QuickBooks Desktop: Setting up sales tax before you sync invoices

If you collect sales tax in RoasterTools and sync invoices to QuickBooks Desktop, you'll need to set up a small handoff between the two systems before invoices with tax can sync cleanly.

RoasterTools sends collected sales tax to QuickBooks Desktop as a separate invoice line. Because of that, you need a regular QuickBooks item connected to a clearing liability account. This article walks through that setup.

Why pointing at "Sales Tax Payable" doesn't work

The first instinct is usually to point a tax line item at QuickBooks Desktop's existing Sales Tax Payable account. QuickBooks blocks this with a warning that says: "You cannot associate an item with Sales Tax Payable, Undeposited Funds, accounts receivable, accounts payable, or non-posting accounts."

That account is reserved for QuickBooks' own native sales tax workflow (the one you use today via Vendors → Sales Tax → Pay Sales Tax). Regular invoice line items, including the one RoasterTools uses to send tax, can't post into it directly.

The same thing applies to the state-named sales tax items QuickBooks uses for that built-in workflow (the ones that look like "Sales Tax {your state}"). Those are a different item type reserved for QuickBooks' own tax engine. RoasterTools' current sync path can't reuse them as the default tax item.

The fix is to give RoasterTools its own item that points at a separate liability account. Three steps.

Step 1: Create the Other Current Liability account

You'll add a new liability account in your QuickBooks Desktop chart of accounts. This is where RoasterTools-collected sales tax will land.

1. From the top menu in QuickBooks Desktop, click Lists, then Chart of Accounts.
2. At the bottom of the Chart of Accounts window, click the Account button (bottom-left). A small menu appears.
3. Click New. The "Add New Account: Choose Account Type" window opens.
4. Select Other Current Liability, then click Continue.
5. Fill in the account details. Two shapes work; pick whichever your accountant prefers for reporting.
   • Option A: Sub-account under your existing Sales Tax Payable (recommended for most). This keeps the new account grouped with your existing tax structure on reports.
     • Account Name: something like RoasterTools Sales Tax Clearing   or RT Sales Tax Clearing  . Use a name that's self-explanatory on its own; you'll see it in reports and transaction lines without the parent context.
     • Tick Subaccount of, then select Sales Tax Payable as the parent.
   • Option B: Standalone Other Current Liability account.
     • Account Name: same suggestions as Option A. Anything except literally "Sales Tax Payable", which is taken by the system account.
     • Leave Subaccount of unchecked.
6. Other fields (Description, Tax Schedule, etc.) can stay at their defaults.
7. Click Save & Close.

Step 2: Create the Other Charge item

Now you'll create a QuickBooks item that points at the account you just made. This is the item RoasterTools will use on every synced invoice that has sales tax.

1. From the top menu, click Lists, then Item List.
2. At the bottom of the Item List window, click the Item button (bottom-left). A menu appears.
3. Click New. The "New Item" window opens.
4. In the Type dropdown at the top, select Other Charge.
5. Fill in the rest of the fields:
   • Item Name/Number: something descriptive like RoasterTools Sales Tax  .
   • Description (optional): something like "Sales tax collected by RoasterTools". This appears on the invoice line.
   • Amount or %: leave blank. RoasterTools sends the actual amount per invoice.
   • Tax Code: non-taxable (typically labeled Non). The line itself represents tax collected; it shouldn't get taxed again.
   • Account: the new Other Current Liability account you created in Step 1.
6. Click OK to save.

If you see the warning "You cannot associate an item with Sales Tax Payable...", you've selected the wrong account in the Account field. Cancel out, return to the Account dropdown, and confirm you're picking the new child or clearing account from Step 1, not the system Sales Tax Payable.

Step 3: Map the item in RoasterTools

The last step happens on the RoasterTools side. Reach out to support@roastertools.com with the name of the new item you just created. We'll point RoasterTools' "Default Tax Item" preference at it for your QuickBooks Desktop connection.

After that, the next invoice you sync that has a tax line will use the new item, and the tax amount will land in your new clearing account.

Filing each period

Once the new item is wired up, RoasterTools-synced invoices will accumulate collected tax in your new clearing account over time. At filing time, you move that balance into QuickBooks' native sales tax workflow so you can pay it through your usual Pay Sales Tax form.

Three short sub-steps.

Filing Step 1: Get the period total from the clearing account

1. Open Lists → Chart of Accounts.
2. Right-click your new clearing account and choose QuickReport.
3. Set the date range to the period you're filing for (e.g., the current month or quarter).
4. Note the report's total. That's the amount RoasterTools collected in sales tax during that period.

Filing Step 2: Move the total into the native sales tax liability

1. Open Vendors → Sales Tax → Pay Sales Tax. The Pay Sales Tax window opens.
2. Click the Adjust button at the bottom-right of the window. The Sales Tax Adjustment dialog opens.
3. Fill in:
   • Adjustment Date: the filing or period-end date.
   • Sales Tax Vendor: your state tax agency (the same one tied to your existing native sales tax item).
   • Adjustment Account: your new clearing account.
   • Adjustment Type: Increase Sales Tax By.
   • Amount: the period total you got in Filing Step 1.
   • Memo (optional): something like "RoasterTools-collected tax, {period}".
4. Click OK. The native sales tax liability goes up by that amount, and your clearing account drops by the same amount (back toward zero).

Filing Step 3: Pay through the regular Pay Sales Tax form

You're back in the Pay Sales Tax window with the corrected amount due. Pay it the way you usually do.

This is functionally a journal entry, done inline with the Pay Sales Tax form.

What not to do

• Don't point an item at the system Sales Tax Payable account. QuickBooks won't let you, and it's the wrong destination anyway.
• Don't rename or reuse the state-named sales tax items QuickBooks uses for its built-in Pay Sales Tax workflow. Those belong to QuickBooks' native tax engine and can't be the RoasterTools default tax item. The new item you create above is separate.
• Don't skip the tax code on the new item. Mark it non-taxable so QuickBooks doesn't try to tax the tax line.

Glossary

• Other Current Liability (OCL): a QuickBooks account type for short-term amounts you owe, including sales tax you've collected and not yet remitted.
• Books of record: the accounting system your accountant treats as authoritative for reporting and reconciliation. For most QuickBooks Desktop customers, that's QuickBooks itself.