Bank Reconciliation
Bank reconciliation lets you match your bank statement transactions against the entries recorded in AcuSheet. The screen shows both sides in a side-by-side view with a live difference figure so you always know how close you are to balancing.
Before You Start
Only accounts set up as Cash and Bank type in your Chart of Accounts can be reconciled. The opening balance for each period is calculated automatically from your account history — you do not enter it manually.
Creating a Reconciliation
- Go to Bank Reconciliations
- Click New Reconciliation
- Fill in the form:
| Field | Description |
|---|---|
| Account | The bank or cash account you are reconciling |
| Statement From | Start date of your bank statement period |
| Statement To | End date of your bank statement |
| Closing Balance | The closing balance shown on your bank statement |
| Notes | Optional internal note |
- Click Save
AcuSheet calculates the Opening Balance automatically. Periods cannot overlap — if an existing reconciliation already covers some of those dates for the same account, you will see a validation error.
The Reconciliation Screen
The screen has two panels:
Bank Statement Lines (left) — transactions from your bank statement, either imported or entered manually.
Book Transactions (right) — transactions recorded in AcuSheet for that account and period that have not yet been reconciled.
At the top, three figures update in real time:
- Opening Balance — calculated from account history
- Statement Balance — the closing balance you entered
- Difference — turns green when it reaches zero (or within 0.01)
Adding Bank Statement Lines
Import a CSV File
- Click Import CSV
- Upload your bank export file
- AcuSheet detects the column headers and maps them automatically to Date, Description, Amount, and Reference
- Review and adjust the mapping if needed
- Optionally save the mapping as a profile so future imports from the same bank pre-fill it
- Click Import
Once imported, AcuSheet runs auto-matching in the background. Lines with an amount match and a date within 5 days of a book transaction are matched automatically.
The CSV importer supports both single-amount columns and separate debit/credit columns. Accepted date formats include DD/MM/YYYY, MM/DD/YYYY, YYYY-MM-DD, and others.
Add Lines Manually
- Click Add Line Manually
- Enter the date, description, reference (optional), and amount
- Use a positive amount for deposits and credits, negative for withdrawals and debits
Matching Transactions
Auto-Matching
After an import, AcuSheet attempts to match each statement line to a book transaction automatically. Lines matched automatically appear with a green Matched badge. The page updates in real time as matching runs.
Manual Matching
For any unmatched line:
- Click the statement line in the left panel to select it
- The right panel highlights book transactions with matching or near-matching amounts in blue, and amount mismatches in orange
- Click the book transaction you want to link it to
- If the amounts differ, AcuSheet asks you to confirm before creating the match
Unmatching
Click the X button on any matched line to remove the match and return it to unmatched status.
Statement Line Statuses
| Status | Meaning |
|---|---|
| Unmatched | No book transaction linked yet |
| Matched | Linked to a book transaction (shown in green) |
| Excluded | Set aside and not counted in the balance calculation |
Handling Unmatched Lines
If a statement line has no matching book transaction:
Create a new transaction — click the + Create button on the unmatched line and choose the transaction type. Options depend on whether the amount is positive or negative:
- Positive amounts: Received Payment, Receipt Voucher, Journal Entry
- Negative amounts: Expense, Made Payment, Payment Voucher, Journal Entry
Exclude the line — if a line should not affect the reconciliation (for example, a duplicate or a transfer already handled elsewhere), you can exclude it. Excluded lines are grayed out, ignored in the balance calculation, and remain visible in the downloaded report with an optional note.
Finishing the Reconciliation
The Finish Reconciliation button is enabled when:
- The Difference figure is zero (or within 0.01)
- All statement lines are either matched or excluded
Click Finish Reconciliation and confirm. AcuSheet will:
- Mark the reconciliation as Completed
- Lock all matched transactions against further changes
- Record who completed it and when
Once completed, the reconciliation is read-only.
Unlocking a Completed Reconciliation
Only admin users can unlock a completed reconciliation. Click Unlock on the completed reconciliation and confirm. This reverts the status to draft and removes the lock from all matched transactions so corrections can be made.
Downloading a Report
Click Download Report at any time (draft or completed) to generate a PDF that includes:
- Account name, statement period, and status
- Opening balance, statement balance, and difference
- All matched statement lines and their linked book transactions
- Any excluded lines with exclusion notes
- Any book transactions that were not matched
- Completion details if the reconciliation is finished
Frequently Asked Questions
Which accounts can be reconciled?
Only Cash and Bank type accounts set up in your Chart of Accounts.
Can I have two open reconciliations for the same account?
No. Date periods cannot overlap for the same account. Finish or delete the existing one before creating a new reconciliation that covers any of the same dates.
My bank statement has separate debit and credit columns. Does the import support that?
Yes. During the CSV import step, map the debit and credit columns separately. AcuSheet combines them into a single signed amount automatically.
Can I edit a statement line after importing?
Statement lines cannot be edited after import. You can delete a line and re-add it manually, or exclude it if it should not affect the balance.
What does the Difference figure represent?
Difference = Statement Balance minus (Opening Balance plus the sum of all matched transaction amounts). When it reaches zero, your books match the bank statement.
What happens to transactions once I finish a reconciliation?
Matched transactions are stamped with the reconciliation date and locked. They show as reconciled in the Account Transactions report.
Can I delete a completed reconciliation?
Only draft reconciliations can be deleted. To remove a completed reconciliation, an admin must unlock it first, then delete it.
Was this article helpful?
Your feedback helps us improve.