Skimmer Billing Report - Customer Statement
To learn how to view and use the Customer Statement report, see the video below. Or, if you prefer, scroll past the video to view our step-by-step text instructions.
Step-by-step instructions . . .
Here’s how to access and use the Customer Statement Report. To begin, there are a couple ways you can get there. The most direct is under Billing Reports on the website, and in the Customer Reports box you’ll click on Customer Statement.
Once there, you’ll see the first choice you need to make is which customer to view. So, click the dropdown and make your choice.
Before we move forward, let’s see the second way to access this report. On the customer’s profile, find the Account Overview box and click the View Statement button. This will take you to the same report, but note that because we’ve accessed it from a specific customer profile, that customer has already been selected from the dropdown.
Next, you’ll want to choose your date range. The report displays the current calendar month by default, but you can change it to whatever you need. For demonstration, we’ll leave it on the default. We’re only partway into this month, which is why you’re not seeing a full month’s transactions.
So, what is the purpose of this report? It’s designed to show a statement of all transactions over a selected period of time, including starting and ending balances. So if you want to see the sequence of invoices, payments collected, credits applied, etc. this will be a good report to give you a high-level view. Maybe a customer thinks they’re all paid up for service, but you know they’re still overdue for a certain amount. Well, this report can show them the exact sequence of their bills versus their payments, and if there’s still a remaining balance owed, demonstrate why that’s the case.
To begin, let’s look at those three big numbers at the top of the report. What do they represent? Account Receivable shows everything the customer owes you, everything you’ve invoiced that is unpaid. Credit Balance shows any money currently applied directly to customer’s account and not an invoice. Net Balance shows the difference between those two numbers.
Moving down, you can see every transaction that occurred for this month so far, organized by date in sequential order. You can see what kind of transaction it was, how much, by what method, and finally how that transaction affected the customer’s account balance.
The top line shows the opening balance, or the balance that this customer account carried at the beginning of the month. In this case, they had a net balance of $44, meaning they owed you $44. Then the customer submitted two payments toward their Account Credit, meaning they didn’t submit payment for a specific invoice, and those funds were applied to their account instead. Following that, credit was applied to that outstanding balance of $44, so that balance was paid, leaving the customer with a remaining credit of $156. Next, an invoice for $100 was generated, and credit was automatically applied to it. So, as of today, the customer’s outstanding invoices have been paid and they retain an account credit of $56.
We were able to track that entire sequence of invoices and payments with just this one report.