Skip to main content

How Can I Create a Monthly Billing Statement for a Client?

Use the Projects List to generate a monthly billing summary for a specific client in Goodshuffle Pro.

Sierra Burton avatar
Written by Sierra Burton
Updated over a week ago

To access this feature, you must be on Goodshuffle Pro Standard or above.

Full Users can use the Projects List to quickly view and create a Monthly Billing Statement for a client.

Follow these steps:

  1. Add the custom columns “Amount Due” and “Remaining Balance” to your Projects List view

    • Click “Update Columns” and position them side by side

    • Amount Due: Active funds owed right now on signed projects (includes deposits and payments not yet made)

    • Remaining Balance: What’s owed in total, including amounts scheduled for future invoicing

  2. Hover your mouse over either column to see the totals for all rows

  3. Set your filters:

    • Select “Contract Signed” and “Action Needed” statuses

    • Use Specific Dates to narrow by month

    • Search for the client’s name in the Client filter field

  4. Select all visible projects

  5. Click to Download Your Columns as an Excel sheet


In Excel or Numbers

  1. Find the “Remaining Balance” column

  2. Sum the values to calculate the total amount due from that client

💡 If using Numbers, you may need to click the green handle icon at the corner of your row set to add a new row for calculations

Pro tip: Add the Custom Columns 'Billing Status', 'Net Paid', and 'Contract Total' and place them beside each other to make it easier to view all results.


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?