thread Re: What would cause the payments total to be higher than the sales total on the sales summary repor in Archived Discussions (Read Only)

What would cause the payments total to be higher than the sales total on the sales summary report?

Evan_R — Tue, 07 Jul 2020 20:37:29 GMT

I am attempting to run a sales summary report for quarterly taxes. The gross/net sales are the same. The payment total collected is higher by slightly over $1000?

Re: What would cause the payments total to be higher than the sales total on the sales summary repor

ryanwanner — Tue, 07 Jul 2020 20:39:57 GMT

Hello @Evan_R

The only thing I can think of is Gift Cards. Did you sell any for the quarter?

Gift cards will add to the payments received but not as sales. Sales are recorded when the customer comes back in and buys something with the card.

Re: What would cause the payments total to be higher than the sales total on the sales summary repor

Evan_R — Tue, 07 Jul 2020 20:42:43 GMT

Nope, have not sold any gift cards. We have had a couple of transactions where deposits were involved- but I wouldnt think that would make the payments higher?

Re: What would cause the payments total to be higher than the sales total on the sales summary repor

ryanwanner — Tue, 07 Jul 2020 21:05:07 GMT

@Evan_R I forgot about deposits on Invoices!

Yes, the deposit isn't counted as a sale until you have completed and closed the invoice. The rationale there is that you have the potential to return the deposit if you/your customer cancels the job. Instead of running refunds (Square categorizes your account as a higher risk account if you do a lot of large dollar refunds) you can cancel the invoice without negating the sales.

Re: What would cause the payments total to be higher than the sales total on the sales summary repor

Evan_R — Tue, 07 Jul 2020 21:35:33 GMT

Thank you! That would make sense.

Re: What would cause the payments total to be higher than the sales total on the sales summary repor

Valentina — Wed, 08 Jul 2020 00:35:07 GMT

Good catch with the deposits - love to see this collaboration in the Community! 👐✨