Tax Reports - The Tax Calculations Report
The Tax Reports feature in Standard ERP:
---
The Tax Reports setting together with the Tax Calculations report and the Tax Report form allows you to design and produce custom reports. This page describes the Tax Calculations report, which you can use to test the formulae that you have listed in a record in the Tax Reports setting (as described here) and to check the results. As you add or change formulae in a record in the Tax Reports setting, you can recalculate this report to see the consequences of the changes immediately.
When you double-click (Windows/macOS) or tap (iOS/Android) 'Tax Calculations' in the 'Reports' list in the Nominal Ledger, the 'Specify Tax Calculations' window will open:
- Period
- Paste Special
Reporting Periods setting, System module
- Specify the period to be covered by the report.
- To refer to the first date of this period in your formulae, use the expression #D1.
- To refer to the last date of this period in your formulae, use the expression #D2.
- Previous Date (D3), Previous Date (D4)
- Paste Special
Choose date
- Enter any comparison dates that might be required by the formulae in your record in the Tax Reports setting. To refer to these dates in your formulae, use the expressions #D3 and #D4.
- Report
- Paste Special
Tax Reports setting, Nominal Ledger
- Specify the record in the Tax Report setting that contains the formulae that you wish to test.
- Display Values in
- Paste Special
Currency register, System module
- Specify the Currency that is to be used in the report. Leave the field empty to use the home Currency (Base Currency 1).
- Don't Show Formula
- By default, the Code and Formula of each row in the Tax Report record will be printed in the report. Use this option if you don't want this information to be printed.
- Don't Show Rows with Empty Comments
- Use this option if you want rows in the Tax Report record that do not have Comments to be omitted from the report.
- Use Format
- Use this option if you have specified a Format on flip B of any row in the Tax Report record and if you want the figure resulting from that row to be printed using that Format.
When the specification window is complete, press the [Run] button in the Button Bar. The resulting report contains a separate line for each row in the record in the
Tax Reports setting:
The calculated result of the formula will be shown in the second column, while the formula itself will be shown in the fourth column (providing you did not select the
Don't Show Formula option).
---
Settings in the Nominal Ledger:
Go back to: