Accounts Receivable Reconciliation |
|||||
Department: My Department |
|||||
Date: 10/8/XX |
|||||
Prepared By: Me |
|||||
Date |
Description |
Document |
Sales |
Payments |
Balance |
7/1/XX |
Beginning Balance |
|
|
|
1,000.00 |
7/15/XX |
July Sales |
J000111 |
500.00 |
|
1,500.00 |
7/21/XX |
Payments |
F000313 |
|
1,000.00 |
500.00 |
8/12/XX |
August Sales |
J000175 |
750.00 |
|
1,250.00 |
8/18/XX |
Payments |
F000395 |
|
450.00 |
800.00 |
9/23/XX |
September Sales |
J000205 |
850.00 |
|
1,650.00 |
9/30/XX |
Payments |
F000423 |
|
800.00 |
850.00 |
|
|
|
|
||
|
Balance 9/30/XX from FGITBAL Acct A3103: |
825.00 |
|||
|
|
|
|
|
|
|
|
|
|
Difference: |
25.00 |
J000205 did not include sales of 25.00 |
|||||
recorded with J000252 10/8/XX |
Back to Top
Year End Procedures
Each department that records accounts receivable needs to submit a listing of entities external to the University who owe amounts for goods or services that have been provided. This listing also needs to indicate the date the goods or services were provided and short description of them. A template for this listing is located at https://pages.uoregon.edu/baoforms/bao_drupal_6/sites/ba.uoregon.edu/files/forms/yearendar.xlsx. Please see the deadlines listing on the Year End Close website for due date and procedures.
Back to TopCOPS (Certificates of Participation)
At the point COP reimbursements are requested, a receivable is booked.
Entry:
Debit A3103 "Miscellaneous A/R" for the amount of the reimbursement request
Credit 05202 "COPS Proceeds" for the amount of the reimbursement request
When the reimbursement is actually received it should be deposited against the A/R account (A3103 Miscellaneous A/R). At year end a reimbursement request for expenditures that are outstanding at June 30 must be processed prior to the close of fiscal period 12.