M3TAX Function

The M3TAX function returns the balance for the specified M3 code. A list of valid M3 codes can be found in the M3 Code drop-down list in the Tax tab of the Working Trial Balance or in the Assign M3 Codes dialog (Account | Assign Groupings | M3 Codes from the Working Papers ribbons).

Syntax

M3TAX(<"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). Sign is an optional parameter. Available values for Sign 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 debit balances

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

Code represents the M3 tax code.

Example 1

M3TAX("BR","M3213A")

Returns the active year to date report balance for all accounts assigned to M3 tax code M3213A, the code for Interest Income (Book).

Example 2

M3TAX("DO", "BTF","M3213A").

Returns the active year to date federal tax balance for all accounts with debit balances assigned to M3 tax code M3213A, the code for Interest Income (Book).

Related Topics