Square Custom Report doesn't show refunds even if you say to include them

[GCRR]

Normally we don't have any refunds or even split payments (cash/card), but what I've noticed is that the Custom Report, even with the option turned on to show refunds, doesn't show them as a line item and also, split payments are not calculated correctly in the reports between cash/card lines leading to the report not matching what will be deposited

[Candlestore]

@GCRR ;

I do not do alot of Split Payments or Refunds.  I just did a Custom Report for Payments.  Now doing this report it shows Refunds as Column and not a Row.

See image below:

But the line on the left just states Card on File.

[GCRR]

My custom report looks very different.

[GCRR]

I deleted the report and recreated it and it's worse showing all these payment types we don't use but still nothing for refunds

[Candlestore · Accepted solution]

That is because you Chose Sale summary for your Custom Report.

If you click  Create New Report > at the bottom it says Add Report click that > then a pop up appears that shows different reports you can add to customize.  I chose Payments for mine.   Hope that helps  🙂

[GCRR]

Gotcha.  I think the Sales Summary should show refunds it has a checkbox for the row for it but checking/unchecking doesn't do anything

[GCRR]

Here is what I'm referring too.  I'm trying to look at the Sales Summary to match it with the Balance Transfer amount but they don't match because the sales summary doesn't factor in refunds or the refund of a free.  The balance transfer page has an issue because it show the fee as a subtraction (its in parenthesis) but it's actually a refund

Its very odd

[Candlestore]

@GCRR 

Square does not refund the Processing Fee as of April 11th, 2023.

5615-refunds-faqs 

Make sure when creating the reprort the Date of the refund is included with what your report says.

If I choose the Date range from Last month, the report shows nothing for Refunds, If I use last year I have 1 refund.  So if I select Refunds as you have circled and have the date range of last week that Line item of Refunds is not visable on my reports untill I choose for Last Year.  This might be why you are not seeing the Change on your Sales Summary report.

There is a Balance Transfer report, but Square does not Show this option in Reports.  You need to go throught Balance, Select Location, Select View all and select the Date range of the Refund.  Then select the date of the refund and select it.  A popup will appear with a summary of the amounts in the Deposit from Square to your Bank account.  

Since this is a Bal Transfer Positive numbers show As A sale depost to your account and with drawals for a refund show in '($32.95)' for example.

[GCRR]

More research shows Refund by amount it for partial refunds.  So adding a payment methods will help as it shows refunds but odd part it doesn't show by correct source it shows Filtered By Source: eCommerce Integrations even though I know 100% the sale and refund from from Point of Sale.