The Subledger API Transaction Matching process allows you to programmatically push transaction information from your subledger, bank, or other source systems into FloQast. You will then use FloQast's AutoRec Matching functionality to review and match transactions to your ERP data. To implement this process, you and/or your technical team must leverage two publicly available FloQast APIs.
You will first enable the Subledger Matching feature on the applicable Reconciliations within FloQast.
Once your account has been enabled for FloQast API services, you must create an API key. Additional information on API key generation can be found HERE. Armed with your API key, you can begin following the steps listed below:
-
Access your FloQast Reconciliation data:
Begin by pulling down reconciliation data from within FloQast so that we can properly identify the reconciliation accounts by their internal IDs. This can be done via a public reconciliations API endpoint with your valid API key.
-
Match the FloQast Reconciliation IDs with transactions from your subledger source systems:
The data you receive from Step 1 includes not just IDs but also account names, system IDs, and additional identifying information. This data allows you and/or your team to map the proper subledger transactions to their respective FloQast reconciliation IDs.
-
Organize the data:
Whether referencing data from one subledger application or multiple, FloQast requires that the data be prepared into a specific format. This reduces the likelihood of errors when ingesting and processing data. This format can be found on our developer documentation HERE.
-
Send the data into FloQast:
Once your data has been organized into our API’s required format, you can call our subledger transactions API endpoint to accept and process the data.- When sending in transactions for accounts receivable or accounts payable, we recommend that you send all open transactions so that the aging reports capture all currently open invoices and not just the invoices that occurred during the set month.
-
Repeat as necessary:
This is a programmatic process that reduces the need to manually upload files repeatedly. You can repeat this process as frequently as your business needs require. We typically recommend clients to start with a refresh frequency of 1 hour. If you currently use Cloud Connect today, we recommend sending us subledger data on the same cadence as the Trial Balance.
A high-level overview of the process described above can also be found in the attached graphic:
- If you have any additional questions about functionality, implementation, or expected behaviors, please feel free to reach out to your ASM.