BarrySDCA Posted March 15, 2013 Share Posted March 15, 2013 I need to export a full account history for one of our corporate clients. that would list invoices and payments in a typical ledger format. whmcs does not do this very well, maybe because they send large checks and those are then posted to multiple invoices. to date I have used a database dump but it's not very nice or complete. anyone have a suggestion? thank you 0 Quote Link to comment Share on other sites More sharing options...
disgruntled Posted March 15, 2013 Share Posted March 15, 2013 (edited) The only thing i can suggest is that you write up a script in your favoured language to export the data to a CSV file. Start by working out the data your accounting system wants and the order it should be in. Then match up this information with the data in the whmcs database. From here you can decide on the best way to get the data, account by account or as a list of accounts. which ever way you go, the brief outline is this: Gather accounting information Gather database information Put script together Choose the account(s), Pull the data and order to requirements Write it out to CSV file. Import into accounting software. your accounting documentation would be a good place to start Good Luck Edited March 15, 2013 by disgruntled 0 Quote Link to comment Share on other sites More sharing options...
BarrySDCA Posted March 21, 2013 Author Share Posted March 21, 2013 wow - WHMCS BADLY needs a real account ledger for individual subscriber accounts. this is a little insane. 0 Quote Link to comment Share on other sites More sharing options...
openmind Posted March 22, 2013 Share Posted March 22, 2013 WHMCS is a billing system first and foremost, not an accounting program. 0 Quote Link to comment Share on other sites More sharing options...
BarrySDCA Posted March 22, 2013 Author Share Posted March 22, 2013 exactly that...it is a billing system and subscribers, especially large corporations, sometimes have a need to review their billing history. after reviewing the whmcs database to try and come up with something, I realize it is a huge mess when it comes to billing. I don't think an account history will even be possible! wow not good 0 Quote Link to comment Share on other sites More sharing options...
openmind Posted March 22, 2013 Share Posted March 22, 2013 I disagree. It's down to the client to keep accurate accounting records, not you or WHMCS. This is why I export all invoices and payments to Xero which is built for the job... The client can login to their account and review their paid invoices and you can generate a Client Account Register Balance report under the reports section and export that as a csv. Anything more than that is their responsibility... 0 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.