I issue single invoices paid over a long period in a schedule of installments. The due date is sometimes a year or more into the future. As payments are against a single invoice, there is no flag to let me know an installment is overdue. Issuing separate invoices for each installment is laborious and confusing for the customer (I tried it). As far as I can see, the only report that includes the due date is the unpaid invoices report. Unfortunately, it isn't downloadable as a data file. I'd like a a data file with rows as follows:
|Inv #||Customer||Reference||Full Amount||Amount Owed||Due Date|
I could then manipulate this data in Excel to work out WHEN customers owe their next installment.
If there is another way to handle scheduled pre-payments against a single invoice I would love to hear about it. Thank you.