Michigan OLD Portal

Go to the Michigan F65 portal: http://f65.mitreasury.msu.edu/Reports/DataSummaryReport.aspx

Batches of F65s must be downloaded by Municipal Type and Chart of Accounts type. For example, for Townships three files must be download by filtering for Fiscal Year, Local Unit Type (Township), Category, and Sub-Category (All). Save the files with the names;

    F652017TownshipsRevenues.xls

    F652017TownshipsExpenses.xls

    F652017TownshipsSOP.xls

 

NOTE: the VBA code assumes the column headers begin in row 4. Some of the spreadsheets have been midified to have the column headers in Row 1. Insert 3 rows in this case.