More information

Reconcile Cash Accounts Buttons

Reconciling Cash Accounts

Transferring Between Multiple Cash Accounts

Bank Reconciliation FAQs

Reconcile Cash Accounts - Checks/Vouchers Tab

Access this tab using Activities>Reconcile Cash Accounts.

Use this tab to identify which checks and/or vouchers have cleared the bank and are therefore no longer reconciling items. The checks/vouchers that display on this tab are posted items from Cash Disbursements, Write Checks, Void Checks/Vouchers/Invoices, A/P Checks/Vouchers, or Payroll Checks/Vouchers. If you are using the Direct Deposit and/or Electronic Funds Transfer for A/P modules, vouchers will also display.

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 (cleared and 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.

 

Checks/Vouchers Table: The first column in this table allows checks/vouchers 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 appears next to selected items.

  • Document Number: The system displays the document 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 document's amount.
  • 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.
  • Type: The system displays the type of document, such as a Cash Disbursement (CD) or Voided Check (V). CD represents all posted checks/vouchers and could have been created using the Enter Cash Disbursements, Enter Manual A/P Checks, Write Checks, or Pay Selected A/P Invoices forms. CD could also represent a check created in the Payroll module. Keep in mind that once a cash disbursement is voided, its type changes from CD to V.
  • ID: The system displays the unique ID that is assigned to this Payee.
  • Source: The system displays the source of the disbursement, such as Employee (E) or Vendor (V). Employee originates from Payroll and Vendor from Accounts Payable. Note that no source is identified for General Ledger type checks.
  • Payment Type: The system displays the payment type—either Check or Voucher.
  • Payee: The system displays the recipient of the designated check/voucher. Note that no payee is identified for General Ledger type checks.
  • Description: The system displays the description of the check/voucher.
  • The checks/vouchers displayed on this tab were posted using one of the following forms:
    • Transactions>Enter Cash Disbursements
    • Transactions>Accounts Payable>Enter Manual A/P Checks (if the Accounts Payable module is installed)
    • Activities>Check Writing>Write Checks
    • Activities>Check Writing>Void Checks/Vouchers/Invoices
    • Activities>Accounts Payable>Pay Selected A/P Invoices (if the Accounts Payable module is installed)

    • Additionally, any Payroll checks/vouchers that have been transferred to Accounting are included on the Checks/Vouchers tab.

  • To clear a specific check/voucher, click in the check box to the left of the Document Number, or you can click Select All to clear all checks/vouchers. To select groups of checks/vouchers, highlight rows using your mouse, and then press the space bar on your keyboard to clear each check/voucher.
  • The functional currency was determined by the Administrator when the organization was created (File>New Organization>Functional Currency panel).