Build an Invoice Template in Excel or Google Sheets with Automatic Totals
You get a cell-by-cell invoice layout with exact formulas for line totals, discount, tax, due date, and a duplicate-proof invoice numbering system.
Prompt
Act as a spreadsheet specialist who builds billing templates for small businesses.
Your job: design a one-page invoice template with automatic totals that I can build in Excel or Google Sheets.
Before you start, ask me these questions in one message and wait for my answers:
1. Excel or Google Sheets?
2. What sales tax or VAT rate do I charge, and does it apply to every item?
3. Do I offer discounts: none, a percentage, or a fixed amount?
4. What are my payment terms (for example, Net 30) and currency?
Rules:
- Give every element an exact cell address and every formula exactly as I would type it, using only functions that work in my chosen app.
- Empty line-item rows must show blank, never 0 or an error like #VALUE!.
- Calculate the due date from the invoice date and payment terms with a formula.
- Include an invoice-numbering method that prevents duplicates, plus a check formula that flags a repeated number.
- Round line totals and tax to 2 decimals so my totals match what a client calculates.
Output format:
1. Layout table with columns: Cell | Label or content | Formula | Format
2. Invoice numbering: method, formula, and duplicate check
3. Protection and data validation steps (numbered)
4. How to reuse the template for the next invoice (3-5 steps)
End with one line listing your assumptions. Note that this is not tax advice and I should confirm tax rules with an accountant.Example output
Tips and common edits
Why this works
- Asking for app, tax, discount and terms first means formulas match the user's setup instead of a generic guess.
- Requiring exact cell addresses and blank-on-empty formulas produces a sheet that works on first build without error cells.
- A logged numbering scheme plus a COUNTIF check stops duplicate invoice numbers, a common bookkeeping problem.
Use this when you bill clients and want a reusable invoice without paid software. Know your tax rate, discount policy and payment terms. Works in ChatGPT, Claude or Gemini.
Common edits
- Ask for a fixed-amount discount line instead of a percentage.
- Request a version with two tax rates, for example taxable services and tax-exempt items.
Prompt details
- By
- Prompts-GPT editors
- Published
Did this prompt work?
Keep exploring
More like this
Build an Employee Shift Schedule and Hours Tracker with Overtime in Excel
You get a ready-to-build spreadsheet layout with formulas for overnight shifts, unpaid breaks, weekly hours per employee and highlighted overtime.
Build an Inventory Tracker Spreadsheet with Reorder Points and Low-Stock Alerts
You get exact columns, copy-ready reorder-point formulas, a status column and conditional formatting that highlights items to reorder now or this week.
Build Excel and Google Sheets Formulas for Workdays, Ages and Deadlines
You get working date formulas for your exact layout, such as workdays, deadlines, ages and month offsets, with a holiday table, locale pitfalls and a test row.
Clean and Standardize Messy Spreadsheet Data with Exact Formulas
Get a column-by-column cleaning plan with ready-to-fill formulas for spaces, case, dates and duplicates, plus a list of rows that need a manual check.
Build a Break-Even and Pricing Calculator Spreadsheet in Excel
You get an Excel layout that separates fixed and variable costs, formulas for break-even and margin at three prices, and a ranking of which inputs move the result most.
Design a One-Page Manager Dashboard in Excel or Google Sheets
Get a buildable one-page dashboard plan with a layout grid, a spec for each tile (metric, chart, filter, source range, formula) and numbered build steps.