Square for Retail Reporting FAQ
No. With Square for Retail Free, you will have access to the Item Sales report, Category Sales report and Sales by Payment Type report. To view the COGS and Margin report, Projected Profit report, Inventory Category report and Sales by Vendor report, you will need to have a subscription to Square for Retail Plus.
Yes. You can update unit costs for items from the History log on your online Square Dashboard. The item cost can be updated for any stock intake such as stock received, re-counted to adjust up and restock.
Read more about updating your unit costs.
FIFO stands for first-in, first-out. The FIFO method means the first items you receive (in) at a certain cost will be the first the first items recorded as sold (out).
For example:
Let’s say you purchase three shirts at a cost of $2. Later purchase two more of the same shirt, but at a cost of $3. If a customer buys four shirts, your reports will reflect the sale of three shirts at $2, and one shirt at $3. The total cost for all four shirts sold will equal $9.
The item variation unit cost will help ensure that your inventory reports will reflect your profit and profit margin for future sales. The item variation unit cost will pre-populate on purchase orders and when you manually receive stock.
Updating your unit cost via History log will correct errors or discrepancies in your reports. If you previously received stock without a unit cost, profit and profit margins will not be represented in your reporting. When you update the original stock intake in your History log, your profit and profit margins will be accurately represented in your COGS report.
Yes. Your Retail reporting will reflect variably priced items; however, since your Projected Profit and Inventory by Category reports estimate your profit for future sales, variably priced items will not have a predicted profit or profit margin.
If you update a unit type, historical sales will reflect the previous and new versions as separate line items.
If you’re looking at the Projected Profit or Inventory by Category report, keep in mind these reports generate your daily sales one hour after your scheduled close of day. If you just closed your business, you’ll need to wait one hour before they will update.
Your Retail reports may also be lower because a historical stock adjustment did not include a unit cost.
To identify and update missing unit costs:
- Log in to your Square Dashboard.
- Go to Items > Inventory Management > History.
- From the All Costs dropdown menu, select Missing Cost.
The Missing Cost filter will display a list of items that are not associated with a unit cost.
To add a unit cost:
- Tap Add Cost next to one of your items.
- Enter the unit cost and select Save.
Note: If you have variably priced items, we won’t be able to provide an anticipated profit or profit margin until you sell the items at a fixed price.
Read more about Retail reporting.
The first time you import your stock to your item library, the intake will be marked as a receive. For every subsequent stock import, your stock intake will be marked as a re-count.
Note: Depending on whether your stock intake is considered a receive or re-count, your Cost of Goods Sold report will be affected differently. Receiving stock will not have an effect on your Cost of Goods Sold (COGS). However, re-counts that adjust your stock up will credit your COGS (decrease), and re-counts that adjust your stock down, will debit your COGS (increase). If you’re only interested in seeing profit and profit margin for sold items (i.e. excluding re-counts), apply the Sales filter.
Updating your unit costs using the bulk import in your item library affects your reporting the same as manually updating from the item variation – moving forward, your reports will reflect the updated costs.
If you set your item cost and stock with a single import, the new cost will apply to the new stock count. However, for stock already received in your library, head to your History log to update the associated unit cost.
Here are some actions for potentially intaking stock without a unit cost:
- Re-count up without a set unit cost.
- Received stock without a set unit cost and without manually setting a unit cost. If you manually set a unit cost on a receive, we’ll add it to the item variation.
- Manual restock not associated with an itemized return.
Yes. By visiting the Vendor Sales Report in your online Square Dashboard, you can view which items are sold in a given time frame, sorted by vendor. To do so:
- Go to Reports > Inventory Reports > Vendor Sales in your online Square Dashboard.
- Use the date selector to choose the date range you’d like to view, or enter custom dates.
- If you have more than one location, select which ones you’d like to see.
Read more about Square for Retail reporting.