Skip to main content
All CollectionsWebgility DesktopAdvice & troubleshootingAmazon
How to Record Amazon Settlement Data in QuickBooks and Prepare for Reconciliation
How to Record Amazon Settlement Data in QuickBooks and Prepare for Reconciliation

Learn how to prepare QuickBooks for Amazon orders and fees.

Virendra avatar
Written by Virendra
Updated over a week ago

Overview:

This guide will walk you through the steps to properly record Amazon settlement data in QuickBooks, helping you manage orders, fees, and transfers smoothly. By following these steps, you can ensure your Amazon sales and fees are accurately tracked and ready for reconciliation with your bank account.

1. Set Up QuickBooks for Amazon Orders & Fees

A. Create a Bank Account for Amazon (Amazon Clearing Account)

In QuickBooks, create a new bank account called "Amazon Clearing." This account will act as a virtual holding account where Amazon's revenue is temporarily stored until the funds are transferred to your actual bank account.

B. Create an Expense Account (Amazon Expenses and Fees)

Next, create an expense account labeled "Amazon Expenses and Fees" to accurately track all costs associated with Amazon, such as commissions, FBA fees, advertising, and shipping.

C. Create a Vendor (Amazon Vendor)

Add a new vendor named "Amazon Vendor" in QuickBooks. This will help you manage and categorize Amazon-specific expenses more effectively.

2. Configure Webgility for Amazon Orders & Settlements

Webgility simplifies the process of downloading and posting Amazon orders and settlement reports directly into QuickBooks. Here’s how you can set up Webgility to streamline this process:

A. Configure Daily Order Downloads

Set Webgility to automatically download Amazon orders each day, ensuring your sales records are always current in QuickBooks. For detailed setup instructions, refer to the article [How to Download Orders in Webgility Desktop].

B. Recommended Settings for Amazon

Webgility provides specific settings optimized for Amazon order downloads. Use the recommended configurations to streamline this process and ensure accuracy. See the guide on [Recommeded Settings for Amazon] for further details.

C. Posting Orders to QuickBooks

Once orders have been downloaded, the next step is to post them to QuickBooks. Webgility offers recommended posting settings to ensure the smooth transfer of data to your accounting software. For step-by-step instructions, refer to [How to Post Orders to Your Accounting].

3. Handling Amazon Settlement Reports

Every two weeks, Amazon provides a settlement report that includes all sales, fees, refunds, and other financial transactions for that period. Webgility can help you import this settlement report into QuickBooks.

When posting the settlement report:

  • Debit the "Amazon Expenses and Fees" account to increase your expense tracking.

  • Credit the "Amazon Clearing" account for the total of fees and expenses, reducing the clearing account balance.

For instructions on downloading and posting settlement reports, see [How to Download and Post Amazon Settlement Reports with Webgility Desktop].

4. Transferring Funds to Your Bank Account

After posting the settlement report in QuickBooks, Webgility will record the payment transactions in the Amazon Clearing account.

  • Go to Banking > Transfer Funds.

  • Transfer the amount from the "Amazon Clearing" account to your actual bank account.

  • Ensure the transfer date and amount match the settlement report.

Note: The date and transfer amount should match the transfer amount (closing balance), in the Amazon settlement report.


Clearing account wrap-up

Master equation:

Total revenue - $ deposited by Amazon - expenses and fees charged by Amazon = $0​

This is why this is called a clearing account.


Conclusion

This step-by-step process ensures that your Amazon revenue, fees, and transfers are correctly recorded in QuickBooks, simplifying the reconciliation process and providing clear visibility into your financials. For more information on related tasks, see the linked articles for detailed instructions on downloading and posting data using Webgility.

If you have any questions or need more help, please contact our support team.

Did this answer your question?