Identifying and Correcting Discrepancies in Your Amazon Reserved Balances Account
If the balance showing in your Amazon Reserved Balances account in Xero or QuickBooks doesn't match what Amazon is actually holding, don't worry - this guide will help you figure out what's going wrong and how to fix it.
Note: While this article is focused on Amazon, the same principles apply to reserved balances for other sales channels too.
Start with the Basics
Before diving into troubleshooting, double-check the following:
All your settlement invoices from Link My Books have been sent to Xero/QuickBooks
None have been deleted, voided, or duplicated in Xero/QuickBooks
You've followed the setup and posting instructions correctly from our help guides
If all of the above is in place, your Reserved Balances account should balance exactly to what Amazon shows as reserved. If it doesn't, keep reading.
What Is the Reserved Balances Account Used For?
In most cases, the Amazon Reserved Balances account is used for:
Funds held and released by Amazon
Split-month settlements (only for Amazon; for other channels like Shopify, Etsy, and eBay, those are recorded in the Split Month Rollover account)
Since every debit should eventually be followed by a matching credit, identifying mismatches is just a matter of finding entries that don't cancel each other out.
Step 1: Run the Account Activity Report
To begin reconciling:
Go to your accounting software and pull up the account activity for your Reserved Balances account (default name: LMB9 Amazon Reserved Balances)
In Xero: Go to Accounting > Account Transactions
In QuickBooks: Chart of Accounts > Find the account > Run ReportExport the report to Excel or Numbers
If you sell across multiple marketplaces or currencies, apply filters to review each one separately
Then, try to match off all transactions with corresponding debits and credits. Whatever's left unmatched is likely where the discrepancy lies.
⚠️ Before you check anything else: Look at the very first entry in your Reserved Balances account activity report. If it's a credit line called "Amazon Reserved Balances - Successful charge" or "Repayment of negative Amazon balance" with no matching debit before it, you almost certainly have an opening balance issue (see Section 6 below) — not a rolled-over negative settlement or a cross-debt adjustment. The fix is different, so please check this first before working through the other scenarios.
Common Discrepancies and How to Fix Them
1. Exchange Rate Differences
If you're working with multiple currencies, exchange rate fluctuations between the debit and credit dates may leave a small balance.
Example:
EUR debits and credits match perfectly
GBP equivalent differs by £23.23 due to FX rates
Fix: Create a journal entry to adjust the difference between the Reserved Balances account and your exchange rate gains/losses account. Your accountant can help if needed.
2. Negative Balances Rolled Over (Instead of Being Charged)
Sometimes, instead of charging your card for a negative balance, Amazon rolls the amount into the next settlement. This creates a missing credit entry in your Reserved Balances account.
Fix (Quick Summary):
Locate the negative settlement in Xero or QuickBooks
Manually add the balancing line item to account for the rolled-over amount
In Xero:
Add a line to the bill for the missing amount (e.g. -2,696.88)
Description: Small Balance Rolled over by Amazon
Account: Amazon Reserved Balances
Update the invoice total to £0.00
In QuickBooks:
Edit the journal entry
Change the "Bank Transfer" line to use Amazon Reserved Balances instead of your bank account
Update the description accordingly
For step-by-step instructions, see our dedicated help article on rolled-over settlements.
💡 How to tell this is your scenario: The unmatched entry in your Reserved Balances account is a negative line on a settlement that posted as a bill (because the settlement total was negative). The following settlement contains a "Repayment of negative Amazon balance" line. If instead the unmatched entry is a positive credit with no preceding debit, this is not your scenario — see Section 6.
3. Cross-Debt Adjustments Between Marketplaces
When Amazon uses a positive balance from one marketplace to offset a negative balance on another (a cross-debt adjustment), both sides of the transaction flow through the Amazon Reserved Balances account. If one marketplace's settlement has been sent to your accounting software but the other has not yet been sent, you will see a temporary imbalance in the Reserved Balances account.
How to identify this:
Look for a "Cross-debt adjustment" or "Cross-marketplace adjustment" entry on one marketplace with no corresponding entry on the other.
Check whether the other marketplace's settlement has been sent to Xero/QuickBooks. If not, send it and the entries should cancel out.
Fix: Ensure all marketplace settlements for the same period have been sent to your accounting software. Once both sides of the cross-debt adjustment are posted, the Reserved Balances account should balance. If a discrepancy remains after both are posted, check whether the negative settlement's bill was adjusted correctly (see our article on negative settlement bills in Xero).
4. Split-Month Settlement Parts Missing in Your Accounting Software
Amazon settlements that span the end of one month and the start of the next are split into two parts so that each month's revenue posts correctly. The Reserved Balances account holds the carried-forward value between the two parts, so both parts must be sent to your accounting software for the account to balance.
If you have an unmatched orange entry in Reserved Balances and the settlement period straddles a month-end, this is the most likely cause.
How to identify this:
Find the unmatched debit or credit in the Reserved Balances activity report and note the settlement value and date range.
In Link My Books, find the matching settlement on your dashboard. If the date range straddles a month boundary, it will have been split into two parts.
Check Xero or QuickBooks for both parts. If only one part has posted, the other is the missing side of the entry.
Fix:
In Link My Books, find the affected settlement on your dashboard.
Click Action > View to view the settlement. From the view settlement page you can send only the unsent invoice to Xero or QuickBooks.
OR you can rollback the entire invoice from the settlemetn dashboard and then resend from the settlement dashboard by clicking Action > Rollback which will rollback the parts of the invoice that has been sent.
Then click Action > Send To Xero/QuickBooks to resend the full invoice with all parts of the split month payout.
💡 Tip: If you'd like split-month settlements to repost automatically after rollback, go to Settings > Settlement Settings and switch on the option that allows autopost after rollback. Otherwise you'll need to manually click Send To Xero/QuickBooks for each one.
If the rollback fails:
🚨 Rollback failing with an error?
If you get a rollback error such as "the journal/invoice has been modified", it usually means the journal or invoice in Xero or QuickBooks has been edited or partly reconciled since Link My Books originally sent it. Our rollback can't remove a journal that's been changed on your accounting platform's side, so you'll need to:
1. Open the affected journal or invoice directly in Xero or QuickBooks and delete it manually.
2. Return to Link My Books and click Action > Rollback again, the rollback will now go through cleanly.
3. Click Action > Send To Xero/QuickBooks to resend the settlement.
5. Incorrect Marketplace Mapping
If you've mapped different marketplaces to separate accounts, make sure you haven't accidentally mixed up entries. A debit in one marketplace's account and a credit in another will leave both unbalanced.
Look for settlements labeled Missing Marketplace - these need to be manually allocated. See our help article on how to resolve this.
6. Opening Balance Issues (a very common cause for mid-year migrations)
If you started using Link My Books mid-year, switched from another system, or your accountant joined the account part-way through Amazon trading, you'll need to make sure your opening balance in the Reserved Balances account reflects what Amazon had reserved on your Link My Books start date. This is one of the most common causes of a persistent unmatched balance that won't clear, especially for accounts that have been with us for less than 12 months.
How to identify this is your scenario:
Run the account activity report for LMB9 Amazon Reserved Balances.
Look at the very first entry in the report.
If that first entry is a credit (for example, "Amazon Reserved Balances - Successful charge" or "Repayment of negative Amazon balance") with no preceding debit, you have an opening balance issue.
This happens because Amazon originally put the funds into reserve before Link My Books started syncing your settlements, so the matching debit was never posted to your accounting software. The credit that releases those funds is now sitting on its own and the account looks like it has an unexpected credit balance.
Why this gets mistaken for a rolled-over negative settlement:
The credit description in the account looks identical to the credit you'd see following a rolled-over negative settlement, so it's easy to assume the fix is to add a balancing line to a bill. That's not the right fix here. Adding a balancing line to a bill won't resolve an opening balance issue because there's no negative settlement to balance against — the entry is simply pre-Link My Books reserved funds that Amazon is now releasing.
The fix:
Post a manual journal entry in your accounting software dated on or before the date Link My Books started syncing this Amazon account, for the same amount as the unmatched credit:
In Xero: Go to Accounting > Manual Journals > New Journal. Date the journal as the day before your first Link My Books settlement was sent.
Line 1: Debit LMB9 Amazon Reserved Balances for the unmatched amount (e.g. £30.00). No VAT.
Line 2: Credit Retained Earnings (or your chosen opening balance equity account) for the same amount. No VAT.
Save and post the journal.
In QuickBooks: Go to + New > Journal Entry. Date the entry as the day before your first Link My Books settlement.
Line 1: Debit LMB9 Amazon Reserved Balances for the unmatched amount.
Line 2: Credit Opening Balance Equity (or Retained Earnings) for the same amount.
Save the journal.
Once that journal is posted, the unmatched credit on the Reserved Balances account now has a matching debit, and the balance will net to zero. The credit side of the journal sits on an equity account, which is the correct accounting treatment for a balance brought forward from before your records started.
💡 Example: A customer started using Link My Books in November 2025. Their first Amazon settlement on 26/11/2025 contained a "Successful charge" credit of £30.00 to LMB9, but no preceding debit. Amazon had originally reserved that £30 in October 2025, before Link My Books was connected. The fix was a manual journal dated 25/11/2025 debiting LMB9 by £30 and crediting Opening Balance Equity by £30. The account then balanced.
If you're unsure or want us to confirm before you post the journal, our support team is happy to take a look at your activity report with you.
7. Failed Transfers
When a payment fails, Amazon may bundle it into the next settlement - this can affect the Reserved Balances account too. If things still aren't matching up, this might be why. See our article on failed settlement transfers for help resolving this.
Still Not Balancing?
These are the most common causes, but not an exhaustive list. If you've checked:
All invoices have posted correctly
No duplicates, deletions, or voids exist
You've worked through the potential issues above
...and it's still not balancing, your accountant should be able to help identify the outlier. Or feel free to reach out to our Support Team - we're always happy to take a look with you.
If you have any questions about this article or feedback on how we could make it better please reach out to the support team via the blue chat icon on the bottom right of the page or via email to [email protected].