The current report format 'groups' invoice details of one customer with the name of another customer, there is no blank row separation:
| ID No. | Date | Total Due | 0 - 30 | 31 - 60 | 61 - 90 | 90+ |
| XXX Pty Ltd | ||||||
| ABC123 | ||||||
| 0% 1st Net 30th after EOM | ||||||
| 00010900 | 28/02/2019 | $352.00 | $352.00 | $0.00 | $0.00 | $0.00 |
| Total: | $352.00 | $352.00 | $0.00 | $0.00 | $0.00 | |
| XXX2 Pty Ltd | ||||||
| ABC124 | ||||||
| 0% 1st Net 30th after EOM | ||||||
| 00010901 | 28/02/2019 | $533.50 | $533.50 | $0.00 | $0.00 | $0.00 |
| Total: | $533.50 | $533.50 | $0.00 | $0.00 | $0.00 |
The proposed format below makes it easier to see details that relate to a customer. There is clearer separation between the invoice details of one customer and the name of the next customer:
| ID No. | Date | Total Due | 0 - 30 | 31 - 60 | 61 - 90 | 90+ |
| XXX Pty Ltd | ||||||
| ABC123 | ||||||
| 0% 1st Net 30th after EOM | ||||||
| 00010900 | 28/02/2019 | $352.00 | $352.00 | $0.00 | $0.00 | $0.00 |
| Total: | $352.00 | $352.00 | $0.00 | $0.00 | $0.00 | |
| XXX2 Pty Ltd | ||||||
| ABC124 | ||||||
| 0% 1st Net 30th after EOM | ||||||
| 00010901 | 28/02/2019 | $533.50 | $533.50 | $0.00 | $0.00 | $0.00 |
| Total: | $533.50 | $533.50 | $0.00 | $0.00 | $0.00 |
What do others think?
"Separate the Supplier or Customer details in the Aged Payables and Receivables report with two blank rows and remove one blank row between Card ID and invoice terms"