Bank Reconciliation

This program will determine whether or not the bank statement and monthly transactions are balanced. The process will print the list of outstanding checks and/or deposits for the month the summary report.

1. Select Funds/Lists/Bank Reconciliation Report from the list of JCampus modules on the left of the screen.
2. In the setup box verify the Fiscal Year Date. It will always be Jul 01, 20##.
3. Select the Month to be reconciled. The system will automatically determine the begin date and end date for the month selected.
4. The Close Date will appear on the setup box.
5. The Show Cleared Records will default to yes. This selection is optional and can be changed to No.
6. Select whether to Clear All Deposits at One Time. This will clear only those deposits made on the same date.
7. Select whether to Clear All Deposits on the same receipt'. This will clear only those deposits that have the same receipt number.
8. Click Ok.
9. The display will appear on the screen.

Definitions of Column Headings

• M--The Mark indicator that flags a record/transaction to be cleared.
• TT--Transaction Type
• Check No.--Check Number
• PayDate--Pay Date of the transaction
• Vendor Name--Name of the Vendor that received the check
• Deposit--Amount of a deposit transaction
• Payment--Amount of a check transaction
• Adjustment--Amount of a positive adjustment transaction
• Withdraw--Amount of a negative adjustment transaction
• Cash Needed--Running balance
• Cash--Actual cash
• Reference No--Information from the Vend Ref field of a transaction
• Sent Date--The date generated on the save step for any record that was marked to be cleared.
• Receipt No--The receipt number generated when a deposit is posted.

Reconciliation Process

1. Use the M column to flag a record as having cleared the bank. A single left mouse click will enter the letter M in this cell. All records that have the same check number, same receipt number or same deposit date will have the M entered with a single left mouse click.
2. Continue to mark bank statement items.
3. If you have a voided check entry or a pair of entries (original check and an adjustment) that void a check, be sure to mark these at this time.
4. To verify the total of a check, click the check number. A popup with the total for the check or deposit will appear. Click Ok to remove the popup from the screen.
5. To verify the total of a deposit, click the DEP value. The popup will give two amounts--the total of the receipt (with the number) and total for the day.
6. Click the Save button to update cleared transactions.

To Print this Report

1. Click the Print button at the bottom of the screen.
2. A popup will appear with a set of document print options--PDF, XLS, CSV, HTML.
3. The default print option will be PDF.
4. Click the print button on this popup and a print preview window will appear.
5. To get the print icon on this window, hover the mouse in the bottom right area of the preview. A grey rectangle will appear with several icons.
6. Click the print icon at the right end of this rectangle. Another print preview will appear.
7. Click the print button at the top left to print the report. Close the print preview.