Founder, Deep Dish Swift • Brewed Books user
"My balance sheet was off by $1,400 and I couldn't figure out why"
I imported my QuickBooks data into Brewed Books and noticed the checking account balance didn't match my bank statement. Off by about $1,400 — close enough to be maddening, not obvious enough to spot manually. I uploaded the bank statement to Claude and asked for help.
My balance sheet as of 6/30 is off by ~$1,400 and I can't figure out why. The checking account doesn't match my bank statement.
Claude • Used: get_balance_sheet, list_journal_entries
I pulled up your balance sheet and compared it against the bank statement. Your books show the checking account at $54,222 but the bank statement ending balance is $55,648. That's a difference of $1,426.25.
Claude • Used: list_journal_entries (search)
Found the culprit. Journal Entry #86 is a $1,426.25 speaker reimbursement dated June 30 — but the ACH payment didn't actually clear until July 29. It was recorded in the wrong month during the QuickBooks import.
Claude identified the exact journal entry, the exact amount, and exactly why it was wrong — a timing mismatch between when the payment was recorded and when the bank processed it. A common QuickBooks import issue.
Can you fix it?
Claude • Used: create_correcting_entry
Done. I reversed the June 30 entry and re-recorded the $1,426.25 reimbursement on July 29 to match when the payment actually cleared. Your June balance sheet now shows $55,648 — matching the bank statement exactly.
The original entry is untouched for audit purposes. Both the reversal and the corrected entry show up in your History with full before/after diffs. You can revert either one with a single click if anything looks off.
What happened here
I asked Claude why my balance sheet was wrong and uploaded my bank statement. No spreadsheets, no manual digging.
Claude used Brewed Books' MCP tools to pull my balance sheet, search journal entries, and compare against the bank statement.
It found a payment recorded in June that didn't clear until July — a $1,426.25 timing error from my QuickBooks import.
Claude created a proper accounting correction: a reversal entry + a corrected entry on the right date. Original entry preserved for audit trail.
Total time: about 30 seconds. The same investigation would have taken me an hour with a spreadsheet.
No credit card required.