Sales Tax Report (Accrual)

What is a Sales Tax Report (Accrual)?

The Sales Tax Report (Accrual) provides a detailed summary of sales tax calculated on sales transactions recorded within a selected reporting period using the accrual accounting method. Under the accrual method, sales tax is reported based on the transaction date rather than the payment date, making the report suitable for businesses that file taxes on an accrual basis.

The report includes detailed tax information for sales invoices and other taxable transactions, including customer details, reference numbers, tax codes, shipping charges, taxable amounts, and total tax collected. This enables users to review GST or other sales tax amounts, analyze tax liabilities, and generate detailed tax reports for reporting and compliance purposes.

Running and Customizing the Sales Tax Report (Accrual)

To generate the report:

1. Navigate to Menu > Reports > Sales > Sales Tax Report (Accrual).

2. Select the required Period or specify a custom From and To date.

3. The report displays all qualifying transactions recorded within the selected period.

4. Use the available toolbar options to customize, export, or format the report as required.

Report Filters

Filter	Description
Period	Selects the reporting period for the report. Users can choose a predefined period or specify a custom date range using the From and To date fields.
From Date	Specifies the beginning date of the reporting period.
To Date	Specifies the ending date of the reporting period.

Fields

Field	Description
Transaction Date	Displays the date on which the transaction was recorded.
Transaction Type	Displays the type of transaction, such as Invoice or Credit Memo.
Subtotal	Displays the transaction amount before taxes and shipping charges are applied.
Customer Name	Displays the customer associated with the transaction.
Reference Number	Displays the document reference number for the transaction.
Shipping Cost	Displays the shipping charges applied to the transaction.
Shipping Tax Amount	Displays the tax calculated on the shipping charges.
Tax Amount	Displays the total tax calculated for the transaction.
Tax Code Name	Displays the tax code applied to the transaction.
Total Amount	Displays the total transaction amount, including taxes and shipping charges.
Total Shipping Amount	Displays the total shipping amount charged for the transaction.
Total Tax Amount	Displays the total tax amount applied to the transaction.
Ship To City	Displays the destination city for the shipment.
Ship To State	Displays the destination state or province for the shipment.

Toolbar

File:

• Print – Prints the report.

• Save My Layout – Saves the current report layout for future use.

• Restore Layout – Restores the previously saved layout.

• Restore Filters – Removes all applied filters and restores the default filter settings.

• Save as New – Saves the customized report as a new report layout.

Tools:

• Provides additional report management options.

Export:

• Grid: Displays the report in a tabular grid format.

• Charts: Displays the report using graphical charts for data visualization.

Layout and Formatting Options

The report includes several customization options to modify its appearance and presentation.

Format

The Format window allows users to customize how values are displayed within the report. Users can modify number formatting, text alignment, currency formatting, decimal precision, thousand separators, and conditional formatting rules to improve the readability of the report.

Options

The Options window allows users to customize the report layout and display settings.

Users can configure:

• Grand Totals to display totals for rows, columns, both, or hide them entirely.

• Subtotals to display subtotal rows, subtotal columns, both, or hide subtotals.

• Report Layout by selecting Compact, Classic, or Flat form.

Click Apply to save the changes.

Fields

The Fields window allows users to customize the report by selecting and organizing the columns displayed in the report.

Within this window, users can:

• Select or deselect fields to display in the report.

• Rearrange the column order using drag-and-drop.

• Quickly locate fields using the available list.

• Restore the desired report layout before applying the changes.

Click Apply to update the report with the selected configuration.