AI Bill → ExcelGarment & TextileDesktop App

Purchase bills to stock-ready Excel — in seconds, not hours.

Bill Scanner Pro reads garment and textile purchase bills the way a trained operator would — PDFs, phone photos, scans, Word or Excel files — and turns them into a clean 30-column stock sheet with GST, WSP, MRP, sizes, colours and barcodes already worked out.

Runs onWindows 10/11macOSGemini · Claude · OpenAIOffline OCR mode
Bill Scanner Pro — Review & Edit · INV-2527
Rows extracted
48
Vendor GST
08AAB…1Z5
WSP total
₹61,420
DesignItemSizeColourWSPMRP
GULEL 2527Saree6.3 MRio Red₹840₹1,490
GULEL 2528Saree6.3 MPeacoat₹840₹1,490
LP 2001KurtiMRama Green₹399₹790
LP 2002KurtiLFirozi₹399₹790
JN 118Jeans32Indigo₹620₹1,290
Exported INV-2527.xlsx · 48 rows
10+
Input formats — PDF, image, DOCX, XLSX, CSV
30
Stock columns exported per bill
2,300+
Pantone shade names for colour detection
60–70%
Lower AI token usage via smart page rendering

From manual chaos to one clean system

Before

Typing every bill line by hand

  • Staff re-type hundreds of design numbers, sizes and rates from each vendor bill.
  • GST exclusive/inclusive, discounts and WSP get calculated differently by each person.
  • Size ranges (M–XXL) and design ranges (2527–2536) have to be expanded manually.
  • The same invoice gets entered twice and nobody notices until stock doesn't match.
  • Colour names are guessed, inconsistent, and hard to search later.
With Bill Scanner Pro

Scan → review → export

  • AI extracts every line item, vendor, GSTIN, HSN and bill details automatically.
  • One consistent WSP / GST-on-sale calculation everywhere in the app.
  • Quantities, size ranges and design-number ranges expand into individual rows.
  • Duplicate-invoice detection warns before a bill is processed twice.
  • Camera and photo colour detection names shades from the Pantone textile library.

Everything Bill Scanner Pro does

Built from real day-to-day operations, not a generic template.

Multi-AI extraction

Choose Google Gemini, Claude or OpenAI. Auto-select sends simple bills to a fast, cheap model and escalates blurry or complex ones to a stronger model.

Any bill format

PDF, JPG/PNG/WEBP/TIFF photos, scanned images, Word (.docx), Excel (.xlsx/.xls) and CSV/TXT — queue many files and process them in one batch.

Automatic failover

If Gemini's free tier is busy, the same request silently retries on OpenAI with your saved key — no bill lost to a temporary outage.

GST, WSP & MRP logic

Validates GST against legal garment slabs, computes WSP from exclusive/inclusive rates and discounts, and auto-applies the 5% / 18% GST-on-sale slab from MRP.

Review & Edit workspace

Nothing is saved until you approve it. Inline editing, dropdowns, multi-row bulk edit, live search, changed-cell highlighting and 10-level undo.

Clean Excel export

One worksheet per bill number, frozen styled headers, sensible column widths and real numeric cells — ready for your stock or ERP import.

Pantone colour scanner

Detect primary and secondary garment colours from a photo or webcam. 2,300+ Pantone textile names plus Indian trade shades like Rama Green, Firozi and Mehendi.

Duplicate invoice guard

Every saved bill is fingerprinted (bill no., vendor GST, date, item count). Likely duplicates trigger a warning showing exactly what matched.

Scan log & cost tracking

Every scan is logged with vendor, pages, items, model and input/output tokens, so you always know throughput and AI spend.

How it works

01

Add bills

Drop in PDFs, photos or spreadsheets — one bill or a whole batch.

02

AI reads them

Pages are rendered at the right resolution, quality-checked and sent to your chosen AI or local OCR.

03

Review & fix

Rules auto-fill GST, WSP, sizes and codes. Quick Fill, MRP Tools and AI Command clean up the rest.

04

Export to Excel

Get a 30-column workbook per bill, named and formatted, ready to import.

Module-by-module detail

Scanning engine

Smart rendering that cuts AI cost

Each PDF page is rendered at a resolution chosen for its content (120 DPI for digital text, 150 DPI for handwritten or scanned pages). Near-empty trailing pages are skipped and embedded text from Tally-style PDFs is used directly — reducing vision-token usage by an estimated 60–70%.

  • Sharpness & table-complexity check before any API call
  • Blurry-image confirmation to avoid paying for failed scans
  • Up to 5 retries with back-off on rate limits
  • Local OCR with PaddleOCR, EasyOCR or Tesseract
  • OCR-only mode needs no API key at all
  • Cancel any scan mid-way
Data rules

Garment-trade business rules, built in

Raw AI output is passed through a set of industry rules so the numbers are right before you even look at them.

  • Quantity 10 → 10 individual rows
  • Design ranges like GULEL 2527–2536 expanded
  • Size ranges M–XXL expanded
  • Vendor code derived from GSTIN / PAN
  • Brand derived from vendor name
  • Bill-wide GST normalisation
  • Item names validated against catalog
  • Saree always 6.3 M / 2 Pcs
Bulk tools

Quick Fill, MRP Tools & plain-English AI Command

Eleven Quick Fill tabs fill item, sub-item, gender, group, size, GST, price and discounts for selected rows, an IPN range, blanks only or everything. The MRP module offers seven pricing methods, and AI Command lets you type edits like “markup MRP by 80% where item is Saree”.

  • MRP: manual, %, IPN, WSP, slab, size-wise, colour-wise
  • Round-off to 50 / 90 / 99 / 00
  • Split one design into multiple sale rates (2@100, 2@200)
  • Auto barcode, item code & unique code sequences
  • Column Tools for bulk set / clear
  • Common commands run locally — free & instant
Colour & Rapid Scan

Name garment colours from the camera

Rapid Scan is a live-camera panel for tagging many garments quickly. It detects when a person rather than a garment is in frame, locks a reading only once it is stable, shows the top three candidates and auto-advances to the next unfilled row.

  • Pantone TCX name + code + match closeness
  • Indian trade shade names recognised on bills
  • Calibrate White removes shop-light tint
  • 5-frame averaging for dim light
  • Keyboard next / previous / skip
  • Photo upload for multi-colour pieces

Technical specifications

Platforms
Windows 10/11 desktop installer; macOS build
Input formats
PDF, PNG, JPG, WEBP, BMP, GIF, TIFF, DOCX, XLSX, XLSM, XLS, CSV, TSV, TXT
Output
Excel (.xlsx), one sheet per bill number, 30 columns
AI backends
Google Gemini, Anthropic Claude, OpenAI — or local OCR only
Local OCR
PaddleOCR, EasyOCR, Tesseract
Catalog
11 categories, ~90 built-in items with sub-items; fully editable
Data storage
Local on your PC — bills are not stored on our servers
Updates
In-app update check with safe download & install

Built for

Garment retailersSaree & ethnic wear storesTextile wholesalersMulti-brand fashion outletsBack-office data-entry teamsRetail ERP operators

Technology

PythonGemini APIClaude APIOpenAI APIPaddleOCRTesseractOpenCVopenpyxlPyMuPDFInno Setup

Frequently asked questions

It converts garment and textile purchase bills — PDFs, photos, scans, Word or Excel files — into a structured 30-column Excel stock sheet. AI reads the bill, industry rules calculate GST, WSP and MRP, and you review everything in an editable table before exporting.

PDF, JPG, PNG, WEBP, BMP, GIF and TIFF images, Word .docx, Excel .xlsx/.xls/.xlsm and CSV/TSV/TXT. You can queue multiple files and process them as a batch.

No. You can use Google Gemini (which has a free tier), Claude or OpenAI with your own API key — or run in OCR-only mode with no API key at all. With Gemini, typical cost is a fraction of a rupee per bill.

No. The app runs on your computer and saves Excel files locally. Only the bill pages you scan are sent to the AI provider you choose, using your own API key.

WSP = P. Rate × (1 + GST%) for exclusive GST, or P. Rate as-is for inclusive, then less any purchase discount. GST on sale is auto-applied: fabric at 5%, readymade garments at 5% below ₹2,500 MRP and 18% at or above — recalculated whenever MRP or item changes.

Yes. The colour scanner and Rapid Scan read colours from a webcam or uploaded photo and name them using 2,300+ Pantone textile shades plus common Indian trade names like Rama Green, Firozi and Mehendi Green.

Yes. Sigill Infotech can adapt columns, item catalogs, code formats and pricing rules to match your ERP or stock software import format.

Live demo · Setup support · Custom changes

Stop typing bills. Start scanning them.

See Bill Scanner Pro convert one of your own vendor bills live. We'll help with setup, your item catalog and Excel format.