Download OpenAPI specification:Download
As a pioneering force within the industry, FloQast consistently strives to discover innovative avenues through which our customers can engage with our cutting-edge application. We empower you to extract comprehensive analytics from FloQast while seamlessly integrating reconciliation balances by introducing these latest endpoints. We are pleased to offer these new services and look forward to their transformative effect on your close process as they are poised to unlock unprecedented time savings for you and your organization.
Requests to FloQast's API must be authenticated using an API key.
The API key must be included in the x-api-key
header of each request and can be generated in the FloQast application.
The key should also have the correct permissions to access the API endpoints you are using.
Directions to generate an API key
This API endpoint enables fetching a collection of checklists performed during a specific month and year. By providing the desired month and year as parameters, the API response narrows down the results to the exact period, facilitating the analysis of financial data and tracking the progress of checklist efforts." And also include information about TLCs.
filter[month] | string Example: filter[month]=march Specifies the month for which the checklists should be retrieved. Valid values are the names of the months. Must be used in conjunction with filter[year]. Required if neither filter[modifiedBefore] nor filter[modifiedSince] is provided. |
filter[year] | integer Example: filter[year]=2023 Specifies the year for which the checklists should be retrieved. It should be a four-digit numerical value. Must be used in conjunction with filter[month]. Required if neither filter[modifiedBefore] nor filter[modifiedSince] is provided. |
filter[modifiedBefore] | string <date> Example: filter[modifiedBefore]=2021-01-01 Sets the cutoff date for retrieving checklists, including only those modified before (but not including) the specified date. The date must be in the format YYYY-MM-DD. While filter[modifiedBefore] is required if filter[month] and filter[year] are not provided, it can also be used in conjunction with these filters for more specific queries. |
filter[modifiedSince] | string <date> Example: filter[modifiedSince]=2020-12-31 Sets the cutoff date for retrieving checklists, including only those modified on or after the specified date. The date must be in the format YYYY-MM-DD. While filter[modifiedSince] is required if filter[month] and filter[year] are not provided, it can also be used in conjunction with these filters for more specific queries. |
filter[entityIds] | string Example: filter[entityIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated entity ids for which the checklists should be retrieved. |
filter[workflowIds] | string Example: filter[workflowIds]=5e94d5b63f557b001420baa1,5e94d5b63f557b001420baa2 Comma separated workflow ids for which the checklists should be retrieved |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (ChecklistAnalyticsModel) Array of Checklists | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "_id": "5e94d5b63f557b001420bbe3",
- "entity": {
- "_id": "5e94d5b63f557b001420bbe2",
- "name": "John Smith's company",
- "workflow": {
- "_id": "5e94d5b63f557b001420bbe1",
- "name": "Close"
}, - "details": "Client ID: 123ABC"
}, - "folder": {
- "_id": "5e94d5b63f557b001420bbe4",
- "name": "Accounts Receivable"
}, - "description": "1200 Accounts Receivable",
- "itemStatus": "On Track",
- "frequency": "Monthly",
- "frequencyMonths": [
- "june"
], - "signatures": [
- {
- "assignedTo": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "signedBy": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "signedDate": "2019-08-24T14:15:22Z",
- "dueDate": "2019-08-24T14:15:22Z",
- "estimatedTimeMinutes": 90,
- "group": "preparer"
}
], - "reviewNotes": [
- {
- "author": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "assignedTo": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "message": "string",
- "created": "2021-01-01T00:00:00.000Z",
- "comments": [
- {
- "author": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "message": "string",
- "created": "2021-01-01T00:00:00.000Z"
}
]
}
], - "tags": [
- {
- "name": "non_close"
}
], - "updatedAt": "2021-01-01T00:00:00.000Z",
- "period": {
- "month": "december",
- "year": "2023"
}
}
], - "links": {
- "self": "/api/v1/analytics/checklists?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/analytics/checklists?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe6"
}
}
This API endpoint enables fetching a collection of reconciliations performed during a specific month and year. By providing the desired month and year as parameters, the API response narrows down the results to the exact period, facilitating the analysis of financial data and tracking the progress of reconciliation efforts." And also include information about TLCs.
filter[month] | string Example: filter[month]=march Specifies the month for which the reconciliations should be retrieved. Valid values are the names of the months. Must be used in conjunction with filter[year]. Required if neither filter[modifiedBefore] nor filter[modifiedSince] is provided. |
filter[year] | integer Example: filter[year]=2023 Specifies the year for which the reconciliations should be retrieved. It should be a four-digit numerical value. Must be used in conjunction with filter[month]. Required if neither filter[modifiedBefore] nor filter[modifiedSince] is provided. |
filter[modifiedBefore] | string <date> Example: filter[modifiedBefore]=2021-01-01 Sets the cutoff date for retrieving reconciliations, including only those modified before (but not including) the specified date. The date must be in the format YYYY-MM-DD. While filter[modifiedBefore] is required if filter[month] and filter[year] are not provided, it can also be used in conjunction with these filters for more specific queries. |
filter[modifiedSince] | string <date> Example: filter[modifiedSince]=2020-12-31 Sets the cutoff date for retrieving reconciliations, including only those modified on or after the specified date. The date must be in the format YYYY-MM-DD. While filter[modifiedSince] is required if filter[month] and filter[year] are not provided, it can also be used in conjunction with these filters for more specific queries. |
filter[entityIds] | string Example: filter[entityIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated entity ids for which the reconciliations should be retrieved. |
filter[journalSource] | string Example: filter[journalSource]=SUB_LEDGER journalSource for which the reconciliations should be retrieved. |
filter[internalIds] | string Example: filter[internalIds]=123456, 78910 Comma seperated gl internalIds for which the reconciliations should be retrieved. |
filter[workflowIds] | string Example: filter[workflowIds]=5e94d5b63f557b001420baa1,5e94d5b63f557b001420baa2 Comma separated workflow ids for which the reconciliations should be retrieved. |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (Reconciliation_AnalyticsModel) Array of Reconciliation Analytics | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "_id": "5e94d5b63f557b001420bbe3",
- "entity": {
- "_id": "5e94d5b63f557b001420bbe2",
- "name": "John Smith's company",
- "workflow": {
- "_id": "5e94d5b63f557b001420bbe1",
- "name": "Close"
}, - "details": "Client ID: 123ABC"
}, - "folder": {
- "_id": "5e94d5b63f557b001420bbe4",
- "name": "Accounts Receivable"
}, - "spreadsheet": {
}, - "threshold": {
- "rules": [
- {
- "type": "fixed",
- "value": 1
}
], - "operator": "or",
- "isDefault": true
}, - "frequency": "Monthly",
- "frequencyMonths": [
- "june"
], - "type": "SINGLE",
- "name": "1200 Accounts Receivable",
- "sourceBalance": "30000",
- "glBalance": "39.8",
- "gl": {
- "internalId": "1234",
- "internalPeriod": "334",
- "provider": "TB",
- "TB": {
- "internalPeriod": "334"
}, - "NETSUITE": {
- "internalPeriod": "334",
- "internalId": "1234",
- "parentCompany": "3",
- "reportingBookId": "4",
- "subsidiaries": [
- {
- "name": "name",
- "internalId": "334"
}
]
}, - "INTACCT": {
- "internalPeriod": "334",
- "internalId": "1234",
- "reportingBookId": "4",
- "adjustmentBookIds": [
- "1234"
], - "excludeReportingBook": true,
- "locations": [
- {
- "internalId": "1234",
- "name": "germany",
- "parentId": "1234",
- "excludeChildLocations": true
}
]
}, - "QBO": {
- "internalPeriod": "334",
- "internalId": "1234"
}, - "MSDYNAMICS": {
- "internalPeriod": "334",
- "internalId": "1234"
}, - "SAP": {
- "internalPeriod": "334",
- "internalId": "1234",
- "currencyType": "COMPANY",
- "ledger": "0L",
- "companyCodes": [
- "1234"
]
}, - "XERO": {
- "internalPeriod": "334",
- "internalId": "1234"
}
}, - "subledger": {
- "balance": "39.8"
}, - "journalSource": "GENERAL_LEDGER",
- "reconcilingItems": {
- "sumTotal": 10,
- "items": [
- {
- "balance": 10,
- "description": "Reconciled item description",
- "itemDate": "2021-01-01T00:00:00.000Z"
}
]
}, - "difference": "-149964.2",
- "currency": {
- "code": "USD",
- "symbol": "$",
- "name": "US Dollar",
- "decimalDigits": 2
}, - "updatedAt": "2021-01-01T00:00:00.000Z",
- "period": {
- "month": "december",
- "year": "2023"
}, - "itemStatus": "On Track",
- "lastBalanceChange": "2021-01-01T00:00:00.000Z",
- "tags": [
- {
- "name": "non_close"
}
], - "signatures": [
- {
- "assignedTo": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "signedBy": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "signedDate": "2019-08-24T14:15:22Z",
- "dueDate": "2019-08-24T14:15:22Z",
- "estimatedTimeMinutes": 90,
- "group": "preparer"
}
], - "accounts": [
- {
- "name": "1200 Accounts Receivable",
- "sourceBalance": "30000",
- "glBalance": "39.8",
- "reconcilingItems": {
- "sumTotal": 10,
- "items": [
- {
- "balance": 10,
- "description": "Reconciled item description",
- "itemDate": "2021-01-01T00:00:00.000Z"
}
]
}, - "difference": "-149964.2"
}
], - "reviewNotes": [
- {
- "author": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "assignedTo": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "message": "string",
- "created": "2021-01-01T00:00:00.000Z",
- "comments": [
- {
- "author": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "message": "string",
- "created": "2021-01-01T00:00:00.000Z"
}
]
}
]
}
], - "links": {
- "self": "/api/v1/analytics/reconciliations?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/analytics/reconciliations?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=63b88f2cb1f05200179e7857"
}
}
This API endpoint retrieves audit logs for all API keys within a top-level client, providing a comprehensive overview of usage. It supports querying logs for a specific user's API key ID to facilitate focused analysis.
filter[startDate] | string Example: filter[startDate]=2023-11-01 Specifies the start date (inclusive) for logs to be retrieved. The date must be in the ISO 8601 format like YYYY-MM-DD. |
filter[endDate] | string Example: filter[endDate]=2023-12-01 Specifies the end date (inclusive) for logs to be retrieved. The date must be in the ISO 8601 format like YYYY-MM-DD. |
filter[userApiKey._id] | string Example: filter[userApiKey._id]=5e94d5b63f557b001420bbe3 Specifies the user API key ID to filter logs by. |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (AuditTrailModel) Array of Audit Trail items | |||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "_id": "5e94d5b63f557b001420bbe3",
- "uri": "/api/v1/reconciliations",
- "method": "GET",
- "sourceIp": "123.45.6.78",
- "meta": {
- "status": "400",
- "service": "Reconciliations",
- "queryParameters": {
- "filter[modifiedBefore]": "2021-01-01",
- "page[size]": "500"
}, - "error": "Error message"
}, - "userApiKey": {
- "_id": "5e94d5b63f557b001420bab1",
- "name": "API Token"
}, - "createdAt": "2021-01-01T00:00:00.000Z"
}
], - "links": {
- "self": "/api/v1/audit-trail?filter[startDate]=2023-11-01&filter[endDate]=2023-12-01&page[size]=12000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/audit-trail?filter[startDate]=2023-11-01&filter[endDate]=2023-12-01&page[size]=12000&page[cursor]=5e94d5b63f557b001420bbe6"
}
}
This API endpoint retrieves amortization entries for a designated month and year, providing a concise overview of amortization activities within the specified period. It facilitates access to detailed records of amortization transactions, which include the systematic allocation of costs for intangible assets over their useful life, enabling thorough analysis and financial tracking.
filter[month] required | string Example: filter[month]=march Specifies the month for which the amortization should be retrieved. Valid values are the names of the months. Must be used in conjunction with filter[year]. |
filter[year] required | integer Example: filter[year]=2023 Specifies the year for which the amortization should be retrieved. It should be a four-digit numerical value. Must be used in conjunction with filter[month]. |
filter[entityIds] | string Example: filter[entityIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated entity ids for which the amortizations should be retrieved. |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (AmortizationModel) Array of Amortization Items | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe3",
- "entityId": "5e94d5b63f557b001420bbe2",
- "reconciliationId": "5e94d5b63f557b001420bbe3",
- "period": {
- "month": "january",
- "year": 2023
}, - "assetAccount": {
- "name": "Software Development Costs",
- "number": "2210"
}, - "expenseAccount": {
- "name": "Amortization Expense",
- "number": "48"
}, - "vendor": "OfficeTech Supplies Ltd.",
- "description": "Monthly amortization for software development costs",
- "invoiceNumber": "INV-20230315",
- "department": "Finance Department",
- "currentExpense": {
- "amount": 153.37
}, - "customFields": {
- "CustomKey1": "SD-2023-Mar",
- "CustomKey2": "SW-78910"
}, - "journalEntry": {
- "id": "5e94d5b63f557b001420bbe3",
- "status": "POSTED",
- "timestamp": "2024-03-29T21:36:43.309+00:00"
}
}
], - "links": {
- "self": "/api/v1/amortization/items?filter[month]=january&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/amortization/items?filter[month]=january&filter[year]=2023&page[size]=1000&page[cursor]=63b88f2cb1f05200179e7857"
}
}
This API endpoint takes a reconciliationId and journal entry status information, and updates amortization reconciliation entries.
reconciliationId required | string Example: 5e94d5b63f557b001420bbe3 Id of reconciliation |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
object | |||||||
|
success | boolean |
{- "data": {
- "journalEntryStatus": "POSTED",
- "journalEntryId": "615bcdc00000000000000302",
- "journalEntryTimestamp": "2024-03-29T21:36:43.309+00:00"
}
}
{- "success": true
}
This API endpoint can take reconciliationIds and journal entry status, and gets amortization reconciliations entries.
filter[reconciliationIds] | string Example: filter[reconciliationIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated reconciliation ids for which the reconciliations should be retrieved |
filter[journalEntryStatus] | string Example: filter[journalEntryStatus]=PROCESSING Status of journal entry for which the reconciliations should be retrieved |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (AmortizingReconciliationModel) Array of Reconciliation Items | |||||||||||
Array
| |||||||||||
object | |||||||||||
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe1",
- "entityId": "5e94d5b63f557b001420bbe2",
- "journalEntryId": "5e94d5b63f557b001420bbe3",
- "journalEntryStatus": "NOT_POSTED",
- "journalEntryTimestamp": "2020-04-13T00:00:00Z"
}
], - "links": {
- "self": "/api/v1/amortization/reconciliations?filter[reconciliationIds]=615bcdc00000000000020000,615bcdc00000000000020001&filter[journalEntryStatus]=PROCESSING&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/amortization/reconciliations?filter[reconciliationIds]=615bcdc00000000000020000,615bcdc00000000000020001&filter[journalEntryStatus]=PROCESSING&page[size]=1000&page[cursor]=63b88f2cb1f05200179e7857"
}
}
This API endpoint retrieves depreciation entries for a designated month and year, providing a concise overview of depreciation activities within the specified period. It enables access to detailed records associated with the depreciation of tangible assets, facilitating thorough financial tracking and analysis.
filter[month] required | string Example: filter[month]=march Specifies the month for which the depreciation should be retrieved. Valid values are the names of the months. Must be used in conjunction with filter[year]. |
filter[year] required | integer Example: filter[year]=2023 Specifies the year for which the depreciation should be retrieved. It should be a four-digit numerical value. Must be used in conjunction with filter[month]. |
filter[entityIds] | string Example: filter[entityIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated entity ids for which the depreciations should be retrieved. |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (DepreciationModel) Array of Depreciation Items | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe3",
- "entityId": "5e94d5b63f557b001420bbe2",
- "reconciliationId": "5e94d5b63f557b001420bbe3",
- "period": {
- "month": "january",
- "year": 2023
}, - "assetAccount": {
- "name": "Vehicle Fleet",
- "number": "1120"
}, - "vendor": "Superior Vehicles Inc.",
- "description": "Depreciation of company vehicles",
- "invoiceNumber": "SV-20230115",
- "department": "Logistics",
- "assetId": "5e94d5b63f557b001420bbe3",
- "accumulatedDepreciationAccount": {
- "name": "Accumulated Depreciation - Vehicle Fleet",
- "number": "1121"
}, - "expenseAccount": {
- "name": "Depreciation Expense - Vehicles",
- "number": "49"
}, - "customFields": {
- "CustomKey1": "2020-01-10",
- "CustomKey2": "VanMaster 3000"
}, - "journalEntry": {
- "id": "5e94d5b63f557b001420bbe3",
- "status": "POSTED",
- "timestamp": "2024-03-29T21:36:43.309+00:00"
}, - "currentExpense": {
- "amount": 2500
}
}
], - "links": {
- "self": "/api/v1/depreciation/items?filter[month]=january&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/depreciation/items?filter[month]=january&filter[year]=2023&page[size]=1000&page[cursor]=63b88f2cb1f05200179e7857"
}
}
This API endpoint takes a reconciliationId and journal entry status information, and updates depreciation reconciliations entries.
reconciliationId required | string Example: 5e94d5b63f557b001420bbe3 Id of reconciliation |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
object | |||||||
|
success | boolean |
{- "data": {
- "journalEntryStatus": "POSTED",
- "journalEntryId": "615bcdc00000000000000302",
- "journalEntryTimestamp": "2024-03-29T21:36:43.309+00:00"
}
}
{- "success": true
}
This API endpoint can take reconciliationIds and journal entry status, and gets depreciation reconciliations entries.
filter[reconciliationIds] | string Example: filter[reconciliationIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated reconciliation ids for which the reconciliations should be retrieved |
filter[journalEntryStatus] | string Example: filter[journalEntryStatus]=PROCESSING Status of journal entry for which the reconciliations should be retrieved |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (DepreciatingReconciliationModel) Array of Reconciliation Items | |||||||||||
Array
| |||||||||||
object | |||||||||||
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe1",
- "entityId": "5e94d5b63f557b001420bbe2",
- "journalEntryId": "5e94d5b63f557b001420bbe3",
- "journalEntryStatus": "NOT_POSTED",
- "journalEntryTimestamp": "2020-04-13T00:00:00Z"
}
], - "links": {
- "self": "/api/v1/depreciation/reconciliations?filter[reconciliationIds]=615bcdc00000000000020000,615bcdc00000000000020001&filter[journalEntryStatus]=PROCESSING&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/depreciation/reconciliations?filter[reconciliationIds]=615bcdc00000000000020000,615bcdc00000000000020001&filter[journalEntryStatus]=PROCESSING&page[size]=1000&page[cursor]=63b88f2cb1f05200179e7857"
}
}
This API endpoint returns chart of accounts data used in FloQast.
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
filter[entityIds] | string Example: filter[entityIds]=648118111cc2ef0019cf0868,648118111cc2ef0019cf0867 Comma separated entity ids for which the chart of accounts should be retrieved. |
Array of objects Array of Chart Of Accounts Data | |||||||||||||
Array
|
{- "data": [
- {
- "entityId": "648118111cc2ef0019cf0868",
- "error": "Error retrieving chart of accounts"
}, - {
- "entityId": "648118111cc2ef0019cf0867",
- "accounts": [
- {
- "number": "35121",
- "name": "Cash"
}
]
}
]
}
This API endpoint takes chart of accounts data and uploads it to a user’s FloQast tenant. Use this endpoint for operations such as adding, editing, and removing accounts inside of FloQast.
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects Array of Chart Of Accounts Data | |||||||||||
Array
|
Array of objects Array of Chart Of Accounts Data | |||||||||||||||
Array
|
{- "data": [
- {
- "entityId": "5e94d5b63f557b001420bbe3",
- "accounts": [
- {
- "number": "35123",
- "name": "Cash"
}
]
}
]
}
{- "data": [
- {
- "entityId": "648118111cc2ef0019cf0868",
- "success": false,
- "accounts": [
- {
- "number": "35123",
- "name": "Cash"
}
], - "error": "Failed to validate entityId"
}, - {
- "entityId": "648118111cc2ef0019cf0867",
- "success": true,
- "accounts": [
- {
- "number": "35121",
- "name": "Cash"
}
]
}
]
}
This API endpoint enables fetching a collection of entities within a given FloQast tenant. Optional query parameters can either narrow the API response or provide pagination functionality.
filter[name] | string Example: filter[name]=Entity Name Specifies the name of the entity. Cannot be used with page[number]. |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[number] | integer Example: page[number]=5 Indicates the page number of the results to retrieve. This parameter is used to paginate through lists of items. Cannot be used with filter[name]. |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (Entity) | |||||||
Array
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe3",
- "name": "TB1 5e94d5b63f557b001420bbe3",
- "details": "Client ID: 123ABC"
}
]
}
This API endpoint enables fetching a single specific entity with its unique identifier.
id required | string The ID of the entity |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (Entity) | |||||||
Array
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe3",
- "name": "TB1 5e94d5b63f557b001420bbe3",
- "details": "Client ID: 123ABC"
}
]
}
This API endpoint enables fetching a collection of checklists performed during a specific month and year. By providing the desired month and year as parameters, the API response narrows down the results to the exact period, facilitating the analysis of financial data and tracking the progress of checklist efforts.
filter[month] required | string Example: filter[month]=march Specifies the month for which the checklists should be retrieved. Valid values are the names of the months. Must be used in conjunction with filter[year]. |
filter[year] required | integer Example: filter[year]=2023 Specifies the year for which the checklists should be retrieved. It should be a four-digit numerical value. Must be used in conjunction with filter[month]. |
filter[templateId] | string Example: filter[templateId]=5e94d5b63f557b001420bbb1 templateId for which the checklists should be retrieved. |
filter[description] | string Example: filter[description]=Generate balance sheet Specifies a description for which checklists should be retrieved. |
filter[entityId] | string Example: filter[entityId]=656abc949ec04a00096b56d7 Specifies the entity for which the checklists should be retrieved |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (ChecklistModel) Array of Checklists | |||||||||||||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe3",
- "templateId": "5e94d5b63f557b001420bbe4",
- "description": "Record accrued property tax. Verify monthly accrual is 1/12th of prior year expense.",
- "entityId": "656abc949ec04a00096b56d7",
- "period": {
- "month": "december",
- "year": "2023"
}, - "signatures": [
- {
- "id": "5e94d5b63f557b001420bbe5",
- "group": "preparer",
- "signedDate": "2021-01-01T00:00:00.000Z",
- "signedBy": "5e94d5b63f557b001420bba5",
- "assignedTo": "5e94d5b63f557b001420bba5",
- "dueDate": "2021-01-01T00:00:00.000Z",
- "metaData": {
- "token": "5e94d5b63f557b001420bbe6"
}
}
], - "tags": [
- {
- "name": "non_close"
}
]
}
], - "links": {
- "self": "/api/v1/checklists?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/checklists?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe6"
}
}
This API endpoint updates the signature status of a checklist.
checklistId required | string The ID of the checklist item |
signatureId | string If provided, only signoff on this signature |
userId | string If provided, only signoff on signatures assigned to this user |
group | string Enum: "preparer" "reviewer" "unassigned" If provided, only signoff on signatures in this group |
setSignedOff | boolean The status of the signature. Defaults to true |
id | string Id of checklist | ||||||||||||||||||
templateId | string Template Id of checklist | ||||||||||||||||||
description | string | ||||||||||||||||||
entityId | string | ||||||||||||||||||
object | |||||||||||||||||||
| |||||||||||||||||||
Array of objects | |||||||||||||||||||
Array
| |||||||||||||||||||
Array of objects | |||||||||||||||||||
Array
|
{- "signatureId": "5e94d5b63f557b001420bbe5",
- "userId": "5e94d5b63f557b001420bbe6",
- "group": "preparer",
- "setSignedOff": true
}
{- "id": "5e94d5b63f557b001420bbe3",
- "templateId": "5e94d5b63f557b001420bbe4",
- "description": "Record accrued property tax. Verify monthly accrual is 1/12th of prior year expense.",
- "entityId": "656abc949ec04a00096b56d7",
- "period": {
- "month": "december",
- "year": "2023"
}, - "signatures": [
- {
- "id": "5e94d5b63f557b001420bbe5",
- "group": "preparer",
- "signedDate": "2021-01-01T00:00:00.000Z",
- "signedBy": "5e94d5b63f557b001420bba5",
- "assignedTo": "5e94d5b63f557b001420bba5",
- "dueDate": "2021-01-01T00:00:00.000Z",
- "metaData": {
- "token": "5e94d5b63f557b001420bbe6"
}
}
], - "tags": [
- {
- "name": "non_close"
}
]
}
This API endpoint enables fetching a collection of reconciliations performed during a specific month and year. By providing the desired month and year as parameters, the API response narrows down the results to the exact period, facilitating the analysis of financial data and tracking the progress of reconciliation efforts." And also include information about TLCs.
filter[month] | string Example: filter[month]=march Specifies the month for which the reconciliations should be retrieved. Valid values are the names of the months. Must be used in conjunction with filter[year]. Required if neither filter[modifiedBefore] nor filter[modifiedSince] is provided. |
filter[year] | integer Example: filter[year]=2023 Specifies the year for which the reconciliations should be retrieved. It should be a four-digit numerical value. Must be used in conjunction with filter[month]. Required if neither filter[modifiedBefore] nor filter[modifiedSince] is provided. |
filter[modifiedBefore] | string <date> Example: filter[modifiedBefore]=2021-01-01 Sets the cutoff date for retrieving reconciliations, including only those modified before (but not including) the specified date. The date must be in the format YYYY-MM-DD. While filter[modifiedBefore] is required if filter[month] and filter[year] are not provided, it can also be used in conjunction with these filters for more specific queries. |
filter[modifiedSince] | string <date> Example: filter[modifiedSince]=2020-12-31 Sets the cutoff date for retrieving reconciliations, including only those modified on or after the specified date. The date must be in the format YYYY-MM-DD. While filter[modifiedSince] is required if filter[month] and filter[year] are not provided, it can also be used in conjunction with these filters for more specific queries. |
filter[entityIds] | string Example: filter[entityIds]=5e94d5b63f557b001420bbe1,5e94d5b63f557b001420bbe2 Comma separated entity ids for which the reconciliations should be retrieved. |
filter[workflowIds] | string Example: filter[workflowIds]=5e94d5b63f557b001420baa1,5e94d5b63f557b001420baa2 Comma separated workflow ids for which the reconciliations should be retrieved. |
filter[journalSource] | string Example: filter[journalSource]=SUB_LEDGER journalSource for which the reconciliations should be retrieved. |
filter[internalIds] | string Example: filter[internalIds]=123456, 78910 Comma seperated gl internalIds for which the reconciliations should be retrieved. |
page[size] | integer Example: page[size]=12000 The number of items to return. If not specified, the API will return a default of 30,000 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (ReconciliationModel) Array of Reconciliations | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
{- "data": [
- {
- "_id": "5e94d5b63f557b001420bbe3",
- "entity": {
- "_id": "5e94d5b63f557b001420bbe2",
- "name": "John Smith's company",
- "workflow": {
- "name": "Close"
}
}, - "type": "SINGLE",
- "name": "1200 Accounts Receivable",
- "updatedAt": "2024-01-01T00:00:00.000Z",
- "glBalance": "39.8",
- "gl": {
- "internalId": "1234",
- "internalPeriod": "334",
- "provider": "TB",
- "TB": {
- "internalPeriod": "334"
}, - "NETSUITE": {
- "internalPeriod": "334",
- "internalId": "1234",
- "parentCompany": "3",
- "reportingBookId": "4",
- "subsidiaries": [
- {
- "name": "name",
- "internalId": "334"
}
]
}, - "INTACCT": {
- "internalPeriod": "334",
- "internalId": "1234",
- "reportingBookId": "4",
- "adjustmentBookIds": [
- "1234"
], - "excludeReportingBook": true,
- "locations": [
- {
- "internalId": "1234",
- "name": "germany",
- "parentId": "1234",
- "excludeChildLocations": true
}
]
}, - "QBO": {
- "internalPeriod": "334",
- "internalId": "1234"
}, - "MSDYNAMICS": {
- "internalPeriod": "334",
- "internalId": "1234"
}, - "SAP": {
- "internalPeriod": "334",
- "internalId": "1234",
- "currencyType": "COMPANY",
- "ledger": "0L",
- "companyCodes": [
- "1234"
]
}, - "XERO": {
- "internalPeriod": "334",
- "internalId": "1234"
}
}, - "currency": {
- "code": "USD",
- "symbol": "$",
- "name": "US Dollar",
- "decimalDigits": 2
}, - "accounts": [
- {
- "name": "1200 Accounts Receivable",
- "glBalance": "39.8"
}
], - "period": {
- "month": "december",
- "year": "2023"
}, - "journalSource": "GENERAL_LEDGER",
- "templateId": "5e94d5b63f557b001420bbe3",
- "tags": [
- {
- "name": "non_close"
}
], - "signatures": [
- {
- "assignedTo": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "signedBy": {
- "name": {
- "first": "John",
- "last": "Smith"
}, - "email": "john.smith@example.com"
}, - "signedDate": "2019-08-24T14:15:22Z",
- "dueDate": "2019-08-24T14:15:22Z",
- "estimatedTimeMinutes": 90,
- "group": "preparer"
}
]
}
], - "links": {
- "self": "/api/v1/reconciliations?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/reconciliations?filter[month]=march&filter[year]=2023&page[size]=1000&page[cursor]=63b88f2cb1f05200179e7857"
}
}
Get information about the current user and token
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
object | |||||
|
{- "data": {
- "apiKeyId": "5e94d5b63f557b001420bbe3",
- "userId": "5e94d5b63f557b001420bbe4"
}
}
This endpoint returns users who have current or historical shared workspace access with the user who the API key belongs to.
page[size] | integer Example: page[size]=100 The number of items to return. If not specified, the API will return a default of 500 items, which is the maximum value. |
page[cursor] | string Example: page[cursor]=5e94d5b63f557b001420bbe3 Pagination cursor that indicates the starting position for the next set of items |
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects (GetUsersModel) Array of Users | |||||||||||||||||||||||||||
Array
| |||||||||||||||||||||||||||
object | |||||||||||||||||||||||||||
|
{- "data": [
- {
- "id": "5e94d5b63f557b001420bbe3",
- "name": "First Last",
- "email": "email@example.com",
- "accountStatus": "active",
- "accountRole": {
- "id": "5e94d5b63f557b001420bbe3",
- "name": "USER"
}, - "auditProjectRole": {
- "id": "5e94d5b63f557b001420bbe3",
- "name": "USER"
}, - "lastLoginDate": "2024-06-01T20:20:39.000Z"
}
], - "links": {
- "self": "/api/v1/users&page[size]=100&page[cursor]=5e94d5b63f557b001420bbe3",
- "next": "/api/v1/users?page[size]=100&page[cursor]=63b88f2cb1f05200179e7857"
}
}
This API endpoint retrieves tags under a TLC
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
id | string |
name | string |
type | string |
category | string |
tlcId | string |
deactivationTime | string |
{- "id": "5e94d5b63f557b001420bbe3",
- "name": "journal_entry",
- "type": "CUSTOM",
- "category": "GENERAL",
- "tlcId": "5e94d5b63f557b001420bbe3",
- "deactivationTime": null
}
This endpoint attaches or detaches a tag to/from a reconciliation. When attaching, if the specified tag does not exist, it will be created and then attached automatically.
system required | string Value: "RECONCILIATIONS" The name of the system receiving the tag (e.g., Reconciliations, Checklists). Currently, only Reconciliations is supported. |
systemId required | string The unique identifier for the system designated to receive the tag (e.g., Reconciliation ID, Checklist ID). Currently, only Reconciliation ID is supported. |
action required | string Enum: "ATTACH" "DETACH" Specifies whether to attach or detach a tag from the system. |
name required | string Name of the tag |
{- "system": "RECONCILIATIONS",
- "systemId": "5e94d5b63f557b001420bbe3",
- "action": "ATTACH",
- "name": "low_risk"
}
{- "message": "Invalid tag name",
- "name": "BadRequest",
- "status": 400
}
This endpoint takes a list of FloQast reconciliation IDs and updates the subledger balance for each.
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
Array of objects Array of Subledger Data | |||||||||||||
Array
|
statusId | string |
{- "data": [
- {
- "reconciliationId": "5e94d5b63f557b001420bbe3",
- "subledger": {
- "balance": "1001.99",
- "currency": "USD",
- "locale": "en-US"
}
}
]
}
{- "statusId": "615bcdc00000000000000302"
}
This endpoint takes a reconciliationId and a corresponding ledger type and updates each provided transaction.
allowRedirect | boolean Example: allowRedirect=true If set to true, the API will return a 303 redirect response if the response payload is too large. The header |
object | |||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
statusId | string |
{- "data": {
- "reconciliationId": "5e94d5b63f557b001420bbe3",
- "ledgerType": "SUB_LEDGER",
- "upsert": true,
- "transactions": [
- {
- "transactionId": "TX12848472728",
- "transactionDate": "2020-04-13",
- "accountType": "Accounts Receivable",
- "accountingDate": "2020-04-13",
- "amount": "15821.56",
- "currency": "USD",
- "customer": "PepsiCo",
- "vendor": "Salesforce",
- "assetNumber": "FA101",
- "recordType": "Credit memo",
- "leaseId": "LSE1001",
- "dueDate": "2020-05-13",
- "description": "Credit memo for returned items",
- "subsidiary": "PepsiCo North America",
- "referenceNumber": "REF-485769",
- "quantity": "17",
- "unitValue": "930.68",
- "clearingIndicator": "CLEARED",
- "assetType": "Computers",
- "leaseType": "FINANCIAL",
- "tradingPartner": "TP-001",
- "locale": "en-US"
}
]
}
}
{- "statusId": "615bcdc00000000000000302"
}
This endpoint takes a reconciliationId and deletes all subledger transactions tied to it.
reconciliationId required | string Example: reconciliationId=668ee68e00b661374b4861c6 The reconciliationId specifies all subledger transactions associated with it for deletion |
statusId | string |
{- "statusId": "668ee68e00b661374b4861c6"
}
This endpoint takes an ID of an endpoint event and returns the status of the event.
statusId required | string Example: 615bcdc00000000000000302 The status ID returned after making a request |
_id | string the Status ID | ||||
status | string Enum: "PENDING" "SUCCESS" "FAILED" The status of the data being saved to our DB | ||||
Array of objects | |||||
Array
|
{- "_id": "5e94d5b63f557b001420bbe3",
- "status": "PENDING",
- "errorList": [
- {
- "reconciliationId": "5e94d5b63f557b001420bbe3",
- "message": "Not a valid reconciliationId"
}
]
}
This API endpoint takes trial balance data and uploads it to a user's FloQast tenant. Use this endpoint to assign or update trial balance values for each account in a given entity and period.
Array of objects | |||||||||||||||||||||
Array
|
Array of objects | |||||||||||||
Array
|
{- "data": [
- {
- "entityId": "5e94d5b63f557b001420bbe2",
- "period": {
- "month": "january",
- "year": "2019"
}, - "accounts": [
- {
- "name": "Software Development Costs",
- "number": "2210",
- "balance": "123.45"
}
]
}
]
}
{- "data": [
- {
- "entityId": "5e94d5b63f557b001420bbe2",
- "period": {
- "month": "january",
- "year": "2019"
}, - "success": true
}
]
}