Report Showing Billing Cycle

[chrissie-penguin]

Hi, I am not sure if anyone here is able to help but my accountant has requested that I provide a list of all sales showing the billing cycle and I cannot see any way to generate this via the existing reports in WHMCS?

 

What I actually need is a report with the following fields but also including Billing Cycle:

 

Invoice ID Client Name Invoice Date Date Paid Subtotal Credit Tax Tax Rate Total Payment Method

 

Is this something anyone is able to help with? I am hoping it would be a nice simple one that would save me hours going through and checking all of the transactions individually.

Thanks in advance

[Alex - Arvixe]

Try contacting ModulesGarden / HostTheBest for a custom report module, I am not aware of any already existing modules and don't recall this being a core feature.

[chrissie-penguin]

Thank you so much, I will look into this.

[alinford]

ModulesGarden built a couple of similar reports for me.

[chrissie-penguin]

Great. I have had to do it manually this time around as I had to get the info to accountant but will definitely sort it out soon then. Thanks for your advice.

[othellotech]

There isnt a billing cycle for an *invoice* as an invoice can have multiple items.

Similarly domains and hosting may not be on the same "cycle" now as they were at the point of being invoiced.

 

First question has to be *why* does the accountant think they need that data and what are they going to do with it ...