Deposit Reconciliation Statuses

The following table lists reconciliation statuses for deposits.

Deposit Reconciliation Statuses
Status Description
Cleared

You assign this reconciliation status to a deposit that cleared the bank with the same amount as the deposit recorded in Sage 300.

The total amount of cleared deposits appears on the Totals tab of the Reconciliation screen.

Cleared with Bank Error

You assign this status to a deposit that cleared the bank with an amount different from the deposit total posted in Sage 300, if the error is greater than the spread specified in the bank record.

When you post the reconciliation, the error is carried forward as an outstanding transaction for the next reconciliation.

The Totals tab of the Reconcile Statements screen shows the total amount of deposit bank errors for the current reconciliation.

On the Reconciliation Status Report, a deposit bank error appears:

  • In the deposits section, if it will increase the bank balance when it is corrected. Such errors include:

    • Deposits that cleared the bank for an amount less than the actual amount.
    • Payments and withdrawals that cleared the bank for an amount greater than the actual amount.
  • In the withdrawals section, if it will reduce the bank balance when it is corrected. Such errors include deposits that cleared the bank for more than the actual amount.
Cleared with Credit Card Charges

You can apply this reconciliation status only to deposits that include a receipt with a credit card payment type.

Select this status if the difference between the deposit amount and the cleared amount is the result of credit card charges that were applied to the deposit.

The Totals tab of the Reconcile Statements screen shows the total amount of deposits cleared with credit card charges for the current reconciliation.

Cleared with Exchange Rate Difference

This status is available only if:

  • The bank account is multicurrency.
  • The bank's statement currency is the same as the functional currency.

You can assign this status to a payment made in a currency other than the statement currency.

You can assign this status to a deposit if at least one of its receipts is in a currency other than the statement currency.

The Totals tab of the Reconcile Statements screen shows separate totals for deposits and withdrawals cleared with an exchange rate difference.

Cleared with Write-Off

You assign this reconciliation status to deposits that clear the bank for amounts different from their posted amounts, where the difference is less than the error spread specified in the bank record.

The Totals tab of the Reconcile statements screen shows the total amount of deposits cleared with a write-off.

Deleted

This status is used for deposits processed through Accounts Receivable.

Deleted status is available only if all the receipt entries for the deposit were deleted. You change the Not Posted default status to Deleted in the Reconcile Statements screen.

On the Reconciliation Status report, "Deleted" is an option in the Deposit Reconciliation Status area. You can select this status only if the Print Deposit Details option is not selected. The resulting report displays Deleted in the Status column of an empty deposit, with zeroes across the other columns.

On the Reconciliation Posting Journal report, if the Print Deposit Details option is not selected, the report displays an empty deposit on the report with a status of Deleted and zeroes across the other columns.

Not Posted

Not Posted status is used for:

  • Bank entries that you have saved, but not yet posted.
  • Accounts Receivable deposits that include unposted receipt batches. (The batch total is zero in Bank Services.)

Once you post a bank entry or a deposit batch, its status changes to Outstanding.

Outstanding

A deposit (receipt batch) or transfer that has been posted but not cleared has Outstanding status.

Reconcile by Deposit Detail

You assign this status to a deposit that includes multiple receipts, if you want to reconcile each receipt individually. After assigning this status, you can reconcile receipts on the Deposit Details screen.