QuickBooksHelpIntuit

Handle cash basis sales tax

by Intuit•4• Updated 6 months ago

You may be required to collect taxes for certain goods and services you offer. QuickBooks helps you keep an accurate record of these taxes so you can easily monitor and remit them to the appropriate tax collecting agency.

	This article is part of a series on Sales Tax. It covers the usual sales tax workflow in QuickBooks Desktop. Set up sales tax Collect sales tax Review sales tax reports Pay sales tax It also helps you complete other sales tax-related tasks. Handle cash basis sales tax Process sales tax adjustment Show multiple sales tax items on an invoice Refund sales tax collected from tax exempt customers Track sales tax on purchases from vendors If you encounter problems while working on your sales tax, see Resolve common sales tax issues.

If your taxable sales amount seems off when you run the Sales Tax Liability report or if you have invoices from another month or period showing on the current report, then you may need to check if you are running the report on cash or accrual basis. Note that the accounting method or report basis you use affects the sales tax amount you owe.

Accrual: QuickBooks calculates sales tax payable as soon as you invoice your customer. Regardless of the payment amount or date, the full sales tax amount will show on the month when the invoice was created.
Cash: QuickBooks calculates sales tax payable only when you receive the payment. When you receive a full payment for the invoice, the full sales tax amount will show on the month when the payment was received. No sweat! It becomes complicated, however, when there are non-taxable line items on the invoice or if you receive partial payments or if there are credits/discounts applied to the invoice.

Here are some of the common scenarios you may encounter when you receive partial payments for cash basis sales tax.

Scenario 1: Completely taxable invoice with a partial payment

If you create a completely taxable invoice and receive a partial payment then sales tax amount shows on the month when you receive the partial payment. QuickBooks applies the payment to the taxable sales and then reverse calculating the sales tax to be paid.

Example:

User-added image

Taxable Invoice amount: $1000
Payment amount: $200
Sales Tax rate: 8%

To calculate the taxable sale amount, divide the payment collected by 100 plus sales tax rate and then multiply it by 100.

$200 (payment) / 100 + 8 (tax rate) x 100 = $185.19 (Taxable Sale)

To calculate the tax amount, subtract taxable sale from the payment amount.

200 (payment) - $ 185.19 (taxable sale) = $14. 81 (Tax Amount)

NOTE: If there are several partial payments, you can add up all payments made against the invoice and use the same formula for calculating the total amount of taxable sale and tax collected.

Scenario 2: Invoice with a non-taxable item and a partial payment

If you create an invoice with a non-taxable item and partial payment, then sales tax amount shows on the month when you receive the partial payment. QuickBooks calculates the taxable sale by applying the payment percentage to the total amount of taxable item.

Example:

User-added image

Taxable item amount: $1000
Non-Taxable item amount: $100
Payment amount: $200
Sales Tax rate: 8%

To calculate the payment percentage, divide the total payment received by the total amount due.

$200 (payment) / $1180 (total amount due) = 16.95% (rounded off payment percentage)

To calculate the taxable sales amount, multiply the taxable item amount by the payment percentage.

$1000 (taxable item) x 16.95% (payment percentage) = $169.50 (rounded off taxable sales amount)

To calculate the tax amount, multiply the taxable sale by the tax rate.

$169.50 (taxable sale) x 8% (tax rate) = $13.56 (tax collected)

NOTE:

If there are multiple taxable items on the invoice, QuickBooks multiplies the payment percentage to each taxable item.
If there are several partial payments, you can add up all payments made against the invoice and use the same formula for calculating the total amount of taxable sale and tax collected.

Scenario 3: Invoice with an applied credit and a partial payment

If you create an invoice with a non-taxable item and an applied discount/credit and you receive a partial payment, then sales tax amount shows on the month when you receive the partial payment. QuickBooks calculates the taxable sale by applying the payment percentage to the total amount of taxable item.

Example:

User-added image

Taxable Invoice amount: $1000
Non-taxable item amount: $100
Discount/Credit: $100
Payment amount: $200
Sales Tax rate: 8%

To calculate the payment percentage, divide the total payment received by the total amount due.

$200 (payment) / $1072 (total amount due) = 18.66% (rounded off payment percentage)

To calculate the taxable sales amount, multiply the taxable item amount by the payment percentage.

$900* (taxable item) x 18.66% (payment percentage) = $167.91 (taxable sales amount)
^*$1000 (total taxable items) minus $100 (credit/discount)

To calculate the tax amount, multiply the taxable sale by the tax rate.

$167.91 (taxable sale) x 8% (tax rate) = $13.43 (tax collected)

NOTE:

If there are multiple taxable items on the invoice, QuickBooks multiplies the payment percentage to each taxable item.
If there are several partial payments, you can add up all payments made against the invoice and use the same formula for calculating the total amount of taxable sale and tax collected.

QuickBooks Desktop Mac PlusQuickBooks Desktop Premier 2021QuickBooks Desktop Premier PlusQuickBooks Desktop Pro 2021QuickBooks Desktop Pro PlusQuickBooks Desktop for Mac 2020QuickBooks Desktop for Mac 2021

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.