Overview
Vault Core ledger acts as a central repository (SSOT) for all the financial transactions performed within a bank triggered by the business events of the various products and maintains the balance and turnover of all the accounting entities.
Throughout the analysis process, we have covered (1) Transaction structure, how single transaction object looks and what information it contain, (2) Chart of internal accounts (and how it’s mapped to the GL accounts of the accounting system), (3) Postings list - finite list of possible entries that can be performed in Vault, each of them identified by the unique TRANSACTION CODE.
(1) Transaction structure
Each transaction will have the following data properties:
Property | Description |
---|---|
value_timestamp | Date of the actual business event |
insertion timestamp | Date when the record was actually inserted to the system |
debit account id / internal account | |
debit account address (for non-internal) | |
debit account phase - pending incoming / pending outgoing / committed | |
credit account id / internal account | |
credit account address (for non-internal) | |
credit account phase | pending incoming / pending outgoing / committed |
amount | |
denomination | |
transaction code | unique for each transaction type, transactions will be identified based on this. All transactions which do specific movement (credit/debit + addresses) will share same value. NOTE: If same movement occurs in two different event types, they must have different code. |
2x transaction id | unique for each transaction - one generated by Vault, one filled by us. |
2x transaction batch id | unique for each transaction batch containing multiple transactions - one generated by Vault, one filled by us |
custom_details | containing list of posting-specific data. Should be split into optional and mandatory ones. |
(2) Chart of Internal Accounts
# | Vault Account | Linked GL account | Catogory | GL Group |
---|---|---|---|---|
1 | Main Account (DEFAULT) | SAVINGS DEP - DOM - INDIVIDUAL | DEPOSIT LIABILITIES | SAVINGS DEPOSIT |
2 | Main Account (FEE OVERDUE) | Accounts Receivable - Subscription Fee - Non-Performing | TRADE AND OTHER RECEIVABLES | TRADE AND OTHER RECEIVABLES |
3 | Accounts Receivable - Subscription Fee - Performing | TRADE AND OTHER RECEIVABLES | TRADE AND OTHER RECEIVABLES | |
4 | Main account (INTEREST) | AIP- Savings Deposit | CURRENT LIABILITIES | ACCRUED INTEREST EXPENSE |
5 | Main Account (OVERDRAFT) | SAVINGS DEP - DOM - INDIVIDUAL | DEPOSIT LIABILITIES | SAVINGS DEPOSIT |
6 | Main Account (REFERRAL ADDRESS) | Accrued Provision for Referral Bonus Cost | CURRENT LIABILITIES | ACCRUED EXPENSES |
7 | I assume this is a transit account only, no balances | |||
8 | Loan Account (INTEREST DUE) | AIR - Personal Loans - Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
9 | Loan Account (INTEREST OVERDUE) | AIR - Personal Loan - Non-Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
10 | Loan Account (PENALTIES) | Loans Receivable - Personal Loans - Penalty - Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
11 | Loan Account (PRINCIPAL DUE) | Loans Receivable - Personal Loan - Principal - Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
12 | Loan Account (PRINCIPAL OVERDUE) | Loans Receivable - Personal Loan - Non-Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
13 | Loan Account (PRINCIPAL) | Loans Receivable - Personal Loan - Principal - Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
14 | Saving Pocket (DEFAULT) | SAVINGS DEP - DOM - INDIVIDUAL | DEPOSIT LIABILITIES | SAVINGS DEPOSIT |
15 | Saving Pocket (INTEREST) | AIP- Savings Deposit | CURRENT LIABILITIES | ACCRUED INTEREST EXPENSE |
16 | Saving Pocket (LOCKED BONUS) | AIP- Savings Deposit | CURRENT LIABILITIES | ACCRUED INTEREST EXPENSE |
17 | Saving Pocket (MONTHLY INTEREST) | AIP- Savings Deposit | CURRENT LIABILITIES | ACCRUED INTEREST EXPENSE |
18 | Accrued Interest Receivable | AIR - Personal Loans - Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
19 | Overdraft Principle Receivables | Loans Receivable - Overdraft - Principal - Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
20 | Overdraft Principal Receivables Overdue | Loans Receivable - Overdraft - Non-Performing | TRADE AND OTHER RECEIVABLES | LOANS AND RECEIVABLES |
21 | Interest Received Account | Interest Income - Personal Loans | REVENUE ACCOUNTS | INTEREST INCOME |
24 | Suspense account (F.E Mastercard) | Accounts Payable - Mastercard Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
25 | Deposit Interest WHT | Final Withholding Tax Payable - Interest expense | CURRENT LIABILITIES | TAXES AND LICENSES PAYABLE |
27 | Late Repayment Fee Income Account | Income from Penalties - Personal Loans | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
28 | ATM fee income | SERVICE FEES - CARD ATM | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
29 | Card creation fee income | SERVICE FEES-PAYMENTS-CARD CREATION/ REPLACEMENT | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
30 | Loan Late fee income | Income from Penalties - Personal Loans | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
31 | Loan Opening Fee Income | SERVICE CHARGES-PERSONAL LOAN FEES-PROCESSING | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
32 | Overdraft Fee Income | SERVICE CHARGES-OVERDRAFT FEES-EXTENSION | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
33 | Subscription Fee Income | Subscription Income | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
34 | Deposit interest cost | Interest Expense - Tax-Exempt-Savings Deposit | OPERATING EXPENSES | DIRECT COSTS |
35 | Referral bonus cost | Ads and Promotions - Referral Bonus | OPERATING EXPENSES | OTHER OPERATING EXPENSES |
36 | Rounding difference | |||
37 | TUP_EW_GXI | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
38 | TUP_EW_MYA | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
39 | TUP_EW_SPE | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
40 | TUP_EW_GPY | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
41 | TUP_EW_WCT | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
42 | TUP_EW_APY | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
43 | TUP_EW_PYP | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
44 | TUP_DC_VSA | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
45 | TUP_DC_MCD | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
46 | TUP_BT_BPI | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
47 | TUP_BT_UBK | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
48 | TUP_BT_PNB | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
49 | TUP_BT_RCB | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
50 | TUP_BT_BDO | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
51 | TUP_OT_7CN | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
52 | TUP_OT_7CQ | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
53 | TUP_OT_ECP | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
54 | TUP_OT_MLR | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
55 | TUP_OT_CLR | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
56 | TUP_OT_SMP | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
57 | TUP_OT_PLP | Accounts Receivable - Paynamics | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
58 | TUD_OT_DIG | Accounts Receivable - Digipay | OTHER CURRENT ASSET | SETTLEMENT CLEARING |
59 | MWP_IB_INS | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
60 | MWP_IB_PES | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
61 | MWP_OT_CLR | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
62 | MWP_IB_MLR | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
63 | MWP_IB_PLP | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
64 | MWP_IB_LBC | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
65 | MWP_IB_SMP | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
66 | MWP_EW_INS | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
67 | BPP_BP_PYC | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
68 | BPC_BP_ECP | Accounts Payable - ECPay Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
69 | DGP_DG_PYC | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
70 | DGP_DG_ECP | Accounts Payable - Paynamics Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
71 | MWB_IB_INS | Accounts Payable - Instapay Settlements | CURRENT LIABILITIES | ACCOUNTS PAYABLE |
72 | MWB_IB_PES | Accounts Payable - Pesonet Settlements | OTHER CURRENT LIABILITIES | SETTLEMENT CLEARING |
73 | FEE_TUP_EW_GXI | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
74 | FEE_TUP_EW_MYA | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
75 | FEE_TUP_EW_SPE | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
76 | FEE_TUP_EW_GPY | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
77 | FEE_TUP_EW_WCT | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
78 | FEE_TUP_EW_APY | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
79 | FEE_TUP_EW_PYP | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
80 | FEE_TUP_DC_VSA | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
81 | FEE_TUP_DC_MCD | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
82 | FEE_TUP_BT_BPI | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
83 | FEE_TUP_BT_UBK | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
84 | FEE_TUP_BT_PNB | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
85 | FEE_TUP_BT_RCB | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
86 | FEE_TUP_BT_BDO | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
87 | FEE_TUP_OT_7CN | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
88 | FEE_TUP_OT_7CQ | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
89 | FEE_TUP_OT_ECP | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
90 | FEE_TUP_OT_MLR | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
91 | FEE_TUP_OT_CLR | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
92 | FEE_TUP_OT_SMP | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
93 | FEE_TUP_OT_PLP | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
94 | FEE_TUD_OT_DIG | Accounts Payable - Digipay Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
95 | FEE_MWP_IB_INS | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
96 | FEE_MWP_IB_PES | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
97 | FEE_MWP_OT_CLR | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
98 | FEE_MWP_IB_MLR | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
99 | FEE_MWP_IB_PLP | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
100 | FEE_MWP_IB_LBC | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
101 | FEE_MWP_IB_SMP | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
102 | FEE_MWP_EW_INS | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
103 | FEE_BPP_BP_PYC | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
104 | FEE_BPC_BP_ECP | Accounts Payable - ECPay Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
105 | FEE_DGP_DG_PYC | Accounts Payable - Paynamics Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
106 | FEE_DGP_DG_ECP | Accounts Payable - ECPay Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
107 | FEE_MWB_IB_INS | Accounts Payable - Instapay Fees | CURRENT LIABILITIES | ACCOUNTS PAYABLE |
108 | FEE_MWB_IB_PES | Accounts Payable - Pesonet Fees | OTHER CURRENT LIABILITIES | ACCOUNTS PAYABLE |
109 | Top up income | SERVICE FEES-PAYMENTS-CASH-IN | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
110 |
| |||
111 | Bill Payment income | Payment Services - Bills | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
112 | Digital goods income | Payment Services - digital goods | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
113 | Paynamics transaction cost | Bank Service Costs - Paynamics | OPERATING EXPENSES | DIRECT COSTS |
114 | ECPay transaction cost | Bank Service Costs - ECPay | OPERATING EXPENSES | DIRECT COSTS |
115 | Digipay transaction cost | Bank Service Costs - Digipay | OPERATING EXPENSES | DIRECT COSTS |
116 | Card replacement fee income | SERVICE FEES-PAYMENTS-CARD CREATION/ REPLACEMENT | REVENUE ACCOUNTS | OTHER OPERATING INCOME |
117 | ATM transaction cost | Bank Service Costs - Mastercard | OPERATING EXPENSES | DIRECT COSTS |
118 | Suspense account (Atome BNPL) | Accounts Payable - Atome BNPL Settlements | CURRENT LIABILITIES | ACCOUNTS PAYABLE |
(3) Posting List
Transaction codes are not defined in the postings file
Attachments:
SaFi Postings v12.xlsx (application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)