More information

Reconcile Cash Accounts Buttons

Reconciling Cash Accounts

Bank Reconciliation FAQs

Reconcile Cash Accounts - Other Cash Items Tab

Access this tab using Activities>Reconcile Cash Accounts.

Use this tab to clear other cash items (transactions which debit or credit a cash account). These are items which were entered as Journal Vouchers, A/P Invoices, A/P Credits, A/R Invoices, and A/R Credits. For example, assume bank service charges were entered as a Journal Voucher entry. This adjustment affects the cash account and must be cleared on this tab.

Note: When you move between tabs or click the Update button, the unreconciled difference between the bank account and the ledger balance changes to reflect the items marked as cleared.

Use the buttons at the top of the form to change the view to:

  • All Items (those cleared on the reconciliation date and those outstanding),
  • Cleared Items only (those cleared on the reconciliation date), or
  • Outstanding Items only (those that have not been cleared as of the reconciliation date).

The Currency field is only available if the Administrator has installed and added the Multicurrency module (Organization>Add a Module). The Functional Amount, Exchange Adjustment, and Cleared Amount fields are also available if a functional currency account is selected on the Summary tab.

 

Other Cash Items Table: The first column in this table allows deposits to be selected that have cleared the bank account. Click in the check boxes to select or clear individual items, or use the buttons at the top of the form to select or clear multiple items. A check mark displays next to selected items.

  • Document: The system displays the document's unique number.
  • Document Date: The system displays the date of the document.
  • Currency: The system displays the currency type associated with the Amount, such as USD, CAD, EUR, GBP, or MXN. Currencies were created and activated by the Administrator using the Organization>Currency Setup form.
  • Amount: The system displays the amount of the document.
  • Functional Amount: The system displays the functional amount booked to each document.
  • Exchange Adjustment: The system displays the exchange adjustment amount, which is calculated by taking the difference between the Cleared Amount less the Functional Amount for the document.
  • Cleared Amount: The system displays the amount of which the document actually cleared the bank or displays the original document amount if it has not cleared. If appropriate, change the functional cleared amount.
  • Description: The system displays a description of the document.
  • The other cash items displayed on this tab were posted using one of the following forms:
    • Transactions>Enter Journal Vouchers
    • Transactions>Accounts Payable>Enter A/P Invoices or Enter A/P Credits (if the Accounts Payable module is installed)
    • Transactions>Accounts Receivable>Enter A/R Invoices or Enter A/R Credits (if the Accounts Receivable Reporting module is installed)
  • To clear a specific item, click the check box to the left of the Document column, or click Select All to clear all items. To select groups of deposits, highlight rows using your mouse, and then press the space bar on your keyboard to clear each deposit.
  • The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).