How do you handle accounting with WHMCS?

[FPForum]

I've personally noticed the accounting side of things can be very overwhelming at times. With accepting different payment methods like EGold and Paypal, plus dealing with fraudulent orders that get past maxmind and then end up getting refunded. How do all of you handle this stuff?

 

It doesn't seam like WHMCS does a great job on the accounting side. Is there some tips or secrets someone can share to make the job a bit easier?

 

Thanks!

[uberhost]

It doesn't seam like WHMCS does a great job on the accounting side.

 

WHMCS has some convenience features that are simply there to give you an overview, but it's not meant to replace an accounting program. We use QuickBooks for that.

[phenglai]

We use Microsoft Office Accounting 2008 and use the export options in WHMCS to import into our accounting system.

[FPForum]

We use Microsoft Office Accounting 2008 and use the export options in WHMCS to import into our accounting system.

 

this is the kind of answer I was looking for! many thanks

[Adam]

this is the kind of answer I was looking for! many thanks

 

If you are technology savvy and know Microsoft Access, you can really take a hold of connecting to your WHMCS database, and important transactions to the Microsoft Access database/spread sheet and do wonders with Visual Basics for custom reports, etc.

 

 

From,

Adam

[FPForum]

Thanks for the tip Adam! I used to be quite good with Access but honestly haven't used it in probably 4 years. I didn't even consider making that connect to my database. I'm going to be looking more into that!

[Adam]

Thanks for the tip Adam! I used to be quite good with Access but honestly haven't used it in probably 4 years. I didn't even consider making that connect to my database. I'm going to be looking more into that!

 

Hey,

 

O ya, its wonderful. Setting it up will take you some time but once you have everything automated and start using Visual Basics to run automated task and what not, you can create a report on just about anything.

 

 

From,

Adam

[FPForum]

We use Microsoft Office Accounting 2008 and use the export options in WHMCS to import into our accounting system.

 

I have microsoft accounting 2008 but the import feature does not work. WHMCS exports in csv format, MS Accounting 2008 only allows you to import excel spreadsheets.

 

Also I have noticed you miss valuable fields when importing transactions and things because the export of transactions in whmcs does not include product names and other things.

 

Can anyone else recommend any better software that imports csv's and works nicely with WHMCS. Surely there has to be something

[Austdata]

An SQL script could be used to read the MySQL database and extract the data you want by reading more than one table. I suppose I should look in to that myself one day.

 

Excel can import a .cvs file and if you use a macro it should be able to save it as an xls file.Though that's a long winded way about it. Maybe the SQL script could save it in an xls (almost) format and MS Accounting 2008 might not care that the table is a little different.

 

Cheers,

 

Mike