Note
All accounts in the smart contract have their Tside (Asset or Liability) and here is the list:
account type | T-Side | net balance |
---|---|---|
main account | Liability | total credit - total debit |
pocket account | Liability | total credit - total debit |
loan account | Asset | total debit - total credit |
TEST_ASSET_INTERNAL_ACCOUNT | Asset | total debit - total credit |
LOAN_PENALTIES_UNPAID_INTERNAL | Liability | total credit - total debit |
2. Money movements
We opened a loan as below:
Loan installment plan calculation
Parameter Name | Value | Description |
---|---|---|
Principal | 30000 | |
loan interest | 0.031 | |
denomination | PHP | |
terms | 6 | |
repayment day | 19 | repay at 19th of every month |
loan open date | 2022-01-19T16:00:00Z | |
emi | 5045.31 | last term’s emi will be different |
installment plan:
Installment Number | Due Date | principal | interest | total(emi) |
---|---|---|---|---|
1 | 2022-02-19 | 4966.32 | 78.99 | 5045.31 |
2 | 2022-03-19 | 4985.78 | 59.53 | 5045.31 |
3 | 2022-04-19 | 4992.53 | 52.78 | 5045.31 |
4 | 2022-05-19 | 5006.95 | 38.36 | 5045.31 |
5 | 2022-06-19 | 5018.85 | 26.46 | 5045.31 |
6 | 2022-07-19 | 5029.57 | 12.82 | 5042.39 |
Money movement history:
loan open:
2022-01-19T16:00:00Z Postings: - LOAN_ACCOUNT:PRINCIPAL -> DUMMY_DEPOSITING_ACCOUNT:DEFAULT 30000PHP Payment of 30000 of loan principal LOAN_ACCOUNT balances: - PRINCIPAL: 30000PHP
Daily accrue interest
2022-01-21T16:00:01Z Postings: - LOAN_ACCOUNT:ACCRUED_INTEREST -> LOAN_ACCOUNT:INTERNAL_CONTRA 2.54795PHP Daily interest accrued at 0.008493% on outstanding principal of 30000 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 5.0959PHP - INTERNAL_CONTRA: -5.0959PHP - PRINCIPAL: 30000PHP
due date money movement
2022-02-19T16:01:00Z Postings: - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:INTERNAL_CONTRA 0.00355PHP Extra interest charged to customer from negative remainder due to repayable amount for INTEREST_DUE rounded up - LOAN_ACCOUNT:PRINCIPAL_DUE -> LOAN_ACCOUNT:PRINCIPAL 4966.32PHP Installment 1 principal added to due address: 4966.32 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:ACCRUED_INTEREST 78.98645PHP Installment 1 interest added to due address: 78.99 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - INTEREST_DUE: 78.99PHP - INTERNAL_CONTRA: -78.99PHP - PRINCIPAL: 25033.68PHP - PRINCIPAL_DUE: 4966.32PHP 2022-02-19T17:00:00Z Postings: - [Unknown PI] Paying off 5045.31 from DUMMY_DEPOSITING_ACCOUNT, installment 1 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: -5045.31PHP - INTEREST_DUE: 78.99PHP - INTERNAL_CONTRA: -78.99PHP - PRINCIPAL: 25033.68PHP - PRINCIPAL_DUE: 4966.32PHP 2022-02-19T17:00:00Z Postings: - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_PAID 78.99PHP Interest payment log for amount 78.99. - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:INTEREST_DUE 78.99PHP Paying off 78.99 on INTEREST_DUE, which was at 78.99 - 2022-02-19 17:00:00 from DEFAULT, installment 1 - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:PRINCIPAL_DUE 4966.32PHP Paying off 4966.32 on PRINCIPAL_DUE, which was at 4966.32 - 2022-02-19 17:00:00 from DEFAULT, installment 1 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 0PHP - INTEREST_PAID: -78.99PHP - INTERNAL_CONTRA: 0PHP - PRINCIPAL: 25033.68PHP - PRINCIPAL_DUE: 0PHP 2022-03-19T16:01:00Z Postings: - LOAN_ACCOUNT:PRINCIPAL_DUE -> LOAN_ACCOUNT:PRINCIPAL 4985.78PHP Installment 2 principal added to due address: 4985.78 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:ACCRUED_INTEREST 59.5322PHP Installment 2 interest added to due address: 59.53 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_DUE 0.0022PHP Extra interest returned to customer from positive remainder due to repayable amount for INTEREST_DUE rounded down LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 59.53PHP - INTEREST_PAID: -78.99PHP - INTERNAL_CONTRA: -59.53PHP - PRINCIPAL: 20047.9PHP - PRINCIPAL_DUE: 4985.78PHP 2022-03-19T17:00:00Z Postings: - [Unknown PI] Paying off 5045.31 from DUMMY_DEPOSITING_ACCOUNT, installment 2 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: -5045.31PHP - INTEREST_DUE: 59.53PHP - INTEREST_PAID: -78.99PHP - INTERNAL_CONTRA: -59.53PHP - PRINCIPAL: 20047.9PHP - PRINCIPAL_DUE: 4985.78PHP 2022-03-19T17:00:00Z Postings: - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:INTEREST_DUE 59.53PHP Paying off 59.53 on INTEREST_DUE, which was at 59.53 - 2022-03-19 17:00:00 from DEFAULT, installment 2 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_PAID 59.53PHP Interest payment log for amount 59.53. - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:PRINCIPAL_DUE 4985.78PHP Paying off 4985.78 on PRINCIPAL_DUE, which was at 4985.78 - 2022-03-19 17:00:00 from DEFAULT, installment 2 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 0PHP - INTEREST_PAID: -138.52PHP - INTERNAL_CONTRA: 0PHP - PRINCIPAL: 20047.9PHP - PRINCIPAL_DUE: 0PHP 2022-04-19T16:01:00Z Postings: - LOAN_ACCOUNT:PRINCIPAL_DUE -> LOAN_ACCOUNT:PRINCIPAL 4992.53PHP Installment 3 principal added to due address: 4992.53 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:ACCRUED_INTEREST 52.7837PHP Installment 3 interest added to due address: 52.78 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_DUE 0.0037PHP Extra interest returned to customer from positive remainder due to repayable amount for INTEREST_DUE rounded down LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 52.78PHP - INTEREST_PAID: -138.52PHP - INTERNAL_CONTRA: -52.78PHP - PRINCIPAL: 15055.37PHP - PRINCIPAL_DUE: 4992.53PHP 2022-04-19T17:00:00Z Postings: - [Unknown PI] Paying off 5045.31 from DUMMY_DEPOSITING_ACCOUNT, installment 3 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: -5045.31PHP - INTEREST_DUE: 52.78PHP - INTEREST_PAID: -138.52PHP - INTERNAL_CONTRA: -52.78PHP - PRINCIPAL: 15055.37PHP - PRINCIPAL_DUE: 4992.53PHP 2022-04-19T17:00:00Z Postings: - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:INTEREST_DUE 52.78PHP Paying off 52.78 on INTEREST_DUE, which was at 52.78 - 2022-04-19 17:00:00 from DEFAULT, installment 3 - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:PRINCIPAL_DUE 4992.53PHP Paying off 4992.53 on PRINCIPAL_DUE, which was at 4992.53 - 2022-04-19 17:00:00 from DEFAULT, installment 3 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_PAID 52.78PHP Interest payment log for amount 52.78. LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 0PHP - INTEREST_PAID: -191.3PHP - INTERNAL_CONTRA: 0PHP - PRINCIPAL: 15055.37PHP - PRINCIPAL_DUE: 0PHP 2022-05-19T16:01:00Z Postings: - LOAN_ACCOUNT:PRINCIPAL_DUE -> LOAN_ACCOUNT:PRINCIPAL 5006.95PHP Installment 4 principal added to due address: 5006.95 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:ACCRUED_INTEREST 38.3604PHP Installment 4 interest added to due address: 38.36 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_DUE 0.0004PHP Extra interest returned to customer from positive remainder due to repayable amount for INTEREST_DUE rounded down LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 38.36PHP - INTEREST_PAID: -191.3PHP - INTERNAL_CONTRA: -38.36PHP - PRINCIPAL: 10048.42PHP - PRINCIPAL_DUE: 5006.95PHP 2022-05-19T17:00:00Z Postings: - [Unknown PI] Paying off 5045.31 from DUMMY_DEPOSITING_ACCOUNT, installment 4 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: -5045.31PHP - INTEREST_DUE: 38.36PHP - INTEREST_PAID: -191.3PHP - INTERNAL_CONTRA: -38.36PHP - PRINCIPAL: 10048.42PHP - PRINCIPAL_DUE: 5006.95PHP 2022-05-19T17:00:00Z Postings: - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:PRINCIPAL_DUE 5006.95PHP Paying off 5006.95 on PRINCIPAL_DUE, which was at 5006.95 - 2022-05-19 17:00:00 from DEFAULT, installment 4 - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:INTEREST_DUE 38.36PHP Paying off 38.36 on INTEREST_DUE, which was at 38.36 - 2022-05-19 17:00:00 from DEFAULT, installment 4 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_PAID 38.36PHP Interest payment log for amount 38.36. LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 0PHP - INTEREST_PAID: -229.66PHP - INTERNAL_CONTRA: 0PHP - PRINCIPAL: 10048.42PHP - PRINCIPAL_DUE: 0PHP 2022-06-19T16:01:00Z Postings: - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:INTERNAL_CONTRA 0.00367PHP Extra interest charged to customer from negative remainder due to repayable amount for INTEREST_DUE rounded up - LOAN_ACCOUNT:PRINCIPAL_DUE -> LOAN_ACCOUNT:PRINCIPAL 5018.85PHP Installment 5 principal added to due address: 5018.85 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:ACCRUED_INTEREST 26.45633PHP Installment 5 interest added to due address: 26.46 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 26.46PHP - INTEREST_PAID: -229.66PHP - INTERNAL_CONTRA: -26.46PHP - PRINCIPAL: 5029.57PHP - PRINCIPAL_DUE: 5018.85PHP 2022-06-19T17:00:00Z Postings: - [Unknown PI] Paying off 5045.31 from DUMMY_DEPOSITING_ACCOUNT, installment 5 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: -5045.31PHP - INTEREST_DUE: 26.46PHP - INTEREST_PAID: -229.66PHP - INTERNAL_CONTRA: -26.46PHP - PRINCIPAL: 5029.57PHP - PRINCIPAL_DUE: 5018.85PHP 2022-06-19T17:00:00Z Postings: - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_PAID 26.46PHP Interest payment log for amount 26.46. - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:INTEREST_DUE 26.46PHP Paying off 26.46 on INTEREST_DUE, which was at 26.46 - 2022-06-19 17:00:00 from DEFAULT, installment 5 - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:PRINCIPAL_DUE 5018.85PHP Paying off 5018.85 on PRINCIPAL_DUE, which was at 5018.85 - 2022-06-19 17:00:00 from DEFAULT, installment 5 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 0PHP - INTEREST_PAID: -256.12PHP - INTERNAL_CONTRA: 0PHP - PRINCIPAL: 5029.57PHP - PRINCIPAL_DUE: 0PHP 2022-07-19T16:01:00Z Postings: - LOAN_ACCOUNT:PRINCIPAL_DUE -> LOAN_ACCOUNT:PRINCIPAL 5029.57PHP Installment 6 principal added to due address: 5029.57 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:ACCRUED_INTEREST 12.8151PHP Installment 6 interest added to due address: 12.82 - LOAN_ACCOUNT:INTEREST_DUE -> LOAN_ACCOUNT:INTERNAL_CONTRA 0.0049PHP Extra interest charged to customer from negative remainder due to repayable amount for INTEREST_DUE rounded up LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 12.82PHP - INTEREST_PAID: -256.12PHP - INTERNAL_CONTRA: -12.82PHP - PRINCIPAL: 0PHP - PRINCIPAL_DUE: 5029.57PHP 2022-07-19T17:00:00Z Postings: - [Unknown PI] Paying off 5042.39 from DUMMY_DEPOSITING_ACCOUNT, installment 6 LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: -5042.39PHP - INTEREST_DUE: 12.82PHP - INTEREST_PAID: -256.12PHP - INTERNAL_CONTRA: -12.82PHP - PRINCIPAL: 0PHP - PRINCIPAL_DUE: 5029.57PHP 2022-07-19T17:00:00Z Postings: - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:INTEREST_DUE 12.82PHP Paying off 12.82 on INTEREST_DUE, which was at 12.82 - 2022-07-19 17:00:00 from DEFAULT, installment 6 - LOAN_ACCOUNT:DEFAULT -> LOAN_ACCOUNT:PRINCIPAL_DUE 5029.57PHP Paying off 5029.57 on PRINCIPAL_DUE, which was at 5029.57 - 2022-07-19 17:00:00 from DEFAULT, installment 6 - LOAN_ACCOUNT:INTERNAL_CONTRA -> LOAN_ACCOUNT:INTEREST_PAID 12.82PHP Interest payment log for amount 12.82. LOAN_ACCOUNT balances: - ACCRUED_INTEREST: 0PHP - DEFAULT: 0PHP - INTEREST_DUE: 0PHP - INTEREST_PAID: -268.94PHP - INTERNAL_CONTRA: 0PHP - PRINCIPAL: 0PHP - PRINCIPAL_DUE: 0PHP