Vijayalakshmi Agencies TDS

Enter PIN

This app holds your business figures, so it is locked with a PIN.

Upload the BPCL statements The .xls statements as downloaded from the BPCL portal — both outlets, one or several months. BPCL tanker invoice PDFs can be dropped here too.

Months

TDS 194Q to pay

TDS 194I to pay (LFR)

Credited back by BPCL in this statement

Outlets

Each outlet's statement is checked against BPCL's own sub-total and closing balance.

MS / HSD invoices

Each tanker invoice is rebuilt from its rates and checked against BPCL's amount. Rates come from the BPCL invoice PDF, the rate list, or BPCL's rate e-mail — in that order.

Other purchases

TDS credited by BPCL

Lines marked 194Q / 194I in the statement — BPCL acknowledging TDS you have deposited.

Lines left out of the TDS working

Outlets

BPCL customer codes and the short names used in the app and the Excel. New codes are added automatically when a statement is uploaded.

BPCL tanker invoices (PDF)

Upload the invoice PDF of any tanker load that shows “Needs rates”. The app reads quantity, rate and delivery charges from it and adds the total to the rate list.

BPCL rate alerts

Add rates by pasting e-mails

Copy one or more “Retail RSP Revision” e-mails from Gmail and paste them here (useful for past months).

E-mails received by the app

—

Rate list — known tanker loads

The statement shows only each invoice total. Each total here stands for one load (KL, rate per KL, delivery charges). When BPCL changes a price, a new total appears and the app asks you for the rates once from that invoice.

TDS history

TDS worked out each month (both outlets together) against the TDS credits BPCL posted in that month's statements. A small gap is normal if a credit is posted the next month.