Skip to main content
October 20, 2022
Question

Sales taxes not reporting properly

  • October 20, 2022
  • 1 reply
  • 0 views

I have taken over bookkeeping in Quickbooks Online for a small restaurant/pub in BC Canada that also sells merch (t-shirts) and does cabin rentals. They use Touchbistro to enter sales of food, beverages and merch, and Campspot for the cabin rentals. There are two different merchant accounts collecting and depositing money daily to the bank account.  All revenues are directed to the Cash Clearing account which is cleared at the end of the month with a journal entry to separate the revenues into different categories, and to record the sales taxes collected.

 

In BC there are 3 PST tax rates: 7% on meals and non-alcoholic drinks, 10% on alcoholic beverages, and 8% hotel tax on the cabin rentals.  There is also the 5% GST on everything.

 

When money is deposited from the Merchant account, I can't enter all of the individual tax rates on the single deposit, which is why it is broken down in one journal entry at the end of the month.  However, when done this way, when you do a GST/HST Summary Report, because you didn't enter a tax code on the deposit, no revenue or taxes are recorded on this report, only the GST ITC's (input tax credits from purchases).  

 

Is there a better way to do this so the tax reports will work properly?

1 reply

October 20, 2022

Hi dianaenglish,

 

Welcome to Community!  QuickBooks Online has the features you need to keep ahead of your work!  I'd be glad to assist!

 

Putting payments into the Undeposited Funds account enables you to combine multiple payments into a single record.  This way, your bank records will always match with your QuickBooks.  There's only one Undeposited Funds account, which holds all payments that need to be combined.  There are different ways to enter the transactions based on how the payments were processed.  Here's a helpful guide for your reference.  With regards to adding the applicable sales tax when using third party applications, I recommend reaching out to your accountant or an associate for the best course of action.  If you don't have an accountant, we can help you locate a ProAdvisor in your local area.

 

Please feel free to reach back out if you have any other questions.  We'd be happy to help!