Update Multiple Account Budgets
If you want to modify several account budgets or project budgets, you can export the data to a spreadsheet program and update them using any combination of formulas available in the spreadsheet program.
You can also update one or more Departments
for each account specified.
To update multiple account budgets:
Step 1: Export the accounts budgets
- In the Home window on the File menu, choose Import/Export, and then Export Records.
- Select Export account budgets and click Next.
- In the Export File window:
- Enter a name for the file you are exporting.
- Enter a destination for the file you are exporting, or click Browse to navigate to a destination.
- Click Next.
- To select the accounts
you want to export, click the
column beside each account,
or click Select All to choose everything
in the list. Then click Next. - To select the departments
to which you want to export budgets, click the column beside
each department, or click Select All to choose
everything in the list. Then click Next.
- Review the export log for errors. If the export was successful, click OK to save the file.
- Click Finish to close the wizard.
Step 2: Modify the account budgets
in a spreadsheet program
- The exported file was saved in a .TXT format. Rename it as a .CSV file to open it in a spreadsheet program.
- Open the file in the spreadsheet program and modify as required.
- Save the updated file in .CSV format.
Note: The account number and department segment must match your Sage 50 Accounting data. If it does not match, it will be skipped during import.
Step 3: Import the new account
budgets back into Sage 50 Accounting
- Choose Import/Export from the File menu in the Home window, then Import Records.
- Select Updated account budgets and click OK.
- (Optional) To back up your company, click Back Up. When the backup is finished, click Next.
- Enter the location of the file you want to import, or click Browse to locate it, and then click Next.
- Review the import log for errors and then click OK.
- Click Finish to close the wizard.
If any accounts or departments cannot be imported, they are identified in the Import Progress Report displayed on your desktop screen. You can print this report and adjust your spreadsheet as required.