A question came up last month about updating budgets within MAS 90.
While there are several ways to update the budgets in MAS 90, I find the easiest way is using F9’s Budget Write Back functionality.
F9 is an Excel plugin that reads financial data
First you need to create a spreadsheet with your GL Accounts and periods. The critical piece is to have the headers exactly correct. The header for the Account Column needs to say Account, the header for the account description needs to read Description, and the individual periods needs to have the number only for the period as the header (ie: Period one is 1, Period two is 2, etc.). You don’t have to have the account description in your spreadsheet for this to work. I’ll put up another post explaining how to do this later and link to it here.
Next you need to fill out the budget amounts for each period. If you only want to update a single period, you don’t have to have the other periods in your spreadsheet.
Before we run the F9 Budget Write back, you can see the MAS 90 budget here:
Next we go back to Excel and highlight and copy the cells with the accounts, periods and budgets you want to update.
Then go to the F9 Menu | Budgeting | Budget Write Back.
Verify the company code, budget, and Fiscal year.
The other concern here is whether you have the “Write ‘Sales’ accounts as debits” check box checked. Check it if you entered the sales accounts as positive amounts on your spreadsheet. Don’t check it if you entered them as negatives.
Click on Write and over in MAS 90, you will see the budgets have been entered automatically. Note that it will show the credit balances as negatives in MAS 90.
You can use the same technique to only update certain accounts and certain periods. To make this work, just make sure you only copy the sections you want to update before performing the Budget Write Back.
In my example below I’m updating only period three for the account selected.