Sales Reporting

[philmcdonnell]

Hello,

 

This is a question that maybe some of the veteran users can answer for me. Currently I have been using Quickbooks to keep track of all my invoicing but it is getting hard to keep up.

 

How can I use WHMCS online for billing and then enter the info into Quickbooks to keep my accounting reconciled? Does everyone re-enter every sale is QB? Do you just enter daily/weekly/monthly sales? If so how do you separate where the sales are coming from and what type of payment was used?

 

I know there is no export to QB as I asked the sales team already but I would love to hear from existing users how they manage their books not just how they bill their clients.

 

Thanks,

Phil

[JofleyUK]

Hi Phil. As you are tracking your individual sales with client details in WHMCS you can generalise your Quickbooks to enter a total sales figure on a daily or weekly basis. Use the income search facility in the reports menu to allow you to see sales from a date to a date. Remember this tho, by doing this you will not see entries for clients who added credits to their accounts. If you want to keep yourself right you could just duplicate the information in Quickbooks.

 

You would input sales under the headers of CASH/CHQ and CC as 3 separate entries in Quickbooks.

 

I would suggest you speak to a good quickbooks accountant and see what he says. Everyones needs are individual. If you are VAT regged there are problems with grouping transactions for the final quarters/months VAT return if u r UK based and VAT Regd.

[philmcdonnell]

Hi Phil. As you are tracking your individual sales with client details in WHMCS you can generalise your Quickbooks to enter a total sales figure on a daily or weekly basis. Use the income search facility in the reports menu to allow you to see sales from a date to a date. Remember this tho, by doing this you will not see entries for clients who added credits to their accounts. If you want to keep yourself right you could just duplicate the information in Quickbooks.

 

You would input sales under the headers of CASH/CHQ and CC as 3 separate entries in Quickbooks.

 

I would suggest you speak to a good quickbooks accountant and see what he says. Everyones needs are individual. If you are VAT regged there are problems with grouping transactions for the final quarters/months VAT return if u r UK based and VAT Regd.

 

Ok, so if I wanted to duplicate everything in QB, which really stinks by the way to have to do all that work... How would I get all the invoices and then payments to print out in a nice format for me or someone to enter into QB.

 

I am in the US so no VAT. If I just wanted to track weekly sales I could make a general entry in QB? That would show my income but then there is no real way to show my receivables of clients that owe me money atleast not in QB...

 

This is always a big problem for me, you see doing it in QB you always know where you stand with everything. It doesn't keep track of domains too well but money it does

 

I was thinking about finding just a signup script and not having all the bells and whistles of a full customer central, then I could get the signups, manually enter into QB and then do all billing from there.

 

Can I use WHMCS as a signup script only? Do I have to do my recurring billing from within it or can I just not allow customers into it.

 

I have been down this road many times already and don't want to make a switch to something that doesn't work for me. As it stands right now QB is working except for the fact that there is no online signup and keeping track of everything is not that easy.

 

Thanks,

Phil

[bugster]

I have the same question as Phil.

 

Duplicating everything in quickbooks doesn't seem like a practical answer. Is that really what everyone is doing. There has to be an easier way, isn't there? Anyone have any tips or tricks they would like to offer on this subject?