Client exported budget numbers to Excel for all departments using a Financial Statement export.
Changes were made to budget numbers.
We then saved each departmental report with a new name.
We created a macro to change formulas to values,
strip out the header rows and subtotal rows,
delete the extra columns,
change format of dollars to numbers with 2 decimal places,
and change the account code figures from [50000-`] to [50000].

The resulting excel spreadsheet has columns for account code and each of 12 periods.

When importing, we are defaulting department to the correct 3 character code and defaulting type to ?Income Statement?
Result is ?File layout is incorrect. Import is cancelled.?

Can you advise what might be the problem with the layout?