Question

Multi Line Invoice in Xero from Excel Data

  • 30 November 2020
  • 7 replies
  • 341 views

Userlevel 1

I am needing to create multiple lined invoices in Xero from Excel Data, how does the Excel sheet need to formatted to be able to create the right invoice?


This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

7 replies

Userlevel 1
Badge

Hi @jjackson 

Here are the fields the zap is looking for, if you create a column for each field.

Userlevel 1

Hi @andyc

Thanks but how does the Data need to be organised in Excel to create multiple invoice lines? Does the Excel file need additional columns for additional invoice lines?

When I add the data in there is no option to add additional invoice lines?

 

Userlevel 1
Badge

Hi @jjackson 

Yes you need additional columns.

The Zap gives you an option to add the additional lines.

What is the max number of additional lines you need?

How many invoices are you working with?

Do you create a quote before you create the invoice?

 

If you would like some training or someone to jump on a video call to go over this with you, one of experts team including myself provide those services.

https://experts.zapier.com/

 

 

Userlevel 1

i cant see in the Zap where i add the extra lines for the invoice … am i using the wrong template?

Userlevel 7
Badge +9

Hey @jjackson - How did you get on here?

One thing I haven’t seen mentioned in this thread is Zapier’s line itemizer. 

https://zapier.com/help/create/format/create-line-items-in-zaps - Introduction

https://zapier.com/help/doc/how-use-line-items-formatterv2 - More advanced functionality

Lastly, and the most useful help article is using these in your subsequent Zapier steps: https://zapier.com/help/create/basics/use-line-items-in-zaps

 

Line items are pretty advanced and are incredibly nuanced, so please do try it out and let us know how you get on. 

Userlevel 1
Badge

Thanks @andywingrave I was just looking at some of those links for @jjackson 

Userlevel 7
Badge +11

Hi @jjackson!

Since this was a little while ago, I wanted to check in to see if you’d managed to solve this or whether you still needed help here. Please let us know!