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
COPYcurl --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
COPYcurl --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
COPYcurl --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.