Free invoice templates: Excel and Word downloads
43 free files to download and use: invoice templates, receipts and statements, trackers and logs, wording packs and checklists in Excel, Word, PDF and plain text. The spreadsheets add up the totals for you; the Word documents you type straight into. Google Sheets and Google Docs can open them after conversion: check the totals. No sign-up, no email address.
They are blank starting points. Nothing is filled in for you, and they don’t connect to Charming Invoices or any other app: each file is yours to keep and edit.
Updated
Invoice templates (22 files)
Blank invoices to fill in and send. The spreadsheets add up the totals for you.
- Excel .xlsx
Invoice template for Excel
The general-purpose invoice: products, services or a mix, priced by quantity and rate.
- 15 lines where amount = quantity × rate, rounded to the cent
- Subtotal, fixed discount, one tax rate, total, amount paid and balance due, all calculated
- Due date worked out from the invoice date and your payment terms
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Invoice template for Excel - Excel .xlsx
Hourly invoice template for Excel
For time-based work: one line per day or task, billed by the hour.
- Date, description, hours and hourly rate on each of 15 lines
- Total hours added up for your client to check
- The same calculated totals block as the general invoice
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Hourly invoice template for Excel - Word .docx
Invoice template for Word
The general invoice as a Word document, for people who would rather type than use cells.
- Logo box, From, Bill to and invoice details at the top
- A 10-line item table and a totals block you fill in
- Payment details and a notes / terms section
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Invoice template for Word - Word .docx
Service invoice template for Word
For a job: what you did, where and when, then labour and materials.
- Description of work: job, site address, dates and work performed
- Labour and materials table
- Totals with a line for the deposit already paid, then the balance due
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Service invoice template for Word - Excel .xlsx
Catering invoice template for Excel
For caterers: food and drink per guest, staffing, equipment hire and delivery.
- Starter lines for per-guest food and drink, staff hours, hire, delivery and a service charge
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Catering invoice template for Excel - Word .docx
Catering invoice template for Word
For caterers: food and drink per guest, staffing, equipment hire and delivery.
- A description-of-work box for the event, venue and dates
- Starter lines for food, staff, hire, delivery and a service charge, and a deposit line
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Catering invoice template for Word - Excel .xlsx
Cleaning invoice template for Excel
For cleaners: dated visits, deep cleans, add-ons, supplies and office contracts.
- A date on every line, for each visit
- Starter lines for cleans, add-ons and supplies
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Cleaning invoice template for Excel - Word .docx
Cleaning invoice template for Word
For cleaners: dated visits, deep cleans, add-ons, supplies and office contracts.
- A description-of-work box for the service address, date and rooms
- Starter lines for a deep clean, add-ons and supplies, and a deposit line
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Cleaning invoice template for Word - Excel .xlsx
Photography invoice template for Excel
For photographers: session fee, editing, deliverables, prints, travel and usage licence.
- Starter lines from the session fee to the usage licence
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Photography invoice template for Excel - Word .docx
Photography invoice template for Word
For photographers: session fee, editing, deliverables, prints, travel and usage licence.
- A description-of-work box for the shoot, venue and dates
- Starter lines from the session fee to the usage licence, and a deposit line
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Photography invoice template for Word - Excel .xlsx
Moving company invoice template for Excel
For movers: crew and truck hours, travel time, packing materials and extras.
- Starter lines for crew hours, travel time, boxes and supplies, and extras
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Moving company invoice template for Excel - Word .docx
Moving company invoice template for Word
For movers: crew and truck hours, travel time, packing materials and extras.
- A description-of-work box for the move date and addresses
- Starter lines for crew hours, travel time, materials and extras, and a deposit line
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Moving company invoice template for Word - Excel .xlsx
Event planner invoice template for Excel
For event planners: a planning fee, event-day hours and vendor costs passed on.
- Starter lines for the planning fee, coordination hours and vendor costs
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Event planner invoice template for Excel - Word .docx
Event planner invoice template for Word
For event planners: a planning fee, event-day hours and vendor costs passed on.
- A description-of-work box for the event date and venue
- Starter lines for the planning fee, coordination hours and vendor costs, and a deposit line
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Event planner invoice template for Word - Excel .xlsx
Snow removal invoice template for Excel
For snow contractors: storms by date, pushes, salt, sidewalks and loader hours.
- Starter lines for two storms, each with its pushes, salt and sidewalk visits
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Snow removal invoice template for Excel - Word .docx
Snow removal invoice template for Word
For snow contractors: storms by date, pushes, salt, sidewalks and loader hours.
- A description-of-work box for the storm, property and date
- Starter lines for pushes, salt, sidewalks and loader hours
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Snow removal invoice template for Word - Excel .xlsx
Therapy invoice template for Excel
For therapists who bill clients directly: one line per session, plus a late cancellation.
- A date on every line, for each session
- Starter lines for sessions and a late cancellation
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Therapy invoice template for Excel - Word .docx
Therapy invoice template for Word
For therapists who bill clients directly: one line per session, plus a late cancellation.
- Starter lines for sessions and a late cancellation
- A paid-at-session line before the balance due
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Therapy invoice template for Word - Excel .xlsx
Bookkeeping invoice template for Excel
For bookkeepers: a monthly package, last month's extras and catch-up hours.
- Starter lines for the package, extras by count, catch-up hours and a year-end package
- Rates left blank: you type your own
- Subtotal, discount, one tax rate, total, amount paid and balance due, all calculated
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Bookkeeping invoice template for Excel - Word .docx
Bookkeeping invoice template for Word
For bookkeepers: a monthly package, last month's extras and catch-up hours.
- Starter lines for the package, extras by count, catch-up hours and a year-end package
- A deposit line before the balance due
- Rates and totals left for you to type
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Bookkeeping invoice template for Word - Excel .xlsx
Estimate or quote template for Excel
Price a job before you start: scope, line items, a valid-until date and an optional deposit.
- Valid-until date worked out from the estimate date and the days it stands
- 15 lines with subtotal, discount, tax and estimate total, all calculated
- Deposit to start as a percentage or a fixed amount, and an acceptance block
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Estimate or quote template for Excel - Word .docx
Estimate or quote template for Word
The estimate as a Word document: scope of work, prices, deposit and acceptance lines.
- Scope of work box: job, site address, timing and work included
- An 8-line price table and a totals block with a deposit line
- Assumptions and exclusions, and lines for the client to accept
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Estimate or quote template for Word
Receipts and statements (3 files)
For after the invoice: confirm a payment, or show a client everything they owe.
- Excel .xlsx
Statement of account for Excel
For a client with several unpaid invoices: one page listing each one, what is left and how late it is.
- 20 rows where balance and days overdue are calculated from the statement date
- Ageing summary: Current, 1 to 30, 31 to 60, 61 to 90 and 90 plus days, with the total due
- Amount due now and not yet due, payment details and a filled-in example tab
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Statement of account for Excel - Excel .xlsx
Receipt template for Excel
Confirm a payment: paid in full, a part payment against an invoice, or a cash sale with change.
- Receipt number, date received, payment method list and the invoice it settles
- Amount received, paid to date and balance still due, all calculated
- Cash tendered and change given for cash sales
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Receipt template for Excel - Word .docx
Receipt template for Word
The same receipt as a Word document, for people who would rather type than use cells.
- Receipt details: number, date received, payment method and the invoice it settles
- Amount received, paid to date, balance still due, cash tendered and change given
- A received-by line for a name and signature
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Receipt template for Word
Trackers and logs (6 files)
Spreadsheets for your own records: what you sent, what was paid, where the time went.
- Excel .xlsx
Invoice tracker for Excel
Every invoice you have sent on one sheet, with its balance, status and how many days late it is.
- Balance, status, days overdue and ageing bucket worked out for up to 499 invoices
- An ageing summary: total outstanding, what is overdue and how late
- A filled-in example of nine invoices, with the results to check against
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Invoice tracker for Excel - Excel .xlsx
Weekly timesheet for hourly work
For anyone who bills by the hour: log a week of time, split billable from non-billable, and get the hours and amount to put on the invoice.
- 30 entries a week: date, project or task, billable Yes or No, hours as decimals
- Rounding setting: none, nearest 0.25 h or up to the next 0.25 h, applied to each entry
- Week total, billable and non-billable hours, hours to invoice and the amount at your rate
- Hours by day, Monday to Sunday, and a filled-in Example tab
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Weekly timesheet for hourly work - Excel .xlsx
Invoice numbering log
A record of every invoice number you issue, from any app or template, that flags duplicates and gaps and suggests the next number.
- 200 rows: number, date, client, amount, status (Draft, Sent, Paid or Void) and notes
- Duplicate check on every number, and gaps or out-of-order numbers named
- Prefix and digits settings, and the next number worked out for you
- Count and amount by status, and a filled-in Example tab
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Invoice numbering log - Excel .xlsx
Expense reimbursement sheet
For costs you pay on a client's behalf: log each one with its receipt, add any agreed markup, and see what is still to bill.
- 100 rows: date, supplier, what it was for, category, receipt reference, amount and tax
- Markup % per expense, with the markup and billable amount worked out
- A Billed on invoice column, with billed and not-yet-billed totals
- Totals by category (categories you can rename) and a filled-in Example tab
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Expense reimbursement sheet - Excel .xlsx
Retainer tracker
For prepaid and drawdown retainers: a running balance of money paid in, work drawn from it and anything refunded, with a low-balance alert.
- 60 rows: date, what happened, invoice number, paid in, work billed and refunded
- Paid from retainer, amount due and the balance after each row, worked out
- Opening balance and low-balance alert level, with OK, Low, Empty or Check
- A filled-in Example tab with a drawdown retainer
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Retainer tracker - Excel .xlsx
Mileage log
For trips you bill to clients: log each journey from the odometer, mark it billable, and total the miles at the rate you agreed.
- 150 rows: date, from, to, purpose, client, start and end odometer, billable Yes or No
- Miles worked out from the odometer readings, with a check for a reading typed the wrong way round
- Total miles, billable miles and billable amount; the rate per mile is left blank for the rate you agreed
- A filled-in Example tab
Made for Excel. Google Sheets can open it after conversion: check the totals. Formulas checked by script on .
Download .xlsx: Mileage log
Wording to copy (4 files)
Emails, terms and notes to adapt and paste into your own invoices and messages.
- Word .docx
Invoice email templates for Word
Emails to send an invoice in 12 situations, and a 4-step follow-up for one that is overdue.
- 12 emails for sending an invoice, one per situation, each with a subject line
- A 4-step follow-up sequence for an overdue invoice, with example timing
- Every subject line in one list, and 7 example variables for tools that fill them in
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Invoice email templates for Word - Text .txt
Invoice email templates as plain text
The same emails as a plain text file, the easiest version to copy into any email app.
- 12 emails for sending an invoice, one per situation, each with a subject line
- A 4-step follow-up sequence for an overdue invoice, with example timing
- Every subject line in one list, and 7 example variables for tools that fill them in
Plain text, so you can copy each piece straight into your email or invoice.
Download .txt: Invoice email templates as plain text - Word .docx
Invoice terms and notes examples for Word
Example wording to adapt for the Terms and Notes boxes on your invoice. General information, not legal or tax advice.
- 10 example terms, by situation, with placeholders in [square brackets]
- A complete Terms and Notes example for one invoice
- 6 example notes: thank-you, next step, delivery, reference and more
Made for Word. Google Docs can open it after conversion: check the layout and the totals.
Download .docx: Invoice terms and notes examples for Word - Text .txt
Invoice terms and notes examples as plain text
The same terms and notes examples as a plain text file, to paste into any invoice. General information, not legal or tax advice.
- 10 example terms, by situation, with placeholders in [square brackets]
- A complete Terms and Notes example for one invoice
- 6 example notes: thank-you, next step, delivery, reference and more
Plain text, so you can copy each piece straight into your email or invoice.
Download .txt: Invoice terms and notes examples as plain text
Checklists (8 files)
One-page checklists to print or keep beside you.
- PDF
First-invoice checklist (A4)
For your very first invoice: the seven things it needs, ticked off one by one.
- The seven things every invoice needs, in plain words
- Five checks before you send it
- One printable page
A PDF to print, or to keep open while you work.
Download .pdf: First-invoice checklist (A4) - PDF
First-invoice checklist (US Letter)
For your very first invoice: the seven things it needs, ticked off one by one.
- The seven things every invoice needs, in plain words
- Five checks before you send it
- One printable page
A PDF to print, or to keep open while you work.
Download .pdf: First-invoice checklist (US Letter) - PDF
What belongs on an invoice: field checklist (A4)
Check any invoice against the 11 essentials before it goes out.
- The 11 essential fields, with what to write in each
- The extras worth adding, and what to leave off
- A pointer to the official sources for your country's rules
A PDF to print, or to keep open while you work.
Download .pdf: What belongs on an invoice: field checklist (A4) - PDF
What belongs on an invoice: field checklist (US Letter)
Check any invoice against the 11 essentials before it goes out.
- The 11 essential fields, with what to write in each
- The extras worth adding, and what to leave off
- A pointer to the official sources for your country's rules
A PDF to print, or to keep open while you work.
Download .pdf: What belongs on an invoice: field checklist (US Letter) - PDF
Client onboarding checklist for billing (A4)
What to settle with a new company client before you send the first invoice.
- Legal name, billing contact and the accounts payable email
- Purchase orders, supplier forms, payment method, terms and payment runs
- Lines to note the details you collect
A PDF to print, or to keep open while you work.
Download .pdf: Client onboarding checklist for billing (A4) - PDF
Client onboarding checklist for billing (US Letter)
What to settle with a new company client before you send the first invoice.
- Legal name, billing contact and the accounts payable email
- Purchase orders, supplier forms, payment method, terms and payment runs
- Lines to note the details you collect
A PDF to print, or to keep open while you work.
Download .pdf: Client onboarding checklist for billing (US Letter) - PDF
Late-payment follow-up schedule (A4)
Plan every reminder and follow-up from the due date, and write in the dates.
- Before-due and due-date reminders, then the four follow-up steps
- A table to write in the date of each step and tick it off
- Checks before each step, and when to pause
A PDF to print, or to keep open while you work.
Download .pdf: Late-payment follow-up schedule (A4) - PDF
Late-payment follow-up schedule (US Letter)
Plan every reminder and follow-up from the due date, and write in the dates.
- Before-due and due-date reminders, then the four follow-up steps
- A table to write in the date of each step and tick it off
- Checks before each step, and when to pause
A PDF to print, or to keep open while you work.
Download .pdf: Late-payment follow-up schedule (US Letter)
Excel or Word?
Pick Excel if you want the numbers done for you. Every amount, the subtotal, tax, total and balance due are formulas, so a changed quantity or rate updates the whole invoice and you never add anything up by hand. Pick Word if you mostly write descriptions and have one or two lines to price: it is easier to type paragraphs into, but you work out the totals yourself.
Bill by the hour? The hourly spreadsheet adds a date to every line and totals the hours. Billing a job with a deposit, like a repair or an installation? The service invoice for Word has a description of the work and takes the deposit off the balance due.
Filling in the Excel templates
- Type over the placeholder text (Your business name, Client name and so on). The cells meant for you are lightly shaded; everything unshaded works itself out. The shading is faint enough to barely show on paper.
- Add your logo inside the dashed box: in Excel use Insert > Pictures, in Google Sheets Insert > Image > Image over cells, then delete the words “Your logo”.
- Fill in the invoice date and a line per item. The cells check what you type: a date has to be a date, quantities and rates can’t be negative, and the tax rate must be 0 or a plain number from 1 to 100.
- Give every invoice its own number (INV-0001, INV-0002…) and save a copy per invoice, so past invoices stay exactly as you sent them. The second tab, How to use, repeats these steps inside the file.
How the formulas work
- Amount (each line)
- Quantity × rate, or hours × hourly rate. It stays blank until both numbers are in, so unused lines print empty.
- Due date
- Invoice date + payment terms in days. Terms start at 30; change them to 14, 7 or 0 for due on receipt.
- Subtotal
- Every line's amount added up.
- Tax
- (Subtotal − discount) × tax rate ÷ 100, rounded to the cent. Type the rate as a plain number: 20 for 20%. The cell refuses 20% and 0.2, because Excel stores both as 0.2, which would charge 0.2%. Leave it blank if you don't charge tax.
- Total
- Subtotal − discount + tax, never below 0. If the discount is more than the subtotal, the total stops at 0 and a red note under the totals says so.
- Balance due
- Total − amount paid, so a deposit or part-payment comes off what the client still owes.
- Total hours (hourly only)
- Every line's hours added up, for your client to check against their own records.
Amounts show two decimals and no currency symbol, so the files work in any currency. To show one, select the amounts and choose a currency number format. The key cells are named (InvoiceDate, Subtotal, TaxRatePercent, BalanceDue and so on), so you can jump to them from the Name Box in Excel.
Filling in the Word templates
- Click into any placeholder and type over it. To add your logo, click inside the dashed box and use Insert > Pictures (Word) or Insert > Image (Google Docs).
- Fill in the item table. Press Tab in the last cell to add a row; right-click a row to delete one you don’t need.
- Work out the totals: amount = quantity × rate, subtotal = the amounts added up, tax = (subtotal − discount) × tax rate, total = subtotal − discount + tax, and balance due = total − anything already paid. The same steps are in a short italic note under the totals; delete it before you send the invoice.
Using them in Google Sheets or Google Docs
There is no shared Google copy to request access to. Download the file, then in Google Drive choose New > File upload and pick it. Open it with Open in Google Sheets (or Open in Google Docs); that edits it as an Office file, and to turn it into a Google file you then use File > Save as Google Sheets (or Save as Google Docs). Google says some features of Office files may be lost or altered when it converts them, so check the totals and the page layout before you send an invoice.
Sending it as a PDF
Send clients a PDF rather than the editable file: it looks the same on every device and can’t be changed by accident. In Excel or Word use File > Save As (or Export) and pick PDF; in Google Sheets or Docs use File > Download > PDF document. The spreadsheets have their print area set to the invoice alone, scaled to one A4 or Letter page. The Word documents are set to A4: if you print on Letter, change the paper size in Word’s page setup and check the preview first.
What a template file won’t do
A file only knows about itself. It can’t pick the next invoice number, remember a client’s details, tell you which invoices are unpaid or remind anyone when one is overdue: that record-keeping is yours, usually in a folder of saved copies and a list of what has been paid.
Invoice templates by trade
A worked sample invoice for each trade, with typical line items, the details clients in that line of work expect, and a blank PDF to print and fill in by hand.
- An auto repair invoice that separates parts, labour and the car
- A DJ invoice for a wedding: set times, add-ons and the deposit
- An electrician invoice for a 200 A panel upgrade
- A handyman invoice for a five-job visit
- An hours-worked invoice: dated tasks, weekly subtotals, one rate
- An HVAC service invoice with refrigerant, parts and the agreement
- A landscaping invoice for a month of visits and a bed refresh
- A painter's invoice for an interior repaint in a 1971 house
- A plumbing invoice for an after-hours leak and a new water heater
- A roofing invoice for an insurance-claim reroof, priced by the square
- A towing invoice that itemizes the hook, the miles and the lot
- A trucking invoice a broker can match to the rate con
Questions
Are these templates really free?
Can I share the files?
Do the totals calculate in Google Sheets?
Why doesn't the Word template add up the totals?
Can I add more lines?
Will the tax work for my country?
Can I import a filled-in template into Charming Invoices?
Or let Charming Invoices do the numbering and the maths
Sign up free and pick from 60 invoice templates. Invoice numbers, totals and tax are worked out for you, and every invoice goes to your client as a PDF with your logo and colours. The free plan has no trial clock and needs no card.