Custom Invoice Formats in Zoho Books: The Limitation, the Elite Plan Option, and the Excel Macro Workaround

Here is the fix for the single most common request we get on this topic: a PO number that fills itself in on every invoice for a given customer, instead of being typed by hand each time. Go to Settings, then Invoices under Sales, then the Field Customization tab, then click + New Custom Field. Name it "PO Number," set the Data Type to Text, then click Inherit Value and choose Customers from the dropdown, followed by the specific field on the customer record you want it pulled from. Save. From that point on, every invoice you raise for that customer carries the PO number automatically, no typing, no copy-paste from an email thread.

Here is a second one, just as common: adding an item code or HSN/SAC column to the line-item table itself, not just the invoice header. This is a different settings screen from the one above, because it lives at the item level. Go to Settings, then Items, then Field Customization, then + New Custom Field. Set "Show when creating transactions" to Yes and "Show in transaction types" to Sales. Save, and the field now appears as its own column inside the item table on every invoice, sales order and quote, right alongside Quantity and Rate.

And a third, for anyone who needs a customer sign-off recorded on the document itself: open Settings, then PDF Templates under Customization, select Invoices, and edit your active template. Inside the editor there is a Layout option that controls font, colour and background per section, a Labels option that controls column widths in the item table, and a toggle for adding a second signature block so the customer can sign the invoice, not just you. None of the three examples above touch the HTML editor. They are all available in the visual editor, on the Standard plan and above.

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

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

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:

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

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

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.

---