Problem with PST Liability Report

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

Reply to
todd
Loading thread data ...

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

Reply to
!-!

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

!-! wrote:

Reply to
todd

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

Reply to
!-!

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.