Invoice and Customer Directory Reporting: Is this possible in Square?

[jonathanderek]

I need to create a report with the following information:  A report that shows all customers invoiced in a month along with the cooresponding payment that was received. I can run a report for any or all months in a given year.  

I can't find where to do this for the entire batch of customers, I know I can do this for each single customer at a time but that is a bit time consuming. 

Thank you

[#2]

Hello @jonathanderek, I just wanted to let you know you can now export a CSV report of your invoices! This report includes the customer's name, the amount requested, the amount paid, and the invoice status!

Take a look at this Product Update post for more details: Square Invoices - New Outstanding Invoices Report and Export to CSV.  

I hope this helps! 🙂

- Helen

[Tom · Accepted solution]

Hey @jonathanderek,

Thanks for bringing this up. I see what you mean—it's a bit cumbersome to piece this information together directly in the Invoices tab. I'll be sure to note this with the proper team members.

For now, I would suggest downloading the Transactions CSV from the Transactions tab. From there, you can sort by date and source of the payment, and the customer who completed the payment will display in the Customer Name column. You can cross-reference this information with with any outstanding invoices for the month from the Invoices tab.

I realize this involves a few more steps with having to use Numbers or Excel, but I hope it helps get you where you need to be. Please let me know if any concerns remain or if there are any specific details that you'd like us to know for why this is important for your business.

Thanks for your patience as we make improvements over time!

[Helen]

Hello @jonathanderek, I just wanted to let you know you can now export a CSV report of your invoices! This report includes the customer's name, the amount requested, the amount paid, and the invoice status!

Take a look at this Product Update post for more details: Square Invoices - New Outstanding Invoices Report and Export to CSV.  

I hope this helps! 🙂

- Helen

[jonathanderek]

Awesome!!! I will take a look at it. Thank you for the response