Hi Neville. I’m trying to do the same thing as thestores but I’m not having any success. I cannot get the “Xero Invoices Template v2” to post ANY payments to Xero.
Even if I do a simple invoice in columns A - V and then put the payment information into Columns W - AB, the invoice will upload fine but the payment data I’ve entered is always ignored and no payment is posted regardless of whether it’s a full or partial payment
Specifically regarding your last comment on adding a copy of the prior line with a value of $0. This does not upload the payment data in W - AB either, it just creates a second row on the invoice with a $0 amount and Xero drops the account from the line item since it has a $0 value.