Problem with PST Liability Report

Nov 01, 2005 3 Replies

QB 2005 Pro



When I generate my report each month, the "Sales and Other Revenue" amount always seemed correct, until I double-checked it.



When I view the detail and check it against actual invoices, I find that invoices where no tax (GST or PST) has been applied, for example in the case of out-of-province goverment customers, those invoice totals are not included in the Sales and Other Revenue total.



Is this by design or a bug?



Thanks



It's not a bug. The program seems to work as designed. It's user error.

The tax reports include only sales with a valid tax code. In some jurisdictions, this is what the authorities require - TAXABLE sales. Sales with no tax code, or the "dot - not used" code that seems to be created automatically along with other default tax codes in the Canadian editions, are not included in the sales tax reports.

I tested this by creating a test invoice dated next year with 7 items, each $1000, and each one with a different tax code (including one with the tax code blank. I then generated a P&L and a sales tax report for next year. The P&L showed sales of $7,000 as expected. The sales tax report showed only $5,000 sales; the detail shows that it includes the items with valid tax codes and excludes the blank and "dot" tax code items.

The remedy is to be sure to use a valid tax code - for example "E" (Exempt) for your out-of province customers and other non-taxable sales. Be sure the default tax code and default customer tax code are valid, not blank or "dot" (Edit, Preferences, GST/PST, Company Preferences). If you use Customer-specific tax codes, check them all. And check the default Sales tax code for all your Items.

A simple work-around is to get the sales figure from a P&L report instead of the sales tax report.

example

Thanks for the prompt reply. I'll start using the 'E' code instead of '.'

!-! wrote:

You're welcome. I don't remember anything in Help about this issue, and I expect that MANY users are completely unaware of it - or have decided it's a bug.

sales.

Revenue"

invoice

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required