Automated Excel Billing Sheet Creation

I need a single Excel workbook that lets me enter raw sales data and instantly turns it into professional-looking bills. The sheet must pull every essential detail into the final print-ready invoice: • Customer information: name, full contact details, address, and account number • An itemised list of products or services with quantities, rates, and line totals • Clearly shown payment terms, plus auto-calculated subtotals, tax, discounts, and grand total Date handling is important—each invoice should grab the sale date, stamp a configurable due date, and feed those dates into a running tally so I can track what’s outstanding. A summary page that aggregates totals by day, week, and month will help me reconcile figures quickly. Please build the logic with standard Excel formulas; feel free to use VBA only where it makes the process noticeably smoother (for example, one-click “Generate Invoice” or “Clear Form” buttons). The final file must work on the latest Microsoft 365 desktop version without additional add-ins. Deliverables 1. Fully functioning Excel billing workbook 2. Brief PDF guide explaining where to paste raw data, how the invoice populates, and how to reset for the next customer 3. A small set of dummy data so I can test everything straight away I’ll consider the job complete once I can load the sheet, enter sample sales, click a button (or trigger the formula workflow), and print or PDF an invoice that meets the above requirements with zero manual edits.

Project ID: 40488203