Accounting CS
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 Activity variables from the Report Designer can be inserted into reports or statements to display activity for each account in the client’s Chart of Accounts. The following tables provide details about each of these variables.
See also: Variables overview
Workpapers CS users: Some of the variables in this section, while visible in the Design Tools frame in the Report Designer, may not be relevant to Workpapers CS and if used in reports or other documents for a Workpapers CS-only client would display the notation "This report contains no data."
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of the activity for a particular account based on the date range selected on the report, calculated from Actions > Enter Trial Balance | Amount | [ChartofAccountsActivity.Amount] |
| Beginning Balance | Beginning balance for an account from Actions > Enter Trial Balance | Amount | [ChartofAccountsActivity.BeginningBalance] |
| Core GL Account Number | Core GL account number for the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.CoreGLAccount] |
| Core GL Account Description | Core GL account description for the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.CoreGLAccountDescription] |
| GL Account Number | GL account number for the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.GLAccount] |
| GL Account Description | GL account description for the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.GLAccountDescription] |
| Tickmark | Tickmark on the account from Actions > Enter Trial Balance | Image | [ChartofAccountsActivity.Tickmark] |
| Tickmark Description | Description of the tickmark on the account from Setup > Firm Information > Tickmarks | Text | [ChartofAccountsActivity.TickmarkDescription] |
| Type Code | Type code of the account from the background table based on the classification code assigned to the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.TypeCode] |
| Type Description | Type code description of the account from the background table based on the classification code assigned to the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.TypeDescription] |
| Workpaper Reference | Workpaper reference on the account from Actions > Enter Trial Balance | Text | [ChartofAccountsActivity.WPReference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| AJE Amount | Amount of an adjusting journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.AdjustingJournalEntry.Amount] |
| Auto-reverse Next Period | Auto-reverse next period checkbox on Actions > Enter Transactions | Yes/no | [ChartofAccountsActivity.AdjustingJournalEntry.AutoReverseNextPeriod] |
| Date | Date of an adjusting journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.AdjustingJournalEntry.Date] |
| Description | Description of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.Description] |
| Journal Code | Journal code of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.JournalCode] |
| Journal Description | Name of the journal an adjusting journal entry is written to from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.JournalDescription] |
| Net Income Effect | Net income effect of an adjusting journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.AdjustingJournalEntry.NetIncomeEffect] |
| Entry Posting Period | Posting period of an adjusting journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.AdjustingJournalEntry.PostingPeriod] |
| Reference | Reference of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.Reference] |
| WP Reference | Workpaper reference of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.WPReference] |
| Distribution Amount | Distribution amount of an adjusting journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.AdjustingJournalEntry.Distributions.Amount] |
| Distribution Description | Distribution description of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account name of an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.Distributions.GLAccountDescription] |
| Distribution WP Reference | Distribution workpaper reference for an adjusting journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.AdjustingJournalEntry.Distributions.WPReference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Core Amount | Calculated amount of the core account from Actions > Enter Trial Balance | Amount | [ChartofAccountsActivity.Core.Amount] |
| Beginning Balance | For reports in the Accounting folder, the calculated beginning balance as of the start of the date range selected for the report for the core account
Note: For Financial Statements, use the ChartofAccountsActivity.Core.Amount variable with a period of CB for the current year beginning balance, or [(CY) - (CP)] for the beginning balance of the current period. Other period selections can also be used to display the desired values. |
Amount | [ChartofAccountsActivity.Core.BeginningBalance] |
| Core GL Account Number | Core GL account number from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.Core.GLAccount] |
| Core GL Account Description | Name of the core GL account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.Core.GLAccountDescription] |
| Core Account Type Code | Type code of the core accounts from the background table based on the classification code assigned to the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.Core.TypeCode] |
| Core Account Type Description | Description of the type code from the background table based on the classification code assigned to the account from Setup > Chart of Accounts | Text | [ChartofAccountsActivity.Core.TypeDescription] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Calculated value of the net income or loss based on the account groupings assigned to accounts.
Note: When the "TAX" basis is chosen in the Cell Properties, the variable will also take into consideration the adjustments made on Actions > Enter Tax Code Adjustments |
Amount | [ChartofAccountsActivity.NetIncomeLoss.Amount] |
| Chart of Accounts Activity Amount | Calculated value of net income or loss based on the account groupings affected by the transactions entered on Actions > Enter Transactions | Amount | [ChartofAccountsActivity.NetIncomeLoss.ChartofAccountsActivityAmount] |
| Tax Code Adjustment Activity Amount | Calculated value of net income or loss based on the account groupings impacted by the items entered on Actions > Enter Tax Code Adjustments.
Note: The Cell Properties must have the "TAX" basis in order for this variable to output the correct information |
Amount | [ChartofAccountsActivity.NetIncomeLoss.TaxCodeAdjustmentActivityAmount] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of an other journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.OtherJournalEntry.Amount] |
| Date | Date of an other journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.OtherJournalEntry.Date] |
| Description | Description of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.Description] |
| Difference | Difference field of an other journal entry from Actions > Enter Transactions (Permanent or Temporary) | Text | [ChartofAccountsActivity.OtherJournalEntry.Difference] |
| Journal Code | Journal code of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.JournalCode] |
| Journal Description | Name of the journal of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.JournalDescription] |
| Net Income Effect | Net income effect of an other journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.OtherJournalEntry.NetIncomeEffect] |
| Posting Period | Posting period of an other journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.OtherJournalEntry.PostingPeriod] |
| Reference | Reference of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.Reference] |
| Workpaper Reference | Workpaper reference of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.WPReference] |
| Distribution Amount | Distribution amount of an other journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.OtherJournalEntry.Distributions.Amount] |
| Distribution Description | Distribution description of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account number of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account name of an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.Distributions.GLAccountDescription] |
| Distribution Workpaper Reference | Workpaper reference of the distribution for an other journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.OtherJournalEntry.Distributions.WPReference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Impound Liabilities Amount | Amount of the impound liabilities of a payroll journal entry from the background tables | Amount | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.Amount] |
| Bank Account Description | Name of the bank account for the impound liabilities on the payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.BankAccountDescription] |
| Bank Account Number | Bank account number for the impound liabilities on the payroll journal entry from the background tables | Number | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.BankAccountNumber] |
| Bank Account Number (last four digits) | Last four digits of the bank account number for the impound liabilities on the payroll journal entry from the background tables | Number | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.BankAccountNumberLastFourDigits] |
| Impound Liabilities Date | Date of the impound liabilities from the payroll journal entry from the background tables | Date | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.Date] |
| Impound Liabilities GL Account Number | GL Account for the impound liabilities on the payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.GLAccount] |
| Impound Liabilities GL Account Description | GL Account description for the impound liabilities on the payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.GLAccountDescription] |
| Impound Liabilities Reference | Reference for the impound liabilities payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.ImpoundLiabilities.Reference] |
| Payroll Amount | Amount of the payroll on a payroll journal entry from the background tables | Amount | [ChartofAccountsActivity.PayrollJournalEntry.Payroll.Amount] |
| Payroll Date | Date of the payroll on a payroll journal entry from the background tables | Date | [ChartofAccountsActivity.PayrollJournalEntry.Payroll.Date] |
| Payroll GL Account Number | GL account of the payroll on a payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.Payroll.GLAccount] |
| Payroll GL Account Description | GL account description of the payroll on a payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.Payroll.GLAccountDescription] |
| Payroll Reference | Reference of the payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.Payroll.Reference] |
| Vendor Activity Amount | Amount of the vendor activity on a payroll journal entry from the background tables | Amount | [ChartofAccountsActivity.PayrollJournalEntry.VendorActivity.Amount] |
| Vendor Activity Date | Date of the vendor activity on a payroll journal entry from the background tables | Date | [ChartofAccountsActivity.PayrollJournalEntry.VendorActivity.Date] |
| Vendor Activity GL Account Number | GL account of the vendor activity on a payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.VendorActivity.GLAccount] |
| Vendor Activity GL Account Description | GL account description of the vendor activity on a payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.VendorActivity.GLAccountDescription] |
| Vendor Activity Reference | Reference of the vendor activity on a payroll journal entry from the background tables | Text | [ChartofAccountsActivity.PayrollJournalEntry.VendorActivity.Reference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of a potential journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.PotentialJournalEntry.Amount] |
| Date | Date of a potential journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.PotentialJournalEntry.Date] |
| Description | Description of a potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Description] |
| Journal Code | Journal code for the potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.JournalCode] |
| Journal Description | Name of the journal for the potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.JournalDescription] |
| Misstatement | Misstatement field selection for the potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Misstatement] |
| Net Income Effect | Net income effect of the potential journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.PotentialJournalEntry.NetIncomeEffect] |
| Posting Period | Posting period of the potential journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.PotentialJournalEntry.PostingPeriod] |
| Reference | Reference of the potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Reference] |
| Workpaper Reference | Workpaper reference of the potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.WPReference] |
| Distribution Amount | Distribution amount of a potential journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.PotentialJournalEntry.Distributions.Amount] |
| Distribution Description | Distribution description of a potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account of a potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account name of a potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Distributions.GLAccountDescription] |
| Distribution Workpaper Reference | Distribution workpaper reference of a potential journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.PotentialJournalEntry.Distributions.WPReference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of a reclassifying journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.ReclassifyingJournalEntry.Amount] |
| Date | Date of a reclassifying journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.ReclassifyingJournalEntry.Date] |
| Description | Description of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.Description] |
| Difference | Selection made in the Difference field of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.Difference] |
| Journal Code | Journal code of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.JournalCode] |
| Journal Description | Journal name of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.JournalDescription] |
| Net Income Effect | Net income effect of a reclassifying journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.ReclassifyingJournalEntry.NetIncomeEffect] |
| Posting Period | Posting period of a reclassifying journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.ReclassifyingJournalEntry.PostingPeriod] |
| Reference | Reference of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.Reference] |
| Workpaper Reference | Workpaper reference of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.WPReference] |
| Distribution Amount | Distribution amount of a reclassifying journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.ReclassifyingJournalEntry.Distributions.Amount] |
| Distribution Description | Distribution description of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account description of a reclassifying journal entry from Actions > Enter Transactions | Text | ]ChartofAccountsActivity.ReclassifyingJournalEntry.Distributions.GLAccountDescription] |
| Distribution Workpaper Reference | Distribution workpaper reference of a reclassifying journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.ReclassifyingJournalEntry.Distributions.WPReference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of a regular journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.RegularJournalEntry.Amount] |
| Auto-Reverse Next Period | Auto-reverse next period checkbox on Actions > Enter Transactions for regular journal entries | Yes/No | [ChartofAccountsActivity.RegularJournalEntry.AutoReverseNextPeriod] |
| Date | Date of a regular journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.RegularJournalEntry.Date] |
| Description | Description of a regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.Description] |
| Journal Code | Journal code of the journal for the regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.JournalCode] |
| Journal Description | Journal name for the regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.JournalDescription] |
| Net Income Effect | Net income effect of the regular journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.RegularJournalEntry.NetIncomeEffect] |
| Posting Period | Posting period of a regular journal entry from Actions > Enter Transaction | Date | [ChartofAccountsActivity.RegularJournalEntry.PostingPeriod] |
| Reference | Reference of a regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.Reference] |
| Distribution Amount | Distribution amount of a regular journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.RegularJournalEntry.Distributions.Amount] |
| Distribution Description | Distribution description of a regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account of a regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account description of a regular journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.RegularJournalEntry.Distributions.GLAccountDescription] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of a tax adjustment journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Amount] |
| Date | Date of a tax adjustment journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Date] |
| Description | Description of a tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Description] |
| Difference | Difference selection (temporary or permanent) for the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Difference] |
| Journal Code | Journal code the tax adjustment journal entry was written to from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.JournalCode] |
| Journal Description | Journal description the tax adjustment journal entry was written to from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.JournalDescription] |
| Net Income Effect | Net income effect of the tax adjustment journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.NetIncomeEffect] |
| Posting Period | Posting period of the tax adjustment journal entry from Actions > Enter Transactions | Date | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.PostingPeriod] |
| Reference | Reference of the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournelEntry.Reference] |
| Workpaper Reference | Workpaper reference of the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.WPReference] |
| Distribution Amount | Distribution amount of the tax adjustment journal entry from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Distributions.Amount] |
| Distribution Description | Distribution description of the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account number for the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account description for the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Distributions.GLAccountDescription] |
| Distribution WP Reference | Distribution workpaper reference for the tax adjustment journal entry from Actions > Enter Transactions | Text | [ChartofAccountsActivity.TaxAdjustmentJournalEntry.Distributions.WPReference] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of a transaction from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.Transaction.Amount] |
| Auto-Reverse Next Period | Auto-reverse next period checkbox on Actions > Enter Transactions | Yes/no | [ChartofAccountsActivity.Transaction.AutoReverseNextPeriod] |
| Bank Account Description | Bank account description for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.BankAccountDescription] |
| Bank Account Number | Bank account number for the transaction from Actions > Enter Transactions and Setup > Bank Accounts | Number | [ChartofAccountsActivity.Transaction.BankAccountNumber] |
| Bank Account Number (last four digits) | Last four digits of the bank account number for the transaction from Actions > Enter Transactions | Number | [ChartofAccountsActivity.Transaction.BankAccountNumberLastFourDigits] |
| Date | Date of the transaction from Actions > Enter Transactions | Date | [ChartofAccountsActivity.Transaction.Date] |
| Description | Description of the transaction from Actions > Enter Transaction | Text | [ChartofAccountsActivity.Transaction.Description] |
| Difference | Difference selection for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transation.Difference] |
| Journal Code | Journal code for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.JournalCode] |
| Journal Description | Journal description for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.JournalDescription] |
| Memo | Memo for the transaction from ACtions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Memo] |
| Misstatement | Misstatement selection for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Misstatement] |
| Net Income Effect | Net income effect of the transaction from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.Transaction.NetIncomeEffect] |
| Payee ID | Payee ID for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.PayeeID] |
| Payee Name | Payee name of the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.PayeeName] |
| Posting Period | Posting period of the transaction from Actions > Enter Transactions | Date | [ChartofAccountsActivity.Transaction.PostingPeriod] |
| Reference | Reference of the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Reference] |
| Status | Status of the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Status] |
| Subtype | Transaction subtype from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Subtype] |
| Type | Transaction type from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Type] |
| Workpaper Reference | Workpaper reference for the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.WPReference] |
| Check Summary Memo Amount | Amount of a check summary memo transaction from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.Transaction.CheckSummaryMemoDetails.Amount] |
| Check Summary Memo Date | Date of a check summary memo transaction from Actions > Enter Transactions | Date | [ChartofAccountsActivity.Transaction.CheckSummaryMemoDetails.Date] |
| Check Summary Memo Description | Description of a check summary memo transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.CheckSummaryMemoDetails.Description] |
| Check Summary Memo Reference | Reference of a check summary memo transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.CheckSummaryMemoDetails.Reference] |
| Detail Amount | Detail amount of a deposit type transaction from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.Transaction.Details.Amount] |
| Detail Description | Detail description of a deposit type transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Details.Description] |
| 1099 Distributions | 1099 form and box distribution of the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Distributions.1099] |
| Distribution Amount | Distribution amount of a transaction from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.Transaction.Distributions.Amount] |
| Distribution GL Account Number | Distribution GL account number from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Transaction.Distribution.GLAccount] |
| Distribution GL Account Description | Distribution GL account description from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Distributions.GLAccountDescription] |
| Distribution GL Account Type Code | Type code of the distribution GL account from the background tables based on the classification code assigned to the account from Actions > Enter Transactions and Setup > Chart of Accounts | Text | [ChartofAccountsActivity.Distributions.GLAccountTypeCode] |
| Distribution GL Account Type Description | Type code description of the distribution GL account from the background tables based on the classification code assigned to the account from Actions > Enter Transactions and Setup > Chart of Accounts | Text | [ChartofAccountsActivity.Distributions.GLAccountTypeDescription] |
| Source | Source of the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Distributions.Source] |
| Workpaper Reference | Distribution workpaper reference, from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Distributions.WPReference] |
| Notes | Note on the transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Notes.Note] |
| Payment Amount | Amount of a payment type transaction from Actions > Enter Transactions | Amount | [ChartofAccountsActivity.Payments.Amount] |
| Payment Customer ID | Customer ID of a payment type transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Payments.CustomerID] |
| Payment Customer Name | Customer name of a payment type transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Payments.CustomerName] |
| Payment Date | Date of a payment type transaction from Actions > Enter Transactions | Date | [ChartofAccountsActivity.Payments.Date] |
| Payment Reference | Reference of a payment type transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Payments.Reference] |
| Payment Type | Type of payment transaction from Actions > Enter Transactions | Text | [ChartofAccountsActivity.Payments.Type] |
See also: Report Designer: Procedures
Was this article helpful?
Great! Can you tell us why? (optional)
We're sorry. Can you tell us why? (optional)
Thank you for the feedback!
|
Continuing education and training Get the most out of your Thomson Reuters Tax & Accounting products. Our continued learning packages will teach you how to better use the tools you already own, while earning CPE credit. Learn more. |
|
Product information and alerts |
|
Contact Support Chat - Best option for simple questions Call us at +1 800 968 0600. You might like to see our hours and menu options before calling |