What is account reconciliation?
Accounts reconciliation is the process of comparing financial records with corresponding records, such as bank statements, supplier accounts or customer accounts, to identify and resolve discrepancies. Regular reconciliation helps businesses maintain accurate financial statements, reduce accounting errors, support tax compliance and avoid issues during audits.
For Indian businesses, reconciliation is also important for Goods and Services Tax (GST) compliance. For example, mismatches between purchase records and suppliers' GST returns can lead to denied input tax credit (ITC) claims, affecting cash flow. Reconciling accounts regularly helps businesses identify such mismatches early and maintain accurate financial records.
What does account reconciliation actually involve?
Reconciliation is not a single task. It is a category of accounting activity that applies to several different record pairs, depending on the type of business and the accounts it maintains.
The most common types are:
- Bank reconciliation: Matching the cash book against the bank statement to identify timing differences, bank charges or missed entries.
- Vendor reconciliation: Comparing your accounts payable ledger with a supplier’s statement to confirm outstanding balances are agreed.
- Customer reconciliation: Checking your accounts receivable records against customer account statements to verify amounts owed.
- GST reconciliation: Matching purchase invoices and ITC claims against GSTR-2B to confirm what the GST portal reflects.
- Inter-company reconciliation: For businesses with multiple entities, ensuring that transactions between group companies cancel out correctly.
Why is account reconciliation important for businesses?
Account reconciliation helps businesses ensure that their financial records accurately reflect actual transactions and balances. By regularly comparing internal records with bank statements, invoices, and other supporting documents, businesses can identify and resolve discrepancies before they affect financial reporting.
It is important because it helps:
- Maintain accurate records: Ensures balances and transactions are recorded correctly.
- Detect errors early: Identifies duplicate entries, missing transactions, incorrect amounts, and posting errors.
- Prevent and detect fraud: Helps uncover unauthorised or unusual transactions.
- Support compliance: Keeps financial records reliable and ready for audits, tax filings, and regulatory requirements.
- Improve financial control: Gives businesses greater confidence in cash balances, receivables, payables, and other accounts.
- Enable better decisions: Reliable financial information helps business owners make informed cash flow and financial decisions.
What documents are required for account reconciliation?
The documents required for account reconciliation depend on the type of account being reconciled. Common records include:
- Bank statements: To compare bank transactions and balances with the books of accounts.
- General ledger: To verify transactions recorded under the relevant accounts.
- Sales and purchase invoices: To validate amounts recorded for customer and supplier transactions.
- Supplier statements: To reconcile outstanding payables and identify missing or incorrect entries.
- Customer statements: To verify receivables, payments received, and outstanding balances.
- Payment and receipt records: To cross-check payments made and amounts received.
- GST records: To reconcile sales, purchases, input tax credit, and GST returns with the books of accounts.
- Credit and debit notes: To account for adjustments, returns, discounts, or corrections.
Why do mismatches happen?
Understanding the cause of a discrepancy is the first step to fixing it. Most mismatches fall into one of a few categories:
|
Cause |
Where it appears |
Example |
|---|---|---|
|
Timing difference |
Bank reconciliation |
Cheque issued but not yet cleared |
|
Missing entry |
Any reconciliation |
Bank charge not recorded in the cash book |
|
Duplicate entry |
Accounts payable or receivable |
Invoice entered twice |
|
Supplier filing gap |
GST reconciliation |
The vendor did not file GSTR-1 on time |
|
Data entry error |
Any reconciliation |
Amount transposed when posting |
How do you carry out accounts reconciliation?
The steps below apply to most reconciliation types. The specific records and systems differ, but the logic is the same.
- Collect both sets of records: Get the internal ledger entry and the external statement for the same period. Make sure both cover the same date range.
- Set the opening balance: Confirm that the closing balance from the previous period matches the opening balance in this period for both records.
- List all transactions: Go through both records and mark off items that appear in both. This is called matching. Any item that appears in one record but not the other is a candidate for investigation.
- Identify discrepancies: For each unmatched item, determine whether it is a timing difference (will resolve itself in the next period), a missing entry (needs to be posted) or an error (needs to be corrected).
- Make adjusting entries: Post any corrections or missing transactions in your accounting records.
- Confirm the closing balance: After adjustments, both records should agree. Document the reconciliation and obtain sign-off.
- File and retain: Keep reconciliation records for at least six years under the Companies Act, 2013 and as required under the Income Tax Act, 1961.
Account reconciliation example: How does it work?
Suppose a business’s cash book shows a bank balance of ₹1,00,000, while its bank statement shows ₹95,000. This creates a difference of ₹5,000.
On investigation, the business finds that bank charges of ₹5,000 were deducted by the bank but had not yet been recorded in the books.
The business records the ₹5,000 bank charge in its accounts. After the adjustment:
Cash book balance: ₹95,000
Bank statement balance: ₹95,000
The balances now match, completing the reconciliation.
How often should businesses perform account reconciliation?
The frequency of account reconciliation depends on the volume of transactions, type of account, and business needs. High-volume accounts generally require more frequent reconciliation.
- Daily: Suitable for businesses with a high volume of bank, payment, or sales transactions.
- Weekly: Useful for regularly monitoring bank accounts, receivables, and payables.
- Monthly: Common for reconciling bank accounts, ledgers, customer and supplier balances, and other financial accounts before month-end reporting.
- Periodic or compliance-based: Tax-related accounts, such as GST, should be reconciled in line with applicable return filing and compliance requirements.
Regular reconciliation helps businesses identify discrepancies early and maintain accurate financial records.
What are the common errors to watch for?
A few error categories recur frequently in business reconciliations.
- Uncleared cheques treated as cleared: A cheque issued but not yet presented to the bank will appear in the cash book as paid, but will not yet appear on the bank statement. These are timing differences, not errors, but they need to be tracked and cleared in the following period.
- Bank charges not posted: Charges deducted directly by the bank will not appear in an internal cash book unless someone records them manually. These are a common source of unexplained differences.
- GST ITC mismatches: If a supplier has not filed GSTR-1, the invoice will not appear in your GSTR-2B even though you have the physical invoice. You cannot claim ITC on that purchase until it appears in GSTR-2B.
- Duplicate payments: In accounts payable reconciliation, posting the same invoice twice will inflate the payable balance. This is easy to miss if purchase volumes are high.
How does account reconciliation help with GST compliance?
Account reconciliation helps businesses compare their purchase records with GST data to ensure that transactions are recorded correctly and identify mismatches before filing returns or claiming Input Tax Credit (ITC).
Regular GST reconciliation helps businesses:
- Identify missing or mismatched invoices between the books and GST records.
- Verify supplier-reported transactions and follow up on discrepancies.
- Support accurate ITC claims by checking eligible purchase invoices against available GST data.
- Reduce reporting errors before filing GST returns.
- Maintain accurate records for compliance and audit purposes.
How can accounting software simplify account reconciliation?
Accounting software can simplify account reconciliation by automating repetitive tasks and making it easier to identify and resolve discrepancies. It can help businesses:
- Match transactions automatically: Compare transactions in the books with bank or other records.
- Identify discrepancies: Highlight unmatched, missing, or incorrectly recorded transactions for review.
- Simplify bank reconciliation: Import bank transactions and match them with accounting entries.
- Support GST reconciliation: Compare GST data with transactions recorded in the books to identify mismatches and support accurate ITC claims.
- Maintain organised records: Keep transactions and supporting financial information in one place for easier tracking and verification.
This reduces manual effort while helping businesses maintain accurate and up-to-date financial records.
Conclusion
Accounts reconciliation helps businesses maintain accurate financial records by identifying errors and discrepancies before they affect GST filings, income tax returns or financial statements. Making reconciliation a regular part of your accounting process can improve financial accuracy, support compliance and reduce the time and cost of correcting errors later. Businesses that rely on manual reconciliation often find the process slow and prone to oversight.
TallyPrime simplifies bank and GST reconciliation, helping businesses reconcile records more efficiently while supporting accurate accounting and compliance.
