Bank Deposit Details Screen

  1. Open Common Services > Bank Services > Bank Transactions > Reconcile Statements.
  2. On the Reconcilitation tab, select a deposit that includes multiple receipts.
  3. Click the Details button or press F9.

This field appears only if the deposit has a status of Reconcile By Deposit Detail.

Initially, this field displays the total value of the deposit. After you clear some details, make sure the value in this field matches the sum of the details you set to Cleared.

Note: This field appears only for deposits with a status of Reconcile By Deposit Detail.

By default, this field is set to the Reconcilition Date entered for the deposit on the Reconciliation tab of the Bank Reconcile Statements screen.

When you set a receipt's status to Cleared, this date will automatically be assigned as the Reconciliation Date for the receipt. Also, if the Default Reconciliation Status is set to Cleared, and you click the Go Go button  button, the date specified in this field will be assigned as the Reconciliation Date for all receipts in the deposit.

As long as the status of a receipt is Cleared, you can manually change its reconciliation date.

The deposit date is the date you deposited the receipts at the bank. (Accounts Receivable prints the date on the deposit slip for the deposit number.)

The deposit date may be different from the batch date and the receipt dates.

Displays the total amount of a deposit in the bank's statement currency.

  • For multicurrency banks, the statement currency is specified in the bank record.
  • For bank transfers, the amount deposited via the bank transfer is converted to the bank's statement currency.

    For banks that are not multicurrency, the statement currency is the functional currency.

Note: This field appears only for deposits with a status of Reconcile By Deposit Detail.

By default, this field is set to the Reconcilition Description entered for the deposit on the Reconciliation tab of the Reconcile Statements screen.

When you set a receipt's status to Cleared, this description is automatically assigned as the Reconciliation Description for the receipt. Also, if the Default Reconciliation Status is set to Cleared, and you click the Go Go button button, the description specified in this field is assigned as the Reconciliation Description for all receipts in the deposit.

As long as the status of a receipt is Cleared, you can manually change its Reconciliation Description.

This field displays the description used for the posted deposit (or bank transfer).

This field displays the number assigned when the deposit was saved in Sage 300.

Displays the total amount that is outstanding for a deposit.

The reconciliation status for the posted deposit (or bank transfer) appears in this field.

You cannot change the field.

Indicates whether the listed transactions are sorted by transaction date or number.

Note: This setting is specified in the Sort Deposit Details by field on the Processing tab of the Bank Options screen.

Note: This field appears only for deposits with a status of Reconcile By Deposit Detail.

By default, this field is set to Cleared.

If this field is set to Cleared, and you click the Go Go button button, the values specified in the Default Reconciliation section are assigned as the Reconciliation Date, Reconciliation Description, and Reconciliation Status for all receipts in the deposit.

This field displays the batch number for a receipt.

This field displays the cleared amount for a receipt.

This field displays the date for a receipt.

This field displays the difference between the deposit amount and the cleared amount for a receipt.

This field displays, for each receipt on the list, the entry number within the receipt batch.

This field displays the customer number for a receipt.

This field displays the name of the customer for a receipt.

This field displays the amount of a receipt in the bank's statement currency.

This field displays the receipt number for a receipt. It also lets you drill down to view a selected receipt in the original transaction entry screen. (To drill down to the original entry, select the detail line, and then click the Drilldown Drilldown button button in the Receipt No. column heading.)

This field displays the reconciliation date for a receipt.

This field displays the reconciliation description for a receipt.

This field displays the reconciliation period for a receipt.

This field displays the reconciliation status for a receipt.

This field displays the reconciliation year for a receipt.

Overview

You use the Bank Deposit Details screen as follows:

  • If you set a deposit’s status to anything other than Reconcile By Deposit Detail on the Bank Reconcile Statements screen, the Bank Deposit Details screen lets you:

    • View a list of the individual receipts that make up a selected deposit.
    • Drill down to view a selected receipt in the original transaction entry screen.

      To drill down to the original entry, select the detail line, and then click the Drilldown Drilldown button button in the Receipt No. column heading.

    • View the total amount of the deposit, as well as totals for the receipts you have cleared and the receipts that remain outstanding.

  • If you set a deposit’s status to Reconcile By Deposit Detail on the Bank Reconcile Statements screen, the Bank Deposit Details screen lets you do everything listed above, and it also lets you:

    • Reconcile individual receipts.
    • Define default reconciliation settings (status, date, and description) to be assigned to receipts.

The Bank Deposit Details screen displays totals for cleared amounts. These total amounts are the same as those displayed on the Totals tab of the Bank Reconcile Statements screen, except that they relate to a single deposit, rather than the whole bank account.

Note: Depending on the status of the deposit, some totals fields may not be displayed.