Report Designer: Impound Bank Account Reconciliation 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 Report Designer Impound Bank Account Reconciliation variables display information on reports about the current reconciliation for the firm impound bank account. The following tables list all of the currently available variables, what they output, and where the information is retrieved from within the application.

See also: Variables overview

Workpapers CS users: This section of variables is visible in the Design Tools frame in the Report Designer, but will not output any information. If any of these variables are inserted, the report or other document may display as "This report contains no data."

Impound Bank Account Reconciliation

Variable name Data content/source Format Variable syntax
Beginning Balance The beginning balance of the bank account Amount [ImpoundBankAccountReconciliation.BankAccountBeginningBalance]
Checks and Payments The total credits (checks and payments) for the bank account Amount [ImpoundBankAccountReconciliation.BankAccountChecksandPayments]
Deposits and Additions The total debits (deposits and additions) for the bank account Amount [ImpoundBankAccountReconciliation.BankAccountDepositsandAdditions]
Bank Account Description The impound bank account description from Setup > Firm Information > Impound Bank Accounts Text [ImpoundBankAccountReconciliation.BankAccountDescription]
Bank Account Ending Adjusted Balance The ending adjusted balance for the bank account from Actions > Enter Trial Balance Amount [ImpoundBankAccountReconciliation.BankAccountEndingAdjustedBalance]
Bank Account Ending Unadjusted Balance The ending unadjusted balance for the bank account from Actions > Enter Trial Balance Amount [ImpoundBankAccountReconciliation.BankAccountEndingUnadjustedBalance]
Bank Account Number The impound bank account number from Setup > Firm Information > Impound Bank Accounts Number [ImpoundBankAccountReconciliation.BankAccountNumber]
Bank Account Number (last four digits) The last four digits of the impound bank account number from Setup > Firm Information > Impound Bank Accounts Number [ImpoundBankAccountReconciliation.BankAccountNumberLastFourDigits]
Bank Account Type The impound bank account type (checking or savings) from Setup > Firm Information > Impound Bank Accounts Text [ImpoundBankAccountReconciliation.BankAccountType]
Bank Name The impound bank name from Setup > Firm Information > Impound Bank Accounts Text [ImpoundBankAccountReconciliation.BankName]
Bank Routing Number The impound bank routing number from Setup > Firm Information > Impound Bank Accounts Number [ImpoundBankAccountReconciliation.BankRoutingNumber]
Bank Statement Beginning Balance The beginning balance of the impound bank account from the General Information tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.BankStatementBeginningBalance]
Bank Statement Beginning Date The beginning statement date of the impound bank account from the General Information tab of Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconciliation.BankStatementBeginningDate]
Bank Statement Checks and Payments The total checks and payments of the impound bank account from the General Information tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.BankStatementChecksandPayments]
Bank Statement Deposits and Additions The total deposits and additions of the impound bank account from the General Information tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.BankStatementDepositsandAdditions]
Bank Statement Ending Balance The ending balance of the impound bank account from the General Information tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.BankStatementEndingBalance]
Bank Statement Ending Date The ending statement date of the impound bank account from the general Information tab of Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconcilation.BankStatementEndingDate]

Adjustments to Cleared Items

Variable name Data content/source Format Variable syntax
Adjustment Amount The Adjustment column for cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.AdjustmentAmount]
Client ID The client ID for cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.ClientID]
Client Name The client name for cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.ClientName]
Date The date of the cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.Date]
Description The description of the cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.Description]
GL Account Number The GL account number for the cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.GLAccount]
GL Account Description The GL account description for the cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.GLAccountDescription]
Reference The reference for the cleared items with adjustments from Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.Reference]
Total Adjustment Amount The calculated total amount of the adjustments made to cleared items on Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.AdjustmentstoClearedItems.TotalAdjustmentAmount]

Cleared Checks and Payments

Variable name Data content/source Format Variable syntax
Adjustment GL Account Number The GL account number for the cleared item adjustments on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.ClearedChecksandPayments.AdjustmentGLAccount]
Adjustment GL Account Description The GL account description for the cleared item adjustments on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedChecksandPayments.AdjustmentGLAccountDescription]
Amount The amount of the cleared items on the Checks and Payments tab on Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.ClearedChecksandPayments.Amount]
Client ID The client ID of the cleared items on the Checks and Payments tab on Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedChecksandPayments.ClientID]
Client Name The client name of the cleared items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedChecksandPayments.ClientName]
Date The date of the cleared items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconciliation.ClearedChecksandPayments.Date]
Description The description of the cleared items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedChecksandPayments.Description]
GL Account Number The GL account number distributions of the cleared items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.ClearedChecksandPayments.GLAccount]
GL Account Description The GL account description of the cleared items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedChecksandPayments.GLAccountDescription]
Reference The reference of the cleared items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedChecksandPayments.Reference]
Total Amount The cleared total from the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.ClearedChecksandPayments.TotalAmount]

Cleared Deposits and Additions

Variable name Data content/source Format Variable syntax
Adjustment GL Account Number The GL account number for the cleared item adjustments on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.AdjustmentGLAccount]
Adjustment GL Account Description The GL account description for the cleared item adjustments on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.AdjustmentGLAccountDescription]
Amount The amount of the cleared items on the Deposits and Additions tab on Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.Amount]
Client ID The client ID of the cleared items on the Deposits and Additions tab on Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.ClientID]
Client Name The client name of the cleared items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.ClientName]
Date The date of the cleared items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.Date]
Description The description of the cleared items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.Description]
GL Account Number The GL account number distributions of the cleared items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.GLAccount]
GL Account Description The GL account description of the cleared items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.GLAccountDescription]
Reference The reference of the cleared items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.Reference]
Total Amount The cleared total from the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.ClearedDepositsandAdditions.TotalAmount]

Open Checks and Payments

Variable name Data content/source Format Variable syntax
Amount The Amount of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.OpenChecksandPayments.Amount]
Client ID The client ID of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenChecksandPayments.ClientID]
Client Name The client name of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenChecksandPayments.ClientName]
Date The date of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconciliation.OpenChecksandPayments.Date]
Description The description of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenChecksandPayments.Description]
GL Account Number The distribution GL account number of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.OpenChecksandPayments.GLAccount]
GL Account Description The distribution GL account description of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenChecksandPayments.GLAccountDescription]
Reference The reference of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenChecksandPayments.Reference]
Total Amount The calculated total amount of the open items on the Checks and Payments tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.OpenChecksandPayments.TotalAmount]

Open Deposits and Additions

Variable name Data content/source Format Variable syntax
Amount The amount of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.Amount]
Client ID The client ID of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.ClientID]
Client Name The client name of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts text [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.ClientName]
Date The date of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Date [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.Date]
Description The description of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.Description]
GL Account Number The distribution GL account number of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Number [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.GLAccount]
GL Account Description The distribution GL account description of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.GLAccountDescription]
Reference The reference of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Text [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.Reference]
Total Amount The calculated total amount of the open items on the Deposits and Additions tab of Actions > Reconcile Impound Bank Accounts Amount [ImpoundBankAccountReconciliation.OpenDepositsandAdditions.TotalAmount]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!