Sales Tax Payable or Liability Report Doesn't Match the Return

Why doesn't my sales tax payable balance match the return I filed?

A sales tax payable balance (the liability account holding tax owed to the state), a sales tax liability report and a filed return measure the same tax three ways, so they differ until each known gap is added back. The payable balance is sales tax charged or collected, plus use tax accrued, less tax paid. The liability report adds up the tax on the period's customer invoices. The return reports gross sales, taxable sales and taxable purchases, works out the tax, then subtracts any discount or credit (Texas instructions; New York bulletin). This page uses the Texas, New York and California returns as examples; your state's form decides the lines, the discount and the correction route.

A case is not simple, and often needs a professional's review, when several states or rates are involved, the balance has been off for more than a quarter, the payable is more than the state has been paid, a return was already corrected once, or a state notice has arrived. Gather each filed return with its payment confirmation and bank statement, the sales tax report by jurisdiction, ledger detail for the payable account, the exemption certificates, and any corrected return or notice.

Start with one state and one period: take the filed return, not a draft in your software, match the amount paid to the bank withdrawal, then explain each gap in the table.

What does a state sales tax return ask for, and where does each number come from in my books?

Many state returns, such as Texas, New York and California, start from sales, not from the tax you collected, and work the tax out from taxable sales and purchases. Texas asks for total sales, taxable sales and taxable purchases; New York and California ask for total sales, the nontaxable portion and purchases subject to use tax.

A return that works out tax from taxable sales can differ from a payable that holds the tax your invoices actually charged. The two agree only when, among other things, every invoice was taxed at the right rate on the right items.

How do I find the "total gross sales" the return asks for?

Total gross sales is every sale for that state and period, taxable or not, without the sales tax itself. Each state sets what counts. Texas counts all sales, services, leases and rentals, with related charges, made from a Texas location or into Texas (instructions). California counts all sales related to its California business, including labor, service, shipping and handling charges and lease and rental receipts (CDTFA).

To build the figure from the books:

1. Pull sales for one state, using the return's exact first and last day.
2. Take out the sales tax. Texas's total-sales line excludes it, and California's return has a line for tax included in Total Sales. Whether collected tax is also income depends on who the state's law imposes it on (IRS Publication 334); California, for one, makes the seller responsible for paying it. See sales tax collected and paid.
3. Add related charges that belong in sales, such as shipping, handling and fees. Check equipment and other business assets sold in the period: California reports them as Sales of Fixtures and Equipment, and the selling price can differ from the gain or loss in the books.
4. Keep exempt, resale and marketplace sales in. They come out later, as nontaxable sales.
5. Compare the total with the return. A remaining gap is usually sales dated just before or after the period, a sales source missing from the books, or tax still inside sales.

Timing can differ too. New York and California both require a sale to be reported for the period in which it is made, whether or not the customer has paid (New York Publication 750; California Publication 73). Cash-basis books lag by the invoices unpaid at period end; see cash or accrual. For deposits and Form 1099-K totals, see reconciling sales and payouts.

Which sales sit in gross sales but carry no tax?

Sales to resellers and exempt buyers, sales a marketplace collects tax on, sales delivered out of state, and nontaxable items all stay in gross sales and come out of taxable sales. California says a seller's records must show gross receipts from all sales, even ones the seller considers exempt.

In many accounting programs a liability report counts a sale as taxable unless its customer or item is flagged exempt; check how yours treats them. Until the flags match the certificates, taxable sales will not match the return. See exemption certificates from customers and filing sales tax returns for marketplace sales on a return.

Where do the timely-filing discount and vendor credit go?

On the return, a discount or credit lowers the amount you pay, not the tax. When a seller pays less than it collected, the difference stays in the payable until it is moved to its own account; see sales tax collected and paid for the entry.

Texas lets a permitted seller take 0.5% of tax timely reported and paid, plus 1.25% more for monthly or quarterly filers who prepay a reasonable estimate of the period's tax and meet the other prepayment rules (Texas Comptroller; prepayment FAQ). A prepayer's credit on the return is larger than the cash prepaid, because the credit includes the discount (instructions). New York's vendor collection credit is 5% of the taxes and fees reported, up to $200 for each quarterly or annual period; monthly filers do not get it (TB-ST-925).

The Texas discount and the New York credit both depend on filing and paying on time. Texas tells filers not to take the discount if the return or payment is late. New York allows no credit on a past-due or amended return, or when the full amount is not paid on time, and none carries forward. Not every state gives one; California's seller's permit guide describes none.

How do rounding, tax-included prices and tax on shipping create small differences?

Rounding, tax-included prices and tax on shipping each move the tax by cents per invoice, or by a share of the invoice, so they are the first places to look for a small gap.

• Rounding. Texas has sellers figure tax on a sale to the third decimal place, rounding up to the next cent at five or more (Texas FAQ), then report sales lines in whole dollars (instructions). California lets a seller round the return to the nearest whole dollar. New York has sellers compute tax on the total of a transaction, not item by item, when the items share a rate (Publication 750). Tax summed invoice by invoice and tax figured on a period total can differ by cents.
• Tax-included prices. When a price includes tax, the sale price is the price divided by one plus the rate, and the rest is tax (Texas FAQ). If the full price was booked as sales, sales are overstated and the tax sits in income instead of the payable.
• Shipping and delivery. Texas taxes delivery and shipping charges connected with taxable items. New York includes shipping, handling and delivery when it calculates tax on taxable property. In those states, an invoice that taxed the item but not the shipping, or the reverse, collects a different amount from the one the return computes. California deducts delivery charges paid to an independent carrier when separately stated on the invoice; any amount above the actual cost stays taxable. Check your state's rule before calling a shipping difference an error.

A gap of cents per invoice may be rounding, but recompute the invoices and the return under the state's rule before calling it that. A small rate or taxability error can look the same, and unbooked rounding can add up over periods. Clear only the amount the calculation explains.

How does use tax appear on the return but not in the liability report?

The return adds tax on the business's own taxable purchases, and a liability report built from customer invoices never sees them. A Texas seller with a permit reports use tax in Item 3, Taxable Purchases. A registered New York business reports it on its sales tax return, for example on taxable property bought from an out-of-state seller who charged no New York tax (TB-ST-910). California's return has a line for purchases subject to use tax.

Use tax also covers purchases that carried only part of the tax, and items taken out of resale inventory for the business's own use. Texas's Item 3 and use tax page show both; New York's return covers purchases made in one jurisdiction for use in another with a higher rate.

The return's tax due is therefore tax on sales plus use tax. If the use tax was never accrued in the books, the payment is larger than the payable by that amount. For what is taxed and how to book it, see use tax on business purchases and sales tax collected and paid.

What do credit memos, refunds and bad debts do to the balance?

A credit memo or refund lowers the tax you owe only if the state lets you take it, and the return may take it in a different period from the books. The conditions differ by state.

• California deducts returned taxable merchandise only when the full price, including tax, was returned or credited, and a bad debt on a taxable sale only if it was charged off; the conditions are in CDTFA's instructions. Tax reported and paid on an earlier return is claimed on a separate schedule, for the period in which the credit happened. A credit that belonged on an earlier, already-filed return needs an amended return or a refund claim.
• Texas has the seller claim a credit in Item 2 by subtracting sales on which tax was paid in error or refunded, and attach Form 01-148. A bad debt credit must be filed electronically (instructions).

In the books, a credit memo lowers the payable on its own date. If the return takes the credit in another period, the two balances differ until then. For the entries, see recording refunds and writing off unpaid invoices.

Why does a sales tax balance never clear?

A balance that never clears is usually a payment booked to the wrong period, state or account, or a gap that was never booked. Each leaves a different pattern in the ledger.

A balance left by a discount, use tax or a prepayment is explained in the sections above.

A wrong rate does not make the difference disappear. Texas holds the seller to the correct amount (FAQ). In California, tax collected above what is due must be returned to the customer or paid to the state and reported; the return has an Excess tax collected line. New York tells filers to remit the total they collected as tax, even if it is more than the tax due. Fix the invoices and the setting, then decide how the period is corrected.

What steps tie the return, the payment and the ledger on filing day?

Tie one state and one period at a time, starting from the filed return and working back into the books.

1. Take the filed return and its payment confirmation, not the draft.
2. Compare total sales on the return with sales in the books, without tax. Explain any gap with the cutoff, channel and tax-in-sales checks above.
3. Compare taxable sales on the return with the liability report. Explain any gap with exempt, resale and marketplace sales.
4. Compare the tax on sales with the tax collected in the books. List invoices taxed at the wrong rate or on the wrong items.
5. Add use tax, then follow the return's order for credits, discounts and payments. A Texas prepayment credit already includes its discount, and the timely-filing discount applies only to the balance left after it. Texas takes refund and error credits inside taxable sales, so the tax figure already reflects them; California's credits for earlier periods come off the tax. Subtract prior payments or overpayments applied to the period and add any penalty and interest. If every gap is accounted for, the result matches the amount due on the return, which the payment should equal.
6. Match each payment, including any prepayment, to a bank withdrawal, to its posting and to the state's account history for that period.
7. Roll the payable forward: opening balance, plus sales tax charged or collected (including tax on unpaid invoices, where the state reports sales for the period they are made), plus use tax accrued, minus the tax in credit memos and refunds, minus payments, minus the discount booked, equals the closing balance. If the roll-forward holds, the closing balance matches the tax and use tax accrued for periods not yet paid. Support it by state and period.
8. List whatever is left, by invoice or payment.

What do I do with a difference I cannot explain, and when do I amend?

Narrow it before you adjust it. Posting an unexplained difference to income or expense zeroes the account but hides the cause.

Until the cause is found, one way to hold the amount is to leave it in the payable with a dated note; once the pattern shows it is only rounding, it can be cleared to a rounding account. Use the roll-forward to find the first period where the balance stopped tying, then list that period's invoices, payments and credits.

A payable above what the state has been paid may be tax collected and never sent in. New York can hold owners, officers, directors, employees, partners or members personally liable, and California can do so for a person in control of a business that ends owing collected tax it willfully left unpaid. Filing sales tax returns covers who owes it in each state and how far back a state can assess.

Whether to amend depends on whether the filed return reported the right sales, taxable sales and tax for the period, and on the state's rules for correcting it. If the return was wrong, the period may need correcting. If the return matches what the law required and only the books are off, the books need fixing. A return can match the invoices and still be wrong if the invoices used the wrong rate or taxed the wrong items.

• California says not to adjust the current period's gross sales for an earlier error: file an amended return for the period of the error. An amended return that ends in a credit is treated as a refund request (CDTFA).
• Texas lets you file an amended return on paper or online. If it shows tax underpaid, pay the added tax with any penalty and interest; if it shows an overpayment and you want a refund, you must meet the requirements for a refund claim. Tax paid in error, returned merchandise and bookkeeping errors are credits taken on the current return with Form 01-148 (instructions).

Check refund deadlines before setting an old period aside. Texas generally allows four years from the date the tax was due and payable (Comptroller). California's deadline is the latest of three years from the return's due date, six months from the overpayment, or six months after a billing becomes final (Publication 117; section 6902). New York allows three years from the date the tax was due, or two years from the date it was paid, whichever is later (TB-ST-350). A dated ledger note does not preserve a claim.

Which route fits is a state-by-state question. A difference that spans several periods or states, or has sat unexplained for years, is a case for professional review.

Example

These examples are illustrative. Amounts are in US dollars.

A Texas retailer: the discount stays in the payable

A Texas retailer that files and pays on time, without prepaying, has taxable sales of $48,000 in a month at an 8.25% combined rate, so tax is $3,960. The 0.5% timely-filing discount is $19.80, so it pays $3,940.20. The payable holds the $3,960 collected, and after the payment $19.80 remains. Here that is the discount, not an error, because every invoice was taxed at 8.25%. Booked to its own account, it clears the payable.

An online seller: exempt and resale sales

An online seller books $120,000 of sales in a quarter at an illustrative 8% rate, with no use tax, discount or credits. The liability report shows $120,000 under taxable sales, but its tax column shows $7,200, because no tax was charged on $30,000 sold to resellers and exempt buyers. The return reports $120,000 total sales and $90,000 taxable, so its tax is $7,200 and agrees with the payable. The gap is only in the taxable-sales column. In this example, flagging the $30,000 as nontaxable, with the certificates kept, makes the report match. If the payable showed $9,600 instead, tax was charged on the exempt sales and that excess needs its own fix.

A New York business: use tax and the vendor credit

A New York business files quarterly and pays in full on time. It collected $3,000 of tax from customers, at the right rate, and bought $5,000 of supplies from an out-of-state seller that charged no New York tax. At an illustrative 8% rate, use tax is $400. The return shows $3,400 of tax. The vendor credit is 5% of $3,400, or $170, under the $200 cap, so the payment is $3,230. The payable holds only the $3,000 collected, so it is $230 short of the payment. In this example the gap is the $400 of use tax not accrued, less the $170 credit not booked. A monthly filer gets no credit, so its payment would be $3,400 and the gap $400.

Different for you?

• The balance has sat unexplained for more than a quarter, several states or rates are involved, the payable is more than the state has been paid, a return was already corrected once, or a notice has arrived: whether the books or the returns are wrong, which periods need an amended return, and how the payable should be rebuilt are questions for a professional. Bring the filed returns, payment confirmations, the sales tax report by jurisdiction and the payable ledger to bookkeeping help.
• A state sent an audit letter or information request: see the sales tax audit guide.
• You missed returns, or the state sent an estimated bill: see filing sales tax returns.
• You keep tying this out every period, or file in several states: see outsourcing sales tax filing for what still needs a person even with software.
• The mismatch is tax charged at the wrong local rate: see sales tax sourcing by ship-to address.
• You should have collected tax and did not: see catching up on uncollected sales tax, or invoices sent without sales tax if the invoices are already paid.
• Your sales run through a marketplace, a payment processor or a restaurant POS: see reconciling sales and payouts or restaurant sales tax and POS reconciliation.
• You need the journal entries for tax collected, paid and use tax: see sales tax collected and paid and use tax on business purchases.