Microsoft Office Invoice Template

What to include in an Office invoice workflow

Twelve fields. The first nine are what every US invoice needs to clear AP and satisfy state tax rules. The last three — OneDrive storage path, Outlook delivery with read receipt, and the Excel log entry — are what turn a one-off Word file into a workflow that survives an audit.

1. 01

   Business header (Word)

   Logo, legal business name, address, phone, email, and tax ID. Build it in Word's Header pane (Insert → Header) so it repeats if the invoice runs to a second page.

2. 02

   Client / bill-to block (Word)

   Legal entity name, AP contact, billing address, and a separate ship-to if it differs. Pull these straight from your Excel client log so the spelling is consistent every month.

3. 03

   Unique invoice number (Excel-driven)

   Maintain a sequential counter in Excel (column A on a 'Log' sheet) and reference it in the Word doc with Insert → Quick Parts → Field. Auditors flag gaps in invoice numbering.

4. 04

   Invoice date and due date

   Most US small businesses use Net 15 or Net 30. Type both as plain text — not Word DATE fields — so the dates don't auto-update if the recipient opens the file weeks later.

5. 05

   Project / PO reference

   Required by anyone with a formal AP process. Drop it under the invoice number — it's the second thing the AP clerk looks for when matching to a purchase order.

6. 06

   Itemized line-items grid (Word table style)

   Build a four-column table: Description, Quantity, Rate, Amount. Apply Word's built-in 'Grid Table 4 — Accent 1' table style for clean header banding without manual cell shading.

7. 07

   Subtotal, tax, total — Excel-linked or Word formula

   Two options: paste-link an Excel range (Paste Special → Paste Link) so the Word total auto-updates when you edit the spreadsheet, or use Layout → Formula → =SUM(ABOVE) inside the Word table. Press F9 to recalculate Word formulas.

8. 08

   Payment terms and accepted methods

   ACH details, check payable-to, card link, and a late-fee clause. "1.5% monthly interest on overdue balances" is the typical legal cap in most US states.

9. 09

   Footer with page numbers and contact

   Insert → Footer. Add 'Page X of Y' for multi-page invoices and a one-line 'Questions? email billing@…' so the AP clerk can resolve issues without forwarding.

10. 10

    Storage path (OneDrive)

    Save the working .docx to OneDrive\Invoices\{Client}\{YYYY}\ — that gives you per-client folders, automatic versioning, and a share link if the file ever exceeds Outlook's attachment cap.

11. 11

    Outlook send + read receipt

    Compose the email in Outlook, attach the PDF export, and turn on Options → Request a Read Receipt for important invoices. The recipient can decline, but you'll know if they opened it.

12. 12

    Archive copy + Excel log entry

    Drop a PDF copy into OneDrive\Invoices\Sent\ and add a row to your Excel log: invoice number, client, amount, date sent, date due, status. That log becomes your AR aging report.

The Office numbers your workflow needs to respect

Storage caps, attachment limits, file-format constraints. The numbers below are why the workflow is structured the way it is — skip them and you'll hit a 35 MB Outlook bounce or run out of OneDrive space mid-quarter.

The two numbers most people forget: the Excel row cap is effectively infinite for a small-business client log (a million rows is more than a century of weekly invoices), but Outlook's 35 MB attachment cap bites the moment you bundle scanned receipts or photo proof of work. Switch to a OneDrive share link as soon as the email approaches 25 MB.

How to invoice end-to-end across the Office suite

The six-step Word → Excel → OneDrive → Outlook loop that turns a downloaded .docx into a sent, tracked, archived, and logged invoice in under five minutes.

1. 1

   Build the invoice in Word from a .dotx master

   Download the .docx for your industry below, then File → Save As → Word Template (.dotx) and put it in your Custom Office Templates folder. Every double-click on the .dotx spawns a fresh untitled invoice — no risk of overwriting last month's file. Drop in the logo (Insert → Pictures), then Find & Replace the {{CLIENT_NAME}}, {{INVOICE_NUMBER}}, and {{DUE_DATE}} tokens.

2. 2

   Add the line items via an Excel-linked totals table

   Open your Excel client log, fill out the line items on a per-invoice tab (Description, Qty, Rate, Amount), and let Excel compute the subtotal, tax, and total. Select the totals range, copy, then in Word use Paste Special → Paste Link → Microsoft Excel Worksheet Object. The Word totals now auto-update whenever you edit the spreadsheet.

3. 3

   Save the .docx and PDF copy to OneDrive

   File → Save As, pick OneDrive\Invoices\{Client}\{YYYY}\, and save the editable .docx. Then File → Save As → PDF and save the PDF to the same folder with -final in the filename. OneDrive versioning keeps every prior save for 30 days, which is your safety net if a client disputes a number you changed.

4. 4

   Attach to Outlook with a read receipt

   In Outlook, compose a new message, drag the PDF into the body, and turn on Options → Request a Read Receipt before sending. For invoices over Outlook 365's 35 MB attachment cap (rare for invoices but common when you bundle backup docs), use Insert → Attach File → Share OneDrive Link instead so the recipient downloads from the cloud.

5. 5

   Archive a copy and log it in Excel

   Drop a duplicate PDF into OneDrive\Invoices\Sent\ and append a row to your master Excel log: invoice number, client, amount, date sent, date due, status (Sent / Paid / Overdue). Sort by date due to see what's coming up, by status to see what's overdue. That log is your AR aging report — no separate accounting tool needed below ~30 invoices/month.

6. 6

   Mark paid and reconcile when payment lands

   When the ACH or check clears, update the status cell from 'Sent' to 'Paid' and add the date received. Use Excel's conditional formatting to highlight any 'Sent' row past due in red — that becomes your weekly follow-up list. For card payments via Stripe or PayPal, paste the transaction ID into a Notes column so reconciling against your bank statement takes seconds, not minutes.

When to use Word vs Excel vs Outlook in the workflow

Each Office app does one job better than the others. Picking wrong at the start usually means rebuilding the invoice in a second app a week later. Use this table to assign each step to the right tool.

The honest answer: source layout in Word, calculate in Excel, store in OneDrive, send through Outlook. The recipient should never receive an editable file unless they've explicitly asked for one — always export the Word doc to PDF first.

When the Office workflow is the wrong tool

• You don't pay for Microsoft 365. The free Office Online tier exists but lacks Outlook desktop features (read receipts, advanced rules) and caps OneDrive at 5 GB. If you live in Gmail and Google Drive instead, use the Google Docs invoice template — purpose-built for that suite.
• You only need a final, locked PDF. If the recipient never edits and you don't need a client log, skip the Word/Excel round trip and use the PDF invoice template directly — it's three steps shorter.
• You send 30+ invoices a month with payment links. At that volume the manual edit-export-attach-log loop is the bottleneck, not the layout. Move to invoicing software (Agiled, FreshBooks, QuickBooks) so numbering, reminders, Stripe/PayPal payment, and AR aging handle themselves.
• Your team collaborates live across phones and non-Microsoft accounts. Word's co-authoring assumes everyone's on Word 365 with OneDrive. If even one teammate is on a tablet or a personal Gmail, switch to Google Docs/Sheets — collaboration is faster from day one.

Microsoft Office invoice questions

Related templates