How to import or update account budgets

• When importing budgets, the data is only applicable for the current fiscal year
• If you wish to update the budget for the next fiscal year, you must start a new year

Enable account budgets in Sage 50

1. Go to Setup, Settings, General (Accounts), Budget.
2. Select the Budget revenue and expense accounts option.
3. Select the desired Budget period frequency.
4. Click OK.

Activate budgets in the Chart of Accounts

1. In Sage 50, go to Company, then Chart of Accounts.
2. Double-click the first account you're going to use, and go to the Budget tab.
3. Select the Budget this account option.
4. Click Save and Close.
5. Go to the next account if needed.

Modifying the CSV file (with Microsoft Excel)

1. Open Microsoft Excel.
2. Select File, then Open.
3. Select the CSV file exported from the old Sage 50 Accounting file on the c: drive.
4. The first line of the CSV file must contain a Version Number, Country Code, and the word Account Budgets.
5. The second line of the CSV file must contain the word Account, the word Name, and the name of each budgeting period in separate columns.
6. The number of periods must match the Budget period frequency that you selected in Settings.
7. For each account (or account/department), you must have one line:
   • The account number in column A
   • The account name in column B (formatted as text)
   • One column for each budgeted period afterwards. Don't leave spaces but put zeros

• • If you have department feature enabled, you can follow the format below to get the budget
    amounts imported to each department too:
    

Import the budgets into Sage 50 Accounting