NCFS Report - RPT-RTR-013

Report Name: RPT-RTR-013-NCAS to GL Reconciliation Reports

Report Description: NCAS to GL reconciliation report will have the following worksheets:

1. Compare account balances at the R1 clearing budget fund level vs the R3 detailed budget funds.
2. Compare account balances at the Budget Code Level in R1 vs R3.
3. Compare cash account balances between the ledgers (Cash Ledger vs Modified Accrual Ledger vs Full Accrual Ledger).
4. Compare net balances in 13th periods in 37000000 & 38000000 accounts in Modified Accrual Ledger & Full Accrual Ledger. If an accounting distribution has a non-zero balance, then it needs to be flagged and reviewed.
5. Extract the Journal Entries created using conversion clearing account- 29000001 (Cash Ledger) & 32900000 (Accrual Ledger).
6. Programmatic comparison of trial balance between NCAS & Oracle as of 13th period.