Skip to main content

How Can I Generate a Statement for a Company With All Their Open Balances?

Here's how to use Custom Columns and filters to find all open balances for a company.

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

This feature is available on all Goodshuffle Pro Plans.

Step-by-Step Instructions

  1. Go to your Project List.

  2. Click "Edit Columns" at the top right to manage Custom Columns.

  3. Add these columns:

    • “Remaining Balance”

    • “Payment Type”

    • “Client Name”

    • “Business”

    Then click "Update Columns". These columns will help you view balances and payment terms at a glance.

  4. Use the “Filters” button and:

    • Filter by the Business name

    • Then filter by Billing Status

    • (Optional) Include Archived Projects to ensure nothing is missed

  5. Your filtered list now shows:

    • All projects for this business

    • The remaining balance on each

    • Whether the project was paid upfront or on Net terms

  6. Click the check box next to "Project Name" to select all projects and then click the Download icon to export this list to Excel.

    1. Users with a Goodshuffle Pro Lite can create this report. Note that you must be on a Goodshuffle Pro Standard Plan or above to export this report.


Need Additional Support?

Click the blue chat bubble in the bottom corner of your screen to message our support team—we’re happy to help!

Did this answer your question?