Summary Sync: How to Correctly Split Amazon FBA and Amazon Pay Summaries

Synder supports synchronization of all payouts from Amazon, both regular and those related to Amazon Pay. In this guide, we will explore how to accurately split Amazon FBA and Amazon Pay summaries using Synder’s Summary Sync mode.  

For Daily aggregation, Amazon Pay payouts are handled like other payouts and included in the summary for the corresponding day. However, for Per-Payout aggregation, due to the limitations from Amazon’s side, there will not be separate summaries for payouts related to Amazon Pay; instead, sales related to Amazon Pay will be incorporated into day-based summaries, ensuring your financial data is organized and precise. 

Although these payouts will go to the same account, the sales might be sent to different clearing accounts if chosen during the mapping process. This setup could cause discrepancies in your financial reports, so it’s important to carefully map sales and payouts in Synder.

We will demonstrate how to accurately manage and split Amazon FBA and Amazon Pay summaries using Synder’s Summary Sync mode, focusing particularly on account mapping and configuration in QuickBooks Online to achieve the desired result.

Setting up accounts in QuickBooks Online

For this use case, we recommend configuring QuickBooks Online with a top-level clearing account and specific sub-accounts for Amazon Seller Central and Amazon Pay. Follow these steps to configure your accounts in QuickBooks Online.

How to create sub-accounts for Amazon transactions

• Sub-account 1 – Amazon Seller Central
  1. Click on “Chart of Accounts”.
  2. Click “New” to create a new account.
  3. Name the account “Amazon Seller Central Clearing“.
  4. Select “Is sub-account” and choose “Amazon Clearing (Synder)” from the dropdown.
  5. Click “Save” and “Close”.

• Sub-account 2 – Amazon Pay
  1. Repeat steps 1-2 above.
  2. Name the account “Amazon Pay Clearing“.
  3. Select “Is sub-account” and choose “Amazon Seller Central Clearing” from the dropdown.
  4. Click “Save” and “Close”.

Configuring Amazon integration mapping in Synder

In the Mapping tab within Synder, select the Amazon integration, where you can specify which transactions should be routed to specific clearing accounts.

1. Amazon Seller Central transactions should be mapped to “Amazon Seller Central Clearing“.
2. Amazon Pay transactions should be mapped to “Amazon Pay Clearing“.

This configuration allows you to view the total for all three accounts (the top-level and both sub-accounts) in one place in QuickBooks Online. Although the individual accounts will record their respective transactions, with this setup you make sure the top-level Amazon Clearing account is always reconciled and free of discrepancies. 

By following these steps, you can ensure that your Amazon-related financial data is neatly organized and accurately reflected in QuickBooks Online.

Reach out to Synder Team via online support chat, phone, or email with any questions you have – we are always happy to help you!