Edit

Of Budgets, Balances & Reminders

If you are heavily into budgets, you will be pleased to know that MoneyWorks supports two alternate budgets, A and B. Budget information for each of these can be entered for the Previous, Current and Next financial years, and is used to generate variance data in your account enquiries and reports. Budgets are normally done on an accrual basis (e.g. invoiced sales); use the Cash Forecast report to convert an accrual budget to a 15 month cash flow forecast.

Budget data can be entered directly into MoneyWorks, it can be copied out of a spreadsheet (or from the MoneyWorks historic actual or budget data) and pasted into the MoneyWorks budget editor, or it can be imported from a text file (import).

Entering Budget Data

  1. Choose Show>Budgets or press Ctrl-6/⌘-6

The Budget data appears in a grid of account codes and periods. This is called the Budget Editor.

  1. Choose whether you want to work with the A or B budgets

By default, the editor will open showing the A budget. Choose the B Budget from the toolbar menu. The window title shows the currently used budget.

The B Budget is available as an alternate budget in custom reports. The A budget is used in all the supplied reports, as well as in the Account Enquiries (see Account Enquiries).

  1. Click on the cell containing the budget figure you wish to alter
  1. Type in the new value

It will appear in the edit area at the top of the window as you type.

  1. Click the Tick button or press tab or Enter

If you do not want the changed value to be entered into the cell, click the Cross button.

Budgets are normally entered as positive values1. Income and liability budgets will appear in red to indicate that they will be treated as credits.

Note: You can use the Undo command in the Edit menu to undo the last change to the budget spreadsheet.

Note: If you only wish to enter annual budgets instead of period by period budgets, you should enter these into the first period of the financial year. For example, if your financial year runs from April to March, you should enter your annual budgets into the April period2.


1  This is not how it was done in versions of MoneyWorks prior to 5.0.

2  You can use the Fill Right command to spread it out over the whole financial year