TAX Function

The TAX function returns the balance for the specified tax code from the Tax tab of the Working Trial Balance in the client file.

Syntax

TAX(<"Sign">,"Value","Code")

Where

Sign represents the ability to state the sign of the group or to filter particular accounts in the group based on their balance (debit or credit). Available parameters are:

"C"

Credit group - where the sign of the balance is reversed

"CO"

Credit only - only include accounts with credit balances

"DO"

Debit only - only include accounts with credit balances

Value represents the type of balance to link to the cell.

Code represents the tax code.

Example 1

TAX("BR","13.A")

Returns the active year to date report balance for all accounts assigned to tax code 13.A, the U.S. code for Depreciation.

Example 2

TAX("DO","BR","13.A").

Returns the active year to date report balance for all accounts with debit balances assigned to tax code 13.A, the U.S. code for Depreciation.

Related Topics