View source for Bank Reconciliation - Manual

'''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.'''
#Select '''Funds/Lists/Bank Reconciliation Report''' from the list of JCampus modules on the left of the screen. 
#In the setup box verify the '''Fiscal Year Date'''. It will always be Jul 01, 20##.
#Select the '''Month''' to be reconciled. The system will automatically determine the begin date and end date for the month selected.
#The '''Close Date''' will appear on the setup box. 
#The '''Show Cleared Records''' will default to '''yes'''. This selection is optional and can be changed to '''No'''.
#Select whether to '''Clear All Deposits at One Time'''. This will clear only those deposits made on the '''same date'''.
#Select whether to '''Clear All Deposits on the same receipt'''. This will clear only those deposits that have the '''same receipt number'''.
#Click '''Ok'''.
#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'''
#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.
#Continue to mark bank statement items.
#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.
#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.
#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.
#Click the '''Save''' button to update cleared transactions.
#The '''Bank Recon Monthly Report''' will appear that lists all outstanding transactions.
#Click the '''Balance''' button.
#A popup will appear. Enter the '''balance''' from the Bank Statement.
#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'''

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


----
[[Funds|'''Funds''' Main Page]]