Skip to main content

How to Recognize Amazon Sales in the Right Period Under DD+7

2 ways to get Amazon sales into the month they shipped.

The problem

Amazon holds each payment until 7 days after the order is delivered (Amazon calls this DD+7). By default, ConnectBooks dates sales on the day Amazon posts them to the settlement.

So an order shipped on March 30 may be posted in April. It shows up in April's sales, not March's. Your March sales look too low and April looks too high.

Option 1: Date sales by ship date (recommended)

Turn on a setting, and each sale is dated on the day it shipped. No journal entry needed.

The catch: a month isn't complete in QuickBooks until all its orders are posted and their settlements close. That can take 2 to 3 weeks into the next month.

To turn it on:

  1. Go to Stores & Files and open your Amazon store's settings.

  2. On the QuickBooks tab, click Configure Advanced Settings.

  3. Tick "Export QuickBooks by Ship Date" and save.

Option 2: A reversing journal entry at month end

Keep the default dates. At month end, post a journal entry that moves the sales and costs not yet posted into a Deferred Revenue account. Then reverse it on the first day of the next month.

This is best for accountants who close the books formally each month, quarter or year.

Which should I pick?

  • Want it to happen on its own, and don't mind waiting a few weeks to close the month? Option 1.

  • Want to keep the default and just fix it at month end? Option 2.

Both put sales and costs in the month the order shipped, and your Amazon settlements still match.

Frequently asked questions

Why is my month still open in QuickBooks?

With Option 1, sales arrive as settlements close. Wait until all the month's settlements are closed and exported.

Did this answer your question?