Skip to main content

Troubleshooting Account Balance Discrepancies

What to check if your Ambrook balance doesn't match your statement.

Written by Katie Brooks

If the balance of an account in Ambrook doesn't match your bank, credit card or loan statement, the cause is usually one of a few things: the account's Starting Balance is wrong, some transactions are missing, or transactions were added that shouldn't be there. This article walks you through how to find the difference.

Understanding the balances you see

Ambrook can show up to three balances for an account. Before troubleshooting, make sure you're comparing the right one to your statement.

  • Current Balance: The total balance recorded in Ambrook, including bookkeeping activity that may not have cleared the bank yet.

  • Available Balance: How much money you have to spend. It's your Current Balance minus any checks you've written that haven't been cashed yet. If you have no outstanding checks, Available and Current Balance are the same.

  • Synced Balance: For connected bank accounts only. It's the balance your bank reports to Ambrook through the bank connection. You'll see it on the Accounts page, shown under the account's balance only when it's different from what's recorded in Ambrook.

Tip: A small difference between your Synced Balance and your Ambrook balance is often timing. Pending transactions, outstanding or undeposited checks, or a connection that hasn't refreshed yet can all cause a temporary difference. If the gap doesn't go away after a few days, work through the steps below.


Step 1: Check the account's Starting Balance

Every account's balance in Ambrook is its Starting Balance plus every transaction recorded in Ambrook from the Starting Date on. If the Starting Balance is wrong, every balance after it will be off by the same amount.

To check it:

  1. Go to the Accounts page and click the account.

  2. In the account details, find the Starting Date and Starting Balance.

  3. Find the bank or credit card statement that covers the Starting Date.

  4. Compare the Starting Balance with your statement. Use the balance at the start of the Starting Date if that day's transactions are in Ambrook, or at the end of the day if they aren't. If your statement period doesn't line up with your Starting Date (common with credit cards), see Finding Your Account's Starting Balance for how to calculate it.

If they don't match, update it:

  1. In the account details, click on the starting balance amount.

  2. Enter the correct balance.

  3. Save your changes.

Tip: If your Ambrook balance is off by the same amount every month, the Starting Balance is the most likely cause.

Note: Changing the Starting Balance changes the beginning balance of every reconciliation for that account. If you've already reconciled the account, you may need to remove and re-reconcile those sessions. See Changing or Undoing a Reconciliation.


Step 2: Look for missing transactions

If the Starting Balance is correct, the next most common cause is transactions that are in your bank's records but not counted in Ambrook.

Check for excluded transactions

Excluded transactions don't count toward your account balance. A transaction excluded by mistake, or by a rule, can throw your balance off.

  1. In your Ledger, click Filter.

  2. Under the Account tab, select the account.

  3. Go to Status → Excluded Only.

  4. Review the list. If a transaction should count toward the balance, click the three-dot menu (⋯) on the far right of the transaction and select Undo Exclusion.

Tip: If you find several excluded transactions that match a pattern, check your rules. A rule set to exclude transactions may be catching more than you intended.

Check for large blocks of missing transactions

If your balance is off by a large amount, a whole stretch of transactions may be missing, not just one or two.

  • Look for gaps in dates. Filter your Ledger to the account and scan by month. A month (or several weeks) with very few or no transactions, when your statements show normal activity, usually means transactions are missing for that period.

  • Compare month by month. Compare Ambrook's balance at the end of each month with your statement's ending balance. The first month that doesn't match is where the problem starts.

  • Check your bank connection. Go to Settings → Connections and check when the account last synced. If it hasn't updated in several days, click the three dots next to the connection and choose Update Login. If it still isn't syncing, see Troubleshooting: Existing Connections.

  • Check history before the account was connected. If your Starting Date is earlier than when you connected the account, your bank may not have sent all of the older transactions. You can import the missing transactions via csv file. See How to Bulk Import Transactions.

  • Check for an account that was hidden or reconnected. If an account was hidden, disconnected or connected a second time, some transactions may be on a different account in Ambrook. Filter your Ledger by each version of the account to find them.

Tip: For manual (unconnected) accounts, add missing transactions yourself, either from the Ledger or with the +New button in a reconciliation session. If it is a large amount of transactions, import them via .csv file.

While you're looking, check for extra transactions

A balance can also be off because of transactions that shouldn't be there:

  • Duplicates: Often caused by an import or a manually added transaction that overlaps a connected account. Open the transaction and check the Source field at the bottom (Manual, Imported, or Plaid/MoneyKit) to find where it came from.

  • Transactions on the wrong account: A transfer or payment recorded against the wrong account will throw off both accounts.


Step 3: Reconcile the account

The most reliable way to find and prevent balance discrepancies is to reconcile each account monthly against your statements. Reconciling checks every transaction against your statement and pinpoints the month where the difference starts.

Tip: If you've never reconciled, start with the month of your Starting Date and work forward one month at a time. The first month that doesn't balance is where you'll find the problem.


Still doesn't match?

  • For loan accounts see Troubleshooting Loan Balances.

  • If you've checked your Starting Balance, looked for missing and extra transactions, and reconciled, and the balance still doesn't match, contact our support team at support@ambrook.com or via the in-app chat. Let us know which account, the balance you expect, and the date.

Did this answer your question?