Client Balance Summary Report Updated

Table of Contents

  1. Overview
  2. Report actions
  3. Troubleshooting

Overview

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

This report can be found from the Reports tab under the heading for Financial Reports.

The client balance summary report shows which clients have owing balances on their account, and which have credits.

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

client balance summary overview showing clients with credit and clients with outstanding balance

Report actions

Filter the report -To filter the report to see only outstanding balances, or just ones with credits, click on the category you want to see in the overview. The report below will then filter to view only these clients.

Export Report - Click on Receive Excel Copy, to be emailed a copy of the report to the email you are logged in with to Jobber.

Add/ Remove Columns - Click on Columns, on the right, to add or remove certain columns from the report.

Sort the Report - To sort the report, click on the header of any column that shows the up and down arrows. For example, if you click on 'Name', the report will sort alphabetically by the client's name. 

View the Client's Profile - To view a certain client's profile in the report, click the 'Open' button on the right. This will open the client's profile in a new tab. 

client balance summary report with the column for balance highlighted

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 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