Account reconciliation is the process of comparing two sets of financial records to confirm that they agree, and investigating and fixing any differences. For example, you might match your general ledger cash balance with the bank statement, or your accounts receivable (AR) control account with the AR subledger. This guide explains why account reconciliation matters, the main types, a step-by-step process with a worked example, common discrepancies, and how account reconciliation software compares with spreadsheets.
Table of Contents
Toggle- What is account reconciliation?
- Why account reconciliation matters
- Types of account reconciliation
- The account reconciliation process, step by step
- Worked example: a simple bank reconciliation
- Common discrepancies and how to resolve them
- Spreadsheets vs. account reconciliation software
- Automating account reconciliation
- Account reconciliation best practices
- Frequently Asked Questions
- Take the next step
What is account reconciliation?
Account reconciliation is the control that proves a balance in your books is correct. An accountant compares a general ledger balance at period end with independent evidence, such as a statement, subledger report or supporting schedule. Any difference is explained, documented and, where needed, corrected with an adjusting entry.
The process is critical for accountants, accounting managers, controllers and auditors. It is a core step in the month-end close and the foundation for accurate financial statements and compliance with regulations.
Why account reconciliation matters
- Accuracy: Reconciliations catch posting errors, duplicate entries, missing transactions and timing differences before they reach the financial statements.
- Fraud detection: Comparing books with independent sources such as bank statements helps reveal unauthorized payments, altered checks or unexplained transfers.
- Audit readiness: Documented, reviewed reconciliations give auditors the evidence they need and reduce back-and-forth during the audit.
- Close speed: When reconciliations are standardized and done consistently, fewer surprises appear at period end and late adjustments become less frequent.
Types of account reconciliation
| Type | What is compared | Typical purpose |
|---|---|---|
| Bank reconciliation | GL cash account vs. bank statement | Confirm cash balance; find outstanding checks, deposits in transit, fees and errors. |
| Credit card reconciliation | Card statement vs. recorded expenses and receipts | Make sure every charge is recorded, coded and supported. |
| Intercompany reconciliation | Balances between related entities | Confirm that receivables and payables between subsidiaries match before consolidation. |
| Accounts receivable reconciliation | AR subledger and aging vs. GL control account | Confirm customer balances and identify unapplied cash. |
| Accounts payable reconciliation | AP subledger vs. GL control account | Confirm amounts owed to vendors and spot unrecorded liabilities. |
| Balance sheet / GL reconciliation | Any balance sheet account vs. supporting schedule | Support prepaids, accruals, fixed assets, inventory and other accounts. |
| Vendor and customer statement reconciliation | Third-party statements vs. your records | Resolve disputes, missing invoices and unapplied payments with trading partners. |
The account reconciliation process, step by step
- Define scope and ownership. List the accounts to reconcile, how often, and who prepares and reviews each one.
- Gather the balances. Pull the GL balance at period end and the independent source: statement, subledger report or schedule.
- Compare and match. Match transactions on both sides by amount, date and reference.
- Identify differences. List unmatched items and classify them as timing differences, errors or items that need investigation.
- Investigate and resolve. Research each item, contact the owner where needed, and decide whether an adjustment is required.
- Record adjustments. Post journal entries for errors or items not yet recorded in the books.
- Document. Attach supporting evidence and explain any remaining reconciling items.
- Review and approve. A second person reviews the reconciliation, signs off and the result is stored for audit.
Worked example: a simple bank reconciliation
The following is a hypothetical example with illustrative numbers, not data from any real company.
At month end, the bank statement shows a balance of $48,200. The company’s general ledger cash account shows $49,535. The accountant finds these reconciling items:
- A deposit of $4,100 recorded on the last day of the month that the bank has not yet processed (deposit in transit).
- Two checks issued to vendors for $1,200 and $2,300 that have not cleared the bank (outstanding checks).
- A $35 bank service fee on the statement that was not recorded in the books.
- A $700 customer check returned for insufficient funds that was not recorded in the books.
| Bank side | Amount | Book side | Amount |
|---|---|---|---|
| Balance per bank statement | $48,200 | Balance per general ledger | $49,535 |
| Add: deposit in transit | $4,100 | Less: bank service fee | ($35) |
| Less: outstanding checks | ($3,500) | Less: returned customer check | ($700) |
| Adjusted bank balance | $48,800 | Adjusted book balance | $48,800 |
Both sides now agree. The deposit in transit and outstanding checks are timing differences that will clear next month, so no entry is needed. The bank fee and returned check require journal entries in the books, and the returned check also goes back to AR for collection.
Common discrepancies and how to resolve them
- Timing differences: Deposits in transit, outstanding checks and cut-off issues. Document them and confirm they clear in the next period.
- Unrecorded bank activity: Fees, interest, automatic debits and returned items. Record them with a journal entry.
- Data entry errors: Transposed digits, wrong amounts or wrong accounts. Correct the original entry and check for similar errors.
- Unapplied cash and credits: Customer payments or vendor credits not matched to invoices. Apply them in the subledger.
- Intercompany mismatches: One entity recorded a charge the other did not. Agree on the amount and record the missing side.
- Unexplained differences: Escalate items that cannot be explained; they may indicate a control issue or fraud.
Spreadsheets vs. account reconciliation software
For many accounting teams, reconciliation in spreadsheets is a frustrating, manual process. Using spreadsheets or relying only on ERP systems for reconciliation often creates new problems:
- Chasing down information: Teams spend time tracking down discrepancies and confirming data with multiple owners.
- Audit challenges: Gathering and organizing documentation for audits becomes overwhelming.
- Fragmented communication: Discussions about close activities happen in email or Excel comments, and information gets lost.
- Lack of scalability: As organizations grow, spreadsheet-based processes fail to keep up.
- Errors and limited accuracy: Manual data entry and broken formulas reduce confidence in your financial reports.
Account reconciliation software addresses these issues with standard templates, automated matching, central status tracking and an audit trail. Ask yourself:
- Does the month-end close take longer than you’d like?
- Is the process chaotic or overly manual?
- Are you using spreadsheets to track reconciliation tasks?
- Do late adjustments happen too often?
- Are you struggling to prepare for audits?
If you said “yes” to any of these, it is time to rethink how you handle reconciliation.
Automating account reconciliation
Tools like Prophix, Oracle EPM and NetSuite can automate much of the work. Each takes a different approach.
Oracle Account Reconciliation (Oracle EPM)
Account reconciliation is part of Oracle Fusion Cloud EPM, alongside planning, financial consolidation and close, and tax reporting. Oracle describes a Reconciliation Agent that automates account reconciliations, runs them continuously with anomaly detection so issues surface before period end, and assigns reconciliation tasks based on risk profiles, policy thresholds and team capacity. Learn more on our Oracle EPM page.
NetSuite
NetSuite’s accounting features include account reconciliation for accounts payable and receivable, bank, credit card, prepaid, inventory, accruals, fixed assets, intercompany and other balance sheet accounts. Teams can view each account’s status with balance comparisons, preparers, reviewers and sign-off dates. NetSuite’s close management automates tasks such as journal entries, reconciliations, variance analysis and intercompany transactions.
Prophix One Account Reconciliation
Prophix One Account Reconciliation tracks reconciliation progress by account, period and entity, replaces scattered Excel files with centralized templates, and supports roll-forward reconciliations. It uses AI to match high-volume transactions for bank and subledger reconciliations, suggesting matches for review so the team can focus on exceptions. It also assembles close packages with supporting documentation and sign-offs, with an audit trail of every change.
Account reconciliation best practices
- Reconcile on a schedule. Set frequencies by risk: high-volume or high-risk accounts monthly or more often, low-activity accounts less often.
- Standardize templates. Use the same format and required fields for each account type.
- Separate duties. The person who prepares a reconciliation should not be the one who approves it.
- Set materiality thresholds. Define when a difference must be investigated or escalated.
- Keep evidence with the reconciliation. Store statements and support in one place for reviewers and auditors.
- Reconcile continuously where possible. Matching transactions during the month reduces period-end pressure.
Frequently Asked Questions
What is account reconciliation in accounting?
Account reconciliation is the process of comparing a general ledger balance with an independent source, such as a bank statement, subledger or supporting schedule, to confirm the balance is correct. Differences are investigated, explained and corrected with adjusting entries where needed. It is a key control in the month-end close and supports accurate financial statements and audits.
How often should accounts be reconciled?
Most companies reconcile cash, receivables, payables and other key balance sheet accounts every month as part of the close. High-volume accounts such as bank accounts may be reconciled weekly or daily. Lower-risk, low-activity accounts can be reconciled quarterly. The frequency should reflect each account’s risk, volume and materiality.
What is the difference between bank reconciliation and account reconciliation?
Bank reconciliation is one type of account reconciliation. It compares the cash balance in your general ledger with the bank statement. Account reconciliation is the broader practice that covers every balance sheet account, including receivables, payables, prepaids, accruals, fixed assets and intercompany balances, each compared with its own supporting source.
What does account reconciliation software do?
Account reconciliation software centralizes reconciliations in one system. It imports balances from the ERP, matches transactions automatically, flags exceptions, applies standard templates, routes reconciliations for review and approval, and stores supporting documents with an audit trail. This replaces spreadsheets and email and gives controllers real-time visibility into close status.
Can an ERP handle account reconciliation on its own?
Most ERPs include bank reconciliation and some reconciliation features, and some, like NetSuite, cover a wide range of balance sheet accounts. Companies with many entities, high transaction volumes or strict audit requirements often add a dedicated reconciliation or close tool, such as Oracle EPM or Prophix, connected to the ERP.
Take the next step
Ready to see how technology can improve your reconciliation and close processes? Request a consultation to talk to our team about simplifying account reconciliation and your financial close.
Visit our financial management and planning pages to learn more:
