Yesterday’s sales, written into your sheet before you open it.

A Google Sheets add-on for Square merchants. Same figures as your Square Sales Summary.

Get early access

14-day free trial · Read-only access to Square

Daily

Hourly Month to date Log Sample data · fictional shop
Sample Daily tab: one row per location per day. Fictional figures.
LocationDateGross salesDiscounts & compsReturnsNet salesTaxTipsTotal collectedOrders
Harbor StNov 163,284.00−96.40−42.003,145.60259.53412.753,817.88182
Mill RdNov 162,041.50−38.000.002,003.50165.29244.102,412.89119
Market HallNov 161,612.25−55.800.001,556.45128.41201.601,886.4697
Harbor StNov 173,509.75−97.250.003,412.50281.53441.204,135.23196
Mill RdNov 172,130.10−44.000.002,086.10172.10259.352,517.55124
Market HallNov 171,801.95−57.00−18.501,726.45142.43220.402,089.28104

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.

  1. OnceAdd Tillsheet to a Google Sheet. It lives in the Extensions menu, in the spreadsheet you choose.
  2. OnceConnect Square. You sign in on Square’s own page and approve read-only access to reports and your business profile.
  3. 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 access

Questions

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.

Tomorrow morning, the row could already be there.

Get early access