Budget import errors
Description

There are many different reasons why your budget import will have errors. 

The most common reasons are:

  • Changes made to the ledger account name or number
  • Deleted columns or rows from the exported file
  • Added extra columns or rows
  • Put anything other than figures in the boxes
  • Clearing a figures box or leaving it blank

NOTE:

This feature is only available in Sage Accounting Plus. Find information on how to upgrade your Sage subscription.

Cause
Resolution

Import requirements

Your imported file must include:

  • A column for every month
  • Include all the ledger accounts from the original export (nothing added or removed)
  • A figure for every ledger account, for every month. (Even if it's 0)
  • Adapted from the original exported file. You can't import your own file

Download the error log

  1. Select Notifications on the top bar.
  2. On the notification for Financial budgets, select Download error log.
  3. The file will automatically download to your device, or will ask you to select a location to save it. 
    If you don't see the Download error log, look at the next section.

Resolve the errors

The upload file is not in the correct format

This message will appear on the notification if:

  • You've added or removed columns
  • You've added or removed rows
  • The original export file hasn't been used
  • A different file format has been used

To resolve the error, update your financial budgets using Excel, change the figures only and import again. 

Error log

The error log will show what is preventing the budget from importing successfully. 

The error log will include a cell number, or an actual entry along with what the error is. 

Examples of errors include:

Error message Reason Resolution
Non-numeric data found in the import file at cell D16 The system is expecting to see a number here. Go to the cell and make sure you only enter a numerical value, no words or letters.
Could not find ledger account with nominal code "4922" This means the nominal code doesn’t exist in the system. If you’ve changed a nominal code, change it back. If you’ve added a nominal code to the file, remove it.

Review each error and resolve the problem. 

Once you’ve resolved the errors, import your budget file again. 

If you need further support, contact our Support team.

Steps to duplicate
Related Solutions