Check Reconciliation (Maximize this screen before viewing)

Menu option Accounts Payable – Month End – Cash Reconciliation

A file provided by the bank of cleared/returned checks can be imported by clicking the Import button and selecting the file to import. See SGA for help on the one-time setup of the bank specs.

The following example is manually reconciling checks with a bank statement with an ending date of 08/31/2004. In this example, we want to display outstanding checks (for a selected bank account number) as of 08/31/2004, including all types through a check date of 08/31/2004.

Enter the last check date that is included on the bank statement. Leave the “From” check date blank to include all outstanding checks through the selected date.

Then click Display.

Enter the clear/return date to be recorded on each check as the check is marked “returned”. You might prefer this to be the date of the bank statement or today’s date

Enter the bank statement ending date to display outstanding checks as of this date

The outstanding check numbers and check information are now displayed.

To mark a group of consecutively numbered checks as returned, enter the range of numbers and click Returned.

Results.

	If a check was processed through the bank for a different amount than the recorded check amount in the computer, you may reference an adjustment amount and adjustment date here. You may then click to go directly to Journal Entry to make any necessary adjusting entry in the general ledger.
Click Print for a report of whatever is displayed on the screen at any time.

	Delete button: You may delete old checks from the archive file at any time. This is a permanent delete and checks will not be able to be viewed again.
Archive button: You can archive returned checks through any month end date. The Archive process simply moves returned checks to an archive file. If you ever want to review archived checks, select the file set Archive instead of Live.