Automated SQLite PDF Invoice Generator
Budget: ₹750 – ₹1,250 INR
I already have a fixed, branded invoice layout and an SQLite database that stores every invoice record. Between 10 and 20 fields—invoice number, dates, client info, line items, totals, taxes, and so on—need to be pulled from that database and merged into the PDF exactly as designed.
The task is to create a small utility that reads the SQLite file, lets me target one invoice, a date range, or every unpaid record, and then outputs a separate A4 PDF for each invoice. I’m happy with Python (ReportLab, WeasyPrint, FPDF) or any cross-platform approach that runs on Windows and Linux without paid libraries; just keep the code readable so I can tweak it later.
Deliverables
• Parameter-driven template replicating my current layout
• Source script that queries SQLite and fills the template
• Command-line or minimal GUI runner with basic filters (ID, date range, status)
• README covering setup, execution, and how to add new fields
Acceptance criteria
Generated PDFs must match the provided mock-up, populate every one of the 10–20 required fields correctly, and run in a clean environment with a single command. Feel free to request a sample schema or layout snapshot to get started.
The task is to create a small utility that reads the SQLite file, lets me target one invoice, a date range, or every unpaid record, and then outputs a separate A4 PDF for each invoice. I’m happy with Python (ReportLab, WeasyPrint, FPDF) or any cross-platform approach that runs on Windows and Linux without paid libraries; just keep the code readable so I can tweak it later.
Deliverables
• Parameter-driven template replicating my current layout
• Source script that queries SQLite and fills the template
• Command-line or minimal GUI runner with basic filters (ID, date range, status)
• README covering setup, execution, and how to add new fields
Acceptance criteria
Generated PDFs must match the provided mock-up, populate every one of the 10–20 required fields correctly, and run in a clean environment with a single command. Feel free to request a sample schema or layout snapshot to get started.