Expense Management Integration

On myBiz, one of the key focus areas is automating all the processes in an organisation's travel management system. One of the key areas of automation is to offer automated expense reporting, reimbursements, and payment cycles. To facilitate this, we provide expense automation capabilities to integrate with your expense partners via two processes: Integrate with fetch travel details API and SFTP integration

Procedure

  • 1Client’s IP needs to be whitelisted at myBiz’s end.
  • 2Client have to integrate with myBiz’s Fetch Travel Details API. Details of the same are mentioned below

API details: Fetch Travel Details API

In order to automate your financial reconciliation, you can integrate with our fetchtraveldata API. Implementing this expense management automation will allow you to access a real-time feed of travelled data along with all the financial data.

  • 1You can access Booker details, traveler details, approval details and the corresponding GST information.
  • 2Clients can call this API and get integrated expense management reports for the following type of travel: Flight, Hotel, Cab, Bus, Train & Wallet.
  • 3You can retrieve a report based on a date range or a list of booking IDs. The report can cover a maximum range of 1 month or up to 200 booking IDs. If you retrieve the report using booking IDs, the date range input will be ignored, and you will receive all lines associated with the specified booking IDs.
  • 4Sample API JSON for report type ‘flight’ is given below. The fields mentioned are mandatory inputs.
  • 5Client ID and Org ID are two secret keys used in the API request.
  • 6Secret keys generation:
    • Both the keys can be generated/refreshed real time from myBiz admin page.
    • Steps: Login to myBiz admin account -> Go to Company Details page -> Generate/Refresh expense client id and external org id.
  • 7“Level” can be INVOICE OR ACTION.
    • Level = Invoice; gives cumulative report at invoice level.
    • Level = Action; gives drilled down report at action level (action can be add-on, seat selection etc.).
  • 8A csv will be generated post this, which can be exported. Output file will be in csv format only
  • 9The generated csv file will have the following fields (It is not mandatory to have the same format. Clients can define formats on their own):

Sample API CURL

COPY
curl --location 'https://corpcb.makemytrip.com/transaction/data' 
 --header 'Content-Type: application/json' 
 --header 'Accept: text/csv' 
 --data 
 '{"expense-client-id":"89f4e681-a005-4c46-b514-2351b0cdc23d", 
 "external-org-id":"53a27b51-145d-4088-8707-a9b4f826bdd3", 
 "to-date":1675987210000, 
 "from-date":1675900810000, 
 "report-type":"FLIGHT", 
 "level":"INVOICE"
}'
Booking ID
PNR No
Operator Ticket Number
Created/Updated Date
Journey Date
Booker Email
Booker Name
Booker Employee ID
Booker Department
Booker Comment
No of Passengers
Passenger Email(s)
Passenger Name(s)
Passenger Employee ID(s)
Passenger Department(s)
Booker Cost Center
Traveller Cost Center
Departure City
Arrival City
Bus Operator
Bus Type
Seat Type
Booking Action
Booking Mode
Bus Fare(inclusive taxes)
Bus Operator GST
Bus Operator CGST
Bus Operator SGST
Bus Operator IGST
Convenience fee charged by MMT(including tax)
GST Charged by MMT
CGST charged by MMT
SGST charged by MMT
IGST charged by MMT
E-coupon amount
Insurance Amount
Cancellation Penalty
Net amount charged
Is GST Claimable
GST Claimable Amount
Advance Receipt Number
MMT Invoice No
MMT GSTN
Bus Operator GSTN
Customer GSTN
Payment Source
Claim Reason
Approver Email
Approver Name
Approver Employee ID
Approver Comment
Approver Department
Approval Status
Policy Status
Out of policy reason
Unique ID
Requisition ID
Reason For Travel
NU1111111111111
A8BRV12
A154BC
11-09-2023 15:27
11-09-2023 22:50
booker1@test.in
booker1
A123
Sales
Sales Visit
1
passenger1@test.in
passenger1
A1234
Sales
C2
T23
Chalakudi
Bangalore
Sona Travels
A/C-Seater
Seater
BOOKING
online
2098.9505
24.39457599
0
0
24.39457599
0
0
0
0
0
0
15
0
2113.95
Yes
24.39457599
ARN123
M06AI
06AAD
AB124
Vx19nA
Credit/Debit card
NA
Approver1@test.in
approver1
B123
Approved
Sales
NOT_REQUIRED
TRUE
NA
24abcbf2
UA123
Corporate Travel
NU2222222222222
A8AJH34
A154AB
12-09-2023 14:15
13-09-2023 21:12
booker2@test.in
booker2
B123
HR
Urgent Meeting
1
passenger2@test.in
passenger2
B1234
HR
C1
T42
Chalakudi
Bangalore
KKN Travels
Non A/C-Seater_Sleeper
Sleeper
BOOKING
online
1153.9505
13.41152514
0
0
13.41152514
0
0
0
0
0
0
42
0
1153.95
Yes
13.41152514
ARN135
M06AI
06AAD
BA123
Vx19nB
Net Banking
NA
Approver2@test.in
approver2
C321
Approved
HR
NOT_REQUIRED
TRUE
NA
ee616883
BA324
Corporate Travel

API details: Fetch Travel Invoice Details API

In order to automate your financial reconciliation, you can integrate with our fetchTravelInvoice API. Implementing this expense management automation will allow you to access a real-time feed of travel invoice data and copies.

  • 1You can access all MakeMyTrip (MMT) and Vendor (GST) invoices along with a summary of invoice availability.
  • 2Clients can call this API and get MMT and GST invoices for the following type of travel: Flight, Hotel, Cab, Bus and Rail.
  • 3Sample API JSON for invoice type ‘flight’ is given in the sample API cURL. The fields that are non-mandatory are marked blank in the sample cURL.
  • 4Invoices can be retrieved only for a single booking ID per API call.
  • 5Client ID and Org ID are two secret keys used in the API request. The following process is to be followed for generation of secret keys:
  • 6Secret keys generation:
    • Both the keys can be generated/refreshed real time from myBiz admin page.
    • Steps: Login to myBiz admin account -> Go to Company Details page -> Generate/Refresh expense client id and external org id.
  • 7Valid values for the input variables are given below:
    • booking_id = string, mandatory
    • invoice-type = mmt/gst, non-mandatory (Keeping this variable empty will provide data for both MMT and GST invoices)

Sample API CURL

COPY
curl --location 'https://corpcb.makemytrip.com/external/invoice/data' 
 --header 'Content-Type: application/json' 
 --data 
  '{"expense-client-id":"89f4e681-a005-4c46-b514-2351b0cdc23d", 
 "external-org-id":"53a27b51-145d-4088-8707-a9b4f826bdd3", 
 "booking-id":"NH94159314382186", 
 "invoice-type":"GST/MMT/eVOUCHER" //not mandatory; if not specified then all invoice data is returned
}'

API details: Fetch Wallet Transactions API

To automate your financial reconciliation, integrate with our fetchWalletTransaction API. This integration will provide you with a real-time feed of wallet transactions, streamlining your expense management process.

  • 1A sample JSON for extracting a wallet report is provided in the sample cURL.
  • 2Client ID and Org ID are two secret keys used in the API request. The following process is to be followed for generation of secret keys:
    • Log in to your myBiz admin account.
    • Go to the Company Details page.
    • Generate or refresh the expense client ID and external org ID.
  • 3You can retrieve a wallet report based on a date range or a list of booking IDs. The report can cover a maximum range of 1 month or up to 200 booking IDs. If you retrieve the report using booking IDs, the date range input will be ignored, and you will receive all transactions associated with the specified booking IDs.
  • 4Valid values for the input variables are given below:
    • booking_ids: list of string, optional
    • from_date: epoch time, mandatory
    • to_date: epoch time, mandatory
  • 5By following these guidelines, you can effectively integrate with our API and automate your financial reconciliation process.

Sample API CURL

COPY
curl --location 'https://corpcb.makemytrip.com/external/wallet/data' 
 --header 'Content-Type: application/json' 
 --data 
 '{"expense-client-id": "89f4e681-a005-4c46-b514-2351b0cdc23d", 
 "external-org-id": "53a27b51-145d-4088-8707-a9b4f826bdd3", 
 "to-date": 1712188799999, 
 "from-date": 1711974600741, 
 "booking-ids": ["NF96139349643982"]
}'

SFTP Integration options

myBiz offers expense integration through an SFTP location too. This SFTP should be residing in the client’s network. myBiz would not give any FTP servers. The same csv output file will be pushed at shared SFTP location.

Custom Integrations

We have custom integrations available with DICE and ZOHO for T & E automation. For more details please drop your queries on mybiz-integration-queries@go-mmt.com.