Sales Tax Liability by Tax Agency Report
The Sales Tax Liability by Tax Agency report shows sales tax liabilities that have accrued for the date range selected, and the amounts due as payable at the end of that date range. Amounts in the Tax Collected and Tax Due columns are determined by the transaction date. The liabilities on this report are grouped by tax agency.
The following columns are included in this report:
-
Total Sales – This column reports the amount from invoices, cash sales and credits that included any taxable items sold at the rate for the tax code listed.
It will not match the Sales Summary report because it includes only sales with taxable items.
It will equal the total of the Nontaxable Sales column and the Taxable Sales column on this liability report.
-
Nontaxable Sales – This column reports the amount of sales that are excluded from sales tax calculations.
-
Taxable Sales – This column reports the difference between the Total Sales column and the Nontaxable Sales column.
This amount is used as the base for calculation of your sales tax liability.
-
Tax Collected – This column shows the tax amount that results from multiplying the amount in the Taxable Sales column by the Tax Rate for that transaction.
-
Tax Due – This column reports the total tax amount due to the tax agency for this tax code. This amount is the total as of the last date selected on this report.
To see the Sales Tax Liability by Tax Agency report, go to Reports > Sales Tax US > Sales Tax Liability by Tax Agency.
A message on the screen indicates that your report is loading. The status bar in the footer of the report indicates the progress as your report loads. You can click Cancel Report next to the status bar to stop the report from loading.
You can run this report on a cash basis. The Cash Basis Reporting preference at Setup > Accounting > Accounting Preferences, on the General Ledger subtab, applies to all standard reports that support cash basis reporting. If this preference is enabled, the report is on a cash basis rather than an accrual basis. If this preference is not enabled, you can create a custom cash basis report by enabling Cash Basis on the More Options page of the Financial Report Builder. See Setting Up Cash Basis Reporting.