Check the MS Excel steps like BS&A with a few exceptions

Add a new tab and name it RawData

Copy A4 à last row/column of data (or 1st cell containing an account string)

Paste onto RawData starting at A2

Insert 9 columns to the left of column A

Enter these column headers: ImpMunID, ImpAndID_####, ImpFutID, ImpFtsID, ImpSscID, ImpFundCode, ImpFunctionCode, SectionID, ImpSection, AcctSource, ImpAccountString, Balance, ImpDescription

The column with data to load as ImpAmount

Populate Column A with the local unit’s MunID

Populate Column B with the AndID

To get the Section Populate Column H with: =RIGHT(LEFT(I2,11),1)

Filter the list to Section 3 and enter “Revenues” in column I.

Filter the list to Section 5 and enter “Expense” in column I.

Populate column F with =LEFT(J2,2)

NOTE: the following formulas may change based on the account string for each local unit.

Filter the list for Revenues by column H = 3 and enter: =LEFT(J69,2)

Filter the list for Expense by column H = 5 and enter: =LEFT(J69,2)&"-"&RIGHT(LEFT(J69,9),3).

To get the Account String enter in Column K: =RIGHT(J2,LEN(J2)-21)

To get the Account Description enter in Column M: =RIGHT(J2,LEN(J2)-21).