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 Bank Account Activity variables in the Report Designer can be inserted into reports to display information about activity for a client bank account. The following tables provide details about each of these variables.
See also: Variables overview
Workpapers CS users: This section of variables, while visible in the Design Tools frame in the Report Designer, is not relevant to Workpapers CS. If any of these variables were to be used in reports or other documents for a Workpapers CS-only client, the notation "This report contains no data" would appear.
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Bank Account Description | Description of the bank account from Setup > Bank Accounts | Text | [BankAccountActivity.BankAccountDescription] |
| Bank Account Number | Bank account number from Setup > Bank Accounts | Number | [BankAccountActivity.BankAccountNumber] |
| Bank Account Number (last four digits) | Last four digits of the bank account number from Setup > Bank Accounts | Number | [BankAccountActivity.BankAccountNumberLastFourDigits] |
| Beginning Balance | Beginning balance of the bank account from Actions > Enter Trial Balance | Amount | [BankAccountActivity.BeginningBalance] |
| Current Balance | Current bank balance from the status bar on Actions > Enter Transactions | Amount | [BankAccountActivity.CurrentBalance] |
| Current Reconciliation Beginning Date | Beginning date of the current bank account reconciliation from Actions > Reconcile Bank Accounts | Date | [BankAccountActivity.CurrentReconciliationBeginningDate] |
| Current Reconciliation Ending Date | Ending date of the current bank account reconciliation from Actions > Reconcile Bank Accounts | Date | [BankAccountActivity.CurrentReconciliationEndingDate] |
| Current Tentative Balance | Tentative balance from the status bar on Actions > Enter Transactions | Amount | [BankAccountActivity.CurrentTentativeBalance] |
| GL Account Number | GL account number for the bank account from Setup > Bank Accounts | Text | [BankAccountActivity.GLAccount] |
| GL Account Description | GL account description for the bank account from Setup > Bank Accounts | Text | [BankAccountActivity.GLAccountDescription] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Bank Account Description | Description of the bank account selected on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.BankAccountDescription] |
| Bank Account GL Account | GL account number assigned to the bank account on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.BankAccountGLAccount] |
| Bank Account GL Description | Description of the GL account assigned to the bank account on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActibity.Deposit.BankAccountGLAccountDescription] |
| Bank Account Number | Bank account number of the bank account selected on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Number | [BankAccountActivity.Deposit.BankAccountNumber] |
| Bank Account Number (last four digits) | Last four digits of the bank account number of the bank selected on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Number | [BankAccountActivity.Deposit.BankAccountNumberLastFourDigits] |
| Bank Name | Name of the bank account selected on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.BankName] |
| Bank Routing Number | Routing number of the bank selected on a Deposit or AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Number | [BankAccountActivity.Deposit.BankRoutingNumber |
| Cash Back GL Account | Cash back GL account number from the Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.CashBackGLAccount] |
| Cash Back GL Account Description | Cash back GL account description from the Cash back field on the Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.CashBackGLAccountDescription] |
| Cash Back Memo | Text entered in the Cash back memo field on the Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.CashBackMemo] |
| Date | Date of a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Date | [BankAccountActivity.Deposit.Date] |
| Description | Description of a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.Description] |
| Journal Code | Journal code from the Journal field on a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.JournalCode] |
| Journal Description | Description of the Journal selected on a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.JournalDescription] |
| Posting Period | Posting period selected on a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Date | [BankAccountActivity.Deposit.PostingPeriod] |
| Reference | Reference entered on a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Text | [BankAccountActivity.Deposit.Reference] |
| Total Cash Amount | For a Deposit, this variable calculates the total amount of all positive amounts on the Details tab of Actions > Enter Transactions that contain "Cash" in the description. For AR Deposits, this variable calculates the total of the Cash type payments. | Amount | [BankAccountActivity.Deposit.TotalCashAmount] |
| Total Cash and Non-cash Amount | Calculates the total of a Deposit or AR Deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Amount | [BankAccountActivity.Deposit.TotalCashandNonCashAmount] |
| Total Cash and Non-cash Quantity | Calculates the total number of cash and non-cash items included in a deposit from the Actions > Enter Transactions or Actions > Enter Deposits screen. | Number | [BankAccountActivity.Deposit.TotalCashandNonCashQuantity] |
| Total Cash Back Amount | For a Deposit, this variable calculates the total amount of all negative amounts on the Details tab of Actions > Enter Transactions. For AR Deposits, displays the cash back amount field from Actions > Enter Deposits. | Amount | [BankAccountActivity.Deposit.TotalCashBackAmount] |
| Total Cash Quantity | Calculates the total number of items included in the total cash amount (see above). | Number | [BankAccountActivity.Deposit.TotalCashQuantity] |
| Total Deposit Amount | For Deposits, the amount field from Actions > Enter Transactions. For AR Deposits, calculates the total deposit amount (total cash amount + total non-cash amount - total cash back amount) from Actions > Enter Deposits. | Amount | [BankAccountActivity.Deposit.TotalDepositAmount] |
| Total Non-cash Amount | For a Deposit, this variable calculates the total amount of all positive amounts on the Details tab of Actions > Enter Transactions that do not contain "Cash" in the description. For AR Deposits, this variable calculates the total of the non-cash type payments. | Amount | [BankAccountActivity.Deposit.TotalNonCashAmount] |
| Total Non-cash Quantity | Calculates the total number of items included in the total non-cash amount (see above) | Number | [BankAccountActivity.Deposit.TotalNonCashQuantity] |
| Type | Type field of a Deposit or AR Deposit from Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Type] |
| Bank Business Address Line 1 | First line of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.AddressLine1] |
| Bank Business Address Line 1 and Line 2 | First and second lines of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.AddressLine1andAddressLine2] |
| Bank Business Address Line 2 | Second line of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.AddressLine2] |
| Bank Business Address City | City of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.City] |
| Bank Business Address City, State and Zip | City, state, and zip code of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.CityStateandZip] |
| Complete Bank Business Address | Complete bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Firm. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.CompleteAddress] |
| Complete Bank Business Address (single line) | Complete bank business address on a single line of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Firm. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.CompleteAddressSingleLine] |
| Bank Business Address Country | Country of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.Country] |
| Bank Business Address County | County of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.County] |
| Bank Business Address State (abbreviation) | State abbreviation of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.State] |
| Bank Business Address State (full name) | State name of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Business.StateName] |
| Bank Business Address Zip code | Zip code of the bank business address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Number | [BankAccountActivity.Deposit.BankAddresses.Business.Zip] |
| Bank Home Address Line 1 | First line of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.AddressLine1] |
| Bank Home Address Line 1 and Line 2 | First and second lines of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.AddressLine1andAddressLine2] |
| Bank Home Address Line 2 | Second line of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.AddressLine2] |
| Bank Home Address City | City of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.City] |
| Bank Home Address City, State and Zip | City, state, and zip code of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.CityStateandZip] |
| Complete Bank Home Address | Complete bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.CompleteAddress] |
| Complete Bank Home Address (single line) | Complete bank home address displayed on a single line of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.CompleteAddressSingleLine] |
| Bank Home Address Country | Country of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.Country] |
| Bank Home Address County | County of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.County] |
| Bank Home Address State (abbreviation) | State abbreviation of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.State] |
| Bank Home Address State (full name) | State name of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Home.StateName] |
| Bank Home Address Zip Code | Zip code of the bank home address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Number | [BankAccountActivity.Deposit.BankAddresses.Home.Zip] |
| Bank Mailing Address Line 1 | First line of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.AddressLine1] |
| Bank Mailing Address Line 1 and Line 2 | First and second lines of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.AddressLine1andAddressLine2] |
| Bank Mailing Address Line 2 | Second line of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.AddressLine2] |
| Bank Mailing Address City | City of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.City] |
| Bank Mailing Address City, State and Zip | City, state, and zip code of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.CityStateandZip] |
| Complete Bank Mailing Address | Complete bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.CompleteAddress] |
| Complete Bank Mailing Address (single line) | Complete bank mailing address on a single line of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.CompleteAddressSingleLine] |
| Bank Mailing Address Country | Country of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.Country] |
| Bank Mailing Address County | County of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.County] |
| Bank Mailing Address State (abbreviation) | State abbreviation of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.State] |
| Bank Mailing Address State (full name) | State name of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Mailing.StateName] |
| Bank Mailing Address Zip Code | Zip code of the bank mailing address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Number | [BankAccountActivity.Deposit.BankAddresses.Mailing.Zip] |
| Bank Other Address Line 1 | First line of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.AddressLine1] |
| Bank Other Address Line 1 and Line 2 | First and second lines of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.AddressLine1andAddressLine2] |
| Bank Other Address Line 2 | Second line of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.AddressLine2] |
| Bank Other Address City | City of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.City] |
| Bank Other Address City, State, and Zip | City, state, and zip code of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.CityStateandZip] |
| Complete Bank Other Address | Complete bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.CompleteAddress] |
| Complete Bank Other Address (single line) | Complete bank other address on a single line of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.CompleteAddressSingleLine] |
| Bank Other Address Country | Country of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.Country] |
| Bank Other Address State (abbreviation) | State abbreviation of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.State] |
| Bank Other Address State (full name) | State name of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Text | [BankAccountActivity.Deposit.BankAddresses.Other.StateName] |
| Bank Other Address Zip | Zip code of the bank other address of the bank selected on a Deposit or AR Deposit from Setup > Firm Information > Banks. | Number | [BankAccountActivity.Deposit.BankAddresses.Other.Zip] |
| Cash Details Amount | Positive amounts that contain "cash" in the description from the Details tab on Actions > Enter Transactions for a Deposit or AR Deposit type transaction. | Amount | [BankAccountActivity.Deposit.CashDetails.Amount] |
| Cash Details Description | Description of the positive amount line items from the Details tab on Actions > Enter Transactions fr a Deposit or AR Deposit type transaction. | Text | [BankAccountActivity.Deposit.CashDetails.Description] |
| Cash Payment Amount | Amount of the cash type payments included on an AR Deposit from Actions > Enter Deposits of Actions > Enter Deposits. | Amount | [BankAccountActivity.Deposit.CashPayments.Amount] |
| Cash Payment Customer ID | Customer ID of the cash type payments included on an AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.CashPayments.CustomerID] |
| Cash Payment Customer Name | Customer name of the cash type payments included on an AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.CashPayments.CustomerName] |
| Cash Payment Date | Date of the cash type payments included on an AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Date | [BankAccountActivity.Deposit.CashPayments.Date] |
| Cash Payment Reference | Reference of the cash type payments included on an AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.CashPayments.Reference] |
| Cash Payment Type | Type of the cash type payments included on an AR Deposit from Actions > Enter Transactions or Actions > Enter Deposits. | Text | [BankAccountActivity.Deposit.CashPayments.Type] |
| Client Business Address Line 1 | First line of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.AddressLine1] |
| Client Business Address Line 1 and Line 2 | First and second lines of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.AddressLine1andAddressLine2] |
| Client Business Address Line 2 | Second line of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.AddressLine2] |
| Client Business Address City | City of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.City] |
| Client Business Address City, State and Zip | City, state, and zip code of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.CityStateandZip] |
| Complete Client Business Address | Complete client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.CompleteAddress] |
| Complete Client Business Address (single line) | Complete client business address on a single line for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.CompleteAddressSingleLine] |
| Client Business Address Country | Country of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.Country] |
| Client Business Address County | County of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.County] |
| Client Business Address Municipality Code | Municipality code of the client business address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Business.MunicipalityCode] |
| Client Business Address Municipality Description | Municipality description of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.MunicipalityDescription] |
| Client Business Address School District Code | School district code of the client business address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Business.SchoolDistrictCode] |
| Client Business Address School District Description | School district description of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.SchoolDistrictDescription] |
| Client Business Address State (abbreviation) | State abbreviation of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.State] |
| Client Business Address State (full name) | State name of the client business address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Business.StateName] |
| Client Business Address Zip Code | Zip code of the client business address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Business.Zip] |
| Client Home Address Line 1 | First line of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.AddressLine1] |
| Client Home Address Line 1 and Line 2 | First and second lines of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.AddressLine1andAddressLine2] |
| Client Home Address Line 2 | Second line of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.AddressLine2] |
| Client Home Address City | City of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.City] |
| Client Home Address City, State, and Zip | City, state, and zip code of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.CityStateandZip] |
| Complete Client Home Address | Complete client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.CompleteAddress] |
| Complete Client Home Address (single line) | Complete client home address on a single line for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.CompleteAddressSingleLine] |
| Client Home Address Country | Country of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.Country] |
| Client Home Address County | County of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.County] |
| Client Home Address Municipality Code | Municipality code of the client home address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Home.MunicipalityCode] |
| Client Home Address Municipality Description | Municipality description of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.MunicipalityDescription] |
| Client Home Address School District Code | School district code of the client home address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Home.SchoolDistrictCode] |
| Client Home Address School District Description | School district description of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.SchoolDistrictDescription] |
| Client Home Address State (abbreviation) | State abbreviation of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.State] |
| Client Home Address State (full name) | State name of the client home address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Home.StateName] |
| Client Home Address Zip Code | Zip code of the client home address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Home.Zip] |
| Client Mailing Address Line 1 | First line of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.AddressLine1] |
| Client Mailing Address Line 1 and Line 2 | First and second lines of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.AddressLine1andAddressLine2] |
| Client Mailing Address Line 2 | Second line of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.AddressLine2] |
| Client Mailing Address City | City of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.City] |
| Client Mailing Address City, State, and Zip | City, state, and zip code of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.CityStateandZip] |
| Complete Client Mailing Address | Complete client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.CompleteAddress] |
| Complete Client Mailing Address (single line) | Complete client mailing address on a single line for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.CompleteAddressSingleLine] |
| Client Mailing Address Country | Country of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.Country] |
| Client Mailing Address County | County of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.County] |
| Client Mailing Address Municipality Code | Municipality code of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Mailing.MunicipalityCode] |
| Client Mailing Address Municipality Description | Municipality description of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.MunicipalityDescription] |
| Client Mailing Address School District Code | School district code of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Mailing.SchoolDistrictCode] |
| Client Mailing Address School District Description | School district description of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.SchoolDistrictDescription] |
| Client Mailing Address State (abbreviation) | State abbreviation of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.State] |
| Client Mailing Address State (full name) | State name of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Mailing.StateName] |
| Client Mailing Address Zip Code | Zip code of the client mailing address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Mailing.Zip] |
| Client Other Address Line 1 | First line of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.AddressLine1] |
| Client Other Address Line 1 and Line 2 | First and second lines of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.AddressLine1andAddressLine2] |
| Client Other Address Line 2 | Second line of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.AddressLine2] |
| Client Other Address City | City of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.City] |
| Client Other Address City, State and Zip | City, state, and zip code of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.CityStateandZip] |
| Complete Client Other Address | Complete client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.CompleteAddress] |
| Complete Client Other Address (single line) | Complete client other address on a single line for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.CompleteAddressSingleLine] |
| Client Other Address Country | Country of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.Country] |
| Client Other Address County | County of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.County] |
| Client Other Address Municipality Code | Municipality code of the client other address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Other.MunicipalityCode] |
| Client Other Address Municipality Description | Municipality description of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.MunicipalityDescription] |
| Client Other Address School District Code | School district code of the client other address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Other.SchoolDistrictCode] |
| Client Other Address School District Description | School district description of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.SchoolDistrictDescription] |
| Client Other Address State (abbreviation) | State abbreviation of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.State] |
| Client Other Address State (full name) | State name of the client other address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Other.StateName] |
| Client Other Address Zip Code | Zip code of the client other address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Other.Zip] |
| Client Taxing Address Line 1 | First line of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.AddressLine1] |
| Client Taxing Address Line 1 and Line 2 | First and second lines of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.AddressLine1andAddressLine2] |
| Client Taxing Address Line 2 | Second line of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.AddressLine2] |
| Client Taxing Address City | City of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.City] |
| Client Taxing Address City, State and Zip | City, state, and zip code of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.CityStateandZip] |
| Complete Client Taxing Address | Complete client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.CompleteAddress] |
| Complete Client Taxing Address (single line) | Complete client taxing address on a single line for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.CompleteAddressSingleLine] |
| Client Taxing Address Country | Country of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.Country] |
| Client Taxing Address County | County of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.County] |
| Client Taxing Address Municipality Code | Municipality code of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Taxing.MunicipalityCode] |
| Client Taxing Address Municipality Description | Municipality description of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.MunicipalityDescription] |
| Client Taxing Address School District Code | School district code of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Taxing.SchoolDistrictCode] |
| Client Taxing Address School District Description | School district description of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.SchoolDistrictDescription] |
| Client Taxing Address State (abbreviation) | State abbreviation of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.State] |
| Client Taxing Address State (full name) | State name of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Text | [BankAccountActivity.Deposit.ClientAddresses.Taxing.StateName] |
| Client Taxing Address Zip Code | Zip code of the client taxing address for a Deposit or AR Deposit from Setup > Clients. | Number | [BankAccountActivity.Deposit.ClientAddresses.Taxing.Zip] |
| Deposit Details Amount | Amount column of the details tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Amount | [BankAccountActivity.Deposit.Details.Amount] |
| Deposit Details Description | Description column of the Details tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Details.Description] |
| Deposit Distributions Amount | Amount column of the Distributions tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Amount | [BankAccountActivity.Deposit.Distributions.Amount] |
| Deposit Distributions Description | Description column of the Distributions tab of a Deposit or AR Deposit on Actions > Enter Transactions | Text | [BankAccountActivity.Deposit.Distributions.Description] |
| Deposit Distributions GL Account | GL account number from the Distributions tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Distributions.GLAccount] |
| Deposit Distributions GL Account Description | GL account description from the Distributions tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Distributions.GLAccountDescription] |
| Non-cash Deposit Amount | Amount of the positive amount line items that do not contain "Cash" in the description from the Details tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Amount | [BankAccountActivity.Deposit.NonCashDetails.Amount] |
| Non-cash Deposit Description | Description of the positive amount line items that do not contain "Cash" in the description from the Details tab of a Deposit or AR Deposit on Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.NonCashDetails.Description] |
| Non-cash Payments Amount | Amount of the non-cash payment types of an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Amount | [BankAccountActivity.Deposit.NonCashPayments.Amount] |
| Non-cash Payments Customer ID | Customer ID of the non-cash payment types of an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.NonCashPayments.CustomerID] |
| Non-cash Payments Customer Name | Customer name of the non-cash payment types of an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.NonCashPayments.CustomerName] |
| Non-cash Payments Date | Date of the non-cash payment types of an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Date | [BankAccountActivity.Deposit.NonCashPayments.Date] |
| Non-cash Payments Reference | Reference of the non-cash payment types of an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.NonCashPayments.Reference] |
| Non-cash Payments Type | Type of the non-cash payments of an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.NonCashPayments.Type] |
| Payment Amount | Amount of the payments on an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Amount | [BankAccountActivity.Deposit.Payments.Amount] |
| Payment Customer ID | Customer ID of the payments on an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Payments.CustomerID] |
| Payment Customer Name | Customer name of the payments on an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Payments.CustomerName] |
| Payment Date | Date of the payments on an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Date | [BankAccountActivity.Deposit.Payments.Date] |
| Payment Reference | Reference of the payments on an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Payments.Reference] |
| Payment Type | Type of the payments on an AR Deposit from Actions > Enter Deposits or Actions > Enter Transactions. | Text | [BankAccountActivity.Deposit.Payments.Type] |
| Variable name | Data content/source | Format | Variable syntax |
|---|---|---|---|
| Amount | Amount of a transaction distributed to the bank account from Actions > Enter Transactions | Amount | [BankAccountActivity.Transaction.Amount] |
| Date | Date of a transaction distributed to the bank account from Actions > Enter Transactions | Date | [BankAccountActivity.Transaction.Date] |
| Description | Description of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Description] |
| Journal Code | Journal code of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.JournalCode] |
| Journal Description | Journal description of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.JournalDescription] |
| Memo | Memo of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Memo] |
| Payee ID | Payee ID of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.PayeeID] |
| Payee Name | Payee name of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.PayeeName] |
| Posting Period | Posting period of a transaction distributed to the bank account from Actions > Enter Transactions | Date | [BankAccountActivity.Transaction.PostingPeriod] |
| Reference | Reference of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Reference] |
| Status | Status of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Status] |
| Type | Type of transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Type] |
| Application Distributions Amount | For AP check/payment type transactions: Applied Payable Distributions amount that is created when applying an AP check/payment to a payable. | Amount | [BankAccountActivity.Transaction.ApplicationDistributions.Amount] |
| Application Distributions Discount Taken Amount | For AP check/payment type transactions: Applied Payable Distributions Discount Taken Amount that is created when applying an AP check/payment to a payable. | Amount | [BankAccountActivity.Transaction.ApplicationDistributions.DiscountTakenAmount] |
| Application Distributions GL Account | For AP check/payment type transactions: Applied Payable Distributions GL Account that is created when applying an AP check/payment to a payable. | Text | [BankAccountActivity.Transaction.ApplicationDistributions.GLAccount] |
| Application Distributions GL Account Description | For AP check/payment type transactions: Applied Payable Distributions GL Account description that is created when applying an AP check/payment to a payable | Text | [BankAccountActivity.Transaction.ApplicationDistributions.GLAccountDescription] |
| Detail Amount | Amount from the details tab of a deposit type transaction on Actions > Enter Transactions | Amount | [BankAccountActivity.Transaction.Details.Amount] |
| Detail Description | Description from the details tab of a deposit type transaction on Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Details.Description] |
| 1099 Distribution | 1099 distribution of the transaction also distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Distributions.1099] |
| Distribution Amount | Distribution amount of a transaction distributed to the bank account from Actions > Enter Transactions | Amount | [BankAccountActivity.Transaction.Distributions.Amount] |
| Distribution Description | Distribution description of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Distributions.Description] |
| Distribution GL Account Number | Distribution GL account number of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Distributions.GLAccount] |
| Distribution GL Account Description | Distribution GL account description of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Distributions.GLAccountDescription] |
| Note | Note of a transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Notes.Note] |
| Primary Note | First note entered on a transaction on Actions > Enter Transactions that flows through to a bank account | Text | [BankAccountActivity.Transaction.Notes.PrimaryNote] |
| Payment Amount | Amount of an AP payment type transaction distributed to the bank account from Actions > Enter Transactions | Amount | [BankAccountActivity.Transaction.Payments.Amount] |
| Payment Customer ID | Customer ID of an AP payment type transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Payments.CustomerID] |
| Payment Customer Name | Customer name of an AP payment type transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Payments.CustomerName] |
| Payment Date | Date of an AP payment type transaction distributed to the bank account from Actions > Enter Transactions | Date | [BankAccountActivity.Transaction.Payments.Date] |
| Payment Reference | Reference of a payment type transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.Payments.Reference] |
| Payment Type | Type of a payment type transaction distributed to the bank account from Actions > Enter Transactions | Text | [BankAccountActivity.Transaction.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 |