Gallery
Share
Explore

Report Automation

ABFL Reports:

Everyday emails will be received with below MIS from ABFL These emails will have .xlsx attachment Data needs to be extracted from these MIS’s excel and replaced in
SCF- Large Pipeline
⁠
google sheet under “Utilization - Auto Update” tab
JINDAL STEEL AND POWER LTD
From: “
abflportfolio@supermoney.in
⁠
“ or “
care.abf@adityabirlacapital.net.in
⁠
“
To: “abflportfolio@supermoney.in”
Subject: Starts with “CF Anchorwise Outstanding MIS-JINDAL STEEL AND POWER LTD”
Haier
From: “
abflportfolio@supermoney.in
⁠
“ or “
care.abf@adityabirlacapital.net.in
⁠
“
To: “abflportfolio@supermoney.in”
Subject: Starts with “CF Anchorwise Outstanding MIS-HAIER APPLIANCES INDIA PRIVATE LIMITED”
JINDAL STAINLESS STEELWAY LTD
From: “
abflportfolio@supermoney.in
⁠
“ or “
care.abf@adityabirlacapital.net.in
⁠
“
To: “abflportfolio@supermoney.in”
Subject: Starts with “CF Anchorwise Outstanding MIS-JINDAL STAINLESS STEELWAY LIMITED

ABFL Sheet Mapping
Target Sheet Column Name
Source Sheet Column Names
1
TEAM
​
2
Lender
"ABFL"
3
DEBTOR_ANCHOR_NAME
DEBTOR_ANCHOR_NAME
4
CLIENT_NAME
CLIENT_NAME
5
SM Spoc
​
6
LIMIT_AMOUNT
LIMIT_AMOUNT
7
AUM
PP_OUTSTANDING_AMT
8
AVAILABILITY(in lacs)
AVAILABILITY
9
CL_LIMIT_EXPIRY_DATE
CL_LIMIT_EXPIRY_DATE
10
Utilisation Plan
​
11
City
​
12
States
​
13
Zone
​
14
Total OD
TOTAL_OD_AMOUNT
15
Phn Nos.
​
16
Product
​
17
Cust IDs
​
There are no rows in this table
⁠

Kotak Report:

From: “
Scf.Mis@kotak.com
⁠
“
To: “
sheetal.kushalkar@supermoney.in
⁠
“
Subject: Starts with “Supermoney Utilisation report as on” <<today’s Date>>
Source and Target Sheet Mapping
Lender: Kotak
Dealer Name: Client Name
Sanction limit: Limit Amount (to be converted in Lacs)
Outstanding Amount: AUM (to be converted in Lacs)
Available Amount: Availability (to be converted in Lacs)
Kotak Sheet Mapping
Target Sheet Column Name
Source Sheet Column Name
1
TEAM
​
2
Lender
"Kotak"
3
DEBTOR_ANCHOR_NAME
​
4
CLIENT_NAME
Dealer Name
5
SM Spoc
​
6
LIMIT_AMOUNT
Sanction limit (to be converted in Lacs)
7
AUM
Outstanding Amount (to be converted in Lacs)
8
AVAILABILITY(in lacs)
Available Amount (to be converted in Lacs)
9
CL_LIMIT_EXPIRY_DATE
​
10
Utilisation Plan
​
11
City
​
12
States
​
13
Zone
​
14
Total OD
​
15
Phn Nos.
​
16
Product
​
17
Cust IDs
​
There are no rows in this table
⁠

Mintwalk

(Only activated customers: JSSL, JSPL, Haier)
Lender: Hero
Program Name: DEBTOR_ANCHOR_NAME
CLIENT_NAME: Trade Name
LIMIT_AMOUNT: Sanctioned Limit (to be converted in Lacs)
AUM: Total Outstanding (princ +int+penal)(to be converted in Lacs)
CL_LIMIT_EXPIRY_DATE: 365 + Sanctioned Date
City: POB City
States: POB State


Hero: This will be manual
Lender: Hero
Client Name: Client Name
Product: DEBTOR_ANCHOR_NAME
Branch: City
Sanction limit: Limit Amount (to be converted in Lacs)
Utilized Amount: AUM (to be converted in Lacs)
Deal Expiry: CL_LIMIT_EXPIRY_DATE


ABFL: PID will be manual
Ugrow will be manual


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.