Using Reset to No Actual’s
The Reset to No Actuals feature is designed to make the next year budget easier. This works by saving your actuals as the budget figures to then allow to you extend the budget into next year using these figures as the basis for extend and amend.
Method:
1. Copy the actual forecast and save as a new forecast:
2. Open the copied forecast and select Reset to No Actuals
3. Select Yes to reset:
4. Then select Yes to keep your actuals:
5. Your forecast will revert back to budget mode, replacing your original budget figures with your actuals.
Once Actuals are reset:
All records will need to be checked depending on the methods e.g. % of records should be fine but memo drivers may change values.
All the forecast system records are going to change (e.g. GST, Debtors, Creditors, Bank, interest, tax etc) as the new figures will be factored in to the calculations.
Calculated Loans (Taken and Received) and Financed Assets will need the terms changed for 12 months less.
Manual loans, for example, will need to be reviewed carefully as the entries could differ.
The opening balance sheet is unchanged from the original so this will need to be updated.
To import the last actual balance sheet and paste into the new opening balance:
1. Go to the original budget and enter actuals.
2. Export the year end last balance sheet to clipboard then paste to excel.
3. Open the new forecast, go to Enter Opening Balances.
4. Reset the balance sheet so there are no values.
5. From excel in step 2, copy the balance sheet and select Import from Clipboard.
The retained earnings are going to change.
Income Tax needs to be checked as the Reset to No Actuals causes a recalculation of tax as well the tax payments.
Also for dividends which are manually entered.
To make a recalculation, change a sales record value, select a month and note the values. Enter 0 then tab off the cell, now enter the old value. This will force a recalculation.
From the Utilities Tab, run budget record recalculation
Now go to reports and the system records recalculation will run
Related Articles
Import Error: SQL Exception: Incorrect Syntax near "s"
Issue: Receiving this error message when trying to import records, sections or folders. SQL Exception Incorrect Syntax near "s" Unclosed quotation mark after the character string 'WHERE' This error is caused because there is a single quote character ...Using Forecast Status
We have recently introduced a forecast status for Admin Pack users. This allows the owner of a forecast to define the status of a forecast; Editable = Anything can be changed in the forecast. Budget Entry = Only numbers can be entered (settings and ...One Touch Reporting - An error occured while using the template
Issue: When trying to create a OTR report from Forecast 5, you are receiving the error below: Cause: This can be due to a number of reasons: 1. The excel template you are trying to use is already open. 2. The forecast name contains characters that ...Using bank accounts for shareholders payments and crediting to current account
How to set up shareholders payments and credit to current account Set up a P&L Cost as separately invoiced cost and call it “shareholders salaries” Create a bank account called “Drawings” Create an other debtor/creditor account (Other assets and ...GST Cash Payments Opening Balance
Issue: When using the GST Scheme of Cash Payments, there is no way to accomodate for opening entry. Solution: Set to Manually Entered to enter the opening payment. The rest of the process will stay the same.