Report Designer: Bank Account 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 Bank Account variables in the Report Designer can be inserted into reports or statements to display information about the client-level setup of bank account information. 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.

Bank Account

Variable name Data content/source Format Variable syntax
Account Holder Name Bank account holder name from Setup > Bank Accounts Text [BankAccount.AccountHolderName]
Account Number Bank account number from Setup > Bank Accounts Number [BankAccount.AccountNumber]
Account Number (last four digits) Last four digits of the bank account number from Setup > Bank Accounts Number [BankAccount.AccountNumberLastFourDigits]
Account Type Type of bank account (checking or savings) from Setup > Bank Accounts Text [BankAccount.AccountType]
Bank Name Bank name from Setup > Bank Accounts Text [BankAccount.BankName]
Bank Routing Number Bank routing number from Setup > Bank Accounts Number [BankAccount.BankRoutingNumber]
Description Description of the bank account from Setup > Bank Accounts Text [BankAccount.Description]
Inactive Inactive checkbox on Setup > Bank Accounts Yes/No [BankAccount.Inactive]

Direct Deposit Balanced File

>
Variable name Data content/source Format Variable syntax
Payroll Checks Payroll checks checkbox in the Balanced File section on the Direct Deposit tab of Setup > Bank Accounts Yes/No [BankAccount.DirectDepositBalancedFile.PayrollChecks]
Tax Deposits Tax deposits checkbox in the Balanced File section on the Direct Deposit tab of Setup > Bank Accounts Yes/No [BankAccount.DirectDepositBalancedFile.TaxDeposits]
Vendor Checks Vendor checks checkbox in the Balanced File section on the Direct Deposit tab of Setup > Bank Accounts Yes/No [BankAccount.DirectDepositBalancedFile.VendorChecks]

Direct Deposit Destination

Variable name Data content/source Format Variable syntax
Bank Name Name of the bank selected as the immediate destination bank from the Direct Deposit tab of Setup > Bank Accounts Text [BankAccount.DirectDepositDestination.BankName]
Bank Routing Number Routing number of the bank selected as the immediate destination bank from the Direct Deposit tab of Setup > Bank Accounts Number [BankAccount.DirectDepositDestination.BankRoutingNumber]

Direct Deposit Originator

Variable name Data content/source Format Variable syntax
Bank Name Name of the bank selected as the originator bank from the Direct Deposit tab of Setup > Bank Accounts Text [BankAccount.DirectDepositOriginator.BankName]
Routing Number Routing number of the bank selected as the originator bank from the Direct Deposit tab of Setup > Bank Accounts Number [BankAccount.DirectDepositOriginator.BankRoutingNumber]

Direct Deposit Prenote Information

Variable name Data content/source Format Data content/source
Status Bank account prenote status from the Direct Deposit tab of Setup > Bank Accounts Text [BankAccount.DirectDepositPrenoteInformation.Status]

General Ledger

Variable name Data content/source Format Variable syntax
GL Account Number GL account number assigned to the bank account from the Main tab of Setup > Bank Accounts Text [BankAccount.GeneralLedger.GLAccount]
GL Account Description GL account description assigned to the bank account from the Main tab of Setup > Clients Text [BankAccount.GeneralLedger.GLAccountDescription]
Reconciliation JE Reference Journal entry reference to use when adjustments are made on the bank account reconciliation from the Main tab of Setup > Bank Accounts Text [BankAccount.GeneralLedger.ReconciliationJEReference]

Images

Variable name Data content/source Format Variable syntax
Logo Client logo from the Check Layout tab of Setup > Bank Accounts Image [BankAccount.Images.Logo]
Signature 1 Client signature 1 from the Check Layout tab of Setup > Bank Accounts Image [BankAccount.Images.Signature1]
Signature 2 Client signature 2 from the Check Layout tab of Setup > Bank Accounts Image [BankAccount.Images.Signature2]

MICR

Variable name Data content/source Format Variable syntax
Digits for Auxiliary On-Us Digits to allow for auxiliary on-us selection made on the Check Layout tab of Setup > Bank Accounts Number [BankAccount.MICR.DigitsforAuxiliaryOnUs]
MICR Line Complete MICR line, in the special MICR font and formatting from the Check Layout tab of Setup > Bank Accounts Number [BankAccount.MICR.MICRLine]
Print Beginning On-Us Character Print beginning on-us character checkbox on the Check Layout tab of Setup > Bank Accounts Yes/No [BankAccount.MICR.PrintBeginningOnUsCharacter]
Starting Position for On-Us Starting position for on-us section selection from the Check Layout tab of Setup > Bank Accounts Number [BankAccount.MICR.StartingPositionforOnUs]

References

Variable name Data content/source Format Variable syntax
Next Check Number Next check number from the Main tab of Setup > Bank Accounts Number [BankAccount.References.NextCheckNumber]
Skipped Check Number Skipped check numbers for the bank account from the background tables Number [BankAccount.References.SkippedCheckNumber]
Skipped Zero Net Check Reference Skipped zero net check reference numbers for the bank account from the background tables Number [BankAccount.References.SkippedZeroNetCheckReference]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!