How do I reconcile accounts that haven't been reconciled in months?
Start with the oldest unreconciled month, not the most recent. Reconciliation works chronologically because each month’s ending balance becomes the next month’s beginning balance. If you skip ahead, you’ll create problems that are harder to fix later.
Gather all your bank and credit card statements for the unreconciled period. You’ll need the ending balance and transaction details from each month. Download statements from your bank’s website if you don’t have paper copies. Having everything in front of you before you start saves time.
Open the reconciliation window in your accounting software and enter the ending balance from your statement. Work through the transactions, checking off items that appear on both your statement and your books. The goal is a difference of zero. When it doesn’t match, that’s where the real work begins.
Expect to find problems. Months of unreconciled accounts usually mean duplicate transactions, missing entries, incorrect amounts, or transactions recorded to the wrong account. Each discrepancy needs investigation. Look at the original transaction, compare it to the statement, and figure out what went wrong.
Old outstanding checks require attention. A check written eight months ago that still hasn’t cleared is either lost or was never cashed. Contact the payee or consider voiding and reissuing. Checks that have been outstanding for more than six months often indicate something went wrong.
If your beginning balance doesn’t match the statement’s beginning balance, you have a prior period error. This usually happens when someone adjusted a reconciled transaction or when previous reconciliations weren’t completed correctly. You’ll need to find and fix the discrepancy before the current month will reconcile.
Don’t skip transactions you can’t identify. Every unmatched item is either something you need to add to your books or something that was recorded incorrectly. Leaving mystery transactions unresolved means your books don’t reflect reality. Take the time to research each one.
Work through each month completely before moving to the next. Partial reconciliations create confusion and make it harder to track your progress. Finish January before starting February. Check off that month as done and move forward.
Once you’re caught up, reconcile weekly or at least monthly going forward. The reason accounts fall behind is usually that monthly reconciliation feels like a big task. Weekly reconciliation takes ten minutes and catches errors while you still remember what happened.
If the backlog feels overwhelming or you keep finding issues you don’t know how to fix, catch-up bookkeeping services exist for exactly this situation. Someone with experience can work through the mess faster and establish clean books going forward.
The longer accounts go unreconciled, the harder they are to clean up. Memory fades, supporting documents get harder to find, and small errors compound into bigger discrepancies. Even if the process feels tedious, getting current with reconciliation gives you accurate numbers and peace of mind.
Consistent small business bookkeeping prevents this problem from recurring. Once your accounts are reconciled and current, staying on top of them monthly takes far less effort than another multi-month catch-up project.
Full-Service Bookkeeping for Greater Phoenix
The Next Step:
A Quick Conversation
Tell us about your situation. We'll listen, ask a few questions, and give you a clear price to handle the work.
More Questions
How much do fractional CFO services cost?
Fractional CFO services typically cost $1,000 to $5,000 per month for most small to mid-sized businesses. The actual price depends on the scope of work, how many hours you need monthly, and the CFO's experience level.
Read answerHow do I account for food waste and spoilage?
Food waste and spoilage flow through your cost of goods sold, not as a separate expense. Track waste daily by category so you can see how much of your food cost comes from loss versus productive use.
Read answerDo I need an accountant who understands e-commerce accounting?
Yes. E-commerce involves unique challenges like payment processor reconciliation, inventory costing, multi-channel tracking, and multi-state sales tax that general accountants often struggle with.
Read answerHow do I handle accounts payable efficiently?
Efficient accounts payable comes down to centralizing invoice intake, coding bills as they arrive, and batching payments on a set schedule. Most inefficiency comes from chasing paper, scrambling at the last minute, and paying bills one at a time.
Read answerWhat should I look for when hiring a bookkeeper for my Shopify store?
Look for someone with specific e-commerce experience who understands how Shopify reports revenue, handles payment processor reconciliation, and knows multi-state sales tax rules. General small business bookkeeping skills aren't enough for the complexity of online selling.
Read answerWhat happens if I don't do my bookkeeping?
Neglected bookkeeping leads to tax problems, cash flow blindness, and cleanup costs that far exceed what ongoing bookkeeping would have cost. The longer you wait, the more expensive and painful it becomes to fix.
Read answer