Gallery
Share
Explore

Statement of Account


There will be 2 types of SOAs that can be generated
Loan Specific SOA: User will input Loan Id/ Invoice Number to generate SOA for that specific loan throughout its transactions journey
Date Range Specific SOA: User will input date range and the SOA will generate all transactions across loans within the selected date range There will be Summary level sheet as well as detailed level sheet provided to the customer Formats: pdf and excel
Summary Details
Details
Value
1
Customer Id
562016
2
Customer Name
BLACK PEARL MARKETING
3
Current Date
10-04-2024
4
From
09-08-2022
5
To
14-08-2023
6
Total Outstanding
4844736.4
7
Principal
4781367.21
8
Interest
63369.19
9
Penalty
0
10
Sanctioned Limit
5000000
11
Available Limit
218632.79
12
Utilized Limit
4781367.21
There are no rows in this table
⁠
Sample Entries in SOA
Loan Id
Invoice no
Description
Transaction Date
Transaction Type
Transaction Amount
Principal
Interest
Penalty
fee
Closing Amount
1
​
​
Opening Amount
09-08-2022
​
292,287
​
​
​
​
292,287
2
55,452
YC00493
DISBURSEMENT
09-08-2022
CREDIT
190,500
0
0
0
​
482,787
3
55,452
YC00493
Interest Accrued from 01-08-2022 to 31-08-2022
31-08-2022
CREDIT
1,000
​
1,000
​
​
483,787
4
55,452
YC00493
Interest Accrued from 01-09-2022 to 30-09-2022
30-09-2022
CREDIT
1,000
​
1,000
​
​
484,787
5
55,452
YC00493
Interest Accrued from 01-10-2022 to 30-10-2022
31-10-2022
CREDIT
1,000
​
1,000
​
​
485,787
6
55,452
YC00493
Interest Accrued from 1-11-2022 to 15-11-2022
15-11-2022
CREDIT
500
​
500
​
​
486,287
7
55,452
YC00493
REPAYMENT
15-11-2022
DEBIT
193,318.36
190,500
2,818.36
0
​
292,968.6
8
55,452
YC00493
Interest Accrued from 15-11-2022 to 30-11-2022
30-11-2022
CREDIT
500
​
500
​
​
293,468.6
9
55,452
YC00493
​
​
​
​
​
​
​
​
​
10
55,453
YC00494
​
​
​
​
​
​
​
​
​
11
55,453
YC00495
​
​
​
​
​
​
​
​
​
There are no rows in this table
⁠

On the day of repayment, show Accrual Entry for that Invoice till that date as credit entry. And then make a repayment entry that will adjust the interest component.
At the end of the month, post an interest accrual which is pending till the end of the month for that invoice
For eg. Repayment came on 15th Nov 2022 for invoice YC00493, interest component accrued till that date for invoice will be calculated and posted for eg here it was Rs. 500. Then at the end of the month the remaining Rs.500 will be posted as Interest Accrual for that Invoice
At the end of the statement, show an entry of interests accrued till that date. For eg, if the last date of SOA is 14-08-2023; then post an interest accrued from last date posted eg. 01-08-2023 till 14-08-2023

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.