Reconcile cash and bank balances

Web Level Intermediate Role Owner, Admin Module Full Accounting About 8 minutes
Updated

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

  1. Go to Accounting → Bookkeeping → Bank Reconciliation

    Open the Bank Reconciliation page from the sidebar menu. The screen displays the Reconciliation Settings form.

  2. 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.

    Reconciliation Settings form and cash bank balance summary cards
    Pick the cash/bank account and date, enter the statement balance, then click Show.
  3. 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.

    Reconciliation transaction list with Mark buttons and filter options
    Click Mark on transactions that have cleared at the bank
  4. 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.

  5. 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.

  6. 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.