Amazon now holds most sellers' funds under DD+7 (Delivery Date Based Reserve), releasing them 7 days after delivery. Most sellers were switched in March or April.
The problem: the date a sale happens and the date the money posts can now be weeks apart. If your sales export to QuickBooks by posted date, revenue lands in the wrong month.
Example: you ship an order March 20, it's delivered March 23, and the funds don't reach your bank until early April. Exported by posted date, that sale shows up in April even though you earned it in March. Exporting by ship date fixes this. The sale is recorded when it ships, while the payout still posts when the funds arrive.
Before you begin
Some settlements you delete below may already be reconciled in QuickBooks, and deleting a reconciled deposit breaks that reconciliation. If yours were already reconciled, see How to reconcile deleted deposits in QuickBooks first.
Steps
Turn on the setting. Go to Stores & Files and click the store. Under Accounting Settings, click Settings. Click Configure Advanced Settings, tick Export QuickBooks by Ship Date, then click Save. See Export Sales to QuickBooks by Ship Date.
Find your DD+7 start date. In Seller Central, go to Payments and find when funds began sitting in deferred status. For most sellers this was in March or April.
Delete and export again. Delete every settlement from that date forward, then export them again. They'll return with sales dated by ship date, payouts applied, and deposits posted on the date funds arrived.
Confirm in QuickBooks. Spot check a few orders: sales on ship dates, payouts applied correctly, deposits on the dates funds came through.
A settlement can't be exported until every order in it has a ship date.
Every new settlement now exports this way automatically.
Frequently asked questions
Where is the ship date setting?
Go to Stores & Files and click the store. Under Accounting Settings, click Settings, then click Configure Advanced Settings. Tick Export QuickBooks by Ship Date and click Save.
Which settlements do I need to delete and export again?
Every settlement from your DD+7 start date forward.
Why won't a settlement export?
A settlement can't be exported until every order in it has a ship date.
Do I need to do this for new settlements?
No. New settlements export by ship date automatically once the setting is on.