By Ryan Balfe on Jun 15 2015

Calculating, paying and filing state sales tax can be extremely confusing for many businesses. The concept is quite simple, however.


For starters, sales tax is a liability and not an actual expense. When it is finally time to file and pay your sales tax to the state, don’t get angry – it was never really your money to begin with. You are simply required by law to apply your state’s sales tax rate to your invoices for services rendered. Your customers are ultimately footing the bill. The problem with many companies, especially those operating on a tight cash flow schedule, is that the money gets deposited into their account and most like co-mingled with regular business expenses. This is why it is absolutely crucial to keep track of your sales tax liabilities on a regular basis so you can properly budget for it and have no surprises when it is time to pay up and file. At any given moment, you should be able to peek at your balance sheet and see exactly the running amount that you owe to the state.

“As a business obligated to pay sales tax, you essentially serve as an intermediary between your customers and the state. Proper bookkeeping ensures that you will ultimately pay to the state the exact amount you collected from your customers during the filing period.”

Below is a checklist of four critical items to review each quarter (or month) to ensure you are calculating sales tax correctly and not pulling money out of your business by misreporting sales and deductions on your return. As a business obligated to pay sales tax, you essentially serve as an intermediary between your customers and the state. Proper bookkeeping ensures that you will ultimately pay to the state the exact amount you collected from your customers during the filing period.

  1. Do you file on a cash or accrual basis? More than likely, the answer is cash. If so, just make sure that your sales reports are not generated on an accrual basis. You need to specify total gross sales on your return. If you have a bunch of invoices created during the filing quarter that have not been paid by your customers, they will not show up as sales on a cash basis, but WILL factor into your gross sales on an accrual basis. Additionally, do not just guess this number. The state will compare your total gross sales amounts reported each filing period with your year-end income tax return. These must match!
  2. Is your Accounts Receivable Correct? Every month, you should run an A/R Aging Report (after your bank rec’s of course – see #4) to verify that everything looks correct. If you see payments within this report, chances are you either never applied that payment to an open invoice or never created an invoice to begin with. This is OK if you have not actually provided the service as of the last day of the filing period but – if the job is, in fact, closed – go back and create an invoice so you can apply that payment. Otherwise, you will be under-reporting sales and will get penalized in the event of an audit.
  3. Are you recording refunds to customers correctly? If you owe money back to a customer, chances are you’re simply writing them a check and recording the expense to an income account. Don’t forget about the sales tax though!! If a customer initially pays you $100 plus $7 for sales tax, $100 should go towards sales and $7 should be applied to your sales tax liability account on your balance sheet. If you refund $107 back to the customer and apply it directly to an income account, you are miscalculating sales and may end up still paying the $7. Also, never retroactively create a refund in your bookkeeping system. The refund should always be entered on the date you actually refunded the customer. Always check your sales tax liability register to verify that your payments to the state match the liability amounts accrued during the filing period.
  4. Are your accounts reconciled? This is the bible for proper bookkeeping. Every single penny going in and out of your business should be accounted for with 100% accuracy. Otherwise, you may wind up accidentally inflating sales and paying more in sales tax (and income tax) than you should. You may discover payments recorded that never actually hit the bank account (or invoices that were actually paid but never recorded in your system). Also, if you receive a loan or make a personal contribution to the company, make sure none of this activity hits your P&L whatsoever – they should only be impacting assets, liabilities or equity on the balance sheet. Also check to see if any refunds from your vendors were classified to the actual expense account and not recorded as income.

Utilize the Sales Tax Center in Quickbooks Online to diligently keep track of your sales tax liabilities and ALWAYS record your actual sales tax payments here and not directly to the liability account. There should not be any expense accounts associated with sales tax. If you think you may have misreported, overpaid or underpaid sales tax in the past, feel free to ask us questions in the comments section below or chat with us by clicking on the icon towards the bottom right of your screen.