| Location | Date | Gross sales | Discounts & comps | Returns | Net sales | Tax | Tips | Total collected | Orders |
|---|---|---|---|---|---|---|---|---|---|
| Harbor St | Nov 16 | 3,284.00 | −96.40 | −42.00 | 3,145.60 | 259.53 | 412.75 | 3,817.88 | 182 |
| Mill Rd | Nov 16 | 2,041.50 | −38.00 | 0.00 | 2,003.50 | 165.29 | 244.10 | 2,412.89 | 119 |
| Market Hall | Nov 16 | 1,612.25 | −55.80 | 0.00 | 1,556.45 | 128.41 | 201.60 | 1,886.46 | 97 |
| Harbor St | Nov 17 | 3,509.75 | −97.25 | 0.00 | 3,412.50 | 281.53 | 441.20 | 4,135.23 | 196 |
| Mill Rd | Nov 17 | 2,130.10 | −44.00 | 0.00 | 2,086.10 | 172.10 | 259.35 | 2,517.55 | 124 |
| Market Hall | Nov 17 | 1,801.95 | −57.00 | −18.50 | 1,726.45 | 142.43 | 220.40 | 2,089.28 | 104 |
One row per location per day, in your own spreadsheet. Run it twice and the row is updated, never duplicated.
Set it up once. Then it just happens.
- OnceAdd Tillsheet to a Google Sheet. It lives in the Extensions menu, in the spreadsheet you choose.
- OnceConnect Square. You sign in on Square’s own page and approve read-only access to reports and your business profile.
- Every morningYesterday’s row appears. Each location gets its line for the day. If a sync ever fails, you get an email.
The figures you already check in Square.
Tillsheet reads Square’s own reporting data, the source behind the Sales Summary in your Square Dashboard. Discounts and returns keep Square’s signs, and orders are counted the way the Dashboard counts them.
The Square Dashboard remains the source of truth. Check figures there before you file taxes.
- Gross sales
- Before discounts and returns
- Discounts & comps
- Negative, as Square shows them
- Returns
- Items returned that day
- Net sales
- The number most people look for first
- Tax · Tips
- Collected that day
- Refunds
- Money sent back
- Total collected
- What actually came in
- Orders · Avg sale
- Refunds aren’t counted as orders
It reads totals. Nothing else.
What Tillsheet reads
- Daily and hourly sales totals for each location
- Your business and location names
- The one spreadsheet you install it in
What it never touches
- Individual orders, items or customers
- Card numbers or payment details
- Anything that changes your Square account
Disconnect from the sidebar at any time, and the stored connection is deleted. Details in the Privacy Policy.
Also in your sheet
- Hourly tab to see when the rush really is
- Month to date per location, kept current
- Backfill past days so the sheet starts with history
- Sync log with every run and its result
Try it free for 14 days.
After the trial, Tillsheet is a monthly subscription, billed by Paddle. We’ll announce the price at launch. Cancel any time.
Get early accessQuestions
Will the numbers match my Square Dashboard?
They come from Square’s Reporting API, the same data behind the Sales Summary, and Tillsheet uses the same measures. The Square Dashboard stays the source of truth.
Can Tillsheet change anything in Square?
No. It asks Square for two read-only permissions. It can’t take payments, edit items, or see customer details.
I have several locations. Does that work?
Yes. Each location gets its own row for each day, in the same tab.
Can I bring in past sales?
Yes. Backfill fills in earlier days a chunk at a time, without duplicating rows that are already there.