Report - Data Feed Reconciliation
GET {{baseUrl}}/sf/funds/:fundId/reports/dataFeedRec?start={{start}}&end={{end}}
Allows you to retrieve all ledger transactions as well as raw data feed bank transactions to compare/reconcile/verify against the source.
API Scopes
The following API scopes can access this resouce
- audit
- smsf_partner
Entities Supported
The following entityTypes are supported
- SMSF
- BillableTrust
- BillableCompany
- BillableIndividual
The Data Feed Reconciliation report provides all ledger transactions and all raw data feed transactions for the specified date range.
This report allows the verification that the transactions on the ledger exist and reconcile with the transactions that were received directly from the data feed / bank.
| Key | Type | Comments |
|---|---|---|
| fundId | Text | The Fund Identificaion Number. This is unique across all of Simple Fund 360. |
| start | Date | yyyy-mm-dd |
| end | Date | yyyy-mm-dd |
| account | Array | see Account array below |
Account array
| Key | Type | Comments |
|---|---|---|
| tAccountId | String | The Account Code from the Chart of Accounts. Display Control Account code for Control Accounts. Display Sub-account code for sub-accounts. |
| accountSummary | Object | See below |
| ledgerSummary | Object | See below |
| bankFeedSummary | Object | See below |
| ledgerTransactions | Array | See below |
| bankFeedTransactions | Array | See below |
accountSummary Object
| Key | Type | Comments |
|---|---|---|
| accountNumber | String | Bank account number |
| accountType | String | AssetBank, LiabilityLRBA |
| bsb | String | Bank, State, Branch |
| code | String | Chart of Accounts sub code |
| dataFeed | String | Data Feed - e.g. BGLBankDataService |
| feedStartDate | Date | YYYY-MM-DD |
| id | String | Chart of Accounts unique identifier |
| name | String | Chart of Accounts name |
| pcode | String | Chart of Accounts control code |
ledgerSummary Object
| Key | Type | Comments |
|---|---|---|
| closingBalance | Number | The Closing Balance in Simple Fund 360 based on the 'end' date parameter for the account. null indicates no value found in Simple Fund 360. |
| closingBalanceCheck | Number | Calculated using openingBalance - totalCredits + totalDebits This field can be used to check against the returned closingBalance |
| openingBalance | Number | The Opening Balance in Simple Fund 360 based on the 'start' date parameter for the account. null indicates no value found in Simple Fund 360. |
| totalCredits | Number | The total of all Credit transactions in Simple Fund 360 based on the query parameters for the account |
| totalDebits | Number | The total of all Debit transactions in Simple Fund 360 based on the query parameters for the account |
bankFeedSummary Object
| Key | Type | Comments |
|---|---|---|
| closingBalance | Number | The Closing Balance in Simple Fund 360 based on the 'end' date parameter for the account. null indicates no value found in bank feed database. |
| closingBalanceCheck | Number | Calculated using openingBalance - totalCredits + totalDebits This field can be used to check against the returned closingBalance |
| openingBalance | Number | The Opening Balance received directly from the bank based on the 'start' date parameter for the account. null indicates no value found in bank feed database. |
| totalCredits | Number | The total of all Credit transactions in bank feed database based on the query parameters for the account |
| totalDebits | Number | The total of all Debit transactions in bank feed database based on the query parameters for the account |
ledgerTransactions Array
| Key | Type | Comments |
|---|---|---|
| amount | Number | Amount of the transaction |
| createdBy | String | User/System that created the transaction - e.g. bankFeedSaveris a system value |
| description | String | Transaction description |
| lastModifiedBy | String | User/System to last modify the transaction - e.g. bankFeedSaveris a system value |
| source | String | How the transaction was created. SF360 - Manual entry BGLBank - Includes BGL Bank Data Feed and Macquarie Cash BANKSTATEMENTS - BankStatement.com.au CSVBank - Imported via CSV Banklink Xero |
| transactionDate | Date | YYYY-MM-DD |
| transactionId | String | Unique transaction identifier |
bankFeedTransactions Array
| Key | Type | Comments |
|---|---|---|
| amount | Number | Amount of the transaction |
| createdBy | String | This will always return ‘BankFeedSystem’ as the data is created by the system and no manual intervention is allowed. |
| description | String | Transaction description |
| lastModifiedBy | String | This will always return ‘BankFeedSystem’ as the data is created by the system and no manual intervention is allowed. |
| source | String | Where the transaction data came from ADL ANZ BBL BOQ BWAMI CBA DDH HUM MBL NAB SGB WBC |
| transactionDate | Date | YYYY-MM-DD |
| transactionId | String | Unique transaction identifier |
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
start | string | [REQUIRED] YYYY-MM-DD | |
end | string | [REQUIRED] YYYY-MM-DD |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Authorization | string | ||
Content-Type | string | ||
Cookie | string |
RESPONSES
status: OK
{"dataFeedRec":{"account":[{"accountSummary":{"accountNumber":"924012301","accountType":"AssetBank","bsb":"012012","code":"ANZ924012301","dataFeed":"BGLBankDataService","feedStartDate":"2022-07-01","id":222286977836,"name":"ANZ","pcode":"60400"},"bankFeedSummary":{"closingBalance":null,"closingBalanceCheck":458642.13,"openingBalance":-800,"tAccountId":null,"totalCredits":-40561.75,"totalDebits":500003.88},"bankFeedTransactions":[{"amount":500000,"createdBy":"BankFeedSystem","description":"TRANSFER","lastModifiedBy":"BankFeedSystem","source":"ANZ","transactionDate":"2022-07-01","transactionId":"2742222"},{"amount":-40000,"createdBy":"BankFeedSystem","description":"TRANSFER COMMSEC WITHDRAWAL","lastModifiedBy":"BankFeedSystem","source":"ANZ","transactionDate":"2022-07-12","transactionId":"2899041"},{"amount":-559.25,"createdBy":"BankFeedSystem","description":"ANZ INTERNET BANKING FUNDS TFER ADVISOR FEE","lastModifiedBy":"BankFeedSystem","source":"ANZ","transactionDate":"2022-07-15","transactionId":"2899042"},{"amount":3.88,"createdBy":"BankFeedSystem","description":"CREDIT INTEREST","lastModifiedBy":"BankFeedSystem","source":"ANZ","transactionDate":"2022-07-31","transactionId":"2742223"},{"amount":-2.5,"createdBy":"BankFeedSystem","description":"ACCOUNT SERVICING FEE","lastModifiedBy":"BankFeedSystem","source":"ANZ","transactionDate":"2022-07-31","transactionId":"2742224"}],"ledgerSummary":{"closingBalance":null,"closingBalanceCheck":458642.13,"openingBalance":-800,"tAccountId":null,"totalCredits":-40561.75,"totalDebits":500003.88},"ledgerTransactions":[{"amount":500000,"createdBy":"bankFeedSaver","description":"TRANSFER","lastModifiedBy":"bankFeedSaver","source":"BGLBank","transactionDate":"2022-07-01","transactionId":"2742222"},{"amount":-40000,"createdBy":"bankFeedSaver","description":"TRANSFER COMMSEC WITHDRAWAL","lastModifiedBy":"bankFeedSaver","source":"BGLBank","transactionDate":"2022-07-12","transactionId":"2899041"},{"amount":-559.25,"createdBy":"bankFeedSaver","description":"ANZ INTERNET BANKING FUNDS TFER ADVISOR FEE","lastModifiedBy":"bankFeedSaver","source":"BGLBank","transactionDate":"2022-07-15","transactionId":"2899042"},{"amount":3.88,"createdBy":"bankFeedSaver","description":"CREDIT INTEREST","lastModifiedBy":"bankFeedSaver","source":"BGLBank","transactionDate":"2022-07-31","transactionId":"2742223"},{"amount":-2.5,"createdBy":"bankFeedSaver","description":"ACCOUNT SERVICING FEE","lastModifiedBy":"bankFeedSaver","source":"BGLBank","transactionDate":"2022-07-31","transactionId":"2742224"}],"tAccountId":222286977836}],"end":"2023-06-30T00:00:00Z","fundId":"8a8bd53685e14fb40185e15d1ce90000","start":"2022-07-01T00:00:00Z"}}