Trial Balance Upload
If you receive the “Invalid reconciliation name/number” error, the reconciliations listed in the specified rows could not be found on your Chart of Accounts file. This is a list of accounts supplied to FloQast via an Excel/CSV file. Each time you upload a template, your reconciliations are cross-referenced across this list to ensure everything is still active and valid.
If an account on the reconciliation template is missing from the COA, it will need to be added to the COA file for the template to apply. Once added, you can upload the updated COA file under the Manage Reconciliations tab in the Admin settings, then retry uploading the revised reconciliation template.
Your Chart of Accounts file can be found in the following folder path in your Cloud Storage:
FloQast > FQ - [Entity Name] > Chart of Accounts
If you receive the “Invalid reconciliation name/number" error, the account(s) in the specified row(s) is not recognized in your Netsuite Chart of Accounts. If this is a recently added account, Admins and Managers can run the Sync General Ledger function under the Manage Entities tab in the Admin settings. This function pings your Netsuite environment for any new accounts or subsidiaries. Once complete, try re-uploading the updated reconciliation template.
If this was a preexisting reconciliation that is now being returned as invalid, it’s possible that the account was deactivated in Netsuite. In this case, we recommend deleting it as a reconciliation by removing that row from your template.
If you receive the “Invalid reconciliation name/number” error, the account in that row is not recognized from your Intacct Chart of Accounts. It is possible that your team has deactivated this account in Intacct. Once an account is marked inactive in Intacct, it is no longer a valid reconciliation in FloQast. You can check your Intacct COA to confirm that the account is inactive. If so, we recommend removing the account as a reconciliation by deleting the row from your template.