OrderOutHelp

Square for Retail: reseller training

Square for Retail is Square's point of sale for retail stores: barcode checkout, a built-in customer directory, item variations, stock counts, purchase orders, transfers between locations, and, with Square for Retail Plus, inventory reports such as cost of goods sold, sell-through and aging.

Presented by Brittany Lee-Sue, Square

Hosted by Mike Collins, Square

Recorded ·41m 9s·Editor’s notes

Recording courtesy of Square. Chapters, notes and transcript by OrderOut.

Plays here from YouTube (privacy-enhanced mode). Nothing loads from YouTube until you press play.

Chapters

  1. Play from 0:00: Retail hardware, team passcodes and permissions
  2. Play from 1:11: Adding items: search, item grid, barcodes and discounts
  3. Play from 3:01: Customer directory, groups, house accounts and loyalty
  4. Play from 4:59: Checkout and payment options
  5. Play from 6:12: Q&A: kiosk, bottle deposits, EBT, age checks and scales
  6. Play from 9:54: Returns, exchanges and restocking
  7. Play from 11:04: Inventory on the POS: stock, receiving and unit costs
  8. Play from 12:37: Stock counts: full, partial and blind
  9. Play from 13:42: Q&A: online store, prices by location, auto-create from a UPC
  10. Play from 14:52: Purchase orders on the POS
  11. Play from 16:26: Compatible hardware and transfer orders
  12. Play from 18:05: POS metrics and the More tab: reports, catalog, orders, invoices
  13. Play from 20:39: Q&A: online sales tax, and Retail with Restaurants
  14. Play from 22:01: Dashboard item library: variations, vendors, alerts, import
  15. Play from 25:10: Dashboard inventory: history, counts, vendors, POs, transfers
  16. Play from 27:58: Q&A: costs by vendor, charging for transfers, spend by vendor
  17. Play from 29:40: Sales reports: summary, trends, items, team, vendors
  18. Play from 32:06: Accounting, payment and operations reports
  19. Play from 34:19: Inventory reports: COGS, projected profit, sell-through, aging
  20. Play from 37:11: Q&A: separate retail and restaurant reports, Square AI
  21. Play from 38:38: Service charge tax, labor vs sales, custom reports
  22. Play from 40:15: Offline mode and loyalty sign-up

What this training covers

Editor’s notes

Recorded in December 2025. OrderOut’s notes, written September 23, 2026, flag what was planned, in beta or dated at the time, and what we cut. Check with Square before quoting a roadmap item.

Questions resellers ask about this

What does Square for Retail do?

It is Square's point of sale for retail stores. It covers barcode checkout, item variations, a built-in customer directory with loyalty and house accounts, returns with restock, stock counts, purchase orders and transfers between locations, plus sales and inventory reports on the Square Dashboard.

What does Square for Retail Plus add?

As of late 2025, Square for Retail Plus added team management (unique passcodes and permission sets for employees) and the advanced inventory reports: cost of goods sold, projected profit, inventory by category, sell-through and aging. Plans change, so check Square's current plans before quoting one to a merchant.

Can Square for Retail create items by scanning a barcode?

Yes. Scanning an existing UPC adds the item to the sale. As of late 2025, scanning a registered UPC that is not in the item library yet offered auto-create, which used AI to fill in the item's name, image and description. Square can also generate SKUs for printed barcode labels.

How do stock counts work in Square for Retail?

Staff run a full or partial count with the Square Handheld's built-in scanner, a phone or iPad camera, or a Bluetooth scanner. The count goes to a review that shows expected versus counted and the variance in units and cost, and permissions can hide the expected quantities from the people counting.

Does Square for Retail accept EBT?

Not first party as of late 2025. Merchants needed an EBT partner, and Square said first-party EBT was in the works without giving a date. Check Square's public roadmap or ask Square for the current status.

Can a store run Square for Retail and Square for Restaurants together?

Yes. A store with a café or quick-service counter can run Square for Restaurants there and Square for Retail at the main register, on one Square account. Inventory, reporting and the customer directory are shared, and reports can be separated by device, category or location.

How are bottle deposits handled in Square for Retail?

As of late 2025, as a service charge assigned to the item, so it is added automatically when the item is sold. Returned deposits are refunded with an unlinked refund. Whether a deposit counts as income was not answered in the session, so check with Square before advising a merchant.

Does Square for Retail work offline?

Offline mode, if the seller turns it on, activates automatically when the connection drops. As of late 2025, offline payments had to reconnect within 24 hours, and the transaction status report shows any that declined. Check Square's current offline terms before advising a merchant.

Answers summarize what Square said in this December 2025 training.

Sell Square with OrderOut

Board merchants onto Square under your own brand and earn residuals.

Request access

Full transcript41m 9s

Lightly edited for reading. Questions from other resellers are paraphrased and labeled “Reseller”.

Play from 0:00Retail hardware, team passcodes and permissions

0:00

Brittany Lee-Sue (Square): We have a new Square Handheld. It's really cool because it has a built-in barcode scanner, so it's really great for retailers who want to be more mobile, especially sellers who do events or aren't physically at the store sometimes. This iPad also works with our Square Stand, or they can always use the iPad on its own, connect to a reader for payments, and use the camera as the barcode scanner.

0:25

This Enter passcode screen is here because with Square for Retail Plus, sellers get some team management features. It lets them create unique four-digit passcodes for their employees and assign permission sets. Say they have some part-time employees who should just run through transactions, versus a manager role, where they want managers to view reports but not make any big changes, and then owner permissions, which would be full access to everything.

0:52

In the top right-hand corner we have a clock-in and clock-out feature, so if they want to do time tracking as well as shift scheduling with Square, that's available here as well. It ties in really well with Square Payroll, so if they want to pay their employees through Square, we have Square Payroll available too.

Play from 1:11Adding items: search, item grid, barcodes and discounts

1:11

Logging into our point of sale, there are a couple of ways you can add items to the cart. In the top left-hand corner we have the universal search bar, where you can search items, customers, discounts and categories, then tap and add to the cart. You have your item grid view on the left-hand side. It's customizable by the seller, and they can name the pages however they'd like. Tap an item and it adds right to the cart.

1:37

If there are different variations of an item, so different colors or sizes, they can set up those variations within Square as well, and we can track inventory per variation.

1:48

The third way is by using barcode labels. If the seller has an existing UPC barcode label, they can just scan that label, and you can see the item added right to the cart. Or if they ever need to create and print barcode labels with Square, Square can auto-generate a SKU number for them, and we can use that to create and print barcode labels.

2:11

This item grid view is also great if the seller wants to apply discounts. We have manual discounts as well as automated discounts. A manual discount, you just tap, and it applies to the checkout.

2:23

Automated discounts are things like customer group discounts: maybe they have VIP customers who get 10% off their purchase. Or quantity discounts, buy two get one free. Or maybe this weekend some specific items are 20% off, and they can set that up to apply automatically from Friday at open till Sunday at close. On the Dashboard end, they get discount reporting, so they can track their discounts and what was applied.

2:50

Also in this group, if they want to add service charges or sell gift cards: we have eGift cards as well as physical gift cards with Square, and that's available here as well.

Play from 3:01Customer directory, groups, house accounts and loyalty

3:01

So we have our items added. Let's add some customer information. With Square, our CRM and customer directory is built in, first party. In the top middle, I'm just going to tap Add customer. This is where you can search your existing customer directory or add a new customer. If the seller forgets to add a customer at checkout, and the customer pays by credit card and inserts or swipes their card, Square will create an automated profile for them. We'll take their first and last name, and if they use their phone number or email for a receipt, build out a profile for them.

3:37

Going into my profile here, we can have name, phone number, email and address. You can even group customers into specific groups: again, VIP customers, or customers who buy certain products or categories, or who spend over $1,000 a month. You can group them together with Square. These groups work really well with those automated discounts, and also with Square Marketing, so if you want to send targeted marketing campaigns to specific customer groups, we can do that through Square Marketing.

4:14

You can also have notes and files, any images or PDFs. We can save payment cards on file, so if you ever want to charge that card on file, we have that available. We can search all past transactions, which come up under their profile. We also have house accounts: something like a customer account, where they come in and purchase several times a month and you just want to invoice them at the end of the month. And we have a loyalty program, so if you want to create and tier a loyalty program based on dollars spent, number of visits or items purchased, you can reward your customers with dollar or percentage discounts, or free items.

Play from 4:59Checkout and payment options

4:59

Cool. So we have our customer added and our items added, and we're ready to check out. In the bottom right-hand corner, we'll tap Charge. This takes us to the payment screen, where the customer can swipe, insert or tap their card. All card payments with Square are PCI compliant. Then you have all your other payment options listed below, based on what you'd like to offer, such as cash, manual card entry and those gift cards. Like I mentioned, we have eGift cards as well as physical cards.

5:26

We can send out payment links. We can also convert this transaction into an invoice: say it's a bigger transaction, and you require a deposit today and the remainder at a later date. We can convert the transaction to an invoice and take payment that way. We also accept Cash App Pay, Apple Pay, Google Pay and Afterpay as payment options.

5:51

I'm just going to tap Cash here. This takes us to the receipt screen, so we can email a receipt or text a receipt, and if you have a receipt printer attached, you can print one too. And if you have our loyalty program, your customer can see how many points they earned today, and if they're not part of the program yet, they'll be asked if they want to opt in with their phone number.

Play from 6:12Q&A: kiosk, bottle deposits, EBT, age checks and scales

6:12

(Reading resellers' questions from the chat.) Square Kiosk, configured for retail? Square Kiosk right now is more for a food and beverage setting. There's no scanning capability on it. You could use it, but it's more of an online-style experience, where customers just select their item and pay. There's no scanning. We do have partners, such as Grubbrr, that allow scanning in a retail kiosk setting, so that could be a partner a seller could use.

6:41

Bottle deposits: we have service charges that can be assigned to specific items, so you could say these bottles have a bottle deposit of 10 cents or something like that. Then to do the return, you'd do it as an unlinked refund. You'd figure out how much bottle deposit you're returning, say it's a dollar because they're bringing in 10 bottles. You can just write "bottle deposit" and refund that to either cash or a gift card, so an eGift card or a physical gift card.

7:23

We don't have EBT first party as of yet. You'd have to use an EBT partner, such as Go EBT, to have that available. I know we're working on bringing EBT first party. I don't know the correct timing on that yet, but I can send Mike the public roadmap, or provide it once we're done with the demo. We have a public roadmap, which has the dates as it's updated.

7:51

Inventory: yes, we have what we call sell-by units. You could say, I receive a case of wine, and that case has six bottles, so you can either sell a case or sell six bottles. As you sell either unit, it deducts from the main inventory of the case.

8:08

Age verification: you can turn that on per item. When it's on, it asks to scan the buyer's ID, so you can scan an actual ID to verify, or you can enter a date of birth, and that adds the item to the cart.

8:26

For Square, you can have a 1D or a 2D scanner, and we have both in our Square Shop. 2D scanners are great because they can scan those actual buyer IDs if you want to do age verification, and 2D scanners can also scan QR codes.

8:45

(On grocery scales.) As long as their barcode-printing scale is a price-embedded barcode-printing scale, we have certain requirements for how that scale is set up: it has to be a UPC-A or EAN-13 barcode, the five-digit PLU on the scale needs to match the five-digit SKU in Square, and it has to be a five-digit price. As long as it's set up correctly that way, we can read those barcodes.

9:16

(Answering a reseller's question: can the deposit be added to items automatically?) Yes. It would be a service charge, and then you assign it to the item. So when the item is added to the cart, that service charge is automatically added with it.

9:25

Sell-by units work the same way for cartons: you receive by the carton, and you can say that carton has so many packs. So you'll see the sales by either carton or pack.

9:40

For scanning to add items to the cart, it has to be those regular barcodes. We can't scan QR codes to add items to the cart, but you do have QR code scanning for customer profiles, if you want to attach a QR code to a customer.

Play from 9:54Returns, exchanges and restocking

9:54

This then takes us right to our Transactions tab. This is where you can pull up all past transactions on the point of sale. You can search by customer name, phone number, receipt number, items on the receipt or any notes on the receipt. A physical receipt also has a barcode you can scan to bring up the transaction. You can tap into a transaction and see all the details, and this is the screen where you can issue a return or exchange.

10:21

You can return or exchange by items or by dollar amount. If we're doing it by items and we're keeping track of inventory, we have the option to restock the items. Say we can resell it: we add it back to our inventory counts, so we restock. Or maybe the item is damaged or opened: we can skip restock, so it shows as a loss on our inventory history report, but you can still issue that return or exchange.

10:51

On this screen you have the exchange box at the top and the return at the bottom, and as we add items, you can see the refund amount update based on what the customer now owes, or what we need to refund.

Play from 11:04Inventory on the POS: stock, receiving and unit costs

11:04

Next up is our Inventory tab. This is where we dig into some of the inventory management features on our point of sale. We're first taken to a stock overview, where you can search an item name, scan a barcode or search a SKU number, and see your on-hand inventory in real time. If the seller uses purchase orders with Square, for ordering and receiving inventory, you'll also see your on-order inventory.

11:30

If I tap into an item here, I'll see all the details, and if I have multiple locations, I'll also see my inventory per location. The top right-hand corner lets me manage stock for this item, so if I need to make any manual stock updates, such as receiving, recounts, or marking something as damaged, theft or loss, we can do it right on this screen.

11:52

If the seller receives inventory outside of a purchase order and just wants to add it to their counts, in the top right-hand corner we have the Receive stock option, where you can search or scan items in, and that updates your inventory. So let's receive inventory here. Say your vendor has variable unit costs: they're updating our costs, and now this dress is $26 to receive in. We can update our unit costs in a purchase order or in this receiving workflow, and your cost of goods sold reporting will calculate based on the first in, first out method. And that just updates your stock right there.

Play from 12:37Stock counts: full, partial and blind

12:37

Also available here is stock counting. You can do full counts as well as partial counts with Square. That's another reason the Handheld is really great: it has that built-in barcode scanner. Or if the seller wants to use an iPad or iPhone, they can use the camera as a barcode scanner, or connect a third-party Bluetooth scanner if they want an actual physical scanner. Full counts, maybe once or twice a year, versus partial counts, where throughout the year they're counting specific categories or sections of the store.

13:11

These counts go in for review, and in the review you can see what's expected in inventory versus what was actually counted, the variance in count and the variance in cost. Once the count is confirmed, your inventory updates automatically.

13:28

Counts can also have permissions on them, so certain employees can contribute to a stock count without seeing what was expected. That way they're not fudging the numbers, or updating the numbers to make it look correct when it's not.

Play from 13:42Q&A: online store, prices by location, auto-create from a UPC

13:43

(Answering resellers' questions from the chat.) Yes, they can create an online store and integrate it with Square. That's all through Square Online. Inventory syncs in real time between in-store and online, and they can also use things like loyalty and gift cards both in-store and online.

13:59

If they need a more advanced website, where they want to do some coding and have their developers work on it, we work really well with WooCommerce. That's one of our partner integrations that's really great for websites. And yes, we can do price overrides per location, so if there's a different price per location, we can definitely set that up.

14:20

Let's go back to our checkout here really quickly. Let me scan this barcode beside me, an item that doesn't exist. It says no matches found, and then it prompts me to create the item. And a really cool feature we have is called auto-create: if the UPC is a registered UPC barcode, Square will use AI to pull the item name, image and description from the internet to make it easier to create the item. Or if you don't have that, you can just create a new item right from this screen.

Play from 14:52Purchase orders on the POS

14:53

Going back to our Inventory tab here, this takes us to purchase orders. The way purchase orders work within Square, the seller can create a purchase order and send it directly to the vendor by email. Or say you order through a vendor rep or a portal: perfectly fine. They can still create a purchase order so it lives in this purchase order overview screen.

15:16

The Dashboard end lets you use an Excel template, so if you want to build out a purchase order in Excel, you drag and drop it into Square. That works on the Dashboard end. OCR receiving should be launching next year, so sellers can drag and drop a vendor PDF and that creates a purchase order for them. It's not available yet, but that will be next year.

15:38

You can see our purchase orders have different statuses: pending, partially received. If I tap into a purchase order, I'll see all the details. You can edit a purchase order at any time, so if your vendor updates unit costs or adds items that weren't part of the initial order, you can update that order. You can print barcode labels from a purchase order, so you'll have as many barcode labels as you need ready to go once those items are received.

16:06

You can also add any additional taxes or fees, such as shipping or handling fees. That gets baked into the unit cost of the item once it's marked as received, so you have more accurate costing. And once you mark the purchase order as received, your inventory updates automatically.

Play from 16:26Compatible hardware and transfer orders

16:26

Cool. I just saw a question about peripherals. We have a Square website with all our hardware, and we also have a list of compatible hardware, so if a seller has existing hardware, you can compare it against our list. If it isn't compatible, we have hardware available in our Square Shop, including receipt printers, barcode scanners, barcode label printers and cash drawers: everything you'd need for a full retail setup.

17:00

Transfer orders: I'll dig into these more on the Dashboard end, because that's where they're created. Transfers are for when you have multiple locations, like you're asking about. You choose your source location and your destination location, you choose which items you're transferring, and those items move into an in-transit status. Once they're marked as received at the destination, inventory is deducted at the source location and increased at the destination location. You can always track these transfer orders on the Dashboard, as well as in the inventory history report, so if you ever want to see past transfers, that's all available there too.

17:43

(Answering more questions from the chat.) There's a lot of reporting on the back-of-house end, which we'll go through, and I think that might answer the questions on low stock alerts. We have our sell-through report, which shows when an item was last ordered and so on, so I'll make sure to show that. And we don't have an integration with the tobacco scan data system.

Play from 18:05POS metrics and the More tab: reports, catalog, orders, invoices

18:05

Last thing here is metrics. Again, when we get to the back of house, we get more robust reporting, where we can filter and export to Excel. On the front of house, this is just a quick snapshot of the last 30 days: your total cost of goods sold, revenue, profit and profit margin.

18:22

(Answering questions from the chat.) And yes, there is a template for importing items, which we'll get to on the back-of-house end, where the seller can find it.

18:29

(Answering a reseller's question about case barcodes: one barcode on a case of six, and another on each item inside it.) With our sell-by units, you can set up different barcodes for the case and for the individual packs or items within the case. Then you can either receive by the case or by the individual unit; you choose which unit you want to receive by.

18:46

Last thing on the point of sale end is our More tab. This is where you'll find sales reporting. It's very summarized compared to what they'll get on the back-of-house end, but it breaks down gross sales, net sales, payment types and fees to give them the net total, as well as top items and top categories. The seller can also customize this report to look at specific date ranges, time frames, devices or team members.

19:16

If they have a cash drawer connected (sorry, I don't have one here), they'll get an end-of-day cash report as well, with starting cash, ending cash, cash in and cash out. They can also print their end-of-day cash reports so they can reconcile their drawer.

19:29

Also on the More tab is your item catalog, so if you need to quickly create or edit an item, you can do it right on the point of sale. You don't have to go to the Dashboard. That's also where the auto-create feature lives, so if you have those registered UPCs, you can scan them there and it can create items for you.

19:51

Also on the More tab, I know there was a question about having an online site. If you have a Square Online website, we have your order manager here. Any time a new order comes in, it's sent right to your point of sale, so you don't have to go to another dashboard to look for your orders. It all lives here. You can tap into an order, see all the details and mark the order with different statuses, and as you update the statuses, the customer is notified.

20:18

Also on the More tab is invoicing. If you want to use invoicing with Square, sellers can find their invoices here and take payment on them in person, or payment links are sent so customers can pay invoices online. And also here are customers, team members and any other front-of-house settings.

Play from 20:39Q&A: online sales tax, and Retail with Restaurants

20:41

(Answering a reseller's question about sales tax on online orders.) For online, you'd have to set up the different tax jurisdictions and areas, so wherever you're shipping to, you'd set up those tax rates, if you're shipping to different states and so on. But Square will give you all the tax reporting you need.

21:01

(Answering a reseller's question about running Square for Retail alongside Square for Restaurants.) There are different kinds of setups. If they have a QSR side with its own point of sale checkout flow, some sellers run our Square for Restaurants point of sale there, and Square for Retail on their main checkout register. They can still ring in retail items on Square for Restaurants, and you can still scan items on Square for Restaurants, so they both work together. I think it depends on what the seller needs.

21:30

If on the QSR side they want more modifiers and that tapping flow for combos, versus the retail side, where they might just need to scan items and do inventory. Some sellers use Retail on both. Some have Restaurants on one and Retail on the other, or run Retail in the back of house and Restaurants in front. It depends on the setup, but it all talks to each other: inventory syncs between the two, and reporting syncs too.

Play from 22:01Dashboard item library: variations, vendors, alerts, import

22:02

And as we move to the Dashboard end here, this is your one main dashboard for everything, so we'll just live on this back-of-house end.

22:14

Good segue into our Dashboard. For context, I'm now on a computer, in a web browser, on the Square Dashboard. This is where the seller can access all their back-of-house features and functionality with Square. You have your menu on the left-hand side, so you can access items and inventory, orders, payments, the online store dashboard if you have one, customers, reports, team members and settings. This is where everything lives.

22:45

Going into Items takes us right to our item library, which is where all our items live. Each item has its own image, name and description. If you have variations of an item, different colors or sizes for example, you can set that up within Square. GTIN is for when you have an existing UPC barcode label: you can enter it in that field and scan it at checkout. For the SKU number, again, Square can auto-generate one for you, or you can use your own to create and print barcode labels.

23:15

You have the category and location: if you have multiple locations, maybe some items are available at one location but not another, so you can set which locations, along with location price overrides. You have on-hand inventory, retail price and unit costs, which give us cost of goods sold reporting as well as projected profit reporting. And again, with variable unit costs, the cost of goods sold report calculates based on the first in, first out method.

23:44

And vendor information: you can create vendors and assign them to your items. You can assign multiple vendors per item, and multiple vendors can have multiple unit costs. We also give you a vendor sales report, which breaks down gross sales and net sales per vendor.

24:02

You can also add a low stock alert, so if you want to be notified when inventory hits a certain number, so you know when to order more, you can set a low stock alert for your items. You can then export that list of low stock items to a CSV file, and what some sellers do is use it to create purchase orders or make buying decisions.

24:25

The Actions button here is where you'd find that template. If the seller wants to use the Excel template to import their items, they just need to make sure the right information is under the right headers, then drag and drop it into Square, and it acts like a mass upload. Barcode printing is available here as well, with some examples of what the barcodes look like: the price, item name, variation name, SKU number, and the barcode they can scan.

24:59

(Reading a question from the chat.) How do accounts work between Restaurants and Retail? As long as it's all under the Square account, the customer directory is shared as well, so you should be good there.

Play from 25:10Dashboard inventory: history, counts, vendors, POs, transfers

25:11

Going into inventory management, you get a stock overview, where you can search an item and see what's on hand, very similar to the stock overview we saw on the front-of-house end. If we go into a specific item, we can make manual stock adjustments on the back of house too: recounts, damage, theft, loss, that's all available here.

25:36

The seller also gets an inventory history report. It shows every stock adjustment: any time they sell, receive, recount or transfer an item, or mark an item as a loss, it shows on this report. They can filter by any date range, by location, adjustment type, vendor or team member. Each stock action has a team member associated with it, so you have that accountability piece. You can also filter by a specific item, so if they're thinking, "We should have 10 of this shirt on the shelf, but we only have six," they can search this report and see if there are any discrepancies.

26:15

Stock counting: I know we went through this on the point of sale, so that's where you'd actually do the count.

26:20

Vendors: this acts as your own internal vendor directory. You can set up your vendors with as little or as much information as you like, and we have an import and export tool for vendors, so if sellers have an existing list of vendors, we can easily import it into Square. Click into a vendor and you'll see all the details, and as you assign your items to your vendors, you can pull up an item library per vendor.

26:49

Once those vendors are created, that's when you can create purchase orders. It's the same kind of purchase order overview we saw on the front-of-house end, and you have the import tool, so if you want to import a purchase order from Excel, that's available here. If I click into my purchase order, I'll see all the details: I can print labels, edit the order, and add taxes or fees. You can also partially receive orders, or mark items as damaged on delivery or will not be fulfilled. And again, once the purchase order is marked as received, your inventory updates automatically.

27:25

And the last thing here is transfer orders. To create a transfer order, you choose your source location and your destination location. If there's an expected date, you can add that; if you're shipping it, you can add a tracking number, and any notes. Then you scan in or search for items to add to the transfer order. You can see your inventory at the source and destination locations and set your quantities, and once it's created, those items move into an in-transit status.

Play from 27:58Q&A: costs by vendor, charging for transfers, spend by vendor

27:58

(Answering a reseller's question about one item costing different amounts from different vendors.) You can have multiple vendors and multiple unit costs per item. Let's go into this backpack here. We have our vendor with a unit cost of $25, but I could also receive it from this vendor for $20. And if your vendors have different codes for ordering that you want included on the purchase order, you can set a different vendor code per vendor as well.

28:26

(Answering a reseller's question about charging other locations for transfers.) The transfer orders themselves are more the inventory movement. If you want to charge the other locations, you can do it through invoicing, if you want to send an invoice, but I guess that's more like selling to the other location. So charging might have to be handled manually, outside of Square.

28:52

(Answering a reseller's question: a prospect wants a weekly report of what they order from each vendor, to see what they spend and with whom.) This is where I think the history report would be helpful, because you can filter by vendor. So we could say from this vendor, let's go this year, maybe Brightport: what did we receive from this vendor? That's what we received in from the vendor, with the cost. If it hasn't been received yet, it would probably have to be in the purchase orders, where you search by vendor to see what you ordered.

29:22

(Answering a reseller's question about transfer suggestions.) I would say the best is to set those low stock alerts. You can set different low stock alerts per location, then filter by location and low stock alert, and use that to see what you want to transfer over, or what you need to order more of.

Play from 32:06Accounting, payment and operations reports

32:06

Accounting-wise, this breaks down your tax names and your taxable versus non-taxable item sales. If you have any fees, this breaks down all your fees, so the processing fees are all broken down here. Service charges: if you have those bottle deposits, or any service charges you add to items, you'll see a breakdown of gross sales per service charge. And reconciliation: if your seller wants to make sure what's being transferred into their bank account actually matches their sales, we have a reconciliation report here.

32:45

Payment-wise, we have payment methods, which breaks down all the payment methods you accept: card versus cash, gift card and so on. For card payments, it also breaks them down by card type (Visa, Amex, Mastercard, Discover and so on) and whether the card was tapped, swiped, inserted or manually entered, along with the fees.

33:08

Transaction status is helpful for sellers who want to operate in offline mode, or who lose connectivity a lot, or are out in the field. We can take those offline-mode payments; they just need to make sure they're back within internet connectivity within 24 hours. This is a great report to see which transactions are going through, and if some decline, they'll see it in this status report.

33:34

Discounts: I mentioned manual discounts and automated discounts. As those discounts are applied, you get a report of gross sales and net sales per discount, and which items were discounted. Operationally, you get an activity log, which shows any time a team member updates inventory, applies a discount or completes a refund.

33:58

We also have our labor versus sales report, so you can see your labor versus sales percentage. If you had employees clocking in and out, there'd be another graph at the bottom showing that labor. It's helpful with staffing, and maybe with hiring decisions.

Play from 34:19Inventory reports: COGS, projected profit, sell-through, aging

34:19

Inventory management-wise, you get your cost of goods sold report, again calculated on the first in, first out method. It gives you your total cost of goods sold, revenue, profit and profit margin.

34:32

The projected profit report takes the unit cost times how much inventory you have on hand, and gives you total inventory value, retail value, projected profit and profit margin. This report is really great because you can backdate it to a day, so if you want to see your end-of-year inventory valuation, this is a great report for that. I know there was a question about that earlier. Inventory by category: if you categorize your items, you'll see inventory value, potential profit and profit margin per category.

35:09

The inventory sell-through report acts as a kind of inventory health report. It gives you your sell-through percentage, your sales velocity, what you have on hand versus what you sold, when you last sold an item, when you last received it into stock, when you've been out of stock, and what's on order. If any of these items are on an existing purchase order, you can pull up that purchase order.

35:37

You also get some action buttons at the end of this report. If I scroll here: from this report, you can order more right from the report. A healthy sell-through rate is around 80%. Say you're selling through at 100%: maybe you want to edit your low stock alerts so you're notified when inventory hits a higher number, so you know when to order more. Or say you're selling through at 20%: you want to apply a discount or reprice that item, or you can even use Square Marketing to create a campaign letting your customers know you have that item. It's great reporting for seeing how your inventory is moving, and it can help with buying decisions. You can also filter it by location, so you can see sell-through, and update discounts and prices, per location.

36:26

And the last report here is our aging inventory report. It gives you the average age of how long items have been sitting on your shelves, when they were last received into stock, and quantity and value, ranging from 0 to 30 days all the way up to 120-plus days. It's another great report for seeing what's moving and what's not, so maybe we need to return some items to the vendor, or stop ordering them. It gives us those insights here as well.

36:58

Other than that, there are some custom reports the seller can make, like a custom item report, or they can always export all these reports to CSV files if they want to reconcile further.

Play from 37:11Q&A: separate retail and restaurant reports, Square AI

37:12

(Reading questions from the chat.) I think if you want to separate retail reporting from restaurant reporting, there are different ways to filter reporting. You can name the devices differently, so maybe you have a retail-specific device and a restaurant-specific device, or maybe we just go by categories: retail items in one category versus food items. So you're able to filter reporting. It depends on how sellers want to set it up. Some sellers have them as two separate locations, but some have just one location and use filters to separate retail from restaurants.

37:47

(A reseller had asked about Square AI.) Is there any specific reporting you're looking for from the AI?

37:51

Reseller: No, just looking, for example: I'm assuming you can click a button and talk, and it recognizes what you're asking for, for a certain report. Like, how much did I sell of X last month, or whatever.

38:08

Brittany Lee-Sue (Square): So, a category last week, something like that, right? "How much did I sell of my accessories last week?" It'll search with AI and hopefully give us a good answer. You can see we made $329 in gross sales from accessories, and it breaks it all down. Then you can even ask more questions, like "Which top-selling accessory item should I make a marketing email campaign about?", something like that.

Play from 38:38Service charge tax, labor vs sales, custom reports

38:39

(Answering a reseller's question about service charges and sales tax.) When you set them up, you can say whether they're taxable or not, so whether sales tax is applied. If you don't want taxes applied, just turn that off.

38:54

(Answering a question about labor versus sales.) When you set up your team members, you can enter them as hourly or salaried staff, and that's factored into the labor versus sales report.

39:08

As for the custom reports: the custom report is different from the custom item report. I call it a Frankenstein of our sales and transactional reports: you choose which of these reports you want to put together in one view, and then view them all at once instead of clicking into each one. It's one report with all the information you'd look at for the day. It doesn't really require anything; it just refreshes as it goes, because reporting updates in real time, with the exception of the sell-through and aging inventory reports, which update every 24 hours at 8 p.m. Eastern.

39:50

And then the custom item report breaks down all your items, and you can filter further to look at specific date ranges or items, so you can select what you want to see. This one is for when you want to dig into actual items, what's selling and what's not. This report's really great.

40:11

Cool. That's pretty much Square for Retail, front of house and back of house.

Play from 40:15Offline mode and loyalty sign-up

40:16

(Answering a reseller's question about the software timing out.) There usually isn't a problem, because Square is unique in being your point of sale as well as your processor. The only timing-out I've ever had is when you're losing internet connectivity and don't have offline mode activated. If you have offline mode toggled on, it activates automatically when you lose connectivity.

40:39

(Answering a reseller's question about signing customers up for loyalty.) It's part of the checkout flow. As you run through your transaction, if the customer isn't part of the program yet, at the end of the transaction it gives them the option to sign up for loyalty with their phone number. Or if your seller uses our Square Register, which is our hardware with a front-facing customer screen and an employee-facing screen, customers can sign up or sign into their loyalty program at any time with their phone number on that screen.

Chapters, notes and transcript by OrderOut. Still stuck? Email reseller@orderout.co·All guides