Report Designer: Chart of Accounts variables

Show expandable text

We moved!

Help articles have been migrated to the new Help and Support. You can find help for your products and accounts, discover FAQs, explore training, and contact us!

The Chart of Accounts variables available from the Report Designer can be inserted into reports or statements to display information about the setup of the client's Chart of Accounts. The following tables provide details about each of these variables.

See also: Variables overview

Account Groupings

Variable name Data content/source Format Variable syntax
Description Description of the account grouping from Setup > Account Groupings Text [ChartofAccounts.AccountGroupings.Description]
Code Code(s) from Setup > Account Groupings Text [ChartofAccounts.AccountGroupings.Codes.Code]
Code Description Description of the code from Setup > Account Groupings Text [ChartofAccounts.AccountGroupings.Codes.CodeDescription]
Subcode Subcode(s) from Setup > Account Groupings Text [ChartofAccounts.AccountGroupings.Codes.Subcodes.Subcode]
Subcode Description Description of the subcode from Setup > Account Groupings Text [ChartofAccounts.AccountGroupings.Codes.Subcodes.SubcodeDescription]

Account Segments

Variable name Data content/source Format Variable syntax
Description Description of the account segment from Setup > Account Segments Text [ChartofAccounts.AccountSegments.Description]
Mask Mask of the account segment from Setup > Account Segments Text [ChartofAccounts.AccountSegments.Mask]
Code Segment code(s) from Setup > Account Segments Number [ChartofAccounts.AccountSegments.Codes.Code]
Code Description Segment code description from Setup > Account Segments Text [ChartofAccounts.AccountSegments.Codes.Description]
Inactive Code Inactive checkbox on Setup > Account Segments Yes/No [ChartofAccounts.AccountSegments.Codes.Inactive]
Code Combinations Code of the combined segments from Setup > Account Segments Text [ChartofAccounts.AccountSegments.Combinations.Code]
Combination Description Description of the combined segments from Setup > Account Segments Text [ChartofAccounts.AccountSegments.Combinations.Description]

Accounts

Variable name Data content/source Format Variable syntax
Classification Code Classification code for the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.ClassificationCode]
Classification Code Description Description of the classification code for the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.ClassificationCodeDescription]
Classification Subcode Classification subcode for the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.ClassificationSubcode]
Classification Subcode Description Description of the classification subcode for the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.ClassificationSubcodeDescription]
Core GL Account Number Core account number from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.CoreGLAccount]
Core GL Account Description Name of the core account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.CoreGLAccountDescription]
GL Account Number Account number from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.GLAccount]
GL Account Description Name of the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.GLAccountDescription]
Inactive Inactive checkbox from Setup > Chart of Accounts Yes/No [ChartofAccounts.Accounts.Inactive]
M-3 Tax Code M-3 tax code from Setup > Chart of Accounts Number [ChartofAccounts.Accounts.M3TaxCode]
M-3 Tax Code Custom Description Custom description of the M-3 tax code from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.M3TaxCodeCustomDescription]
M-3 Tax Code Description Description of the M-3 tax code from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.M3TaxCodeDescription]
M-3 Tax Code Subcode M-3 tax code subcode from Setup > Chart of Accounts Number [ChartofAccounts.Accounts.M3TaxCodeSubcode]
Mask Chart of accounts mask from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.Mask]
Tax Code Outputs tax code from Setup > Tax Codes Number [ChartofAccounts.Accounts.TaxCode]
Tax Code Custom Description User-defined description of a tax code from Setup > Tax Codes Text [ChartofAccounts.Accounts.TaxCodeCustomDescription]
Tax Code Description Description of the tax code from Setup > Tax Codes Text [ChartofAccounts.Accounts.TaxCodeDescription]
Tax Code Subcode Subcode of the tax code from Setup > Tax Codes Number [ChartofAccounts.Accounts.TaxCodeSubcode]
Tax Code Unit Unit of the tax code from Setup > Tax Codes Number [ChartofAccounts.Accounts.TaxCodeUnit]
Tickmark Tickmark on the account Image [ChartofAccounts.Accounts.Tickmark]
Tickmark Description Description of the tickmark on the account Text [ChartofAccounts.Accounts.TickmarkDescription]
Type Code Type code of the account (A, L, etc.) from the background tables Text [ChartofAccounts.Accounts.TypeCode]
Type Description Description of the account type (Asset, Liability, etc.) Text [ChartofAccounts.Accounts.TypeDescription]
Workpaper Reference Workpaper reference on the account Text [ChartofAccounts.Accounts.WPReference]
Grouping Code Account grouping code on the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.AccountGroupings.Code]
Grouping Code Description Description of the account grouping code on the account from Setup > Account Groupings Text [ChartofAccounts.Accounts.AccountGroupings.CodeDescription]
Grouping Description Description of the account grouping on the account (Account Classification, Leadsheet Schedule, etc.) from Setup > Account Groupings Text [ChartofAccounts.Accounts.AccountGroupings.Description]
Grouping GL Account Number GL account number from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.AccountGroupings.GLAccount]
Grouping GL Account Description GL account description from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.AccountGroupings.GLAccountDescription]
Grouping Subcode Account grouping subcode on the account from Setup > Chart of Accounts Text [ChartofAccounts.Accounts.AccountGroupings.Subcode]
Grouping Subcode Description Account grouping subcode description on the account from Setup > Account Groupings Text [ChartofAccounts.Accounts.AccountGroupings.SubcodeDescription]
Grouping Type Code Account grouping type code for the grouping code from Setup > Account Groupings Text [ChartofAccounts.Accounts.AccountGroupings.TypeCode]
Grouping Type Code Description Account grouping type code description for the grouping code from Setup > Account Groupings Text [ChartofAccounts.Accounts.AccountGroupings.TypeDescription]

Tickmarks

Variable name Data content/source Format Variable syntax
Description Description of the tickmark from Setup > Firm Information > Tickmarks Text [ChartofAccounts.Tickmarks.Description]
Image Image of a tickmark from Setup > Firm Information > Tickmarks Image [ChartofAccounts.Tickmarks.Image]
Text Text of a tickmark from Setup > Firm Information > Tickmarks Text [ChartofAccounts.Tickmarks.Text]
Type Type of a tickmark (image or text) from Setup > Firm Information > Tickmarks Text [ChartofAccounts.Tickmarks.Type]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!