It's month-end and the Sheet is lovely. There is a SUMIF in cell H2 that adds up every Meals row, a tab of monthly totals, and a column that shades red when something is missing. The only trouble is the shoebox on the shelf behind you. It holds a month of thermal slips, and the inbox holds a month of PDFs. None of them ever became a row.
The formulas are fine. They're just adding up an almost empty column.
Why do Google Sheets formulas need rows first?
A formula can only add up, filter, or group what is already in a cell. So the real work in receipt tracking happens before the formula, when each receipt becomes one row with a date, vendor, total, tax, category, and source.
What does a clean run of receipt rows look like?
One receipt, one row. Here is an invented stretch of five receipts and one card charge with no receipt behind it yet:
| date | vendor | total | tax | category | source |
|---|---|---|---|---|---|
| 2026-08-29 | Corner Hardware | $41.30 | $3.40 | Supplies | thermal slip |
| 2026-09-02 | Adobe | $59.99 | $0.00 | Software | email PDF |
| 2026-09-04 | Blue Bottle | $14.80 | $1.22 | Meals | phone photo |
| 2026-09-09 | Staples | $63.45 | $5.22 | Office | email PDF |
| 2026-09-12 | Blue Bottle | $9.60 | $0.79 | Meals | phone photo |
| 2026-09-15 | CITYPARK 0412 | $22.00 | not shown | needs receipt | card statement line |
| Receipt rows | 5 receipts | $189.14 | $10.63 |
The sources are mixed on purpose: a thermal slip, two email PDFs, two phone photos. In the sheet they all look the same. The last row is different. A card charge proves money left, but it isn't a receipt row until the receipt turns up, which is why its tax says not shown and its category says needs receipt. The reasoning is in a card statement is not a receipt.
That card line is out of every total on this page. The footer adds the 5 receipt rows only: $189.14 in totals and $10.63 in tax. Once the receipt arrives, you fill in the row and it joins the sums.
Which formulas work once the rows exist?
Three small ones cover most of a month-end, and a fourth keeps the gaps visible:
| formula | what it does | result on the sample rows |
|---|---|---|
=SUMIF(E2:E7,"Meals",C2:C7) | Adds the total column for every row whose category is Meals. | $24.40 |
=QUERY(A1:F7,"select B, sum(C), sum(D) where B is not null and F <> 'card statement line' group by B label sum(C) 'Total', sum(D) 'Tax'",1) | Groups total and tax by vendor, skipping the card-statement-only line, with a header row in the data. | Adobe $59.99 / $0.00; Blue Bottle $24.40 / $2.01; Corner Hardware $41.30 / $3.40; Staples $63.45 / $5.22 |
=SUMIFS(C2:C7,A2:A7,">="&DATE(2026,9,1),A2:A7,"<"&DATE(2026,10,1),F2:F7,"<>card statement line") | Adds September's totals, from the 1st up to but not including October 1, ignoring the card-statement-only line. | $147.84 |
=COUNTIF(F2:F7,"card statement line") | Counts the rows still waiting on a receipt. | 1 |
The QUERY formula shows how much a clean column buys you. It only works because column A holds real dates and columns C and D hold numbers. Google's help page says each column in a query can hold only one kind of value, and that a mixed column is read by its majority type, with the minority values treated as empty. A stray $12.50 tip incl. in the total column is exactly that problem.
The month formula uses SUMIFS with a date window, so it needs dates the Sheet recognizes. And it leaves out the card-statement line on purpose, so the $22.00 sitting in that row never leaks into September's $147.84.
How do the rows get into the Sheet?
Slipsheet makes the rows. Photograph the slip, upload the PDF, or forward the email to receipts@slipsheet.app. OCR reads the page, and you review each row: the date, the vendor, the total, the tax, and the category you set.
Then you export a CSV and bring it into your Sheet yourself. In Google Sheets that is File > Import, then Upload, then your file, then an import location. Google's help page describes choosing to replace or append data, and appending puts the new rows under the old ones. That is the whole path: review, export, import.
Slipsheet doesn't write your formulas, and it doesn't sync with your Sheet. The formulas are yours and they stay in your file. If you want the full setup for a tracker tab, how to track receipts in Google Sheets covers it, and this page doesn't try to.
What about mixed-use bills and tax?
The category and the source are your calls at review time. If something is partly personal, keep the full amount on the row and note it, so whatever split your accountant picks is applied to the real number. This page is about the ledger, not tax advice.
A few straight answers
Can Google Sheets formulas read my receipts?
No. Formulas work on cells that already hold values. A SUMIF can add up a column of totals, but it can't read a photo, a PDF, or a paper slip. Each receipt has to become a row first, with a real date and a number in the total column.
Does Slipsheet write the formulas or sync with my Sheet?
No to both. Slipsheet turns receipts into reviewed rows and exports a CSV. You import or append that file into your own Sheet, and the formulas live there, written by you. There is no live connection between the two.
How do I add a new month of rows without breaking my formulas?
Use File > Import, choose Upload, pick the CSV, and choose Append to current sheet so the new rows land under the old ones. Keep the same columns in the same order, and check that the header row from the CSV didn't land in the middle of your data and that the date column imported as real dates.
Should a card charge be in my totals?
Not as a receipt row. A card charge proves money left but doesn't carry the tax or the receipt behind it. Keep it on the sheet flagged as waiting for a receipt, and leave it out of the totals until the receipt row exists. Whether and how a charge counts for tax is a question for your accountant.