Bank Reconciliation

From EDgearWiki
Jump to navigationJump to search

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 of 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.
  7. The Bank Recon Monthly Report will appear that lists all outstanding transactions.
  8. Click the Balance button.
  9. A popup will appear. Enter the balance from the Bank Statement.
  10. The Reconciliation Summary print preview will appear on the screen. If the Reconciliation Difference is NOT Zero you must stop and determine what is needed to correct the reconciliation. When you have a reconciliation difference of zero, print the report using the instructions below.

Print

  1. Click the Print button at the bottom of the screen.
  2. Click the printer icon at the top right. Another print servlet will appear.
  3. Click the print button at the top left to print the report. Close the original print servlet window.


Funds Main Page

JCampus Main Page

Retrieved from EDgear Wiki