Error message when you use the "Budget Wizard for Excel" in Microsoft Dynamics GP to try to import a budget: "The number of periods for the budget does not match the number of columns in Excel. Import will not be able to complete"

To resolve this issue, use one of the following methods.

Method 1

Go to the Fiscal Periods Setup window to see how the names for the periods are listed. If they are in date format, change them to Period 1, Period 2, etc. To do this click on Tools on the Microsoft Dynamics GP menu, point to Setup, point to Company and click Fiscal Periods. Then enter the new matching fiscal period names such as Period 1, Period 2, etc. on the import file. Save and retest the import. 

Method 2

Change the period headers in the Excel worksheet to a text format. To do this, follow these steps:

1. In the Excel worksheet, highlight all the column headers for the periods.
2. On the Format menu, click Cells.
3. On the Number tab, click Text in the Category list.
4. Click OK.
5. If the cells are changed to numbers, re-enter the period headers to match the fiscal period setup.
   
   NOTE:  Or put a single apostrophe before each column header name to force it to be text.