How to reconcile a budgeting app against your bank statement

Why app balances drift

Even with a working bank connection, an app's balance and your bank's balance drift apart for a handful of ordinary reasons. Knowing them turns reconciling from a hunt into a short checklist.

• YNAB lists duplicate outflows, missing transactions, uncleared items that have since cleared, and outflows recorded as inflows as common reasons the app shows less than the bank. [1]
• Monarch traces duplicates to pending transactions at the bank or to adding the same account twice. [2]
• PocketSmith traces missing transactions to changes in the bank's website, a disconnected feed, or intermittent data-provider faults. [3]

The general method, in five steps

This works in any app, or in a spreadsheet. The key idea, borrowed from YNAB's terminology, is to compare cleared balances: the sum of transactions both you and the bank know about. [4] Pending items are timing, not errors.

• 1. Get the bank's posted (cleared) balance and its date, from the statement or the online transaction list.
• 2. In the app, bring transactions up to date: approve imports, enter anything the bank shows that the app lacks.
• 3. Set aside pending items on both sides, then compare the cleared balances.
• 4. If they differ, work out the gap and test it against the causes above: one amount (duplicate or missing), twice an amount (sign flip), constant gap (starting balance).
• 5. Fix the transactions you can explain. Only then, if a small gap remains, record an adjustment and note why.

Worked example: a $60 gap

Say the bank shows a posted balance of $1,842.60 and the app shows a cleared balance of $1,902.60, so the app is $60 higher than the bank. Sort the app's transactions since the last reconcile by amount, which YNAB suggests as the quickest way to line up duplicates, and scan for 60.00 and 30.00. [1] If you find the $30 refund entered as a purchase, flipping it closes the gap exactly. If nothing fits, check whether the gap matches last month's gap before reaching for an adjustment.

Each app's reconcile or adjustment tool

Only YNAB documents a dedicated reconciliation workflow. The other three give you ways to correct a balance, and you do the transaction comparison yourself.

App notes worth knowing

YNAB: reconciling puts lock icons on reconciled transactions and tells YNAB not to import transactions dated more than three days before the last reconciled transaction, which cuts down duplicates. [5] For linked accounts, YNAB first checks whether pending transactions explain a mismatch and offers Reconcile Now if they do. [5] If you delete imported transactions, YNAB will not let the same transactions be imported into that account again. [10]

Monarch: before editing a balance, check your bank's own site to see whether a suspected duplicate appears there too, and check for the same account added twice. [2] Monarch also notes that some high balances are temporary, such as investment cash that has not settled or a large transfer that has not cleared. [6]

Lunch Money: synced balances flow from your bank to Plaid to Lunch Money; bank-to-Plaid updates can take one to three business days, and Lunch Money re-syncs at least every two days. Missing transactions or wrong balances usually start between the bank and Plaid, so support is the route for those. [7] After a CSV import you can correct the balance if Lunch Money's estimate is off. [11]

PocketSmith: for offline accounts filled by file imports, Calculated Closing Balance with a known balance on a date gives you an anchor. [9] When re-importing a file to fix gaps, the recommended Replace transactions on overlapping dates option replaces every existing transaction in the file's date range, losing labels and notes on those rows. [12]

The 10-minute monthly reconcile

Do credit cards the same way, using the statement balance and remembering that card payments should appear on both accounts as transfers. YNAB recommends reconciling weekly; the more often you do it, the fewer transactions you have to search when something is off. [1]

• Minute 1: open the latest statement or the bank's posted transaction list; note the posted balance and date.
• Minutes 2 to 3: in the app, approve or categorize anything waiting, and add any transaction the bank shows that the app lacks.
• Minute 4: mark or set aside pending items so you compare posted to posted.
• Minute 5: compare balances. If they match, finish (in YNAB, confirm the cleared balance to lock the transactions).
• Minutes 6 to 8: if not, compute the gap and test it: one amount, twice an amount, or constant.
• Minute 9: fix the transactions you found; recheck the balance.
• Minute 10: if a small unexplained gap remains, record an adjustment with a note, and repeat for the next account.