Please help/give advice on my Amazon merchant account recon (after the amz feb 28 update on how they present their reporting now -- post-based/accrual)
Hi everyone,
first time posting here! I just wanted to ask for your help/advice on how I can update my amazon merchant account reconciliation. Amazon updated their reporting from settlement-based to post-based and I am having a hard time updating our WP to reconcile Netsuite balance with Amazon.
Since both Netsuite and Amazon are now post-based, just looking at monthly transactions, they are the same. But in my reconciliation, I am seeing a difference in the ending balances.
I think it may be a problem with how I get my final amazon ending balance or I do not know how/what else to "adjust" Netsuite balance to match my Amazon ending balance.
What worked for January 2026 (using the updated reports from amazon) are the following adjustments (only in the WP and not in Netsuite, really. I just wanted to show what numbers exactly are causing the difference in balances):
- I add the transactions posted in previous month released in current month
- I remove the transactions posted this month but are yet to be released / deferred transactions
It worked well for January with 0 difference between amazon and NS balances.
My thought process what that the ones I removed in Feb will now be the additions and then a new removal amount from the deferred/unreleased amounts will be there. I'm not sure why it's not working in Feb onwards? Maybe I am missing something to consider?
Files I use for recon:
amz -- transaction report and flat file of period containing month-end date (e.g. period feb 25-mar 11 and then filtered up to feb 28).
netsuite -- balance sheet
general process in amazon merchant account reconciliation before I reach the final audit (the one I've been talking about above):
- recorded/ adjusted amz merchant account via JE -- settlements, reserves, landed cost, sales tax adjustments, income statement items (e.g. sales, returns marketplace fees, discounts, etc.)
After that, I do the final audit where I compare the amz ending bal with the netsuite ending bal and adjust to match Netsuite with Amazon's.
For the final audit, I get the amazon ending balance using the 2 amazon files I said earlier. Included in the amazon ending balance are the transactions that are both in the flat file I used and transaction report + transactions at the end of the month that are in the transaction report but not in the flat file (timing differences). This is how I do it before amazon changed their reporting to post-based and it has worked perfectly. For jan 2026, like I said, I did the same thing and considered the additions and removals and I was able to close cleanly.
For feb or for mar 2026, I cannot do the same simply.
Can you give me some advice or point out if I am missing anything in the final audit steps?
Thanks so much in advance, everyone! I've been trying to go over this for a month now (for feb and then for mar reconciliation).
Please be kind to me, I didn't study this at school. I learned bookkeeping through my boss who mentored me before so I mainly learned through hands-on application.