Hi Guessed,

Thank you very much for replying.

This page lists the available fields Xero has: Xero Central

You would expect «Balance» to be the one needed, since it says "Running total of sales invoices". But nope, that just shows the balance remaining on that invoice! Incredibly annoying.

I've been trying your second suggestion for nearly 2 hours now, without much success. The problem (I think) is that the statement shouldn't ever have an opening balance, so referring to cells above on invoice line one doesn't work.

I've now removed the opening balance row totally.

Do you happen to know what part of the statement is telling Xero how many invoice lines there should be?

Maybe if I can separate the codes for invoice 1 and invoices 2 to n, I can fix invoice 1 and use that as the static value?

Thanks again!