Reconcile cash and bank balances
The Bank Reconciliation page matches store cash or bank account activity with your bank statement. This feature helps align bookkeeping cash or bank balances with your statement.
When to use it:
- At the end of each month when you print your bank statement.
- When checking transactions that are still uncredited or outstanding.
Good to know:
- Requires an active Full Accounting Bookkeeping module.
- Cleared status saves automatically when you click the button.
- Cleared Balance must match the Statement Balance you entered.
Before you start
- The Full Accounting Bookkeeping module is active in your store.
- The Set Up Accounting guide has been completed and money pockets are mapped.
- A bank statement or bank activity report for the period is ready.
Steps
-
Go to Accounting → Bookkeeping → Bank Reconciliation
Open the Bank Reconciliation page from the sidebar menu. The screen displays the Reconciliation Settings form.
-
Select an account and enter the statement balance
Select your account in Cash/Bank Account and set As of date. Then enter Statement Balance (Rp) and click Show to load data.
Pick the cash/bank account and date, enter the statement balance, then click Show. -
Click Mark on transactions that have cleared
Find transactions matching your bank statement. Click Mark in the Cleared column. The status saves automatically right away.
Click Mark on transactions that have cleared at the bank -
Use filters and bulk mark buttons
Use Filter to sort by status or money direction. Click Mark displayed: Cleared or Unmark displayed to update multiple rows at once.
-
Ensure the Difference becomes 0
Check the cards above the table: Book Balance, Cleared Balance, Outstanding, and Difference. When Difference reaches 0, Cleared Balance matches Statement Balance. Uncredited transactions remain in the Outstanding card.
-
Click Print / PDF to print the results
Click Print / PDF at the top. You can download or print the reconciliation file as your monthly bookkeeping archive.
What you end up with
You can now match cash and bank activity with bank statements and track outstanding transactions.
If something goes wrong
Cleared Balance differs from Statement Balance
Review the transaction rows marked as Cleared. Ensure no bank statement transactions were missed or marked by mistake.
A bank transaction is missing from the list
Ensure the sale, repair, or expense was entered in Automan. Open Journal Voucher if you need to add bank admin fees.
Save button cannot be found on the screen
This page does not need a Save button. Your reconciliation status saves automatically when you click Mark on any row.
Related tutorials
- Tutorial
Activate the shop accounting module
Guide to activating the accounting module and initial store bookkeeping setup.
- Tutorial
Run the annual store period closing
How to close store financial books at the end of the year.
- Tutorial
Transfer balances between shop cash pockets
Track money transfers between cash drawers and store bank accounts.