Amazon to QuickBooks Online Accounting: Configuring Sales Tax and Marketplace Facilitator Tax
- By Hung Truong
This step-by-step guide will show you how to set up sales tax in QuickBooks Online from a brand new company.
If you’re not careful, sales tax collected through Amazon may be different from the sales tax calculated in QuickBooks Online. You’ll want to make sure that invoices you create in QuickBooks Online display the correct sales tax collected. Otherwise, your accounts may not reconcile properly.
- Set up QuickBooks Online Sales Tax with new Automated Sales Tax engine
- Set up QuickBooks Online Sales Tax with standard sales tax engine
- Configuring QuickBooks Online Marketplace Facilitator Tax service item and bank account
- Sample QuickBooks Online invoice with Marketplace Facilitator Tax and Tax Override
- Other articles in our Amazon to QuickBooks Online Accounting Series
Setting up Sales Tax in QuickBooks Online with new Automated Sales Tax
QuickBooks Online’s new automated sales tax engine makes configuring sales tax very simple for users. Users no longer need to manually configure districts or city taxes. Instead, just enter the state and filing frequency, and QuickBooks Online will take care of the rest!
Look through this visual guide for setting up QuickBooks Online Sales Tax.
If you’re collecting and remitting sales tax for your state, select the filing frequency and start date. When you pay, you’ll select your Bank account that you used to pay your sales tax liability.
We’ll add an additional sales tax agency as an example. The process is the same for any other sales tax agency. Select the filing frequency and start date.
When you have an invoice with sales tax to any state, overwrite what QuickBooks automatically enters with the amount that Amazon collects if the two amounts are different. We’ll go over how to do this below.
Setting up Sales Tax in QuickBooks Online with Standard Sales Tax
Some users will be presented with this screen to switch to the new automated sales tax engine used earlier in this article. We’ll continue with the old tax center.
Add any additional states you need. Use the general state sales tax rate for each state you set up unless you want to manually set up the combined tax rate.
When you have an invoice with sales tax to any state, overwrite what QuickBooks automatically enters with the amount that Amazon collects if the amounts are different. We’ll go over how to do this below.
Setting up QuickBooks Online Service Item and Bank Account for Marketplace Facilitator Sales Tax
Once you’ve configured sales tax agencies for your QuickBooks Online company, you’ll need to set up a Bank account (Detail type: Cash) for the Marketplace Facilitator Tax.
To do this properly, you’ll have to create a Marketplace Facilitator Tax service item linked to the Marketplace Facilitator Tax bank account.
Once you’ve created the service item linked to the bank account, you’ll select this Marketplace Facilitator Tax service item as the line item on your affected invoices.
Once you’ve created the bank account, you’ll need to create the service account that links to this account you’ve just created.
Make sure the “Is taxable” box is not checked.
Once you’ve saved the service item, you can now select this item for both your Marketplace Facilitator Tax Shipping and Marketplace Facilitator Tax Shipping. For invoices that have taxes on sales and shipping, sellers can choose to sum up those taxes into one line item. Or sellers can use the same service item twice with the different amounts.
Another option is to create separate service items for Marketplace Facilitator Tax Principal and Marketplace Facilitator Tax Shipping. If you choose to do this, then link them both to the same Marketplace Facilitator Tax bank account.
Some sellers will want this level of separation, but it’s not really necessary since taxes are deposited to and paid from the same offset bank account.
What’s important is that the amounts are correct whatever option you choose. When you create the invoice, the amounts will be properly deposited into the right accounts.
Example of QuickBooks Online Invoice with Marketplace Facilitator Tax
Here’s how all of this works in QuickBooks Online with an Amazon invoice. We’ll create a QuickBooks Online invoice with Marketplace Facilitator Sales Tax collected.
Once you’ve entered the amounts in the invoice, double check that the sales tax that QuickBooks Online automatically calculates is correct. If it’s correct and all the numbers are correctly entered, save the invoice.
Marketplace Taxes won’t affect any of your accounts since any amount deposited is also withdrawn to reflect what Amazon does.
You can always run a report on the Marketplace Facilitator bank account.
Save the invoice and make sure to receive payment if you’ve already shipped the item or if it’s an FBA order.
Congratulations! You’ve successfully configured sales tax in QuickBooks Online. You’ve also accurately recorded the sales tax that Amazon collects for its Marketplace Tax!
It’s important that you track sales tax even when you’re not the one collecting and remitting it. Using an accounting software like QuickBooks Online track sales tax means that you’ll always have a record in the event you need it.
You can automate all of the document creation for your Amazon seller account. SellerZen automatically imports all transactions in real-time so that your QuickBooks Online company is always up-to-date. Give us a try for free now!
Learn more about other bookkeeping topics through our articles on accounting for Amazon businesses:
- Amazon to QuickBooks Online Accounting: Configuring your New Company
- Amazon to QuickBooks Online Accounting: Using Purchase Orders to Receive Inventory
- Amazon to QuickBooks Online Accounting: Creating Proper Invoices
- Amazon to QuickBooks Online Accounting: Handling Refunds and Returns
- Amazon to QuickBooks Online Accounting: Recording Reimbursements
- Amazon to QuickBooks Online Accounting: Processing Settlements and Bank Deposits
