How can we improve WHMCS?

Share, discuss and vote for what you would like to see added to WHMCS

Accounts Receivable Rollforward

  • Michael Godbout shared this idea 4 years ago
  • Reporting
  • 3 Comments


There are many, many deficiencies in WHMCS reporting. I saw someone suggested the ability to generate a detail Accounts Receivable Aging. This would be very beneficial, but I need something more. I actually figured out how to run an detail AR aging as of a specific date. I've proven that it is correct. It requires Moldule Gardens Report Generator, or you can do it manually in Excel. Either way it will not include prepayments,. which it should. The AR summary aging in reports also does not include prepayments.

However, when I try to rollforward from one AR aging to another I run into difficulties. There should be a canned detail report which will roll forward accounts receivable. It's format would be Beginning Balance, Invoices, Credits, Write Offs, Payments, Refunds, and Ending Balance. In general I am having to piece together reports to roll AR and I run into issues every month.

3 Comments

Login to post a comment.

<a href="https://eggycar.onl">Eggy" Car</a>
Eggy Car
It's so frustrating when reporting features fall short! A detailed AR aging report as of a specific date sounds incredibly useful. The fact that you've figured out a workaround, even if it requires Report Generator or manual Excel work, is impressive. The prepayments issue is a real problem, though. It's like trying to drive the [Eggy Car](https://eggycar.onl) uphill with a flat tire – you might get there, but it's going to be a struggle! Hopefully WHMCS will address this gap in future updates.
This article really helps understand the rules and structure of <a href="https://matkabook.net/">Online" Matka</a>. Perfect for someone just getting started.