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.
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.
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.
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.
When you create a new inventory item in QuickBooks Online, you’ll see the following fields.
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.
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 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.
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.
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.
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 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.
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.
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.
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.
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.