Project Funding Access Database 1 Project Funding Database
Project Funding Access Database 1
Project Funding Database • Assist county highway accountants in reconciling various state aid accounts in their highway costing system each and every month. • Accounting for contracts payable to vendors • Determining unearned revenue balances • Additional features in this system will assist in year-end reporting for the county’s Annual Highway Report and county wide financials. 2
Monthly Processing
Project Funding Menu
Contracts Menu
Allotment Processing Menu
Monthly Reports Menu
Journal Entry Processing Menu
Journal Entry Processing menu • The system will generate data entry forms for the ACS, Costrite or Generic Costing Systems. • You must provide the correct Costing System in the County Name Maintenance and Cost Accounts in the Cost – G/L Account Maintenance area of the system prior to running the options on this menu. 9
Monthly reports and reconciliation Special considerations: • There may be a timing difference in transactions processed • The SAAS Status Report is like a bank statement, outstanding transactions must be considered when reconciling • A request may be posted to the database but has yet to be processed on the SAAS Status Report • A disbursement may be posted to the SAAS Status Report but has yet to be receipted by the county • Transfer between maintenance and construction at year-end and prior year • Maintenance receivable at year-end and prior year • SAAS Status Report does not consider prior year maintenance transfers and receivables until the Summary Highway Information is received and processed by State Aid Finance 10
Summary of State Aid Receivable by Funding Print/View Summary of State Aid Receivable by Funding 11
Sample - Summary of State Aid Receivable by Funding
Contracts Payable Print/View Contracts Payable 13
Sample - Contract Payable
Allotment Balance Report Print/View Allotment Balance Report 15
Sample - Allotment Balance Report
Unearned Revenue Balance Report Print/View Unearned Revenue Balance Report 17
Sample - Unearned Revenue Balance Report
Annual Processing Menu
Annual Reports Menu
State Reports Menu
Sample – Annual Summary of Highway Information
Sample – Analysis of State Aid Projects
Sample – Year End Status Report
Sample – County Highway Restricted Fund Balance-Net Position
Questions? Contact: State Aid Finance staff 26
- Slides: 26