At the time of writing this document , implementation is in progress 11/25/2022
Overview
In addition to the Vault Core's ledger, whose transactions are purely operational in nature, and is needed for the functioning of the banking system, actual financial accounting is done in the dedicated accounting system. The accounting system forms a basis for creating regulatory-compliant financial statements.
As the CBS is the major source for accounting system journal entries, these transactions should be transformed and loaded into the NetSuite systematically
Data load frequency: Daily (After midnight)
1. High level data flow
2. Data Transformation
2.1 Mapping of the TM Accounts/Addresses to the NetSuite COA is done based on the lookup table depicted in the Internal accounts and postings structure document
2.2 Transactions are aggregated by the transaction code in BigQuery
3. NetSuite Journal Entry
NetSuite gateway will populate the JE object based on a CSV file generated/uploaded by the DataLake with the following logic:
Property | How it’s filled |
---|---|
transactionId (HEADER) | Blank (Null/Empty). It will be automatically generated by the NS with the predefined logic |
transactiondate (HEADER) | Transaction date of which the data aggregated |
isDeferred (HEADER) | Static. always false |
reversalDate (HEADER) | Blank (Null/Empty) |
subsidiary (HEADER) | Static. Reference key should be provided from NetSuite |
memo (HEADER) | Batch Id |
account ref | NetSuite account reference key |
debit amount | Aggregated value |
credit amount | Aggregated value (Will be the same as debit amount) |
entity ref | Static. Reference key should be provided from NetSuite |
department ref | Static. Reference key should be provided from NetSuite |
class ref | Static. Reference key should be provided from NetSuite |
location ref | Static. Reference key should be provided from NetSuite |
taxCodeRef | Static. Reference key should be provided from NetSuite |
4. TM/NetSuite Reconcilation
WIP
Attachments:
Integration with Accounting System.drawio.png (image/png)