How to Prepare Invoices in
Excel and QuickBooks
A practical, step-by-step guide to building professional invoices manually in Excel and automatically in QuickBooks — plus the rules that keep them audit-ready.
An invoice is more than a request for payment. It’s a legal record of a sale, the document your accountant reconciles against bank deposits, and often the first professional impression a client has of how organized your business really is. Whether you’re a freelancer just starting out or a growing company deciding when to move off spreadsheets, knowing how to prepare invoices correctly — in both Excel and QuickBooks — is a skill worth mastering properly rather than improvising each time.
This guide walks through both approaches: building a clean, reusable invoice template in Excel from scratch, and generating one automatically inside QuickBooks Online. It also covers the invoice elements every business needs regardless of tool, and the common mistakes that cause late payments or bookkeeping headaches down the line.
What Every Invoice Must Include
Before opening Excel or QuickBooks, it helps to know what a complete invoice actually needs. Missing even one of these fields is one of the most common reasons invoices get disputed or delayed.
- A unique invoice number, sequential and never reused
- Invoice date and payment due date
- Your business name, address, and contact details
- The customer’s name and billing details
- A clear description of each product or service, with quantity and rate
- Subtotal, applicable tax, and the final total due
- Payment terms (for example, “Net 30”) and accepted payment methods
Rule: never skip the invoice number, even for a one-off client. Sequential numbering is what lets you and your accountant trace every dollar of revenue back to a specific transaction during a tax filing or audit.
Preparing an Invoice in Excel, Step by Step
Excel remains a solid choice for freelancers, very small businesses, or anyone who wants full control over layout without paying for software. Here’s how to build a reusable template.
1. Set up the header. Reserve the top rows for your business name, logo placeholder, address, and contact information, followed by the client’s billing details on the opposite side. Add clearly labeled cells for Invoice Number, Invoice Date, and Due Date.
2. Build the line-item table. Create columns for Description, Quantity, Unit Price, and Amount. In the Amount column, multiply quantity by unit price with a simple formula such as =Quantity*UnitPrice for each row, so totals update automatically if a quantity changes.
3. Add the subtotal, tax, and total. Use =SUM() to total the Amount column, then calculate tax as a percentage of the subtotal, and add a final Total row combining both. Locking these cells with a percentage-rate reference (rather than typing the tax rate into each formula) means updating the rate once updates every invoice built from the template.
4. Add payment terms and notes. Include a line for payment terms, accepted payment methods, and any late-payment policy, positioned clearly below the total so it isn’t missed.
5. Protect the formulas. Once the template is finalized, protect the cells containing formulas so quantity or price entries don’t accidentally overwrite a calculation. This is the single most common way Excel invoices end up with silently wrong totals.
6. Save as a template. Save the finished file as a template (.xltx) or a protected master copy, and create a new copy for every invoice rather than editing the master directly. This keeps your invoice numbering and formatting consistent over time.
Rule: keep a separate log sheet, or a simple running list, of every invoice number issued. Excel doesn’t auto-track invoice history the way accounting software does, so without a log it’s easy to accidentally duplicate a number or lose track of what’s outstanding.
Preparing an Invoice in QuickBooks Online, Step by Step
QuickBooks automates most of what has to be done manually in Excel, and directly ties every invoice to your accounts receivable and financial reports. Here’s the standard workflow.
1. Confirm your company details are set. Before creating your first invoice, check that your business name, address, and logo are correctly filled in under Settings, then Account and Settings, so every invoice pulls accurate contact information automatically.
2. Start a new invoice. Select the “+ New” button, then choose “Invoice.” Alternatively, go to Sales, then Invoices, and select “Create invoice.”
3. Select the customer. Choose the customer from the dropdown, or select “Add New” to create a new customer record if this is their first invoice. QuickBooks will automatically fill in any saved billing details.
4. Review invoice date, due date, and terms. QuickBooks sets these automatically based on your default settings, but they can be adjusted per invoice. The “Terms” field, such as “Net 30,” determines when the invoice is considered overdue.
5. Add products or services. Select each product or service from your saved list, or add a new one on the spot. QuickBooks pulls in the description and rate automatically, then calculates line totals, subtotal, and tax for you.
6. Set payment options. If you use QuickBooks Payments, turn on the payment methods you want to accept so the customer can pay directly from the invoice. You can also enable automatic payment reminders here.
7. Review and send. Select “Review and send” to email the invoice immediately, or “Save” to send later. Once sent, the invoice status updates to “Sent” and the transaction is automatically recorded in your accounts receivable.
Rule: set up your Products and Services list and customer records before you start invoicing regularly. Building both in advance is what makes QuickBooks invoicing genuinely fast — most of the time spent on a “slow” QuickBooks invoice is really time spent creating new customer or item records mid-invoice.
Excel vs. QuickBooks: Which Should You Use?
Excel makes sense when invoice volume is low, your needs are simple, and you want a free, fully customizable layout with no subscription cost. It requires more manual discipline, since nothing tracks payment status, sends reminders, or reconciles against your bank automatically.
QuickBooks becomes worthwhile once you’re sending invoices regularly, need to track who has and hasn’t paid, want automatic reminders and online payment collection, or need invoicing data to flow directly into your financial statements without manual re-entry. The subscription cost is usually offset quickly by the time saved on reconciliation and collections alone.
Common Invoicing Mistakes to Avoid
A few mistakes account for the majority of late payments and bookkeeping errors, regardless of which tool you use.
- Sending an invoice without a due date, leaving payment timing ambiguous
- Reusing or skipping invoice numbers, which breaks sequential tracking
- Leaving tax calculations manual and unchecked instead of formula-driven
- Failing to follow up on overdue invoices with a reminder
- Not keeping a copy of every invoice sent, whether in Excel or QuickBooks
QuickBooks vs Xero vs Zoho Books (New Guide 2026)
Key Takeaway
Excel gives you full control and zero cost for low-volume invoicing, as long as you protect your formulas and keep a manual invoice log. QuickBooks trades some of that manual control for automation, payment tracking, and direct integration with your books — a trade-off that pays off the moment invoicing becomes a regular part of running the business.
Frequently Asked Questions
Can I use an Excel invoice for tax purposes?
Yes, as long as it includes all the required fields — invoice number, date, business and client details, itemized charges, and tax — an Excel invoice is a valid business record for tax and accounting purposes.
How do I number invoices consistently in Excel?
Keep a separate log sheet listing every invoice number you’ve issued, in order, and manually increment the number each time you create a new invoice from your template. This avoids duplicates that automated software prevents by default.
Does QuickBooks automatically calculate tax on invoices?
Yes, once your sales tax settings are configured, QuickBooks calculates tax automatically based on the customer’s location and the products or services on the invoice.
Can I convert an Excel invoicing system into QuickBooks later?
Yes. Most businesses transition by importing their customer and product lists into QuickBooks first, then starting fresh invoice numbering going forward rather than trying to migrate old Excel invoice history record by record.