thread Report on sent invoices vs. paid invoices in Archived Discussions (Read Only)

Report on sent invoices vs. paid invoices

rtgshelli — Tue, 30 Mar 2021 13:42:06 GMT

I'm looking for a report that will show me the total number of invoices sent vs. the total number of invoices paid.

I use Square for a consulting business. I send potential new clients an invoice from Square after our discovery call. I have a "master invoice" that I duplicate and change the name/email before sending. The potential client either pays the invoice to become a client, or ignores it, resulting in me losing the sale. I'm trying to calculate my close rate, based on paid vs. ignored invoices.

I have 4 reminders set up to send automatically, but after the 4th reminder, I usually archive the invoice.

Is there a report that will do this for me? Thanks!

Re: Report on sent invoices vs. paid invoices

Valentina — Fri, 02 Apr 2021 23:30:20 GMT

Hi hi @rtgshelli - sorry to see trouble has brought you to the Seller Community!

Have you tried viewing your outstanding invoices? It sounds like this may be what you want to do, but let's do a quick overview of your Square Dashboard reports first, to make sure we're on the same page here.

Start by heading to your Square Dashboard > Invoices > Reports
Once here, select the dropdown next to the box that says Search invoices and you can view All invoices.
You can also select Paid to view all invoices that have been paid.
You'll notice an Export button, which you can click to export both of these views as reports.

If I've misunderstood what you're looking to do here, please let me know! 🙌✨

Re: Report on sent invoices vs. paid invoices

Scottwa333 — Mon, 06 Feb 2023 18:02:47 GMT

First problem: when I open the Invoice page and filter for December 2022, it shows a list of four invoices, three of which are dated for mid-January 2023.

Second: the Invoice page shows four invoices paid; my bank statement shows five received in January.

What gives?

Re: Report on sent invoices vs. paid invoices

JJ_ — Wed, 08 Feb 2023 19:24:02 GMT

Hello @Scottwa333 and welcome to the Seller Community

I can recommend looking at your Transfer Reports as they are the best source to correlate the transfers that were sent to your bank account and they will show the source of each transfer.

I hope this information is helpful!