Raised invoices

When I was trying to run a report on raised invoices which ever way I did it I got very messy data. It included the initial invoices and then tried to incorporate payments and then was lots of duplications. For simple accounting it would be great to have a 12 month (depending on your financial year) raised invoice report of just the invoices raised, regardless of whether paid or not.

A separate aged debtors report as per a certain date (normal your year end) could accompany that.

It goes without saying that these need to export to excel.

I wonder if anyone from an accounting background has had any input into the accounting part of Pabau as they may have some other suggestions. All I know is that I contacted support, tried many different ways and then spent hours cleaning up the data and removing duplicates, where this was a straight forward step in my previous system.