Once a user has saved supporting documents in the company cloud storage system, these documents can tie to the General Ledger automatically by adding a ‘#FQ-account number’ to the right of the reconciling balance. This ‘#FQ’ anchor replaces the traditional use of a ‘TB’ on a reconciliation. Note: you cannot use the same hashtag reference multiple times for one account within the same folder. FloQast will not know which balance to pull in as the correct balance.
In the Account Reconciliations module in FloQast, the ‘Reconciled Balance’ amount comes from the Excel document saved in cloud storage and the ‘Per GL,’ 'Per NetSuite' or 'Per Intacct' column comes directly from your Trial Balance/ERP System. If the balances change in your workbook or in the Trial Balance, use the refresh button in FloQast to update.
FloQast will re-run all reconciliations automatically in the current period on a nightly basis.
Note: The document size restriction is 100MB for Checklist uploads and the size restrictions are provider-dependent for Reconciliations (Box ~50MB, OneDrive ~250MB, Dropbox ~150MB).