Client Balance Summary Report

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: 

1. Sign in to Jobber.com 
2. Select Insights followed by Reports from the side navigation
3. 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
• All time
• Custom range

Note: The All time option uses the account creation date as the start date. For invoices or deposits dated before that, use the Custom range option to get accurate balance reporting.

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?

It’s most likely an invoice has been closed without a payment. It’s possible to do this from an invoice by clicking More Actions followed by 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’s account balance, which you can view from their billing history box. 

To fix this: 

1. Find the invoice that has been marked as paid but has no payment recorded on it 
2. On this invoice click Actions then Re-open 
3. Click Collect Payment again. A payment record box will appear, where you can record the payment. The invoice will then be marked paid with a payment record in the client’s balance.

If you’re not sure which invoices have been closed without a payment, the invoices report can help you identify which invoices are in Paid status without an associated payment. 

1. Go to Insights, then Reports, then select the 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, make sure the client name, invoice number, total, balance, and open options are 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. In the new tab, click Actions, then Re-open Invoice, then Collect Payment and record the payment and 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, and repeat from step 7 for the whole list.

View original article