Adding Locations and food tax to Sales Tax Report of Adj the Sales Tax Audit Export Report

Currently, the sales tax report doesn't break out jurisdictions by GL locations and it does not list the food tax amounts collected. Having the GL breakout on total sales tax is greatly beneficial to those who have locations which collect multiple jurisdictions and have overlap between billing locations.

The sales tax audit export is a way to get the total by jurisdictions, by GL location, and also be able to separate the food tax items from fully taxed items. However, the sales tax audit export has two major issues: 1) the total sales tax collected is replicated for each item that is found on a ticket and 2) the timing of imported sales throws off the sales tax totals to the GL.

Duplicate items can be removed in order to work around problem #1 in the audit export. However, there is no control over what is deleted. For example, if a candy bar (0.03 food tax) and a cup of coffee (0.08 fully taxed) are purchased, each item will be listed showing 0.11 of tax collected. When deleting duplicates by invoice number, if the candy bar line gets deleted, the total tax paid will be correct, but the breakdown between what should have be remitted as food and fully taxed will not be correct at all.

The second issue involving the dates of imported sales occurs when July 31 sales are imported on August 1 - these sales have an 8/1 date, but will hit the GL as 7/31. When these sales show on the audit export, they will not show on a July report, but rather an August report, even though these are taxes collected for July.