QBO Commerce Amazon Data Mapping to QBO

Hello there, Dan. Thank you for reaching out to us here in the Community forum. I'm glad you took the time to post your query, and it would be my pleasure to assist you with your questions regarding QBO Commerce Amazon data mapping to QuickBooks Online.

It's great to hear that you have successfully set up the Amazon connection and that it is working well for you. However, I understand that you are facing some challenges when it comes to reconciling the data in QBO with what appears in Amazon, particularly in terms of how QBO classifies the data into different accounts such as Sales, Discounts, and Shipping.

When it comes to how your data is reflected in our program, it is important to note that the way it is mapped and displayed depends on the third-party application you are using. In this case, we upload your sales data or transactions into our program based on the information provided to us by your third-party application which is Amazon.

To address the issue you are experiencing with the specific accounts showing different amounts in QBO compared to Amazon, I would recommend reaching out to Amazon directly. They may be able to provide guidance on how to configure the mapping accurately. 

You can also check out this article for the Frequently asked questions about  QBO and Amazon integration: Amazon Seller Connector by QuickBooks. Just go to the FAQs section.

In addition to the information I've provided above, I've included this helpful article that'll help you get the most out of your sales reports by filtering the information and even personalizing the format: Customize reports in QuickBooks Online. 

If you have any further questions or need additional assistance managing your Amazon transactions in QuickBooks Online, please don't hesitate to reach out. I'm all ears and ready to help you make the most out of your QuickBooks experience. Your satisfaction is my top priority, and I'm committed to ensuring your success.

@DantheMan-2 

QB Commerce offers limited functionality. Consider exploring third-party connectors to compare results.

Hello,

Thanks for the quick reply.

I am a little confused. Generally a third party application sends data in a standard format and the receiving application is responsible for handling how it is mapped in their software since each receiving application handles the data differently. I have a extensive background in IT and been working with financial systems for many decades and this is how it is normally handle.

Since this is integration provided by QBO, not another 3rd party, I would expect someone at QBO to know how the data is mapped.

While I am making a big assumption, I would have thought the data our using is basically the same data that I can download (GET_V2_SETTLEMENT_REPORT_DATA_FLAT_FILE_V2).

So not to be rude, this is something QBO should be able to explain and not try and push me to go back to Amazon. 

Thanks in advance,

Dan

I have looked at 2 other 3rd party connectors, but since we are just starting out, the cost seems expensive at this stage so trying to see if we can get QBO to work at least in the short term.

If you are working solo, you can use QB Desktop with a single user with a 3rd party connector to sync with Amazon and compare them. Your cost will be lower than QBO Plus.

We have a few users and we work virtually, so that wouldn't work 

We appreciate you for coming back here, @DantheMan-2. We understand that you've been using QBO for years, and it's quite confusing on your end why the amounts aren't the same this time with your Amazon seller account. With that in mind, let me route you to the best possible help.

I recommend contacting QBO live support to pull up your account in a safe environment and look for the root cause of why the amounts aren't in sync with your Amazon account. It might be that you're not the only one experiencing this issue and with this, they can create an investigation into this. Here's how:

1. Sign in to your QuickBooks Online company.
2. Select Help (?).
3. Select either tab to get started:
   • Assistant: Get quick, personalized answers. Select a suggested option, or type a question or topic you need help with. If you decide you need further help, you can still Talk to a human.
   • Search: Search the QuickBooks Online knowledge base directly, or select Contact Us and choose a way to connect with us:
     • Start a chat with a support expert.
     • Get a callback from the next available expert

Feel free to read these articles for future reference:

• Common questions about accounting for e-commerce in QuickBooks Online.
• Compare QuickBooks Commerce and accounting for e-commerce.

If you have additional questions, don't hesitate to come back here. We'll be willing to lend a hand. Take care.

@DantheMan-2 I am wondering if you ever got a good answer for the question about how the data is mapped.  I am truly confused and for things like advertising they aren't brought in as advertising.  Just curious if you got a solid answer or if I need to go back to my excel spreadsheet!

Hey Dan,

I had the same problem when I connected my Amazon account to QuickBooks Online. The total deposit would come through correctly, but the details like sales, discounts, shipping, and fees never seemed to match what I saw in Amazon. I spent hours trying to figure out how QuickBooks was mapping everything, and honestly, it just didn’t make sense.

I ended up using a tool called Synder, and it completely changed the game for me. Synder pulls in all the Amazon data and maps it clearly to the right categories in QuickBooks, just like how Amazon reports them. Sales show up as sales, discounts as discounts, shipping as shipping - everything is broken down properly.

What really helped is that Synder lets you customize and control how the data is categorized, so you’re not stuck trying to guess where numbers are coming from. It made reconciling everything so much easier, and I finally felt confident that my books were accurate.

If you’re running into the same frustration, I’d definitely recommend trying out Synder. It made a big difference for me, and I think it could really help you too.