fbpx

Amazon to QuickBooks Online Accounting: Configuring Sales Tax and Marketplace Facilitator Tax

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.

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.

QuickBooks Online Sales Tax Setup

QuickBooks Online Sales Tax Setup 2

QuickBooks Online Sales Tax Setup 3

QuickBooks Online Sales Tax Setup 4

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.

Amazon to QuickBooks Online Accounting: Configuring Sales Tax and Marketplace Facilitator Tax

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.

Back to top

Setting up Sales Tax in QuickBooks Online with Standard Sales Tax

QBO Old Sales Tax Switch to New

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.

QuickBooks Online old Sales Tax Setup 1

QuickBooks Online old Sales Tax Setup 2

QuickBooks Online old Sales Tax Setup 3

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.

Back to top

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.

QuickBooks Online Accounts

Amazon to QuickBooks Online Accounting: Configuring Sales Tax and Marketplace Facilitator Tax

Once you’ve created the bank account, you’ll need to create the service account that links to this account you’ve just created.

QuickBooks Online Add Service Item

QuickBooks Online Product and Services Add

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.

Back to top

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.

Sample Amazon Invoice

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.

QBO Invoice with Marketplace Tax

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.

Back to top

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: