About this file
From the source
This is a template for a Reconciliation Report
Other files for this federal contract opportunity
Other files attached to Perkins Loan Servicing, newest first.
| File |
Type |
Posted |
| Title_IV_Aid_Servicing_IDIQ_T C.pdf |
PDF |
|
| SF-30_pdf_-_10.4.pdf |
PDF |
|
| SF_30_Phase_2_Amend.pdf |
PDF |
|
| 24000_Ph2_FinancialRpt_Recon.zip |
ZIP file |
|
| 21000_AccessToNFPsystems.zip |
ZIP file |
|
| 25000_Ph2_FMS.zip |
ZIP file |
|
| 27000_Ph2_Other.zip |
ZIP file |
|
| 26000_Ph2_FinancialActivity_Trans.zip |
ZIP file |
|
| 22000_Ph2_DL_Origination.zip |
ZIP file |
|
| 23000_Ph2_Conversions_Purchases.zip |
ZIP file |
|
| 17000_Compliance_Monitoring.zip |
ZIP file |
|
| 18000_Transfers.zip |
ZIP file |
|
| 20000_AccessToFSAsystems.zip |
ZIP file |
|
| 19000_Security.zip |
ZIP file |
|
| 15500_IBR_Interface.zip |
ZIP file |
|
| 15000_Consolidation.zip |
ZIP file |
|
| 14000_DebtCollection.zip |
ZIP file |
|
| 16000_RecordRetention.zip |
ZIP file |
|
| 13000_TPD.zip |
ZIP file |
|
| 12000_NSLDS.zip |
ZIP file |
|
| 08000_FinancialActivity_Trans.zip |
ZIP file |
|
| 10000_InternalCtrl_Audits.zip |
ZIP file |
|
| 11000_OpsPort_Rpting.zip |
ZIP file |
|
| 07000_FMS.zip |
ZIP file |
|
| 06000_FinancialRpt_Recon.zip |
ZIP file |
|
| 05000_Processing_Servicing.zip |
ZIP file |
|
| Final_Perkins_Phase_II_Solicitation_-_Amendment_0001.doc |
DOC document |
|
| Part_2_Q A.doc |
DOC document |
|
| Phase_2_Q.A..pdf |
PDF |
|
| SF_1449_-_Perkins_Loan_Servicing_(Phase_II).pdf |
PDF |
|
| Final Perkins Phase II Solicitation.doc |
DOC document |
|
| Phase 1 Successful Offerors.pdf |
PDF |
|
| Phase I - Questions Answers 6.21.12.doc |
DOC document |
|
| Phase I - Questions Answers 6.21.12.doc |
DOC document |
|
| Phase I - Questions Answers 6.19.12.pdf |
PDF |
|
| Amendment 0002.pdf |
PDF |
|
| Phase I - Questions Answers.doc |
DOC document |
|
| Amendment 0001.doc |
DOC document |
|
| FINAL Phase I Solicitation.doc |
DOC document |
|
Show all 39
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
The file's text, extracted by GovTribe without its formatting.
Lead Sheet
| XXX System Trial Balance to FMS Trial Balance Reconciliation |
| Fund ZZZ - Loan Participation Programs (PI1, PI2) |
| Period Ending June 30, 2011 |
| Fund | Account | Loan Servicing System Ending Trial Balance | FMS Ending Trial Balance | Difference | Support Tab Reference |
| ZZZ | | $0.00 | $0.00 | $0.00 | |
| ZZZ | | $1,500,000.00 | $1,500,000.00 | $0.00 | |
| ZZZ | | $39,500,000.00 | $37,500,000.00 | $2,000,000.00 | Tab 3 |
| ZZZ | | $1,249,000,000.00 | $1,249,000,000.00 | $0.00 | |
| ZZZ | | $0.00 | $0.00 | $0.00 | |
| ZZZ | | ($1,280,000,000.00) | ($1,280,000,000.00) | $0.00 | |
| ZZZ | | ($1,500,000.00) | ($1,500,000.00) | $0.00 | |
| ZZZ | | $0.00 | $0.00 | $0.00 | |
| ZZZ | | $500,000.00 | $500,000.00 | $0.00 | |
| ZZZ | | $1,000,000.00 | $1,000,000.00 | $0.00 | |
| ZZZ | | ($1,500,000.00) | ($1,500,000.00) | $0.00 | |
| ZZZ | | $1,500,000.00 | $1,500,000.00 | $0.00 | |
| ZZZ | | $0.00 | $0.00 | $0.00 | |
| ZZZ | | $0.00 | $0.00 | $0.00 | |
| 531200 | ($10,000,000.00) | ($8,000,000.00) | ($2,000,000.00) | Tab 4 |
| | $0.00 | $0.00 | $0.00 | |
| NOTES: | | | | | |
| Loan Servicing System Ending Trial Balance Support - Page 2 | | | | | |
| FMS Ending Trial Balance Support - Page 3 | | | | | |
| Prepared by: | |
| XXX Operations - John Doe |
| Reviewed by: | |
| XXX Operations - John Doe |
| Reviewed by: | |
| CFO Reconciliation Branch - SERVICER POC |
| Approved by: | |
| Reconciliation Branch Manager |
&A
1 - Serv TB
| XXX Servicing System Trial Balance to FMS Trial Balance Reconciliation | | | | | | | |
| Loan Participation Programs (PI1, PI2) Fund ZZZ | | | | | | | |
| Period Ending June 30, 2011 | | | | | | | |
| XXX Servicing System Trial Balance by Fund Report | | | | | | | |
| Month/Year: June 2011 | | | | | | | |
| Default Status | Loan Program | Fund | GL Account | GL Account Name | Beginning Balance | Net Activity | Ending Balance |
| ND | PI1 | ZZZ | | Cash Disbursements - ALC 009 | $0.00 | $0.00 | $0.00 |
| ND | PI1 | ZZZ | | Cash Collections - ALC 009 | $0.00 | $1,500,000.00 | $1,500,000.00 |
| ND | PI1 | ZZZ | | Interest Receivable | $0.00 | $39,500,000.00 | $39,500,000.00 |
| ND | PI1 | ZZZ | | Loans Receivable | $0.00 | $1,249,000,000.00 | $1,249,000,000.00 |
| ND | PI1 | ZZZ | | Penalties, Fines & Administrative Fees Receivable | $0.00 | $0.00 | $0.00 |
| ND | PI1 | ZZZ | | Allowance for Subsidy | $0.00 | ($1,280,000,000.00) | ($1,280,000,000.00) |
| ND | PI1 | ZZZ | | Anticipated Collections | $0.00 | ($1,500,000.00) | ($1,500,000.00) |
| ND | PI1 | ZZZ | | Actual Collection of Fees | $0.00 | $0.00 | $0.00 |
| ND | PI1 | ZZZ | | Actual Collection of Loan Principal | $0.00 | $500,000.00 | $500,000.00 |
| ND | PI1 | ZZZ | | Actual Collection of Loan Interest | $0.00 | $1,000,000.00 | $1,000,000.00 |
| ND | PI1 | ZZZ | | Apportionments | $0.00 | ($1,500,000.00) | ($1,500,000.00) |
| ND | PI1 | ZZZ | | Apportionments - Unavailable | $0.00 | $1,500,000.00 | $1,500,000.00 |
| ND | PI1 | ZZZ | | Unexpended Obligations - Unpaid | $0.00 | $0.00 | $0.00 |
| ND | PI1 | ZZZ | | Expended Authority - Paid | $0.00 | $0.00 | $0.00 |
| ND | PI1 | ZZZ | | Interest Revenue - Loans Receivable | $0.00 | ($10,000,000.00) | ($10,000,000.00) |
| | | | | $0.00 | $0.00 | $0.00 |
2 - FMS TB
| XXX Servicing System Trial Balance to FMS Trial Balance Reconciliation | | | | | |
| Loan Participation Programs (PI1, PI2) Fund ZZZ | | | | | |
| Period Ending June 30, 2011 | | | | | |
| FMS GL TRIAL BALANCE BY SOURCE - SUMMARY REPORT For Fund : 'ZZZ', Source : S2, and Period : 'Jun-09' | | | | | |
| Fund | Account | Source Code | Beginning Balance | Net Activity | Ending Balance |
| ZZZ | 101092 | S2 | $0.00 | $0.00 | $0.00 |
| ZZZ | 101093 | S2 | $0.00 | $1,500,000.00 | $1,500,000.00 |
| ZZZ | 134101 | S2 | $0.00 | $37,500,000.00 | $37,500,000.00 |
| ZZZ | 135001 | S2 | $0.00 | $1,249,000,000.00 | $1,249,000,000.00 |
| ZZZ | 136000 | S2 | $0.00 | $0.00 | $0.00 |
| ZZZ | 139900 | S2 | $0.00 | ($1,280,000,000.00) | ($1,280,000,000.00) |
| ZZZ | 406000 | S2 | $0.00 | ($1,500,000.00) | ($1,500,000.00) |
| ZZZ | 426100 | S2 | $0.00 | $0.00 | $0.00 |
| ZZZ | 426200 | S2 | $0.00 | $500,000.00 | $500,000.00 |
| ZZZ | 426300 | S2 | $0.00 | $1,000,000.00 | $1,000,000.00 |
| ZZZ | 451000 | S2 | $0.00 | ($1,500,000.00) | ($1,500,000.00) |
| ZZZ | 459000 | S2 | $0.00 | $1,500,000.00 | $1,500,000.00 |
| ZZZ | 480100 | S2 | $0.00 | $0.00 | $0.00 |
| ZZZ | 490200 | S2 | $0.00 | $0.00 | $0.00 |
| ZZZ | 531200 | S2 | $0.00 | ($8,000,000.00) | ($8,000,000.00) |
| | | $0.00 | $0.00 | $0.00 |
3 - 134101
| Sample Difference Worksheet Page to be included in Trial Balance Reconciliaitons only when differences are identified. | | | | | | | | |
| Separate Difference Worksheet Page is required for each GL account that includes amounts in "Difference" column of Lead Sheet | | | | | | | | |
| XXX Servicing System Trial Balance to FMS Trial Balance Reconciliation | | | | | | | | |
| Loan Participation Programs (PI1, PI2) Fund ZZZ | | | | | | | | |
| Period Ending June 30, 2011 | | | | | | | | |
| 134001 Difference Worksheet | | | | | | | | |
| Great Lakes Servicing System Posting of Interest Accruals | | | | | | | | |
| Period Name: June-09 | | | | | | | | |
| Fund | Account | Loan Program | Transaction Code | Net | Posted Date | Transactional Identifier | Amount Type | Reason for Variance |
| ZZZ | | PI1 | INTACC | $400,000.00 | 30-Jun-2011 | YYYYYYYYYYY | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $350,000.00 | 30-Jun-2011 | YYYYYYYYYYY | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $1,250,000.00 | 30-Jun-2011 | YYYYYYYYYYY | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| | | | $2,000,000.00 | | | | |
| FMS Posting of Interest Accruals | | | | | | | | |
| Period Name: July-09 | | | | | | | | |
| Fund | Account | Loan Program | Transaction Code | Net | Posted Date | Transactional Identifier | Amount Type | Reason for Variance |
| ZZZ | | PI1 | INTACC | $400,000.00 | 02-Jul-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $350,000.00 | 02-Jul-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $1,250,000.00 | 02-Jul-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| | | | $2,000,000.00 | | | | |
4 - 531200
| Sample Difference Worksheet Page to be included in Trial Balance Reconciliaitons only when differences are identified. |
| Separate Difference Worksheet Page is required for each GL account that includes amounts in "Difference" column of Lead Sheet |
| XXX Servicing System Trial Balance to FMS Trial Balance Reconciliation | | | | | | | | |
| Loan Participation Programs (PI1, PI2) Fund ZZZ | | | | | | | | |
| Period Ending June 30, 2011 | | | | | | | | |
| 531200 Difference Worksheet | | | | | | | | |
| Great Lakes Servicing System Posting of Interest Accruals | | | | | | | | |
| Period Name: June-09 | | | | | | | | |
| Fund | Account | Loan Program | Transaction Code | Net | Posted Date | Transactional Identifier | Amount Type | Reason for Variance |
| ZZZ | | PI1 | INTACC | $400,000.00 | 30-Jun-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $350,000.00 | 30-Jun-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $1,250,000.00 | 30-Jun-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| | | | $2,000,000.00 | | | | |
| FMS Posting of Interest Accruals | | | | | | | | |
| Period Name: July-09 | | | | | | | | |
| Fund | Account | Loan Program | Transaction Code | Net | Posted Date | Transactional Identifier | Amount Type | Reason for Variance |
| ZZZ | | PI1 | INTACC | $400,000.00 | 02-Jul-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $350,000.00 | 02-Jul-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| ZZZ | | PI1 | INTACC | $1,250,000.00 | 02-Jul-2011 | | IRB_AMT | Interest Accruals posted in Servcing system June 2011 and in FMS July 2011 |
| | | | $2,000,000.00 | | | | |
File details come from the government source that posted it.
Updated .