The Florida AFR data has come to us in two flavors. The first is a normalized list of records with Funds and Functions in rows. The second is a flat file with Funds in columns. Then new state portal seems to have standardized on the flat file. We have scripts stored to handle both.
The flatfile contains all forms of government in one Excel workbook for Revenues, another workbook for Expenditures, and Total Debt in a third workbook. Be careful when importing the flatfile into the MySQL staging table as the column names have changed from one year to the next.
The normalized Florida AFR file is an Excel spreadsheet with a separate tab Cites and Counties and a separate tab for Revenues and a tab for Expenditures. The file format has been different each year so some exploring will be required. The state of Florida does not require the reporting of balance sheet items. The Revenue and Expenditure Account codes in Column A must be in the format ###.###.
The Florida Local Code (Unit ID) is a 6-digit code. The first two digits identify the type of local unit. 10 = County, 20 = Municipality. 30 = Authority. 50 = Looks like Regional Planning Councils and an array of trust agencies.