Excel + AI Assistant: Build a Family Expense Table in an Evening and Plug Budget Leaks

Why a spreadsheet isn't boring — it's profitable

A family budget often feels like a diet: everyone knows they should, but nobody wants to. That's a mistake. According to surveys (e.g., from NAFI), almost half of Russian families don't track their finances and only find out about a money shortage when it runs out. Meanwhile, money conflicts are one of the main causes of arguments in couples.

The good news: you don't need to be a financier. It's enough to set up a simple spreadsheet once and connect an AI twin to take over the routine. In this article, I'll show you how to get your money in order in an evening and forget about arguments over "who spent how much."

Step 1. Gather the initial data (human + AI)

What the human does: sits down with their spouse and writes out all sources of income: salaries, pensions, side jobs, interest on deposits. Then lists regular expenses: rent, mortgage, utilities, loans, kindergarten, clubs.

What the AI twin does: gets access to your email and documents (with your permission) and finds all receipts, contracts, and statements for the past months. It categorizes them and notes what data is missing — for example, no receipt for internet is visible.

Tip: don't try to remember everything at once. The AI twin will pull amounts from bank and management company emails itself.

Step 2. Create a simple spreadsheet

Create a file in Google Sheets or Excel with three sheets:

1. Income — date, source, amount.
2. Expenses — date, category, description, amount.
3. Budget — monthly plan by category and actual.

Here's an example structure for the "Expenses" sheet:

What the AI twin does: it can fill in this table itself. You give it a task: "Every Monday, collect all spending from bank emails and add it to the table." The AI will parse statements, extract amounts and categories, and then enter them into the file. You just need to check.

Step 3. Connect the AI twin to data sources

For the AI twin to work, it needs access to your services. This is safe: you grant access yourself via OAuth (e.g., to Gmail or Google Calendar) and can revoke permission at any time.

What the human does: in the AI twin settings (on asibiont.com), selects services: email, bank (if integration is available), marketplaces. Confirms access.

What the AI twin does: checks the connection, starts scanning incoming emails and notifications. It looks for receipts, invoices, subscriptions, and automatically creates entries in the table.

Step 4. Set up automatic total calculation

In the spreadsheet, create a "Totals" sheet with formulas. For example, to calculate the sum of expenses for the month in the "Groceries" category, use:

=SUMIF(Expenses!B:B; "Groceries"; Expenses!D:D)

What the human does: enters the formulas once and checks that they work.

What the AI twin does: once a month (or on your schedule), it updates these totals itself, generates a report as a PDF, and sends it to your email. It can also compare plan vs. actual and highlight categories where you overspent.

Step 5. Find money leaks

Usually a family spends 10–15% more than planned due to small unnoticed purchases and forgotten subscriptions. The AI twin can find them.

What the human does: asks the AI twin: "Analyze expenses for the last three months and show where most money goes and which subscriptions are active."

What the AI twin does: scans the table and email, finds regular charges (e.g., for streaming or fitness), sums them up, and provides a list. It can also suggest canceling unnecessary subscriptions — but you make the decision.

Step 6. Set up payment reminders

To avoid paying penalties and fines, it's important to make mandatory payments on time.

What the human does: tells the AI twin a list of regular payments with dates (e.g., mortgage on the 5th, utilities on the 10th, internet on the 15th).

What the AI twin does: creates reminders in the calendar and sends notifications a day before the payment. It can also check if a bill has arrived and compare the amount with the usual one.

Step 7. Discuss the budget without arguments

The most important step. Money is an emotional topic, but when you have a transparent table, there's nothing to argue about.

What the human does: once a month, sits down with their spouse and reviews the report prepared by the AI twin. Together decide what to adjust.

What the AI twin does: sends both spouses a brief summary in advance: how much earned, how much spent, where overspending occurred, which goals were achieved. This removes mutual accusations — the numbers are impartial.

Frequently asked questions

— Can I manage a family budget without tables, only with AI?
Yes, the AI twin can store all data and provide reports on request. But a table gives clarity and the ability to quickly check any figure. It's better to combine both.

— Is it safe to give the AI twin access to bank accounts?
The AI twin does not store passwords and cannot transfer money without your confirmation. Access is via secure protocols (OAuth), and you can revoke permission at any time.

— What will the AI twin do if it sees a suspicious transaction?
It will flag it in the report and send a notification. For example, if the amount is noticeably higher than usual or the category is not planned.

— Do I need to enter every purchase myself?
No. The AI twin automatically collects spending from bank emails, receipts in email, and marketplace notifications. You just check.

— Can the AI twin help if we don't have a joint account?
Yes. It can keep a budget for each family member separately and then sum them up. The main thing is to give it access to both spouses' data (with their consent).

Checklist: what to do right now

1. Create a spreadsheet with three sheets: "Income," "Expenses," "Budget." (The AI twin can create it automatically upon your request.)
2. Connect the AI twin to email and calendar on asibiont.com. (The AI twin will set up data collection itself.)
3. Enter regular income and expenses — manually or ask the AI twin to find them in emails. (The AI twin will do it for you.)
4. Set up formulas to calculate totals by category. (The AI twin can create formulas and check them.)
5. Give the AI twin a task: "Every Monday, collect the week's spending and add it to the table."
6. Ask the AI twin to find active subscriptions and forgotten payments.
7. Set reminders for regular payments. (The AI twin will create them in the calendar.)
8. Agree with your spouse on a monthly meeting to review the report — the AI twin will send it in advance.

Start small: connect the AI twin to your email and ask it to collect all receipts for the past month. Within an hour, you'll have a clear picture of where your money goes. Then just delegate the routine to the AI twin on asibiont.com.