How to Do a Bank Reconciliation
Accessing Bank Reconciliation Tool
Go to the menu
Select General Ledger
Choose Bank Reconciliation
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
Handling Outstanding Transactions
If there are outstanding transactions from the prior month, enter an un-reconciled start date
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)
Verifying and Saving
Verify all transactions by checking them off
Ignore vouchers that do not impact the verified balance
Save the reconciled transactions
Resolving Differences
If there is a difference, investigate and make necessary adjustments
Ensure the difference is zero before finalizing
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
Additional Actions
Create vouchers if needed to correct account balances
Provide a name for the finalized bank statement (e.g., December 2024)
Accessing Finalized Bank Statement
View an Excel sheet with totals and verified items for deposits and withdrawals
Reviewing Bank Reconciliation
Access finalized bank statements for future reference.
