Jump to content

account ledger


Recommended Posts

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

Link to comment
Share on other sites

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 :idea:

Edited by disgruntled
Link to comment
Share on other sites

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

Link to comment
Share on other sites

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...

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Recently Browsing   0 members

    • No registered users viewing this page.
  • Create New...

Important Information

By using this site, you agree to our Terms of Use & Guidelines and understand your posts will initially be pre-moderated