- More > Bank Transactions > Reconcile Statements.
- On the Reconciliation tab, click the Edit
button in the Deposits column of an entry.
Fields and controls
Cleared Amount
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.
Date (Default Reconciliation)
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 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.
Date (Deposit)
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.
Deposit Total
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.
Description (Default Reconciliation)
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 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.
Description (Deposit)
This field displays the description used for the posted deposit (or bank transfer).
Number
This field displays the number assigned when the deposit was saved in Sage 300.
Outstanding Amount
Displays the total amount that is outstanding for a deposit.
Reconciliation Status
The reconciliation status for the posted deposit (or bank transfer) appears in this field.
You cannot change the field.
Sorted By
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.
Status
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 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.
Detail Table
Batch Number
This field displays the batch number for a receipt.
Cleared Amount
This field displays the cleared amount for a receipt.
Date
This field displays the date for a receipt.
Difference
This field displays the difference between the deposit amount and the cleared amount for a receipt.
Entry Number
This field displays, for each receipt on the list, the entry number within the receipt batch.
Payer Code
This field displays the customer number for a receipt.
Payer Name
This field displays the name of the customer for a receipt.
Receipt Amount
This field displays the amount of a receipt in the bank's statement currency.
Receipt No.
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 context menu 
in the Receipt No. column heading.)
Reconciliation Date
This field displays the reconciliation date for a receipt.
Reconciliation Description
This field displays the reconciliation description for a receipt.
Reconciliation Period
This field displays the reconciliation period for a receipt.
Reconciliation Status
This field displays the reconciliation status for a receipt.
Reconciliation Year
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 context menu
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.