How can I find the fees associated with transactions of a specific item during a specific timeframe

[NIHM]

I have a consigner who does local tours and our store sells tickets for him. Our consignment deal includes him paying the card processing fee for transactions of his ticket sales. His payouts happen every two weeks, so I need to be able to filter by time period as well.

Previously I've simply exported an Item Sales Summary (or Detail, I can't remember right now) Report, which included a column for Fees. It seems Square has done away with this column in both Item Sales and Item Category Sales, in favor of a new Fees report tab that doesn't have any filtering capabilities beyond monthly overviews.

Anyone know any other reports or workarounds that could help me out here?

[Summer2024]

Hi there, @NIHM! 

While it doesn't seem like you can still see fees associated with transactions of a specific item during a specific timeframe, you are still able to see the amount in sales that you did for these specific items.

My advice would be to tell your consigner that you will charge a certain fee on the gross amount in sales that his item does. That way you can still print a report that shows the net sales and then calculate the fees yourself.

Not the best workaround, but a workaround nonetheless. 

I hope this helps! 

[NIHM]

I suppose this is currently my only option, hopefully he's receptive to renegotiating.

I'm sure I'm not the only person affected by this change. It's a shame to see perfectly functional features being removed, especially when the replacement feature can't do the same job.

[frances_a]

Hello @NIHM 

Would you be available to attach a screenshot of the report you were previously using? Please make sure to edit out any personal information before posting. 

I went ahead and escalated your concern to our team, but we have had no recent updates to our Item Sales report, so the team would like to see what the report looked like for you before and how long ago you noticed this change. 

I'll keep an eye out for your reply!

Thank you ✨

[NIHM]

Thanks for reaching out @frances_a 

I just noticed it about a day or two before I posted here. To be fair it could have happened quite a while ago, I believe the last time I needed this report was Sept 2023, as the tours don't run during the winter months.

I couldn't find any original exported CSV's still on my computer, but here is a snip of a lightly edited one.

[NIHM]

Forgive me @frances_a @Summer2024 turns out I just wasted your time 😅 

The report I used to originally get this information was a transactions CSV report, which still functions as it was. So there was no issue to begin with.

On top of that I've realized that the transaction reports I was using aren't ideal for this situation anyway, as it gives the total and fee amounts for the entire transaction, so if there was some of our merchandise in the same transaction as a tour ticket we could accidentally overpay. Luckily that never happened.

Thank you for your replies!

[frances_a]

Hi @NIHM 

Oh! No worries. 

That actually makes a lot of sense. 

When I reached out to our team we were all a bit confused as our fees are always calculated based on the total amount we process, rather than the price of each item. However, we were determined to find out if something had changed and was affecting your reporting options. 😅

Thank you so much for letting us know what had happened! I will update the team.