MoneyWorks allows you to import budget data from a text file created in another application. This is not available in Cashbook.
To import budgets from a text file, the text file must be in tab-separated format with the account codes in the first column, followed by budget data in subsequent columns.
The standard file open window will be displayed.
The Import Budgets dialog box will be displayed.
MoneyWorks will have filled this out based on the number if columns of budget data in the file.
You can import budgets for the previous, current or next financial years.
Budgeted income will (normally) be represented as a credit balance. If the income in your spreadsheet has been entered as positive values, you need to check the Credit is Positive radio button. Budgeted expenditure in the spreadsheet should have the opposite sign to income (because it is normally a debit).
The text file will be checked and any errors detected they will be listed on the screen. You will need to correct these and try the import again.
If no errors are found you will be asked if you want to continue and import the information.
The budget information will be imported.
If Cancel is clicked, the budgets will not be imported
Note: The importing of budgets can be scripted using the SetBudget() function.