Home

SAAS Manual - Minnesota Department of Transportation

1. Drill down on Disbursements Preview Annual Allocations Deposits Transfers Disbursements Report ID Disbursements State of Minnesota Run Date 10 31 2002 Departnent of Transportation Inquire on Disbursements for 2002 County 001 AITKIN Acct Account 70 CO REG CONST as of 10 31 2002 Partial Transfer Payment Description Final Payment Nbr 001 103 006 PARTIAL PAYMENT 001 103 005 FINAL PAYMENT 001 602 011 PARTIAL PAYMENT 001 610 018 FINAL PAYMENT 001 610 019 PARTIAL PAYMENT 001 631 002 PARTIAL PAYMENT 001 634 002 PARTIAL PAYMENT 001 640 002 PARTIAL PAYMENT Wewn Drill down on Encumbrances Preview Annual Allocations Deposits Transfers Disbursements Encumbrances Report ID Encumbrances State of Minnesota Run Date 10 31 2002 Department of Transportation Inquire on Encumbrances amp Open Projects for 2002 County 001 AITKIN Acct Account 70 CO REG CONST as of 10 31 2002 Project Number Encumbrance Amount 001 602 010 74 420 11 001 602 011 49 353 90 001 614 010 277 70 001 622 005 6 908 20 001 622 006 30 852 46 001 624 001 65 321 59 001 624002 4 958 14 001 631 001 41 107 99 001 631 002 15 767 93 001 634002 2 174 07 001 640 001 45 479 32 001 640 002 28 732 66 365 329 07 Drill down on Overpayments Preview Annual Allocations Deposits Transfers Disbursements Encumbrances Overpayments f O01 Report ID Overpayments State of Minnesota Run Date 10 31 2002 Deparinent o
2. This Report Runs for Current Reporting Month 200912 Log out of system The next page displays the appearance of the report Page 35 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Local Bridge Project Expenditure Obligation Report Summary Appearance Page of 3 Minnesota Department of Transportation Office of Finance e SAAS Local Bridge Project Expenditure Obligation Report Summary Award Date between 1 1 2009 and 12 7 2009 As of 12 6 2009 Rel Township Rd of County Rd of Muni Bridges of Township Rd of County Name Co Co Br Bond Amt Proj Br Bond Amt X Proj Br Bond Amt Proj Town Bridge Amt Proj AITKIN 001 135 901 00 1 67 735 00 1 BECKER 003 135 540 00 2 BELTRAMI 004 501 171 00 1 635 865 30 2 122 844 00 1 BLUE EARTH O07 0 00 1 48 184 40 1 131 705 13 1 BROWN 008 1 109 892 01 1 197 198 05 2 CHIPPEWA 012 111 333 42 1 CLAY 014 52 179 00 1 111 289 88 1 COTTONWOOD 017 90 142 23 1 155 711 00 1 DAKOTA 019 1 662 076 00 1 DODGE 020 150 120 00 2 FARIBAULT 022 282 482 00 1 102 550 00 1 FILLMORE 023 433 774 54 4 FREEBORN 024 1 104 062 00 4 255 617 88 1 GOODHUE 025 577 526 07 4 HOUSTON 028 63 488 00 1 833 193 62 3 HUBBARD 029 276 776 29 1 195 725 00 1 ISANTI 030 5226 97 7 60 1 ITASCA 031 708 794 11 2 JACKSON 032 352 612 00 2 KANDIYOHI 034 312 636 33 1 KITTSON 035 102 123 00 1 18
3. Page 104 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Accountant E Mail Accountant E Mail Purpose View Accountant E Mail addresses by district Audience All users Screen This is the entry screen Select the District SAAS Web Reporting Functional Business View Accountant Task Force Address Reports Accountant E Mail District District o Log out of system Page 105 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Accountant E Mail A list will appear on the screen you may highlight and copy list into e mail click View Report to print the list SAAS Web Reporting Functional Business View Accountant Task Force Address Reports Accountant E Mail District District 1 anne zellner co cook mn us darlene tanner co itasca mn us donna hodel co koochiching mn us linda libal co lake mn us mark linne co carlton mn us morleya co st louis mn us spanders co pine mn us Log out of system Page 106 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Accountant List Accountant List Purpose View Accountant List list all or by district The list includes address accounting system e mail and phone numbers
4. Binoculars the binoculars are used to initiate a search of the document You specify the word or phrase of interest in the dialog box that displays Page 10 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 State Aid County and Municipality Reports STATE AID COUNTY AND MUNICIPALITY REPORTS Reports for county and municipality use are listed on the State Aid County and Municipality Reports screen Select any report by double clicking on the name of the report 7 SAAS Reports Windows Internet Explnrer Gc Rp eodera dot aute mn usiSAnsissas Repertettul aep oder D EMO Ts Fde Fu Vane Fooros Tooh Help dedo furem pee c dh Enge Ts en SAAS Web Reporting Functional Business View State Aid County and Municipality Reports Advance CSAH amp MSAS Funds Aging Bond Applied Projects Bond Loan Schedule Bond Principal and Interest Due Bridge Bonding amp Other State Bonding Programs Bridge Bonding amp Other State Bonding Programs Acct Only Bridge Bonding amp Other State Bonding Programs Summary Expenditure Detail By Co Muni amp Contrel Section Number Local Bridge Project Expenditure Obligation Report Summary Overpayments Payment Document Final Maintenance Payment Document Construction Payment Shortages Project Allocation Project Allocation Acct Only Praject Histary Status Log out
5. 1 POC SI M ene 53 DELEGATED CONTRACT PROCESS DCP PAYMENT REQUEST 89 FEDERAL AID AGREEMENT PAYMENT REQUEST e eee eee eee enn one 96 STATE AID PROJECT NUMBER REQUEST e eee ee eee eene eee eene oon eee eeuo 101 ACOUNTANT TASK FORCE ADDRESS REPORTS cccccsccscscccsccccscees 103 Accountant E Male A E E a AE A AT a 105 PATER IARE SRI 107 Tas ME Qo TREE L Mal erri aa E EEAS 109 Ro T Ore BREST 111 Page 3 State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Navigation USING HELP Document Maps and Bookmarks The Table of Contents may be used to find any topic but a document map in Microsoft WORD and bookmarks in Acrobat Reader provide navigation help from the left margin To display the document map in Microsoft WORD use the menu option View Document Map Click on any topic to navigate to that subject matter To display bookmarks in Acrobat Reader click on the Bookmarks tab on the left Bookmarks also list topics for convenient navigation Find Using Microsoft s Find option you can search for every reference to any particular word in the User Manual Find can be initiated from the menu option Edit Find or the keyboard shortcut of Ctrl F Page 4 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Repor
6. 105 855 69 2 1 099 999 009 r F0 COREG CONST 100 00 14 002 05 0 00 14 002 05 0 00 Total for Account 70 14 002 05 0 00 14 002 05 0 00 Total for the funding type 14 002 05 0 00 14 002 05 0 00 Grand Total 146 321 66 0 00 146 321 66 132 319 61 Note OR Overrun Account Report ID FCRBPayDetail All v20080509 Print Date 4 16 2009 7 08 13AM Page 77 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Minnesota Department of Transportation Office of Finance FCRB Payment Detail County SAMPLE MAPS Contract Nbr FF326 State Aid Project Number 099 999 009 Project Type DCP Federal Project Number 2308 153 Pay Request Nbr 1 Local Project Number Fund 300 Payments Paying Original Acct Acct GFS Nbr Cat Priority SP Net Cert Amt Paid to Date L110 L110 FF326 01 C 1 1 099 999 009 105 855 69 0 00 Grand Total 105 855 69 0 00 This report uses tables FCRB CARD FCRB_PROJ_ SETUP FCRB ACCT FED FCRB WORK CERTIFIED HDR FCRB WORK CERTIFIED FCRB PAYMT DETAIL CO MUNI INFORMATION Nate OR Cverrun Account Report ID FCRBPayDetailAll v20080509 MASTER ACCTS Payment Detail Appearance Page 4 of 4 Work Certified Through 09 22 2008 Payment Date 10 01 2008 Total Due 105 855 69 105 855 69 Print Date 4 16 2009 7 08 13AM Page 78 Return to Table of Contents State Aid Accounting System Minnesota Department
7. 20 7 77 2601262 000 1 1 027 753 010 Q100 Q100 BR REPLACEMENT 80 00 1 591 293 70 1 559 467 83 31 825 87 31 825 87 Grand Total 2 463 296 52 2 405 458 03 57 838 49 31 825 87 L 7 Contractor Paid Federal oca State Aid Br Bond Misc Approp Other To Dt Amt Total 1 591 293 70 0 00 483 806 82 388 196 00 0 00 2 463 296 52 Receipts 1 591 293 70 0 00 0 00 0 00 0 00 1 591 293 70 Rev Unearned Rev 0 00 0 00 0 00 0 00 0 00 0 00 This report uses tables FCRB_CARD FCRB_PROJ SETUP FCRB_ACCT FED FCRB WORK CERTIFIED HDR FCRB PAYMT DETAIL MASTER ACCTS CO MUNI INFORMATION MAPS FCRB LEDGER Report ID FCRBPaySummary 120090714 Print Date 12 8 2009 6 18 30AM Page 82 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Setup Project Setup Purpose View Federal Project Setup by category and account Displays Encumbrance Summary Original Encumbrance Amount Adjustments Payments Ending Encumbrance Balance Category Totals Original Category Amount Current Category Amount Original Encumbered Amount Current Orig Adj Encumbrance Amount Account Limits Audience All users Screen This is the entry screen Enter the Project Number and then click View Report SAAS Web Reporting Functional Business View FCRB County and Municipality Reports FCRB Project Setup Enter Project Number to view ar click Lo
8. 4 PV 99 099 099 5107309001I 0 00 0 00 6 00 0 00 0 00 0 00 134 986 78 134 986 78 11 13 2007 CR 0959 995 59 T073 14F0021 0 00 0 00 0 00 134 986 78 0 00 0 00 0 00 0 00 Totals 0 00 0 00 0 00 593 400 00 00 0 00 593 400 00 00 Bridge Bonding Payments Trans Dt Paymt Amt 07 20 2007 0 00 08 14 2007 819 408 50 9 10 2007 46 734 53 10 05 2007 amp 48 460 7 11 05 2007 162 223 95 12 04 2007 249 447 39 05 02 2008 278 102 29 ORD 2008 158 702 73 10 16 2008 81 076 20 0203 20049 5 143 88 02 17 2009 0 00 1 049 299 75 Note Bridge Bonding payments made prior to SAAS conversion Nov 2002 are not included in this report Report ID FCRBLedgerByCardSummary v20090421 Print Date 4 21 7009 3 41 36PM Page 72 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Detail Payment Detail Purpose View Federal Project Payment Detail by account Displays certified to date retainage damage incentive net certified amounts for individual payment requests Audience All users Screen This is the entry screen Enter the County Municipal Number press the Tab Key or click the Project Number select the Project Number select Voucher Number All or an individual voucher select report view All or by Account Category Fund 300 or Project then click View Report SAAS Web Reporting Functional Business View FCRB County and Municipal
9. AH174 Vendor Nbr 01010101010 Vendor Name SAMPLE COUNTY Job Nbr Pct Fund 300 Cap Ind Ind T44829 80 00 T Federal Total Fund 300 Cap Ind Ind N Y N N Non Federal Total Grand Total Project Setup Appearance Page 1 of 4 Original Enc Amt Plus Enc Adjustments Less Payments Contract Enc Amt 593 400 00 593 400 00 Contract Enc Amt 1 049 299 75 287 199 00 1 336 498 75 1 929 898 75 Print Date 4 20 2009 10 31 49AM Enc Balance Fed Auth Amt 593 400 00 593 400 00 0 00 264 572 11 328 827 89 Page 85 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Setup Appearance Page 2 of 4 Minnesota Department of Transportation Office of Finance FCRB Project Setup Cats Par Pct Non Par Original Current Note Pct Cat Amt Cat Amt 1 100 00 0 00 1 642 699 75 1 642 699 75 Priority Acct Nbr AC FR Job Nbr Pct Fund 300 Cap Current Cat Amt Ind Ind 1 L110 060 098 144829 80 00 Y T 593 400 0000 593 400 00 Priority Acct Nbr SP FP Job Nbr Pct Part Fund300 Cap Overrun Current Cat Amt Limit Amt Ind Ind Ind Ind 1 245 099 999 099 2000 Y N Y N 148 350 0000 2 245 099 999 099 100 00 T N Y Y 900 949 7500 3 70 099 999 099 100 00 Y N N Y 0 0000 1 049 299 75 Total 1 642 699 75 2 0 00 100 00 180 000 00 180 000 00 Priority Acct Nbr SP FR Job Nbr Pct Part Fund300 Cap Ov
10. Culvert Br jo Approach Panel n Bridge R Rehab E rcha ecological Stud Study E Brdas Removal r fet Areawide Planning NonConstruction n Access Control i Emergency We Preempbon Guardrail f Interconnect ig Bridge Replacement El lArtilack Accpursibiin a Bridge Widening jE Constructa Sigra Engineering e Railroad Crossing dads reci RE IE poorne Management Surfacing E Cutvert Extension I Pun IE Ramp Meter E Cuert Replacement E Corridor Study s Signal Lamp E Deck Replacement Napincement E Design Engineering Reptacemant B B 4 er Ir Signing Develop A isis ca e IE Existing Alignment Bice E Striping o iint Repair El penal Iai El Mechanical th Upgrade EI ain ee m Rricige El p iati Piultiuse Trail m Underpese ind bike io amp ceric Easement n New Alignment El Tourist Irifirmatiori O New Bridge E raining Conference Concrete Ml amp n Overlay pi Mew Culvart p Concrete Overlay O Erea ee L c RN ED Conerete surfacing O Pedestrian Bridge 3 Construct Detour o AL io Culvert lo Rasing Replacement 3 curb amp Gutter p Beea p Biagonal Parking E Temporary Bridge E3 erainagen ess LO Culv E Emergency Repairs E Erosion Repas O Existing Alhgrmernt o erating o Hov Lane p Median E Micro Surfacing E New Alignment o Patching io Roundabou
11. District Co Muni Sort Order from the drop down lists Click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Aging Year Requested Project Type District QR comuni Ja 0 0 M Cort Order Project Number Bid Opening Date This rep Project Number pen projects that had bid openings through the end of the Year Requested Log out of system There are no drill downs for this report The next two examples show the report sorted by Bid Opening Date and Project Number Page 17 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Aging Sorted by Bid Opening Date Appearance Minnesota Department of Transportation Office of Finance PEDEM SAAS Aging Report Project Tvpe ALL Bid Opening Date prior to 12 31 2009 Sorted by Bid Opening Date All Districts County 001 AITKIN Bid Plan DSAE Proj Nbr av Koad Name Location Account ae Tat ObligAmt Paid to Date Enc Amt Due bie e 001 599 031 SAP 432ND LANE 75 SPECIAL TOWN BR CONST p 52 735 00 0 00 52 735 00 001 599 032 SAP 257TH PLACE UNT47R24 75 SPECIAL TOWN BR CONST p 317 230 08 0 00 317 230 08 001 599 031 SAP 432NDLANE 75 SPECIAL TOWN BR ENG P 15 000 00 0 00 15 000 00 001 599 032 SAP 257TH PLACE UNT47R24 76 TOWN BRIDGE CONST F 2 639 42 0 00 2 039 42 001 603 009 SAP GROVEST 70 CO REG CONST C
12. of 4 FCRB Payment Detail County SAMPLE MAPS Contract Nbr FF326 Work Certified Through 09 22 2008 State Aid Project Number 099 999 009 Project Type DCP Payment Date 10 01 2008 Federal Project Number 2308 153 Pay Request Nbr 1 Local Project Number Payment Detail by Category Damage Total Met Cat ParAmt X NonParAmt Total Cert Amt Retainage Incentive Cert Amt 1 139 283 80 0 00 139 283 80 6 964 19 0 00 132 319 61 Orig Paying Acct Total Net Prev Net Nettet Priority SP Acct Acct AC Pct Cert Amt Cert to Dt this Voucher Paymt Amt 1 099 999 009 20g 202 20 00 526 463 92 0 00 26 463 92 26 463 92 1 099 999 009 L110 L110 80 00 105 855 69 0 00 105 855 69 105 855 69 Total for Cat 132 319 61 0 00 132 319 61 132 319 64 2 0 00 14 739 00 14 739 00 736 95 0 00 14 002 05 rig aying cct otal Ne Priority SP Acct Acct AC Pet Cert Amt Cert to Dt this Voucher Paymt Amt 1 099 999 009 70 70 100 00 14 002 05 0 00 14 002 05 0 00 total ron care 14 002 05 0 00 14 002 05 0 00 Note OR Overrun Account Report ID FCRBPayDetailAll v20080509 Print Date 4 16 2009 7 08 13AM Page 75 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Detail Appearance Minnesota Department of Transportation Office of Finance Page 2 of 4 FCRB Payment Detail County SAMPLE MAPS Contract Nbr FF326 Work Certified Through 09 22 2
13. 0 00 0 00 0 00 0 00 0 00 Report ID Status v20080904 Print Date 4 21 2009 2 22 08PM Page 55 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Status Report Drill Down Drill Down Drill down on Allocations Preview Annual Allocations Report ID AnnlAlloc State of Minnesota Rum Date 10 31 2002 Department of Transportation Inquire on Annual Allocations for 2002 County 001 AITKIN Acct Account 70 CO REG CONST as of 10 31 2002 Alloc Amt Comment 2 000 589 00 2 000 589 00 Drill down on Deposits Preview Annual Allocations Deposits Report ID Deposits State of Minnesota Run Date 10 31 2002 Department of Transportation Inquire on Deposits and Outstanding Billed Amounts for 2002 County 001 AITKIN Acct Account 70 CO REG CONST as of 10 31 2002 Proj Nbr Desc Billed Amt Date Billed AmtPaid Date Paid Drill down on Transfers Preview Annual Allocations Deposits Transfers Report ID Transfers State of Minnesota Run Date 10 31 2002 Department of Transportation Inquire on Transfers for 2002 County 001 AITKIN Account 70 CO REG CONST as of 10 31 2002 To Account 70 CO REG CONST 71 CO MUNI CONST 80 CO REG MAINT 70 CO REG CONST Page 56 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Status Report Drill Down
14. 00 0 00 53 636 50 118 080 031 SAP 07 17 2006 12 05 2006 519 943 00 81 347 00 601 290 00 360 749 68 240 540 32 0 00 Report ID BrdgBondByAcct v20080527 Print Date 4 21 2009 9 43 19AM Page 29 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bridge Bonding amp Other State Bonding Programs Summary Bridge Bonding amp Other State Bonding Programs Summary Purpose To display summarized information regarding Bridge Bonding and Other State Bonding Programs accounts Uses Shows funds available for payment reserved for projects original allocation less net allocated and available to allocate Audience All users Screen This is the entry screen Select All Appropriations or Open Appropriation Only and Reporting Year Month from the drop down list Note that reports cannot be run for a reporting month prior to the listed date Click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Bridge Bonding amp Other State Bonding Programs Summary Account Number AART ada ate ela Reporting Year Manth j This repart can nat be run far a reporting month prior to 11 2002 Log out of system The next 2 pages display the appearance of the report Page 30 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March
15. 00 0 00 1 737 29 0 00 001 AITKIN 07 19 2007 001 624 001 70 CO REG CONST 981 54 0 00 0 00 0 00 0 00 0 00 981 54 0 00 001 AITKIN 01 06 2004 001 634 002 70 CO REG CONST 397 62 0 00 0 00 0 00 0 00 0 00 397 62 0 00 001 AITKIN 11 17 2000 001 636 002 70 CO REG CONST 680 25 0 00 680 25 680 25 0 00 0 00 0 00 0 00 001 AITKIN 07 26 1996 MAINTENANCE 71 CO MUNI CONST 4 607 36 0 00 0 00 0 00 0 00 0 00 4 607 36 0 00 001 AITKIN 03 08 1997 MAINTENANCE 70 CO REG CONST 6 612 24 0 00 0 00 0 00 0 00 0 00 6 612 24 0 00 002 ANOKA 04 06 2006 002 600 013 73 STATE PARK 2 002 90 0 00 0 00 0 00 0 00 0 00 2 002 90 0 00 002 ANOKA 12 31 2002 002 612 008 70 CO REG CONST 3 758 588 00 0 00 0 00 0 00 0 00 0 00 3 758 588 09 0 00 002 ANOKA 07 19 2004 002 617 005 70 CO REG CONST 1 226 193 38 0 00 0 00 0 00 0 00 000 1 226 193 38 0 00 002 ANOK A 02 13 2002 002 617 017 70 CO REG CONST 739 126 29 0 00 739 126 29 739 126 29 0 00 0 00 0 00 0 00 002 ANOKA 03 07 2002 002 716 002 70 CO REG CONST 5 856 82 0 00 5 856 82 5 856 82 0 00 0 00 0 00 0 00 002 ANOK A 12 31 2002 002 716 004 70 CO REG CONST 159 702 21 0 00 0 00 0 00 0 00 000 15970221 0 00 003 BECKER 09 15 1999 003 599 015 76 TOWN BRIDGE 5 688 10 0 00 5 688 10 5 688 10 0 00 0 00 0 00 0 00 003 BECKER 06 27 2000 003 599 016 76 TOWN BRIDGE 35 715 25 0 00 0 00 0 00 0 00 0 00 35 715 25 0 00 003 BECKER 08 21 2001 003 600 007 70 CO REG CONST 197 600 00 0 00 197 600 00 197 600 00 0 00 0 00 0 00 0 00 003 BECKER 04 06 1992 0
16. 218 685 5347 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Dawn Timmer Jackson ri dawn timmer co jackson mn us 23053 780th St Jackson MN 56143 Phone No 507 847 2525 Fax No D 84 2538 Appointment Date 10 01 2009 Term Expiration Date 09 30 2011 Barbara O hara Kittson 2 bohara co kittson mn us 401 2nd St SW Hallock MN 56728 Phone No 218 843 2686 Fax Mo 218 843 2488 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Report ID TaskForceList v20100302 Print Date 3 15 2010 7 46 12 AM Page 113 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force List Appearance qp Page 3 of 4 State Aid Accounting Task Force List R Name County Dept District Agency Email Address Hobin Sterzinger Lincoln a8 rsterzinger co lincoln mn us Lincoln County Courthouse PO Box 97 Ivanhoe MN 56142 97 Phone No 507 694 1464 Fax No o0 694 1101 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Cindy Wenkel Nicollet T cwenkel co nicollet mn us PO Box 518 1700 Sunrise Dr St Peter MN 56082 Phone No 507 931 1760 Fax No 507 931 6978 Appointment Date 10 01 2009 Term Expiration Date 09 30 2011 Paula Herring Olmsted 6 herring paula co olmsted mn us 2122 Campus Drive SE Rochester MN 55904 Phone No 507 328 7070 Fax No 507 328 7 083 Appointment Date 10 01 2008 Term
17. 634 00 2 315 846 24 0 00 0 00 575 213 21 1 740 633 03 260 837 54 0 00 1 479 795 49 0 00 0 00 0 00 1 479 795 49 Account 71 CO MUNI CONST Outstanding State Aid Acct to Acct Beg Yr Bal Allocation Total Deposits Transfers Disb Unexp Bal Enc BL Rsrw Bal Avail Overpymts Avail to Adv Advances 35 967 51 78 583 00 114 550 51 0 00 0 00 0 00 114 550 51 0 00 0 00 114 550 51 0 00 0 00 0 00 114 550 51 Account 73 STATE PARK Outstanding State Aid Acct to Acct Beg Yr Bal Allocation Total Deposits Transfers Dish Unexp Bal Enc B L Rsrv Bal Avail Overpymts Avail to Adv Advances 4 905 96 0 00 4 905 96 0 00 0 00 0 00 4 905 96 4 905 96 0 00 0 00 0 00 0 00 0 00 0 00 Account 75 SPECIAL TOWN BR Outstanding State Aid Acct to Acct Bes Yr Bal Allocation Total Deposits Transfers Disb Unexp Bal Enc EL Rsrv Bal Avail verpymts Avail to Adv Advances 317 230 08 67 735 00 384 965 08 0 00 0 00 0 00 384 965 08 384 965 08 0 00 0 00 0 00 0 00 0 00 0 00 Account 76 TOWN BRIDGE Outstanding State Aid Acct to Acct Beg Yr Bal Allocation Total Deposits Transfers Disb Unexp Bal Enc BL Rsrv Bal Avail Overpymts Avail to Adv Advances 5 844 98 51 454 00 57 198 98 0 00 0 00 0 00 57 298 98 82 639 42 0 00 25 340 44 0 00 0 00 0 00 25 340 44 Account 77 TOWN ROAD Outstanding State Aid Acct to Acct Beg Yr Bal Allocation Total Deposits Transfers Dish Unexp Bal Ene B L Rar Bal Avail verpymts Avail to Adv Advances 0 00 279 331 00 279 331 00 0 00 0 00 279 331 00 0 00 0 00 0 00
18. Audience All users Screen This is the entry screen Select the District click View Report SAAS Web Reporting Functional Business View Accountant Task Force Address Reports Accountant List District View Report Log out of system Page 107 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 County Aitkin 001 District 3 Name Sandy Blackledge Address 1211 Air Park Drive Aitkin MN 56431 County Anoka 002 District 5 Name Fred Edstrom Address 2100 3rd Ave Room 224 Anoka MN 55303 County Becker 003 District 4 Name Kim Kildal Address 200 State St East Detroit Lakes MN 56501 County Beltrami 004 District 2 Name Dolores A Wiggins Address 249 Adams Ave NW Bemidji MN 56601 County Benton 005 District 3 Name Michelle Dillenburg Address 321 6th Ave N Foley MN 56329 County Big Stone 006 District 4 Name Shannon Millerbernd Address 437 N Minnesota St PO Box 98 Ortonville MN 56278 County Blue Earth 007 District 7 Name Karen Langford Address 35 Map Drive PO Box 3083 Mankato MN 56002 3083 County Brown 008 District 7 Name Tamara Furth Address 1901 N Jefferson St New Ulm MN 56073 Report ID AccountantList v20100302 Accountant List District ALL Cost System Phone Fax Email Cost System Phone Fax Email Cost System Phone F
19. Highway 212 W PO Box 300 Cologne MN 55322 0300 Phone No 952 456 5205 Fax Mo 952 361 1025 Appointment Date 10 01 2007 Term Expiration Date 09 30 2009 David Enblom Cass dave enblom co cass mn us Department Of Public Works PO Box 5 9 Walker MN 56484 Phone No 218 547 1211 Fax No 218 547 1099 Appointment Date 10 01 2009 Term Expiration Date 09 30 2012 Anne Zellner Cook 4 anne zellner amp co cook mn us 609 E 4th Ave Grand Marais MN 55602 Phone No 218 387 3014 Fax No 218 387 3012 Appointment Date 10 01 2007 Term Expiration Date 09 30 2008 Report ID TaskForceList v20100302 Print Date 3 15 2010 7 46 12AM Page 112 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force List Appearance State Aid Accounting Task Force List adiac Name County Dept District Agency Email Address Duane Ruona Crow Wing 3 duane ruona co crow wing mn us 611 Oak Street Brainerd MN 36401 Phone No 218 824 1110 Fax No 218 824 1111 Appointment Date 10 01 2007 Term Expiration Date 09 30 2009 Sheila Kirkwood Goodhue 6 sheila kirkwood co goodhue mn us PO Box 404 Red Wing MN 55066 Phone No 651 385 3025 Fax No 651 388 8437 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Deidre Hubbard Grant 4 deidre hubbard co grant mn us 3rd St SE PO Box 1005 Elbow Lake MN 56531 1005 Phone No 218 685 4481 Fax No
20. Minnesota Department of Transportation Office of Finance Page 1 of 5 Delegated Contract Process Payment Request County SAMPLE Project Type DCP State Aid Project Number 099 999 099 MAPS Contract Nbr AH174 Federal Project Number 0607 098 Pay Request Nbr 3 Local Project Number Work Certified Through 03 31 2009 REQUEST FOR PARTIAL PAYMENT OF FEDERAL amp BRIDGE BONDING MISC APPROP FUNDS This is to certifify that the costs for the above contract have been incurred for work performed by the contractor for the total construction costs due based on the information summarized below hereby request reimbursement of the following amounts Federal 233 393 82 Bridge Bonding 58 348 45 Remarks Work Certified Summary Retainage Pct 5 00 Retainage Amt 0 00 Damage Incentive Amt 0 00 Cat Total Cert Amt 1 655 218 33 2 180 000 00 3 68 222 17 903 440 50 Approved Date Phone 555 555 5555 TOM ENGINEER County Engineer Preparedby JOHN SMITH pate 6 15 2009 pone 555 555 5555 _ Enclosed Copy of Partial Estimate cc DSAE with Copy of Partial Estimate Mail to Minnesota Dept of Transportation Office of Finance 395 John Ireland Blvd MS 215 St Paul MN 55101 Note OR Overnin Account Report ID FCRBPaymentRequest v20090407 Print Date 4 20 2009 1 19 24PM Page 91 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 D
21. Municipality Reports SAAS Bond Loan Schedule cofmuni amp L M Bond Type Reporting Year Month This repart can nat be run far a reporting month prior to 11 2002 Log out of system There are no drill downs for this report The next page displays the appearance of the report Page 22 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bond Loan Schedule Appearance Page of 1 Minnesota Department of Transportation Office of Finance SAAS Bond Loan Schedule COUNTY Accounts Bond Type STATE AID as of 4 21 2009 Co Muni ANOKA Issue Date 03 01 2001 Bond Number 1 Issue Amount 4 575 000 00 Applied Amount 4 575 000 00 Remaining Balance 06 00 Total Principal Scheduled 4 575 000 00 Total Principal Paid 3 480 000 00 Total Interest Scheduled 1 116 198 33 Total Interest Paid 1 047 223 33 Account Scheduled Scheduled Actual Actual Payment Type Number Payment Date Payment Pavment Date Payment INTEREST 80 05 01 2002 210 163 33 03 13 2002 210 163 33 INTEREST 80 05 01 2003 167 930 00 04 08 2003 167 930 00 INTEREST 80 05 01 2004 154 455 00 04 09 2004 154 455 00 INTEREST 80 05 01 2005 138 255 00 04 06 2005 138 255 00 INTEREST 0 05 01 2006 121 455 00 O4 06 2006 121 455 00 INTEREST 80 05 01 2007 103 855 00 04 13 2007 103 855 00 INTEREST 80 05 01 2008 85 255 00 05 13 2008 85 255 00 INTEREST 80 05 01 2009 6
22. Office of Finance SAAS Bridge Bonding amp Other State Bonding Programs Summary Account All Appropriations as of 04 20 2009 Act AcctDese Fy Fund Pe PON EniDt Org Avallfor Pymt BET Allocation Alocated to Allocate 238 2007 EMER MATCH 2002 790 O00 614 06 30 2007 50604 0 00 0 00 399 198 02 399 009 30 188 72 239 MNRECOV ROSEAU 2003 290 0000 657 06 30 2008 5004 0 00 0 00 1 000 000 00 1 000 000 00 0 00 240 MN RECOVER POLK 2003 290 000 658 S004 0 00 0 00 400 000 000 195 893 76 204 106 74 2414 DULUTH AERIAL 2005 500 0000 749 12 31 2010 5004 50 000 00 0 00 1 000 000 00 452 489 88 547 510 12 242 BRIDGE BONDING 2005 290 0000 743 12 31 2010 S04 313 678 83 722 436 18 38 977 045 15 38 9139 290 00 37 755 15 243 LRIP KEG SIGNIF 2005 290 0000 744 12 31 2010 SOS 0 00 0 00 5 000 000 00 5 000 000 00 0 00 244 LRIP SAFETY 2008 290 0000 745 12 31 2010 5009 5 956 26 283 047 30 5 000 000 00 4 982 584 60 17 415 40 245 BRIDGE BONDING 2006 290 0000 amp 07 06 30 2011 S004 3 029 212 57 2 821 762 39 52 500 000 00 51 703 955 70 796 044 80 246 MPLS LOWEY BR 2006 290 0000 808 06 30 2011 5004 0 00 0 00 2 500 000 00 2 500 000 00 0 00 247 LRIP REG SIGNIF 2006 290 0000 09 05 20 2011 5009 614 547 79 0 00 7 136 157 7 7 090 940 37 45 217 42 248 LEIF FREEBORN 2006 290 0000 810 06 30 2011 KL 0 00 0 00 500 000 00 499 999 30 0 70 249 LRIP SAFETY 2006 290 0000 S11 06 30 2011 5009 8 639 38 546 204 00 7 650 000 00 7 348 923 78 301 076 22 250 LRIP
23. State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Navigation Installation Crystal Reports When you select a report for the first time a prompt to download Crystal Report ActiveX Viewer Control will appear follow the instructions on the screen 5 This site might require the Following Activex control Crystal Report Actives Viewer Control From Business Objects Americas Click here to install x uj Click here to install the following Actives control Crystal Report Actives Viewer Control fram Business Objects Americas tenet Z When the download is complete the report you selected will appear on your screen If you do not have administrative rights to your computer the installation will fail 1f this occurs someone from your IT department will be required to sign on to your computer as administrator and install the Crystal Report ActiveX Viewer Control Microsoft Internet Explorer X AD The Crystal Report Viewer is unable to create it s resource objects This software will be loaded the first time you access a SAAS report Once the software has been successfully downloaded and installed you will not be required to download anything else Page 7 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Reports Payments and Project Number Requ
24. bd di hitpejidotapp clot state mn us 5A AS ssdegon asp AB Intrenet The above home page will allow you to access the State Aid Accounting System Click on SAAS Reports and you will be presented with the Logon screen Page 5 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Navigation Ji hilpzidatapp dot slale mn us SAASIsaasImpan asp Microsol Inlernel Explorer Fie Fell Yew Fannie Tonk Hala O O bia fn Dren gyre A L4 45 _ m Address AE Petp itdobapp doleas mn us AAS askan arp v Ele uke Wy Minnesota Department of Transportation STATE AID FINANCE 355 John Ireland Boulevard Mail Stop 215 St Paul MN 55155 1098 Welcome to the State Aid Finance Svstem Entry Page Developed by Mu DOT Ofhee of Information Technology Note These reports may not be available every other Thursday from noon to 1 p m for maintenance Please enter your password for this site and cick the Log On button Log On You MUST keg on here to access reports T you are ururg ol your account mlorrmalien contact State Aid FPmimte personnel State Aid Finance Home Page Minnesota vavessmsent lind Morihesae eners Criicg Fenici riena Vests File MnIPOT Exbiinal Weh jila General questions iriepdot gigs mn us Feedpark di nne Enter your Password and then click Log On Page 6 Return to Table of Contents Td
25. government Government Display summarized transactions for a selected Federal Project View Receipts received by source type Ledger by Card Summary Payments made and Cash Balance View Federal Project Payment Detail by Account Category Fund 300 or Project Displays certified to date retainage damage incentive net certified amounts for individual payment requests Payment Shortages Federal Advance AH AC Display total payment shortage for Federal Advance Construction AC Payment Summary Payment Summary Payment Summary Display summarized payment information for the selected project summarized payment Display summarized payment information for the selected project for the selected project Payment Detail View Federal Project Setup by category and account Displays Encumbrance Summary Original Encumbrance Amount Adjustments Payments Ending Encumbrance Balance Category Totals Original Category Amount Current Category Amount Original Encumbered Amount Current Orig Adj Encumbrance Amount Account Limits Project Setup Page 60 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Encumbrance Encumbrance Open Projects Purpose DCP amp Agreements displays the remaining Federal Balance available for payment to local government Traditional displays total balance available for paymen
26. screen shot of the report Page 51 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project History Appearance Page 1 of 1 Minnesota Department of Transportation Office of Finance SAAS Project History Report COUNTY 045 MARSHALL Proj Nbr 045 617 006 Plan Approval Dt Tied To Local Proj Nbr Bid Opening Dt 05 15 1990 Fed Proj Nbr Contractor Name Project Type SAP Description TH 1 6 MI N AND3MI E OF OSLO Type of Work Total Overpymt Actual Overpymt Proj Oblig PP Applied Payment Payment To Be To Be State Aid Acct to Acct Incl All Oblig TransDt Acct FT Encumbrances To Pymt Amount Short Applied Refunded Advances Advances 258 100 97 13 31 1990 70 PP I 12 908 05 0 00 245 252 92 0 00 0 00 0 00 0 00 0 00 Comments Converted 20021115 201 000 75 08 15 99 70 FP 3 0 00 0 00 15 753 86 0 00 0 00 0 00 0 00 0 00 Comments Converted 20021115 Total 0 00 261 006 78 0 C40 0 04 0 00 0 00 00 This report uses tables CO MUNI INFORMATION FEDERAL PROJS MASTER_ACCTS OVERPAYMTS_LEDGER PROJ_ACCT_ENC_SUM PROJS TRANS LEDGER FCRB CARD FCRB PROJ SETUP FCRB WORK CERTIFIED HDR FCRB PAYMT DETAIL Note Bridge Bonding payments and Short payments made prior to SAAS conversion Nov 2002 are not included in this report Note Federal payments made prior to FCRB conversion Sept 2007 are not included in this report Note Column labeled PP F
27. the entire report to print select Landscape Preview printing and other typical printing options Preview displays the tree navigation information see Tree example below Envelope allows you to export the report into a number of formats such as e F a Crystal Report a WORD document or an Excel spreadsheet Lightening Bolt the Refresh the screen function for running a report with new selection criteria Tree opens the left side Preview bar for easy navigation of the report Tree example navigation in the Preview window allows you to jump directly to a particular place in the report MUNICIPALITY ANDOVER a 35106942 379307 00 93037643 000 3179117 000 87876325 731613 12500000 80 824 12 MUNICIPALITY ANOKA 680 624 12 0090 Account 94 MUNI MAINT 0091 Beg Yr Bal Allocation Total Deposits Transfers Lisb Unexp Bal Ex BELRav Pal Avail Bead 74958 58 40983100 484 789 58 000 5179117 437704115 59 539 60 000 5651500 34024 60 MUNICIPALITY APPLE V 34024 60 0090 RED aoe MUNICIPALITY ARDEN H Account 90 MUNI CONST MUNICIPALITY AUSTIN BegYrPal Allocation Total Deposits Transfers Dib UnexpRal Ew __ BLRav Bul Avail MUNICIPALITY BAXTER 196 517 55 405 038 00 89160555 000 000 344258 90 54734665 29 370 27 000 517976 38 MUNICIPALITY BEMIDJI 51797638 M
28. you what page of the report you are on and how many total pages there are of the report When you first enter a page the total number of pages to the report does not display To display the total number of pages simply navigate to page two This action will prompt the total number of pages in the document to appear Knowing the length of a report is particularly helpful when making decisions about printing the report 20 copies of a 100 page report may tie up the printer for awhile See the following screens Initially only Page 1 is given x Se elle i N oye ie M3 Preview 250 MUNICIPALITY COUNTY Report ID GFAREG State of Minnesota Run Date 10 29 2002 Depariment of Transportation COUNTY General Fund Advances Regular x amp amp 2 z M Preview 250 MUNICIPALITY 70 COUNTY Report ID GFAREG State of Minnesota 71 Run Date 10 29 2002 Depariment of Transportation COUNTY General Fund Advances Regular Page 1 now shows total number of pages Report ID GFAREG State of Mi MUNICIPALITY Run Date 10 29 2002 Depariment of Transportation General Fund Advances Regular As of 10 28 2002 COUNTY Mx Albwab oto Advancs 10 000 000 00 Stop Load Box this icon is enabled when a report is loading You may use it to stop loading the report or to cancel a search
29. 0 00 0 00 08 13 2008 PARTIAL 027 752 009 5 12 13 2000 1 000 000 00 484 473 80 1 484 473 80 1 462 990 96 21 079 85 402 99 0 00 04 20 2004 PARTIAL 062 649 011 5 11 16 2004 5 000 00 15 000 00 100 000 00 56 195 83 43 749 24 54 93 0 00 08 22 2008 PARTIAL 062 649 023 5 02 15 2007 700 000 00 0 00 700 000 00 700 000 00 0 00 0 00 0 00 10 13 2008 PARTIAL 062 649 024 5 07 09 2008 750 000 00 0 00 750 000 00 394 877 03 20 783 00 334 339 97 0 00 10 16 2008 PARTIAL 062 672 004 5 10 02 2008 3 100 000 00 0 00 3 100 000 00 2 085 383 79 109 757 04 904 859 17 0 00 10 13 2008 PARTIAL 062 672 005 5 02 01 2007 2 130 000 00 0 00 2 130 000 00 329 555 66 800 444 34 0 00 0 00 10 03 2008 PARTIAL 062 688 003 5 07 17 2007 1 500 000 00 0 00 1 500 000 00 1 082 752 23 417 247 77 0 00 0 00 08 22 2008 PARTIAL Report ID ProjAllocByAcct v20080527 Print Date 4 21 2009 33 06PM Page 50 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project History Project History Purpose To provide a detailed history of all transactions for a specific project Audience All users Screen This is the entry screen Enter the Project Number and then click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Project History Project Number Log out of system Drill down capacity is demonstrated on the pages following the
30. 00 Project Total 33 020 34 County Total Note This report reduces the payment amount for overpayments applied Report ID DisbDetail v20081110 Page 34 Disbursement Detail by Co Muni amp Control Section Number Appearance Page of 5 Payment Amount 53 986 92 53 986 92 53 986 92 668 385 53 658 645 52 358 030 50 1 685 061 55 1 685 061 55 6 774 33 6 774 33 6 774 33 83 408 24 1 973 83 85 382 07 72 545 04 72 545 04 157 927 11 202 501 10 67 344 46 47 418 66 182 575 30 162 264 99 74 122 12 236 387 11 53 811 81 Print Date 4 21 2009 10 32 29 AM Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Local Bridge Project Expenditure Obligation Report Summary Local Bridge Project Expenditure Obligation Report Summary Purpose To display information regarding Bridge Bonding and Town Bridge Funds that have been spent in the districts counties or municipalities Audience All users Screen This is the selection screen Select District or Co Muni and Beginning Award Date and Ending Award Date from the drop down lists Click View Report SAAS Web Reporting Functional Business View State Aid County and Municipality Reports SAAS Local Bridge Project Expenditure Obligation Report Summary District OR Co Muni Beginning Award Date oz v Ending Award Date oz
31. 008 State Aid Project Number 099 999 009 Project Type DCP Payment Date 10 01 2008 Federal Project Number 2308 153 Pay Request Nbr 1 Local Project Number Total Net Prev Net Net Cert p A Cert Amt Cert to Dt this Voucher CST WIN Grand Total 146 321 66 0 00 146 321 66 132 319 61 Note OR Overrun Account Report ID FCRBPayDetailAll v20080509 Print Date 4 16 2009 7 08 13 AM Page 76 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Detail Appearance Minnesota Department of Transportation Office of Finance Page 3 of 4 FCRB Payment Detail County SAMPLE MAPS Contract Nbr FF326 Work Certified Through 09 22 2008 State Aid Project Number 099 999 009 Project Type DCP Payment Date 10 01 2008 Federal Project Number 2308 153 Pay Request Nbr 1 Local Project Number Payment Detail by Account Orig Paying Acct Acct Total Net Prev Met Met Cert Cat Priority SP Acct Acct Desc AC Pct Cert Amt Cert to Dt this Voucher Paymt Amt 1 1 099 999 009 252 252 BRIDGE BONDING 20 00 26 463 92 0 00 26 463 92 26 463 92 Total for Account 252 26 463 92 0 00 26 463 92 26 463 92 Total for the funding type 26 463 92 0 00 26 463 92 26 463 92 1 1 098 999 009 L110 L110 BRIDGE 19596 0FF 80 00 105 855 69 0 00 105 855 69 105 855 69 Total for Account L110 105 855 69 0 00 105 855 69 105 855 69 Total for the funding type 105 855 69 0 00 105 855 69
32. 03 601 015 70 CO REG CONST 17 425 24 0 00 0 00 0 00 0 00 0 00 17 425 24 0 00 Page 40 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Document Maintenance Payment Document Final Maintenance Purpose Payment document used to display specific details related to a maintenance payment Audience All users Screen This is the entry screen Select the County Municipality Co Muni and Year Requested from the drop down lists then click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Payment Document Final Maintenance coMui Ja 0 0 0 M Year Requested lew Report Log out of system The next page displays the appearance of the report Page 41 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 State Aid Payment Document Maintenance Appearance NES eS Or Minnesota Department of Transportation Office of Finance MAIL STOP 215 395 JOHN IRELAND BLVD Phone 651 366 4854 ST PAUL MN 55155 1899 Fax 651 366 4909 STATE AID MAINTENANCE PAYMENT DOCUMENT Customer Account Maintenance COUNTY 002 ANOKA Payment Type FINAL DOUGLAS FISCHER Allocation Year 2008 ANOKA COUNTY HIGHWAY DEPT Transaction Date 07 01 2008 1440 BUNKER LAKE BLVD NW ANDOVER MN 55304 0 Regul
33. 1 98211685 59224581 389 871 04 0 00 0 00 Report ID PrajAlloc v20080527 Print Date 4 21 2009 1 25 49PM Page 48 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Allocation Acct Only Project Allocation Acct Only Purpose To display information regarding County and Municipal project allocations by account Uses To determine what funds have been allocated To identify the unexpended balance available to allocate to counties and municipalities Audience All users Screen This is the entry screen Select the Account Allocation Year and Reporting Year Month Project Status All or Open from the drop down lists Note that reports cannot be run for a reporting month prior to the listed date Click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Project Allocation Acct Only Reporting Tear Month Project Status ALL PROJECTS This report can not be run far a reporting month prior to 11 2002 Log out of system The next page displays the appearance of the report Page 49 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Allocation Acct Only Appearance Minnesota Department of Transportation Office of Finance Page of 7
34. 10 02 2007 0 00 625 535 09 0 00 371 592 00 0 00 997 127 09 11 21 2008 03 16 2009 078 611 004 7807 145 AH368 08 07 2007 08 07 2007 0 00 26 330 00 122 340 80 240 800 00 0 00 389 470 80 05 30 2008 03 23 2000 078 613 007 7807 144 FF042 11 06 2007 11 06 2007 0 00 12 260 75 57 022 05 200 800 00 0 00 270 482 80 07 24 2008 03 25 2009 080 623 013 8006 058 FF249 05 22 2008 06 12 2008 0 00 440 603 36 0 00 789 676 00 0 00 1 230279 36 01 08 2009 04 02 2009 083 598 018 8308 013 FF275 06 26 2008 10 000 00 0 00 76 502 14 306 008 54 0 00 392 510 68 10 01 2008 01 14 2009 091 060 017 MN02 003 88504 6 290 00 0 00 0 00 24 960 00 0 00 31 250 00 01 23 2009 02 05 2009 Yes 091 060 051 MN05003 80560 6 250 00 0 00 0 00 25 000 00 0 00 31 250 00 02 12 2000 02 18 2009 091 060 056 MN05008 89646 22 500 00 0 00 0 00 90 000 00 0 00 112 500 00 03 07 2009 04 13 2009 105 010 014 20406 031 ADT724 07 19 2006 28 034 50 0 00 0 00 100 000 00 134 665 50 262 700 00 07 25 2008 04 14 2009 105 090 003 0408 149 FF290 07 10 2008 59 130 72 0 00 0 00 155 807 48 0 00 214 938 20 10 09 2008 03 06 2009 107 399 026 2701 128 84321 06 14 2004 36 251 71 0 00 0 00 145 006 82 0 00 181 258 53 11 29 2007 03 23 2009 Note Projects with zero encumbrance at conversion and or various special projects will not appear on this report Referto excel worksheets for project data Report ID FCRBFinalProjects v20090409 Print Da
35. 2010 Bridge Bonding amp Other State Bonding Programs Summary Appearance Page 1 of 2 Minnesota Department of Transportation Office of Finance SAAS Bridge Bonding amp Other State Bonding Programs Summary Account All Appropriations as of 04 20 2009 Act Acet Dese FY Fund PO Unit End Dt Org AvallforFymt o PPP allocation Allocated to Allocate 203 BRIDGE BONDING 1995 7590 56000 518 06 30 2003 S000 0 00 0 00 595 669 82 595 669 82 0 00 204 BRIDGE BONDING 1955 290 5000 519 05 30 2003 5000 0 00 0 00 1 352 211 47 1 452 211 47 0 00 207 BRIDGE BONDING 1995 290 0000 524 8 30 2003 S006 0 00 0 00 6 747 00 6 747 00 0 00 208 BRIDGE BONDING 1995 290 5000 526 06 30 2003 5000 0 00 0 00 215 501 33 215 501 33 0 00 210 BRIDGE BONDING 1995 290 5000 536 06 30 2003 5000 0 00 0 00 63 638 19 63 638 19 0 00 213 BRIDGE BONDING 1996 290 0000 541 06 30 2003 S006 0 00 0 00 6 96 00 6 961 00 0 00 215 BRIDGE BONDING 1998 290 0000 414 06 30 2003 5004 0 00 0 00 24 751 20 24 757 20 0 00 216 BRIDGE BONDING 1998 3290 0000 414 58 30 2003 S005 0 00 0 00 30 377 28 30 377 28 0 00 217 BRIDGE BONDING 1958 290 000 4l4 06 30 2003 S006 0 00 0 00 9 576 63 90 576 68 0 00 118 BRIDGE BONDING 1998 290 0000 414 06 20 2003 5009 0 00 0 00 2 606 59 2 696 59 0 00 219 BRIDGE BONDING 1998 290 0000 543 06 30 2004 5004 0 00 0 00 1 208 30 1 203 30 0 00 2210 BRIDGE BONDING 1998 290 0000 543 06 30 2004 5006 0 00 0 00 11 726 10 11 726 10 0 00 222 BRIDGE BONDING 1998 2
36. 28 2008 03 26 2009 141 030 004 2799 276 00131 05 25 2000 07 14 2000 0 00 127 964 97 0 00 511 859 86 0 00 639 824 83 09 16 2008 03 26 2009 172 101 005 8199 102 99248 07 15 1999 254 519 18 53 168 51 0 00 212 674 03 0 00 520 361 72 08 16 2006 04 10 2009 LTC Dik C ues S Gn Gl ee Grand Tota 7 565 108 29 10 355 518 45 1 784507 59 17 794 120 65 845 706 80 32 741 961 78 This report uses tables FCRB CARD V FCRB PROJ SETUP FCRB PAID AMT V MASTER ACCTS CO MUNI TNFORMATION FCRB FINAL WORK CERT V Note Projects with zero encumbrance at conversion and or various special projects will not appear on this report Refer to excel worksheets for project data Report ID FCRBFinalProjects v20090409 Print Dale 4 21 2009 3 27 32PM Page 68 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Last Voucher Input by Local Government Last Voucher Input by Local Government Purpose Display last Delegated Contract Process DCP Request entered by local government Audience All users Screen This is the entry screen Enter the Project Number then click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports FCRB Last Voucher input by Local Government Enter Project Number to view or click Lookup to search Project Number Lookup EE f View Report Log out of system Page
37. 5 06 10 2008 05 15 2008 01 16 2009 001 632 003 SAP 4g0TH ST 70 CO REG CONST CONST P 993 039 71 943 387 72 49 651 99 06 10 2008 05 15 2008 01 16 2009 Total 8 356 096 05 5 247 591 75 798 262 30 Report ID Aging v20080527 Print Date 4 21 2009 7 23 00AM Page 19 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bond Applied Projects Bond Applied Projects Purpose To identify projects applied to bonds may select by Co Muni Bond Type and Year Month Audience All users Screen This is the entry screen Select the Co Muni Bond Type Reporting Year Month from the drop down lists Click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Bond Applied Projects CoMuni ate Bond Type Reporting Year Month This repart can not be run for a reporting month prior to 11 2002 Log out of system There are no drill downs for this report The next page displays the appearance of the report Page 20 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bond Applied Projects Appearance Page 5 of 148 Minnesota Department of Transportation Office of Finance SAAS Bond Applied Projects COUNTY Accounts Bond Type STATE AID as of 4 21 2009 Co Muni BELTRAMI Issue Date 05 01 1987 Iss
38. 5 855 00 04 03 2009 65 855 00 INTEREST 80 05 01 2010 45 455 00 INTEREST 80 05 01 2011 23 520 00 PRINCIPAL 70 05 01 2002 370 000 00 03 13 2002 370 000 00 PRINCIPAL 70 05 01 2003 385 000 00 04 08 2003 203 267 36 04 29 2003 181 732 64 PRINCIPAL 70 05 01 2004 405 000 00 04 09 2004 405 000 00 PRINCIPAL 70 05 01 2005 420 000 00 04 06 2005 420 000 00 PRINCIPAL 70 05 01 2006 440 000 00 04 06 2006 440 000 00 PRINCIPAL 70B 05 01 2007 465 000 00 04 13 2007 465 000 00 PRINCIPAL 70B 05 01 2008 485 000 00 05 13 2008 485 000 00 PRINCIPAL 70B 05 01 2009 510 000 00 04 03 2009 510 000 00 PRINCIPAL TOB 05 01 2010 535 000 00 PRINCIPAL 70B 05 01 2011 560 000 00 This report uses tables BOND LOAN SCHED PAYMTS BOND SCHED PAID SUMM CO MUNI INFORMATION TRANS LEDGER Report ID bondLoanSched v20080527 Page 23 Print Date 4 21 2009 7 44 42 AM Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bond Principal and Interest Due Bond Principal and Interest Due Purpose This report displays bond principal and interest due in a given year Information from this report is used to determine minimum allocations Audience All users Screen This is the entry screen Select the Year Requested and Bond Type from the drop down lists and then click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Bond Principal a
39. 6 181 90 1 Note 1 If the award date was blank in project tracking the repart will display projects created in SAAS during the award date range selected Note 2 Includes all funding types Const Eng ROW ete Report ID BridgeBondAcctSummary v20090915 Print Date 12 7 2009 1 03 57PM Page 36 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Local Bridge Project Expenditure Obligation Report Summary Appearance Page 2 of 3 Minnesota Department of Transportation Office of Finance TS SAAS Local Bridge Project Expenditure Obligation Report Summary Award Date between 1 1 2009 and 12 7 2009 As of 12 6 2009 Rel Township Rd of County Rd of Muni Bridges of Township Rd of County Name Cost Co Br Bond Amt Pro Br Bond Amt Proj Br Bond Amt Proj Town Bridge Amt Proj LAC QUI PARLE 037 94 200 00 4 LESUEUR 040 266 542 00 1 LYON 042 93 182 23 1 MCLEOD 043 174 276 94 3 MARTIN 046 62 399 94 1 MORRISON 049 77 332 00 1 95 838 00 1 MOWER 050 820 150 10 9 MURRAY 051 110 492 50 1 209 701 00 2 NOBLES 053 181 844 00 1 182 200 00 1 208 880 00 1 NORMAN 054 97 859 60 1 OLMSTED 055 183 655 00 1 699 926 35 2 PIPESTONE 059 187 899 00 1 159 580 00 1 RAMSEY 062 2 070 525 82 2 RICE 066 621 141 15 4 ROCK 067 113 029 66 1 ROSEAU 068 87 744 30 1 ST LOUIS 069 412 704 00 1 96 784 75 1 SCOTT 0 0 1 579 661 21 9 SIBLEY 072 3
40. 62 347 00 16 756 50 179 103 50 170 148 33 8 955 17 00 007 597 003 SAP 245 BRIDGE BONDING 09 26 2008 10 21 2008 154 686 00 1 033 00 155 719 00 147 933 05 7 785 95 0 00 007 598 025 SAP 245 BRIDGE BONDING 04 08 2008 05 13 2008 568 205 00 1 614 35 569 819 35 500 698 15 69 121 20 0 00 007 620 022 SAP 249 LRIP SAFETY 04 04 2007 400 000 00 400 000 00 0 00 0 00 0 00 0 00 007 642 008 SAP 245 BRIDGE BONDING 06 23 2006 09 18 2006 3 718 270 00 321 025 00 3 397 245 00 3 077 067 71 320 177 29 0 00 007 650 001 SP 245 BRIDGE BONDING 05 18 2047 06 11 2007 874 309 90 144 253 10 1 018 603 00 967 672 85 50 930 15 0 00 008 611 018 SP 252 BRIDGE BONDING 04 14 2009 2 222 98440 0 00 2 222 984 40 0 00 0 00 2 222 984 40 008 629 021 SAP 253 LRIP SAFETY 04 10 2009 84 388 00 0 00 84 388 00 0 00 0 00 84 388 00 009 608 013 SAP 245 BRIDGE BONDING 07 18 2006 08 28 2006 869 073 00 85 147 16 783 925 84 496 729 70 287 196 14 0 00 011 602 007 SAP 253 LRIP SAFETY 03 27 2009 80 324 70 0 00 80 324 70 0 00 0 00 80 324 70 Report ID BrdgBond v20080527 Print Date 4 21 2009 9 30 21 AM Page 27 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bridge Bonding amp Other State Bonding Programs Acct Only Bridge Bonding amp Other State Bonding Programs Acct Only Purpose To display information regarding Bridge Bonding and Other State Bonding Programs appropriat
41. 69 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Ledger by Card Summary Ledger by Card Summary Purpose Display summarized transactions for a selected Federal Project View Receipts received by source type Payments made and Cash Balance Audience All users Screen This is the entry screen Enter the Project Number then click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports amp Payment Request FCRB Ledger By Card Summary Enter Project Number to view or click Lookup to search Project Number Lookup Log out of system Page 70 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Ledger by Card Summary Screen If you do not know the Project Number press Lookup Financial Web Reporting Project Lookup Enter any known field and click Next to search Co Muni Number Federal Project Number Agreement Number project Type Enter your County or Municipal Number Federal Project Number or Agreement Number select Project Type then press Next Financial Web Reporting lick Project Number to select State Aid Project Nbr Main SP Nbr Federal Project Nbr MAPS Contract Nbr Agreement Nor Local Project Nbr Card ID 099 090 002 0
42. 72 498 50 2 565 375 40 3 STEARNS 073 160 536 00 1 TODD Of 225 562 00 1 TRAVERSE 078 101 480 00 1 Note 1 If the award date was blank in project tracking the report will display projects created in SAAS during the award date range selected Note 2 Includes all funding types Const Eng ROW etc Report ID BridgcBondAcdSummary v20090915 Print Date 12 7 2009 1 03 57PM Page 37 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Local Bridge Project Expenditure Obligation Report Summary Appearance Page 3 of 3 Minnesota Department of Transportation Office of Finance SAAS Local Bridge Project Expenditure Obligation Report Summary Award Date between 1 1 2009 and 12 7 2009 As of 12 6 2009 Rel Township Rd of County Rd of Muni Bridges H of Township Rd of County Name Cost Co amp Br Bond Amt Proj Br Bond Amt Proj Br Bond Amt Proj Town Bridge Amt Proj WABASHA 079 341 495 00 1 WASECA 081 615 724 00 1 WINONA O85 545 784 00 1 YELLOW MEDICINE 087 189 049 17 3 BEMIDJI 105 004 150 946 00 1 HIBBING 131 069 201 279 00 1 PLYMOUTH 195 027 180 857 00 1 ST PAUL 164 062 1 195 165 00 1 CORCORAN 215 027 GRAND TOTALS 785 138 00 4 12 848 581 38 44 2 028 927 15 7 9 463 761 85 58 Township Rd Br Bond Amt Control Section 599 County 039 Lake Control Section 598 County Rd Br Bond Amt Control Section 598 600
43. 9 75 593 400 00 0 00 1 958 345 31 12 16 2008 02 03 2009 018 060 006 MN05017 89618 10 140 00 0 00 0 00 40 560 00 0 00 50 700 00 03 03 2009 03 27 2009 018 615 008 1808 139 FF226 05 07 2008 05 13 2008 0 00 83 848 46 0 00 222 660 00 0 00 306 508 46 12 09 2008 03 26 2009 028 620 012 2807 101 FF049 10 01 2007 10 16 2007 0 00 108 576 91 179 450 50 160 000 00 0 00 448 027 41 01 08 2009 02 19 2009 032 090 001 3204 015 ACI2I 03 21 2005 03 22 2005 35 386 01 0 00 0 00 141 544 04 0 00 176 930 05 07 15 2005 01 14 2009 034 647 002 3407 141 AH365 07 10 2007 08 01 2007 449 077 79 1 128261 18 0 00 1 166 200 00 0 00 2 744 138 97 01 09 2009 02 17 2009 036 702 002 H157 001 FFO0 51 10 22 2007 11 14 2007 0 00 469 580 00 0 00 748 329 00 0 00 1 217 909 00 10 27 2008 03 10 2009 041 070 001 4109 137 93733 746 14 0 00 0 00 6 715 23 0 00 7 461 37 03 18 2009 04 20 2009 041 619 011 4108 134 FF211 03 18 2008 94 01 2008 0 00 328 445 63 0 00 684 000 00 0 00 1 012 145 63 12 03 2008 02 17 2009 045 617 012 4507 119 AHI82 06 19 2007 06 19 2007 0 00 27 505 00 299 492 35 370 000 00 0 00 696 997 35 12 29 2008 03 10 2009 051 604 025 5108 116 FF221 04 15 2008 05 06 2008 0 00 197 574 12 0 00 735 542 46 276 581 80 1 209 608 38 02 09 2009 03 30 2009 053 635 021 5306 011 AF513 03 01 2007 0 00 4317 776 26 0 00 1 000 000 00 0 00 5317 776 26 09 10 2008 01 06 2009 076 620 018 7607 130 AH366 09 28 2007
44. 90 0000 543 06 30 2004 5009 0 00 0 00 16 618 57 16 618 57 0 00 213 BRIDGE BONDING 1999 290 0000 434 12 31 2004 5004 0 00 0 00 612 477 28 612 477 28 0 00 224 BRIDGE BONDING 1999 290 0000 434 12 31 2004 5005 0 00 0 00 510 072 25 510 072 25 0 00 275 BRIDGE BONDING 1999 290 0000 434 12 31 2004 5006 0 00 0 00 0 00 0 00 226 BRIDGE BONDING 1999 290 0000 434 12 31 2004 5009 0 00 0 00 1 379 114 55 1 379 114 55 0 00 227 BRIDGE BONDING 2001 110 0000 498 06 20 2005 5004 0 00 0 00 87 976 34 87 976 34 0 00 278 BRIDGE BONDING 2001 290 0000 49x 06 30 2008 5004 0 00 0 00 3 555 807 40 3 555 807 40 0 00 231 BRIDGE BONDING 2001 110 0000 498 06 30 2005 5009 0 00 0 00 3747 37 47 0 00 2312 BRIDGE BONDING 2001 290 0000 583 06 30 2008 5004 6 00 0 00 8 502 641 32 8 502 641 32 0 00 234 BRIDGE BONDING 2002 290 0000 605 06 30 2008 5004 0 00 0 00 9 278 078 06 9 278 078 06 0 00 235 BRIDGE BONDING 2002 290 OC 606 S004 D o0 0 00 0 00 0 00 236 BRIDGE BONDING 2002 290 0000 607 12 31 2008 5004 0 00 0 00 43 950 374 86 43 950 374 86 0 00 237 02 FLOOD RELIEF 2002 290 0000 614 06 30 2007 5004 0 00 0 00 4 600 000 00 4 600 000 00 0 00 Report ID BrdeBondSummary 20080623 Print Date 4 21 2009 9 50 12AM Page 31 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bridge Bonding amp Other State Bonding Programs Summary Appearance Page 2 of 2 Minnesota Department of Transportation
45. 99 090 002 0607 150 FF2305 2420 099 999 099 099 999 099 0607 098 AH174 2069 Select the State Aid Project Nbr you wish to view The next page displays the appearance of the report Page 71 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Ledger by Card Summary Appearance Page 1 of 2 Minnesota Department of Transportation Office of l inance FCRB Ledger By Card Summary State Aid Project Number 099 999 099 Local Project Number MAPS Agreement SP No County City FP No Contract No No Contractor Vendor No 099 999 099 SAMPLE J 98 0607 098 AH174 SAMPLE T 01010101010 Receipts Payments Acceptance Reference Trans SP Nbr Mn Dot BrBnd amp Oth Agreement Contract Dt Cd Trans Nbr Local State Aid Bnd Prog Federal Other Amt Amt Cash Bal 08 14 2007 99 999 99 Vil PV 099 999 099 50000002146 0 00 0 00 0 00 0 00 0 00 0 00 77 634 00 77 634 00 08 20 2007 CR 099 999 099 T07230F0047 0 00 0 00 0 00 77 634 00 0 00 0 00 0 00 0 00 09 10 2007 099 999 099 VO 2 PV 099 999 099 50072530041 0 00 0 00 0 00 0 00 0 00 0 00 186 938 11 186 938 11 09 17 2007 CR 099 999 099 T07258F0034 0 00 0 00 0 00 186 938 11 0 00 0 00 0 00 0 00 10 08 2007 099 999 099 VO 3 PV 099 999 099 51072810011 0 00 0 00 0 00 0 00 0 00 0 00 193 841 11 193 841 11 10 15 2007 CR 099 999 099 T072 6F0034 0 00 0 00 0 00 193 841 11 0 00 0 00 0 00 0 00 11 05 2007 099 999 099 VO
46. AASY Reports Users Manual March 2010 Project Setup Appearance Page 4 of 4 Minnesota Department of Transportation Office of Finance FCRB Project Setup Category Amount Details Cat Cat Amt Description Added Date 1 1 642 699 75 Original 07 18 2007 2 180 000 00 Original 07 18 2007 3 107 199 00 Original 07 18 2007 1 929 898 75 This report uses tables FCRB_CARD FCRB PROJ SETUP FCRB FUND CATEGORY HDR FCRB ACCT FED FCRB_ACCT NON FED FCRB FUND CAT ACCT FED FCRB FUND CAT ACCT NON FED FCRB PROJ ENC CHANGE FCRB PROJ CAT CHANGE Report ID FCRBProjectSetup v20090115 Print Date 4 20 2009 10 31 49AM Page 88 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Delegated Contract Process DCP Payment Request DELEGATED CONTRACT PROCESS DCP PAYMENT REQUEST Purpose Process and print DCP Payment Request Audience All users Screen This is the entry screen Enter the County Municipal Number press the Tab Key or click the Project Number select the Project Number then click View Report SAAS Web Reporting Functional Business View Delegated Contract Process Payment Request Enter Co Muni Number press tab to refresh Co Muni Number Project Number Log out of system Page 89 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual Ma
47. AL TOWN BR CONST P 52 735 00 0 00 52 735 00 001 599 032 SAP 957TH PLACE UNT47R24 75 SPECIAL TOWN BR CONST P 317 230 08 0 00 317 230 08 001 599 032 SAP 957TH PLACE UNT47R24 76 TOWN BRIDGE CONST P 82 639 42 0 00 82 639 42 001 600 014 SAP 400TH PLACE 73 STATE PARK CONST P 90 654 00 85 778 04 490596 08 12 2008 06 30 2008 09 08 2008 001 603 009 SAP GROVE ST 70 CO REG CONST CONST P 1 187 038 70 1 128 256 77 59 381 953 05 17 2004 04 14 2004 06 22 2004 001 603 010 SAP GROVE STREET 70 CO REG CONST CONST p 1 179 483 71 1 120 509 52 58 974 19 06 26 2006 05 08 2006 08 15 2006 001 604 0090 SP DAM LAKE ST L240 STP FLEXIBLE CONST P 1 500 000 00 0 00 0 00 07 28 2008 07 01 2008 09 08 2008 001 604 009 SP DAM LAKE 8T 70 CO REG CONST CONST F 1 111 510 48 1 055 934 96 55 575 52 07 28 2008 07 01 2008 09 08 2008 001 607 003 SP 610TH ST 70 CO REG CONST CONST F 233 503 21 221 828 05 11 675 16 06 28 2006 05 01 2006 08 15 2006 001 607 003 SP 610TH ST L250 STP 5 000 CONST P 600 000 00 0 00 0 00 06 20 2006 05 01 2006 08 15 2006 001 626 0060 SAP AT UNNAMED STREAM 2 1 245 BRIDGE BONDING CONST P 58 119 25 0 00 58 119 25 08 19 2008 10 14 2008 001 626 006 SAP ATUNMNAMEDSTREAM 2 70 CO REG CONST CONST P 43 360 75 41 192 71 2 168 04 08 19 2008 10 14 2008 001 629 005 SAP 2s SOFCSAH 3 TO 600 70 CO REG CONST CONST p 468 214 30 444 803 59 23141071 03 24 2008 03 06 2008 05 01 2008 001 632 003 SAP 4g0THST 245 BRIDGE BONDING CONST P 135 901 00 129 105 95 6 795 0
48. Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Overpayments Appearance Minnesota Department of Transportation Office of Finance Page 1 of 115 SAAS Overpayments County ALL as of 4 20 2009 Counties Deposits Applied Original Outstanding gaat County Overpymt Dt Overpayment From Acct amp Overpayment Overpayment Billed Amt Deposited Outstanding To Be Applied Applied to Apply 001 AITKIN 01 07 2004 001 001 016 75 SPECIAL TOWN BR 37 231 23 0 00 3723123 37 231 23 0 00 0 00 0 00 0 00 001 AITKIN 12 05 2006 001 599 029 75 SPECIAL TOWN BR 81 061 32 0 00 81 061 32 81 061 32 0 00 0 00 0 00 0 00 001 AITKIN 12 08 2006 001 599 029 75 SPECIAL TOWN BR 10 000 00 0 00 10 000 00 10 000 00 0 00 0 00 0 00 0 00 001 AITKIN 03 02 1994 001 600 008 OL73 STATE PARK OLD 6 678 59 0 00 6 678 59 6 678 59 0 00 0 00 0 00 0 00 001 AITKIN 08 30 1999 001 601 009 70 CO REG CONST 26 413 58 0 00 26 413 58 26 413 58 0 00 0 00 0 00 0 00 001 AITKIN 03 22 1994 001 604 008 70 CO REG CONST 12 524 44 000 12 524 44 12 524 44 0 00 0 00 0 00 0 00 001 AITKIN 04 22 1992 001 606 012 71 CO MUNI CONST 3 415 36 0 00 0 00 0 00 0 00 0 00 3 415 36 0 00 001 AITKIN 09 03 1996 001 610 017 70 CO REG CONST 80 356 34 0 00 0 00 0 00 0 00 0 00 80 356 34 0 00 001 AITKIN 02 20 2001 001 612 013 70 CO REG CONST 1 138 42 0 00 0 00 0 00 0 00 0 00 1 138 42 0 00 001 AITKIN 10 13 1994 001 613 004 70 CO REG CONST 1 737 29 0 00 0 00 0 00 0
49. Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Payments Federal Payments Purpose View Federal Payments within a date range Displays Federal Payments within a selected date range Audience All users Screen This is the entry screen Enter the County Municipal Number select the From Date select the To Date then click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports amp Payment Request FERB Federal Payments cofmuni From Date ot is Log out of system The next page displays the appearance of the report Page 63 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Payments Appearance Minnesota Department of Transportation Office of Finance Page 1 of 1 FCRB Federal Payments Payments between 01 01 2009 and 04 21 2009 Federal SP Project Acct Nbr Paymt Amt County SAMPLE 099 999 099 5306 011 L240 1 000 000 00 Total for project 1 000 000 00 Grand Total 1 000 000 00 This report uses tables FCRB_CARD FCRB_PROJ_SETUP FCRB_WORK_CERTIFIED_HDR FCRB_PAYMT_DETAIL MASTER ACCTS FCRB_ACCT_FED Note Federal Payments made prior to FCRB conversion Sept 2007 are not included in this report Report ID FCRBFedPaymt v20080421 Print Date 4 21 2008 3 18 09PM Page 64 Return to Table o
50. ERTWP 76 TOWN BRIDGE CONST 80 836 25 76 794 44 0 00 08 19 2008 10 14 2008 001 626 006 SAP ATUNNAMED STREAM 21 245 BRIDGEBONDING CONST 58 119 25 0 00 58 119 25 08 19 2008 10 14 2008 001 626 006 SAP AT UNNAMED STREAM 2 1 70 CO REG CONST CONST 43 300 75 41 192 71 2 6804 O8 19 2008 10 14 2008 Total 356 096 05 5 247 591 75 798 262 30 Report ID Aging v20080527 Print Date 4 21 2009 7 24 47AM Page 18 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Aging Sorted by Project Number Appearance Minnesota Department of Transportation Office of Finance ee SAAS Aging Report Project Type ALL Bid Opening Date prior to 12 31 2009 Sorted by Project Number All Districts County 001 ATTRIN Bid Plan DSAE Proj Oblig Trans Opening Approval Approval Proj Nbr Type Road Name Location Account Type Pymt ObligAmt Paid to Date Ene Amt Date Date Date 001 090 001 SP HILL CITY TRAIL 61 LOCAL OFF SYS CONST P 39 240 04 0 00 0 00 06 26 2006 05 01 2006 001 090 001 SP HILL CITY TRAIL H220 STP CONST P 1 56 960 15 0 00 0 00 06 20 2006 05 01 2006 001 599 030 SAP 125TH AVE BEAVERTWP 61 LOCAL OFF SYS CONST P 10 000 00 0 00 0 00 08 19 2008 10 14 2008 001 599 030 SAP 125TH AVE BEAVER TWP 76 TOWN BRIDGE CONST P 0 836 25 76 794 44 0 00 08 19 2008 10 14 2008 001 599 031 SAP 432ND LANE 75 SPECTAL TOWN BR ENG P 15 000 00 0 00 15 000 00 001 590 031 SAP 432NDLANE 75 SPECI
51. Expiration Date 09 30 2010 Kathy Glass Polk 9 kathy glass co polk mn us 820 Old Hwy 5 South Crookston MN 56716 Phone No 218 281 3952 Fax No 218 281 39 6 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Cindy Degener State Aid Mn DOT cindy degener state mn us 395 John Ireland Blvd Mail Stop 215 St Paul MN 55155 7816 Phone No 651 366 4850 Fax No 651 366 4909 Appointment Date Term Expiration Date Report ID TaskForceList v20100302 Print Date 3 15 2010 7 46 12AM Page 114 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force List Appearance State Aid Accounting Task Force List eee Name County Dept District Agency Email Address Joan Peters State Aid Mn DOT joan peters state mn us 395 John Ireland Blvd Mail Stop 215 St Paul MN 55155 7816 Phone No 691 366 4886 Fax No 651 366 4909 Appointment Date Term Expiration Date Mike Kilanowski State Aid Mn DOT michael kilanowski state mn us 395 John Ireland Blvd Mail Stop 215 St Paul MN 55155 7816 Phone No 691 366 480 Fax No 691 366 4909 Appointment Date Term Expiration Date Tom Karlson State Auditors Office OSA tkarlson osa state mn us 2229 Park Street Suite 500 St Paul MN 55103 Phone No 651 286 4715 Fax No 651 296 5905 Appointment Date Term Expiration Date Nila Ellis Wright 3 nila ellis co wright mn us 1901 Hwy 25 North Buffal
52. Minnesota Department of Transportation March 2010 SAAS Web Reporting Manual for Minnesota Cities and Counties State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Table of Contents TABLE OF CONTENTS TABLE OF CONTENTS uite Eoi EE EEHEE HIE EEEE EE Lebens 2 CING HELEP 4 REPORT NAVIGATION eesssssssscssssssssssscscscscscccscsccecccsccccccccccceccccecccccccscccccccccccccccceseceeeee 5 A E nad enon EE 5 Installation Crystal REPOS ccccccccccsseecccccceeceaeeeeeeeeeeeenaeeseseeceeeeeaaaeeeeeeseesaaaaeeeeeeeeaaaes 7 Reports Payments and Project Number Requests eene TOO D 2 X 9 STATE AID COUNTY AND MUNICIPALITY REPORTS sssssssssseeseoooes 11 Advance CSAH amp MSAS Funds s eeeseeeeeeeeeeee eese eene eene nennen nnn nnne n nnne nnns 14 TAG 17 BONO APP LEUT TOOTS Ena ee nT CR eT nT OR een M M DRE MEE 20 Bond LOON SOC T 22 Bond Principal and TREC CSOD Ue oi e isto E AE NE 24 Bridge Bonding amp Other State Bonding Programs esses 26 Bridge Bonding amp Other State Bonding Programs Acct Only sssseee 28 Bridge Bonding amp Other State Bonding Programs
53. N 497 965 93 264 572 11 233 393 82 233 393 82 1 3 099 999 099 TO TOOR CO REG CONST 100 00 0 00 0 00 0 00 0 00 2 1 099 999 099 TO 0 COREG CONST 100 00 171 000 00 171 000 00 0 00 30 00 3 1 099 999 099 70 70 COREG CONST 100 00 54 811 06 4 493 50 60 317 56 0 00 Total for Account 70 SA COUNTY REGULAR CONST 235 811 06 175 493 50 60 317 56 0 00 Napa ar eee ee 235 811 06 175 493 50 60 317 56 0 00 Grand Total 858 268 47 506 208 64 352 059 83 291 742 27 Total Federal 497 965 93 Less Prev Paymts 264 572 11 Federal Due 233 393 82 Note OR Overnum Account Report ID FCRBPaymentRequest v200590407 Print Date 4 20 2009 1 19 24PM Page 93 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Delegated Contract Process DCP Payment Request Appearance Minnesota Department of Transportation Office of Finance Page 5 of 5 Delegated Contract Process Payment Request County SAMPLE Project Type DCP State Aid Project Number 999 999 099 MAPS Contract Nbr AH174 Federal Project Number 0607 098 Pay Request Nbr 3 Local Project Number Work Certified Through 03 31 2008 Total Bridge Bonding 124 491 48 Less Prev Paymts 66 143 03 Bridge Bonding Due 58 348 45 Note OR Overnun Account Report ID FCRBPaymentRequest v20090407 Print Date 4 20 2009 1 19 24PM Page 94 Return to Table of Contents State Aid Accounting System M
54. ONST P 1 187 638 70 1 128 256 77 59 381 93 05 17 2004 04 14 2004 06 22 2004 001 090 001 SP HILL CITY TRAIL 61 LOCAL OFF SYS CONST P 39 240 04 0 00 0 00 06 26 2006 05 01 2006 001 607 003 SP 610TH ST 70 CO REG CONST CONST p 233 503 21 221 828 05 11 675 16 06 26 2006 05 01 2006 08 15 2006 001 607 003 SP 610TH ST L250 STP lt 5 000 CONST p 600 000 00 0 00 0 00 06 26 2006 05 01 2006 08 15 2006 001 090 001 SP HILL CITY TRAIL H220 STP CONST p 156 960 15 0 00 0 00 06 26 2006 05 01 2006 001 603 010 SAP GROVE STREET 70 CO REG CONST CONST P 1 179 483 7 1 120 509 52 58 974 19 06 26 2006 05 08 2006 08 15 2006 001 629 005 SAP 259 SOFCSAH 3 TO 600 70 CO REG CONST CONST p 468 214 30 444 803 59 23 410 71 03 24 2008 03 06 2008 05 01 2008 001 632 003 SAP 4g0TH ST 245 BRIDGE BONDING CONST P 135 901 00 129 105 95 6 795 05 06 10 2008 05 15 2008 01 16 2009 001 632 003 SAP 480TH ST 70 CO REG CONST CONST F 993 039 71 943 387 72 49 651 99 06 10 2008 05 15 2008 01 16 2009 001 604 009 SP DAM LAKE ST 70 CO REG CONST CONST P 111 1048 1 055 934 96 55 575 52 07 28 2008 07 01 2008 09 08 2008 001 604 009 SP DAM LAKE ST L240 STP FLEXIBLE CONST P 1 500 000 00 0 00 0 00 07 28 2008 07 01 2008 09 08 2008 001 600 014 SAP 400TH PLACE 73 STATE PARK CONST p 90 684 00 85 778 04 4 905 96 08 12 2008 06 30 2008 09 08 2008 001 599 030 SAP 125TH AVE BEAVERTWP 61 LOCAL OFF SYS CONST p 10 000 00 0 00 0 00 08 19 2008 10 14 2008 001 599 030 SAP 125TH AVE BEAV
55. Programs Acct Only To display information regarding Bridge Bonding and Miscellaneous Appropriation accounts Bridge Bonding amp Other State Shows funds available for payment reserved for projects original allocated less net allocated and Bonding Programs Summary available to allocate Expenditure Detail By Co Muni amp To display expenditure information by county muni or district and control number by all or selected Control Section Number accounts within a selected date range Local Bridge Project Ex Expenditure Oblicati ation Report Summary districts counties or municipalities Overpayments To display information regarding Overpayments how an overpayment occurred was the verpayments overpayment applied to another project or billed FERMLSUIEDINS MGE UU Payment document used to display specific details related to a maintenance payment Maintenance Payment Document Construction Payment document used to display specific details related to a construction project payment To display information regarding County and Municipal project allocations This report is used to determine what funds have been allocated and to identify the unexpended balance available to To display information regarding Bridge Bonding and Town Bridge Funds that have been spent in the Project Allocations 1 I ii 1 ifi n Ir ll H Bises e DN allocate to counties and municipalities This is specifically for allocation method P by project verses meth
56. RDED Log out of system You may view the Advance Code Levels for Cities or Counties click on the colored button for the Current Advance Code Status a window will appear with the Advance Code description Page 14 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Advance CSAH amp MSAS Funds E http fcereports dot state mn us AdvanceCode Microsoft Internet JE Bx Code GREEN LOW Plush Fund Balance Advances approved on first come first serve basis while funds are available Resolution required Request to Reserve form optional L Internet 2a http cereports dot state mn us AdvanceCode Microsoft Internet 23 f ak Code BLUE GUARDED Fund Balance low Priority System in use Advances approved on a case by case basis Resolution required Reserve option available only prior to bid advertisement by email or phone L Internet A http cerepurts dot state mn us AdyanceCode Microsoft Internet Jr e Code ORANGE H1GH Fund Balance expected to drop below acceptable balance Priority System in use Advances approved by State Aid Engineer only Resolution required Reserve form not used b Internet E http cereports dot state mn us AdvanceCode Microsoft Internet Je B Code RED SEVERE Fund Balances too low NO ADV ANCES NO EXCEPTIONS eb Internet There are no drill downs for this repo
57. SAAS Project Allocation Acct Only ALL PROJECTS Account 72 CO TURNBACK As of 4 20 2009 Balance Available to Allocate 16 270 159 73 Original Original Net Paymt Proj Nbr Dist Alloc Date Allocation Adjustments Allocation Disbursements Encumbrance Available Advance Amt Trans Dt Status 013 623 005 5 02 21 2002 145 730 23 1 423 759 00 1 569 479 23 403 237 99 000 1 166 241 24 0 00 04 06 2009 PARTIAL 019 650 005 5 04 17 2007 1 290 000 00 0 00 1 290 000 00 1 225 500 00 64 500 00 0 00 0 00 12 18 2007 PARTIAL 019 656 004 5 02 08 2005 78 840 00 4 704 842 00 4 783 682 00 2 668 060 70 2 115 621 30 0 00 0 00 08 21 2008 PARTIAL 019 656 005 5 02 08 2005 164 883 00 4 173 062 00 4 337 945 00 717 945 00 0 00 3 620 000 00 0 00 08 03 2006 PARTIAL 019 656 006 5 02 08 2005 68 373 00 0 00 68 373 00 68 373 00 3 620 000 00 3 620 000 00 0 00 08 14 2008 PARTIAL 019 656 007 5 02 27 2006 3 534 000 00 0 00 3 534 000 00 0 00 3 534 000 00 0 00 0 00 08 13 2008 PARTIAL 027 701 005 5 02 08 2000 138 000 00 229 025 87 367 025 87 338 455 07 0 00 28 570 80 0 00 04 11 2003 PARTIAL 027 701 007 5 05 30 2000 292 000 00 591 400 62 883 400 62 883 400 62 0 00 0 00 0 00 06 28 2006 PARTIAL 027 701 010 5 11 10 2003 575 000 00 8 480 000 00 9 055 000 00 9 055 000 00 0 00 0 00 0 00 11 07 2007 PARTIAL 027 701 0017 5 06 06 2006 500 000 00 0 00 500 000 00 478 058 29 0 00 21 941 71 0 00 06 06 2006 PARTIAL 027 701 018 5 10 19 2006 100 000 00 0 00 100 000 00 0 00 160 000 00
58. SAE Page 97 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Agreement Payment Request Appearance Minnesota Department of Transportation Office of Finance Page 1 of 3 State Aid Agreement Payment Request Municipality OTHER STATE AGENCIES Agreement Type PRELIM ENG State Aid Project Number 099 999 009 Agreement Nbr 99999 Federal Project Number MNOS 010 Pay Request Nbr 3 Local Project Number Work Certified Through 01 19 2010 REQUEST FOR PARTIAL PAYMENT OF FEDERAL FUNDS This is to certifify that the costs for the above agreement have been incurred for the total costs due based on the information summarized below hereby request reimbursement of the following amounts Federal 0 00 Remarks Work Certified Summary Cat ff Total Cert Amt 1 200 000 00 p Masini 200 000 00 Approved T s Date Phone Approved m Date DSAE Approved ee Date SALT John Smith 1 19 2010 Phone 651 999 9999 Prepared by Date Enclosed Backup Documents Mail to District State Aid Engineer Report ID FCREPaymentRequestAgr v20100113 Print Date 1 19 2010 8 08 53AM Page 98 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Agreement Payment Request Appearance Minne
59. Summary cesses 30 Expenditure Detail by Co Muni amp Control Section Number ceeessssssseee 33 Local Bridge Project Expenditure Obligation Report Summary esses 35 BIDS NER TR 39 Payment Document Final Maintenance esses essere essen 41 Payment Document Construction eeeeessssseeeeee esee eene essen esn nnne eser ness nnne nenas 43 E5717 172 11S 1791 9129012 PROPRII ETT 45 401129 9247110 PRETI 47 Project Allocation 306b OH Vues EVI REIN SR EN NEENIN SRI INVI MIR MIS 49 FOC i SLOT you vic teas Visum E iste MUR stacey IUNII P MEM UNE 51 o MT XP HR E 54 FEDERAL AID PROJECTS AND AGREEMENT REPORTS e 39 Lncambrance Open ProjeCiS eadseetasss e Tedcts e Middbyeb die oan et Fes ERO da URS eMe dcus Eae bou Meme n Bee REUS 61 IU 7021 9018 A OCIS ais car scare sage ECCE 63 LARD eg 0 LG qun ECC eee E T E ER Se ee nC on ee ene ey eee UIS 65 Last Voucher Input by Local Government eese eene 69 Ledger by Card Summary eeeeeeeeisssssseeeeeeeeeee sese essenn nnne ess se nan n renes sena 70 PONTO VICI 73 Payment Shortages Federal Advance Construction AC eee 79 Page 2 State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Table of Contents S7 LULA VOI RR HR RT
60. T Ist character Partial or Final 2nd character Payment or Transfer 3rd character Payment Number Report ID FrojHist v20090420 Print Date 4 21 2009 2 1 7 09PM Page 52 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project History Report Drill Down Drill Down Drill Down on Obligations Preview Obligations Report ID PRJHIST State of Minnesota Run Date 11 01 2002 Department of Transportation Project History Report Obligations Project 045 617 006 Payment 2 Account 70 CO REG CONST ssoc Funding Ob lig Percent Acct Description irati to be Paid pproved mt 70 CO REG CONST CONSTRUCTION 261 006 78 261 006 78 Total 261 006 78 261 006 78 Drill down on Overpayment Applied Preview Obligations Overpayments Applied Report ID PRJHIST State of Minnesota Run Date 11 01 2002 Department of Transportation Project History Report Overpayments Applied Project 045 617 006 Payment 2 Account 70 CO REG CONST Date Applied Overpayment From Overpayment Amt Overpayment Total Page 53 Return to Table of Contents Status Purpose Audience Screen State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Status Report To display the status of a county or municipality s State Aid Regular Special or Bridge Bonding accounts In addition users wi
61. TOOD CO 2006 290 0000 12 06 0 2011 5009 144 598 60 0 00 700 000 00 200 000 00 500 000 00 251 BOND FLOOD 2007 2008 290 0000 895 12 31 2012 5004 564 026 50 86 013 35 26 000 000 00 2 193 861 18 23 806 138 82 252 BRIDGE BONDING 2008 290 0000 12U 12 31 2012 5004 6 413 771 15 3 144 022 40 50 000 000 00 17 328 605 97 32 671 394 03 253 LRIP SAFETY 2008 290 0000 12V 12 31 2012 5004 221 637 10 3 216 297 14 10 000 000 00 3 437 934 24 6 562 065 76 254 BB RMSY RICE ST 2008 290 0000 14G 12 31 2012 5004 0 00 338 306 00 2 00 000 00 338 306 00 1 661 694 00 Total 11 446 068 18 11 958 088 76 285 757 670 02 218 607 062 64 67 150 607 38 This report uses tables BRIDGE BONDING IA APPROPRIATION Report ID BrdeBondSummary 20080623 Print Date 4 21 2009 9 50 12AM Page 32 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Disbursement Detail by Co Muni amp Control Section Number Expenditure Detail by Co Muni amp Control Section Number Purpose To display expenditure information by county muni or district and control number by all or selected account within a selected date range Audience All users Screen This is the entry screen Select the County Muni Number or District and Control Section Number Account and From To Dates from the drop down lists Click View Report SAAS Web Reporting Functional Business View Gounty and Municip
62. UNICIPALITY BIG LAKE Account 91 MUNI TURNBACK E MUNICIPALITY BLAINE Reg Yr Pal Allocation Total Deposits Transfers Lisb Unexp Bal En BL Rav Pal Avail MUNICIPALITY BLOOMIN 000 000 000 000 0 00 000 000 0 00 000 000 MUNICIPALITY BRAINER 000 MUNICIPALITY BROOKLY E MUNICIPALITY BROOKLY Account 94 MUNI MAINT A MUNICIPALITY BUFFAL PBegYrFal Allocation Tial Deposits Transfers Disb UnexpRal Em E LRsv Bal Avail aR RAT ans 000 135 030 00 135 030 00 000 000 135003000 000 000 000 000 MUNICIPALITY CAMBRIC om Size allows you to select the report to display in larger or smaller font such as the difference between viewing the appearance of an entire page verses easily reading the text cn oe 4 Arrowhead with vertical bar takes you to the beginning end of the report If the arrow is pointing to a bar on the left of the arrow it takes you to the first page of the report if the arrow is pointing to a bar on the right of the arrow it takes you to the last page of the report Page 9 Return to Table of Contents March 2010 of i State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual Navigation Arrowhead without bar takes you to the previous next page of the report If the arrow faces left it takes you to the previous page an arrow facing right takes you to the next page of the report Page of Pages tells
63. ality Reports SAAS Expenditure Detail By Go Muni amp Control Section Number cofmuni Ja 0 0 M AQR District Control Section Number Select Multiple Control Section Numbers by pressing and holding the Ctrl key Log out of system Page 33 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Minnesota Department of Transportation Office of Finance SAAS Disbursement Detail By Co Muni Co Muni ALL Control Section Number ALL Account ALL 4 1 2009 through 4 21 2009 Partial Payment Project Number Final Transfer Description Trans Date Enc Amt ACCOUNT 70 CO REG CONST AITKIN 001 638 003 F P CONST 04 07 2009 31 767 17 Project Total 3176717 County Total CARVER 010 610 030 P P CONST 04 01 2009 59 365 55 010 610 030 P P ENG 04 01 2009 0 00 010 610 030 E P ROW 04 01 2009 0 00 Project Total 59 365 55 County Total CROW WING 018 603 019 F P CONST 04 09 2009 4 016 12 Project Total 4 016 12 County Total HENNEPIN 027 603 027 F P CONST 04 01 2009 123 725 58 027 603 027 F P ROW 04 01 2009 0 00 Project Total 123 725 58 027 661 027 F P CONST 04 01 2009 19 168 49 Project Total 19 168 49 County Total OTTER TAIL 056 667 030 F P CONST 04 06 2009 65 508 38 056 667 030 F P ENG 04 06 2009 0 00 056 667 030 F P ROW 04 06 2009 0 00 Project Total 65 508 38 056 686 001 F P CONST 04 06 2009 33 020 34 056 686 001 F P ENG 04 06 2009 0
64. ar Municipal Annual Expenditure Report Amount 0 00 0 00 Annual Allocation 3 714 215 00 198 867 00 Eligible maintenance amount 0 00 0 00 Lesser of the Expenditure Report or Annual Allocation Less Previous payments 1 789 670 62 99 433 50 Previous bond interest 134 873 75 0 00 Previous overpay ments 0 00 0 00 Payment Amount 1 789 670 63 99 433 50 Total Overpayment 0 00 0 00 Amount to be applied to future construction projects Amount transferred to construction 0 00 0 00 Local Participation 0 00 0 00 Comments cc FRED EDSTROM Page 42 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 State Aid Payment Document Construction Payment Document Construction Purpose Payment document used to display specific details related to a construction project payment Audience All users Screen This is the entry screen Enter the Project Number and then click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Payment Document Gonstruction Project Number Log out of system There are no drill downs for this report The next page displays the appearance of the report Page 43 Return to Table of Contents March 2010 QU ESO A q gt m 2 e Customer State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual Off
65. ate Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Summary Payment Summary Purpose Display summarized payment information for the selected project Audience All users Screen This is the entry screen Enter the Project Number and then click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports FCRB Payment Summary Enter Project Number to view or click Lookup to search Project Number Lookup EE B View Report Log out of system Page 81 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Summary Appearance Page of Minnesota Department of Transportation Office of Finance j FCRB Payment Summary County HENNEPIN MAPS Contract Nbr A9755 State Aid Project Number 027 753 010 Project Type DCP Federal Project Number 2703 195 Through Pay Request Nbr 5 Orig Paying Acct Acct Total Net Prev Net Net Cert Cat Priority SP Acct Acct Desc AC Pet Cert Amt Cert to Dt this Voucher Paymt Amt 1 4 027 753 010 236 236 BRIDGE BONDING 20 00 388 196 00 388 196 00 0 00 0 00 1 027 753 010 70 70 COREG CONST 20 00 9 627 43 1 670 96 7 956 47 0 00 2 1 027 753 010 70 70 COREG CONST 100 00 474 179 39 456 123 24 18 056 15 0 00 Total for Account 70 SA COUNTY REGULAR CONST 483 806 82 457 794
66. ax Email Cost System Phone Fax Email Cost System Phone Fax Email Cost System Phone Fax Email Cost System Phone Fax Email Cost System Phone Fax Email Page 108 Accountant List Appearance Page 1 of 13 ACS 218 927 3741 218 927 2356 sblackledge co aitkin mn us ACS 463 323 5518 763 323 5418 fred edstrom co anoka mn us ACS 218 847 4463 218 846 2360 kmkilda co becker mn us Task Force Alternate ACS 218 759 8175 218 759 4820 dolores wiggins co beltrami mn us ACS 320 968 5169 320 968 5329 mdillenb co benton mn us Costrite 320 839 2594 320 839 3747 smillerbernd co big stone mn us ACS 920 304 4025 907 304 4049 karen langford co blue earth mn us ACS 907 233 5700 2D 354 685 f tammy furthico brown mn us Print Date 3 15 2010 7 09 25 AMI Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force E Mail Task Force E Mail Purpose View Task Force E Mail addresses sorted by representatives and alternates Audience All users Screen This is the entry screen There is no selection criteria you may highlight and copy list into e mail click View Report to print the list SAAS Web Reporting Functional Business View Accountant Task Force Address Reports State Aid Accounting Task Force E Mail Task Force Represen
67. elegated Contract Process DCP Payment Request Appearance Minnesota Department of Transportation Office of Finance Page 2 of 5 Delegated Contract Process Payment Request County SAMPLE Project Type DCP State Aid Project Number 099 999 099 MAPS Contract Nbr AH174 Federal Project Number 0607 098 Pay Request Nbr 3 Local Project Number Work Certified Through 03 31 2008 Payment Detail by Category Damage Total Net Cat 4 Par Amt Non Par Amt Total Cert Amt Retainage Incentive Cert Arnt 1 655 218 33 0 00 655 218 33 32 760 92 0 00 622 457 41 Orig Paying ree Total Net Prev Net Net Cert Priority SP Acct Acct AC Cert Amt Cert to Dt this Voucher Paymt Amt 1 099 999 099 L110 L110 80 00 497 965 93 264 572 11 200 393 82 233 393 82 1 099 999 099 245 245 20 00 124 491 48 66 143 03 58 348 45 58 348 45 2 099 999 099 245 2435 OR 100 00 0 00 0 00 0 00 0 00 3 099 999 099 F Z OR 100 00 0 00 0 00 0 00 0 00 Total for Cat i Senos CER 622 457 41 330 715 14 291 742 27 291 742 27 2 0 00 180 000 00 180 000 00 9 000 00 0 00 171 000 00 Orig Paying ges Total Met Prev Net Net Cert Priority sP Acct Acct AC Cert Amt Cert to Dt this Voucher Paymt Amt 1 089 999 099 70 70 100 00 171 000 00 171 000 00 0 00 0 00 Total for Cat 171 000 00 171 000 00 0 00 0 00 3 0 00 68 222 17 68 222 17 3 411 11 0 00 64 811 06 Orig Paying ES Total Met Prev Net Net Cert Priority SP Acct Acct Ac Cert Amt Cert to Dt this Vo
68. errun Current Cat Amt Limit Amt Ind Ind Ind Ind 1 r 099 999 099 0607 098 144829 100 00 N N N N 180 000 0000 180 000 00 Total 180 000 00 Report ID FCRBProjectSetup v20090115 Print Date 4 20 2009 10 31 49AM Page 86 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Setup Appearance Page 3 of 4 Minnesota Department of Transportation Office of Finance FCRB Project Setup 3 0 00 100 00 107 199 00 107 199 00 Priority Acct Nbr SPH FF Job Nbr Pct Part Fund300 Cap Overrun Current Cat Amt Limit Amt Ind Ind Ind Ind 1 ro 099 999 099 0607 088 T44829 100 00 N N N N 107 199 0000 107 199 00 Total 107 199 00 Category Amounts by Account Federal Acet Nbr Acct Desc AC CatNbr Priority Total Cat Amt L110 BRIDGE PROGRAM 1596 OFF 1 1 393 400 0000 593 400 00 Federal Total 593 400 00 Category Amounts by Account Non Federal Acct Nor Acct Desc Cat Nbr Total Cat Amt 245 BB 2006 290 0000 807 1 148 350 0000 245 BB 2006 290 0000 807 1 900 949 7500 1 049 299 75 70 SA COUNTY REGULAR CONST 1 30 0000 70 SA COUNTY REGULAR CONST 2 180 000 0000 r SA COUNTY REGULAR CONST 3 107 199 0000 287 199 00 Non Federal Total 1 336 498 75 Grand Total 1 929 898 75 Report ID FCRBProjectSetup v200901 15 Print Date 4 20 2009 10 31 49AM Page 87 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation S
69. ests SAAS Reports Windows Internet Explorer o 3 CB to lidotapp dok stake mn us SAAS saas P eports asp Double click on any of the four menu selections 7 v X Fie Ede View Favortes Took Hebb WS jum 5 Sh Pit Pee D Took Mh reo SAAS Web Reporting Functional Business View Reports Payments and Project Number Requests State Aid County and Municipality Reports Federal Aid Projects and Agreement Reports Delegated Contract Process DCP Payment Request Federal Aid Agreement Payment Request State Aid Project Number Request Accountant Task Force Address Reports Log out of system State Aid County and Municipality Reports see page 11 Federal Aid Projects and Agreement Reports see page 59 Delegated Contract Process DCP Payment Request see page 89 Federal Aid Agreement Payment Request see page 96 State Aid Project Number Request see page 101 Accountant Task Force Address Reports see page 103 Page 8 Navigation Lc x pan L m Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Navigation Toolbar x amp amp st s of t Pb de 5 Preview The toolbar has several icons to aid in navigation of the reports X closes the screen x Printer the print function It brings up the Print Dialog box where you can specify a range of pages or
70. f Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Final Projects Final Projects Purpose Displays finaled Federal Projects within the date range selected finaled projects are sorted by DCP and Traditional Audience All users Screen This is the entry screen Enter the All or District Number From Date To Date and then click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports amp Payment Request FCRB Final Projects District coui jut 0 0 0 0 0 wj From Date January i 01 iv Log out of system Page 65 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Final Projects Appearance Minnesota Department of Transportation Office of Finance Page 1 of 3 FCRB Final Projects District ALL Projects Finaled from 01 01 2009 to 04 21 2009 Project DCP MAES E Work Compl Last MnDOT T Nbr AS Letting Dt Award Dt Local pee nene Federal Other Total ThroughDt TrancDt Final 001 608 005 0106 122 AH340 06 18 2007 07 10 2007 0 00 453 415 59 0 00 600 000 00 0 00 1 053 415 59 08 15 2008 02 23 2009 003 639 011 0308 151 FF247 04 30 2008 05 13 2008 0 00 363 100 30 0 00 880 978 00 0 00 1 244 078 30 09 08 2008 03 16 2009 006 630 003 0607 098 AH174 07 03 2007 0 00 315 645 56 1 049 29
71. f Transportation Inquire on Outstanding Overpayments for 2002 County 001 AITKIN ccount 70 CO REG CONST as of 10 31 2002 Deposits Orgine Outstending Overpayment From Outstend ing To Be App lied i kn to App ir 001 103 006 10 50 2002 3 000 00 7 000 00 7 000 00 Page 57 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Status Report Drill Down Drill down on Acct to Acct Advances Preview Annual Allocations Deposits Transfers Disbursements Encumbrances Overpayments General Fund amp dvances Account to Account Advances Report ID Acct2AcctAdy State of Minnesota Ram Date 10 31 2002 Department of Transportation Inquire on Account to Account Advances for 2002 County 001 AITKIN Account 70 COREG CONST 1 1 2002 10 31 2002 Project Nunber Advance To Account Total Advarce Outstanding Advances Total Page 58 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Projects and Agreement Reports FEDERAL AID PROJECTS AND AGREEMENT Financtat Reports Windows Internet Explorer G pv Qntpodidesoo dot eske mo us SAASIF CRB ce lO ReportsMul aspi olderIDa 5799646 Fie Edt Yew Favokes Toos Help We Be me c GD rem o dtr i Page Gp Took Gray SAAS Web Reporting Functional Business View Fede
72. her accordance with the Mn DOT Schedule of Materials Contra inspection on the federal aid and state funded State Aid Payment Request if applicable portions of this project was performed by personnel certified in accordance with state aid directives the work Gvenrun Jusifficallen required by this contract was completed in accordance with and pursuant to the terms of this contract and ie payment and performance bonds for the full amount of the contract have been provided with aggregate liability Materials Certification Exception Summary of the bond s to twice the full amount of the contract Certificate of Performance Approved Date Phone 955 555 5555 Final Inspection Report TOM ENGINEER County Engineer Certificate of Final Acceptance Recommended for Approval _ EN Date Supplemental Agreements District State Aid Engineer Change Orders Mail to District State Aid Engineer Note OR Overrun Account Report ID FCRBPaymentRequest v20080528 Print Date 4 20 2000 3 28 03PM Page 95 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Agreement Payment Request FEDERAL AID AGREEMENT PAYMENT REQUEST Purpose Process and print Federal Aid Agreement Payment Request in lieu of Sample Cover Letter used in the past Used to request Preliminary Engineering PE Force Account FA Construction Engineering CE and Right of Way ROW Agree
73. ice of Finance MAIL STOP 215 395 JOHN IRELAND BLVD ST PAUL MN 55155 1899 State Aid Payment Document Construction Appearance 4 4 Minnesota Department of Transportation Phone 651 366 4854 Fax 651 366 4909 E mail JOHN FOX QDOT STATE MN US STATE AID PAYMENT DOCUMENT MARSHALL COUNTY LON AUNE 447 S MAIN ST WARREN MN 56762 1423 Account Payment Type Transaction Type Payment Number Project Type Transaction Date Payment Amount Encumbrance CONST 70 CO REG CONST FINAL PAYMENT 3 SAP 08 15 1991 15 753 86 0 00 State Aid Project Number 045 61 7 006 Federal Project Number CFDA Number Local Agency Project Number Contractor Name Construction Obligation Summary CO REG CONST 261 006 78 Project Payment Summary Less Previous Payments Total Due Payment Amount Converted 20021115 10096 261 006 78 245 252 92 15 753 86 15 753 86 Page 44 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Shortages Payment Shortages Purpose Used to display State Aid Projects that have been paid short due to lack of available funds in allocation Audience All users Screen This is the entry screen Enter the Co Muni and then click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Payment Shortages comuni Ja 0 M Log
74. innesota Department of Transportation SAASY Reports Users Manual March 2010 Delegated Contract Process DCP Payment Request Appearance If the Final Voucher is checked the first page of the report will appear as shown Minnesota Department of Transportation Office of Finance Page 1 of 5 Delegated Contract Process Payment Request County SAMPLE Project Type DCP State Aid Project Number 999 999 099 MAPS Contract Nbr AH174 Federal Project Number 0607 098 Pay Request Nbr 6 FINAL Local Project Number Work Certified Through 04 20 2009 REQUEST FOR FINAL PAYMENT OF FEDERAL amp BRIDGE BONDING MISC APPROP FUNDS This is ta certifify that the costs for the above contract have been incurred for work performed by the contractor for the total construction costs due based on the information summarized below hereby request reimbursement of the following amounts Federal 0 00 Bridge Bonding 0 00 Remarks Work Certified Summary Retainage Pct 0 00 Retainage Amt 0 00 Damage Incentive Amt 0 00 Cat ff Total Cert Amt 1 850 748 56 180 000 00 127 598 75 1 958 345 31 hereby certify that wage rates specified in the project contract equal or exceed the minimum hourly rates required for work on federal funded construction projects as determined by the MM Dept of Labor and Industry Required Docs materials used in the federal aid and state funded portions of this project were sampled and tested in Final Estimated Vouc
75. ion Office of Finance SAAS Bridge Bonding amp Other State Bonding Programs as of 04 20 2009 District ALL County ALL Account ALL Project Project Acct Acct Original Bid Open Original Net Nel Reserved for Proj Number Type Nbr Desc Alloc Date Date Allocation Adjustments Allocation Disbursements Avail for Pymt Project Status 001 626 006 SAP 245 BRIDGE BONDING 04 08 2008 08 19 2008 42 222 50 15 896 75 58 119 25 0 00 58 119 25 0 00 001 632 003 SAP 245 BRIDGE BONDING 4 08 2008 06 10 2008 135 901 00 0 00 135 901 00 129 105 95 6 795 05 0 00 002 649 001 SAP 242 BRIDGE BONDING 04 17 2006 06 06 2006 425 000 00 425 000 00 0 00 0 00 0 00 0 00 004 598 015 SAP 252 BRIDGE BONDING 05 01 2008 253 153 00 000 252 153 00 Q0 LR 252 153 00 004 598 017 SAP 252 BRIDGE BONDING 05 01 2008 285 935 00 0 00 285 935 00 0 00 0 00 285 935 00 005 598 002 SAP 252 BRIDGE BONDING 08 12 2008 88 010 00 0 00 88 010 00 0 00 0 00 88 010 00 005 604 021 SAP 245 BRIDGE BONDING 04 08 2008 05 02 2008 S483 50 UU 8 483 50 ih Le HI e 43 50 005 605 008 SAP 244 LRIP SAFETY 09 16 2005 10 14 2005 139 000 00 139 000 00 0 00 0 00 0 00 0 00 005 605 011 SAP 244 LRIP SAFETY 0907 2005 10 14 2005 139 000 00 139 000 00 135 000 040 Oo 0 00 006 598 002 SAP 252 BRIDGE BONDING 10 07 2008 09 02 2008 76 540 00 0 00 76 540 00 0 00 76 540 00 0 00 007 030 002 SP 250 LRIP TOOD CO 03 10 2008 200 000 00 200 000 00 0 00 0 00 0 00 0 00 007 597 001 SAP 245 BRIDGE BONDING 04 26 2008 10 21 2008 1
76. ion accounts Uses To determine what funds have been encumbered To identify the unexpended balance available to encumber to counties and municipalities Audience All users Screen This is the entry screen Select the Account and Reporting Year Month from the drop down lists Note that reports cannot be run for a reporting month prior to the listed date Click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Bridge Bonding amp Other State Bonding Programs Acct Only Account ALL Reporting Year Month i This repart can nat be run for a reporting month prior to 11 2002 Log out of system The next page displays the appearance of the report Page 28 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bridge Bonding amp Other State Bonding Programs Acct Only Appearance Page 68 of 94 Minnesota Department of Transportation Office of Finance SAAS Bridge Bonding amp Other State Bonding Programs Acct Only Account ALL as of 04 20 2009 Account 245 BRIDGE BONDING Fiscal Year 2006 Fund 290 Approp Org 0000 Approp Unit 807 Exp Budget Org 5004 Allocation 52 500 000 00 Less Net Allocated 51 703 955 20 Balance Available to Allocate 796 044 80 Project Project Original Bid Opening Original Net Reserved for Proj Number Type Alloc Date Date Allocation Adjust
77. ity Reports FCRB Payment Detail Enter Co Muni Number press tab to refresh Selecting a tied project will automatically display the main project Co Muni Number Project Humber 099 999 009 Contract wt voucher Number Select One view Report Log out of system Page 73 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Detail SAAS Web Reporting Functional Business View FCRB County and Municipality Reports FCRB Payment Detail Enter Co Muni Number press tab to refresh Selecting a tied project will automatically display the main project Co Muni Number Project Number 099 999 009 Contract v Voucher Number Select One View Report Log out of system SAAS Web Reporting Functional Business View FCRB County and Municipality Reports FCRB Payment Detail Enter Co Muni Number press tab to refresh Selecting a tied project will automatically display the main project Co Muni Number Project Number vaucher Number Select One Account Category Fund 300 Project Log out of system The next 4 pages display the appearance of the report Page 74 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Detail Appearance Minnesota Department of Transportation Office of Finance Page
78. justments Allocation Disbursements Encumbrance Available Advance Amt Trans Dt Status 001 001 016 7 3 12 18 2003 37 231 23 37 231 23 0 00 0 00 0 00 0 00 0 00 01 07 2004 PARTIAL 001 599 031 75 3 03 25 2009 52 735 00 15 000 00 67 735 00 0 00 67 735 00 0 00 0 00 04 07 2009 PARTIAL 001 599 032 13 3 04 08 2008 296 253 50 20 976 58 31 7 230 08 0 00 317 230 08 0 00 0 00 04 08 2008 PARTIAL 001 600 014 Ta 3 07 13 2006 75 000 00 15 684 00 90 084 00 85 778 04 4 905 96 0 00 0 00 12 12 2008 PARTIAL 001 614 009 73 3 11 17 2002 4 750 00 4 750 00 0 00 0 00 0 00 0 00 0 00 NO OBLIG 001 599 020 75 3 11 16 2002 1 00 1 819 00 1 820 00 1 520 00 0 00 0 00 0 00 03 12 2004 FINAL 001 599 071 75 3 ie i 8 098 05 3 957 57 4 741 08 4 741 08 0 00 0 00 0 00 12 18 2003 FINAL 001 599 022 75 3 12 23 2003 131 839 85 0 00 131 839 85 131 839 85 0 00 0 00 0 00 03 16 2005 FINAL 001 599 025 75 3 11 16 2002 30 513 35 22 292 52 6 220 83 6 220 83 0 00 0 00 0 00 03 12 2004 FINAL 001 599 026 75 3 12 07 2005 22 383 25 0 00 22 383 25 22 383 25 0 00 0 00 0 00 12 07 2005 FINAL 001 599 029 75 3 07 14 2006 251 037 63 25 012 01 226 025 62 226 025 62 0 00 0 00 0 00 08 08 2008 FINAL 001 599 036 75 3 QT7 03 2008 18 027 00 932 06 17 094 34 17 094 34 0 00 0 00 0 00 11 03 2008 FINAL 001 600 012 73 3 11 17 2002 53 500 00 36 092 80 89 592 80 89 502 80 0 00 0 00 0 00 05 02 2005 FINAL 001 614 010 73 3 11 18 2002 4 750 00 0 00 4 750 00 4 750 00 0 00 0 00 000 0312 2003 FINAL Total 986 720 46 46036
79. ll have the capability to drill down into transaction detail for any transaction type re allocations deposits transfers disbursements encumbrances bond loan reserves outstanding overpayments general fund advances and outstanding account to account advances All users ScreenThis is the entry screen Select the Co Muni the Sort Order and the Reporting Year Month from the drop down lists Note that reports are not available prior to the listed date Click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Status coun a M Sort Order Reporting Year Month This repart can nat be run far a reporting month prior to 11 2002 Log out of system Drill down capacity is demonstrated on the pages following the screen shot of the report Drill downs for further information are available for those amounts where the information is formatted in color Page 54 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Status Report Appearance Page 1 of 2 Minnesota Department of Transportation Office of Finance SAAS Status Report County 001 ATTKIN as of 04 20 2049 County 001 AITKIN Account 70 CO REG CONST Outstanding State Aid Acct to Acct Beg Yr Bal Allocation Total Deposits Transfers Disb Unexp Bal Enc BL Rsrv Bal Avail Overpymts Avail to Adv Advances 253 212 24 2 062
80. ments Audience All users Screen This is the entry screen Enter the County Municipal Number press the Tab Key or click the Project Number select the Project Number then click View Report SAAS Web Reporting Functional Business View Federal Aid Agreement Payment Request Enter Co Muni Number press tab to refresh Co Muni Number 099 Project Number Mext Log out of system Page 96 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Agreement Payment Request Enter Prepared By Phone Number Pay Request the date the Work Completed Through Date Final Voucher click check box if this is the Final Voucher Remarks optional and the Certified To Dt Amt for each category this is total Work Certified to Date then press View Report SAAS Web Reporting State Aid Agreement Payment Request Project Number 099 999 009 Agreement Number 91096 Prepared By fs First Last Phone Number Lp d Pay Request Last Pay Request 13 Work Completed Through Date 19 vw Final Voucher C Remarks o Enter all certified amounts including zero dollars Previous Certified To Dt Amt 575 163 61 575 163 61 Back to the menu The next 3 pages display the appearance of the report Submit the first page along with your supporting documentation for payment to your District State Aid Engineer D
81. ments Allocation Disbursements Avail for Pymt Project Status 067 599 133 SP 06 08 2006 07 11 2006 93 290 50 15 708 50 77 582 00 15 466 84 62 115 16 0 00 067 599 134 SP 04 10 2007 06 01 2007 147 879 40 147 879 40 0 00 0 00 0 00 0 00 069 597 004 SAP 06 13 2006 127 947 00 0 00 127 947 00 0 00 0 00 127 947 00 070 606 010 SAP 06 03 2008 76 811 63 0 00 76 811 63 6 00 0 00 76 811 63 070 615 010 SAP 06 13 2006 08 29 2006 96 132 50 5 291 14 101 423 64 99 423 64 756 57 1 243 43 070 61 5 011 SAP 07 18 2006 08 29 2006 268 295 00 57 113 08 211 181 92 207 646 32 0 00 3 535 60 070 623 008 SAP 07 18 2006 08 29 2006 187 790 00 2 135 28 185 654 72 183 641 72 0 00 2 013 00 071 598 005 SAP 02 19 2008 370 377 50 11 179 50 381 557 00 0 00 381 557 00 o 00 072 605 0016 SP 06 03 2008 01 15 2004 32 62 0 00 32 62 6 00 0 00 32 62 074 645 012 SAP 03 21 2007 40 297 37 40 297 37 6 00 0 00 0 00 0 00 077 611 031 SP 05 18 2007 05 06 2007 78 265 50 8 668 50 69 597 00 69 597 00 0 00 0 00 079 898 011 SAP 10 26 2006 01 25 1994 46 417 50 46 417 50 0 00 0 00 0 00 0 00 081 613 006 SAP 04 10 2007 05 04 2007 89 742 00 9 814 12 99 556 12 99 556 12 0 00 0 00 082 618 008 SAP 05 18 2007 04 22 2008 526 458 00 58 821 20 85 279 20 562 29 56 22 986 64 0 00 082 638 0013 SAP 05 21 2007 05 17 2007 300 000 00 0 00 300 000 00 119 085 27 180 914 73 0 00 083 601 010 SP 05 18 2007 06 26 2007 71 074 80 7 095 22 63 979 58 63 049 50 930 08 0 00 085 607 009 SAP 03 17 2009 553 636 50 0 00 853 636 50 0
82. nd Interest Due Year Requested Bond Type View Report Log out of system There are no drill downs for this report The next page displays the appearance of the report Page 24 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bond Principal and Interest Due Appearance Page 3 of 5 Minnesota Department of Transportation Office of Finance SAAS Bond Principal and Interest Due for 2009 for Bond Type STATE AID County Issue Dt Principal Amt Interest Amt P amp I Amt ANOKA 05 18 1999 730 000 00 16 790 00 746 790 00 03 01 2001 510 000 00 65 855 00 575 855 00 ANOKA Total 1 240 000 00 82 645 00 1 322 645 00 BENTON 06 07 2007 110 000 00 71 520 00 181 520 00 CHISAGO 03 30 2004 400 000 00 63 993 76 463 993 76 06 13 2007 345 000 00 135 755 00 480 755 00 CHISAGO Total 745 000 00 199 748 76 944 748 76 KANDIYOHI 01 01 1999 235 000 00 59 915 63 294 915 63 LAKE 09 01 2005 455 000 00 62 335 00 517 335 00 LESUEUR 05 01 2003 265 000 00 48 163 75 313 163 75 04 01 2005 265 000 00 65 587 50 330 587 50 LESUEUR Total 530 000 00 113 751 25 643 751 25 MEEKER 09 18 2008 600 000 00 41 334 17 641 334 17 NICOLLET 01 01 2002 200 000 00 49 557 50 249 557 50 POLK 03 18 2008 800 000 00 108 400 00 908 400 00 RAMSEY 12 01 2002 130 000 00 172 330 00 302 330 00 WASECA 09 06 2007 65 000 00 46 051 25 111 051 25 All County Total 5 110 000 00 1 007 588 56 6 117 588 56 Re
83. o MN 55313 Phone No 63 682 385 Fax No 763 682 7313 Appointment Date 10 01 2007 Term Expiration Date 09 30 2008 Bette Schweer Yellow Medicine B bette schweertoco yellow rmedicine rmn us 1320 13th St Granite Falls MN 56241 1286 Phone No 320 564 3331 Fax No 320 564 21 40 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Report ID TaskForceList v20100302 Print Date 3 15 2010 7 46 12 AM Page 115 Return to Table of Contents
84. od A annual allocation process Payment Shortages To display State Aid Projects that have been paid short due to lack of available funds in allocation Project Allocation Acct Only To display information regarding county and municipal project allocations by account ject History To provide a detailed history al all transactions for a specific project Page 12 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 State Aid County and Municipality Reports REPORT PURPOSE Page 13 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Advance CSAH amp MSAS Funds Advance CSAH amp MSAS Funds Purpose To display information regarding general fund advances for all accounts General Fund advances are advances from the unexpended county or municipal state aid balance that may be borrowed by counties or municipalities Audience All users Screen This is the entry screen Select the Reporting Year Month from the drop down lists Note that reports cannot be run for a reporting month prior to the listed date Click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Advance CSAH amp MSAS Funds Current Advance Code Levels Click Colored Button for more Info CITIES COUNTIES GUARDED GUA
85. of Transportation SAASY Reports Users Manual March 2010 Payment Shortages Federal Advance Construction AC Payment Shortages Federal Advance Construction AC Purpose Display total payment shortage for Federal Advance Construction AC Audience All users Screen This is the entry screen There are no selection parameters for this report click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports FCRB Payment Shortages Federal Advance Construction AC This report does not have any parameters Log out of system Page 79 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Shortages Federal Advance Construction AC Appearance Page of Minnesota Department of Transportation Office of Finance FCRB Payment Shortages Federal Advance Construction AC Federal S P Nbr Project GFS Nbr Acct Nbr Paymt Amt 007 682 006 5225 O01 AF492 03 R LY20 374 607 00 045 604 023 4500 229 FF678 Ol C L240 380 000 00 057 603 032 S710 06 FFI59 OL C L250 152 953 32 073 00 045 H131 i04 AH354 03 C L200 1 142 445 45 144 135 011 H128 O0 e354 04 C HO20 1 712 828 00 eee 3 762 866 77 This report uses tables FCRB CARD FCRB_ PROJ SETUP FCRB ACCT FED Report ID FCRBPaymtShartage AC yv20090515 Print Date 12 8 2009 6 17 09AM Page 80 Return to Table of Contents St
86. of system Page 11 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 State Aid County and Municipality Reports Summary Table The available State Aid County and Municipality Reports are summarized below including their purpose REPORT PURPOSE To display information regarding general fund advances for all accounts State Aid Fund advances Advance CSAH amp MSAS Funds are advances from the unexpended county or municipal state aid balance that may be borrowed by counties or municipalities To identify open projects sorted by Bid OpeningDate or Project Number may select by year type district and Co Muni Bond Applied Projects To identify projects applied to bonds may select by Co Muni Bond Type and year month Bond Loan Schedule duse sd Payment Schedule of interest and principal may select by Co Muni Bond Type and Displays Bond principal and interest due in a given year This information is used to determine minimum allocations Bond Principal amp Interest Due To display information regarding Bridge Bonding and Other State Bonding Programs appropriation l Bridge Bonding amp Other State accounts This report is used to determine what funds have been encumbered and to identify the Bonding Programs unexpended balance available to encumber to counties and municipalities Bridge Bonding amp Other State Bonding
87. okup to search Project Number Lookup a NEN Log out of system Page 83 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Setup Screen If you do not know the Project Number press Lookup Financial Web Reporting Project Lookup Enter any known field and click Next to search Co Muni Number Federal Praject Number EE Agreement Number Enter your County or Municipal Number then press Next Financial Web Reporting lick Project Number to select State Aid Project Nbr Main SP Nbr Federal Project Nbr MAPS Contract Nbr Agreement Nbr Local Project Nbr Card ID 099 090 002 099 090 002 0607 150 FF2305 2420 099 999 099 099 999 099 0607 098 AH174 2069 Select the State Aid Project Nbr you wish to view The next 4 pages display the appearance of the report Page 84 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 County SAMPLE State Aid Project Number 099 999 099 Project Type DCP Local Project Number Account Setup Federal Priority Acct AC FP Nbr 1 L110 0607 098 Account Setup Non Federal Acct Nbr 245 70 Report ID FCRBProjectSetup v200901 15 Minnesota Department of Transportation Office of Finance FCRB Project Setup MAPS Contract Nbr
88. ormation funding type project location tied projects bridges within the project and work type Audience All users Screen Fields with an must be completed the screen sample appears on the next page Page 101 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Number Request Fields with must be camplebed 1E you need assistance please contact your District State Ald Engineer s Office rhone e T zmaiaddess 8 0 0 0 0 00 CibyCounby Hamer 0m A TTKN Requestor Name Funding Type s check all that apply Federal Aid D State ad O Turnback E Disaster D State Park Road DJ Read 5ystem 3 amp BREMAN Raad J Baad Nama Project Location Enter beginneng and end ol project to known pombe nat sLatiorungi Fram To in City of Pingel ina City enter the distance and direchon from the nearest incorporate miles From Direction Distance City Name Legal Degeriptian Sechan Toswnahugs Range Tied Project Numbers il any E 7 Bridges Bridge New Bridge amp Old Bridge amp Over a _ Ae OS E H Type al Wark Readway Ir por garegate t Base lo al Esc shoulder E s Aggregate sulaang m Bike Lane eheck all that apply p Roadway Bridge
89. out of system Page 45 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Payment Shortages Appearance Minnesota Department of Transportation Office of Finance Page l of 1 SAAS Payment Shortages As of 6 14 2009 County 005 BENTON Last Obligation Transfer Amt Paid Enc Paymt Total ProjNbr AwardDt paymt Dt Acct Type Status Payment Oblig Amt Amt to Pay To Dt Enc Amt Shortage Amt Shortage Amt Shortage Amt County 005 BENTON 005 604 019 05 29 1998 99 15 1999 71 CONST FINAL P 44 747 55 44 747 55 36 221 22 0 00 0 00 8 526 33 8 526 33 Total for project 003 604 019 8 526 33 005 608 006 04 12 1998 12 07 2000 70 ENG FINAL P 47 259 88 47 259 88 43 631 71 0 00 0 00 3 628 17 3 628 17 005 608 006 06 12 1998 12 07 2000 71 CONST FINAL P 278 108 85 278 108 85 268 135 21 0 00 0 00 9 973 64 9 973 64 Total for project 005 608 006 13 601 81 005 633 009 03 17 2000 04 19 2002 71 CONST FINAL P 96 230 62 96 230 62 25 133 00 0 00 0 00 71 097 62 71 097 62 Total for project 003 633 009 71 097 62 G d Total 93 225 76 This report uses tables PROJ OBLIGS PROJS TRANS LED MAX TRANS DT V MASTER ACCTS Note This report onlv displays the actual obligations that have a shortage Report ID ShortPaymts v20090511 Print Date 6 15 2009 3 10 46PM Page 46 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Repo
90. port ID YrlyBondPI v20090210 Print Date 4 21 2009 7 59 42AM Page 25 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bridge Bonding amp Other State Bonding Bridge Bonding amp Other State Bonding Programs Purpose To display information regarding Bridge Bonding and Other State Bonding Programs accounts Uses To determine what funds have been encumbered To identify the unexpended balance available to encumber to counties and municipalities Audience All users Screen This is the entry screen Select the District All Co Muni Account and Reporting Year Month from the drop down lists Note that reports cannot be run for a reporting month prior to the listed date Click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Bridge Bonding amp Other State Bonding Programs District OR co Muni fate 0 0 ew acowt Je 0 0 0 0 0 0 0 Ww Reporting Year Month This repart can not be run far a reporting month prior ta 11 2002 Log out of system The next page displays the appearance of the report Page 26 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bridge Bonding amp Other State Bonding Programs Appearance Page 1 of 6 Minnesota Department of Transportat
91. ral Aid Projects and Agreement Reports Encumbrance Open Projects Federal Payments Final Projects Last Voucher input by Local Government Ledger By Card Summary Payment Detail Payment Shortages Federal Advance Construction AC Payment Summary Project Setup Log out of system These Finandal Web Reponing pages are Seveloged by me Accounting Syslerm Section within the Office of Finesse Minnesota Government links Northstar Gorena Office Sean iccernal Web Site Mn DOT Coens Web spe General questions rogaa state mo v9 Leedoack cugeeition Page 59 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Projects and Agreement Reports Summary Table The available Federal Aid Projects and Agreement Reports are summarized below including their purpose REPORT PURPOSE View Open Encumbrance balance changes in encumbrance and amount paid to date Use this report to Encumbrance Open Projects verify sufficient encumbrance balance Federal Payments Pa Federal Payments View Federal Payments by specifie date range 0 Federal Payments by View Federal Payments by specifie date range 0 date range Displays finaled Federal Projects within the date range selected finaled projects are sorted by DCP and Paie Traditional Last Voucher Input by Local Display last Delegated Contract Process DCP Request entered by local
92. rch 2010 Delegated Contract Process DCP Payment Request Enter Prepared By Phone Number Voucher Number Retainage Percent OR Retainage Amount Damage Incentive Amount Prorate click check box to prorate Damage Incentive Amount the date the Work Completed Through Date Final Voucher click check box if this is the Final Voucher Remarks optional and the Certified Amt for each category this is total Work Certified to Date then press View Report SAAS Web Reporting Delegated Contract Process Payment Request Project Number 099 999 099 prepared y _ First Last Phone Number Voucher Nbr Last Voucher Nbr 2 Retainage Percent OR Retainage Amount Damage Incentive Amount Prorate Work Completed Through Date March v8 v Final voucher L Remarks 00000 0 O Enter all certified amounts including zero dollars Cat Certified To Dt Amt Previous Notes Certified To Dt Amt l S E55 218 33 348 121 20 190 000 00 180 000 00 3 68 222 17 4 730 00 Total gana 440 50 532 851 20 Back to the menu Log out of system The next 5 pages display the appearance of the report Submit the first page along with your supporting documentation for payment Page 90 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Delegated Contract Process DCP Payment Request Appearance
93. rt The next page displays the appearance of the report Page 15 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Advance CSAH amp MSAS Funds Appearance Page 5 of 8 Minnesota Department of Transportation Office of Finance SAAS Advance CSAH amp MSAS Funds As of 04 20 2009 Fund 260 COUNTY STATE AID HIGHWAY Max Allowable to Advance 10 060 090 86 Less Actual Advances 2 182 613 86 Less Outstanding Reserve Amt 7 471 363 00 Remaining Available to Advance 406 120 00 Account 70 CO REG CONST Resolution Original Bond Advance COUNTY Year Amount Reserve Amt Actual Advance Sel Aside Balance KANABEC 2009 668 659 38 668 659 38 668 659 38 0 00 668 659 38 LAKE 2009 450 000 00 450 000 00 0 00 0 00 0 00 RAMSEY 2009 5 713 287 00 5 713 237 00 0 00 0 00 0 00 ST LOUIS 2009 1 250 000 00 1 250 000 00 0 00 0 00 0 00 Total 8 081 946 38 8 081 946 38 668 659 38 0 00 668 659 38 Report ID GFAReg v20080527 Print Date 4 21 2000 7 40 52AM Page 16 Return to Table of Contents Aging Purpose Audience Screen State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Aging To identify open projects may select by year type district and Co Muni it may be sorted by Bid Opening Date or Project Number All users This is the entry screen Select the Year Requested Project Type
94. rts Users Manual March 2010 Project Allocation Project Allocation Purpose To display information regarding County and Municipal project allocations Uses To determine what funds have been allocated To identify the unexpended balance available to allocate to counties and municipalities Specifically for Allocation Method P by Project verses method A Annual allocation process Audience All users Screen This is the entry screen Select the Co Muni Account Allocation Year and Reporting Year Month Project Status All or Open from the drop down lists Note that reports cannot be run for a reporting month prior to the listed date Click View Report SAAS Web Reporting Functional Business View Gounty and Municipality Reports SAAS Project Allocation coun a M acoun Jeu 0 0 wj Reporting Year Month Project Status ALL PROJECTS This repart can not be run for a reporting month prior to 11 2002 Log out of system The next page displays the appearance of the report Page 47 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Project Allocation Appearance Minnesota Department of Transportation Office of Finance Page 1 of 93 SA AS Project Allocation As of 4 20 2009 County ALL Account ALL County 001 AITKIN Acct Original Original Net Paymt Proj Nbr Nbr Dist Alloc Date Allocation Ad
95. scaping Fi Maintain Building C acela e T Homes Bituminous rai nel bike p Moise Abatement E other Local Uses oO ther Trarssportati n achty Restoration m E Park ard Pade r1 Parking Lat 1 Pedestrian Lighting 1 Rest area Ir Retaining Wall fal Ecen Overlook Street Lohteng Tourist Center g Trail Head Ir Transit Hub Ir utiity Relocation E Wetland Mitigation State Aid Project Number Request Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Accountant Task Force Address Reports ACOUNTANT TASK FORCE ADDRESS REPORTS SAAS Reports Windows Internet oplorer 6 EA T o hitp lidotapor dot state mn usd s Isaas Peportetulb asp Polder Dei sas File Edi View Favorites Touk Help We de phe 5 A reek it deb Print ie Page m E Took M Hap SAAS Web Reporting Functional Business View Accountant Task Force Address Reports Accountant E Mail Accountant List State Aid Accounting Task Force E Mail State Aid Accounting Task Force List Log out of system Page 103 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Accountant Task Force Address Reports Summary Table The available Accountant Task Force Address Reports are summarized below including their purpose REPORT PURPOSE
96. sota Department of Transportation Office of Finance Page 2 of 3 State Aid Agreement Payment Request Municipality OTHER STATE AGENCIES State Aid Project Number 099 999 009 Agreement Type PRELIM ENG Agreement Nbr 99999 Pay Request Nbr 3 Work Certified Through 01 19 2010 Federal Project Number MNOS 010 Local Project Number Total certified amount exceeds contract amount Must submit appropriate supporting documents Payment Detail by Category Cat 4 Par Amt Mon Par Amt Total Cert Amt 200 000 00 0 00 200 000 00 Orig Paying Total Prev Cert this Priority SP Acct Acct AC Cert Amt Cert to Dt Voucher 1 099 999 009 H970 HS70 80 000 00 80 000 00 0 00 1 099 999 009 DNR DNR 20 000 00 20 000 00 30 00 2 099 999 009 DNR DNR OR Total for Cat Grand Total Report ID FCRBPaymentRequestAgr v20100113 100 000 00 200 000 00 Total Cert Amt 200 000 00 0 00 100 000 00 Prev Cert to Dt 100 000 00 100 000 00 100 000 00 Cert this Voucher 100 000 00 Print Date 1 19 2010 8 08 533 AM Paymt Amt 0 00 Page 99 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Federal Aid Agreement Payment Request Appearance Minnesota Department of Transportation Office of Finance Page 3 of 3 State Aid Agreement Payment Request Municipality OTHER STATE AGENCIES State Aid Project N
97. t L3 Bituminous Base E Bituminous Crack amp Saal m Bituminous M Construct Detour D Bituminous ME amp Overlay io Bituminous Overlay Bituminous Pavement m ERumirouEE g Bituminous Surfacing p Bypass Lant O channetization O cota Inplace Recycle O Concrete Crack amp curi Repo System A controller Traffic Signal Installation 0 Traffic Signal Poles F Traffic barrier p Eta Coat E Shoulder Paving E3 Fheudar widening O Fipe Flattereng o Storm Sewer rJ Subgrade Correction E midenin Estimated Construction Start Date January Month Year Estimated Construction End Date ey Month Year Lag out of system Page 102 T Trallic Control Railroad Orossmig E Temporary Traffic Augnal Traffic Management Ir Traffic Signal Cabinet F Traffic Signal Revision Tal Warning Flasher Other Facilities Ir Aggregate Bike 7 Bike Trail E Bike Lockers E ike Rack fa Biological Relacstan oO Bituminous Wak io iHuid amp ng Removal io Bus Shelters Ei Concrete Sidewalk E Curb Ramps El score Fedesmmarn Decoratie Roadway io Eresion Control Exhibits rJ Fencing 3 Histaric Building aztoratin a Historic Praecervatior Historie vehicle esto ation rJ Interpretive Fookties p Kiosks P ancde
98. t to contractor View Open Encumbrance balance changes in encumbrance and amount paid to date Use this report to verify sufficient encumbrance balance Audience All users Screen This is the entry screen Select the County Municipality Co Muni and Year Requested from the drop down lists then click View Report SAAS Web Reporting Functional Business View Federal Aid Projects and Agreement Reports amp Payment Request FERB Encumbrance Open Projects Comuni rmm Reporting Year Manth lew Report Log out of system The next page displays the appearance of the report Page 61 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Encumbrance Appearance Page 1 of 1 Minnesota Department of Transportation Office of Finance m FCRB Encumbrance Open Projects as of 4 20 2009 County SAMPLE Federal Contract Agreement Original Encumbrance Adjusted Paid to Dt Open Project S P Nbr Nbr Nbr Enc Amt Adjustments Enc Amt Amt Enc Amt 2207 014 099 999 099 AF517 1 000 000 00 52 613 47 947 386 53 947 386 53 0 00 1 000 000 00 52 613 47 947 386 53 947 386 53 0 00 This report uses tables FCRB CARD FCRB FUND CATEGORY HDR FCRB PROJ SETUP FCRB PROJ ENC V FCRB PROJ ENC CHANGE CO MUNI INFORMATION Report ID FCRBEncumbrance v2009042 1 Print Date 4 21 2009 2 28 19PM Page 62 Return to Table of Contents State
99. tatives anne zellner amp co cook mn us bette schweer co yellow medicne mn us bohara co kittson mn us cindy degener state mn us cwenkel co nicollet mn us dave enblom co cass mn us deidre hubbard co grant mn us duane ruona co crow wing mn us joan peters state mn us michael kilanowski state mn us sheila kirkwood co goodhue mn us tkarlson osa state mn us Task Force Alternatives dawn timmer co jackson mn us fkerber co carver mn us herring paula co olmsted mn us kathy glass co polk mn us kmkilda co becker mn us mark linne co carlton mn us nila ellis co wright mn us rsterzinger amp co lincoln mn us Log out of system Page 109 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force E Mail Appearance Page 1 of 1 State Aid Accounting Task Force E Mail Task Force Representatives anne zellner co cook mn us bette schweer co yellow medicine mn us bohara co kittson mn us cindy degener state mn us ewenkel co nicollet mn us dave enblom co cass mn us deidre hubbard co grant mn us duane ruona co crow wing mn us joan peters state mn us michael kilanowski state mn us sheila kirkwood co goodhue mn us tkarlson osa state mn us Task Force Alternates dawn timmer co jackson mn us fkerber co carver mn us herring paula co olmsted mn us kathy glass co polk mn us km kilda co becker mn us mark linne co carlton mn us nila ellis co
100. te 4 21 2009 3 27 52PM Page 66 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Final Projects Appearance Minnesota Department of Transportation Office of Finance FCRB Final Projects ALL Projects Finaled from 01 01 2009 to 04 21 2009 Page 2 of 3 District Project Type DCP Federal ewe Agr State Aid UR Om ce acs Jas ee s P Nbr Project Nbr Npr Letting Dt Award Dt Local Eligible BndProgram Federal Other Total Through Dt TransDt Final 144 135 010 1404 163 87226 476 503 17 0 00 0 00 940 418 60 0 00 1 116 921 77 02 10 2009 03 09 2009 160 090 007 6203 138 AC477 08 15 2005 240 193 05 0 00 0 00 948 826 06 0 00 1 189 019 11 09 25 2007 04 16 2009 165 090 002 5206 018 AH360 02 06 2008 03 10 2008 38 611 10 321 544 38 0 00 190 300 00 0 00 550 455 48 10 14 2008 03 23 2009 178 591 001 1907 115 FF058 12 04 2007 0 00 0 00 0 00 118 375 64 0 00 118 375 64 11 18 2008 02 09 2009 195 010 008 MN88 100 89604 0 00 0 00 0 00 358 225 24 0 00 358 225 24 01 28 2009 03 09 2009 Yes 227 020 006 8606 063 AB231 10 05 2004 215 206 77 0 00 0 00 257 580 00 0 00 472 786 77 11 14 2006 01 23 2009 237 010 001 4009 002 FF023 08 30 2007 2 496 30 1 133 81 0 00 197 600 00 131 346 22 332 576 33 11 04 2008 04 15 2009 DCP Total 1 637 417 26 921 136 40 1 784 507 59 12 810 905 11 542 503 52 25 996 559 88 Note Projects with
101. to 799 Muni Bridges Br Bond Amt Control Section 597 080 020 411 176 203 100 to 150 Township Rd Town Bridge Amt Control Section 599 592 County 039 Lake Control Section 598 Bridge Bond Accts 200 to 299 Town Bridge Accts Acct 75 and 76 This report uses tables PROJ OBLIG ALLOC V CO MUNI INFORMATION MASTER ACCTS PROJS PROJ OBLIGS ALLOCS BRIDGE BOND ACCT Note 1 If the award date was blank in project tracking the report will display projects created in SAAS during the award date range selected Note 2 Includes all funding types Const Eng ROW etc Report ID BridgeeBond Aca Summary v20090915 Print Date 12 7 2009 1 03 57PM Page 38 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Overpayments Overpayments Purpose To display information regarding Overpayments how an overpayment ocurred was the overpayment applied to another project or billed Audience All users Screen This is the selection screen Select Co Muni All Outstanding Only and Reporting Year Month from the drop down lists Click View Report SAAS Web Reporting Functional Business View County and Municipality Reports SAAS Overpayments Couty Mun ath Overpayments Reporting ear Moanth View Report Log out of system The next page displays the appearance of the report Page 39 Return to Table of Contents State Aid
102. ts Users Manual March 2010 Navigation REPORT NAVIGATION Entrance The SAAS Web Reporting is accessed through the Internet using your Password Open Internet Explorer and enter the following address http www dot state mn us safinance Back C3 m g n JO Gear Sr Favorites QN Meda o Gs A LI 3 Adress http www dat state mn us safinance Go liri Ji Stale Aid Finance Homepage Microsoli Inlernel Explarer E fes fe Fie EG Vew Favorites Took Help i G O ha Powe erm 0 1 mL 3 Address hitg wey dot state mnousissfinanes Er Mlinneseta Deepen weren of p Transportation b d MIL aln oues Horne About MDOT Doing Business Gating Around Sil ALO Ato Contact Simpl Search amp dranced Search LE State Aid Finance Providing Accounting and Financial Support to Minnesota s Cities and Counties Advances MM Hey Users Tax Distriluion Accountant s Task Force NEEDS Crest for Lecal Effort Annual Apportlonment Letters Hews Commissioner s Order COulzk Search Contacts SAAS Manual Cearnty Information SALT Homepage D C P Pracessing Statutes Rules amp Constitution Definitions and References Tralning Informatlen FHWA Form 536 Worksheet amp Applications GASB H e AMG Homepage Gh Hirret e GFOAH rncpauge WH Slate Lirgislfurie HH Slate Auditor Halignal Higher 3l TT e Vendor Payment Informalri Ad s Bag im i i I l I 1 TIT l l emt
103. ucher Paymt Amt 1 099 999 099 r r 100 00 64 811 06 4 493 50 60 317 56 0 00 PERENNE Ea 64 811 06 4 493 50 60 317 56 0 00 Note OR Overrun Account Report ID FCRBEPaymentRequest v20090407 Print Date 4 20 2009 1 19 24PM Page 92 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Delegated Contract Process DCP Payment Request Appearance Minnesota Department of Transportation Office of Finance Page 4 of 5 Delegated Contract Process Payment Request County SAMPLE Project Type DCP State Aid Project Number 999 999 099 MAPS Contract Nbr AH174 Federal Project Number 0607 098 Pay Request Nbr 3 Local Project Number Payment Detail by Account Work Gertified Through 03 31 2008 Orig Paying Acct Acct Total Net Prev Met Net Cert Cats Priority SP Acct Acct Desc Ac Pet Cert Amt Cert to Dt this Voucher Paymt Amt 1 1 099 999 099 245 245 BRIDGE BONDING 20 00 124 491 48 66 143 03 58 348 45 58 348 45 1 2 089 999 099 245 245 OR BRIDGE BONDING 100 00 0 00 0 00 0 00 0 00 Total for Account 245 BB 2006 290 0000 807 124 491 48 66 143 03 58 348 45 58 348 45 Total for Hie tonding Erne 124 491 48 66 143 03 58 348 45 58 348 45 1 099 999 099 L110 L110 BRIDGE 1596OFF 50 00 5497 965 93 264 572 11 233 393 82 233 393 82 Total for Account L110 BRIDGE PROGRAM 15 OFF 497 965 93 264 572 11 233 393 82 233 393 82 VEM KOP He NATI KEI
104. ued Amount 2 100 000 00 Issue Number l Applied Amount 2 100 000 00 Remaining to Apply 0 00 Report ID BondAppliedPrajs v20090310 Page 21 Overlay Applied Project Number Applied Date Project Amount 004 602 005 12 31 1989 Y 44 025 23 004 605 017 12 31 1989 N 268 711 00 004 605 018 12 31 1989 N 1 199 70 004 605 019 12 31 1989 N 4 195 08 004 609 006 04 20 1997 N 241 113 55 004 611 006 12 31 1989 N 19 111 60 004 615 009 12 31 1989 N 109 232 90 004 615 010 12 31 1989 N 2 251 46 004 623 020 12 31 1989 Y 82 515 24 004 624 008 12 31 1989 N 91 719 10 004 624 009 12 31 1989 N 1 865 02 004 626 003 12 31 1989 N 100 91 1 46 004 629 004 12 31 1989 Y 38 980 67 004 630 01 1 12 31 1989 Y 263 650 81 004 631 005 12 31 1989 Y 131 473 99 004 632 012 12 31 1989 N 179 701 4 004 632 013 12 31 1989 Y 91 927 26 004 632 014 12 31 1989 N 3 569 22 004 636 007 12 31 1989 N 423 845 30 Total 2 100 000 00 Print Date 4 21 2009 7 39 13AM Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Bond Loan Schedule Bond Loan Schedule Purpose Provide Bond Payment Schedule of principal and interest may select by Co Muni Bond Type and Year Month Audience All users Screen This is the entry screen Select the Co Muni Bond Type Reporting Year Month from the drop down lists Click View Report SAAS Web Reporting Functional Business View County and
105. umber 099 999 009 MNOS 010 Agreement Type PRELIM ENG 99999 Pay Request Nbr 3 Work Certified Through 07 19 2010 Agreement Nbr Federal Project Number Local Project Number Payment Detail by Account Orig Paying Acet Acct Cat Priority SP Acct Acct Desc AC Pet Total Prev Cert Amt Cert to Dt Cert this Voucher Paymt Amt 1 089 999 009 H970 H870 NSBP 80 00 Total for Account H970 NATIONAL SCENIC BYWAYS PROGRAM Total for the funding type 0 00 0 00 0 00 80 000 00 80 000 00 80 000 00 30 00 80 000 00 0 00 1 088 999 009 DNR 2 099 999 009 DNR DNR DNR DNR OR DNR 1 Total for Account DNR DEPT OF NATURAL RESOURCES Total for the funding type Grand Total Total Federal Less Prev Paymts Federal Due 80 000 00 80 000 00 0 00 Report ID FCRBPaymentRequestAgr v20100113 20 00 00 00 120 000 00 80 000 00 20 000 00 100 000 00 120 000 00 200 000 00 80 000 00 20 000 00 0 00 20 000 00 20 000 00 100 000 00 0 00 30 00 100 000 00 100 000 00 100 000 00 100 000 00 Print Date 1 19 2010 8 09 53AM 0 00 0 00 0 00 0 00 0 00 Page 100 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 State Aid Project Number Request o STATE AID PROJECT NUMBER REQUEST Purpose Request a State Aid Project Number Provide city county inf
106. wright mn us rsterzinger co lincoln mn us Report ID TaskForceEmail v20100302 Print Date 3 15 2010 7 39 30AM Page 110 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force List Task Force List Purpose View Task Force List The list includes address term e mail and phone numbers Audience All users Screen This is the entry screen There is no selection criteria click View Report to print the list SAAS Web Reporting Functional Business View Accountant Task Force Address Reports State Aid Accounting Task Force List This report does not have any parameters Log out of system Page 111 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Task Force List Appearance Page l of 4 State Aid Accounting Task Force List mem Name County Dept District Agency Email Address Kim Kildal Becker 4 kmkilda co becker mn us 200 State St East Detroit Lakes MN 56501 Phone No 218 847 4463 Fax No 218 846 2360 Appointment Date 10 01 2008 Term Expiration Date 09 30 2010 Mark Linne Carlton 4 mark linne co carlton mn us 1630 Country Road 61 Carlton MN 99 18 81 0 Phone No 218 384 9151 Fax No 218 384 0123 Appointment Date 10 01 2007 Term Expiration Date 09 30 2008 Francis Kerber Carver 5 fkerber co carver mn us 11360
107. zero encumbrance at conversion and or various special projects will not appear on this report Referto excel worksheets for project data Report ID FCRBFinalProjects v20090409 Print Date 4 21 2009 3 27 52PM Page 67 Return to Table of Contents State Aid Accounting System Minnesota Department of Transportation SAASY Reports Users Manual March 2010 Final Projects Appearance Minnesota Department of Transportation Office of Finance Page 3 of 3 FCRB Final Projects District ALL Projects Finaled from 01 01 2009 to 04 21 2009 Project Type TRADITIONAL PRAES ee E WorkCompl Last MnDOT T e A Letting Dt Award Dt Local pe Sates Federal Other Total Through Dt TransDt Final 009 600 002 0995 040 96018 01 22 1996 45 231 46 0 00 0 00 180 925 83 0 00 226 157 29 06 03 4997 03 25 2009 Yes 009 606 020 0996 237 96019 01 22 1996 0 00 73 719 53 0 00 294 878 14 0 00 368 597 67 12 05 1996 03 25 2009 025 590 001 FLEX 196 96384 12 17 1996 24 940 39 0 00 0 00 99 761 57 0 00 124 701 96 01 02 1998 04 01 2009 025 618 014 FLEX 197 98300 03 23 1998 0 00 558 814 69 0 00 2 235258 73 0 00 2 794 073 42 01 12 2009 01 20 2009 032 623 015 1101 166 98504 07 27 1998 0 00 143 161 36 0 00 572 645 43 0 00 715 806 79 03 08 2005 03 30 2009 076 635 020 7699 171 99344 12 21 1999 0 00 177 552 99 000 71021195 0 00 887 764 94 02 12 2009 04 08 2009 092 090 009 FLEX 197 98383 05 14 1998 0 00 0 00 0 00 165 000 00 303 113 28 468 113 28 05

SAAS Manual - Minnesota Department of Transportation

Contents

Download Pdf Manuals

Related Search

Related Contents