Skip to main content
B
babywhatknots-ya
February 20, 2023
Question

I have QuickBooks Self-Employed. How do I import transactions form my Amazon Seller account? I need to import both income and expenses from my Amazon Seller account.

  • February 20, 2023
  • 1 reply
  • 0 views
There does not seem to be an easy way to integrate my Amazon Seller account with QuickBooks.  When I try to find information on it, I only see info on importing your Amazon purchases.  I do not need this.  I need to import my sales and expenses form selling on Amazon this past year.  Is there a trick to doing this?

1 reply

R
rvrfrf
February 20, 2023

Thanks for joining the Community, babywhatknots-ya.
 

You can import Amazon order information into your books by integrating Amazon with QuickBooks.
 

Here's how:
 

  1. Use the Gear (⚙️) icon in your upper right corner.
  2. Click Labs.
  3. Hit Turn It On.
  4. Enter your Amazon sign in credentials.
  5. Allow the connection to complete.

 

Once you've connected with Amazon, you'll see a few orders at first. It takes some time for others to come in while it works to retrieve your data from Amazon. Data retrieval goes back to January 1, 2018. You can hover the computer cursor over imported transactions to see their Order details. They will be identified with how many order items have been attached. You can then Split the transactions by Order Item.
 

When splitting transactions, they will default to a split by item, with your shipping and sales tax for the allocated proportionally across your items. You can check your box to split out the sales tax and shopping as separate expense lines if you need to.
 

Another option is manually uploading your transactions from CSV files:
 

  1. After downloading transactions from Amazon, use the Profile (⚙️) icon, then choose Imports.
  2. Click Import transactions.
  3. Follow your on screen steps to upload the CSV file.
  4. Select Import.

 

I've also included a couple detailed resources about working with transactions which may come in handy moving forward:
 

 

If there's any additional questions, I'm just a post away. Have an awesome day!

J
jeffwhite2
January 20, 2024

Did you ever get your question answered?  I am having that same issue.  I do not need to import my orders from Amazon as a buyer, but as a seller.

Thank you

R
Rasa-LilaM
January 20, 2024

Thank you for joining this thread, jeffwhite2.

 

Integrating Amazon Seller with QuickBooks Self-Employed (QBSE) can be helpful for many users. It allows them to easily manage their cash flow and better understand the profitability across different channels.

 

We encourage you to send a to our product developers to include the integration process of Amazon Seller directly into our product. Our developers will thoroughly review your suggestions and may consider incorporating them in future releases.

 

Here's how to submit your product suggestions:

 

  1. Navigate to the Assistant menu.
  2. Type send feedback in the field.
  3. Select Add a feature.
  4. Enter the details of your suggestion and send it.
  5. Click Yes to confirm.

Discover the newest innovations and enhancements brought to you by our engineers on the QuickBooks Blog. From there, you'll find resources and tips to grow your business.

 

For more in-depth information on how QBSE handles your Amazon transactions, you can refer to this article: Amazon integration with QuickBooks Self-Employed. 

 

 Moreover, you can access the following links for guidance on how to categorize your Amazon entries and allocate them to the correct Schedule C category:

 

Keep in touch if you have additional questions or about the integration process between your Amazon account and QBSE. I'll jump right back in to respond to them. Enjoy the rest of the day, jeffwhite2.

Terms & ConditionsAccessibility statement