I understand that excise tax is a different type of tax, bktalks2u.
The best option I can suggest is to create a service or a non-inventory item and a liability account. We'll have to manually calculate and add it on the transaction as other line item.
Let's set up a liability account first.
We can now set up an item.
You can pull the Transaction Detail by Account report to see the total excise tax. Simply search and select this report on the Reports tab. Just make that the reporting date is correct.
Comment below if you need more assistance. I'll always be here to help you.
I agree with @AlexV, this is similar to how I’ve set up Hawaii GET for several QBO clients. The only difference is that I would create a GET Income account and map the Service or Non-inventory item to that income account (instead of the liability account). This is because GET passed through to customers has to be included in income.
What I usually do is create the invoice/sales receipt and fill in everything before I calculate GET. Then I add the Service/Non-inventory General Excise Tax item last. Unfortunately, since there are not enough decimal places to enter the full pass-through rate, I have not been able to figure out a way for the system to calculate GET for me. I manually calculate it by multiplying the pre-tax subtotal on invoices/sales receipts by the appropriate pass-through rate:
I enter the result into the amount column and save the invoice/sales receipt.
When I file and remit GET, I report all income for the tax period, including the GET passthrough income. As a check, I compare the GET that is due to the GET income in QBO. They should be roughly the same (give or take for rounding). I record the payment as GET expense.
Good day, @jogreene.
Since you wanted to set up GET but not pass it along to your client. You can set up a liability account for this.
Feel free to read these article for future reference:
Drop any additional questions, I'm always here to answer.
Since you’re not passing the GET to customers, the only thing you need to set up is a GET expense account. When you pay the GET, categorize the payment in QBO under the GET expense account (this is assuming you want to record expenses on a cash basis).
However, if you wanted to accrue the expense at the end of each period, you will need to set up an Accrued GET liability account; At the end of the GET period, you will create a Journal Entry:
You will notice the liability on the balance sheet. When you pay the GET, categorize the payment in QBO under the Accrued GET liability account; this will zero out the liability balance.