If you're account isn't reconciling or if your synced balance doesn't match you available balance in Ambrook, there are several steps you can take to identify and correct any discrepancies between the transactions you have in Ambrook and your external source of truth.
Check your Opening Balance
Go to the Accounts page and click on the account you're going to reconcile. Scroll down to the Opening Balance and Starting Date. Make sure that the Opening Balance matches the balance on your bank account or credit card statement as of the Starting Date.
Tip: Always reconcile months in chronological order. If you need to make changes to a past month, you'll need to re-reconcile subsequent months.
Check Your Outstanding & Undeposited Checks Accounts
Your synced balance may differ from your available balance if you have recorded outstanding or undeposited checks that aren't cleared against posted transactions. Follow these steps to double check you don't have any checks
Go to your Accounts page
Click on the Outstanding or Undeposited Checks account
Click View Transactions
Click the 3 dots next to each check clear it
Check off transactions one-by-one against your statement
Deselect all the transactions, then click the circle to the right of the transactions to check off each transaction as you go through your statement. As you do so, the equation above the transaction list will show your progress towards the Statement Ending Balance.
If you are missing transactions on a connected account, try checking for any that were accidentally excluded. To do this, go to your Ledger and apply the following filters: Account → select the account, then Status → Excluded.
If you are missing transactions on a manual account, you can add them directly from the reconciliation session using the +New button.
Compare your debit and credit totals to your statement
At the top of your reconciliation page are the debit and credit totals - compare them to your statement to identify whether you're off on debits, credits or both and see if there are easily identifiable transactions causing the discrepancy.
Tip: If your ending balance doesn’t match your statement, shows the wrong sign, or the date range is off, you can quickly fix it by clicking the three dots next to Setup and editing the session—no need to start over!
Check the transactions on the edge dates:
Sometimes transactions from the first or last date of your statement may not be included on your statement (and instead be part of the previous or next statement). You can address this by changing the reconciliation session start or end date in Ambrook.
Note: The starting balance for your next reconciliation session is the original starting balance on your account plus the sum of ALL transactions from that account on your Ledger before the starting date of the reconciliation session.
Check Your Bank Connection
If you're not seeing recent transactions, check the last time your bank account synced by going to Settings --> Connections.
If your bank account hasn't updated in several days while you're trying to reconcile, here are some steps you can try:
Go to Settings → Connections
Click the 3 dots next to the connection
Click Update Log-In
Re-authenticate with your bank credentials
Wait 10-15 minutes for transactions to sync
Refresh the page
If this fails, reach out to our support team at support@ambrook.com. We can help you create a new connection and the merge the two together to avoid any duplicates.
Other Tips
First, check whether any transactions were previously excluded.
In your Ledger, click Filter.
Under the Account tab, select the relevant account.
Go to Status → Excluded only to see if excluded transactions are causing the discrepancy.
If you’re seeing duplicate transactions on a connected account, the issue is often caused by an accidental import or a manually added transaction.
To identify the source:
Click into a transaction.
Scroll to the bottom and look at the Source field. It will show one of the following:
Manual
Imported
Plaid or MoneyKit
Once you know the source:
Delete manually recorded duplicates.
Exclude imported duplicates, or delete the import if needed.
This should help you pinpoint and resolve the difference.