A working reference for bookkeepers and CPAs: cleanup, the close, and books that hold up under review.


Bookkeeping

Tracking Hawaii GET in QuickBooks Online with a service item

How to collect Hawaii General Excise Tax on invoices using a manual service item, keep the liability clear, and pay the state without distorting your ledger.

Updated 2026-08-20 · 3 min read


Hawaii's General Excise Tax is not a sales tax, and that difference reaches all the way into your ledger. GET is a tax on the business for the privilege of doing business in Hawaii, permitted (not required) to be passed on to the customer. That is why the automated sales tax feature in QuickBooks Online can be the wrong tool for it, and why many Hawaii bookkeepers track GET by hand instead. Here is how we approach that setup, and the judgement calls around it.

Why a service item instead of the sales tax module?

The sales tax module is built around a vendor-collected tax on the customer's purchase. GET applies to gross receipts, including amounts you might not think of as taxable sales, and the pass-on to the customer is a separate calculation. Forcing GET through the sales tax engine can misstate the base, mislabel the liability, and produce returns that do not match what was actually owed.

A manual service item sidesteps that. You calculate GET yourself, at the correct rate and on the correct base, and post it to a liability account you control. The trade-off is that nothing is automated: the rate, the base, and the remittance are all on you.

Setting up the item

Create a new service item in your products and services list. Name it something unambiguous, such as "Hawaii GET". Leave the sales price blank so you can enter the exact amount on each invoice, since the rounded dollar figure will differ from a percentage of the line total.

Map the item to a dedicated liability account, often called something like "Hawaii GET payable". Do not map it to income. The amount you collect is not revenue; it is a liability you owe the state until remitted. Mark the item as non-taxable so the sales tax feature does not compound on top of it.

Using it on an invoice

Add the regular products or services first. Confirm the standard sales tax setting at the bottom of the invoice is off, so the two systems do not double-collect. On the final line, add the GET item and type the calculated amount.

Keep a small working paper habit here: note the base and the rate used, at least for anything unusual. If GET applies to the shipping line or to a pass-through, that belongs in your base, and a note in the memo field saves a later argument with the return.

Paying the state

When you remit, record the payment as a check or expense coded to the same liability account. The debit reduces the payable balance to match what you sent. The liability account should then read zero, or carry only the amount collected but not yet due.

If the balance does not tie to the return, stop and reconcile before filing. A residual usually means an invoice was posted to the wrong account, a payment was coded to expense instead of the liability, or a credit note was issued without reversing the GET line.

Where this stops being ordinary bookkeeping

This setup is simple while the business has one rate and one filing frequency. It gets harder with county surcharges, wholesale versus retail rates, or exempt receipts that still require reporting. Those are accounting judgements, not software problems: the rate schedule and the return rules come from the state, and the treatment can depend on your activity and jurisdiction. Confirm the applicable rates and filing requirements with the Department of Taxation or the client's accountant rather than guessing.

What stays squarely in bookkeeping territory is the ledger discipline: one liability account, consistent item mapping, and a remittance that clears the balance exactly. Get those three right and the GET return almost writes itself from your trial balance.


General information for people who keep the books. It is not accounting, tax or legal advice, and it is not a substitute for your own professional judgement on your own figures.

← All articles