Accounts Receivable - Reconcile Receipts

Pgm: ARCHQREC – Reconcile Receipts; standard Treeview path: Accounts Receivable > Receipt > Reconcile Receipts

This screen is used to classify unreconciled AR cash receipts, which have been entered via the Cash Receipt screen or the Front Office Cashier screen, as reconciled. And for cash receipts that have mistakenly been flagged as reconciled, it can also be used to box them as unreconciled.

According to the entered parameters in the Selection Criteria section, this screen lists unreconciled receipts on the Unreconciled tab, and receipts that have been flagged as reconciled (either manually via this screen, or automatically via the Import functionality of the Bank Reconciliation screen) on the Reconciled tab.

This screen is used in conjunction with the Bank Reconciliation screen of the GL module, if AR clerks are responsible for manually flagging AR cash receipts as reconciled. If all relevant receipts are flagged as reconciled through this screen, then the Outstanding AR Deposits field on the Bank Reconciliation screen will display a balance of $0.00, as shown in the following screenshot. Otherwise, there are unreconciled receipts making up the outstanding balance, which can be viewed on the Unreconciled tab of this screen.

Pgm: GLBANKREC – Bank Reconciliation; standard Treeview path: General Ledger > Utilities > Bank Reconciliation

If the Import functionality of the Bank Reconciliation screen is used, which imports a bank statement for the reconciliation process, the Reconcile Receipts screen can’t be used to manually define receipts as reconciled, since the Import functionality would do this automatically. This screen could, however, be used to manually make adjustments as to what receipts are and are not reconciled. To access this screen from the Bank Reconciliation screen, click the [Details] button that corresponds to the Outstanding AR Deposits field (shown above).

Selection Criteria

Statement Date

Enter the date on the bank statement from which the receipts are being reconciled. This limits the display of unreconciled receipts to receipts that were issued before or on the entered statement date.

Cash Account (Department, Cash Account)

Reconciliation is done by bank account, so a valid GL department and account representing the bank account to be reconciled must be selected.

These fields will default from the department and account entered for the Cash For AR fields on the Accounting tab of the AR Control File for the selected company.

Unreconciled – Tab    

This tab lists unreconciled receipts that satisfy the parameters entered in the Selection Criteria section.

Use this tab to mark receipts as reconciled. To reconcile receipts, check their “Y” checkbox and click the [Save] button.

Reconciled – Tab

This tab lists previously reconciled receipts, based on the parameters entered in the Selection Criteria section.

To un-reconcile receipts, check their corresponding “Y” checkbox and click the [Save] button.