Disclaimer: Zoho Books features and plan inclusions change periodically. Verify current plan details at zoho.com/books/pricing before making any subscription decisions. This article is based on current plan structure as of July 2026. Contact us if you need help evaluating the right plan for your business.
One of the most common frustrations we hear from Zoho Books clients goes like this: "We have a very specific invoice format our customers expect — or that we are legally required to use — and Zoho simply will not let us recreate it." They are right. And it is not a bug. It is a deliberate product constraint that has a specific reason, a paid unlock, and a practical workaround.
This post explains exactly what Zoho Books allows in terms of invoice customisation, what is locked, what the Elite plan unlocks, and how to solve the problem without upgrading if the Elite plan is not justified for your situation.
What Zoho Books Actually Lets You Do With Invoice Templates
Zoho Books comes with a set of pre-built invoice templates. On the Standard, Professional and Premium plans, you can customise these templates through a visual editor. What you can change includes:
- Your company logo, address, and contact details
- Colours — background, accent, text colours
- Font family and size
- Which fields to show or hide — you can add or remove columns, toggle labels, rename field titles
- Header and footer content — custom text, bank details, terms and conditions, payment notes
- Paper size and orientation
What you cannot change through the visual editor:
- The structural layout of the template — where the invoice number sits, how the item table is arranged, the position of totals relative to other elements
- Adding completely new sections or tables outside the predefined template zones
- Changing the fundamental flow — for example, a two-column header layout vs a stacked layout
- Custom calculations or conditional display logic in the template itself
The core limitation: The Zoho Books template editor works within a fixed structural frame. You can paint the walls and change the furniture, but you cannot move the walls or add a room. If your required invoice format has a fundamentally different structure from Zoho's templates — different column arrangement, specific placement of totals, custom signature blocks, multi-table layouts — the visual editor will not get you there.
This is not an oversight. Zoho constrains this deliberately so that templates render consistently across different browsers, PDF exporters, and email clients. Fully free-form HTML templates introduce rendering variability that Zoho does not want to support across all environments on all plans.
What the Elite Plan Unlocks
Zoho Books Elite plan (currently $150/month per organisation) includes the ability to create invoice templates from scratch using HTML and CSS. This is called custom PDF templates and it gives you complete control over the layout.
With HTML/CSS templates you can:
- Build any layout structure you need — two-column, grid-based, specific positioning of every element
- Use Zoho placeholder variables to pull in live data (invoice number, customer name, line items, totals, custom fields) into your own HTML layout
- Add custom sections, signature blocks, watermarks, page-specific headers, and multi-section layouts
- Match a legally mandated or client-specific format exactly
Settings → Customisation → PDF Templates → Invoices → + New
In the template editor, switch from the visual editor to the HTML editor. You will see a full HTML/CSS editor with a list of available Zoho placeholders in the sidebar. Build your layout using standard HTML and CSS — JavaScript is not supported. Save and set as default.
When the Elite plan makes sense: If you are on Zoho Books for a business with a specific invoice format that is legally required (logistics, export businesses, government contractors), or if your clients refuse to accept invoices in a non-standard format and this is costing you business — the Elite plan is worth evaluating. $150/month is significant for a small business but trivial for a mid-size company where the invoice format issue is causing real friction.
When it does not make sense: If your customisation need is cosmetic — you want the logo bigger, or the colours to match your brand more closely — the visual editor on lower plans is sufficient. The HTML template is overkill and the upgrade cost is not justified.
The Practical Workaround: Excel Macro Invoice
If you cannot justify the Elite plan upgrade and you have a specific invoice format you need to produce, there is a reliable workaround that we have set up for multiple clients. It works like this:
Create the invoice normally in Zoho Books
Enter all the invoice data — customer, line items, quantities, rates, taxes — exactly as you would for any invoice. The Zoho Books record is your source of truth for accounting purposes. It feeds your books, your GST returns, your reconciliation. Do not skip this step.
Export the invoice data from Zoho Books
Go to Invoices → select the invoice → Export. Zoho allows you to export invoice data as CSV or Excel. You can also set up an automatic export via Zoho Books API or Zoho Flow if you want this triggered automatically when an invoice is created. For manual workflows, the export takes about 20 seconds.
Run the Excel macro
You prepare an Excel workbook in advance with your exact invoice format built as a template — your layout, your branding, your column structure, your totals placement, your signature block, whatever you need. A macro in this workbook reads the exported data and populates your template automatically. Press one button. Your formatted invoice is generated.
Export as PDF and send
From Excel, export the populated invoice as PDF. Send this PDF to your customer. The Zoho Books invoice record stays as your accounting document. The Excel-generated PDF is what the customer sees.
Building the Excel Macro Invoice: What You Need
The macro itself is a VBA (Visual Basic for Applications) script inside Excel. You do not need to be a developer to use one once it is set up — you press a button, it runs, done. But someone needs to build it once. Here is what the macro needs to do:
- Read the exported CSV or Excel file from Zoho Books
- Map the Zoho field names (Invoice Number, Customer Name, Item Description, Amount, Tax, Total, etc.) to the corresponding cells in your template
- Handle line item rows — loop through all line items and insert rows dynamically so your template expands correctly for invoices with 1 line item and invoices with 20
- Calculate and place totals — subtotal, tax, discount, grand total — in the correct cells
- Optionally: auto-export as PDF and save to a named folder
What we do for clients: We build the initial Excel macro workbook as a one-time setup. The client receives a workbook where they paste the exported Zoho data and click one button. Within seconds they have their formatted invoice PDF ready to send. We also build in basic validation — if required fields are missing, the macro flags it before generating the PDF.
Limitations of the Excel Macro Approach
This workaround is practical but not perfect. Be aware of these limitations before committing to it:
- Two documents per invoice: You will have a Zoho Books invoice (for accounting) and an Excel-generated PDF (for the customer). You need to track that these always stay in sync. If you edit the invoice in Zoho after generating the Excel PDF, you need to regenerate the PDF.
- Manual step in the process: Even with a well-built macro, there is a manual export-and-run step. This adds friction. It is manageable for businesses sending 10–30 invoices a month. It becomes cumbersome at higher volumes.
- Excel dependency: This requires Microsoft Excel with macros enabled. It does not work on Excel Online or Google Sheets. The person running the macro needs a desktop Excel installation.
- One-time setup investment: Building the macro correctly takes time — especially for invoices with complex line item structures or multiple tax rates. Budget for this as a one-time professional cost.
Which Option Is Right for Your Business
| Situation | Recommended approach |
|---|---|
| Minor branding changes — logo, colours, font | Visual editor (any plan) |
| Different column layout or structural format needed | Excel macro workaround |
| High volume (>50 invoices/month) with custom format | Elite plan — HTML template |
| Legally mandated invoice format | Elite plan — HTML template |
| Low volume, specific format, Elite not justified | Excel macro workaround |
| Format needed only for one specific client | Excel macro workaround |
A Note on the Zoho Books Spreadsheet Template
Zoho Books does offer a built-in Spreadsheet template option (Settings → PDF Templates → Invoices → +New → look for Spreadsheet templates). This is different from the HTML custom template. The Spreadsheet template gives you a slightly more flexible grid-based layout than the standard visual editor, and it is available without the Elite plan. It is worth exploring before committing to the Excel macro approach — it may get you close enough for some use cases. However, it is still constrained compared to full HTML, and for complex formats it will not be sufficient.
Need help building the Excel macro invoice for your business?
We set up the macro workbook as a one-time engagement. You give us your required invoice format, we build the macro, test it against your Zoho Books export, and hand it over with a simple instruction document. Usually completed in one week.
Talk to an Expert →