Customer/Job Balances

Hi there, rwyeth.

At the moment, the Company Snapshot report only shows amounts on a summary level. This is the reason why we're unable to add or drill down the data per job. Although, you can double-click on the customer name to get the amounts per tenant.

More details about customizing or running the Company Snapshot are discussed here: Customize a Snapshot tab.

For now, you can run the Open Invoices report. This will let you see the current balance for open invoices per job. Here's how:

1. Go back to the Reports menu.
2. Select Customers and Receivables, then click Open Invoices. 

The Community is always here if you need anything else. 

Pull up your Customer Balance Summary report and Customize

Filter for amount =>0

Filter for Paid status = open

That's all fine and good.  But, I really just want something as simple as the current balance for each customer/job, excluding negative balances, to send to our property manager.  I'd never have thought that achieving that would be such a struggle.

Thank you.  But, it then shows balances based on the open invoice.  That doesn't account for the fact that the invoice may be partially paid.  So, it doesn't give an accurate number of the current balance.

I've got you covered today, rwyeth

There is a Quick Report in QuickBooks Desktop where it lists all transactions related to a particular name or payee. You can run this report to one of your customers and filter the information to remove other columns except for the Opening Balance. 

I'll show you how below:

1. Go to the Customers tab and choose Customer Center.
2. Select a customer and click the QuickReport link from their Customer Information.
   
3. Remove all the columns by clicking Customize Report.
4. Make sure to remove all the unnecessary columns except the Open Balance.
5. Click OK to save the changes.
   

Below is another screenshot that will show how the report would look like after removing other columns except for the opening balance.

Learn more about customizing reports in QuickBooks Desktop through this article: Customize reports in QuickBooks Desktop.

Be sure to drop me a reply if you have additional questions. I'd be more than happy to help. Stay safe and have a good one.

Thank you!!! that was easy

That's great to hear, @ANJ828.

I'm glad the information shared above was able to assist you with your concern.

If you encounter any difficulties with QuickBooks Desktop in the future, you can always share them in the Community!

It's always our pleasure to help! Have a good one, and always keep safe!