Bank Statement Reconciliation Software with Automatic Matching
Add Statement Entry
Structured Transaction Records
WhiteBooks allows finance teams to record every line from the organization's official bank statement as a structured entry — capturing the Bank Name, Transaction Narration, Cheque or Reference Number, Value Date, and Transaction Amount for each statement line.
Bank & Transaction Details
Every bank statement entry records the originating bank's identity and the transaction narration exactly as it appears on the official statement — creating a verbatim reference for direct comparison with the source document during reconciliation.
Reference Details
The cheque number or external reference number associated with each bank transaction is captured and stored against the entry — enabling accurate cross-referencing and matching with the corresponding internal payment, receipt, or contra records in WhiteBooks.
Value Date per Transaction
Each statement line is recorded against its value date — the actual date on which the transaction was credited or debited in the bank account — ensuring correct period-wise attribution for accurate balance verification and chronological reconciliation.
Statement Register
Detailed Bank Statement Register
WhiteBooks presents all bank statement lines in a structured register — including Bank Name, Date, Narration, Cheque/Reference Number, Value Date, Amount, Linked To status, Remaining Amount, and Notes. This complete visibility lets finance teams track reconciliation, spot unmatched entries, and monitor partially linked transactions from a single register.
Statement at a Glance
Each bank statement line is displayed with Bank Name, Date, Narration, Cheque/Reference Number, Value Date, and Amount — giving finance teams a clear, structured view of all transactions that need reconciliation against internal WhiteBooks records.
Linked To Status Tracking
The Linked To column indicates which internal WhiteBooks record — whether a payment, receipt, contra, or journal entry — has been matched to each bank statement line. This provides instant visibility into which entries are fully reconciled, partially linked, or still unlinked.
Remaining Amount per Entry
The Remaining Amount column shows the portion of the transaction value that is yet to be matched to any internal record. This helps reconciliation teams quickly identify partially matched entries and track outstanding balances requiring further linkage.
Bank Statements
Instant Reconciliation Overview
WhiteBooks shows Total Matched and Not Matched amounts right on the Bank Statements screen. Finance managers get an instant view of reconciled vs. outstanding transactions, enabling quick, informed decisions without separate reports.
Total Matched Amount
Aggregates the total value of all bank statement entries successfully linked to corresponding internal WhiteBooks records — giving the reconciliation team a confirmed, quantified figure of fully accounted bank activity within the period.
Outstanding Amount
Displays the total value of all bank statement entries not yet linked to any internal record — giving finance managers a precise, real-time measure of outstanding, unreconciled bank activity that requires investigation or corrective accounting action.
Reconciliation by Period
Matched vs. Not Matched totals give an instant view of reconciliation progress for the period. Finance teams can quickly spot high unmatched balances and prioritize outstanding entries before month-end.
Reconcile Now
One-Click Statement Matching
The ‘Reconcile Now’ action in WhiteBooks matches bank statement entries with internal records in one click. Unreconciled lines are shown alongside candidate transactions for easy review, confirmation, and linking.
Statement at a Glance
The Reconcile Now action triggers the bank reconciliation process for the selected period in a single click, presenting all unmatched statement entries alongside potential internal matches for systematic processing.
Transaction Matching
Unmatched statement entries are displayed with potential internal matches—payments, receipts, or contra entries—based on amount, date, and reference similarity. Finance teams can quickly review, verify, and confirm each match with full context.
Link & Update Balance
When a bank statement entry is confirmed as matched in WhiteBooks: the linkage is recorded, the remaining amount drops to zero, the value moves from Not Matched to Matched total, and the reconciliation is instantly reflected in the period report.
Statement Narration
Contextual Notes per Entry
WhiteBooks captures the original bank transaction narration and provides a Notes field for internal context. Finance teams can add remarks or investigation details, ensuring every entry has full context for review, audit, and reconciliation—without referring to the physical statement.
Preserve Bank Narration
The transaction narration from the official bank statement is captured and stored exactly as provided — preserving the bank’s description as the primary reference for matching statement lines against internal payments, receipts, and contra entries.
Reconciliation Notes
Finance teams can attach internal notes to any bank statement entry—recording investigations, clarifications, or reconciliation decisions. This builds a clear audit trail for management, auditors, and tax authorities.
Narration-Based Matching
Statement entries can be searched by narration, allowing teams to group similar transactions, find all entries from a specific counterparty, or locate a line using keywords—without needing the exact date or amount.
Statement Date Range
Period Statement Overview
WhiteBooks scopes the entire Bank Statements workspace to a specific month — ensuring all statement entries, matched totals, unmatched balances, and reconciliation statuses displayed are strictly relevant to the selected period.
Select Statement by Month
The workspace displays only the statement entries corresponding to the selected calendar month — preventing cross-period transactions from appearing in the active reconciliation view.
Balance Alignment
Month-wise scoping ensures entries align with the period’s opening and closing balances. Finance teams can quickly verify that the reconciled closing balance matches the bank’s official statement.
Review Past Statements
Finance teams can access any historical month to review past statement entries, verify reconciliations, investigate unreconciled items, and ensure previous matches remain accurate despite subsequent transactions.
Reference Matching
Precise Matching via Reference
WhiteBooks uses the cheque number or external reference number captured against every bank statement entry as the primary matching key for linking statement lines to the corresponding internal payment and receipt records.
Cheque Number Linking
Bank statement entries with a cheque number are matched directly to the corresponding internal payment in WhiteBooks. This creates a verifiable, document-backed link between the bank’s cleared cheque and the organization’s payment record.
Reference-Based Matching
The external reference number serves as the primary identifier for locating the corresponding internal record — enabling unambiguous reconciliation even when multiple transactions share the same amount or date.
Unmatched Ref Review
Bank statement entries with reference numbers that don’t match internal records are flagged as unmatched. Finance teams can quickly investigate unrecorded transactions, bank charges, interest credits, or payments needing new entries.
Statement Import
Automated Statement Import
WhiteBooks allows bulk import of bank statements, letting finance teams upload the full period in one go. This eliminates manual entry errors and automatically populates the register for immediate reconciliation.
Automatic Register Population
Every uploaded bank statement line — including bank name, narration, reference number, value date, and amount — is automatically added to the WhiteBooks register, organized chronologically for immediate use in reconciliation workflows.
Import Accuracy Verification
After import, WhiteBooks shows a verification summary with total entries and aggregate value. Finance teams can quickly confirm alignment with the official bank statement and ensure no lines are missed or duplicated.
Time-Saving & Error Reduction
Uploading the entire statement in one operation replaces manual transcription, significantly reducing entry errors and accelerating preparation for bank reconciliation against payments, receipts, and contra entries.
Export
Export Statement Data
WhiteBooks shows all bank statement entries in a period-scoped register with key details—bank, narration, reference, date, amount, linked record, remaining balance, and notes—giving finance teams full visibility of reconciled, unmatched, and partial transactions.
Comprehensive Transaction Visibility
Every statement line is structured and clearly presented, providing a complete, auditable view of banking activity for the active period.
Linked Record Tracking
Instantly see which internal payments, receipts, or contra entries have been matched to each statement line.
Remaining Amount Monitoring
Quickly identify partially reconciled or unmatched entries, supporting accurate and efficient reconciliation workflows.