How to Upload a Chart of Accounts
Note: If you prefer to watch a video on this topic, please visit our FloQademy FAQ course!
For organizations without a direct integration between FloQast and their ERP, FQ pulls account names and numbers from a Chart of Accounts file stored in your Cloud Storage.
You can upload this COA file directly through FloQast. To do this, go to the Reconciliations tab within your Admin Settings, click the Reconciliation Settings button, select the entity you wish to upload the COA for, and then click Upload Chart of Accounts.
You will then be prompted to select your COA file. After choosing the appropriate file, you will then be asked if you want to apply this COA to additional entities. If multiple entities in your FloQast use the same COA, this is a great way to save some time, as you will not have to do this for each entity individually.
Your CoA in your Cloud Storage
Now that you have uploaded your COA through FloQast, the file is now stored in your cloud storage. To access the file in your cloud storage, go to your FloQast folders and navigate to FloQast > FQ - *Entity Name* > Chart of Accounts. In this folder, you will find your current COA file. This method can also be used to upload your COA by replacing the CoA file directly in your cloud storage. NOTE: Make sure that only ONE CoA file exists in this folder at a time.
If you ever need to add a new account, an easy way to do so will be to open this file in your cloud storage, add the new account, and save the file. Please make sure to use the same formatting as previous accounts when adding a new one, as FloQast uses a custom script to read your COA. If you ever do need to change the formatting of your COA, please reach out to email@example.com for assistance.
Alternatively, an updated COA can always be uploaded through FloQast using the earlier steps. If you are updating a COA for multiple entities at once, a hybrid of these methods is probably best: Update one COA through your Cloud Storage, then upload that COA through FloQast and apply it to multiple entities.
Troubleshooting tip: If you add an account to your COA file but don't see the account in the Add Account dropdown, please try refreshing your browser. Sometimes, due to browser caching, you may need to refresh your browser before the new account will be visible.