Key highlights:
- An account reconciliation compares general ledger (GL) data to other documents and records.
- The reconciled general ledger account balances are used to generate the financial statements.
- Bank reconciliations are particularly important because the cash account typically has many transactions. Cash accounts have a higher risk of error or fraud.
What is account reconciliation?
An account reconciliation compares details in the GL accounts, including journal entries and sub ledgers, to other documents and records.
The general ledger includes all accounts and the transactions for each account. The reconciled general ledger account balances generate the balance sheet, income statement, and cash flow statement.
The reconciliation compares general ledger data to receipts, vendor invoices, credit card statements, and other documentation. Any differences should be investigated and recorded in an account reconciliation template.
A reconciliation generally is complete when the accounting team has identified all differences between the general ledger and the supporting documentation. Businesses should reconcile each account during month-end close and as a part of the year-end close.
Companies reconcile both permanent accounts and temporary accounts:
- Permanent accounts: Balance sheet accounts, including asset, liability, and equity accounts, are defined as permanent accounts. The ending balance for the month is also the beginning balance for the next month. The same process applies to year-end balances.
- Temporary accounts: Income statement accounts (revenue and expense accounts) are temporary accounts. At the end of each month and year, income statement balances are adjusted to zero. The net effect of all income statement activity is posted as net income (or a net loss).
When a business owner reviews the account balances on the first day of a new month, all income statement balances have a zero balance.
Account reconciliation and single-entry accounting
Every business should use double-entry accounting to record transactions. Generally Accepted Accounting Principles (GAAP) require companies to use the double-entry method. Single-entry accounting cannot be used to produce the financial statements.
Double-entry accounting entries
To illustrate, assume that a business owes employees $5,000 in wages for the last month of December 2024 and that the wages are paid on January 5, 2025.
Businesses should post at least one debit and one credit for each transaction, and the total dollar amount of debits and credits should be equal.
Accountants should use the accrual basis of accounting which records revenue when earned and expenses when incurred. The accrual basis does not record revenue and expenses based on cash movements.
On December 31, 2024, the company debited wage expenses and credits accrued payroll for $5,000. On January 5th, accrued payroll is debited (reduced) and cash is credited for $5,000. The expense is recorded in 2024.
Single-entry accounting entries
This method posts a single debit or credit for each transaction. When cash is received, revenue is increased with a credit entry. Cash payments generate a debit entry for an expense.
No entry is recorded on December 31, 2024. On January 5th, wage expense is debited for $5,000 and cash is reduced by $5,000. The expense was incurred in 2024, but this method records the expense in 2025.
Many businesses do not use single-entry accounting because the system does not allow the company to produce the balance sheet and other financial reports.
Account reconciliation vs. bank reconciliation
As mentioned above, businesses should reconcile each account in the general ledger. A bank reconciliation is performed on each cash account. The book balance (balance in the accounting records) is compared to the bank balance (balance per the bank statement), and all reconciliation discrepancies are investigated.
Bank reconciliations are particularly important because the cash account typically has a large number of transactions and cash accounts have a higher risk of error or fraud.
Benefits of account reconciliation
Owners that perform monthly account reconciliations generally have reliable accounting data to make informed decisions. Here are some additional benefits for businesses that perform reconciliations on each account.
Accurate financial records
The accounting staff can generate accurate financial statements when each general ledger account is reconciled.
A CPA firm’s audit opinion requires the auditor to assess the effectiveness of the company’s internal controls over financial reporting. Account reconciliations are one type of internal control that allows the business to produce accurate financial statements.
If you operate a public company or plan on issuing common stock in the future, you’ll need strong internal controls including an audit trail for each account reconciliation.
Better historical accuracy
Company managers, investors, and other stakeholders analyze the financial statements. If the business consistently reconciles all accounts, the general ledger generally can be used to produce accurate financial statements each year.
Fraud detection
Timely account reconciliations help to minimize the risk of fraud. Fraud is defined as willful intent to deceive, and individuals inside and outside the business may attempt to steal cash and other assets.
One common type of fraud is a fictitious payee. An individual attempts to convince the business to pay an invoice to a company name similar to a current vendor.
Assume that the business frequently orders supplies from “Midwest Lumber Supply.” An individual sends a fictitious invoice from “Midwest Lumber Suppliers.”
If the cash account is reconciled each month, the accountant may notice the fictitious invoice and halt any future payments to the payee.
Uncover surprises
As a company’s transaction volume increases, so does the risk of errors and omissions. Account reconciliations can uncover several issues:
Incorrect account used
Over time, a business may operate with dozens or hundreds of general ledger accounts. More accounts increase the risk of error, particularly when account numbers are assigned to a specific department or profit center.
For example, the Midwest division purchases a piece of equipment, and the fixed asset should be posted to account #4150-10. The bookkeeper makes an input error and posts the fixed asset to #4150-20.
Wasteful spending
Companies need to ensure that each monthly subscription payment is for a product or service currently used by the business.
For example, the bookkeeper reconciles the bank account and notes a $150 monthly subscription payment for software that is no longer used. The subscription can then be canceled.
Avoiding fees and penalties
By reconciling the bank account, the business can avoid overdraft fees on the account. The credit card statement transactions are reconciled with the accounting records so that payments are submitted on time, avoiding late fees.
Risk management
Account reconciliations can uncover excessive spending in a particular area. If the business doesn’t control spending, they may not have sufficient cash flow to pay all expenses and operate at a loss.
Assume that a salesperson’s monthly travel budget is $4,500 and all expenses are paid using a company credit card.
The credit card statement is reconciled with the travel expense account, and the bookkeeper notices that the salesperson spent $8,000 during the month. The bookkeeper provides the detail to the VP of Sales, so that the spending can be investigated.
Informed decision-making
Managers need accurate financial data to make decisions regarding business growth, product pricing, and capital expenditures.
Building stakeholder trust
Stakeholders are interested in businesses that have strong internal controls and produce reliable financial statements. Well-managed accounting departments build stakeholder trust.
How to perform an account reconciliation
The steps to complete an account reconciliation can be generalized and applied to most account balances.
Two methods of reconciling accounts
There are two methods a business can use to complete an account reconciliation.
Document review
General ledger transactions are compared with receipts, vendor invoices, bank statements, credit card statements, and other documents. Accounts with large dollar balances and frequent financial transactions should be reconciled using documentation.
Analytical review
The accountant performs an analytical review by comparing account activity in past periods to the current period. This method may be suitable for small account balances or accounts with just a few transactions during the period.
Say, for example, that the office supply expenses account averages $200 in expenses per month. The bookkeeper is working on account reconciliations for March.
If March office supply expenses total $215, the business may rely on the analytical review and not use documentation. However, if office supply spending totals $700, the bookkeeper may review documents to determine why March spending was much higher than normal.
A document-based review provides more reliable and precise information than a strictly analytical review.
The steps of the account reconciliation process
Use these steps to complete a document-based account reconciliation. To illustrate, assume that a sporting goods retailer is reconciling the inventory account for baseball gloves as of July 31, 2024.
Verify the beginning balance for the period
Confirm that the July 1st balance agrees with the June 30th account balance. Inventory is a permanent account, and the account balance should carry over from one period to the next.
Gather all documentation
Inventory purchases are documented using vendor invoices, shipping receipts, and bank account documentation showing that the vendor was paid. Inventory sales are documented with client invoices and customer payment information from the bank reconciliation.
Compare each general ledger account to the documentation
Review each July transaction in the general ledger, and compare the transaction detail to the supporting documentation. If inventory was increased by $3,000 on July 17th, the dollar amount should be supported by a vendor invoice, a shipping receipt, and a vendor payment of $3,000.
Investigate exceptions
If any general ledger entries differ from the documentation, investigate the differences. Assume that the $3,000 July 17th inventory purchase in the general ledger does not match the $3,500 vendor invoice.
The accountant determined that $500 in baseball gloves were defective and returned to the vendor. Documentation of the returned gloves should be added to the files for the July reconciliation.
Post adjusting entries
Some reconciliation discrepancies may require the accountant to post an adjusting entry to the general ledger.
Retain documents
File all documents related to each account reconciliation. Explain any differences between the documentation and the general ledger, and how the issue was resolved.
What causes discrepancies?
A general ledger transaction may differ from the documentation, and there are several reasons why these differences can occur.
Timing differences
The accrual basis of accounting requires a business to record adjusting entries due to the timing of a revenue or expense transaction. The end-of-year payroll expense issue above is an example. An expense entry is posted in 2024, and the payroll is not paid in cash until early January 2025.
Bank interest is another good example. A company may not post an entry to record July interest earned on a bank account until the July bank statement is received in early August.
Missing transactions or other data
Supporting documents are required before many transactions are posted to the general ledger. If a salesperson does not provide credit card receipts for business travel, the bookkeeper may not post expense entries until the credit card statement is received.
Duplicate transactions, coding errors
Human error can generate duplicate entries or coding errors, and the risk increases as the company scales. Growing businesses may have multiple transactions with the same vendor each month, and the vendor invoices may be very similar.
To explain, assume that a furniture manufacturer places 15 orders with Premier Lumber during June. The type of lumber, amounts, and other details are very similar. The bookkeeper may post a duplicate transaction or key in the wrong dollar amount due to the volume of journal entries.
Fraud
A fictitious payee attempts to mislead the business into paying a fake invoice. If a fictitious invoice is paid, the general ledger entry for the transaction is not supported by documentation proving the purchase. This situation creates a reconciling item.
Types of accounting reconciliations
The goal of performing account reconciliations is to confirm the balance in each general ledger account. If every account balance is reconciled, the general ledger is reconciled and can be used to create the financial statements.
Here are the most common types of account reconciliations:
Bank reconciliation
This reconciliation compares the cash account balance to the bank statement balance and other documents. Reconciling items include outstanding checks, deposits in transit, bank fees, and interest earned.
Accounts receivable reconciliation
Customer invoices provide documentation for increases to the accounts receivable balance. Bookkeepers can verify decreases in accounts receivable by confirming customer payments.
Accountants can also perform analysis to evaluate the accounts receivable balance. If sales are increasing rapidly, the business may notice a similar percentage increase in accounts receivable.
Accounts payable reconciliation
When a business purchases goods and services on credit the accounts payable balance increases. Bookkeepers can confirm purchases by reviewing vendor invoices for asset purchases. Company payments to vendors reduce the accounts payable balance.
Intercompany reconciliation
When a parent company does business with a subsidiary the activity is considered an intercompany transaction.
Assume for example that a subsidiary sells a price of equipment to the parent company for $50,000. Here are some of the accounting issues related to the transaction:
- Sale: The subsidiary records a sale, removes the equipment from the balance sheet, and increases cash by $50,000.
- Purchase: The parent company increases the equipment asset account and reduces cash by $50,000.
The seller’s gain or loss should be eliminated when the parent and subsidiary companies are posted in a consolidation. The seller’s cost basis also becomes the buyer’s cost basis. All of this activity should be reconciled.
Inventory reconciliation
Inventory is often one of the largest asset account balances on the balance sheet. Businesses perform a physical inventory count and compare the items counted in inventory to the detailed inventory list in the general ledger.
Differences between the inventory count and the general ledger are investigated and documented.
Fixed assets reconciliation
Asset purchases are confirmed by reviewing vendor invoices. When an asset is disposed of, a bookkeeper can review the sales agreement and cash deposits.
Tax reconciliation
An accountant can recompute the tax liability using the tax rate and other sets of records. Here are two examples:
- Sales tax: The dollar amount can be recomputed using total sales for the period and the tax rate.
- Business income tax: Multiply net income by the business tax rate. Companies may file federal, state, and local income tax returns.
Companies post deferred tax asset or liability balances due to differences in depreciation and other accounts. Businesses also pay payroll taxes and property taxes.
Credit card and debit card reconciliation
Businesses often issue debit and credit cards to employees for corporate travel and other purchases. Each time a card is used, the cardholder should provide a receipt to the accounting department.
Companies perform debit card transaction matching using the bank statement and credit card activity is compared to credit card statement. Accounting software can automate the process.
Digital wallet reconciliation
If your business uses digital wallets such as Apple Pay or PayPal, you should reconcile each payment and deposit with the related bank account. The reconciliation process is similar to a credit card reconciliation.
Global currencies reconciliation
Companies that do business in multiple currencies reconcile foreign currency transactions.
To illustrate, assume that a U.S.-based business purchases raw materials from Germany. The company converts U.S. dollars into Euros and completes the purchase. An accountant reviews the bank activity, and the exchange rate for the transactions, and confirms receipt of the raw materials.
Real-time automatic payment reconciliation
Real-time payments (RTPs) are processed immediately, and the system operates continuously 24 hours each day. Unlike ACH transactions and other payments transfers between banks occur in real time.
Accountants reconcile each payment and deposit using bank statements and other records.
Best practices for account reconciliation
Successful businesses apply these best practices to the account reconciliation process:
Reconcile your accounts promptly
Every account is reconciled at the end of each month and year. The accounting department should minimize the days required to complete the reconciliation process. A faster closing process allows the staff to identify reconciling items quickly, and reduce the risk of errors and fraud.
Create reconciliation procedures
A business should have a written procedures manual for each routine task, including account reconciliations. The manual documents how each task is performed, who completes the task, and how often the work is completed.
Companies should use segregation of duties for account reconciliations. If a bookkeeper performs the reconciliations, the supervising accountant reviews and approves the work. No one in the accounting department can have check signing privileges.
A clear set of procedures improves communication and ensures that all reconciliations are completed on schedule.
Document and keep records
Several stakeholders need access to the records used to perform reconciliations. When an audit is conducted, the CPA firm will test the company’s internal controls by reviewing account reconciliations and documentation.
If the accounting department determines that the general ledger requires a prior period adjustment to correct an error, the prior year’s account reconciliation data will be reviewed.
Investigate reconciliation exceptions quickly
As mentioned above, the accounting staff should investigate differences between the general ledger and supporting documents as soon as possible.
How does account reconciliation software work?
Account reconciliation software automates many tasks required to reconcile all general ledger accounts. Businesses use software to complete reconciliations in less time and with fewer errors. Here are some features that you may find in account reconciliation software:
Automated document capture
Receipts, invoices, and other documents are scanned and uploaded into the software. Reviewers can scan documentation as they review a reconciliation.
Reconciliation templates
Users can create an automated template for each account reconciliation. An accounts payable template, for example, is formatted to include each vendor’s name, address, a description of the items purchased, and the dollar amount.
Comparing data
The software can perform an automated comparison of general ledger data with bank statements, credit card statements, and other documents. This eliminates time-consuming manual review and sharply reduces the risk of errors.
Account reconciliation software can also be integrated with your ERP or accounting software.
Tracking and reminder notifications
It is difficult to track the status of each required account reconciliation using manual data entry in a spreadsheet. Software can track the status of each account reconciliation, and provide automated alerts to complete a reconciliation or to review.
Segregation of duties
Businesses can set up automated controls that dictate who can access a particular account reconciliation, and who is responsible for the review.
Document storage and access
The reconciliations and supporting documents are stored on the cloud, and managers determine who can access the data. Automation makes it much easier to search and find accounting data. An outside accounting firm can get a read-only version of the information to perform an audit.
How often should a business reconcile its accounts?
At a minimum, every account in the general ledger should be reconciled at the end of each month and year.
Owners should consider reconciling cash multiple times each month as the business scales. Cash is a high-volume account with a higher risk of errors or fraud.
What are the steps in account reconciliation?
Here are the steps to perform an account reconciliation:
- Verify the beginning balance for the period
- Gather all documentation
- Compare each general ledger account to the documentation
- Investigate exceptions
- Post adjusting entries
- Retain documents
Why should businesses do account reconciliation?
Businesses perform account reconciliations to verify that all general ledger account balances are correct. The general ledger balances are used to generate the financial statements. Companies can also uncover errors, wasteful spending, and fraudulent transactions.
Wrap-Up: All about account reconciliations
An account reconciliation is a key internal control to generate accurate financial statements. Successfully generating accounting information necessitates clean data; however, obtaining this level of data can require numerous hours. Leverage technology to save time.
Manage all of your spending and cash using Rho’s automated platform. Rho is a business banking platform that offers the tools companies need to manage their cash and grow their businesses.
Backed by 24/7 customer support, Rho offers business checking and savings accountsand enterprise-grade spend management – accounts payable, corporate cards, and expense management.
Book a demo today!
Any third-party links are provided for informational purposes only. The third-party sites and content are not endorsed or controlled by Rho.
Rho is a fintech company, not a bank. Checking and card services provided by Webster Bank, N.A., member FDIC; savings account services provided by American Deposit Management Co. and its partner banks.
Note: This content is for informational purposes only. It doesn't necessarily reflect the views of Rho and should not be construed as legal, tax, benefits, financial, accounting, or other advice. If you need specific advice for your business, please consult with an expert, as rules and regulations change regularly.