Hello,
Few Months back , import of the detailed transaction report from KFinTech : India was successfully implemented.
However, I have come across few problem, while importing the statement. The import was only partly successful.
While investigating further, I suspect the following Issue,
Initially, when requested, I supplied the statement to Andreas configure import. Such statement contained the word “SIP” to define the Systematic Investment Plan
The Report, where I am facing issues also contains two more string to denote SIP namely ;
(1) Sys. Investment (18/49) - value in parenthesis suggests 18th installment out of planned 49 such investment installment
(2) Systematic Investment (1)
I think PP misses importing above two text strings.
I have tried to analyse the pdf statement imported with the PP Import values and highlighted ISIN wise as where the difference comes. I tried to import couple of more times the fintech statement analysis.xlsx (18.0 KB)
pdf statement but it produced the same results. Please review the attached excel sheet, if it can help identify the issue.
with best regards and thanks for your valuable time
Paras
Hello,
I am once again reporting an instance of partial import of transaction from Fintech pdf transaction statement. I am attaching debugged copy (Txt) of pdf statement for ready reference.
Further, the following transactions failed to be imported from the statement
Scheme:
117PFRGG-Mirae Asset Aggressive Hybrid Fund (formerly Mirae Asset Hybrid-Equity Fund ) - Regular Plan
ISIN: INF769K01DE6
transactions :
29-Aug-2018 S T P In 6,000.00 415.139 14.453 7,382.809
05-Sep-2018 S T P In 6,000.00 421.141 14.247 7,803.950
12-Sep-2018 S T P In 6,000.00 423.849 14.156 8,227.799
19-Sep-2018 S T P In 6,000.00 426.834 14.057 8,654.633
26-Sep-2018 S T P In 6,000.00 431.437 13.907 9,086.070
03-Oct-2018 S T P In 6,000.00 439.464 13.653 9,525.534
10-Oct-2018 S T P In 6,000.00 449.102 13.360 9,974.636
17-Oct-2018 S T P In 6,000.00 448.430 13.380 10,423.066
24-Oct-2018 S T P In 6,000.00 453.378 13.234 10,876.444
24-Oct-2018 Consolidation In 10,876.444
31-Oct-2018 S T P In 6,000.00 445.500 13.468 11,321.944
09-Nov-2018 S T P In 6,000.00 436.872 13.734 11,758.816
14-Nov-2018 S T P In 6,000.00 436.872 13.734 12,195.688
22-Nov-2018 S T P In 6,000.00 437.382 13.718 12,633.070
28-Nov-2018 S T P In 6,000.00 433.182 13.851 13,066.252
05-Dec-2018 S T P In 6,000.00 432.526 13.872 13,498.778
12-Dec-2018 S T P In 6,000.00 432.900 13.860 13,931.678
19-Dec-2018 S T P In 6,000.00 425.080 14.115 14,356.758
26-Dec-2018 S T P In 6,000.00 431.158 13.916 14,787.916
02-Jan-2019 S T P In 6,000.00 430.849 13.926 15,218.765
09-Jan-2019 S T P In 6,000.00 428.327 14.008 15,647.092
16-Jan-2019 S T P In 6,000.00 428.235 14.011 16,075.327
23-Jan-2019 S T P In 6,000.00 431.251 13.913 16,506.578
30-Jan-2019 S T P In 6,000.00 434.688 13.803 16,941.266
06-Feb-2019 S T P In 6,000.00 427.290 14.042 17,368.556
13-Feb-2019 S T P In 8,294.11 601.327 13.793 17,969.883
Please do let me know, any more information is needed.
Thanks for your kind attention
Paras
Further to above post, i am just sharing below the common description generally contained in kfintech statement for various transactions . Just for the reference.
Transaction description can be any value from the following
PURCHASE
PURCHASE_SIP
SIP
Sys. purchase plan
Sys.Purchase
Systematic Purchase Plan
REDEMPTION
SWITCH_IN
SWITCH_IN_MERGER
SWITCH_OUT
SWITCH_OUT_MERGER
DIVIDEND_PAYOUT
DIVIDEND_REINVESTMENT
SYSTEMATIC TRANFER PLAN FROM ONE MF SCHEME TO OTHER MF SCHEME (STP IN)
STP OUT
SEGREGATION
STAMP_DUTY_TAX
TDS_TAX
STT_TAX
MISC
In continuation of the above post, and as per Andria’s below suggestion
Ideally you post here the example line from the file and what you want that to be imported.
I have scanned through the three different person’s statements of transactions for past ten years and can summarize following terms;
A. Following terminology used for the Transactions are “Purchase”
SIP Purchase - Instalment 2/122, (3/122 and so on)
Systematic Investment Purchase - 1/156, (2/156 and so on)
Purchase
SIP Purchase
Systematic Investment
Sys. Investment (1/213), (2/213 and so on)
Purchase-SIP (ECS)
Purchase-SIP
SIP Purchase - Instalment
10.Switch-In
11.Systematic Switch In
12.S T P In
13.SIP Insure
14.Initial Purchase
15.NFO Purchase
16.Purchase Appln
17.Purchase (New Fund Offer)
18.Systematic Purchase
B. Following terminology says purchase failed
Invalid Purchase-Credit Not Received
C. Following Terminology used for Dividend payout
***IDCW Payout
Note: I can not find “STP Out”, so we may skip the same.
Please do let me know, If i can furnish more information.
Thank you very much for your kind assistance
Paras
Further to my above posts, I am sharing another debugged pdf statement with line numbers. I am summarising below the transactions which failed to be imported
A. Scheme Name : Mirae Large and Midcap Fund
ISIN : INF769K01101
Line No at which Scheme Appears : 498
Transactions failed to be imported between Line Numbers : 502 to 626 (purchase)
B. Scheme Name : Nippon India Multicap
ISIN : INF204K01489
Line no at which scheme appears : 645
Transaction imported only at : Line No 649
Transaction did not import : from Line no 650 to 893 (purchase)
C. Scheme Name : Nippon India Pharma
ISIN : INF204KO1968
Scheme appears at : Line 1087
Transaction Imported : only Line 1091
Transaction missed to be imported : from Line 1092 to 1334 (purchase)
Please do let me know, if any more information is needed.
Thanking you
Paras
