x

Square "Gift Card Load Fees" and the "Sales Summary" report

Earlier this year Square started charging a "Gift Card Load" fee when gift cards are loaded.

 

These fees show up when looking at the details of a "Transfer," however they do not seem to show up in the "Sales Summary" report.  I use the daily "Sales Summary" report to reconcile transactions with my accounting software.  Because the "Gift Card Load" fees aren't present, I have to wait until a bank transfer happens and look there for the amounts.  Obviously this is very tedious.  Is there a way to get this data in the "Sales Summary" report?

606 Views
Message 1 of 21
Report
1 Best Answer
Square Champion

Best Answer

Hey there @cbrew.  This is currently not available on the Sales Summary report.  However, you can find it by going to your Balance page in your online dashboard, clicking on your location.  Then scroll down to the “Balance Overview” section for the date in question.  There you will see a line “Payment Processing” that you can expand and if there are any GC load fees for the day, they will be listed there.

 

FYI, I know for a fact that this visibility has been requested on a future version of the Sales Summary report, because I requested it as part of a beta test I’m participating in.  But, currently, the method above is the only way to see that number on a daily basis.

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है

View Best Answer >

554 Views
Message 2 of 21
Report
20 REPLIES 20
Square Champion

Best Answer

Hey there @cbrew.  This is currently not available on the Sales Summary report.  However, you can find it by going to your Balance page in your online dashboard, clicking on your location.  Then scroll down to the “Balance Overview” section for the date in question.  There you will see a line “Payment Processing” that you can expand and if there are any GC load fees for the day, they will be listed there.

 

FYI, I know for a fact that this visibility has been requested on a future version of the Sales Summary report, because I requested it as part of a beta test I’m participating in.  But, currently, the method above is the only way to see that number on a daily basis.

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
555 Views
Message 2 of 21
Report

Thank you!

> ...because I requested it as part of a beta test I’m participating in

 

Is there a way I can enroll in this as well?

 

With my current process, I have some software that parses the daily "Sales Summary" CSV.  It's helpful that I don't have to wait until a bank transfer happens, but it's still very inconvenient to have to look up this value in the pending payments section.

 

I'll be crossing my fingers that this feature makes it into a release soon!!

540 Views
Message 3 of 21
Report
Square Champion

@cbrew The feature does not exist in the beta, either.  It’s very early in that process and there is no guarantee that it will be included, even when released.  So, being part of the beta test would not really help you at all, in this case.

 

But, here’s a link to the test.  

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
538 Views
Message 4 of 21
Report
Square Champion

@TheRealChipA 

 

Just to clarify, following your steps above I could not see gift card load fees. It requires exporting the transactions from the balance activity page in order to actually see the gift card load fees.

It appears that the only way to actually see the gift card load fee is by the following steps...

 

  • Go to your dashboard 
  • Click Balance in the menu 
  • Choose the location and click on it 
  • Scroll down to choose view all transfers 
  • Then select the location from the dropdown (It won't show you any transfer information if you have multiple locations chosen so make sure you only choose one location) 
  • Choose the date that you're interested in 
  • If you click on a transfer record the pop-up will come up to show you any instant transfer fees but will not have the individual gift card load fees
  • Instead x out of that pop out and click the Export button on the activity page for that date and location 
  • Open the export in a spreadsheet 
  • You'll see your gift card load fees there for each transaction 

 

@Katie_SQ 

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
485 Views
Message 5 of 21
Report
Square Champion

@BofBArtStudio So, if you open your Balance Page, select a location, and go to a date you know you sold a GC, the click on “Payment Processing” to expand it, you don’t see the GC load fees for the day as shown in my screen shot below?  If not, that sounds like an issue with your account.  It definitely should be there.

 

IMG_0039.jpeg

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
478 Views
Message 6 of 21
Report
Square Champion

I cannot seem to find a balance overview. 

 

Here's what I'm doing.. 

 

In the dashboard I go to the menu and click on balance And then this comes up 

 

1000001772.jpg

 

 then I have to choose a location because it won't show any transfers if I have all locations selected 

 

1000001773.jpg

 then I click on the transfer 

1000001774.jpg

 

 and then if I click View Details

 

1000001775.jpg

 

I tried it on both my computer desktop dashboard and my phone dashboard. Both using Chrome. 

 

 what am I missing?

 

 

Here it is on my computer dashboard in Chrome 

 

I go to the menu and click on balance 

1000001776.jpg

Then I click on View All Transfers

 

1000001777.jpg

Then I choose a location because it won't show me anything if all locations are selected 

 

1000001779.jpg

Then I click on the transfer record 

 

1000001780.jpg

 

 And this pop up comes up 

 

View details only shows me the transfer record to the bank

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
475 Views
Message 7 of 21
Report
Square Champion

Hmmmm… I’m attaching a screen recording of how I got to this.  I can’t figure out why this won’t work for you.

 

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
469 Views
Message 8 of 21
Report
Square Champion

Here's what I have in a video that shows it all. Why is my screen so different than your screen? How can I get mine to be upgraded? Every month when I do accounting I have to run an export into a CSV file that I open in a spreadsheet so that I can see all the fees and it's been that way for years. This screen has not changed for me for many years. 

 

 

Is it possible that you're part of a beta testing that has a new screen that I don't have?

 

@Katie_SQ do you know who can help with figuring out why my screen is so different?

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
464 Views
Message 9 of 21
Report
Square Champion

@BofBArtStudio I think I know your issue here.  There’s a little weirdness on the Square Dashboard if you hit the “Go to Balance” button and you have sales for the day already.  Instead of hitting that blue button, go to your dashboard Navigation menu and choose “Balance” from there.  Then, you should see what I see.

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
457 Views
Message 10 of 21
Report
Square Champion

That's what I did.  Dashboard Navigation menu choose Balance. As shown in the beginning of my video. 

Frustrating that I am not getting the same result.

 

I will try at midnight when I have no sales yet for the new day.

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
434 Views
Message 11 of 21
Report
Square Champion

Ok.  Sorry.  I missed that you had done that part.  Duh.  One suggestion.  Instead of clicking “view all transfers” have you tried scrolling to the bottom of that location screen?  I’m wondering if since you are a multi-location account, if the “balance overview” might be located further down the screen?  It’s worth a try!

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
429 Views
Message 12 of 21
Report
Square Champion

Scrolling down on that first screen after I hit balance from the dashboard navigation menu, there is just another box that says square savings and a link to "set up savings", and then there's another box with loans and their balances for the square capital loans, and then there's another box below that that says Bitcoin and I can convert some of my daily sales into Bitcoin.  There is no other links or buttons regarding the balance or balance transfers.

 

Maybe this will be one of those examples of when I actually call square support to look at it together and find out why.

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
425 Views
Message 13 of 21
Report
Square Champion

@BofBArtStudio  Let’s take this offline.  I sent you a private message.

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
422 Views
Message 14 of 21
Report
Square Champion

I would think that it would be in the transaction export, which is what we use to do our accounting.

There is a fees column in that export. 

However I just did an export and it doesn't look like from what I can tell that the fees for gift card loads are accounted for in that export.

 

I was looking at it on my phone in Google Sheets, so maybe I missed it.

 

Otherwise, hopefully that is something that is going to be updated very soon.

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
532 Views
Message 15 of 21
Report
Square Champion

@BofBArtStudio Unless I missed a memo in the past few months, the only place that shows GC Load fees is the balance overview report I mentioned above.  I know that many sellers have brought this up (along with other “hidden” data that needs to be made more accessible), but so far it is what it is.  

 

FYI, I checked the last two gift card sales I did (both online so the processing fee is 2.9%+$0.30) and the Fees listed in that CSV’s fees column are ONLY the processing fees.  The GC Load Fee is not shown anywhere in that CSV.

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
530 Views
Message 16 of 21
Report
Square Champion

@TheRealChipA 

 

Thanks for clarifying that. Darn. 

I probably need to make sure that I'm getting that entered into my accounting properly.

Perhaps many of us might want to be double checking our accounting entries.

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
524 Views
Message 17 of 21
Report
Square Champion

@BofBArtStudio This is why I no longer do my accounting entries manually.  Last year, I subscribed to the third-party app Bookkeep which makes all of my daily accounting entries for me.  I just have to check the clearing accounts each morning to be sure they are at zero, which tells me that all monies were accounted for.  It is not a free subscription.  Currently it costs me $60 per month, but after the first of the year they are modifying their pricing structure to allow those of us who do basic stuff to pay less.  But, even at $60 per month, it is well worth eliminating the morning manual work and hassle of tracking down when things don’t balance.  I’d continue to pay $60 per month, gladly, but I’ll take a discount!

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
523 Views
Message 18 of 21
Report
Square Champion

I will have to check into that. That sounds really good. 

I tried to do the QuickBooks integration with Square long ago and it messed everything up so I've been a little gunshy on having any kind of accounting integration. But I will definitely check on that.

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
519 Views
Message 19 of 21
Report
Square Champion

@BofBArtStudio If you want to Zoom with me sometime after the holidays and see how it works, I’d be more than happy to give you an overview and answer questions.  I don’t use QuickBooks (because I hate Intuit and consider it one of the great tech evils on the planet! LOL) but the principles are the same even though I use different accounting software.  Anyway, if we Zoom I can also fill you in on the few manual pieces that will still remain — at least until Square adds more visibility via APIs to things like savings folders.  Honestly, in this case, Square is the only reason why Bookkeep isn’t able to do a perfect job — sad but true.

 

Take me up on the offer.  I can get you a free month to try it out, too — better than their standard 14-day trial.

Chip

If my answer resolves your issue, please take a minute to mark it as Best Answer. That helps people who find this thread in the future.

Piper’s Ice Cream Bar, Covington KY USA
Website
Facebook
Click here to see a list of third-party apps I use to add functionality to my Square account!

जो है सो है
516 Views
Message 20 of 21
Report
Square Champion

@TheRealChipA 

I will definitely take you up on that offer. After the holidays of course. I'll put a reminder in my calendar to reach out to you and set something up.

I love seeing ways to be more efficient and utilize technology and tools, so I am kind of a geek that way. 🦋

~Cheryl!

Square Champion

Sign in and click Mark as Best Answer if my reply answers your question!


Cheryl! Tisland
Burst Of Butterflies Create & Paint Studio

BurstOfButterflies.com
509 Views
Message 21 of 21
Report