Skip to main content
Question

Amazon Sellers - I am looking for help

  • April 16, 2026
  • 2 replies
  • 53 views
A
Freshman I

Hello Friends,
I have a few questions for those who are Amazon Sellers and use Acumatica, of course. I would like to know if someone has experienced what I am going through currently and if you wouldn’t mind sharing with me how you handle it?

A few notes about us so you have a better understanding, we get hundreds of orders everyday, we do not have Amazon payments connected to Acumatica so we manually process payments for every order in bulk. I also believe the person who was before me did things incorrectly and she trained me and so I feel like I am making our books not have accurate information because of that.

First question, I was wondering if you could tell me how you make sure that all the orders that Amazon says you have are in Acumatica? Currently I download an All Orders report for the time frame I want, and then I have a report in Acumatica that pulls all the sales order for the same time frame (I might do a few days overlap in case of delayed transactions). I then do a Vlookup to see if what Amazon has is in Acumatica, if there are missing orders I usually import them. I feel that this might not be correct exactly.

Second, do you use a clearing account for Amazon payments? As of right now I create a payment for each day of orders. For example today is the 04/16/2026 so in a few days I will create a payment dated 04/16/2026 and add all the orders dated for that day. This payment goes to a clearing account and then when our settlement comes in I will pull payments to total the amount of sales, therefore clearing this account out.

Third, if you do use a clearing account for Amazon payments how do you handle settlements and if you don’t use a clearing account how do you handle settlements? I ask this question because right now my clearing account has tons of payments sitting in there but all my settlements have been done and satisfied which means I shouldn’t have a balance in this account or if I do have a balance it should be very small.  With that said I do not know where to put these funds to clean this account up.

Last question, how do you handle sales tax coming over in Amazon orders? I will spare you the details on this one.

I know this is a long drawn out question and if someone would be so kind to try to help me out that would be great.  I am open to connecting with someone on Zoom to provide verbal details and maybe share some visuals so it could help explain my situation better and maybe get some ideas that way.  But I truly appreciate your time.  Thank you!


 

Angela

2 replies

mahmoudsabaa32
Acumatica Employee
  • mahmoudsabaa32
  • Acumatica Employee
  • April 17, 2026

​@amadrigalplus 

Please let me try to answer your questions, and how our Native Amazon connector works

  1. How can we verify that all orders has been imported to Acumatica: 
    Our connector has a feature to import settlement reports automatically to Acumatica, this settlement report is used by our automated Bank reconciliation screen to match transactions on the settlement reports to payments and orders imported during the period. if any transaction is missing, it will be marked as unmatched 
  2. Do we import transactions to a clearing account: Yes, best practice is to import amounts collected by Amazon into a cash account of type clearing, we import payment by payment to maintain accuracy of data and make sure that each payment has the charges collected by Amazon deducted from it, so at the time of bank reconciliation and bank deposits you are comparing to the actual amounts. So if you are depositing   100$-10$ amazon charges, then we reflect the exact same amount, this is screen shot of how our payments is being imported 
  3. As stated we import all transactions into a clearing account, these transactions include (Payments with charges collected by amazon, and also include non order fees that Amazon charges you, like subscription, warehousing….etc.) All of these transactions are reflected in your clearing Bank account
    example of non order fees imported by our connector 

     

  4. How to we handle Amazon Taxes:
    Our connector is able to distinguish if taxes has been collected by Amazon or the merchant. If taxes is collected by Amazon then we do 2 steps
    Import the taxes together with the order and post it to a liability GL Account, let’s say for instance 24060
    When the payment is imported, we make sure we deduct the amount Amazon withhold from the payment as per the previous screenshot, and we use the same GL Account 24060, hence offsetting the amount at the time of payment. 



    Hope I answered your questions.
    I would recommend to schedule a demo with your partner or directly with Acumatica to answer all your questions and concerns.

    A
    Freshman I
    • amadrigalplus
    • Author
    • Freshman I
    • April 17, 2026

    Our partner has not explained this info in regard to the Amazon Connector. I also started with the company I work with last year and was trained by someone who did not know how to do accounting let alone dealing with the massive amount of data from Amazon.  I do not feel we are using our Amazon Connector to the fullest potential but I do know we also have some things turned off because of our business practices.  I am not sure if after a year or longer of us doing things a specific way within Acumatica that it would be beneficial to turn things back on, but I will definitely ask them.  I appreciate you taking the time to answer my questions.  In the mean time if there is anyone else who can answer my questions with their way of doing things for their Amazon that would be fabulous.

    Angela
      Terms & ConditionsAccessibility statement
      About Acumatica ERP system
      Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
      © 2008 — 2024  Acumatica, Inc. All rights reserved