Wholesale Distribution System – Google Sheets Apps Script

Distribution has a shape of its own: you quote before you sell, you deliver before you collect, your stock has expiry dates, and your salesmen are paid on what they moved. This handles that shape end to end on Google Sheets.

Quote, sell, deliver

A quotation goes out, becomes an invoice when accepted, and the invoice prints. Deliveries are managed with a driver assigned and a delivery challan issued for the goods leaving the warehouse — the document that settles the argument about what was actually sent. Sales returns come back through the system rather than as a hand-written credit.

Stock with batches and expiry

Inventory is tracked by batch with expiry dates and FIFO issue, so the oldest stock leaves first and near-expiry batches are visible before they become a write-off. For anyone distributing food, pharma or anything dated, that is the difference between a stock system and a stock count. Purchase orders and product management sit on the same data.

Getting paid and knowing the margin

Salesman commission is calculated from sales, expenses are recorded with an approval workflow, and profit and loss reports run over the lot — so margin is a report rather than a guess at the end of the month. The dashboard carries the live charts.

Who does what

Five roles — admin, manager, salesman, accountant and warehouse staff — with role-based access, so a salesman sees his customers and commission, the warehouse sees the picking and the challans, and the accountant sees the money.