Account Reconciliation and Review

Departmental Ledger Module Training

Statement of Accounts and Reconciliation

To post (reconcile) paid bills to the ledger using LP6:

1. Review bill to ensure it has correct object code, appropriate documentation (bill amount matches payment, payee, etc).  Ensure that bill has a stamp of date received and a stamp noting materials/goods received.

2. Use define to look up documents.

   1. Define: Go to LP6:  Enter account number to look up unposted documents.  Find the one that matches bill. Enter an "e" to post it, after first checking for correct coding and object codes. 

3. Stamp the voucher as "posted" with your initials and date.  File in the accounting file cabinet for that year by account number. 

Open

To look at posted documents, use LR7. 

To look at unposted (unreconciled) documents, use LR3. 

To see how many unreconciled items there are for the iSchool, run LR2 leaving "account" field blank to see all accounts. 

To make a correction, such as adding fields (define codes) 3, 4, or 5 when they were left missing:

1. Use LT6 in define. Enter the account number and in "misc" enter the voucher number". Hit enter.

2. Enter a "u" for update next to the item when it shows up.

3. Add changes/codes where needed.  Hit "u" again. This updates the entry. 

4. Hit "clear" to leave the screen.

Various bills and charges: 

1. Confirm reconciliation with Financial Manager.  

2. Once okay'ed, use LR5 to print a coversheet for that month's Reconciliation report. 

3. Notify Financial Manager so he can print the report and close out the month. 

4. Pick up cover-sheet and reports from Document Solutions at the School of Social Work building. Shelf is 850.

5. Print signature lines on coversheet using template on file. Give to Financial Manager.