Richard's Work Tracker

Downloads GST invoices from the Air India portal, ready to send to our clients.

• •Input is a simple Excel list of ticket numbers, nothing else.
• •Logs into the portal and downloads every invoice PDF on its own.
• •Even the login OTP is read automatically from the email inbox, no manual step.
• •Creates two Excel reports: a download status sheet for our reference, and the GST report in the exact format the client requires.

Downloads GST invoices from the IndiGo website, ready to send to our clients.

• •Two ways to run it: search by PNR, or search directly by invoice number. Whichever detail you have, the tool can go through either route, each with its own one-click launcher.
• •Input either way is a simple two-column Excel list (PNR or invoice number, plus email), nothing else.
• •Creates two Excel reports: a download status sheet for our reference, and the GST report in the exact format the client requires.

Downloads GST invoices from Akasa Air, ready to send to our clients.

• •Input is a simple Excel list with the PNR and passenger name, nothing else.
• •No website or login involved: the tool connects directly to Akasa's system, so it can process many PNRs at the same time.
• •Akasa returns all of a PNR's invoices as one combined PDF; the tool splits it into clean per-invoice files automatically.
• •Creates two Excel reports: a download status sheet for our reference, and the GST report in the exact format the client requires.

Downloads GST invoices from Air India Express (formerly AirAsia India), ready to send to our clients.

• •Input is a simple Excel list with the PNR and origin city, nothing else.
• •No website or login involved: the tool connects directly to the airline's system.
• •Covers every document type: tax invoices plus credit and debit notes.
• •Senses the airline's speed limits and paces itself automatically, so large batches finish without failures.
• •Creates two Excel reports: a download status sheet for our reference, and the GST report in the exact format the client requires.

Calculates the carbon emissions of flights, for client sustainability reporting.

• •Give it the flight sectors in Excel and it returns the CO2 figure for every leg, using the official ICAO methodology.
• •Any leg the calculator has no data for is clearly flagged, so nothing is missed silently.
• •Built as a website, so the team can run it themselves whenever they need it.

Downloads GST invoices from the SpiceJet portal, ready to send to our clients.

• •The simplest input of all the tools: one Excel column with just the PNRs, nothing else.
• •Fetches every document type in one go: tax invoices, debit notes and credit notes.
• •Handles SpiceJet's website protection on its own; the whole run needs no interaction at all.
• •Creates two Excel reports: a download status sheet for our reference, and the GST report in the exact format the client requires.

• •Runs on an always-on cloud server, so the report goes out even when our systems are off.
• •Each morning it logs into the RBTcliq platform, downloads yesterday's Summary and Pending Cancellation reports for Sodexo, and merges them into one clean Excel.
• •The email itself shows a summary table of the day's transactions (booked, cancelled, reissued and more), counted from the attached file so the numbers always match.
• •If anything does not add up, the run stops instead of sending a wrong report to the client.