Connect Amazon to QuickBooks Online with SellerZen

Here are 11 reasons why you should use SellerZen to connect Amazon to QuickBooks Online using SellerZen’s automated real-time syncing of transactions.

Visit SellerZen now to learn more about how SellerZen can help integrate and sync your Amazon seller account with QuickBooks Online.

Automated, Real-Time Sync

Once you configure SellerZen, our cloud-based platform works automatically to sync and import your Amazon seller transactions to your QuickBooks Online company.

SellerZen works 24 hours a day, 7 days a week to synchronize your transactions between Amazon and QuickBooks Online in real time. That means you’ll see transactions in QuickBooks Online when they’re available on Amazon.

Detailed Reporting

Businesses that have detailed financial reports can make more informed decisions. By using SellerZen to connect Amazon and QuickBooks Online, you’ll be able to see exactly what your income and expenses are using QuickBooks Online’s reporting tools.

Tips for Using SellerZen and QuickBooks Online Integration

See a detailed breakdown of your income and expenses in the Profit and Loss reports, Balance Sheets, or see exactly how much you’ve spent and earned:

  • Sales of Product Income
  • Cost of Goods Sold
  • Refunds
  • Reimbursements
  • Cost of Advertising spending
  • …and more!

Want to track your advertising expenses? Map those fees and more through SellerZen so you know exactly how much you’ve paid Amazon for advertising.

Separate all of your expenses into different accounts, group them into sub-accounts, or just lump them all into one account. However you structure your books, our flexible platform can be adapted to your business needs.

Fully Customizable

SellerZen is fully customizable to meet your business needs. When you sync your Amazon account to QuickBooks Online company through SellerZen, you’ll have the option to configure how we process transactions.

Our platform can be adapted to your business.

Configure the following into your own accounts or use our default settings:

Accurately Track Inventory

Looking for software to manage and track inventory? Why use one software to manage inventory and another to manage your books? QuickBooks Online can do both, streamlining your processes and saving you time.

If you have the Plus or Advanced subscription, you can track inventory in QuickBooks Online. Once you map inventory on SellerZen, our real-time sync of individual transactions means that your inventory levels will always be accurate.

Since SellerZen creates documents for sales, refunds, and reimbursements in real time, you’ll know what your inventory levels are at any moment.

Track inventory in QuickBooks Online so that you can replenish your FBA inventory, order more from suppliers, or look into potential reimbursement claims for FBA damage or loss.

Even if you don’t track inventory in QuickBooks Online, you can use a non-inventory item to track sales of product income.

Multichannel Fulfillment (MCF) Support

If you’re one of the many sellers who use Amazon FBA to fulfill orders for other marketplaces, then you can configure SellerZen to help you manage your inventory and expenses for multichannel fulfillment.

Advanced SKU Mapping

However you have your inventory configured in QuickBooks Online, you can use SellerZen to map your Amazon SKUs to your QuickBooks inventory.

Or configure SellerZen so that you can track income and expenses for classes of inventory.

Sell multiple SKUs across a range of categories? Set up SellerZen so that you can track income and expenses through classes for more detailed reporting.

Track sales across multiple Private Labels using SellerZen’s class tracking feature.

Sellers who do sales on consignment can also use class tracking for sales across multiple clients or brands.

Class Tracking in QuickBooks Online through SellerZen

Have SellerZen just track just sales income or sales income and fees.

Track Sales Tax

Once you integrate using SellerZen, you can track all of your sales taxes in QuickBooks Online.

Learn how much Amazon has collected and remitted on your behalf for the marketplace facilitator taxes.

If you sell on international marketplaces like Canada, you can configure SellerZen and have us handle international sales taxes.

Or run a report for your own state’s sales tax liability in QuickBooks Online.

By using SellerZen to connect and sync Amazon to QuickBooks Online, you’ll be able to run reports on the sales taxes you owe.

Affordable Solution

Instead of paying a monthly subscription fee for features that you may not use, SellerZen charges a flat rate of 5¢ per order import.

That means you only pay for each unique order ID import. All other transactions, like refunds, reimbursements, and settlements, are imported for free alongside the orders.

This pay-as-you-go plan is fantastic for sellers whose sales increase depending on the season.

You could pay $10 a month (200 orders) and then $20 (400 orders) a month during Q4 instead of a subscription fee of $39.99 per month.

Automate to Reduce Labor

SellerZen’s automatic synchronization will save you countless labor hours in entering transactions and fixing mistakes.

If you have an employee manually entering individual transactions, then it’s a task that is not only time consuming, but also extremely prone to errors. At 5¢ an order, SellerZen costs only a tiny fraction of what it’d cost you for a person to enter the same transactions. And our service is accurate.

Errors can also take hours to hunt down and fix, throwing off your reporting and giving you the wrong data when making important business decisions.

By using SellerZen to connect Amazon and QuickBooks Online, you can assign your employee to other important tasks.

Settlement Reconciliation

Once your settlement arrives, we’ll automatically reconcile all transactions on the settlement with the transactions we’ve created. This ensures that your Amazon to QuickBooks Online sync is always accurate.

You can even use SellerZen to run a settlement report to view all the documents we’ve created for that period.

Multiple Marketplaces

Connect as many North American (Mexico, United States, or Canada) marketplaces as you want to your QuickBooks Online company.

If you have more than one Amazon seller account, then you can connect them all to the same QuickBooks Online company to save you money on additional subscriptions.

Configure SellerZen to use location and class tracking so that you can track sales for each of the marketplaces to see how you’re doing with each one.

No matter how big or small your Amazon business is, SellerZen can help you save money and grow.

Using SellerZen to connect your Amazon to QuickBooks Online can give you powerful insight into your company’s financials that you can easily miss when you use other services that lump or summarize all of your income and expenses.

The best part is that there’s no monthly subscription fee. Start using SellerZen with a free 30-day import of your transactions to see just how we can help you today! No credit card is required unless you want to continue using our service.

Want to learn how to use some of the features in QuickBooks Online? Click on the links below to learn more.

SellerZen Part of Feedspot’s Top 70 eCommerce Blogs!

SellerZen is proud to be a part of Feedspot’s Top 70 eCommerce Blogs! See what other eCommerce blogs are on the Top 70 list.

At SellerZen, we work hard to provide our users with helpful and informative content.

Whether you sell on Amazon, eBay, or both, you’ll find useful content on our site.

Looking for shipping services? Tools? App integrations? Don’t waste hours researching these when you can find them all in one convenient place. For instance, our list of Amazon integrations, tools, and services can be useful for any type of Amazon seller.

Even if you don’t use any of those services, knowing what other sellers use can give you an idea of how they remain competitive.

View our collection of articles for a one-stop resource to view useful app integrations all in one place. From 3PL services to QuickBooks Online accounting guides, our articles provide a great starting point for your research.

You may even find a service you didn’t even know you needed. Stop by and browse our articles to see if we can help you today.

Class Tracking in QuickBooks Online through SellerZen

Class tracking is now available through SellerZen! Once enabled in QuickBooks Online and configured, sellers can track all income and fees for classes. While there are several uses for this new feature, we’ll go over two ways you can use this new feature to get better reporting in QuickBooks Online. You can also view our Help Guide on how to configure custom SKU mapping on SellerZen.

Enabling Class Tracking in QuickBooks Online

To use class tracking, you’ll first have to enable the feature in QuickBooks Online. You can do so via the Gear Icon > Company Settings > Advanced > Track classes. If it’s not there, the option may be in the Company link instead. See below for both locations. Click on the pencil icon to edit and turn on class tracking and/or location tracking.

QuickBooks Gear Company settings

Setting under the Advanced link:

Advanced Class Tracking Option

Setting under the Company tab:

Class tracking under Company

Back to top

Creating and editing Classes in QuickBooks Online

Once you’ve enabled classes under your Company settings, you’ll have to create and edit classes. You can do so under the Gear icon > All lists > Classes.

Gear All Lists

Classes location in All Lists

Add new class

Once you click on New, type the name of the class. You can also set your new class as a sub-class of another class. This may be useful for sellers who want even finer detail for their reporting. For instance, if you sell a broad range of categories, you might have Kitchenware as the main class. Then you’d have Utensils, Small Appliances, and Cleaning Supplies as sub-classes.

Breaking up your classes in this way allows you to see total sales and expenses related to categories of your products.

Consignment sellers may want to use the names of their clients instead to track all income and expenses related to the sale of the product. For example, if you’re a consignment shop, you might set up a class called “Client A” and assign that class to all of Client A’s products.

A quick report on the classes will tell you the total income and expenses related to the class. Using class tracking in this way helps you with calculating payments.

Back to top

Assigning Classes to Products on SellerZen

Once you’ve configured your classes, you can map your Amazon SKUs to classes, including all income and expenses associated with the transaction. To map SKUs to classes, go to the SKU Mapping tab under Integration.

Even if you have a class assigned on the inventory item in QuickBooks Online, you’ll still need to assign the class and apply fees and income on SellerZen. 

SellerZen SKU Mapping

Click on the Add New button in order to start mapping classes.

Add New Mapping

If you only have a few products, you can manually map them using the fields. If your QuickBooks Online Inventory Name is the same as your Amazon Seller SKU, then simply fill out the Amazon Seller SKU field, select the class, and check the Apply to item fees and income box if applicable.

Applying item fees and income box allows you to track all income and expenses associated with the mapped inventory item. This is useful if you want to see how much profit you’re earning per class after all income and expenses, or if you’re selling items on consignment.

If you don’t check the box, then we’ll only assign the class to the SKU on transactions. While you won’t be able to see associated income and expenses, you’ll be able to see total sales of product income for the class. See our next section on the reporting for examples.

Class Tracking

If your Amazon Seller SKU is different from your QuickBooks Online inventory name, then fill out the Iten Name field. When an Amazon transaction occurs with that particular Amazon SKU, we’ll use the Inventory Name specified in the QuickBooks Item Name field on the QuickBooks Online documents.

If you don’t want class tracking, you can leave those options alone. You can also use SKU mapping with class tracking. Simply select the class and check the box if you want to apply item fees and income.

SellerZen Custom SKU Mapping

If you have a lot of items to map, then click on the “Have many? Upload a file” link to submit a CSV file for us to process. A sample CSV file is provided for you to fill out, or you can create your own.

We ignore the first row, so don’t use any mapping there.

Sample Spreadsheet for SKU Mapping

Need help exporting to a CSV file? See our visual guide using Google Sheets for more help. Most spreadsheet apps will have a similar process.

Once you upload the file, we’ll send you an email when we’re done processing the mappings. The email will include any issues you need to address. We recommend that you complete all necessary SKU and class mappings before you start the sync.

You can review all mapped SKUs and classes below.

SellerZen Mapped Items

In the image above, Garden_Rocks_FBA is mapped to the inventory Garden Rocks in QuickBooks Online, with no class tracking enabled.

Amazon Seller SKU ABC-DEF-GHI also exists in QuickBooks Online with the same Inventory Name, and we’ve assigned a class and checked the “Also apply to item fees and income” box to track other income and fees with the transaction.

Review all assigned mappings and make any necessary changes.

Back to top

Viewing QuickBooks Online Profit and Loss Reports

Once you’ve configured class tracking on QuickBooks Online and SellerZen, you’ll be able to run profit and loss reports that can give you more detail about your income and expenses.

Take a look below a sample Profit and Loss report in QuickBooks Online with class tracking enabled on some inventory.

Profit and Loss with Class Tracking

In this report, we have the “Also apply to item fees and income” box checked for all items. As a result, all the fees are tracked along with the Sales of Product Income.

Under the “Pants” class, we see a Sales of Product Income of $3,263.18. Because we’ve specified during the mapping that we also wanted to track item fees and income, all other Amazon fees are also tracked. Commission, Fulfillment, Other Fee, and Return Fee total $670.05. That gives us a total of $2593.13 before subtracting Cost of Goods Sold.

Note that with class tracking enabled, SellerZen also processed the return, ensuring that income and expenses are correctly recorded. This is important for consignment sales.

Sub-classes also show up, along with the total for the main class.

Profit and Loss report with Class Tracking

Without the “Also apply to item fees and income” box checked, your report would just show the sales of product income for that item. You can see this in the “Extra” class in the image above.

If you’re diligently adding your Purchase Orders in QuickBooks Online and receiving inventory, using SellerZen to automate your Amazon to QuickBooks Online transactions will give you very detailed reports. You’ll know exactly how much your income and expenses are for every item, class, and account.

Read through our accounting series linked at the end of this article to learn how to receive inventory in QuickBooks Online using Purchase Orders.

Back to top

Use Cases for Class Tracking

Not sure how you can use class tracking for your business? Class tracking allows sellers to group or categorize products. Here are some popular reasons why sellers may want to enable and use class tracking.

Enable and use Location Tracking for even more detail!

Consignment Sales

If you’re a consignment store, you can easily group your products by clients using classes. If you also track fees and income with the item, you’ll be able to see exactly how much the net profit is per sale for each product. For example, in our image above, you might have a class with “Client A” and all products belonging to Client A tracked instead of “Jackets.”

Class tracking for consignment sales streamlines the process for computing disbursements to clients.

Better Organization of Products

Think about classes as categories or groups. In our consignment example above, we’ve used classes as clients. But you’re not limited to just clients. You can also use classes to represent the following:

  • Brands
  • Market Type (Mass Market, Luxury, etc.)
  • Audiences
  • Demographics
  • Collections
  • Categories
  • FBA and FBM
  • …and much more!

Don’t forget that you can also split up classes into sub-classes, allowing for even more detailed reporting!

When you run class reports in QuickBooks Online, you’ll quickly see the relevant numbers for each class you’ve created and assigned in SellerZen.

More Detailed Reporting

By using class tracking, you’ll be able to get more detailed reporting for your business. No matter how you group your products, you’ll be able to see income and expenses for every class that you’ve created and assigned.

This allows you to make better decisions for your business, like dropping low-performing products/classes to focus on more profitable products/classes. You may even discover products or classes that are losing money!

Have questions? Don’t hesitate to contact us at info@sellerzen.com or start a chat with us through the chat icon on anywhere on our website. We’ll be more than happy to help.

Back to top

Want to learn more about how to use SellerZen? Check out these articles:

SellerZen Amazon to QuickBooks Integration Guide

Introduction – SellerZen Amazon to QuickBooks Integration

SellerZen’s Amazon to QuickBooks integration automatically imports Amazon seller transactions into QuickBooks. Setting up your accounting software properly and handling transactions correctly are time-consuming tasks. They’re also prone to mistakes that can take hours to discover and fix. The time it takes to enter documents, reconcile, and fix mistakes can cost you much more than a service like SellerZen.

Additionally, disorganized records mean you’ll end up paying a bookkeeper more just to handle your accounts. With SellerZen, you can be sure that once you configure the platform properly, all your transactions will be accurate. As a result, you’ll save money on employee and bookkeeping costs. Another benefit is that you’ll have insight into your business that you didn’t have if you’ve just been lumping your income and expenses every settlement.

In this article, we’ll go over what the normal process is for entering transactions into QuickBooks. Then we’ll discuss some of the common transactions that sellers forget to enter, like inventory adjustments. We’ll also go over how Amazon sellers can use SellerZen’s features for more convenience.

Check out our list of 3rd party Amazon tools, services, and apps if you’re looking for other ways to automate or improve your Amazon business.

Creating Invoices for FBA and FBM

Amazon FBA and FBM sellers have a slightly different need for handling sales invoices in QuickBooks Online. First, FBA sellers don’t have a critical need to enter sales invoices immediately since their inventory is stored elsewhere. And FBA sellers are paid when Amazon ships the order, so payment is immediate when orders are shipped.

What this means for FBA sellers is that they can enter their invoices when they get a chance since they can create invoices and receive payments right away. They’re not too concerned about having precise inventory counts since their FBA inventory is separate even if they sell on multiple marketplaces. Read more about the advantages of FBA and disadvantages of FBA.

FBM sellers have a slightly different process. When customers submit an order on Amazon, FBM sellers have to create the invoice in QuickBooks Online. Afterward, they’ll ship and mark the order as shipped on Amazon. Only then can they go back to QuickBooks and click on “Receive payment” to close the invoice.

This workflow is important since FBM sellers store their own inventory. Failure to create the invoice in QuickBooks can lead to inventory discrepancies, and if FBM sellers sell on other marketplaces like eBay, their inventory quantity will be incorrect. This workflow has a lot of potential errors in a business where different employees handle different aspects of the business. Miscommunication between different employees can lead to issues that ultimately result in lower seller account metrics because of canceled orders.

When creating invoices in QuickBooks Online, all the line items on the invoice should match the line items Amazon displays for the order. The process in QuickBooks can be a little confusing because QuickBooks uses the term services for line items.

To add line items to QuickBooks Online, you’ll have to go to Sales > Products and Services > New > Service. These services are connected to specific accounts in QuickBooks Online Chart of Accounts. So if you want to view certain fees like Amazon Sales Tax Collection Fees, you should create the corresponding account under Accounting > New. Be sure to select the proper Account and the Detail Type that matches the service.  You may want to use Other Miscellaneous Service Cost or Other Primary Income for the Detail Type if you’re unable to find one that is close.

Naming the service and choosing the right account is important for viewing detailed reports. If you sell on multiple marketplaces and you map all of the services to the same account, you won’t be able to run detailed reports for each marketplace. As you create invoices for your Amazon orders, you’ll eventually create all the necessary services and accounts for your business. You only need to make sure to receive payment for the invoices when you mark the item as shipped on Amazon.

If you’re using a different Undeposited Funds account, be sure to select that before you click on Receive payment. It would be incorrect to select your bank account since you haven’t received money yet. Once Amazon’s disbursement arrives, you would create a bank deposit to your bank account after you’ve reconciled the settlement.

Believe it or not, it’s actually quite easy to lose money selling items on Amazon if you’re selling items for less than $10. Sellers can make pricing mistakes, or FBA workers may measure a product incorrectly, leading to higher than expected fees. If this is the case for some of your invoices, then you’ll have to process these transactions properly.

QuickBooks Online doesn’t allow negative invoices. You’ll have to zero out the invoice and create an additional document with the line item and the remaining amount so that the balances are reconciled. You’ll also have to create proper documents when customers are issued refunds or when they return items, even when these refunds or returns are scams.

FBA sellers have a more difficult time tracking customer returns since those returns can sometimes take more than 30 days before the warehouse ships the removal order. If that’s the case, FBA sellers can track customer returns through SellerZen’s platform.

Whether you use FBA or FBM, SellerZen will automatically create the proper documents for you. If you’re FBA, then the process is completely automated. We’ll create the invoice and receive payment for the invoices. All of this is done reliably, consistently, and accurately no matter the case.

SellerZen Line Item page

Using SellerZen, you can create and link the service items you create to any account you want. Then simply map those service items to our platform, and we’ll automatically create the correct invoices in QuickBooks Online every time. Our platform can link any Amazon line item to a service item of your choice.

We require the most common line items, but every seller is different. You can map the FBA Labeling Service fee to see how much you’re spending for that service. Then you can run reports in QuickBooks Online to see just how much you’re spending every month on the label service. You may discover that you’re better off printing the FNSKU on the package or putting on your own labels.

For fees that you haven’t mapped, we’ll use the “Other Fees & Expenses” service item so that the invoice is created in QuickBooks Online. You can always look through that account later and create any service items you’ve missed. Then map those new service items in SellerZen under “Other Line Items Mapping.” Future invoices will properly reflect the correct fee.

Amazon FBM sellers may find our service particularly convenient since we create invoices as the orders become available through Amazon. Sellers can focus on shipping their orders. We’ll close the invoice as soon as the status change is available through Amazon. FBM sellers no longer need to worry about inventory counts. Because SellerZen imports data in real time, FBM sellers can focus on picking, packing, and shipping rather than setting time aside to enter transactions into QuickBooks Online.

You can save even more time by learning QuickBooks Online shortcuts.

Reimbursements & Refunds

Whether you’re FBA or FBM, you’ll eventually see reimbursements from Amazon for one reason or another. FBM sellers may have reimbursements for Item Not Received (INR) claims when purchasing shipping through Amazon. FBA sellers may be paid for damaged inbound shipping or lost warehouse inventory. Whatever the reasons, many sellers don’t accurately record these transactions, but these transactions can have a significant impact on their business. This is even truer if Amazon loses or damages a large amount of inventory.

Let’s take a common scenario: as an FBA seller, you send in 100 units of inventory. Amazon receives only 50, and after you open a case for investigation, Amazon reimburses you. Amazon may reimburse you for the purchase price or for the sales proceeds price (your sales income after fees). Regardless, few sellers record this transaction properly. This reimbursement isn’t technically a sale. Recording it as such may lead to poor inventory forecasting if you’re using some kind of inventory forecasting tool and you may end up spending money on inventory that doesn’t necessarily sell quickly when you can instead spend it on inventory that moves.

If Amazon reimburses you with inventory, then you may be tempted to ignore the loss and reimbursement since you received back what was lost. However, you should consider recording these two transactions in the event you receive counterfeit or defective goods. SellerZen will log all transactions so you’ll have a record of them if you ever need.

Because all the inventory adjustments happen at the warehouse, you don’t know what condition the items are in. They could be new but slightly damaged or flawed in some way that might result in more returns. Ultimately, you’ll have to trust that any reimbursements with inventory are in excellent condition. The only other way to find out is to create a removal order. You’re still not guaranteed to get the affected item back unless you remove everything. Even then, you wouldn’t be able to tell which ones Amazon gave you unless there was an obvious difference. If you remove inventory during their free inventory removal promotion, you will not be able to send the same ASIN back until later.

Amazon reimbursement for a failed customer return

In the image above, the customer received a refund but didn’t return the product. Because FBA handled the customer service, Amazon funded the loss automatically. A customer return, lost warehouse, or lost inbound will all result in a similar document in QuickBooks Online. In an ideal world, you’d issue the refund and receive a return that is still in new and sellable condition. But that’s hardly the case on Amazon.

Instead, you should create a refund receipt that will increase the inventory count by 1.  Then create another sales document for zero dollars to decrease the inventory by 1. If Amazon reimburses you inventory or cash for the failed return, you’ll have to create another Vendor document to reflect the transaction. When you create the proper documents, your inventory will be synchronized. If you only create the refund document, then your inventory will be out of sync with Amazon.

FBM sellers generally issue refunds after they receive and inspect the return. But FBA sellers don’t have the same luxury since customers return orders to Amazon. Amazon sometimes issues refunds without the return. When customers receive a refund before returning the order, they may not feel obligated to send items back.  Since they’ve already received their money, their priorities shift.

For low-cost items, Amazon may even allow customers to keep the product since return shipping and fees may exceed the cost of the item. Sellers who sell low-cost items should look into returnless refunds. This option will save sellers time and money from having to process refunds and returns.

Creating a refund document in QuickBooks Online when customers haven’t returned the item isn’t accurate. A refund in QuickBooks automatically increases the sellable inventory. The only time this is correct is when the customer returns the item and it’s still in sellable condition. FBA sellers may not see the condition for 60 days since customers can request a refund 30 days from receipt and then have an additional 30-45 days to return the item.

Managing refunds accurately can be a frustrating process for both FBM and FBA sellers. The process is worse when customers open an A-to-Z claim since failing to respond properly results in an automatic loss. Read more about how avoiding some common mistakes new sellers make. Sellers who don’t respond to A-to-Z claims in a timely manner will lose both their product and the funds. They’ll also take a hit on their seller account metrics.

Another scenario sellers may face is when Amazon issues a goodwill discount or partial refund to customers. When this happens, sellers have to create the proper documentation as well. Many sellers may be tempted to create a refund document with the product, but this is incorrect since doing so will increase inventory. Instead, sellers should create a refund with the Goodwill Discount service item and associate the order ID with the document. This case is further complicated if customers later return the item. Then sellers would have to create an additional refund document with the remaining amount and an additional document if the product is damaged.

Creating all of these documents can be confusing since selling on Amazon and keeping track isn’t straightforward. You’ll have to periodically check for reimbursements or returns so that your QuickBooks Online will be synchronized with Amazon transactions. Most sellers don’t bother with this level of detail since proper recordkeeping requires such an investment in time. And it’s nearly impossible to manage if sellers have thousands of orders a month.

Managing refunds and reimbursements correctly will allow you to keep your inventory levels synchronized with Amazon and accurate. For FBA sellers, inventory management is not as urgent since inventory is stored at Amazon. Only FBM sellers may encounter some issues if inventory levels are inaccurate. Since FBM sellers may sell on other marketplaces, inventory management is more critical.

Using SellerZen, sellers can automate the entire process. No matter the case, we’ll handle the proper documentation in QuickBooks Online. Sellers will always have an up-to-date view of their Amazon business since our automated data entry is done in real time.

Inventory

Many sellers start looking for an accounting solution only when they need it. If sellers keep information on a spreadsheet, they may be missing important information. Or they may be logging information that isn’t necessary. Either scenario is a waste of time for sellers.

Few sellers also look for an inventory management system when they first start their business. They may keep a simple spreadsheet with their first few SKUs and not think about recordkeeping until later. Eventually, the spreadsheet grows organically, and a lot of data is missing, misplaced, and highly disorganized. Sellers just want to sell their products and grow their business. So keeping track of inventory can be frustrating and time-consuming.

In this section, we’ll go over some of the issues sellers have with inventory when using QuickBooks for the first time. To create a new inventory item in QuickBooks Online, go to Sales > Products and Services > New > Inventory (or Non-inventory). We recommend that you use the default QuickBooks accounts for inventory. They are the Inventory Asset, Sales of Product Income, and Cost of Goods Sold accounts. SellerZen uses these default accounts if you want us to create the inventory items.

One mistake Amazon sellers make here is that they use the Amazon SKU field for the QuickBooks Online SKU field. And why not? The labels both match. However, the QuickBooks Online SKU field is not unique, meaning sellers can create several inventory items with the same SKU. Sellers who do this can potentially make mistakes or incorrectly map inventory items. This can also lead to a lot of confusion later.

Instead, you should map your Amazon SKU to the QuickBooks Online Name field. The Name field is a unique identifier, so you won’t be able to have two items with the same Name. Here’s what we recommend for the fields so that you can create the proper inventory items.

Below, is what you’ll see on your Amazon account when you click on Manage Inventory. We recommend you use the following names for the QuickBooks inventory fields. The Inventory sales information (description) isn’t really necessary since that may change.

Amazon Inventory Catalog

When you create a new inventory item in QuickBooks Online, you’ll see the following fields.

Add Inventory Screen in QuickBooks Online

Enter the initial quantity on hand. For the As of date, you should use the date that the first transaction occurred for this product. That can mean a sale, purchase, or reimbursement. Many sellers just use the current date. However, QuickBooks Online won’t allow you to create documents for inventory with dates that precede the As of date.

For example, if you choose an As of date of May 1, 2018, then all documents for that item must have a date of May 1, 2018 or later. All transactions for the inventory item you create needs to have a date of May 1, 2018 or later even if the transaction happened before. If you do this and run reports, your amounts for the year will still be correct, but your amounts for the month may be different because all transactions use the As of date from the inventory item.

Why shouldn’t you use the Amazon Product Name in the QuickBooks Online Inventory Name field? Some sellers like to use their product titles or descriptions in the QuickBooks Online Inventory Name field. But doing this can be problematic since QuickBooks Online restricts the number of characters you can use in that field. Also, if the Amazon Product Name changes, you’ll have confusion amongst employees who need to work with your QuickBooks company. You can change QuickBooks Inventory Names, but this can be confusing since it’d require a lot more tracking. You’d have to revise the Name field every time there’s a change on Amazon if you want to keep the two synchronized.

You wouldn’t have to constantly revise inventory if you use the Amazon Seller SKU for the QuickBooks Inventory Name. The Amazon Seller SKU doesn’t change. And you can change the Product Name without worrying about your QuickBooks Online inventory item.

With SellerZen, you’ll have the option of mapping your Amazon Seller SKU to Inventory Name or SKU. We recommend that you use the Name field since that’s a unique identifier in QuickBooks Online. If you use our setup wizard, then we’ll use the Name field and we’ll use the ASIN for the SKU.

SellerZen SKU Mapping page

If you want us to create inventory items, then we’ll use the date of the first transaction we process for the SKU. This may not necessarily be the correct date since we don’t know when you first started selling the item. So if you set the As of date for this month, you’ll see all of your refunds and reimbursements from as far back as you’ve synced dated to this month for the product. Your annual reports should still reflect the correct amounts.

If you enter the Inventory Cost, we’ll calculate and display your true profit per sale on our Order Dashboard. This quick view can alert you to any pricing or issues you have per item or invoice. You can easily see your profit per invoice and investigate further if necessary.

Some sellers don’t need or want to track inventory. If that’s the case, then you don’t necessarily need the QuickBooks Online Plus subscription. Use the “Use the following item for all (Amazon US) SKUs” option and choose the Non-inventory account you want us to use for all of your Amazon SKUs. We recommend that you name this Non-inventory item using your marketplace region. This way, you can connect other marketplaces and separate the sales reports. Something like “Amazon US SKUs” will allow you to run better reports if you later have multiple Amazon marketplaces connected.

You can also map your Amazon SKUs to both Inventory and Non-inventory items through SellerZen. Read our guide here for how to configure custom SKU mapping.

While your own bookkeeping methods may make sense to you, they may not be so clear for other people. Employees, bookkeepers, and accountants aren’t mind readers. By using best practices in QuickBooks Online, you’ll minimize the amount of confusion for other people. And you’ll ultimately pay less for an accountant because your books will be in order. With SellerZen, you won’t have to worry about whether or not someone has properly categorized an expense. You’ll set it up the first time and it’ll always be correct after.

Reconciling Inventory on Amazon & Filing Claims

Keeping track of your inventory on Amazon can be a stressful task. Amazon delays reports anywhere from 24 hours to a week, so knowing your exact inventory level can be difficult. In this section, we’ll go through some tips for checking your inventory status on Amazon.

If you use SellerZen, we’ll reconcile your Amazon and QuickBooks inventory. Any discrepancy between QuickBooks and Amazon means that Amazon has yet to reimburse you for it. You should be filing reimbursement claims for these if the loss or damage occurred more than 30 days ago.

FBM sellers don’t have many reimbursement cases because they store, handle, ship, and refund on their own. Sellers can file for reimbursement claims for Item Not Received claims if they’ve purchased shipping through Amazon. They can also file reimbursement claims for cases where customers exchanged items, though Amazon has become more strict about these claims.

Amazon Inventory Reconciliation Report

Amazon delays the inventory reconciliation report in the image above by a week. But you can run reports like the refund, customer return, and inventory event detail report for current information. You should reconcile these two factors:

  • “Inventory Received” should match what you sent in
  • Lost and Found numbers should match

If the inventory received doesn’t match what you sent in, then look at the FBA shipments report. Confirm that they received what you sent in. Otherwise, you’ll have to investigate and open any cases regarding the discrepancy. If the lost and found numbers don’t match, then you’ll have to look at the Inventory Adjustment report. Amazon may have already reimbursed you, so remember to check your reimbursement reports for that particular SKU.

Requesting claims for customers Amazon refunded but who haven’t returned items

FBA sellers should look at their Inventory Reconciliation report. You can find this under Reports > Fulfillment. This report is delayed by a week, but you can look up any necessary information through other reports: Inventory Event Detail filtered by Shipments will tell you of any inventory sold, while a Payments > Transaction View report will show you refunds.

Amazon Refunds Screen

Compare the refunds here to what customers have returned under Reports > Fulfillment > Customer Returns. Make sure Amazon hasn’t already reimbursed you for these cases. Customers have 30-45 days to return the item.  If the refund is fairly recent, you’ll have to check back later.

The easiest way to find out whether Amazon owes you for failed customer returns is to download the refund report, the return report, and the reimbursement report.

Copy and paste the Order ID column from the refund report into one column on a new worksheet. Then copy and paste the Order ID column from the returns and reimbursement report into another column. Use conditional formatting to match and highlight or delete matching values in each column. You can download an add-on in Google Sheets to do this for you as well. Investigate the remaining order IDs on the refund column since customers haven’t returned those and Amazon hasn’t paid you.

You should open a case for any refunds with no returns past 30 days once you’ve checked Amazon reimbursements.

Requesting claims for lost or damaged warehouse items

Another common reimbursement scenario is inventory that Amazon workers have lost or damaged at the warehouse. You can find these under Reports > Fulfillment > Inventory Adjustments. Enter your SKU and look at the inventory adjustments. The balance should be zero between the misplaced and found inventory. Be sure to view the reimbursement report to confirm before you file a claim.

Amazon Inventory Adjustments Screen

Filter by “Damaged” to see any damaged inventory at the warehouse. You’ll see these possible reasons under the reimbursement report. You should open a case for any inventory that Amazon has damaged and not reimbursed after 30 days. Reimbursements with inventory instead of cash show up as “Transfer from holding account.” “Transfer to holding account” usually happens when Amazon damages inventory, moves it to your unfulfillable inventory, and then to its own holding account.

Reimbursement Reason

It’s not easy keeping track of all your inventory on Amazon. There are numerous cases where Amazon has lost or damaged inventory and has never reimbursed sellers. Amazon may owe some sellers thousands of dollars for lost and damaged products. Amazon also reimburses for out-of-policy refunds. Sellers should monitor their accounts regularly in order to catch these reimbursements and get their money.

Sales Tax

Sales tax has become much more complex for Amazon 3rd-party marketplace sellers in 2018. Amazon began collecting and remitting sales tax for certain states, and this is certain to expand to other states in the near future. These taxes show up on orders as the Marketplace Facilitator Tax. This new tax has been the cause of some confusion for many sellers. Because this tax shows up on the sales order, Amazon sellers must have some way to record it.

In this section, we’ll go over how sellers can document what Amazon collects and pays as evidence for states. This is particularly important if sellers later need the documentation for their accountant or for the state tax boards. Read more about how SellerZen handles this tax.

As of July 2018, Amazon collects and remits sales tax for three states: Oklahoma, Pennsylvania, and Washington. To accurately process invoices, you’ll have to configure Sales Tax in QuickBooks Online for those states. This is necessary because QuickBooks Online creates the proper liability accounts when you create a sales tax rate. The sales tax Amazon collects for the Marketplace Facilitator Tax should be deposited to a bank account that you use to offset the sales tax liability accounts for the states.

QuickBooks Online Sales Tax

To summarize, sellers will have to configure tax rates for the affected states in QuickBooks Online. Sellers also have to create a bank account to offset the liability accounts QuickBooks creates for sales tax. Sellers will also have to create a Marketplace Sales Tax service item that they’ll link to the offset bank account. Doing all of this will allow sellers to properly account for the Marketplace Tax.

If the Marketplace Sales Tax exists, sellers will use the Marketplace Sales Tax service on the invoice. All money collected for this tax is then deposited into the offset bank account. Ultimately, you’ll use the Marketplace Tax bank account to reduce the balance on the sales tax liability accounts.

Other Transactions

Once sellers have configured all of the product, service, and account items, they’ll still need to deal with the non-order transactions. These transactions can include expenses like storage fees and reimbursements for damaged warehouse inventory. Some sellers will want a detailed breakdown of these expenses, whereas other sellers want them lumped into one account. You should talk to your bookkeeper to see how to organize and categorize these expenses for your business.

Many sellers don’t enter these transactions individually since they take so much time to organize properly. That’s because you’ll have to look through the settlement, create the proper QuickBooks document, and make sure they go into the right accounts. Chances are they’re lumping all the fees and expenses instead.

Using SellerZen, you can choose which accounts you want for these transactions. We’ll automatically handle it for you every settlement.

For the settlement transaction mapping in SellerZen, we recommend that you separate some of the expenses. You should map expenses like inbound shipping, storage fees, and reserve amounts so that you’ll know what these are. A high storage fee alerts you to slow items while knowing your reserve amount can help you plan purchases.

When you map your reserve amounts to one account, you’ll know what to expect if you request payment earlier. Otherwise, we’ll put the transactions into the income or expense account depending on the transaction type.

SellerZen Mapped Settlement Transactions

Watch our video about how to map specific transactions like reserve amounts or read more about the fields under the Settlement tab.

Customer List

Unlike traditional brick and mortar retailers with customers who live nearby, Amazon customers come from all over the world. And they are loyal to three values when it comes to shopping: price, quality, and shipping. That’s why having the lowest price, the highest reviews, and the Fulfilled by Amazon tag are such important factors in a product’s success on Amazon.

This also means that a list of Amazon customers in QuickBooks isn’t as important as it would be for a traditional retail store. Not only is a list not as important, many customers can and do disable messages from sellers. In the past, sellers bombarded buyer emails with automated emails to get reviews, prompting customers to disable all messages from sellers.

That’s why we highly recommend that sellers use a default customer per marketplace. If you use this option for SellerZen, you’ll still be able to search for information in the shipping address field. But your customer list won’t have tens of thousands of customers that will slow down your QuickBooks performance. With a massive list of customers, search functions and reports take longer.

Default Customer List

Even if you keep individual customer names and information, you’ll eventually get a lot of customers with the same name. You’ll need to distinguish them somehow, like using John Doe 1, John Doe 2, and John Doe 3. If you enter invoices manually, using a single customer account for each marketplace will save you some time as well.

Conclusion – Amazon to QuickBooks Integration

At SellerZen, we believe in empowering businesses with tools that will help them succeed and thrive. Automating data entry from Amazon to QuickBooks frees your employees from performing mundane, repetitive tasks. Your employees can then focus on other aspects of your business, like sourcing and sales. You’ll have the peace of mind knowing that your company’s financial data is secure and that your accounting is accurate. You’ll also save money from having to pay a bookkeeper thousands of dollars to sort through your Amazon account.

But perhaps the most powerful feature is that an up-to-date set of books allows you to run crucial reports. If you don’t consistently keep track of your sales, you could be losing money on several SKUs. You could never know because your only insight into your business is the settlement summary. But many sellers don’t even look closely at their reports or individual sale. Instead, most sellers are content knowing that their settlement net income is positive even if they’re losing hundreds or thousands of dollars on some SKUs.

You could be losing money on some SKUs, or your margins could be so low that it’s no longer worth the labor involved in sourcing, managing, and selling those items. Read more about SellerZen’s layout to see at a glance whether or not some items are losing you money.

One of the biggest obstacles to a company’s growth is the lack of manpower. There’s only so much one person can do on his own. The cost of hiring and training an additional employee can be prohibitive for most small businesses. That’s why automation can be a vital tool for streamlining processes and improving profit. Using SellerZen, you can integrate your Amazon and QuickBooks Online accounts and focus on selling and growing.

 

SellerZen List of Amazon Integrations, Apps, and Services

At SellerZen, we’re often asked about other Amazon tools and services. Once you’ve automated your data entry process with SellerZen, you may be motivated to improve other aspects of your business to free up even more time. To that end, we’ve compiled this list of tools and services that Amazon sellers can use.

If a service is missing from this list or you’d like to recommend one that you use, contact us at info@sellerzen.com.

SellerZen is not affiliated with any of these services, nor does SellerZen endorse any of these services. We’ve created this list only for informational purposes, so do your own due diligence before you sign up with any services listed in this article.

Table of Contents

3PL Services (Store, Prep, Ship, Inspect)

Accounting

Articles (by SellerZen relevant to these topics)

Financing

Inspections

Inventory

Launch Services

Marketing & Advertising

Other Services (Analytics, Multichannel Order Management, Tool Suites, and more)

Price Scanning Apps

Product Research

Refunds & Reimbursements

Repricers

Reverse Logistics

Sales Tax Services

Shipping Integrations

Ungating Services

3rd Party Logistics (3PL) Services

These businesses offer a range of services that may include: Imports, Preparation, Ship, Inspection, Photography, and Storage. We’ve included the city and state whenever possible so that you can locate the service closest to you if the location is important.

3P Shipping or GyftGo (same website and contact info) – South Farmingdale, New York

3PL Center – Edison, New Jersey and Simi Valley, California

3PLGuys – Paramount, California

Akses FBA – Whittier, California

Amazon Prep Canada – Waterloo, Ontario

Amazon Prep Services – Canada

American eBox – Miami, Florida

AMS Fulfillment – Valencia, California

AMZ Importers – Huntsville, Alabama

Arbsmart – Heightington, Bewdley (UK)

Atlantic Fulfillment – Newport, North Carolina

ATRFulfillment – Raleigh, North Carolina

Automated FBA – Perris, CA and Berlin, Connecticut

Best Logistics Global – Chino, CA and Jamesburg, New Jersey

BGI Worldwide Logistics – Signal Hill, California

Big Sky Prep & Ship – Roundup, Montana

Buckeye Prep 2 Prime – North of Cincinnati, Ohio

Brown Box Ninja – Hubbard, Texas

Build Industries – Sylmar, California

California FBA Prep Service – Lincoln, California

Central Ohio FBA Prep & Ship – Ohio

Central Wisconsin Prep Pack & Ship – Greenwood, Wisconsin

China Purchasing Agent – Shenzhen, China

Corten Logistics – London, England

Direct Station – Hong Kong, China and Mt. Laurel, New Jersey

EastCoast-Direct – Abington, Massachusetts

eHub Solutions – Yorba Linda, California

Evolution Fulfillment – Vancouver, Canada

EZ Prep – Cerritos, California

FBAchiever – Shenzhen, China

FBA Bolt – Hanover, Maryland

FBA Express – Hanover, Massachusettes

FBA FlexPrep – Pearland, Texas

FBA Indiana Prep – Portland, Indiana

FBA Inspection – Fort Bragg, California

FBA Ops – Guangzhou City, China

FBA Prep Australia – Pinkenba, Queensland (Australia)

FBA Prep and Ship – Harrisburg, Oregon

FBA Prep Poland, EU – Kutno, Poland (European Union)

FBA Sourcing China – Shenzhen, China

FBA Strategies – Pensacola, Florida

FBA Terminal – Passaic, New Jersey

FBA Transport – Sarasota, Florida

Forest Shipping – Jersey City, New Jersey and Shenzhen, Guangdong (China)

FWD To Amzin – Ottawa, Ontario (Canada)

Illinois Pack & Ship – Springfield, Illinois

Imaginari – Waynesboro, Virginia

Indy Prep – Noblesville, Indiana

KC Prep and Ship – Roundup, Montana

Kitting & Assembly Solutions – Westminster, Colorado

LDR Prep – Cincinnati, Ohio

Leeline Sourcing – Shanghai, Yiwu, and Shenzhen, China

McKenzie Services – Hillsboro, Oregon

MarksmanRSC – Ohio

MI FBA Prep – Lapeer, Michigan

Midwest Prep Center – Chicago, Illinois

Midwest Prime Prep and Ship – Duluth, Minnesota

MT Prep ‘n’ Ship Pro – Roundup, Montana

My Fulfillment Team – Dresden, Tennessee

My Prep Center – Oxford, Michigan

New York Fulfillments – New Windsor, New York

One Prep Direct – Cazenovia, NY and Claremont, New Hampshire

Oregon Buy, Prep and Ship – Sisters, Oregon

Out West Prep Services – Tillamook, Oregon – full

PacEast Logistics – Chicago, Illinois and Detroit, Michigan

Pacific Prep Services – Hillsboro, Oregon

Phase V Fulfillment – Fort Myers, Florida

Phoenix Package Shipping & Logistics – Franklin, Tennessee

Prep Gurus – Plainfield, Illinois

Prep and Pack – Virginia Beach, Virginia

Prep It! Pack It! Ship It! – Oceanside, California

Prep Label Box – California

Prep Ninjas – Eugene, Oregon

Prepped Express – North Little Rock, Arkansas

Prime Zero Prep – Salem, New Hampshire

Priority Prep – Tyler, Texas

Profit Gopher – Marietta, Georgia

QCADVISOR – Hong Kong, China

QC Fulfillment – Charlotte, North Carolina

River Source Logistics – Los Angeles, California

Selltec Prep – Montana

ShipMonk – Deerfield Beach, Florida

ShipOnTime (formerly FBA Warehousing) – Henderson, North Carolina

Simpl Fulfillment – Austin, TX

Simple Price Prep – Georgia

Sunny Prep – Kissimmee, Florida

Swan Packaging Fulfillment – Wayne, New Jersey

Tax Free FBA Prep Services – Montana

Texas Prep Pack & Ship – Grand Prairie, Texas

Truckmen – Geneva, Ohio

Ultimate Packers – Newburgh, New York

Value Prep and Ship – Sacramento, California

Verde Fulfillment USA – Boise, Idaho

WeFulfillIT – Toledo, Ohio

Worldwide Fulfillment – Florida

Back to top

Accounting

Common accounting software used by small to mid-size businesses in the United States.

Bench

FreshBooks

GoDaddy Accounting – Cash Basis Only, Single-Entry Bookkeeping Only

Kashoo

QuickBooks Online

Pilot

Sage 50c

Wave

Xero

Zoho Books

Back to top

Articles

Where to source products to sell on Amazon and eBay

6 Shipping integrations for Amazon, eBay, & other marketplaces

6 Texas 3PL FBA Prep and Ship Companies

7 Chinese 3PL FBA prep and ship services

8 third-party UPC barcode vendors

8 totally free ecommerce store solutions to sell online now

9 California 3PL FBA prep and ship companies

15 classifieds marketplaces to sell your used goods

Chinese inspection companies to inspect your products in China

Etsy alternatives for artists to market their work

Free image editors for your Amazon images

Free stock photographs and images for commercial use

Online B2B Marketplaces like Alibaba

See 9 different marketplaces for new products and their fees

Back to top

Financing

Please make sure you read the fine print and do your research before you commit to any service on this list.

Amazon Lending – Invite Only

AMZ Seller Financing – broken link

BlueVine

Fundation

Fundbox

Headway Capital

Kabbage

LendingClub

Lendvo

OnDeck

Payability

SellersFunding

Street Shares

UpFund.io

Back to top

Inspections

These services are based in China and may offer more than just product inspection. They may offer factory audits, laboratory testing, or even certification. Other services include product sourcing as well.

Alibaba Inspection

Asia Inspection

Asia Quality Focus

BridgeNova

Bureau Veritas

China Inspection Service

Cotecna

Effition Inspection

FBA Ops

InTouch Inspection

Kistop Inspection

NBN Inspections

QC-I

Shenzen WenXin Import & Export

V-Trust Inspection Service

Back to top

Inventory

These services offer inventory forecasting, management, and reports, amongst other services.

Ecomdash – Multichannel Inventory Management

forecastly – Predictive Analytics and Demand Forecasting

Orderhive – Order, Shipping, and Inventor Management

Stratify – by InventoryLab – Research, List, Accounting, Inventory, Reports

Quantify – by SellerseLabs – Profit and Inventory Reporting

RestockPro – by eComEngine – Inventory Forecasting and Other Tools

SalesDash – FBA Inventory Management Software

Solid Commerce – Inventory and Order Management

SellerExpress – Multichannel Inventory Management

Teikametrics – FBA Inventory Management

tradegecko – Inventory Management Software

Veeqo – Omnichannel Inventory and Order Management

Back to top

Launch Services

If you have a new product you want to launch, these services may help. They may offer email follow-ups, heavy discounts to encourage reviews, and other strategies to gain ranking for your product.

FirstPage.one

JudoLaunch

JumpSend

Launch List Formula

RebateKey

Vipon

Viral Launch

ZonBlast – by SixLeaf

ZonJump

Back to top

Marketing & Advertising

These services help with listings, optimization, or PPC. Some services categorized as Repricers or under Other Services may also offer similar services. Visit the website for more information.

Adbadger – PPC

Asteroid Aim – Product Photography, Optimization

Bindwise – Listing, Hijackers

AMZAlert – Monitor and Protect Product Listing

AMZmailer – Email Manager

BrandBuilders – Website and Content Creation

Efficient Era – PPC, Marketing, Email Automation (closed July 4, 2019)

Feedback Genius – by SellerLabs

Feedback Whiz – Feedback, Product Reviews, Automated Emails

Feedback Express – Email Manager

FeedbackFive – by eComEngine

Feedbackz – Email Manager

GenVideo – Videos

HappySeller – Monitor, Management, Hijacker and Product Alerts

Jungle Hustle – Product Photography, Copywriting

Kenji ROI – Listing Optimization

Kibly – Boost Sales, Feedback, Reviews, and Rankings

Listing Eagle – Hijacker and Suppression Notification

Merchbee – Email Manager, Boost Reviews, and Other Tools

my seller pal – PPC

overGrowth – Marketing and Sales Suite

PPC Agility – PPC

PPC Entourage – PPC

PPC Scope – PPC

Prestozon – PPC

Salesbacker – Email Manager

SatiSupp – EU Marketing Services, Translations

Seller Lift – Feedback Manager

Sellozo – Ad Management, PPC

SentryKit – Hijacker and Product Alerts

Splitly – Listing Optimization

Teikametrics – PPC, Listing Optimization

Back to top

Other Services

These businesses generally offer a suite of tools. Visit the websites for more information.

AccerlerList – Listing, Account & Business Visualization, and Automated Inventory Insights

AMZPing – Business Dashboard

appath – Multichannel Order Management

Appbot – Monitor, Analyze, and Export Amazon App Store Feedback

Brightpearl – Multichannel Order Management

Cashcowpro – Suite of Tools

Contalog – Omni Channel Digital Commerce Platform

eGrowth Partners – Suspensions

epinium – Analytics and SEO

FBAFrontiers – FBA Caculator linked, help with launching in UK

Hello Profit – Analytics

Jazva – Multichannel Order Management, Listing

Jungle Market – Amazon Freelancers

Linnworks – Order Management

Listtee – Listing Software

Manage by Stats – Seller Tools Suite

One Hour Translation – Translation Service for Listings

Quantify Ninja – Optimizer, Analytics, Automated Messaging

Sellbrite – Multichannel Selling Software

SellerLegend – Analytics

Seller Active – Multichannel Order Management

SellerCare – Amazon Suspension Reinstatement Service

Sellics – Suite of Tools

Stitch Labs – Suite of Tools

Skubana – Multichannel Order Management and ERP

SkuVault – Inventory and Warehouse Management

SupplyKick – Buy, List, Sell, and Ship Inventory

The Phifer Group – Translations, Listing Optimization

Thompson and Holt – Suspensions, Seller Suspension Insurance

Trendosaur – Product Research

Vendio – Listing, Management, Multichannel Sales

Back to top

Price Scanning Apps

These are scanning apps to help you source items and check prices and other information on Amazon.

A Seller Tool – FBAScan

Amazon Seller App on iTunes or on Android – by Amazon

Neatoscan

Profit Bandit – by SellerEngine

Scan Power

ScanLister

Scoutify – by InventoryLab

ScoutIQ

ScoutPal

Back to top

Product Research

These services will help you with product research. They may include search, keyword, and review analysis, as well as other services. We may not have listed all the products or tools provided by each service. You can visit the websites to find out more.

Amachete – Profitability Estimator, Rank and Inventory Tracker

Amalytix – Analytics, Keyword Rankings, Reviews and Feedback

AmaSuite – Top Product, Search, Keyword, and Review Analyzer

AmazeOwl – Product Research

Amazooka – PPC, Auto Responder, Product and Keyword Monitor, Product Launcher

AMZ Base – Product Research Tool – broken link

AMZ Insight – Niche Analyzer, Product Tracking, Keyword Ideas and Rankings, and Review Manager

AMZ One – Keyword Tracking, Sales Rank, Sales Tracking, Negative Reviews Notification, Product Promotions

AMZ Scout – Keyword Explorer, Revenue Estimates, Sales Rank

AMZ Space – Keywords Ranking, Product Scout, Auto Responder, Profit Calculator – now Quantify Ninja

AMZ Tracker – Keyword Research, Competitor Analysis, Keyword Tracking, Negative Review Alerts

AMZfoster – Product Research and Optimize Listings – now FosterFBA

AMZShark – Sales Tracker, Niche Scout, Keyword Explorer, Search Rankings Tracker, Listings Scout, Hijacking Alerts

Asinhunt – Product Tracker

ASINspector – Product Research

AZanalyzer – Product Research

BlackBird – Product Research

Catsnatcher – Niche Analyzer

CamelCamelCamel – Price Tracker and Price History

DataHawk – Amazon Analytics, Market Research

DS Amazon Quick View – Chrome Extension

eComSpy – Market Research Tools

Egrow – Product Research

FBA Toolkit – Sales Rank, Price List Analysis, Product Tracking

FBA Wizard – Product Sourcing

indbl – Product Research Tool

Jungle Scout – Product Research

Helium 10 – Product Research, Refunds, Listing Optimization

Keepa – Amazon Price Tracker

Keyword Inspector – Keyword and Amazon Tool Suite

Keyword Tool – Find Keywords

Keyword Tool Dominator – Long-tail Keywords

Keyworx – Keyword Tracking

MerchantWords – Keyword Tool

NovelRank – Tracker for Books

Price Checker 2 – Wholesale Product Research

SalesRankExpress – Tracker for Books

Seller Spirit – Keyword Research, ASIN, Reverse ASIN

SellerApp – Product Research

SellerMetrics – Keyword Research and Tracking

Sellers Toolbox – Suite of Tools – Product Research and Keyword Research

Scientific Seller – Free Keyword Tool

Scope – by SellerLabs – Amazon SEO and Product Research

Sonar-tool – by Sellics – Amazon Keywords and Merchant Words Research

Tactical Arbitrage – Product Sourcing

Trendle – Keyword Ranking, Review Alerts, Analytics

Unicorn Smasher – Product Resarch Tool

WordTree.io – Keyword Research

ZonGuru – Amazon SEO Tool Suite, List, Optimize, Alert, Track

Back to top

Refunds & Reimbursements

Be careful about automatic reimbursement submissions. Amazon has warned and suspended accounts in the past for submitting numerous inaccurate reimbursement requests.

AMZ Refund

FBA Audit

FBA Auditor

Refund Genie – by Helium 10

Refund Retriever

Refund Sniper

Refunds Manager

RocketRefunds

Seller Bench

Back to top

Repricers

Some repricers offer additional services as well. Services after the hyphen are also offered by the website.

Alpha Repricer

BQool – Feedback and Review

ChannelAdvisor – Suite of Tools and Services

ChannelMAX

ePrizer

Feedvisor – Business Reports

Informed.co – formerly Appeagle –

logicsale

Pricing Lab

RepriceIt

RepricerExpress

SellerActive – Channel and Order Management

Seller Dynamics – Multichannel Software, Listings, Order, and Fulfillment

Seller Republic

Seller Snap

Sellery – by SellerEngine – Profit Bandit and SellerEngine Plus

Solid Commerce – Inventory and Order Management

Wiser – WisePricer

XSellco – Helpdesk and Feedback

Back to top

Reverse Logistics

These companies work with your returns. They may inspect, refurbish, repackage, and resell your customer returns.

Extron – Milpitas, California

MarksmanRSC – Ohio

ModusLink – Waltham, Massachusetts

Returnbase – California

Returns Management, Inc.  – Buffalo Grove, Illinois

Reverse Logistics Group Americas – Iselin, New Jersey and Fremont, California

Back to top

Sales Tax Services

These services will help you with your sales taxes.

AccurateTax

Amazon VAT Services

Avalara

SimplyVAT – For VAT compliance

Taxify – by Sovos

TaxJar

Back to top

Shipping Integrations

Ordoro

ShippingEasy

Shippo

ShipStation

ShipWorks

Stamps.com

Back to top

Ungating Services

Amazoker

Amazon Category Approval

AMZ Ungating

AMZGates

Get Ungated Now

SellerEngine Ungating Services

TheFunnelGuru

Ungate Category

Ungating Amazon

Back to top

last edited March 7, 2020

How SellerZen handles Amazon Marketplace Facilitator Tax in QuickBooks Online

Updated April 27, 2019

Several states passed Marketplace Facilitator Tax laws in 2017. These set of laws shifted the burden of sales tax collection from individual sellers to marketplace facilitators. What is a marketplace facilitator? Amazon states:

A Marketplace Facilitator is defined as a marketplace that contracts with third party sellers to promote their sale of physical property, digital goods, and services through the marketplace.

Learn more about the states that have passed similar legislation from Amazon’s Marketplace Tax page.

Even though 3rd party sellers won’t have to collect and remit sales tax to the states that have passed similar legislation, they still have to account for what Amazon collects and remits.

This accounting will serve as evidence that sales tax has been received and paid for Amazon sales in those states. You should still consult with your accountant regarding your tax situation even though Amazon collects and remits on your behalf. If you want to see available sales tax services, visit our list of Amazon tools and services.

Here’s how SellerZen handles the Marketplace Facilitator Tax

Even though sellers never receive sales tax collected by Amazon for marketplace taxes, SellerZen still records these transactions to an account.

Since Amazon credits and debits the tax amount on the invoice, SellerZen will do the same thing for documents imported to QuickBooks Online. As a result, the Marketplace Facilitator bank account will always have a balance of $0.00.

Sellers will need to create a Marketplace Facilitator Tax bank account (Type: Bank and Detail Type: Cash on hand) and a service item called Marketplace Facilitator Tax that is linked to the Marketplace Facilitator Bank account.

Sellers can run a report on this bank account to see all transactions with marketplace taxes, or they can export the report and sort to see the amounts for each state.

Why is this important?

Having a record of the marketplace tax transactions is important. With the service item and bank account, QuickBooks Online sales transactions will accurately reflect sales documents on Amazon.

The Wayfair ruling means that more and more states will eventually require marketplaces like Amazon to collect and remit sales tax.

While that’s an additional source of revenue for the states, it means increased costs for marketplace sellers to comply with the new laws. It’s uncertain now whether Amazon will collect and remit for all states for a fee or if sellers will have to seek out services and solutions. The only certainty is that consumers will have to pay more not just because of sales tax, but also because of increased costs born by merchants for compliance.

Need a step-by-step guide to QuickBooks Online accounting for your Amazon orders? Check out our Amazon to QuickBooks Online accounting series:

SellerZen at a glance: Understanding SellerZen’s layout

Now that you’ve signed up for SellerZen, you may be wondering how our platform works. SellerZen’s layout displays all the information Amazon sellers want to know. And the best part is all that information is searchable using our platform, so you can quickly search for transactions using SellerZen without having to go to different Amazon reports.

Take a look at a screenshot of our Order page below.

SellerZen Order Page

The filter menu allows you to show or hide search functions. You can use this page to search Order IDs, customer names, or any other information on the invoice. Want to search for a customer name? A specific date? Show all orders for a particular SKU? You can search all of that and more through SellerZen. Even partial searches will return results.

The Order page also displays all of your orders, including pending orders. When those orders are shipped on Amazon, we’ll update the order on our platform and create the payment in QuickBooks Online. Click on View to see all of the line items for that invoice. We also include the Cost of Goods and your true profit here if you have that entered into QuickBooks Online.

The numbers on the far right of the row tell you what you’ve earned on that particular sale. If you’ve entered the cost of goods in QuickBooks Online, SellerZen will include that cost in the calculation and display your actual profit. If you haven’t added the cost in QuickBooks Online, then we’ll give your earnings on that sale.

With a cost of goods entered in QuickBooks Online, you can quickly scan your orders for the profit on every invoice. You’ll be able to quickly identify which products are profitable and which are losing you money. Having this knowledge will allow you to make more informed decisions. Drop unprofitable products and low-margin products. Or increase prices so that those items become worthwhile. You can also remove inventory that is not only losing you money per sale but also costing you in FBA storage fees and limits.

The status icons give you a visual of the order status at a glance. The green dollar sign tells you that the order has been paid. The green truck icon shows you that the order has shipped. Finally, the green checkmark icon tells you that we’ve imported the order into QuickBooks Online. The icons would be grayed otherwise.

On the Refunds page, you may see some red truck icons. These are customers who have been issued refunds but have yet to return items. If you haven’t been reimbursed for these orders after 30 days, then you should request a reimbursement.

SellerZen Refund Row

The FBA order from above was refunded on September 6, 2017, but the customer has never returned the item.

SellerZen Reimbursement Row

On the Reimbursements page, you can search by Order ID to see if and how you’ve been reimbursed. Notice in the example above, Amazon has reimbursed cash for the order where the customer failed to return the product. Sometimes, Amazon will compensate you with inventory. Regardless, SellerZen will create the proper QuickBooks Online documents to keep your accounts and inventory reconciled.

Using SellerZen has a host of benefits outside of automated data import and accounting. Configured correctly, you can use our service to quickly search your transactions for orders, refunds, and reimbursements instead of having to dig through numerous Amazon reports. And with the right account setup, you can use our service to run a detailed and accurate profit and loss report in QuickBooks Online.

QuickBooks Profit and Loss Report

Don’t want to split up certain fees like Sales Tax Collection Fees and Refund Administration Fees? You can choose to lump them together into one general Amazon Fees account. You can decide what level of detail you want with SellerZen. The best part is that you won’t have to ever worry about settlement reconciliation again since SellerZen automatically reconciles each settlement with the transactions for that period. That means you won’t have to spend hours looking for a transaction or checking that the numbers were entered correctly.

Having to manually process all of your Amazon transactions becomes an impossible task once you go past a certain number of sales. You can’t possibly track every single transaction on Amazon manually, and let’s face it: most sellers don’t after awhile. They become content with just using the settlements, but even that doesn’t give you the overall health of your business. You could be losing money on a handful of your products and you’d never know.

SellerZen automates the entire data entry process. Once configured, SellerZen will take over the tedious task of data entry, and we’ll import all of your documents accurately every time. You no longer have to stress out about entering transactions into QuickBooks Online. So sign up for SellerZen and sit back and relax. We’ll take care of the data entry for you.

Tips for Using SellerZen and QuickBooks Online Integration

Once you’ve configured SellerZen with your QuickBooks Online account, then use these few tips to make the most out of our service.

Tip 1: Showing Order IDs on the Sales tab in QuickBooks Online

Want to view the Order ID for your invoices and other transactions? Click on the Gear icon and then check the “Memo” field. Checking this box will display the Memo field, which contains the Order ID.

If you’re going to search by Order ID on QuickBooks Online, then you’ll have to use an Advanced search. Filter by the “Memo” field and type in the Order ID.

Tip 2: Showing True Profit Per Invoice on SellerZen

Calculating your true profit per invoice is a difficult task, and Amazon doesn’t make it easy. Most sellers assume that each sale is profitable. But this may not be correct if a repricer is incorrectly configured or prices are continually being lowered to win the Buy Box. SellerZen will show you the profit per invoice on your Orders page if you have the Cost entered in the QuickBooks inventory. You’ll need the Plus subscription with inventory tracking/pricing enabled in settings.

SellerZen Order Profit

You can also view a detailed breakdown of the sale by clicking on the Order ID. Using SellerZen, you can see at a glance the profit per invoice.

SellerZen Invoice

Now with a quick glance at the Profit column, you can see any invoice and inventory item that is costing you money.

 

Tip 3: Search by Order ID, customer name, or item on SellerZen and then click on “View” to see the document in QuickBooks Online. Partial searches are also allowed

Tired of having to use Amazon to search for information? Use our search function to search for partial or full customer names, order IDs, and more!

SellerZen Filter

Tip 4: Run a Profit & Loss Report see all of your income and expenses, broken down into detail depending on how you mapped the transactions

Once you’ve assigned the non-order transactions under the Settlement tab, you can run more detailed reports that give you a better picture of your finances in QuickBooks Online. Take a look at a sample report below using custom transaction mapping.

QuickBooks Profit and Loss Report

If you need help creating these accounts, feel free to ask us with using the chat icon on the bottom right of the screen.

Tip 5: View FBA returns and reimbursements on SellerZen

Using SellerZen, you can easily see which orders have never been returned to you using the green and red truck icons. The green truck icon means Amazon has received the return. A red truck icon indicates Amazon has not received the product.

SellerZen Sample Refund

If customers receive a refund a don’t return your item, then you should receive a reimbursement from Amazon. If you haven’t been reimbursed after 45 days, then you can request one.

Tip 6: View Reimbursements on SellerZen

Get an overview of all Amazon reimbursements on SellerZen. Click on Inventory Adj > Reimbursements to see how you’ve been paid.

SellerZen Inventory Adjustments

In the example above, you’re able to view the Reimbursement document as well as the Cash or Physical quantity reimbursed. If you’re reimbursed inventory, then we’ll make the proper adjustments to your QuickBooks Online inventory.

Combine these 6 tips with using shortcuts in QuickBooks, and you can be saving yourself some valuable time every day!