You are currently viewing Customise Invoices in Xero: 7 Tips for Advanced Invoice Templates

Customise Invoices in Xero: 7 Tips for Advanced Invoice Templates

  • Post author:
  • Post category:News

Here are my top troubleshooting tips for the most common issues with Advanced Invoice Templates in Xero.

Use a Table Format for the Line Items (remove default Tab Format)

Replace the default Tab Format for the item rows with a Table Format. Add in a new Table with the number of columns you want, and copy/paste in the Field Codes to the columns in the table. You can easily adjust the width of the columns as well as removing any columns you don’t want. A couple of popular formats include:

  • Widening the Description Field and removing the Quantity Field.
  • Having the Description Field go across the entire width of the page, and the other fields in a row below.

I find it easiest to work with the table with borders showing, and then remove the borders at the end. Ensure you start with TableStart and finish with TableEnd codes. But between these codes, you can re-order, move, copy and delete any you don’t want.

«TableStart:LineItem»«ItemCode», «Description» «Quantity» «UnitAmount» «TaxPercentageOrName» «LineAmount» «TableEnd:LineItem»

Remove the Default Header

The sample Custom Invoice has a place holder for a picture in the header in the first page. It seems this is intended to make it easier for you to upload a logo but I have never found it helpful. It can be difficult to remove in the usual way as Rightclick/Delete does not remove it.

The easiest way is to highlight the entire header (the picture holder is inside the header) and delete that. You can then start afresh. There is no reason I have found to add a header for your logo if you only want your logo or header brand on the 1st page.

Stop the Item Code from printing

A common complaint is that the Item Code automatically prints on the sample Advanced Invoice Template. This is easily fixed.

The original code showing in the sample Advanced Invoice Template is:

«TableStart:LineItem»,«Description»

This will print the Item Description and the Item Code.

If you don’t want to print the Code, then remove the comma and the space.

«TableStart:LineItem»«Description»

Repeat the Header Row on multiple pages

When you change to a Table format you will find the Column Headers only print on the first page. This can be an issue if you have long invoices that go for multiple pages i.e. “Description” “Amount” “Quantity” etc. This is easily fixed with Table Formatting.

Search “Repeat Table Header on Subsequent Pages” in Word and you will find a couple of ways to do this.

  1. Select the header row or rows that you want to repeat on each page. The selection must include the first row of the table.
  2. Under Table Tools, on the Layout tab, in the Data group, click Repeat Header Rows.
Screenshot shows the cursor pointing to the option for Repeat Header Rows in Table Tools on the Layout tab in the Data group,  .

Or, you can use this approach:

  1. In the table, right-click in the row that you want to repeat, and then click Table Properties.
  2. In the Table Properties dialog box, on the Row tab, select the Repeat as header row at the top of each page check box.
  3. Select OK.


Keeping lines together (Subtotal / GST / Total)

Sometimes rows that you want to show together get split across a page. For example the 3 lines Subtotal, GST and Total split so that the Total might be the only line showing on page 2. This is also easily fixed in the table format. Simply add all the lines you want to stay together inside one row in the table.

Change date and number formatting

Xero has a great help article on how to adjust the date format, as well as the number of decimal places in a custom template in Xero. Here’s the link: https://central.xero.com/s/article/Change-the-amount-date-or-unit-price-format-on-custom-invoices-quotes-NZ-AU-UK#Changethedateformat

However, sometimes when you select Toggle Field Code to see the codes to change, there is nothing there so it’s hard to know where to start.

For Dates the full code should look like this:

{MERGEFIELD InvoiceDate\@ “dd MMM yyyy”*MERGEFORMAT}

Of course you can exchange “InvoiceDate” for whatever field you are using, and you can exchange “dd MMM yyyy” for whatever date format you want.

For Decimal Places the full code should look like this:

{MERGEFIELD UnitAmount# #,##0.00;(#,##0.00)}

Of course you can exchange “UnitAmount” for whatever field you are using, and you can exchange “#,##0.00” for whatever number format you want.

You need to be working in MS Word for these fieldcodes to be inserted. They may not upload correctly if you edit in GoogleDocs.

Insert a Hyperlink from a Logo or Picture

You can quickly insert a hyperlink simply by typing the name of the web address and pressing Enter. However, sometimes you might want a hyperlink from an image or logo rather than from text. To do this highlight the image or logo, then right click, go to Insert / Link and fill in the details in the pop up box. Control-K also works on some computers. The Screen Hint button allows you to type in text that shows when a cursor is hovered over the picture. Here’s what it looks like:

We love helping small businesses figure out creative ways to get Xero working the best it can. More time doing business – less time on admin! Talk to one of our Xero experts.