Skip to main content
All CollectionsManage Your ReportsProject reports
How can I generate a statement for a company with all their open balances?
How can I generate a statement for a company with all their open balances?

Here's how you can use your Custom Columns to see all the projects for a company with a remaining balance.

Colin Connor avatar
Written by Colin Connor
Updated over 2 months ago

First, head to your project list and add your Custom Columns.

Then, add in your Custom Columns. We suggest Remaining Balance, Payment Type, Customer name, and Business to make it easy for you to see these results.

Filter your project list by Business, then filter by Billing Status, and as a best practice, you can include Archived projects.

From here, you can see all projects for this company with the remaining balance and if the project is paid with a deposit (Upfront) or on a Net basis.

Finally, you can download your project list into an Excel Document for a summary of the Company.

Did this answer your question?