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 those users who do not have a direct integration between FloQast and their ERP, FQ pulls account names and numbers from a COA 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, select the entity you wish to upload the COA for, click Reconciliation Settings, and then click Upload Chart of Accounts.
At this point, you will be prompted to select your COA file, and after that, you will be asked if you want to apply this COA to multiple 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, it is 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; if you place your file directly in this folder, FloQast will read it.
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 simply 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 support@floqast.com for assistance.
Alternatively, an updated COA can always be uploaded through FloQast using the steps described earlier. 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.