The process for uploading Budget files into FloQast was developed on the foundation of the current TB upload process, meaning that we will support various Budget file types so long as certain requirements are met for scripting purposes.
The Budget File needs to meet these requirements (these items are non-negotiable for the file requirements):
- In XLSX (preferred) or CSV format
- One column for Account Number
- One column for Account Description
- One Column for Monthly Balance*
- The Budget natural account balance signs must match actuals source (i.e. Credits are Negatives and Debits are Positives)
- Direct API only: One Column for Department Name (NetSuite and Intacct only), or Vendor Name (Intacct only)**
- TB Upload only: Additional Columns that include the appropriate budgetary levels (i.e., Entity code, Department, Cost/Profit Center)***
- In a format where the columns above do not change month-over-month.
- All Budget Account Numbers must match an existing Account Number in the company’s TB, if an account number does not exist then the Account Description will be used.
** Department or Vendor dimensions only need to be included if the customer has included dimensions within their B2A report via the Dimension Insertion Tool within Flux Settings. Note the customer should include the department name and not the department ID.
*** TB Upload client budgetary files must include all relevant budget information which will be concatenated with the account number through the GL Programs portion of the Flux Super Page. This relevant budget information must also match their actuals data within their TB.
Budget File Requirements: 1 File Per Month
If you provide a Budget file that has all 12 months in one file, we will need you to break out the report into 12 separate files and resend (operates the same as the current Trial Balance functionality for Flux Analysis). The most important thing is to make sure that the Account #, Account Name, Dimension Name (if applicable), and Balance columns are consistent across all 12 files as scripts are utilized to extract the data.
Budget File Examples
FloQast utilizes custom scripts to extract data from the existing Budget files so long as they meet the requirements outlined above. The following screenshots are examples of what acceptable Budget formats look like for both NetSuite/Intacct customers and TBU customers.
NetSuite and Intacct:
TB Upload: