Bank Deposit Balance

The Bank Deposit Balance (BDB) page provides the user with a snapshot for a Bank account on a given day. This includes Open Deposits, Return Items, Adjustments, Total Bank Balance, Book Balance, and Variances between the bank and Advantage. Records are inserted into the inquiry by the Update Bank Balance system process. If making updates from a BAI file provided by the bank, then the BAI to XML system process must be run first. Also, key to updates to this inquiry are running the Check Reconciliation and Deposit Reconciliation processes before the update to this inquiry. Furthermore, updates to this inquiry are only possible for banks with a Bank Account Status of Active or Closing.

The Update Bank Deposit Balance process loads data in Bank Deposit Balance and compares the information from the bank with the information on Deposit Reconciliation (DPREC) before populating the Bank Deposit Balance (BDB) page. If a Bank is specified as Auto Reconciliation equal true on the Bank Account Reference page, the opening and closing balances are recorded from the BAI file that is processed by the BAI to XML system process. If the Bank has Auto Reconciliation set to false, the opening and closing balances are recorded from the previous day’s transactions on Deposit Reconciliation.

The following provides clarity for each section of fields that are not self-evident. When the BAI Deposit Configuration page is mentioned, it is best to search that page with the mentioned criteria to see the list of possibilities included in an amount.

Field Name	Field Description
Bank Balance	With Auto Reconciliation, amounts in this section come from the following BAI file fields to give the bank’s balances and activity. Bank Balance Beginning Balance = Bank Begin Amount Receipts = Bank Receipt Amount Issue = Bank Issue Amount Closing Balance = Bank Close Amount Variance: (Bank Balance Beginning Balance + Bank Balance Receipts + Bank Balance Issues) – (Bank Balance Closing Balance) Without Auto Reconciliation amounts are as follows: Beginning Balance: Populated by previous day’s Closing Balance Receipts: The sum of positive Cash Receipts and Bank Transfer Transactions that are processed Issues: The sum of negative Cash Receipts and Bank Transfer Transactions that are processed Closing Balance: Beginning Balance + Receipts - Issues Variance: (Bank Balance Beginning Balance + Bank Balance Receipts + Bank Balance Issues) – (Bank Balance Closing Balance)
Open Deposits	Amounts in this section are only populated if using Auto Reconciliation to give just the deposit activity from the bank. Receipts are summed where the BAI Deposit Configuration file match has Activity Type of Debit and Reconciliation Category Type of Open Deposit. Issues are summed where the BAI Deposit Configuration file match has Activity Type of Credit and Reconciliation Category Type of Open Deposit.
Returns	Amounts in this section are only populated if using Auto Reconciliation to give just return activity from the bank. Receipts are summed where the BAI Deposit Configuration file match has Activity Type of Debit and Reconciliation Category Type of Return. Issues are summed where the BAI Deposit Configuration file match has Activity Type of Credit and Reconciliation Category Type of Return.
Adjustments	Amounts in this section are only populated if using Auto Reconciliation to give just return activity from the bank. Receipts are summed where the BAI Deposit Configuration file match has Activity Type of Debit and Reconciliation Category Type of Adjustment. Issues are summed where the BAI Deposit Configuration file match has Activity Type of Credit and Reconciliation Category Type of Adjustment.
Total Bank Balance	This section is a summation of the previous 4 sections and only relevant if using Auto Reconciliation. Beginning Balance: Bank Balance Beginning Balance + Open Deposits Beginning Balance + Returns Beginning Balance + Adjustments Beginning Balance Receipts: Bank Balance Receipts + Open Deposits Receipts + Returns Receipts + Adjustments Receipts Issues: Bank Balance Issues + Open Deposits Issues + Returns Issues + Adjustments Issues Closing Balance: Bank Balance Closing Balance + Open Deposits Closing Balance + Returns Closing Balance + Adjustments Closing Balance Variance: Total Bank Balance Beginning Balance + Total Bank Balance Receipts + Total Bank Balance Issues – Total Bank Balance Closing Balance
Book Balance	This section calculates what Advantage has for the bank account. Beginning Balance: This is set by a previous run closing balance. Receipts: The sum of positive Cash Receipts and Bank Transfer Transactions that are processed. Issues: The sum of negative Cash Receipts and Bank Transfer Transactions that are processed Closing Balance: Book Balance Beginning Balance + Book Balance Receipts + Book Balance Issues Variance: Book Balance Beginning Balance + Book Balance Receipts + Book Balance Issues – Book Balance Closing Balance
Receipts to Issues Match	This section calculates the difference between what is in Advantage and what was reported by the bank. Beginning Balance: Book Balance Beginning Balance – Total Bank Balance Beginning Balance Receipts: Book Balance Receipts – Total Bank Balance Receipts Issues: Book Balance Issues – Total Bank Balance Issues Closing Balance: Book Balance Closing Balance - Total Bank Balance Closing Balance Variance: Receipts to Issues Match Beginning Balance + Receipts to Issues Match Receipts + Receipts to Issues Match Issues – Receipts to Issues Match Closing Balance
Balance Variance	Beginning Balance: Book Balance Beginning Balance - Total Bank Balance Beginning Balance Receipts: Receipts to Issues Match Receipts + Receipts to Issues Match Issues Issues: Receipts to Issues Match Receipts + Receipts to Issues Match Issues – Receipts to Issues Match Receipts + Receipts to Issues Match Issues Closing Balance: Book Balance Closing Balance - Total Bank Balance Closing Balance Variance: Book Balance Beginning Balance – Total Bank Balance Beginning Balance + Receipts to Issues Match Receipts + Receipts to Issues Match Issues + Receipts to Issues Match Receipts + Receipts to Issues Match Issues – Receipts to Issues Match Receipts + Receipts to Issues Match Issues – Book Balance Closing Balance – Total Bank Balance Closing Balance