When you upload a template to create an Excel organisation, the system will check the format and will provide an error message if it’s incorrect.
Each error message will direct you to the cell in question.
Check the errors below for a quick resolution. If you require further guidance, our Support Team are always on hand to provide help.
ACCOUNTS_PAYABLE_ACCOUNT_NAME_EMPTY
ACCOUNTS_PAYABLE_ACCOUNT_NAME_EMPTY
This means the account set as the system account for Accounts Payable has no account name.
How do I resolve this?
Locate the Current Liabilities category in the Balance Sheet tab of the spreadsheet. Ensure there’s an account set as the system account for Accounts Payable, and that it has a name.
ACCOUNTS_PAYABLE_INCORRECT_CATEGORY
ACCOUNTS_PAYABLE_INCORRECT_CATEGORY
The account set as the system account for Accounts Payable is in the incorrect category. It will always need to be set against an account within the Current Liabilities category.
How do I resolve this?
In the spreadsheet, set an account within the Current Liabilities category to be the system account for Accounts Payable.
If this isn’t the first time uploading the organisation, you’ll need to make sure any accounts that might have moved category keep the same account code.
ACCOUNTS_PAYABLE_MISSING
ACCOUNTS_PAYABLE_MISSING
No account has been selected as the system account for Accounts Payable.
How do I resolve this?
In the spreadsheet, you’ll need to add at least one account to the Current Liabilities category, then set that account as the system account for Accounts Payable.
ACCOUNTS_PAYABLE_MORE_THAN_ONE
ACCOUNTS_PAYABLE_MORE_THAN_ONE
More than one account in the Current Liabilities category in the spreadsheet has been set as the Accounts Payable system account.
How do I resolve this?
In the spreadsheet, in the Current Liabilities category, ensure only one account has been set as the system account for Accounts Payable.
ACCOUNTS_RECEIVABLE_ACCOUNT_NAME_EMPTY
ACCOUNTS_RECEIVABLE_ACCOUNT_NAME_EMPTY
The account set as the system account for Accounts Receivable has no account name.
How do I resolve this?
Locate the Current Assets category in the Balance Sheet tab in the spreadsheet.
Ensure there’s an account set as the system account for Accounts Receivable, and that it has a name.
ACCOUNTS_RECEIVABLE_INCORRECT_CATEGORY
ACCOUNTS_RECEIVABLE_INCORRECT_CATEGORY
The account set as the system account for Accounts Receivable is in the incorrect category. It will always need to be set against an account within the Current Assets category.
How do I resolve this?
In the spreadsheet, set an account within the Current Assets category to be the system account for Accounts Receivable.
If this isn’t the first time uploading the organisation, you’ll need to make sure any accounts that might have moved category keep the same account code.
ACCOUNTS_RECEIVABLE_MISSING
ACCOUNTS_RECEIVABLE_MISSING
No account has been selected as the system account for Accounts Receivable.
How do I resolve this?
In the spreadsheet, you’ll need to add at least one account to the Current Assets category, then set that account as the system account for Accounts Receivable.
ACCOUNTS_RECEIVABLE_MORE_THAN_ONE
ACCOUNTS_RECEIVABLE_MORE_THAN_ONE
More than one account in the Current Liabilities category in the spreadsheet has been set as the Accounts Payable system account.
How do I resolve this?
In the spreadsheet, in the Current Liabilities category, ensure only one account has been set as the system account for Accounts Payable.
BALANCE_SHEET_MISSING
BALANCE_SHEET_MISSING
No Balance Sheet tab has been uploaded in the spreadsheet.
How do I resolve this?
When uploading a spreadsheet, both the Profit & Loss and Balance Sheet tabs need to be uploaded. If the Balance Sheet tab has been deleted, you will need to download a new template.
COMPANY_NAME_BLANK
COMPANY_NAME_BLANK
No company name has been added for the organisation in the spreadsheet.
How do I resolve this?
In the Profit & Loss tab of the spreadsheet, in cell B2, add a name for the organisation. The organisation name cell can’t be left blank.
COMPANY_NAME_TOO_LONG
COMPANY_NAME_TOO_LONG
The company name exceeds the limit of 30 characters.
How do I resolve this?
Modify the name to reduce the number of characters.
CURRENCY_NOT_SUPPORTED
CURRENCY_NOT_SUPPORTED
The currency option selected for the organisation isn’t valid.
How do I resolve this?
In the spreadsheet, within the Profit & Loss tab, update the currency in cell B4 to one of the supported currencies found in the cell's dropdown option.
DATE_FORMAT_INCORRECT
DATE_FORMAT_INCORRECT
The date format in either row 7 of the Profit & Loss tab, or row 5 of the Balance Sheet tab is in the incorrect format.
How do I resolve this?
Use financial year start month and start year to set the dates - even if that means having months that might be left empty - date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
DATE_ROW_HAD_BLANKS
DATE_ROW_HAD_BLANKS
One of the date cells in either row 7 of the Profit & Loss tab, or row 5 of the Balance Sheet tab has not been populated.
How do I resolve this?
Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
DATES_DO_NOT_MATCH
DATES_DO_NOT_MATCH
One of the date cells in the spreadsheet is being uploaded incorrectly.
How do I resolve this?
Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
DUPLICATED_ACCOUNT_CODE
DUPLICATED_ACCOUNT_CODE
More than one account has a specific account code.
How do I resolve this?
Each account will need a unique account code. Locate the accounts in question from the spreadsheet, then change the account code.
If the spreadsheet has already been uploaded, then the new account will need to change account code - if the existing account has the account code changed, it will be deleted and overridden.
DUPLICATED_ACCOUNT_NAME
DUPLICATED_ACCOUNT_NAME
More than one account has a specific account name.
How do I resolve this?
Each account will need a unique account name. locate the accounts in question from the spreadsheet, then change the account name of one or both accounts.
If the spreadsheet has already been uploaded, then ensure the account codes aren’t changed.
FIRST_DATE_NOT_START_OF_FINANCIAL_YEAR
FIRST_DATE_NOT_START_OF_FINANCIAL_YEAR
The first month doesn’t match the first month of the financial year.
How do I resolve this?
Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
FIRST_MONTH_MUST_BE_VALID_MONTH
FIRST_MONTH_MUST_BE_VALID_MONTH
The first month of the dates field isn’t a valid month in the spreadsheet.
How do I resolve this?
Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
FIRST_YEAR_INCORRECT_FORMAT
FIRST_YEAR_INCORRECT_FORMAT
The year that the spreadsheet has been set to start is invalid.
How do I resolve this?
It needs to be added as YYYY. Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
FIRST_YEAR_NOT_IN_RANGE
FIRST_YEAR_NOT_IN_RANGE
The first year data is being uploaded for is outside the 20 year range.
How do I resolve this?
The first year needs to fall within the last 20 years. If the organisation is older, opening balances need to be used for balance sheet accounts.
INVALID_CATEGORY
INVALID_CATEGORY
An account being uploaded has had an incorrect category set.
How do I resolve this?
Locate the account in question, and ensure the account category matches one of the 12 pre-set categories on the template.
MAIN_BANK_ACCOUNT_NAME_EMPTY
MAIN_BANK_ACCOUNT_NAME_EMPTY
The account set as the system account for Main Bank has no account name.
How do I resolve this?
Locate the Bank category in the Balance Sheet tab of the spreadsheet. Ensure there’s an account set as the system account for Main Bank, and that it has a name.
MAIN_BANK_INCORRECT_CATEGORY
MAIN_BANK_INCORRECT_CATEGORY
The account set as the system account for Main Bank is in the incorrect category. It will always need to be set against an account within the Bank category.
How do I resolve this?
In the spreadsheet, set an account within the Bank category to be the system account for Main Bank.
If this isn’t the first time uploading the organisation, you’ll need to make sure any accounts that might have moved category keep the same account code.
MAIN_BANK_MISSING
MAIN_BANK_MISSING
No account has been selected as the system account for Main Bank.
How do I resolve this?
In the spreadsheet, you’ll need to add at least one account to the Bank category, then set that account as the system account for Main Bank.
MAIN_BANK_MORE_THAN_ONE
MAIN_BANK_MORE_THAN_ONE
More than one account in the Bank category in the spreadsheet has been set as the Main Bank system account.
How do I resolve this?
In the spreadsheet, in the Bank category, ensure only one account has been set as the system account for Main Bank.
NOT_CONSECUTIVE_DATES
NOT_CONSECUTIVE_DATES
The dates on the template aren’t in a consecutive order.
How do I resolve this?
Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
ORGANISATION_NAME_ALREADY_IN_WORKSPACE
ORGANISATION_NAME_ALREADY_IN_WORKSPACE
The Excel organisation being uploaded has a name that matches the name of another organisation in the Futrli workspace.
How do I resolve this?
The account name will need to be updated.
PROFIT_AND_LOSS_DATES_MISSING
PROFIT_AND_LOSS_DATES_MISSING
The Profit & Loss tab has no dates in row 7.
How do I resolve this?
Use the financial year start month and year start to set the dates - even if that means having months that might be left empty. Date cells are grey, so not to be edited.
If cell formulas have been overridden, a new template might be required, but if the organisation has been uploaded before, make sure account codes match the original version.
PROFIT_AND_LOSS_SHEET_MISSING
PROFIT_AND_LOSS_SHEET_MISSING
No Profit & Loss tab has been uploaded in the spreadsheet.
How do I resolve this?
When uploading a spreadsheet, both the Profit & Loss and Balance Sheet tabs need to be uploaded.
If the Profit & Loss tab has been deleted, a new template will need to be downloaded.
RETAINED_EARNINGS_ACCOUNT_ACCOUNT_NAME_EMPTY
RETAINED_EARNINGS_ACCOUNT_ACCOUNT_NAME_EMPTY
The account set as the system account for Retained Earnings has no account name.
How do I resolve this?
Locate the Equity category in the Balance Sheet tab of the spreadsheet. Ensure there’s an account set as the system account for Retained Earnings, and that it has a name.
RETAINED_EARNINGS_ACCOUNT_INCORRECT_CATEGORY
RETAINED_EARNINGS_ACCOUNT_INCORRECT_CATEGORY
The account set as the system account for Retained Earnings is in the incorrect category. It will always need to be set against an account within the Equity category.
How do I resolve this?
In the spreadsheet, set an account within the Equity category to be the system account for Retained Earnings.
If this isn’t the first time uploading the organisation, you’ll need to make sure any accounts that might have moved category keep the same account code.
RETAINED_EARNINGS_ACCOUNT_MISSING
RETAINED_EARNINGS_ACCOUNT_MISSING
No account has been selected as the system account for Retained Earnings.
How do I resolve this?
In the spreadsheet, in the Equity category, you’ll need to have a Retained Earnings account.
If there’s no data to upload to retained earnings, the account will still need to exist.
RETAINED_EARNINGS_ACCOUNT_MORE_THAN_ONE
RETAINED_EARNINGS_ACCOUNT_MORE_THAN_ONE
More than one account in the Equity category in the spreadsheet has been set as the Retained Earnings system account.
How do I resolve this?
In the spreadsheet, in the Equity category, ensure only one account has been set as the system account for Retained Earnings.
SHEET_NOT_BALANCED
SHEET_NOT_BALANCED
The data being uploaded in the spreadsheet doesn’t balance.
How do I resolve this?
Only balanced organisations will successfully upload, so the data being uploaded needs to be reviewed.
TYPE_MUST_BE_ORGANISATION
TYPE_MUST_BE_ORGANISATION
The import type isn’t set to Organisation.
How do I resolve this?
In cell B1, the Import type will need to be set as Organisation.
VAT_CONTROL_ACCOUNT_ACCOUNT_NAME_EMPTY
VAT_CONTROL_ACCOUNT_ACCOUNT_NAME_EMPTY
The account set as the system account for VAT Control Account has no account name.
How do I resolve this?
Locate the Current Liabilities category in the Balance Sheet tab of the spreadsheet. Ensure there’s an account set as the system account for VAT Control Account, and that it has a name.
This system account is required for a Futrli organisation, but if the organisation in question is exempt from VAT, there’s no need to upload any data. Predictions in forecasts can also be set to 0% VAT.
VAT_CONTROL_ACCOUNT_INCORRECT_CATEGORY
VAT_CONTROL_ACCOUNT_INCORRECT_CATEGORY
The account set as the system account for VAT Control Account is in the incorrect category. It will always need to be set against an account within the Current Liabilities category.
How do I resolve this?
In the spreadsheet, set an account within the Current Liabilities category to be the system account for VAT Control Account.
If this isn’t the first time uploading the organisation, you’ll need to make sure any accounts that might have moved category keep the same account code. A VAT Control Account is required for a Futrli organisation.
If the organisation in question is exempt from VAT, a VAT Control Account will still need to be selected. No VAT data needs to be uploaded, predictions made in a Futrli forecast can be set as 0%.
VAT_CONTROL_ACCOUNT_MISSING
VAT_CONTROL_ACCOUNT_MISSING
No account has been selected as the system account for VAT Control Account.
How do I resolve this?
In the spreadsheet, you’ll need to add at least one account to the Current Liabilities category, then set that account as the system account for VAT Control Account. A VAT Control Account is required for a Futrli organisation.
If the organisation in question is exempt from VAT, a VAT Control Account will still need to be selected. No VAT data needs to be uploaded, predictions made in a Futrli forecast can be set as 0%.
VAT_CONTROL_ACCOUNT_MORE_THAN_ONE
VAT_CONTROL_ACCOUNT_MORE_THAN_ONE
More than one account in the Current Liabilities category in the spreadsheet has been set as the VAT Control Account system account.
How do I resolve this?
In the spreadsheet, in the Current Liabilities category, ensure only one account has been set as the system account for VAT Control Account.
VAT_FREQUENCY_IS_INVALID
VAT_FREQUENCY_IS_INVALID
The VAT scheme has either been incorrectly set, or not set.
How do I resolve this?
A VAT frequency is required for a Futrli organisation. If the organisation in question is exempt from VAT, a VAT scheme will still need to be selected. No VAT data needs to be uploaded, predictions made in a Futrli forecast can be set as 0%.
VAT_SCHEME_IS_INVALID
VAT_SCHEME_IS_INVALID
The VAT scheme has either been incorrectly set, or not set.
How do I resolve this?
A VAT scheme is required for a Futrli organisation. If the organisation in question is exempt from VAT, a VAT scheme will still need to be selected. No VAT data needs to be uploaded, predictions made in a Futrli forecast can be set as 0%.
YEAR_END_NOT_BALANCED
YEAR_END_NOT_BALANCED
The data being uploaded in the spreadsheet doesn’t balance.
How do I resolve this?
Only balanced organisations will successfully upload, so the data being uploaded needs to be reviewed.