Detecting and Preventing Invoice Mistakes in WHMCS
Detecting and Preventing Invoice Mistakes in WHMCS
WHMCS incorporates things like System Health Status (that's nothing exceptional) but offers literally no way to detect and prevent billing mistakes. This is kind of ironic as the main source of problems in this area is WHMCS itself.
As we point out in our MUST read before launching a WHMCS site, it's crystal clear that WHMCS team has no clue of how invoicing should work. Over the years they proved to be unreliable by changing critical billing concepts overnight.
That's the very reason why we started coding our first module Billing Extension. The module prevents most billing mistakes in the bud and also integrates a system that detects billing problems.
When there's something that requires your attention, the module adds the Billing Warnings badge at the very top of WHMCS administration. The widget is also part Billing Extension and brings back Admin Stats that have been removed in v8.
For earlier versions (v7, v6, v5) this same badge appears right next to Tickets Awaiting Reply as follows.
Clicking such links gives you quick access to the integrated billing error dashboard that can also be accessed from Addons > Billing Extension > Invoices > Warnings.
It is worth to remind that Billing Extension distinguish between "hard" and "soft" notices. In subsequent chapters of this article we will explore the purpose of each type of notice.
This type of notice require your immediate attention as there are questions that should be looked into immediately to avoid further problems. Such notices are colored in red their total number appears in the badge we've previously seen.
|Invoice gaps||Gaps in invoice number sequence (eg. #1, #2, #4)|
|Duplicated invoices||Repeated numbers in invoice number sequence (eg. #1, #2, #2, #3)|
Used for monthly invoicing and manual invoicing based on customizable thresholds on:
|Electronic invoicing requirements||Used for Italian electronic invoicing.|
|Electronic invoicing data||Missing, incorrect or invalid details still for Italian electronic invoicing.|
|Invoice Sync||Lost synchronization for sequential invoice numbering|
There's nothing to worry about in this section. Mostly all notices act as a logging. In this case the color we use is yellow and "soft" notices don't show up in any badge.
|Hard notices (red)||Description|
|VIES||Changes to VIES response, tax exempt status, business type etc.|
|Invoice Data Snapshot||"Orphan" invoice and credit note snapshots|
|Tax Calculation Method||
WHMCS provides two tax calculation modes:
The first mode is utterly wrong and leads to billing errors. The module automatically switches mode in case you're using the wrong one and provides a notice in this section.
|Electronic invoicing profiling||
Used for Italian electronic invoicing. Users can be profiled as:
For companies and Public Administration there's also the concept Split Payment. This section logs all changes made to user's detail.
|Electronic invoicing Admin log||Still used for Italian electronic invoicing. It logs all actions performed by WHMCS administrators on electronic invoices (XML files).|
For this reason we decided that it's was time create this handy tool that can save you from numerous invoicing troubles. First off we made a clear distinction between soft and hard warnings. Hard warnings are colored in red and they refer to things or events that should be addressed as soon as possible. They appear next to Tickets Awaiting Reply.
And also in Billing Extension.
As for soft warnings, they are colored in yellow and don't show up next to Tickets Awaiting Reply and in the module. They are not even part of the counting of existing warnings (the number 19 in the above screenshots represents 19 hard warnings).
On a daily basis Billing Extension looks for any possible gap in invoice numbering. This check also includes credit notes if in use. Thanks to this report finally you can spot invoicing problems immediately and not after months when it's too late. Not only you can see what numbers are missing but we give you probably the most precious information, the expected date.
This is another interesting report that focuses on immediately giving you information about invoices or credit notes that are duplicated. Stop dealing with such a problem when it's already too late. Now you can fix it as soon as it is occurring.
- Too many customers waiting for invoice
- The amount of uninvoiced payments is too high
- The invoice is taking too long to be issued
Every time the Tax Exempt status changes for a client based on VIES check result, Billing Extensionnotifies you such changes so that you can possibly decide to make further investigations. In this section we also notify you the following errors:
- Invalid data (wrong or missing country code or VAT Number)
- VIES service unavailable
- Member State service unavailable
- Server busy (high load)
There's no point in storing snapshots related to invoices, credit notes or proformas that have been removed from WHMCS. They no longer serve any purpose therefore they're removed. Here Billing Extension notifies you about snapshots that have been deleted on a daily basis.
In this article we talked about a long standing issue of WHMCS that has never been addressed by WHMCS team. For reasons described in the article there's one option of WHMCS that shouldn't be used (Tax Calculation Method: Calculate individually per line item). Billing Extensionensures that this setting is disabled. If it's not it automatically changes this setting and notifies you about this change.