Bank Reconciliation

Help Home | System Home | Core | Errors |

The system has been designed to produce a bank reconciliation on any number of different bank accounts at month end. Please note that all checks must be entered before the reconciliation can be printed. All systems that write checks, such as Payroll and Checkbook, will automatically update this file as checks are written. All checks entered through the General Ledger input process will also be automatically recorded in this file. All manual payments and voided checks will also be reflected.

This menu option has been designed to allow you to access the bank reconciliation file and make any necessary changes, such as a bad date.

The ACS Checkbook/Accounts Payable system also contains a bank reconciliation feature. If you have the ACS Checkbook system, we recommend you use the reconciliation feature from that system. This will allow you to reconcile the bank before the entries are posted to the General Ledger. To use the reconciliation in the General Ledger system, you must first post all entries to the General Ledger.

This menu option will allow to review the bank reconciliation file and make any necessary changes. You will use the Reconciliation option, which is another menu option under Bank Reconciliation on the main menu. The system will handle any number of different bank accounts on any company. All check information is maintained in the same reconciliation file. When you first take the bank reconciliation option from your menu, you will be shown a grid of all checks in the bank reconciliation file. If you want to limit the list to a specific bank account, you can click on the symbol to left of the Search field. Choose to toggle autofilters, then click on the drop down arrow and pick the bank account. Your actual bank reconciliation is printed from the Reconciliation option, but you can print any thing in grid by Clicking on the Print option also found under the symbol.

The following information is contained in each record in the bank reconciliation file.

G/L Number

This is the General Ledger number of the bank account from which the check was written.

Check Number

This field contains the actual check number. The check number can contain a maximum of 12 digits.

Payee

Each record contains a 30-character payee field.

Source

This field contains a code to help identify the source of the entry. The system will use GL for General Ledger entries, AP for accounts payable entries and PR for payroll entries.

Date

The check date should be entered in MMDDYY format.

Amount

The net check should be entered in this amount field.

Cleared Bank Code

If a check has cleared the bank, the field will contain a 1, else a zero will be displayed.

The following options are available on the bank reconciliation menu.