If a reconciliation does not balance, start by verifying the opening balance matches the bank statement and check for deleted or modified transactions from previous periods. Common fixes include re-entering missing transactions, adjusting incorrect amounts to match bank records, and checking for duplicate transactions. As a last resort, undo the previous reconciliation.
For unreconciled transactions, it may be necessary to revisit each step of the reconciliation process. A company may have to pull data again and compare each transaction. If their systems allow it, a business may choose to manually adjust a transaction (or multiple transactions) to rectify the situation.
Several issues can derail your reconciliation process, including unauthorized withdrawals that indicate potential fraud, unrecorded bank fees and service charges, outstanding checks not yet cleared, voided checks accidentally processed, cash-in-transit timing differences, errors in transaction amounts, and bulk ...
And here are some details of the fixing process:
Review saved reconciliations
Make sure reconciled transactions still match your statement. Check all the information. The difference must be zero. If not, unreconcile all transactions and start over.
What are the Common Causes of Unreconciled Differences? Several factors can lead to unreconciled differences: Timing Differences: Transactions recorded in the company's books but not yet reflected in the bank statement, or vice versa. Data Entry Errors: Mistakes in recording amounts, dates, or transaction details.
The best way to handle a discrepancy is to take the time to research it and determine exactly what it is, what account it's for, and the best way to reconcile it. This is what is commonly referred to as adjustments and reclassifications.
Generally speaking, banks have 10 days to complete an investigation into an account error. But it is possible the investigation could take as long as 45 days. You can take a look at your deposit account agreement to find out how long it should take your bank.
Identify the root cause of the discrepancy. Discuss Solutions: Bring the involved parties together to discuss possible solutions. Encourage open communication to explore different viewpoints. Implement a Resolution: Once an agreement is reached, put the solution into action.
The reconciliation system only requires that the ending balance be $0. It will warn you if the starting balance doesn't match but it will not prevent you from completing your reconciliation.
Most accounting errors can be classified as data entry errors, errors of commission, errors of omission and errors in principle. Of the four, errors in principle are the most technical type of error and can cause the resultant financial data to be noncompliant with Generally Accepted Accounting Principles (GAAP).
Top 10 ways to fix an unbalanced balance sheet
When the difference isn't zero, this could be that:
Reconciliation means that both people are willing to make concessions to restore their relationship. If only one side makes concessions, but the other side refuses to move. Then reconciliation is not possible.
General Tips for Resolving Discrepancies:
Communicate with stakeholders: Keep relevant parties (management, auditors, etc.) informed about significant discrepancies and their resolution. Update procedures: Use insights gained from resolving discrepancies to improve your reconciliation processes.
In any case, the law does not require you to have the original paper check, or even a copy of it, to resolve a problem with a bank. Generally speaking, you will not be held responsible for processing errors or transactions you did not authorize.
When you write a check and there's not enough funds in your account when it's presented, this is considered non-sufficient funds (NSF). When a check is returned due to NSF, it's returned to the payee that deposited the check, at their bank.
Verify which transactions have discrepancies, compare them with the corresponding records and make adjustments. Don't forget to look for missing transactions. Go back to the last audit and start reviewing any entries after that date. If the total doesn't add up, you have missing transactions.
Bank reconciliations are an important accounting tool because they maintain accurate financial record-keeping, good cash-flow management, fraud or error detection, and effective compliance and tax reporting. The process is handled by an accounting department or business owner and traditionally performed monthly.
Common reconciliation adjustments include outstanding checks, deposits in transit, bank fees, and interest earned or charged by the bank.
The "3 Golden Rules of Accounting" (BK) are fundamental to double-entry bookkeeping: (1) Personal Accounts: Debit the receiver, credit the giver; (2) Real Accounts: Debit what comes in, credit what goes out; and (3) Nominal Accounts: Debit all expenses/losses, credit all incomes/gains, providing a clear framework for recording financial transactions accurately.
Some of the examples of common accounting mistakes are mixing personal and business expenses, not keeping records of small receipts and recording incorrect amounts.
Whether you're on the sending or receiving end of an invoice discrepancy, the best approach is usually direct, honest communication. Reach out to your customer or vendor and let them know what happened as soon as possible so you can work through the inaccuracy and resolve the dispute.