Kerabat Open Kerabat

How to track household expenses — and export them to Excel

Keep track of household spending in Kerabat as it happens, and export it to Excel whenever you want a spreadsheet. The file holds what you’ve recorded: the month’s totals by category and group, how much each person paid, every expense, and your bills.

Start your list

Runs in your browser — no app store needed

From Kerabat to Excel

Add each expense or bill payment in Kerabat when it happens. When you want a spreadsheet, open “Totals” in “Spending” and tap “Export to Excel” at the bottom: pick the month or this year, and Kerabat builds the file from what you’ve recorded.

Here’s what it looks like with sample data: September, exported on October 3.

See a sample (.xlsx)

Opens in Excel, Google Sheets, or Numbers.

The Totals sheet in Excel: Our home · September 2026, spent $4,446.39; by category, from Rent & mortgage at $1,950.00 down; by group; and Paid by — Alex $3,256.94, Anna $1,189.45. Below it, the Totals, Spending, and Bills tabs.
The Totals sheet
The Bills sheet in Excel, status as of October 3: soccer overdue since October 1 in red, phones due October 20 by autopay in green, rent due October 10 in amber; under Passes and subscriptions, the gym membership paid through October 24; under Packs, swimming with 5 of 8 left; under One-time, summer camp due October 12; what was paid in September; and a total of $2,370.00.
The Bills sheet

What’s in the file

  • Totals — what you spent in the period; by category for a month, or month by month for a year; by group, with each one’s share; and how much each person paid.
  • Spending — one row per expense or payment: date, amount, group, category, title, how it was recorded, and who paid. The header row has filters.
  • Bills — one row per bill: how it’s paid, the amount, the due date, its status on the day you export, and what you paid for it in the period.

Amounts are numbers and dates are dates, so you can sort, filter, or build a pivot table.

Monthly expenses by category

Kerabat starts you off with the categories a household actually spends on, grouped so a month reads at a glance:

  • Groceries: Supermarket, Market, Grocery delivery
  • Eating out: Cafés & restaurants, Coffee & snacks, Takeout
  • Home: Rent & mortgage, Utilities, Internet & phone, Home supplies, Repairs & furniture
  • Kids: Activities & classes, School, Daycare, Toys & books
  • Health: Pharmacy, Doctors & labs, Health insurance
  • Sports: Coaching, Memberships, Gear
  • Transportation: Gas, Public transit, Taxis & rideshare, Car maintenance & insurance, Parking
  • Clothes & grooming: Clothes & shoes, Toiletries & cosmetics, Haircuts
  • Leisure: Entertainment, Trips, Hobbies
  • Subscriptions: Streaming & apps, Cloud & software
  • Gifts & celebrations and Other

Spending on your phone, with receipts

A spreadsheet waits until someone sits down at a computer, and the receipts pile up in the meantime.

In Kerabat

Whoever pays adds the expense on their phone, and everyone you share the list with sees it right away. Photograph a receipt, and Kerabat sorts every line into these same categories. “Totals” shows the month category by category, and the Excel export takes it from there.

How family spending works in Kerabat

The spending feed: October, $396.17 spent, with September under it; a Whole Foods receipt waiting for review; category chips; and today’s spending — the swimming pack, Anna; Trader Joe’s under Groceries, Alex — then yesterday’s.

Four habits that make it stick

  1. Add each purchase the day you make it. A receipt you put off for a week turns into a guess.
  2. Add each bill once, with its due date, and mark it paid when you pay it — the payment goes into that month’s spending.
  3. Once a month, look at the groups first — that’s where the money went. The categories inside them are there when you want the details.
  4. Want it in a spreadsheet? Export the month or this year to Excel.

Questions about your family budget spreadsheet

Does it work in Google Sheets?

Yes. The file opens in Excel, Google Sheets, or Numbers. In Google Sheets, choose File → Import → Upload and pick the file.

How do couples track shared expenses?

Each of you adds what you pay for, and every expense shows who paid. The Totals sheet shows how much each of you paid and what share of the month’s spending that is — a starting point for settling up.

Can I export a whole year?

Yes. The export offers the month you’re looking at and this year, and in January and February, last year too.

Which currency does it use?

Your household’s. Every total is in that currency, and the line under the title on the Totals sheet names it.

Start with today’s spending

Add today’s shopping or photograph a receipt, and invite someone at home whenever you like.

Start your list

More about Kerabat on the home page