Client Balance Summary Report Updated

Table of Contents

  1. Overview
  2. Customize the date range of the client balance report
  3. Customize the columns on the team client balance report
  4. Export the client balance report
  5. Troubleshooting

Overview

With over 20 built-in reports, you’ll know exactly how your business is doing. Learn more.

The client balance summary report shows which clients have owing balances on their account, and which have credits. To view the report, sign in to Jobber.com, then select Insights > Reports from the side navigation. Under Financial Reports, select Client Balance Summary. 

At the top of the report is an overview for clients with owing balances and clients with credits.

Customize the date range of the client balance report

The data in the client balance summary can be filtered by a date range. To filter your report by date, select the Date filter dropdown, then select a date range. Your options are:

  • This year
  • Last 12 months
  • Custom range

Customize the columns on the team client balance report

Columns in the client balance summary can be customized by selecting the Columns button, then selecting the columns for the report from the columns list.

The options for columns that can be added to the report are:

  • Name: This is the client's name
  • Balance $: This is the value of the client's balance
  • Paid to date $: This is the value of the payments the client has made so far
  • Invoiced $: This is the total value of invoices issued to this client
  • Phone #: The client's phone number
  • Email: The client's email address
  • Open: Select the icon in this column to open the client's profile

Export the client balance report

To export the client balance summary report, select the Email CSV button to be emailed a copy of the report to the email you are logged in with to Jobber.

Troubleshooting

Q: What if my client's balance does not reflect the same amount for invoices marked as paid?

What has most likely happened is an invoice has been closed without a payment. It's possible to do this from an invoice by clicking More Actions > Close Invoice and then selecting to close the invoice without a payment. This will still show Paid invoices as having an outstanding balance, which can lead to discrepancies in both the invoice balance and the client' account balance which you can view from their billing history box. 

To fix this, find the invoice that has been marked as paid but has no payment recorded on it, then on this invoice click Actions > Re-open, then click Collect Payment again. A payment record box will pop up, where you can record the payment. The invoice will then be marked paid, and a payment will be recorded for it in the client's balance.

If you're not sure which invoices have been closed without a payment, the invoices report can be helpful to figure out which invoices are in Paid status but don't have a payment associated with them. 

1) Go to Insights > Reports > Invoices Report.
2) Select a date range going back a few months in the Options section and click Apply Options
3) In the Overview section click on the Paid line.
4) Using the Columns dropdown we want to make sure we have the client name, invoice number, total, balance and open options ticked.
5) On the report itself click the Balance header twice. We now have the invoices with outstanding balances at the top of the report.
6) Click on the first line ‘open’ icon (two small squares). This will open the invoice in a new tab.
7) Go to that tab, click Actions > Re-open Invoice > Collect Payment and record the payment and the details. This will mark the invoice as paid and clear the balance for that invoice.
8) Close the tab, go back to the report and click the ‘open’ icon on the next line, repeat from step 7 for the whole list.

Related articles

WE’RE HERE TO HELP
Talk to a real person.
No matter the question.
Contact Us