NCAS

GENERAL FUND MONTH END RECONCILIATION

Download this form as an Adobe Acrobat PDF

Month_____________________________________

Report

Column Heading

Row Heading

Budget Code

 l These Must =      

BD702 BUDGET Excess Exp.over/under Rev per BD701  
  BD701-Cert. *BUDGETED*AUTHORIZED Appropriation  
  AK 04 APPROPRIATIONS Adjusted Appropriation $

2a These Must = 1st Two Months of Quarter    
  BD702 UNALLOTTED Excess Exp. over/under Rev. per BD701  
  AK 04 APPROPRIATIONS Appropriation Balance $
         
2b These Must = Last Month of First 3 Quarters AFTER QUARTERLY REVERSION HAS BEEN POSTED  
* AK 05 BALANCE As of last entry for month closing  
  BD702 UNALLOTTED Excess Exp. over/under Rev. per BD701 LESS - (                     )
    UNEXPENDED QTD Net Allotment $
         
2c These Must = Last Month the Fiscal Year JUNE  
* AK 05 BALANCE As of last entry prior to June 30  
  BD702 UNALLOTTED Excess Exp. over/under Rev. per BD701 LESS - (                     )
    UNEXPENDED QTD Net Allotment $

3a These Must = 1st Two Months of Quarter    
  BD702 UNEXPENDED Unexpended Appropriation  
  BD702 UNALLOTTED Excess Exp. over/under Rev. per BD701 PLUS +
    UNEXPENDED QTD Net Allotment $
         
3b These Must = Last Month of First 3 Quarters AFTER QUARTERLY REVERSION HAS BEEN POSTED  
  BD702 UNEXPENDED Unexpended Appropriation  
  BD702 UNALLOTTED Excess Exp. over/under Rev. per BD701 $

4 These Must=      
  BD702 MTD/QTD/YTD Ending Cash in Allotment  
  BD800DET BALANCE Ending Cash Balance  
  AK 04 ALLOTMENTS Month End  
** GL Screen 016 ENDING BALANCE Period Closing  
  Cash 111270      
        $

5a These Must =   Expenditures Revenues
  BD702 CURRENT MONTH Expenditures/Revenues  
  BD701-Cert. *ACTUAL*CURRENT MONTH Expenditures/Revenues $ $
         
5b BD702 YEAR TO DATE Expenditures/Revenues  
  BD701-Cert. *ACTUAL*YEAR-TO-DATE Expenditures/Revenues $ $

6a These Must =      
  BD800SUM YTD RECEIPTS    
* AK 07 YTD RECEIPTS As of last entry for month closing $
         
6b BD800SUM YTD DISBURSEMENTS    
* AK 07 YTD EXPENDITURES As of last entry for month closing $

7a These Must =      
  BD800DET DEPOSITS/TRANS ADJ Period Balance  
  BD800SUM CURRENT RECEIPTS   $
         
7b BD800DET DISBURSEMENTS/TR ADJ Period Balance  
  BD800SUM CURRENT DISBURSEMENTS   $

* Note: Entries in Cash Management (AK05, AK07, AK08) are listed by date entered, not effective date. In order to get the correct month-end balance for the month you are closing, be sure and include any closing month entries made in the current month (or subtract current month entries from ending balance).
** Note: You will not be able to use summary center 999999999999 in cases where there are multiple companies within a budget code or multiple budget codes within a company.