thread Re: Is this possible in Square? in Archived Discussions (Read Only)

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

jonathanderek — Sat, 09 Feb 2019 20:30:13 GMT

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

Re: Is this possible in Square?

Tom — Sat, 09 Feb 2019 20:28:45 GMT

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!

Re: Is this possible in Square?

Helen — Thu, 02 May 2019 21:49:03 GMT

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

Re: Is this possible in Square?

jonathanderek — Thu, 09 May 2019 04:53:18 GMT

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