A live P&L in Google Sheets
You don't need accounting software to know how the month is going. This Zap appends a row to your Google Sheet every time a Locally123 invoice is paid — date, invoice number, customer, total, and amount collected — so your profit-and-loss log keeps itself.
1
Invoice paid
A customer pays a Locally123 invoice (card, Bit, or marked paid).
2
Zapier catches it
The Invoice Paid trigger fires with the amounts and customer.
3
Sheets logs a row
A new line appends to your sheet — a running record you can chart.
Why it works
- See revenue by day, week, or job type without any manual entry.
- Share the sheet with a bookkeeper or accountant — it's always current.
- Build pivot tables and charts on top: your numbers, your way.
- Only paid invoices are logged, so the total is money actually collected.
Prefer Excel or Airtable? Swap the action app — the Locally123 trigger is identical.