Deferred Income Reporting

[chrissie-penguin]

Hi all, I am sorry if this is posted in the wrong location or if there is already a post about this (I searched and couldn't find anything).

 

I use the WHMCS Sales Tax Liability report each month to show me all sales for the month, tax rates, tax charged etc and this works perfectly well for my accounting except for the fact that it does not give me the information I need for reporting deferred income so I am looking for some advice on how others handle this for accounting purposes.

 

So for example, say the accounting year runs Jan to Dec. I have a client who purchases hosting and pays for it on an annual pre-pay basis in November 2015. For accounting purposes, only Nov / Dec charges would be reported in 2015 reporting year and Jan - Oct would be reported in the following accounting year.

 

On the client invoice it shows 'Domain Renewal - ******* - 2 Year/s (01/11/2015 - 31/10/2017) so I can see if I view the invoice that I report 2 months in this year and the rest is carried forward.

 

This information doesn't seem to be displayed on any of the WHMCS reports though and so unless it is obvious what term the charge is for, I have to manually check the invoice and record the duration which is time consuming and tedious.

 

Does anyone else find themselves in this position? I feel there must be a simple way to do this as this is a widely used package and many hosts / registrars offer annual hosting and multi year domain renewals so I am surprised that no-one else has posted about it.

 

In basic terms, I would like the Sales Tax Liability report to show another field with the details from the Invoice description to be included - in a perfect world I would like the report to be able to have a separate field for duration (1 month, 1 year, 2 years etc which is of course recorded within WHMCS) and to / from date but I don't want to be greedy

 

I hope this makes some semblance of sense - it is not the easiest to explain so please do tell me if I need to clarify somewhat.

 

Thanks in advance