thread Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen in Beauty & Wellness

🗺️ How to sort Retail vs Services sales (and more!) using category rollups on Square Appointments

tranguyen — Tue, 09 Dec 2025 18:12:01 GMT

Hey everyone ✨!

We’ve recently brought the Category Rollups feature that used to only be available to Square for Restaurants users over to Square Appointments Plus and Premium subscribers. This unlocks a bunch of cool opportunities for beauty sellers so I wanted to take a second to highlight one way to use it that should help alleviate a common request I’ve heard from sellers — the ability to split your category or item sales reports by retail sales vs service sales when you already have other categories being used.

In order to set this up:

Go to your category sales report by going to your Dashboard > Reports > Category Sales
Click the Rollups button
Name your first Rollup “retail” (or whatever else you want to call it)
Select all of your categories that contain retail items

If you don’t already have categories for all of your items and services you may need to create those categories which you can do here

Click Create a Category Rollup
Repeat this process naming your second rollup “services” (or whatever else you want to call it)
Now you can filter and arrange data on the category sales report and item sales report by your new Retail and Services category rollups.

If you have any feedback related to this or if there is another appointments or beauty specific reports or reporting feature you'd love to see us work on, let us know in the comment!

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

TCSlaguna — Mon, 08 May 2023 22:33:27 GMT

@tranguyen

For the Category Sales report, it would be nice to have a column for Profit Margin.

I also exported to Excel to calculate how much each Category Rollup was as a percent of revenues.

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

BrettA — Mon, 08 May 2023 23:17:13 GMT

Thanks for the feedback @TCSlaguna ! Can you talk to me more about the column you'd want for profit margin? Would that only be for retail items or for services as well? How would you think about calculating it?

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

TCSlaguna — Tue, 09 May 2023 15:00:31 GMT

Hi @BrettA

Good question.

I think Profit Margin for retail items is straight forward, the system has that in place already.

For our services, we have programmed in Appointments that the service providers get __% commission on their services. So I think it could be based off that.

Parties on the other hand, that's a little trickier.

However, keep in mind that Category Rollup does not have to necessarily be based on Retail vs Services. People could have it based on Perishable Goods vs Nonperishable Goods, or whatever other random thing they decide. So having profit margins available will help sellers who use Category Rollups across retail items.

Please let me know if you have any further questions.

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

BrettA — Tue, 09 May 2023 16:16:19 GMT

Awesome, yes, all of this makes perfect sense. Appreciate the insight/feedback @TCSlaguna !

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

SiBellebeauty — Wed, 28 Jun 2023 11:15:55 GMT

Ooh this is great! I’m going to give it a try x x

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

EstyGirl0023 — Thu, 06 Mar 2025 05:44:05 GMT

Thank you for this. I have been hunting all over for this. I’m wondering if there is a way to automate saving a percentage of retail sales to go into a savings folder for purchasing product. Having to do it manually daily or weekly to make sure I am able to replenish retail shelves.

Re: 🗺️ How to Sort Retail vs Services Sales (and more!) using Category Rollups on Square Appointmen

Bronze_Palms — Fri, 18 Apr 2025 01:14:51 GMT

I LOVE this feature! I have different categories for our retail types (clothing/apparel, tan retail, teeth whitening retail) so having them all in one category roll up is great; I do the same for services since we offer 3, then another for packages.