Language:


HansaManuals Home   >> Standard ERP   >> Nominal Ledger   >> Settings  

Previous   Next               Entire Chapter in Printable Form               Search  

This text refers to program version 8.5  

Tax Reports - The Tax Reports Setting

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 Reports setting, which you can use to define the tax calculation formulae that will be used in your custom reports. Each record in this setting will contain a complete report definition.

To enter a new Tax Report definition or to edit an existing one, first ensure you are in the Nominal Ledger and then open the 'Settings' list by clicking (Windows/macOS) or tapping (iOS/Android) the [Settings] button in the Navigation Centre. You can also use the Ctrl-S (Windows) or ⌘-S (macOS) keyboard shortcuts. Double-click or tap 'Tax Reports' in the list. The 'Tax Reports: Browse' window will be opened, listing the Tax Report definitions that you have previously entered. Double-click or tap a record in the list to edit it, or add a new record by selecting 'New' from the Create menu (Windows/macOS) or + menu (iOS/Android). When the record is complete, save it by clicking the [Save] button (Windows/macOS) or by tapping √ (iOS/Android). You can also click the close box or tap < and choose to save changes. To close it without saving changes, click the close box or tap <.

Code
Enter a unique code to identify a Tax Report record (i.e. a set of report definitions). You can use up to ten alpha-numeric characters.

Name
Enter a name for the Tax Report record. This Name will be shown in the 'Tax Records: Browse' window and the 'Paste Special' list so it should be descriptive enough to make the selection of the correct Tax Report record easy for all users.

Delimiter
Specify the character that you will use to separate the parameters in the formula commands. It is recommended that you use the semi colon (;). This has been used in the illustration above and in the examples below. Do not use the colon (:) because this is used to separate the first and last Accounts in a range.

If you leave this field empty, you should use the comma to separate the parameters in the formula commands. But this may produce unexpected (and incorrect) results if you are using the comma as the Thousands, Decimal or Date Separator in the Company Date and Numeric Formats setting in the System module (or, if you are using them, in the Client Date and Numeric Formats setting in the User Settings module or on the 'Formats' card of the user's Person record). If you are using the comma as the Thousands, Decimal or Date Separator, make sure you enter a different character here as the Delimiter, and that you use that character to separate the parameters in the formula commands.
Enter the report definitions (formulae) in the grid. Do not include any spaces in the formulae.

Flip A

Code
Enter a unique Code to identify each row (i.e. each formula).

You should use this Code to refer to the row in other formulae (i.e. in other rows), when it must be preceded by the # character. #SALES and #TAXPERC in row 3 of the illustration are examples, referring to rows 1 and 2 respectively. The Code referred to must already have been defined. Therefore, in the example illustration, the TAXSUM row must appear below the SALES and TAXPERC rows. If you place the TAXSUM row above the SALES and TAXPERC rows, the result of the TAXSUM row will be 0.00. # is alt-3 on the UK macOS keyboard.

Formula
The formula that will be used to calculate the value of the row. The commands that you can use in the formulae are listed immediately below.

Comment
Enter a name for the row of the report, to be shown in the Tax Calculations report. You can choose to omit rows without a Comment from this report.

Flip B

Format
You can specify a format to be used when the result of the formula is printed. You must specifying separate formatting rules for positive numbers, zero and negative numbers, in that order, separated by semi-colons (;). For example:
#,###,###.##;0.00;-#,###,###.##
#,###.##;0.00;(#,###.##)
# ###$;0$;-# ###$
####;zero;(-####)

If you do not specify a format, the decimal and thousands separators will be taken from the Date and Numeric Format setting, and the following format will be used:

#,###.##;0.00;-#,###.##

If you specify a Format, you then have a choice whether to use it when you print the Tax Calculations report. If you want to use it, select the Use Format option when you print the report. However, the Format will always be used in the Tax Report form.

You can use the commands listed below in the Formula field. These commands are not case sensitive. Use the Delimiter character to separate the parameters in each command.
TO(Account Code;Date 1;Date 2;Type)
This command returns the net change between Date 1 and Date 2 for the specified Account.

Use the Type parameter as follows:
C
returns the net change resulting from credit postings to the specified Account

D
returns the net change resulting from debit postings to the specified Account

A
returns the overall net change (Debit - Credit)

Some examples of the use of this command are as follows:
TO(100;01/01/2020;31/12/2020;C)
Returns the sum of the credit postings to Account 100 for the year 2020.

TO(100:1999;01/01/2020;31/12/2020;A)
Returns the sum of the net changes in Accounts 100 to 1999 for the year 2020. The Accounts in the range will be determined using an alpha sort, rather than a numeric one. So Account 1000001 will be included in the example range, while Account 200 will not.

-TO(100:1999;01/01/2020;31/12/2020;A)
As the previous example, but the sign of the final figure will be changed. This will be useful when displaying figures for sales, which are stored as negative figures in Standard ERP. Prefixing the TO command with a minus sign will cause sales to be displayed as positive figures in the report.

OTO(Tag/Object Code;Account Code;Date 1;Date 2;Type)
This command is similar to TO, but in calculating the net change during the period for the specified Account or Accounts, only postings with the specified Tag/Object Code will be taken into account.

The reference to the Tag/Object Code is case sensitive. For example:
OTO(A;100;01/01/2020;31/12/2020;C)
Returns the sum of the credit postings with Tag/Object A to Account 100 for the year 2020. Credit postings with Tag/Object a will not be included.

VTO(VAT Code;Account Code;Date 1;Date 2;Type)
This command is similar to TO, but in calculating the net change during the period for the specified Account or Accounts, only postings with the specified VAT Code will be taken into account.

The reference to the VAT Code is case sensitive.

TO2(Debit Account Code;Credit Account Code;Date 1;Date 2)
This command returns the net change between two Accounts (i.e. between two corresponding Accounts) between Date 1 and Date 2. For example:
TO2(750;100;01/01/2020;31/12/2020)
Returns the sum of the postings during the year 2020 where Account 750 is the debit Account and 100 is the corresponding credit Account.

TO2(750;100:1999;01/01/2020;31/12/2020)
Returns the sum of the postings during the year 2020 where Account 750 is the debit Account and any Account between 100 and 1999 is the corresponding credit Account.

OTO2(Tag/Object Code;Debit Account Code;Credit Account Code;Date 1;Date 2)
This command is similar to TO2, but in calculating the net change between the corresponding Accounts, only double-sided postings in which the specified Tag/Object Code is used on both sides will be taken into account.

The reference to the Tag/Object Code is case sensitive.

BAL(Account Code;Date;Type)
This command returns the balance for the specified Account on the specified Date. It therefore differs from the TO command in that balances brought forward from previous periods are taken into account.

The command can return the sum of the balances of a range of Accounts in the same manner as the TO command: please refer to the description of the TO command above for examples.

OBAL(Tag/Object Code;Account Code;Date;Type)
This command is similar to BAL, but in calculating the balance for the specified Account on the specified date, only postings with the specified Tag/Object Code will be taken into account.

VBAL(VAT Code;Account Code;Date;Type)
This command is similar to BAL, but in calculating the balance for the specified Account on the specified date, only postings with the specified VAT Code will be taken into account.

ABS(expression)
This command returns the absolute (positive) value of the expression. The expression can be a hard-coded number or a formula that uses one of the Tax Report commands. For example:
ABS(-1)
Returns 1

ABS(1)
Returns 1

ABS(TO(100:1999;01/01/2020;31/12/2020;A))
Returns the sum of the net changes in the income Accounts 100 to 1999 for the year 2020, expressed as a positive figure. Balances for income Accounts are stored as negative figures in Standard ERP.

SIGN(expression)
This command returns the following:
1
if the value of the expression is positive

-1
if the value of the expression is negative

0
the value of the expression is zero

The expression can be a hard-coded number or a formula that uses one of the Tax Report commands. For example:
SIGN(TO(100:1999;01/01/2020;31/12/2020;A))
Returns -1 since the balances of income Accounts are negative

SIGN(ABS(TO(100:1999;01/01/2020;31/12/2020;A)))
Returns 1, since the ABS command expresses the balances of income Accounts as positive figures

ROUND(expression;number of decimal places)
This command returns the value of the expression rounded to the specified number of decimal places. The expression can be a hard-coded number or a formula that uses one of the Tax Report commands. For example:
ROUND(1234.24;0)
Returns 1234

ROUND(1234.24;1)
Returns 1234.2

ROUND(1234.24;-2)
Returns 1200

ROUND(TO(100:1999;01/01/2020;31/12/2020;A);2)
Returns the sum of the net changes in the income Accounts 100 to 1999 for the year 2020, rounded to two decimal places.

IF(expression;return 1;return 2)
This command returns the following:
return 1
if the value of the expression is positive or zero

return 2
if the value of the expression is negative

The expression, return 1 and return 2 can all be hard-coded numbers or formulae that use one of the Tax Report commands. For example:
IF(BAL(100;31/12/2020;A);1;-1)
Returns 1 if BAL(100;31/12/2020;A) is positive or -1 if it is negative

NOT(expression)
Returns 1 if the value of the expression is 0 or 1 otherwise.

APDUE(Number of days;Date 1)
This command returns the total in the Purchase Ledger that is overdue for payment by more than the specified number of days on Date 1. For example, APDUE(30;31/12/2020) will return the total that became due 30 days or more before 31/12/2020.

ARDUE(Number of days;Date 1)
This command is the Sales Ledger equivalent of APDUE above.

Dates
If you need to include a date in a formula, you can hard-code it as in the examples above, or, preferably, you can use one of the following variables:
#D1
The first date of the report period, as entered in the report or form specification window.

#D2
The last date of the report period, as entered in the report or form specification window.

#D3, #D4
The Previous Dates, as entered in the report or form specification window. You could use these two dates, for example, to define a period whose figures are to be compared with the main report period (#D1 and #D2).

It is recommended that you use these variables, to ensure that you can use your formulae at any time without modification.

For example, to print the closing balance for Account 100 for the report period 1/1/2020:31/12/2020, you could hard-code the date in the formula as follows:
BAL(100;31/12/2020;A)

Alternatively, you could take the date from the report period, as follows:
BAL(100;#D2;A)
---

Settings in the Nominal Ledger:

Go back to:

Previous   Next   Top            Entire Chapter in Printable Form