An Electronic Notebook in Your Pocket: How to Build Simple Personal Accounting with Google Sheets

When you ask anyone about the secret to financial balance, they often reply: “It’s just about budgeting, and you must track every penny. But the real question is: how do you do the tracking?”

The answer is clear: by using a simple and nearly free tool, Google Sheets. If you like digital spreadsheets and enjoy watching your numbers change before your eyes, this article shows you how to create a personal accounting book that fits your lifestyle.

Why Google Sheets?

Google Sheets combines ease of use with the power of advanced tools. All you need is a Gmail account, and you can access the file from any device, whether a laptop or a phone. Plus, sharing the file with a partner or accountant is just a click away.

Step One: Setting Up the Basic Template

Start by creating a new spreadsheet and name it “Personal Accounting”. Divide the sheet into three main sections:

• Date – a cell to record the day and month.
• Category – classification of expense or income (e.g., food, transport, salary, investment).
• Amount – the value of the transaction, indicating whether it is income (+) or expense (-).

A simple example on the first row:

2026-07-01 | Salary | +15000

Then record each transaction in a new row. You don’t need complex labels—just a word or short phrase describing the activity is enough.

Step Two: Adding an “Accumulated Balance” Column

Here’s where the magic begins. In the fourth column, we write a formula that calculates your balance after each transaction. Assume column D is “Balance”, and cell D2 contains the opening balance (e.g., 15000). In D3, enter the formula:

=D2+C3

Where C3 is the amount for the third row. Drag the formula down to apply it to subsequent rows, and the balance will update automatically after each entry.

Step Three: Smart Categorisation of Categories

To get quick reports, create a list of categories on a separate sheet (e.g., “Categories”), then use Data Validation to display a dropdown list in the Category column. This way, you avoid typing different names for the same type and ensure accurate data aggregation.

Step Four: Extracting Monthly Reports

Now that you’ve collected the data, it’s time to analyse. You can create a new sheet called “Monthly Summary” and use the PIVOT TABLE function to summarise expenses by category and month. The result is a table showing how much you spent on food, transport, leisure, etc.

Example Pivot setup:

• Rows: Category
• Columns: Month
• Values: Sum of Amount (showing negative values only for expenses)

This way, you can see which category is draining your budget most and decide where to cut back.

Step Five: Automatically Linking Bank Accounts (Optional)

If you prefer importing data instead of entering it manually, try Google Finance or an add-on like “Sheetgo” to pull CSV files from your bank. Once the file is loaded, map the columns to the corresponding ones in your main sheet, and the transactions will appear automatically.

Practical Tips to Reduce Errors

1. Use Distinct Colours: Highlight the Amount cell, colour negative values red and positive values green. This simple touch lets you spot discrepancies instantly.

2. Fix the Entry Date: If you forget to record a transaction on the day it happened, use the =TODAY() function to add the date automatically.

3. Keep a Weekly Backup: Although Google Sheets saves every change, backing up to Google Drive or an Excel file adds an extra layer of security.

Practical Example: A Week in Mohammed’s Life

Mohammed works freelance, doing graphic design projects, and has irregular income. During one week, he recorded these transactions in his Google Sheets:

• Monday: Received a commission of 3000 from a client (income).
• Tuesday: Bought an Adobe subscription (expense 120).
• Wednesday: Spent 500 on food outside the home.
• Thursday: Made a bank transfer to savings (expense 800).
• Friday: Sold an artwork for 2000 (income).

After entering the data, he generated a weekly summary showing his net profit was 2580 pounds, with the largest expense being savings—a positive sign that encourages him to plan a bigger savings goal.

How to Benefit from the Template Long-Term

The Google Sheets template is not just a daily log—it’s a database that grows with you. As you add years, you’ll get long-term statistics: average monthly spending, income growth trends, and even future forecasts using the FORECAST function. This turns your file into a realistic financial planning tool.

In short, personal accounting isn’t just numbers on paper—it’s a way to understand where your money goes and how to direct it toward your goals. Google Sheets gives you this understanding in a flexible and easy way, without needing expensive software or advanced programming skills. Start now, record your first transaction today, and you’ll see the difference quickly.