• Linkage Functions
  • ACT Function
  • BALDESC Function
  • CLASS Function
  • CLASSDESC Function
  • CURLANG Function
  • CVEXCEL Function
  • DESC Function
  • DMDESC Function
  • DOCNUM Function
  • ENTABBR Function
  • ENTCLP Function
  • ENTDESC Function
  • Entity Function
  • GRP Function
  • GRPDESC Function
  • GRPENT Function
  • ISINGRP Function
  • Linkage Functions
  • LS Function
  • LSDESC Function
  • M3TAX Function
  • MAP Function
  • MAPDESC Function
  • MASK Function
  • NUMTOTDID Function
  • RATE Function
  • RAWENT Function
  • TAX Function
  • TDIDTONUM Function

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

• Linkage Functions