To create a working budget in Quick Budgets, you will need to:
- Copy an existing Quick Budget, then
- Import actuals into the copied budget
Copy an existing Quick Budget
To copy a an existing Quick Budget:
- At the Home Page, click Budget
- Click Quick Budget
- Click Copy Quick Budget
- The Copy a Quick Budget screen displays
- From the Select Quick Budget to Copy list, select the existing budget you wish to copy
- In the Name of Copy text field, type in a new name e.g. Working Quick Budget March 17 - Feb 18
- Click the green tick to save the new copy
Import Actuals into the copied budget
A common scenario is to import the actuals (cashbook figures) into the copied budget. Each month after the cashbook is reconciled, the actuals are imported into the copy. Adjustments are made to resolve anomalies between the imported figures and the budget figures, and future balances can be examined to see if plans need to be altered.
To import the actuals:
- Open the copy of the budget you wish to import the actuals into
- The Quick Budget screen will display. Click the Import button
- The following dialogue box will be displayed
- Import What?: Select Cashbook as Entered to import data by cheque date
- Select Cashbook as Cleared to import data by the date cheques were cleared on the bank statement
- Import which codes?: All will be selected by default. All codes in the middle column are highlighted
- To select specific codes, follow the directions shown on the window
- To select codes: To select specific codes, use the directions shown on the window
- First month to import: Select the first month you wish to import data from
- Last month to import: Select the last month you wish to import data from
- Click the green tick to import the actuals
- Once you have imported the actuals, you will be taken back to you working budget. You may find it necessary to edit the last imported month, particularly if the month has not been reconciled. The cells filled with the actuals will be grey and locked from editing. You can unlock those cells by unticking the CB Lock checkbox
- If you need to erase or change any figures in the grey locked area of the direct entry section (due to possible doubling up of figures) you would:
- Untick the CB Lock checkbox to unlock the cashbook data
- Click the relevant code
- Click the grey box in the month where the figure needs deleting
- Press the delete key
- Re-lock the cashbook by ticking the CB Lock checkbox
Comments