Accounts Receivable Process
- Interim Reporting
- Aging Report - monthly
- Total A/R
- Six aging categories from 0-60 days to greater than 180 days
- Line designating >150 days outstanding
- Includes project End Date
- Status Report - quarterly (Oct, Jan, April & July)
- Greater than 150 days outstanding
-
Includes comments describing account status
-
Includes project End Date
- Potential Charge-off List - May
-
To prepare for Year-end financial reporting
-
- Distribution - Financial Officer (FO), Grant Administrator (GA), Office of Sponsored Programs, University Controller and Assistant Controller of FOs
- Financial risk sponsors shared quarterly with OSP and entered into SIMS
-
Trending to compare aging categories’ percent of total A/R and relative comparisons
- Aging Report - monthly
-
Aging Report format and how reports prepare
-
Based on BINR, built from the invoice level
-
Only invoices entered into IBIS (browse invoice information)
-
Different than ICAG balance, expenditures not invoiced
-
Aged based on invoice date, assuming a 30-day term, back off 30 days for number of days delinquent
-
Partial payments, invoice date rather than last payment. Status Report includes date of last payment
-
-
Collection Process Matrix, Page 2
-
New tools, freeze account
-
30-Day Warning
-
90-Day grace period with Letter of Guarantee
-
-
Communication:
- Copies of reminder notices sent via email to sponsor with copies to GA and
FO
- Copies of 3rd Request also sent to the Principle Investigator (PI)
- Associate Dean of Research also notified when sponsor given 30-day
Warning
- Copies of reminder notices sent via email to sponsor with copies to GA and
-
1 | 2 | 3 | 4 | 5 | 6 | |
---|---|---|---|---|---|---|
Invoice Date |
Invoice Payable |
2nd Request |
3rd Request.
PI asked to contact
sponsor.
|
Research Accounting
will contact sponsor.
Freeze Warning
|
Begin process of freezing
account. Associate Dean
can request grace
period.
|
|
Date | 3/15/2014 | 4/15/2014 | 5/15/2014 | 6/15/2014 | 7/15/2014 | 8/15/2014 |
Days outstanding | 30 | 61 - 90 | 91 - 120 | 121 - 150 | 151 - 180 | |
Days past due | 31 - 60 | 61 - 90 | 91 - 120 | 121 - 150 |
Collection Process Matrix Descriptions
- Research Accounting (R/A) mails original invoice to the sponsor.
- Unless otherwise stated in the agreement, the invoice is presumed to be due within 30 days of Invoice date.
- 60 - 90 days outstanding, R/A sends 2nd Request for payment.
- 91 - 120 days outstanding, 3rd Request sent. Principal Investigator (PI) asked to contact sponsor's technical contact.
- 121 - 150 days outstanding, R/A will discuss the account with the department and contact the sponsor to determine the problem and to seek payment. R/A will notify FO, Research Administrator, and PI regarding problems with deliverables, which should be addressed promptly. When appropriate, R/A will notify sponsor that account will be frozen unless payment or satisfactory arrangements.
- 151 - 180 days outstanding, R/A will begin the process of freezing the account. Associate Dean can request a grace period (between 30 and 90 days), by signing a Letter of Guarantee. If the account is frozen, R/A will proceed with collections, which may involve assigning the account to a collection agency.
2nd Request | 3rd Request. PI requested to contact sponsor. | Research Accounting will contact sponsor. Freeze Warning | Begin Process to freeze account. Associate Dean can request a grace period. | |
---|---|---|---|---|
Financial Officer | Yes | Yes | Yes | Yes |
Research Administrator | Yes | Yes | Yes | Yes |
Principal Investigator | Yes | Yes | Yes | |
Associate Dean | Yes | Yes | ||
Assistant Controller | Yes | Yes | ||
OSP, Assistant VP | Yes | Yes | ||
University Controller | Yes | |||
Senior VP of Research | Yes |