Cannot Import from Clipboard in Actuals or Opening Balances

Cannot Import from Clipboard in Actuals or Opening Balances

Issue:
I have exported my actual figures to Excel using "Export to Clipboard", have made changes in Excel and copied the excel figures to my clipboard but now the Import option is not available.
Cause:
If you forecast name is entirely made up of numbers or has unusual characters, e.g. * , -
This can cause Forecast 5 confusion on what to import.

Solution:
Temporarily rename your forecast to something plain, e.g. Test, and complete the import.
Note: the heading of your excel copy must match the forecast name:

    • Related Articles

    • 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. ...

    • Opening Balance: Loan Opening Balance Won't Save

      Issue / Problem: When in the Enter Opening balances screen, the Loan opening balance will not save:   Solution: You must enter the Opening Balance of the loan in the loan record:    

    • How To: Import Accrual and Prepaid Actuals for Balance Sheet from Integrations

      Situation Forecast 5 Income & Cost records that are accruals/prepayments and separately invoiced records create a balance sheet data entry field linked to the P&L record but there is no Balance sheet GL Code from which to import the balance each ...

    • Xero Integration - Actuals not importing

      Issue: When trying to import your Actuals into Forecast 5 using the Xero integration, some or all figures are not pulling through. Cause: This could be due to lack of connection or locked accounts. Solution: 1. Check that you have re-established the ...

    • Forecast 5 Essentials Guide - the basics of Forecast 5

      This guide will walk you through the steps of setting up and using Forecast 5. Introduction to Forecast 5 Forecast 5 is a purpose-built forecast and budgeting tool that uses a pre-built metric template and contains an integrated report set (P&L, ...