Why are Fees different in Different CSV files?

[Candlestore]

So I have been playing around with Pivot Tables in Excel and Google Sheets.  Found a way using this to match my Daily Deposits to my Bank account.  Was looking for questions on that and then found other articles where Transactions, Transfers and Sales Reports were not matching.  I downloaded these to compare and using Pivot Tables it is easy to see differences.  So I did these on Square Fees for 2023 so far and am showing a Difference.  All I did was download Jan 1st, 2023 csv files for these files and then selected in Excel to create a Suggested pivot Table.

Sales Report for this time frame shows Square Fees of $1284.25

My Transaction Details Shows Square Fees of $1284.25

My Transfer Details Report  Shows Square Fees of $1263.89

Does anyone know why this would be? 

Here is a Screen Shot of my Excel Pivot Table for my Transfer-Details CSV and my Transactions CSV files.

You can also do this in Google Sheets and create these same pivot tables for free.

I am just wondering why there is a Difference between the Fees in these two CSV files.

[TheRealChipA]

Hey @Candlestore.  Did you receive any free processing this year?  If so, I found that the transactions CSV shows the fees, which are refunded when the deposit is made.  However, the transaction still shows the original fee.

[Candlestore]

@TheRealChipA ;

I am not sure if I did get Free Processing at any time this year but I would think it would be listed in the Transactions Excel Pivot Table under Sum of Adjustment Fees if I did get any.

I am just trying to see why they are different and one is Labeled Sum of Fees  and the other is Sum of Initial Fees and are different when there were do Listed Adjustments.   I would figure these different reports should be identical for Fees and other numbers Like Gross Sales, Net Sales etc... which other posters stated were different dating back from 2017 etc.   So I tried looking at mine to see if I had any Differences and this stuck out and a few other numbers that I did not post here.

I would assume there is a logical explanation but I just do not know what it is.  Yours with the Free processing would make sense if that showed as an adjustment.

[TheRealChipA]

I just looked at a day last week when I had free processing all day.  The initial fees show what they would have been without free processing.  There are no adjustment fees.  And my deposit report shows a fee refund.  So my fees for that day (per the deposit report) are $0, though my fees for the day (per the Transactions CSV) still show fees charged (which were refunded).  It’s always been this way.

[TheRealChipA]

I asked someone at Square about it one time.  I was told that since they do the free processing credit at the deposit level  and not the transaction level, they don’t go back and adjust the transactions.  I thought it was weird, but they were right as far as getting things to balance.  They won’t balance.

[Ellie_]

Hi there, @Candlestore!

Thank you for posting this, I am looking into this for you and will reach out when I found out more information. 

[Candlestore]

@Ellie_ ;

Thank you for looking in to this.

[Ellie_]

Thank you for your patience, @Candlestore, if the information that @TheRealChipA has provided still does not add up for your amounts, we recommend getting in contact with our direct Customer Success team at 855-700-6000.