If your import budget file rejects, verify the following:

• The import file must exactly match the template specified in General Ledger Help.
• 1. From the Help menu, select Help Topics.
  2. Click the Index tab and type "Import budgets" to see a listing of related topics.
  3. Select record format to see the format your budgets need to be in or select file example to see what the comma delimited text file should look like.
• The sign on negative numbers can precede or follow the number (-100 or 100-) when importing budgets.
  Note: If importing from an Excel spreadsheet, the sign should precede the number (-100 instead of 100-).
• The import file must have all thirteen periods plus the annual amount as shown in Help even if the thirteenth period is not used.
• Do not import budgets for a partial year. To update a budget already entered, re-import the entire budget for that year.
• Verify that your budget amounts are not using commas as thousand separators (10,000 should be 10000).
• The import budget file must be in a comma delimited format (each field is separated by a comma).
  Tip: If importing your budgets from an Excel spreadsheet, save the file as a comma delimited (csv) file.
• 1. In Excel, from the File menu, select Save As.
  2. From the Save as type list, select CSV (comma delimited)(*.csv).
  3. Click Save.
  4. To select the CSV file when you import your budgets in General Ledger (Tools, Import Budgets) select All Files (*.*) from the Files of type list.
• The accounts being imported must have Store Budgets selected (Setup, Accounts, General tab).