Follow

Create a Working Budget in Quick Budgets

To create a working budget in Quick Budgets, you will need to:

  1. Copy an existing Quick Budget, then
  2. Import actuals into the copied budget

Copy an existing Quick Budget

To copy a an existing Quick Budget:

  1. At the Home Page, click Budget image001.jpg
  2. Click Quick Budget image002.jpg
  3. Click Copy Quick Budget image003.jpg
  4. The Copy a Quick Budget screen displays 

    image004.png

    • From the Select Quick Budget to Copy listselect 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 

      image005.png

  5.  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:

  1. Open the copy of the budget you wish to import the actuals into
  2. The Quick Budget screen will display. Click the Import button image006.jpg
  3. The following dialogue box will be displayed 

    image007.jpg

    • 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
  4. Click the green tick to import the actuals
  5. 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 image008.jpg
  6. 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 image008.jpg 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
  7. Re-lock the cashbook by ticking the CB Lock checkbox image008.jpg
Was this article helpful?
1 out of 1 found this helpful
Have more questions? Submit a request

Comments