Finance & Accounting · Bank Matching
When Your Bank and Accounts Don't Match, Find Out Why
Your bank statement shows money moving. Your books show what was recorded. When the two don't agree, someone has to find the difference. Make that checking process clearer and easier to follow.
ERPNext accounting records and bank transactions, checked through a controlled review process.
Match the Bank Statement With Your Books
A bank statement and accounting record sit side by side. Watch matching amounts connect. Then find the bank charge that appears only on the statement.
Match the Bank Statement With Your Books
Illustrative statement and ledger — no real bank connection, posting or reconciliation. No real transaction is created.
Step 1 of 4 · Two sheets arrive
The bank statement and accounting entries show the same period.
Step 2 of 4 · Match the receipts
Customer receipts line up when the amount, reference and transaction details agree.
Step 3 of 4 · Match the supplier payment
A recorded supplier payment has a matching bank withdrawal.
Step 4 of 4 · Find the difference
A ₹295 bank charge appears in the statement but is not yet recorded in this sample book.
Bank StatementBank statement linesCurrent account · 28–31 Oct 2026
Accounting RecordsChoose a matching accounting recordSubmitted Payment Entries · 28–31 Oct 2026
₹295 bank fee — no matching accounting entry yet
No matching record
No matching voucher in this sample. Confirm the charge before recording it.
Example bank fee expense−₹295Demo line · not posted
Comparison
——
- Amount—
- Direction—
- Reference—
Net movement · 28–31 Oct 2026Story example
- Bank movement
- +₹41,105
- Books movement
- +₹41,400
- Difference
- ₹295 to review
For these four sample lines only — not an account balance.
Try matching: choose a bank line, then the record that agrees with it.
Fictional treatment: ₹295 to a bank charges expense account.
Bank reconciliation is not about forcing two totals to match. It is about explaining every difference.
Why Bank Matching Becomes a Month-End Headache
The problem often begins long before month-end.
Payments are recorded without a clear reference.
Bank charges are missed because they were not in the original invoice.
One receipt is entered twice or allocated to the wrong customer.
The bank statement is imported, but nobody reviews the remaining lines.
Clean references and a regular matching habit make exceptions easier to investigate.
Statement · end of monthExample
- 03 OctReceiptRef: —+₹18,000No reference
- 12 OctBank chargeNot in any invoice−₹118Missed charge
- 19 OctReceipt ×2 in booksUTR-0877+₹9,500Entered twice
- 24–31 Oct11 imported linesNot reviewedLeft waiting
Let Everyday Transactions Create the Right Accounting Records
In ERPNext, supported submitted Sales Invoices, Purchase Invoices and Payment Entries generate the appropriate accounting entries. Your accounts team still needs the correct accounts, taxes, parties and checks. Good setup reduces repeated entry; it does not remove responsibility for review.
A sales order by itself is not an income entry. A draft document normally does not post to the ledger.
Bring Bank Activity Into One Place
Bank transactions can be imported from a statement or synchronized where an appropriate integration is available. The source line and reference help the accounts team search for the matching ERPNext payment or journal entry.
Bank feeds are not universal. Supported file formats, integrations, access and permissions depend on the actual setup.
Imported bank lineFrom statement file · example
Kiran Distributors receipt+₹15,000
- Right amount and direction
- Date and reference
- Correct accounting document
Find What Is Missing Without Creating Duplicates
If a bank charge appears with no accounting entry, the team should identify it, confirm how it should be booked and create the appropriate entry. If a customer deposit appears without a suggested match, check existing payments first. A new voucher should not be created merely because the first search returned nothing.
Bank charge · −₹295
No accounting entry
- Identify the charge
- Confirm how it should be booked
- Create the appropriate entry
Customer deposit · +₹12,000
No suggested match
- Check existing payments first
- Look for a missing reference
- New voucher only if truly missing
Match first. Investigate exceptions. Record missing entries only after review.
Know the Difference Between Two Types of Reconciliation
A customer payment can be recorded in accounts and allocated to an invoice, but still need checking against the bank statement. These are related jobs, not the same job.
Payment reconciliation
Which customer or supplier invoice does this recorded payment belong to?
Payment EntryPE-101Receipt · ₹50,000
Sales InvoiceINV-176Shree Retailers · ₹50,000
Allocation and follow-up: Payment Collection & Customer Outstanding
Bank reconciliation
Does this accounting transaction agree with what the bank statement actually shows?
Payment EntryPE-101Receipt · ₹50,000
Bank statement lineB0128 Oct · +₹50,000 · UTR-1001
Both matter when you want accurate customer balances and reliable bank records.
Make Regular Reconciliation Part of Your Process
YourOrderBook can help map bank accounts, import formats, reference rules, account heads, roles and a sensible review frequency. Start with one bank account and a real sample period, then test exceptions before expanding.
- Check the existing books
- Map bank statement fields
- Review matching rules
- Test missing items
- Train the accounts team
Some matching functions are standard ERPNext. Special bank integrations, unusual statement formats and advanced automation may need additional development.
Connect Bank Matching With the Rest of Finance
Customer collections create payment records. Supplier bills lead to payables and payments. Bank reconciliation helps confirm what cleared at the bank. Use the same financial records instead of running a separate spreadsheet at the end of every month.
- Customer collectionsCreate payment records
- Supplier billsLead to payables and payments
- Bank reconciliationConfirms what cleared at the bank
Does Your Accounts Team Spend Too Long Finding Differences?
We can review a typical bank statement, the related accounting entries and the way your team handles unmatched amounts, then suggest a suitable ERPNext process.