Budget import errors
Description

 NOTE: This feature is only available in Sage Accounting Plus. 

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

The most common 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
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:

  • Columns have been added or removed
  • Rows have been added or removed
  • The original export file hasn't been used
  • A different file format has been used

To resolve the error, follow these steps to export the file, 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 messageReasonResolution
Non-numeric data found in the import file at cell D16The 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 does not exist in the system.If you have changed a nominal code, change it back. If you have added a nominal code to the file, remove it.

Review each error and resolve the problem. 

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

If you need further support, please contact our Support team > 

[BCB:306:UKI - Search override - Accounting UK / IE:ECB]


[BCB:276:UKI - hide back button:ECB]


[BCB:299:UKI - Personal content block - Dane:ECB]


Steps to duplicate
Related Solutions