Report Designer: 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 Bank Account Reconciliation variables available in the Report Designer can be inserted into reports to display client 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 Reconciliation

Variable name Data content/source Format Variable syntax
Beginning Balance Beginning balance for the bank account from Actions > Enter Trial Balance Amount [BankAccountReconciliation.BankAccountBeginningBalance]
Checks and Payments Total credits (checks and payments) for the bank account from Actions > Enter Trial Balance Amount [BankAccountReconciliation.BankAccountChecksandPayments]
Deposits and Additions Total debits (deposits and additions) for the bank account from Actions > Enter Trial Balance Amount [BankAccountReconciliation.BankAccountDepositsandAdditions]
Description Description of the bank account being reconciled from Setup > Bank Accounts Text [BankAccountReconciliation.BankAccountDescription]
Ending Adjusted Balance Ending adjusted balance of the bank account from Actions > Enter Trial Balance Amount [BankAccountReconciliation.BankAccountEndingAdjustedBalance]
Ending Unadjusted Balance Ending unadjusted balance of the bank account from Actions > Enter Trial Balance Amount [BankAccountReconciliation.BankAccountEndingUnadjustedBalance]
Account Number Bank account number of the account being reconciled from Setup > Bank Accounts Nuumber [BankAccountReconciliation.BankAccountNumber]
Account Number (last four digits) Last four digits of the bank account number of the bank account being reconciled from Setup > Bank Accounts Number [BankAccountReconciliation.BankAccountNumberLastFourDigits]
Account Type Type of bank account (checking or savings) being reconciled from Setup > Bank Accounts Text [BankAccountReconciliation.BankAccountType]
Bank Name Bank name of the bank account being reconciled from Setup > Bank Accounts Text [BankAccountReconciliation.BankName]
Routing Number Routing number of the bank account being reconciled from Setup > Bank Accounts Number [BankAccountReconciliation.BankRoutingNumber]
Statement Beginning Balance Bank account beginning balance from the bank statement entered on the General Information tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.BankStatementBeginningBalance]
Statement Beginning Date Statement beginning date from the General Information tab of Actions > Reconcile Bank Accounts Date [BankAccountReconciliation.BankStatementBeginningDate]
Statement Checks and Payments Total checks and payments (credits) for the bank account entered on the General Information tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.BankStatementChecksandPayments]
Statement Deposits and Additions Total deposits and additions (debits) for the bank account entered on the General Information tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.BankStatementDepositsandAdditions]
Statement Ending Balance Bank statement ending balance from the General Information tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.BankStatementEndingBalance]
Statement Ending Date Statement ending date from the General Information tab of Actions > Reconcile Bank Accounts Date [BankAccountReconciliation.BankStatementEndingDate]
Statement Errors Bank errors amount from the Account Summary tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.BankStatementErrors]

Adjustments to Cleared Items

Variable name Data content/source Format Variable syntax
Adjustment Amount Amount of an adjustment to a cleared item on the Checks and Payments tab and/or the Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.AdjustmentstoClearedItems.AdjustmentAmount]
Cleared Amount Cleared amount of a cleared item on the Checks and Payments tab and/or the Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.AdjustmentstoClearedItems.ClearedAmount]
Date Date of a cleared item with an adjustment from the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Date [BankAccountReconciliation.AdjustmentstoClearedItems.Date]
Description Description of the cleared item with an adjustment from the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.AdjustmentstoClearedItems.Description]
GL Account Number GL account number for the cleared item with an adjustment from the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.AdjustmentstoClearedItems.GLAccount]
GL Account Description G account description for the cleared item with an adjustment from the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.AdjustmentstoClearedItems.GLAccountDescription]
Original Amount Original amount of the cleared item with an adjustment from the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.AdjustmentstoClearedItems.OriginalAmount]
Reference Reference of the cleared item with an adjustment from the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.AdjustmentstoClearedItems.Reference]
Total Adjustment Amount Total adjustment amount of a cleared item on the Checks and Payments and/or Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.AdjustmentstoClearedItems.TotalAdjustmentAmount]

Cleared Checks and Payments

Variable name Data content/source Format Variable syntax
Adjustment GL Account Number GL account number for the adjustment to the cleared item from the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedChecksandPayments.AdjustmentGLAccount]
Adjustment GL Account Description GL account description for the adjustment to the cleared item from the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedChecksandPayments.AdjustmentGLAccountDescription]
Amount Cleared amount of the item from the Checks and Payments tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClearedChecksandPayments.Amount]
Date Date of the cleared item on the Checks and Payments tab of Actions > Reconcile Bank Accounts Date [Bank Account Reconciliation.ClearedChecksandPayments.Date]
Description Description of the cleared item on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedChecksandPayments.Description]
GL Account Number Distribution GL account number of the cleared item on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedChecksandPayments.GLAccount]
GL Account Description Distribution GL account description of the cleared item on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedChecksandPayments.GLAccountDescription]
Reference Reference of the cleared item on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedChecksandPayments.Reference]
Total Amount Cleared total amount from the Checks and Payments tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClearedChecksandPayments.TotalAmount]

Cleared Deposits and Additions

Variable name Data content/source Format Variable syntax
Adjustment GL Account Number GL account number for the adjustment to the cleared item from the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedDepositsandAdditions.AdjustmentGLAccount]
Adjustment GL Account Description GL account description for the adjustment to the cleared item from the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedDepositsandAdditions.AdjustmentGLAccountDescription]
Amount Amount of a cleared item from the Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClearedDepositsandAdditions.Amount]
Date Date of a cleared item on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Date [BankAccountReconciliation.ClearedDepositsandAdditions.Date]
Description Description of the cleared item on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedDepositsandAdditions.Description]
GL Account Number Distribution GL account number for the cleared item from the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedDepositsandAdditions.GLAccount]
GL Account Description Distribution GL account description for the cleared item from the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedDepositsandAdditions.GLAccountDescription]
Reference Reference of the cleared item on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClearedDepositsandAdditions.Reference]
Total Amount Cleared total on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClearedDepositsandAdditions.TotalAmount]

Client Adjustment Transmittal

Variable name Data content/source Format Variable syntax
Adjustment Amount Amount from the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClientAdjustmentTransmittal.BankAccountAdjustmentAmount]
Difference Amount Amount from the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClientAdjustmentTransmittal.BankAccountDifferenceAmount]
Ending Balance Ending bank account balance entered on the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClientAdjustmentTransmittal.BankAccountEndingBalance]
Ending Balance Text Description of the ending bank balance from the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClientAdjustmentTransmittal.BankAccountEndingBalanceText]
Ending Corrected Balance Amount from the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClientAdjustmentTransmittal.BankAccountEndingCorrectedBalance]
Detail Amount Amount from the grid on the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.ClientAdjustmentTransmittal.Details.Amount]
Detail Text Detail from the grid on the Client Adjustment Transmittal tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.ClientAdjustmentTransmittal.Details.Text]

Open Checks and Payments

Variable name Data content/source Format Variable syntax
Amount Amount of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.OpenChecksandPayments.Amount]
Date Date of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Date [BankAccountReconciliation.OpenChecksandPayments.Date]
Description Description of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenChecksandPayments.Description]
GL Account Number Distribution GL account number of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenChecksandPayments.GLAccount]
GL Account Description Distribution GL account description of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenChecksandPayments.GLAccountDescription]
Reference Reference of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenChecksandPayments.Reference]
Total Amount Total amount of the open items on the Checks and Payments tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.OpenChecksandPayments.TotalAmount]

Open Deposits and Additions

Variable name Data content/source Format Variable syntax
Amount Amount of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.OpenDepositsandAdditions.Amount]
Date Date of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Date [BankAccountReconciliation.OpenDepositsandAdditions.Date]
Description Description of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenDepositsandAdditions.Description]
GL Account Number Distribution GL account number of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenDepositsandAdditions.GLAccount]
GL Account Description Distribution GL account description of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenDepositsandAdditions.GLAccountDescription]
Reference Reference of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Text [BankAccountReconciliation.OpenDepositsandAdditions.Reference]
Total Amount Total amount of the open items on the Deposits and Additions tab of Actions > Reconcile Bank Accounts Amount [BankAccountReconciliation.OpenDepositsandAdditions.TotalAmount]

See also: Report Designer: Procedures

Was this article helpful?

Thank you for the feedback!