Tracking Fees with Category Reports

[cpSnackShack]

The title of this thread has been edited by a Square Moderator from the original: Tracking fees

Two families are having a yard sale, in Square Register, we have added items and with the categories being “Smith Yard Sale” and “Doe Yard Sales” all the money and charge cards going into one account. At the end of the day, we run the reports and get a breakdown of each family gross sales. Is there a way to see a breakdown of the credit card fees as well? I need to see the fees for the Smith and for the Doe. This way, when we divide the money. We can subtract each family fee from the credit card deposit when we settle the accounts.

[Sammie_C]

Hi @cpSnackShack, we appreciate you reaching out!

This is possible! Here is a helpful article going over category reports, which is what you would need to access to view the fees for each group.

Another suggestion would be to possibly export your reports into a CSV and then separate/calculate from there too. You could even create a "custom report" that could include all this information in one.

I hope this helps a bit! Please let me know if you have any other questions.

[cpSnackShack]

Thanks for replying, I have categories set up, but what I am needing is a way to track Net Sales per categories. We need a way to organize our end-of-day sales by category with the Net Total for that category (fees taken out).  I see the Gross total for each category sold that day, then I see the total fees that were deducted, not for each category.

I need a report that can show - Example:

Category	Items Sold	Gross Sales	Fees	Net Sales
Smith Yard Sale	3	150.00	1.75 (1 cc trans)	148.25
Doe Yard Sale	4	200.00	7.03 (4 cc trans)	192.37

Not just a total fee showing $8.78 since the bigger fee came from Doe Yard Sale.

Hope this makes sense. 

[Candlestore · Accepted solution]

@cpSnackShack , @Sammie_C ;

I do not think this is Possible with Square or even with 1 csv file.

Following @Sammie_C  way you can get a report for Categories but no Square Fees associated even after pressing the + on the far right.  When Downloading Transaction CSV files there only 1 Transaction CSV that shows Square Fees, but then no Categories.  When you download the Items Details you can see the Categories but then No Fees.

You could Merge the Transaction CSV files, then do a Pivot table based on Category to get what your after I believe.  

Headers for Transactions Detail Csv :

As you see below this has Fees but no Category

Date

Time

Time Zone

Gross Sales

Discounts

Service Charges

Net Sales

Gift Card Sales

Tax

Tip

Partial Refunds

Total Collected

Source

Card

Card Entry Methods

Cash

Square Gift Card

Other Tender

Other Tender Type

Tender Note

Fees

Net Total

Transaction ID

Payment ID

Card Brand

PAN Suffix

Device Name

Staff Name

Staff ID

Details

Description

Event Type

Location

Dining Option

Customer ID

Customer Name

Customer Reference ID

Device Nickname

Third Party Fees

Deposit ID

Deposit Date

Deposit Details

Fee Percentage Rate

Fee Fixed Rate

Refund Reason

Discount Name

Transaction Status

Cash App

Order Reference ID

Fulfillment Note

Free Processing Applied

Channel

Unattributed Tips

Table Info

Here is the Items Detail csv:

This has Category but no Fee.

Date

Time

Time Zone

Category

Item

Qty

Price Point Name

SKU

Modifiers Applied

Gross Sales

Discounts

Net Sales

Tax

Transaction ID

Payment ID

Device Name

Notes

Details

Event Type

Location

Dining Option

Customer ID

Customer Name

Customer Reference ID

Unit

Count

GTIN

Itemization Type

Commission

Employee

Fulfillment Note

Channel

Token

The issue I believe it that 1 Sale can have Multiple Items that are in different Categories.  The Fee Square Charges is by the Total of the Sale plus Sales Tax if any.   Squares Fees are not based on an Item or the category just the Total amount Charged to a Credit Card.  When You setup your Square Account, even from here forward you could assign Sales Associates.  This may work if 1 associate is only selling their items but if you sell the items from both yard sales in 1 transaction you will have to calculate manually again.

I think this is why your having a problem finding what your looking for.  

What you should try setting up in Square is Team Members.  Then under Staff you could have your name and Neighbors name for example and sort by Staff in the Details CSV file.  

Here is more about Team Members:

8356-add-and-manage-team-members 

Since it is currently only You and your Neighbor Square lets you assign 2 accounts for free.  1 for the Owner basically and 1 For sales Staff.  This may work for you in the future, but will not adjust your previous sales.

[Woodljn]

We need this feature as well. I can't believe Square doesn't offer this very basic level of reporting. I have just taken over the books for a nonprofit and I've never worked with Square before. I was shocked at the lack of basic reporting available and it's an absolute nightmare categorizing accurate net sales per item category in quickbooks when I have a report that lists gross per item and lumps the fees together as a separate line item. 

PLEASE make reporting like the example above an option.