Pharmacy Purchase Import: Mapping CSV/Excel Invoices from Top Distributors

Indian retail pharmacies source medicines from multiple local distributors. Each distributor uses a different wholesale billing software (e.g. Marg ERP, Tally, Vyapar, or custom web portals) and exports purchase bills in varying Excel/CSV formats. Manually entering hundreds of item rows, batch details, and taxes is tedious. Here is how to automate the import workflow.

The Nightmare of Manual Purchase Entries

When a distributor delivers a shipment of 50 different medicines, typing every product name, matching HSN codes, copying batch numbers, setting expiry dates, and entering wholesale prices manually takes hours. This manual task also increases the risk of typo errors, resulting in mismatched inventory levels or incorrect sales tax pricing.

The Modern Solution: Automated CSV Mapping

Modern pharmacy systems support automated purchase imports. Rather than typing from a physical invoice printout, you can request the digital CSV or Excel invoice from your distributor (or download it from their supplier portal) and upload it directly.

"By mapping columns like Product Name, Batch Number, Expiry Date, MRP, Purchase Price, and GST once, you can upload a 100-item invoice in under 10 seconds."

How to Import Purchase Invoices in PharmaDesk

PharmaDesk includes a highly smart importer built for Indian distributors. Here is the simple import process:

1. Select Supplier: Choose the distributor from your list or add a new supplier profile.
2. Upload File: Select the CSV/Excel file sent by the supplier.
3. Map Columns: Drag and drop column headers to map variables. PharmaDesk automatically remembers this mapping for subsequent bills from the same distributor.
4. Review & Approve: View the preview grid. PharmaDesk automatically flags near-expiry items and creates new inventory slots for new medicines. Click **Confirm Import** to update your stock instantly.

Aligning with GSTR-2B Reconciliation

Importing digital purchase bills ensures your software's record of wholesale purchases exactly matches the GSTR-2B data filed by your distributors on the GST portal. This eliminates tax audit mismatches, saves your accountant days of work, and secures your input tax credit (ITC) deductions.