Bank Reconciliation
Bank reconciliation is the process of matching bank transactions with your accounting records. This ensures that your books accurately reflect your bank balance and that no transactions are missing or duplicated.
Versoll Books streamlines this process with automatic categorization and intelligent matching capabilities, reducing reconciliation time by 60-80% compared to manual entry.
Automatic Features
Pre-Filled Transaction Data
Every imported transaction comes pre-filled with intelligent suggestions:
- Document Type: Payment, Receipt, or Journal Entry (based on transaction direction)
- Category: Expense/Income category (based on pattern matching)
- Amount: Automatically filled from bank statement
- Date: Automatically filled from bank statement
- Reference: Transaction reference number (if available)
Confidence Scores: Each categorization shows a confidence score (Low/Medium/High) to help you decide whether to accept or review the suggestion.
Matching Workflow
When you select an unreconciled bank transaction, Versoll Books offers three ways to reconcile it:
1. Match with Existing Voucher
If you have already recorded a Payment, Receipt, or Purchase Invoice in the system, you can match it to the bank transaction.
- The system searches for vouchers with matching amounts and similar dates.
- You can manually search for vouchers if the automatic matching doesn't find the correct one.
- Once matched, the bank transaction is linked to the voucher, and its status changes to 'Reconciled'.
2. Create New Voucher
For transactions not yet recorded (like bank charges or direct deposits), you can create a new voucher directly from the reconciliation screen.
- Select the appropriate Account and Party.
- The system pre-fills the amount and date from the bank transaction.
- Upon saving, a new Payment or Receipt voucher is created and automatically linked to the bank transaction.
Understanding Reconciled Status
A bank transaction is considered 'Reconciled' only when it is linked to a valid accounting voucher. This ensures that every entry in your bank statement has a corresponding entry in your General Ledger.
Reconciliation Reports
After completing reconciliation, you can generate reports to verify your work:
- Bank Reconciliation Statement - Shows the difference between your bank balance and book balance.
- Uncleared Vouchers - Lists vouchers that have been recorded in the books but haven't appeared in the bank statement yet.
- Missing Transactions - Highlights bank transactions that haven't been accounted for in the books.
Regular reconciliation (ideally weekly or monthly) is crucial for maintaining accurate financial records and detecting errors or fraud early.