Trial Balance Upload
If you receive the “Invalid Rec Name” error, the reconciliations listed in the specified rows could not be found on your Chart of Accounts file. This is a list of accounts that you have 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. Therefore, if an account is missing from the COA, you’ll simply need it to be added to the COA file in order for it to be recognized. 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 here in your Cloud Storage:
FloQast > FQ - Entity Name > Chart of Accounts
If you receive the “Invalid Rec Name” error, this means that the account in that row 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 (insert link) 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 as well by removing that row from your template.
If you receive the “Invalid Rec Name” error, this means 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 indeed inactive. If it is, we recommend removing the account as a reconciliation by deleting the row from your template.