How to Adjust Unreconciled Amount in AI Bookkeeping: 5-Step Fix

By Editorial Team · August 19, 2026

A man wearing glasses and a blue shirt holds open a large cardboard folder

Key Takeaways

An unreconciled amount in AI bookkeeping means your bank feed and ledger don’t match—usually because of missing entries, duplicates, or timing lags. Start by isolating the mismatch: filter transactions by date, amount, and status to spot the discrepancy in under 30 seconds. AI tools automate reconciliation but still need manual verification for edge cases like partial payments or bank errors, so always cross-check with your bank statement before adjusting anything.

Most discrepancies aren’t missing data—they’re status errors. Fix those first by correcting transaction flags or forcing a bank feed refresh. Only use adjusting entries as a last resort, and even then, document the reason (e.g., a bank error) to keep your books clean. Prevent future headaches by setting up bank rules, scheduling daily syncs, and reconciling weekly—small habits that catch errors before they snowball.

Part of our complete guide: for the full picture, see Xero Bookkeeping Software Reviews: 5 Expert Insights.

Why Unreconciled Amounts Happen in AI Bookkeeping (And How to Spot Them)

An unreconciled amount isn’t just a number—it’s a symptom. Before you adjust anything, you need to know why the mismatch exists. Most discrepancies fall into three buckets: missing transactions (uncategorized expenses, forgotten transfers), duplicates (split payments, recurring charges entered twice), or timing lags (pending bank approvals, delayed feeds). The fix depends on the root cause, and the wrong move can turn a small error into a bigger one.

Here’s how to diagnose it in 30 seconds.

The 30-Second Check

Open your reconciliation report and filter transactions by:

Amount (if the discrepancy is a round number, it’s often a missing or duplicate entry)
Date (timing lags usually show up as transactions that cleared the bank but aren’t in your ledger yet)
Status (pending vs. cleared—if it’s pending in your bank but marked cleared in your books, it’s a timing issue)

If the mismatch disappears after syncing, it was a lag. If it persists, dig deeper.

Where to Look First

Bank feed missing? Check your bank statement for transactions that never pulled into your tool. These are often uncategorized expenses or transfers between accounts.
Ledger duplicates? Scan your books for split payments (e.g., a $200 invoice entered as two $100 entries) or recurring charges manually added after the feed pulled them.
Timing lag? Pending transactions (like holds or recent deposits) won’t reconcile until they clear—force a refresh or wait 24 hours.

The Symptom That Rules Out a Simple Fix

If the discrepancy still exists after syncing, it’s likely one of two things:

A bank error (e.g., a transaction posted twice on their end)
A manual entry error (e.g., a transaction entered twice in your ledger)

In both cases, adjusting entries are a last resort—fix the root cause first. If you’re staring at a persistent mismatch, your next step is to compare your ledger line-by-line with your bank statement. No shortcuts.

Step 1: Isolate the Discrepancy (Without a Manual Entry)

An unreconciled amount is a symptom, not a diagnosis—so before you adjust anything, you need to see the mismatch. Your AI bookkeeping tool’s reconciliation dashboard is the first place to look, not the last. Here’s how to pinpoint the problem in under a minute without touching your ledger.

The 30-Second Check: Sort by Amount

Start by filtering your transactions for the date range where the discrepancy appeared. Then, sort them by amount—descending. If the unreconciled figure matches a single transaction, you’ve likely found your culprit: a duplicate, a misclassified entry, or a transaction that slipped through the cracks. (Most AI tools flag these as “uncleared” or “unmatched” in the status column—use that filter next.)

If the amount doesn’t align with any single entry, the issue is usually a partial payment or a split transaction. For example, a $100 invoice paid in two $50 installments will show up as two separate entries in your bank feed but only one in your ledger. Look for transactions that add up to the discrepancy—this is where timing lags or delayed processing often hide.

When the Discrepancy Lives in the Bank Feed (Not Your Ledger)

If the mismatch appears in your bank feed but not your books, don’t adjust your ledger yet. First, force a sync (more on that in Step 3). If the discrepancy persists, suspect a bank error—like a missing deposit or a misrouted transfer. These are rare but real, and they’re the only time you should create an adjusting entry (Step 4). For everything else (duplicates, timing lags, misclassifications), fixing the root cause is faster and cleaner than patching the symptom.

The Diagnostic Flowchart (No Tool Required)

Discrepancy matches a single transaction? → Duplicate or misclassified. Fix the status (Step 2).
Discrepancy adds up to multiple transactions? → Partial payment or split transaction. Reconcile them as a group.
Discrepancy only in bank feed? → Force a sync. If it persists, suspect a bank error (Step 4).

Pro tip: Most freelancers overlook the “uncleared” filter—it’s the fastest way to spot transactions that should match but don’t. If your tool doesn’t have one, sort by date and manually scan for entries that appear in one system but not the other. The goal isn’t to adjust yet; it’s to see the problem clearly before you fix it.

Step 2: Correct the Transaction Status (Before Adjusting Entries)

Most unreconciled amounts aren’t missing money—they’re just stuck in the wrong status. Your AI bookkeeping tool sees transactions as pending, cleared, or void, and a mismatch here throws off your entire ledger. Here’s how to fix it before reaching for adjusting entries.

The 30-Second Status Check

Open your reconciliation dashboard and filter transactions by status only. If the unreconciled amount shrinks or disappears, you’ve found the culprit. This isn’t a glitch; it’s a timing lag or a mislabeled entry. Don’t adjust yet—just change the status.

How to Flip the Switch

Pending → Cleared: If a transaction appears in your bank feed but not your ledger, mark it cleared. This syncs it to your books. Symptom fixed: The unreconciled amount vanishes when you refresh.
Cleared → Pending: If a transaction is prematurely marked (e.g., a future-dated payment), revert it. Symptom fixed: The mismatch reappears, then resolves when the actual payment posts.
Void: Only use this for duplicates or errors—never for timing differences. Voiding removes the transaction entirely, which can create bigger gaps later.

When Status Changes Don’t Work

If the unreconciled amount persists, dig deeper:

Split payments: A $150 invoice paid as $100 + $50? Your tool might see these as two separate entries. Group them manually.
Partial reconciliations: Some tools auto-match partial amounts. Check for “partially reconciled” flags and clear the remainder.

The Adjusting-Entry Trap

Only create an adjusting entry if: ✅ The bank feed is wrong (e.g., a bank error). ❌ The transaction is pending or duplicated—fix the status instead.

Pro tip: If you’re unsure, filter by amount and date to spot patterns. A recurring $50 discrepancy? It’s likely a subscription or fee your tool isn’t auto-categorizing. Fix the status, not the books.

Step 3: Sync Bank Feeds (And When to Force a Refresh)

The AI Bookkeeping System for Freelancers Who Hate Spreadsheets — If you would rather follow one written plan than piece this together yourself, our $37 guide lays out the setup in eight sections, from connecting accounts to the report pack for your accountant. see what’s inside the bookkeeping guide

An unreconciled amount usually isn’t a missing transaction—it’s a timing lag. Your bank approves deposits and withdrawals on its own clock, and your AI bookkeeping tool pulls those updates in batches. When the two schedules don’t align, your ledger shows a mismatch even though the money is already in transit. The fix? Sync the feed, then wait.

The 5-minute rule

Most banks post transactions in real time, but some hold deposits for final approval—especially on weekends or after business hours. After you hit “Update transactions,” give it five minutes before you assume the discrepancy is permanent. If the amount still doesn’t match, check the transaction list for entries marked “pending.” Those are the ones stuck in limbo; they’ll clear once the bank releases them, usually by the next business day.

What to do if the sync fails

If the feed won’t refresh at all, the connection is the first place to look. Open your tool’s “Bank feeds” tab and check the status: a red warning means the link is broken, a yellow one means the bank is throttling updates. Reconnect the feed if it’s red; if it’s yellow, wait an hour and try again. Some banks limit how often third-party tools can pull data, and forcing too many refreshes can lock you out temporarily.

When to force a refresh

Only force a refresh if the discrepancy persists after 24 hours, or if you see “pending” transactions older than three days. Those are the red flags that something’s stuck on the bank’s side—not just a timing lag. Before you force it, though, run a quick filter: sort your transactions by date and amount, and look for duplicates. A forced refresh can sometimes pull the same entry twice, creating a new mismatch where there wasn’t one before.

The key is patience, not panic. Most unreconciled amounts resolve themselves within a day; the ones that don’t are almost always status errors or duplicates, not missing money. Adjusting entries should be your last move—never your first.

Step 4: Adjusting Entries as a Last Resort (With Examples)

Adjusting entries are the bookkeeping equivalent of surgery—necessary, but only when everything else has failed. Most unreconciled amounts aren’t missing money; they’re just timing lags or status errors you’ve already fixed in Steps 1-3. But when you’ve exhausted those and the discrepancy still stares back at you, here’s how to close the gap without breaking your books.

The Only Two Scenarios That Need Adjusting Entries

Bank errors: Your bank statement shows a deposit or withdrawal that never happened (or happened for the wrong amount). Example: A $500 client payment credited as $50.
Uncategorized transactions: Your AI tool missed a fee, interest, or transfer because it wasn’t in the bank feed or wasn’t assigned to an account. Example: A $25 monthly bank fee that slipped through uncategorized.

If the discrepancy isn’t one of these, you’ve missed a root cause—go back to Step 1 and isolate it again. Adjusting entries should never be your first move.

How to Structure the Entry

Every adjusting entry follows the same rule: debit one account, credit another, and zero out the difference. Here’s the template:

Debit: The correct expense or income account (e.g., Bank Fees for a missed charge, Interest Income for unrecorded interest).
Credit: A temporary Suspense or Reconciliation Discrepancy account. This holds the difference until you resolve the root cause (e.g., a bank error you’re disputing).

Example: Your bank statement shows a $25 fee your AI tool missed.

Debit Bank Fees $25
Credit Suspense $25

The Suspense account acts like a placeholder. Once the bank corrects the error (or you confirm the fee is legitimate), you’ll move the amount to its final home. If the Suspense account doesn’t zero out after your adjustment, you’ve missed another discrepancy—go back and find it.

When to Avoid Adjusting Entries

Timing lags: If the transaction is in your bank feed but marked pending, force a sync (Step 3) instead.
Duplicates: Delete the extra entry—don’t adjust around it.
Categorization errors: Reassign the transaction to the correct account. Adjusting entries are for missing data, not misplaced data.

The Warning

Adjusting entries are a bandage, not a cure. If you find yourself making them often, your AI tool’s bank feed sync is broken—or you’re skipping Steps 1-3. Fix the process first; the entries will follow.

Step 5: Verify the Fix (And How to Prevent Future Discrepancies)

A dark scientific calculator rests on a background of printed numerical charts

Photo by Joachim Schnürle on Unsplash

You’ve fixed the mismatch—now prove it. Open your AI bookkeeping tool’s reconciliation dashboard and re-run the report. If the unreconciled amount reads $0, you’re done. If it doesn’t, resist the urge to adjust anything else. Instead, loop back to Step 1 (isolate the discrepancy) and Step 2 (correct transaction statuses). Most lingering mismatches are still just timing lags or mislabeled transactions, not missing money.

The 30-Second Verification Checklist

Filter by date range: Narrow the view to the period where the discrepancy first appeared.
Sort by amount: Scan for the exact dollar figure that was unreconciled—if it’s gone, the fix worked.
Check transaction statuses: Flag any remaining pending items and force a bank feed refresh (Step 3).

How to Prevent Future Discrepancies

Set up bank rules: Auto-categorize recurring fees (e.g., bank charges, subscriptions) so they’re never mislabeled.
Schedule daily syncs: Most AI tools let you automate feed updates—enable this to catch timing lags early.
Reconcile weekly: Even a 5-minute check catches small mismatches before they snowball.
Enable auto-reconcile for small amounts: If your tool supports it, set it to auto-clear transactions under $10. This eliminates noise from rounding errors or minor timing delays.

The One Setting You’re Probably Missing

Look for an “auto-reconcile” threshold in your tool’s settings. Setting it to $10 (or your comfort level) means the system will automatically mark trivial transactions as reconciled, saving you from chasing pennies. Just remember: this only works for timing lags, not actual errors—always verify larger discrepancies manually.

Pro tip: If your tool offers a “reconciliation health” dashboard, enable it. These dashboards flag potential issues (like duplicate transactions or uncategorized fees) before they become unreconciled amounts. It’s the closest thing to a bookkeeping early-warning system.

When to Escalate: Bank Errors vs. Tool Glitches

If you’ve followed the previous steps and still can’t reconcile your accounts, it’s time to determine whether the issue lies with your bank or your AI bookkeeping tool. The key to resolving this discrepancy lies in identifying the source of the problem.

Identifying Bank Errors

A bank error occurs when the discrepancy appears in your bank feed but not in your ledger, and persists even after syncing. For example, if a deposit is missing from your bank feed, it may indicate a bank error. To resolve this, contact your bank with the transaction date and amount, and ask them to investigate. They will be able to verify whether the transaction was processed correctly and take corrective action if necessary.

Identifying Tool Glitches

On the other hand, a tool glitch occurs when the discrepancy appears in your ledger but not in your bank feed. This could be due to a duplicate entry or an incorrect transaction status. To resolve this, check your tool’s error log (if available) or contact support with screenshots of the discrepancy. They will be able to help you identify and fix the issue.

By following these steps, you can quickly determine whether the problem lies with your bank or your AI bookkeeping tool, and take the necessary actions to resolve the discrepancy and get your accounts back in order.

Frequently Asked Questions

Why does my AI bookkeeping tool show an unreconciled amount after I fixed it?

Because the tool’s reconciliation report is a snapshot, not a live feed. It only updates when you re-run it. After making changes, refresh the report—don’t assume the dashboard auto-updates. If the mismatch persists, check for hidden filters (like date ranges or transaction status) that might be excluding your recent edits.

Can I ignore a small unreconciled amount (e.g., under $10)?

No. Even a few dollars can signal a deeper issue—like a duplicate transaction, a misclassified expense, or a timing lag in bank feeds. Small discrepancies compound over time, skewing your tax filings or cash flow reports. Use your tool’s filter to isolate transactions by amount; if it’s a rounding error, adjust it. If it’s a genuine mismatch, trace it back to the original entry.

What’s the difference between an adjusting entry and a journal entry?

An adjusting entry fixes a mismatch—like moving $50 from a suspense account to the correct expense category. A journal entry records a transaction that never hit your bank feed (e.g., a cash payment or a manual correction). Adjusting entries are temporary; journal entries are permanent. Always label adjusting entries clearly (e.g., “Reconciliation Adjustment – June 2024”) so you can reverse them later if needed.

How do I reconcile a partial payment in my AI tool?

Split the transaction. If a $100 invoice was paid in two $50 installments, your tool likely shows the full $100 as unreconciled. Use the “split” function to allocate $50 to the first payment and $50 to the second. If your tool doesn’t support splits, create a manual journal entry to reflect the partial payment, then mark both the original invoice and the journal entry as reconciled.

Why does my bank feed show transactions that aren’t in my ledger?

Three likely causes:

Timing lag: The bank processed the transaction after your last sync. Force a refresh (see Step 3).
Filters: Your ledger might exclude pending transactions or those outside your date range. Check your view settings.
Duplicates: The bank feed sometimes re-sends cleared transactions. Compare transaction IDs—if they match, void the duplicate in your ledger.

For persistent issues, run a 30-second check: filter your ledger by the transaction amount and date. If it’s missing, it’s a sync issue; if it’s there but unreconciled, it’s a status error.

Final Thoughts: The 2-Minute Reconciliation Checklist

Here’s your reusable diagnostic tool—five steps, two minutes, no guesswork. Run this whenever your AI bookkeeping tool shows an unreconciled amount, and you’ll fix it before it becomes a headache.

The 2-Minute Checklist

Isolate the mismatch Filter transactions by date and amount in your AI tool’s dashboard. The discrepancy will jump out—usually a single transaction stuck in the wrong status or missing from the bank feed.
Fix the status first Most unreconciled amounts aren’t missing data; they’re pending transactions that never cleared. Mark them as “cleared” in your tool before touching anything else.
Sync and wait Force a bank feed refresh, then give it five minutes. Timing lags are the most common cause of false discrepancies—your bank’s clock isn’t your tool’s clock.
Adjust only if necessary If Steps 1–3 fail, create an adjusting entry—but only for bank errors, not timing issues or duplicates. Use a suspense account (like the example above) to keep your books clean.
Verify and prevent Re-run the reconciliation report. If the amount reads $0, you’re done. If not, set up a rule to auto-categorize similar transactions going forward.

The Warning You Need

Adjusting entries are a last resort. Use them for bank errors (like a missing deposit), not for timing lags or duplicates—those fix themselves. If you’re adjusting for the same issue month after month, you’re masking a deeper problem (usually a sync setting or status misclassification).

Bookmark this checklist. Next time your AI tool flags a discrepancy, you’ll know exactly where to start—and when to stop.

Next step: Our $37 guide collects the setup, the categorization rules and the weekly check in one document. see what’s in the guide

Keep reading

Keep exploring the topic with these related guides: