Slipsheet · Content Back to ledger
Home / Receipt Merge: Turn One Trip's Slips Into One Clean Total
Receipt Merge: Turn One Trip's Slips Into One Clean Total

Receipt Merge: Turn One Trip's Slips Into One Clean Total

Slipsheet doesn't merge receipts, and for a trip that's a good thing. Every slip becomes its own row, you tag the trip's rows alike, and one formula after export turns them into a single total you can bill or file.

Why one trip turns into a mess

A two-day client trip leaves a cab slip, a hotel folio and a lunch receipt. In a shoebox or an inbox folder they're three separate scraps, and by invoice time you're hunting for which ones belonged to the trip. Typing them into Excel or Sheets by hand works, but you're stitching rows together from faded thermal paper and hoping the totals match.

What you actually want is the trip as one line you can put on an invoice, with each slip still behind it if anyone asks.

Method A: tag the trip's rows in review

Upload the photos, PDFs or forwarded emails. In Slipsheet's review queue, open each receipt and give it the same client_tag and the same note, here "Portland trip, Oct 1 to 2". Set the category per slip: travel, lodging, meals. Slipsheet still keeps one row per receipt; the shared tag and note are what make them read as one trip.

datemerchanttotal_amountcurrencytax_amountcategoryclient_tagnotesfile_name
2026-10-01Rose City Cab38.50USD0.00TravelHarbor & Co.Portland trip, Oct 1 to 2IMG_6021.HEIC
2026-10-01Hotel Lumen214.00USD18.19LodgingHarbor & Co.Portland trip, Oct 1 to 2hotel-lumen-folio.pdf
2026-10-02Union Station Café46.80USD3.98MealsHarbor & Co.Portland trip, Oct 1 to 2; client lunchIMG_6033.HEIC
Method A, tagged rows: what the Slipsheet export holds. Three receipts, three rows, one shared client_tag and note. Invented example data.

Filter by client_tag or notes in any spreadsheet and the trip shows up as one group, with every date, tax amount and file name intact.

Method B: sum them after export

When you need a single line, build it yourself after export. In Google Sheets or Excel, with the export in columns A to I:

client_tagtripreceiptstotaltax
Harbor & Co.Portland trip, Oct 1 to 23299.3022.17
Method B, after export: a summary line you build yourself in Google Sheets or Excel from the rows above. Slipsheet does not create this row.

The trailing asterisk matches any note that starts with "Portland trip", so the lunch row with its extra words still counts. On Pro, receipts sync to Google Sheets, so you can keep this summary on a tab in that same sheet.

What Slipsheet does, and what it doesn't

Slipsheet reads each receipt, gives you a row to check, and exports one CSV named slipsheet-YYYYMMDD.csv. Every export has the same nine columns in order: date, merchant, total_amount, currency, tax_amount, category, client_tag, notes, file_name. The column walkthrough explains each one, and this guide covers opening the file in Excel without garbled accents.

It doesn't combine receipts into one row, and it has no direct QuickBooks or Xero connection; you bring the CSV in through their import. Google Sheets sync is on Pro. Excel and OneDrive are coming soon.

Starter is $5/mo for 250 receipts. Pro is $12/mo for 1,500 receipts plus Google Sheets sync. Yearly, they're $50 and $120. Start with a 14-day free trial, no card needed. Try Slipsheet.

FAQ

Can Slipsheet merge several receipts into one expense?

No. Slipsheet keeps one row per receipt, and the CSV export has one row per receipt too. To treat a trip as one expense, give its receipts the same client_tag and notes in review, then add them up in your spreadsheet after export.

How do I combine receipts from one trip in Google Sheets or Excel?

Export the CSV, then use SUMIFS on total_amount (column C), filtered by client_tag (column G) and notes (column H). For example: =SUMIFS(C:C,G:G,"Harbor & Co.",H:H,"Portland trip*"). Point the same formula at tax_amount (column E) for the tax.

Why keep one row per receipt instead of one combined row?

Each row keeps its own date, tax and file_name, so any amount traces back to its slip when a client or accountant asks. The trip total is a formula on top of those rows, not a replacement for them.

Can I send the result to QuickBooks or Xero?

Slipsheet has no direct QuickBooks or Xero connection. You can bring the CSV in through their own import tools and map the columns there.

Ready to stop typing receipts?

Open your ledger.

14-day trial. No card. Cancel anytime. Your receipts write themselves while you do literally anything else.