Sales Tax Report

The Sales Tax Report aids in reconciling Journal Entries booked to the Tax General Ledger Account by allowing users to easily view sales taxes invoiced during a given time frame. For these invoices, the report looks at invoice line items to estimate Total Tax Liability, as well as how much of this has been collected via customer payments.

While the default view provides tax amounts grouped by Tax Name, users have the ability to filter and group this report in various ways including by Customer, State, Product, Plan and Invoice ID.

Report Features: 

• Break down of applied taxes in a given period of time. 
• View outstanding tax liability for Posted, Paid, and Partially Paid Invoices.
• Filter and group tax amounts by Invoice, Customer, Product, Plan, etc. 

Run Sales Tax Report

Navigate to Menu > Reports > Sales Tax Report. 

The default view displays: 

• Tax Name - As indicated on the Invoice. 
• Gross Sales - Sum of all Invoice subtotal amounts, exclusive of tax.
• Taxable Sales - Sum of all Invoice subtotal amounts on Invoice lines where tax was applied, exclusive of tax amount. 
• Total Tax Liability - Sum of all Invoice tax amounts.
• Tax Collected - Total tax amount collected via customer payments or reduced via refunds, credits, etc.
• Tax Due - Liability minus Tax collected. 

Filter Report

Use the Filter option to customize the view: 

Click Run to run the report with selected criteria.