You use this program to generate a report indicating the taxable portion of all payments made in the Accounts Payable module which can be used to support the amount of tax being claimed back from the authorities.
This report cannot be generated when your Tax distribution method is set to Not required (Accounts Payable Setup).
| Field | Description | ||||||
|---|---|---|---|---|---|---|---|
| Report type |
|
||||||
| Reprint | Reprints previously printed AP tax information according to your selection criteria. |
These options enable you to apply a theme to the report and to define multiple output destinations for the report once it has been compiled (SRS Output Options).
-
The characters *** on the Total calculated tax line of the report indicate that the total calculated tax differs from the company total tax of the report.
This can be caused by the following:
-
Using Exclusive tax in Accounts Payable and overriding the calculated tax value at the time of entry.
-
Posting 'tax only' lines in the GL Distribution of the AP Invoice Posting program.
The calculated tax values are calculated by applying the tax rate of the tax code to the merchandise value. When you post a 'tax only' line, the entire value of the posting is attributed to tax and the merchandise value is 0. This can cause the calculated tax value to differ from the actual tax value that was posted.
For example:
Assume Tax code D = 100%
In AP Invoice posting, post an invoice with a transaction amount of 14.00 and a tax value of 14.00 with a Tax code of D.
In the GL Distribution of AP Invoice posting, capture a single line for 14.00, Tax code D and enable the Tax only check box.
When you print the AP Tax Distribution, the Company tax is 14.00.
The calculated tax is 14% of the merchandise value, but the merchandise value is zero as the entire GL Distribution line was posted as tax.
The calculated tax is therefore zero, which differs from the Company tax of 14.00.
-
-
The following report summary details are printed for each tax code at the end of the report:
Column Description Tax code The tax code for which the values on the line are printed. GST code The GST tax code for which the values on the line are printed if you are using Canadian GST.
Description The description defined against the tax code. Tax rate The rate of tax defined against the tax code. GST rate The rate of GST tax defined against the tax code if you are using Canadian GST. Taxable amount The sum of the values listed against each invoice in the Taxable amount column for the specific tax code. You can set the Tax amount to equal the Total invoice amount in the AP Invoice Posting program which will set the Taxable amount value for the invoice to zero (i.e. zeros are printed in the Taxable amount column for that invoice and the entire amount is listed in the Tax amount column).
Calculated Tax amount This is the Taxable amount in the summary total line for the specific tax code multiplied by that tax code's Tax rate.
![[Note]](images/note.png)
-
Although no rounding is applied to this calculation, rounding is applied to the tax values against each invoice in the Tax amount column (i.e. the value in the Calculated Tax amount column in the summary may not agree to the value in the Tax amount field on the Company totals line).
-
If you set the Tax amount to equal the Total invoice amount in the AP Invoice Posting program, then this amount is not included in the Calculated Tax amount value, but is included in the Tax amount column against each invoice (i.e. apart from rounding differences, the value in the Tax amount field on the Company totals line will not equal the Calculated Tax amount in the summary line).
-
The calculated summary by tax code will be inaccurate if GL Distribution lines were posted with the Tax only option in the GL Distribution pane of the AP Invoice Posting program.
The tax value on the report is calculated by applying the current tax rate against the Tax code, to the total merchandise value of the GL Distribution lines.
When you enter Tax only lines, then the merchandise value of the line is zero and the tax value is whatever value you enter in the Amount column.
The tax value is not a calculated value based on the Tax code which means that it is possible for the summary printed on the tax report not to balance back to the actual tax values entered.
Calculated GST amount If you are using the Canadian GST system, then this is the Taxable amount in the summary total line for the specific tax code multiplied by that tax code's Tax rate.
-
Although no rounding is applied to this calculation, rounding is applied to the tax values against each invoice in the GST amount column (i.e. the value in the Calculated GST amount column in the summary may not agree to the value in the GST amount field on the Company totals line).
-
If you set the Tax amount to equal the Total invoice amount in the AP Invoice Posting program, then this amount is not included in the Calculated Tax amount value, but is included in the GST amount column against each invoice (i.e. apart from rounding differences, the value in the GST amount field on the Company totals line will not equal the Calculated GST amount in the summary line).
EC Tax amount The sum of the values printed in the Tax on acquisition column.
-
-
Tax and QST on settlement discount are NOT included in this report.
Tax on settlement discount is, however, included in the Tax Return report.