Prepare the files

•    Open the Excel Translator File (M://Clients/aaMichigan/Municipalities/F65 Tracking and Translator.xlsm).

•    Use the “Tracking” tab to keep track of progress.

•    Open the Excel file to be converted by using the tab “Assumptions” and the button “Select File to Process”. (F652013TownshipsRevenues.xls for example)

•    In cell C3 of the Translator use the “Select File to Process” button to enter the name of the file

•    In cell C4 select the translator table for converting F65 Line Numbers to Munetrix Subcategory ID's (2012 Revenue Translator for example)

•    In cell C5 enter which file is being converted (R for Revenues for example)

•    In cell C6 enter the local unity type (Township for example)

•    Click the "Run F65 Worksheet Setup" button

•    Repeat for each of the three FInancial Statement types