Skip to main content

Completing your Bank Reconciliation

Updated over 3 weeks ago

How to Do a Bank Reconciliation

  1. Accessing Bank Reconciliation Tool

    • Go to the menu

    • Select General Ledger

    • Choose Bank Reconciliation

  2. Entering Details

    • Input the date range from the bank statement (e.g., December 1st to December 31st)

    • Select the bank account number from the General Ledger

    • Fill in the bank starting balance

    • Input the bank ending balance

  3. Handling Outstanding Transactions

    • If there are outstanding transactions from the prior month, enter an un-reconciled start date

  4. Reviewing Transactions

    • Click on "Get Transactions" to view a grid of items from the bank statement

    • Filter transactions by type (e.g., sales, AP)

    • Verify transactions by marking them as partially verified (yellow) or fully verified (green)

  5. Verifying and Saving

    • Verify all transactions by checking them off

    • Ignore vouchers that do not impact the verified balance

    • Save the reconciled transactions

  6. Resolving Differences

    • If there is a difference, investigate and make necessary adjustments

    • Ensure the difference is zero before finalizing

  7. Finalizing and Making Adjustments

    • Finalize the reconciliation to close out the month

    • Make adjustments for bank fees by adding them to the operating account and debiting the bank fees account

  8. Additional Actions

    • Create vouchers if needed to correct account balances

    • Provide a name for the finalized bank statement (e.g., December 2024)

  9. Accessing Finalized Bank Statement

    • View an Excel sheet with totals and verified items for deposits and withdrawals

  10. Reviewing Bank Reconciliation

  • Access finalized bank statements for future reference.

Did this answer your question?