Reconciling Sales Batches in Rose with Square

Learn how to reconcile sales batch totals in Rose vs net sales in Square.

1.    Login to your Square Dashboard and select Reports

Screenshot 2024-08-02 at 11.26.35 AM-1

2. Then select Summary and click "Daily.”.
3. Then select the date from the date picker.

Screenshot 2024-06-28 at 3.40.24 PM

4. Scroll down to where you see Net Sales. That is the sales amount that you want to match in Rose.

Screenshot 2024-08-02 at 12.35.43 PM

Screenshot 2024-06-28 at 4.07.02 PM

4.    If they don’t match, click the blue Re-Read Sales Batch button. Give it a minute and refresh.

Screenshot 2024-06-28 at 4.11.39 PM

5.  Also, sales that are in red cannot be posted to an account as is. You need to fix a a faulted sale.  

6.   To fix, add the Consignor Account number, or known SKU, category code, and category name. 
7.   Click the “Save Changes”
8.    Now select “Complete Batch Post” to complete.

PDF Friendly Version

Reconciling What You've Already Posted

If you've already posted sales you'll want to run an "Item Sales" Report from your Square dashboard Reports screen. Export that spreadsheet.

You'll want to compare that with Rose.

In Rose, go to REPORTS from the menu. Find the Period Reports section. Put your Start and Finish date in and check the box for "Sales Report" and click the Report button. Compare this report with your spreadsheet from Square.

To add missing sales, you'll want to do a Single Entry sale thru Rose. Click the link to learn how to manually add missing sales back into Rose.