[fwhorch]

We're noticing differences between our QuickBooks numbers and our Retail Sales numbers when it comes to our sales tax reports.

At the bottom of Sales Manager you can see total sales and total sales tax for any period. This seems to be close to what our QuickBooks export reports.

But if you do a sales tax report, the total sales number can be quite different, and the sales tax is also calculated differently. I have no idea where the total sales numbers are coming from, but the sales tax seems to be a rounding difference.

Can anyone tell me what Retail Edge is doing when it calculates total sales in Sales Manager, versus total sales in the Sales Tax Report?

Thanks,
Fred

P.S. To give you a sense of the difference, for one month sales manager reported $24,833.62 total sales and $1,159.95 total sales tax whereas the sales tax report said $24,788.73 and $1,157.68. Close, but not the same!

[Andy]

Fred,

You are right, the Sales Tax Report (Reports / Sales / Sales / Sales Tax Report) can sometimes differ from other reports (and the Sales Manager). The most common factor is how each report (or MGR) is filtered (e.g. date ranges, tax jurisdictions, RegIDs, etc).

You might also have a corrupt data table. To rule this out, you should go to Tools / Verify Tables and run verification tests on all your tables (simply follow the on-screen instructions).

Another factor, and one that is more subtle, is due to the source of the data that is used in the Sales Tax Report. This report draws it's data from the Sales_Tax table. Data gets put into the Sales_Tax table when a sale is posited. If a sale is entirely non-taxable, it is possible that in some circumstances, the sale's information may not make it to the Sales_Tax table. This can lead to a different sales total than other sales reports.

If you'd like us to take a look at your data for a more definitive answer, please email us at [email protected] and we'll give you instructions on how to send you backup file to us.

Thanks.

[Andy]

Follow-up:

We will be making a change in the next release of RetailEdge (8.0.18) that should resolve the issue of sales with no tax jurisdictions not posting records into the Sales_Tax table. This should bring the Sales Tax Reports into better compliance with the other Sales Reports.