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 google sheet under “Utilization - Auto Update” tab
JINDAL STEEL AND POWER LTD
To: “abflportfolio@supermoney.in”
Subject: Starts with “CF Anchorwise Outstanding MIS-JINDAL STEEL AND POWER LTD”
Haier
To: “abflportfolio@supermoney.in”
Subject: Starts withCF Anchorwise Outstanding MIS-HAIER APPLIANCES INDIA PRIVATE LIMITED”
JINDAL STAINLESS STEELWAY LTD
To: “abflportfolio@supermoney.in”
Subject: Starts withCF 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: “
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.