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.