Income and Expenses: Notebook, Excel or Dashboard?

Choosing between a notebook, Excel and a dashboard for income and expense tracking is less about finding the best tool and more about finding the one that fits where your business is today. In a business where one person keeps the records and the entries are few, a notebook can be enough. When the records spread across several people, several tills or several currencies, Excel can bring order. If the answer to "what did I earn this month" has to be rebuilt by hand every time, a dashboard is worth considering. Whichever you choose, the tool only helps when the records are kept in one place.

This article is written from the point of view of someone who has worked in the operation of high-voltage substations for 11 years and has been building software for businesses for 5 years. What it takes to turn handwritten logs into a month-end Excel sheet is described in Paper Logs to Monthly Reports; here the same question is applied to money records. Two sentences we often hear from small businesses we talk to are also the starting point of this article: "there is only one person at the till" and "at the end of the month I do not know what I earned".

Why "what did I earn" goes unanswered at month end

In most small businesses, money records do not sit in one place. Income stays in the till or on the card terminal slip, expenses in the invoice folder, card payments in the banking app, a cash advance on a scrap of paper. Each record is correct where it is, but unless someone puts them side by side at month end, no total appears.

There are three common reasons the answer is late:

• Scattered records: the same month's money sits in several places; to add it up you have to open each one.
• Missing records: small cash expenses, purchases made on the road and business payments the owner makes out of their own pocket often go unrecorded. A total comes out, but it does not show the real picture.
• Mixed records: regular income and a one-off sale, business costs and household spending end up on the same lines. The month can look good or bad, but the reason cannot be read.

This article is not about how profit is calculated but about where the records behind that calculation are kept. The difference between turnover and profit, and the per-job calculation, are covered in Which of My Jobs Actually Makes Money? A shortfall in the end-of-day cash count is a separate topic; you can find it in Cash Drawer Doesn't Add Up at Night: What to Do?

Notebook: when it is enough, where it stalls

The notebook's strongest point is that it is right at hand. It needs no electricity, internet or password; it sits next to the till and writing in it needs no special skill. That is why many businesses keep their first records in a notebook, and that is not a wrong start.

When a notebook is enough

• One person keeps the records: when the person who writes is also the person who reads, handwriting and abbreviations cause no trouble.
• Few, repeating entries: if similar income and expense lines are written every day, the notebook can stay tidy.
• One till, one currency: if money comes in and goes out through one place, adding it up is easy.
• Limited reporting needs: if seeing the total once a month is enough and there is time to work it out, a notebook can do the job.

Where the notebook stalls

Writing in a notebook is easy; adding it up is not. Totalling every page at month end, sorting expenses into categories or comparing with last month is manual work every time. When a second person starts keeping the records too, handwriting, abbreviations and "did I write this down" uncertainty are added. Because the notebook is a single copy, losing it, getting it wet or leaving it at home can take part of the records with it.

The sign is this: if the month-end total keeps being postponed or is not worked out at all, the notebook is still collecting records but no longer answering the question.

Excel: what it can solve, where it becomes a burden

Excel can be a solution to the notebook's adding-up problem. Once income and expense lines are written in the right column, totals, category breakdowns and monthly comparisons can come out of formulas. The file can be copied, backed up and shared with your accountant. For most businesses, Excel is the natural next step after the notebook.

The setup in which Excel works well

• Fixed columns: date, description, category, amount and payment type. Every line is written in the same layout.
• Category from a drop-down list: the category is not typed by hand but chosen from a list, so "rent" and "Rent" do not show up as two separate items.
• One file, one owner: it is clear which copy is the master and who updates it.

The point where Excel becomes a burden

The problem usually comes not from Excel itself but from the routine around it. When several people open and update the file on their own computers, the question "which one is the latest" appears. When the person who built the formulas leaves, or a row is deleted by mistake, it becomes hard to see why the total changed. The person at the till cannot enter records from a phone, so they write them on paper at the end of the day and someone moves them into Excel in the evening; the notebook is back, with a transfer job added on top.

The signs described in When Excel Stops Working for Customer Tracking, which explains when Excel stops being enough for a customer list, largely apply to an income and expense sheet as well: several people, several copies and a summary rebuilt by hand every month.

Dashboard: what it changes, what it does not

A dashboard is a setup in which records are entered from a browser or a phone and the summary is calculated on its own. What makes the difference is not how the screen looks, but that the records sit in one place and the total is current every time it is opened.

What a dashboard changes

• The summary is ready: this month's income, expenses and net result can be seen without waiting for month end.
• Records stay in one place: the person at the till and the owner write to the same records; since there is only one copy, the question "which one is the latest" does not arise.
• Regular items are defined once: items that repeat every month, such as rent or a subscription, can be marked and recorded automatically each month.
• Category and period comparison: where the expenses go and how this month differs from previous months can be seen without building formulas.
• Access can be set per person: the person who enters records and the person who sees the report do not need the same permissions.

What a dashboard does not change

• Someone still enters the records: the dashboard does not write the receipt by itself. If the person at the till does not enter the record, the dashboard stays incomplete; the routine settles through habit, not through the tool.
• The decision stays with people: a dashboard can show that a cost has gone up; whether to cut that cost is decided by the person who knows the business.
• It does not replace accounting records: the dashboard is the business's own view. For how official records are kept, which documents are retained and filing matters, consult your accountant.
• It does not fix a mixed setup by itself: if categories are mixed and household and business spending are kept together, the dashboard only shows that mix on a tidier screen. First the split is made, then the tool is chosen.

The sections of this kind of dashboard are described on KILMAN's Business Management System page: income, expense, customer and product records in one structure; this month's income, expenses and net profit on the opening screen; one-off income kept apart from regular income, and foreign currency expenses entered in their own currency.

The most common switching mistake: keeping the same records in two places

When moving from a notebook to Excel, or from Excel to a dashboard, the most common choice is to say "let us keep both for a while". The intention is understandable: you do not want to let go of the old tool before you trust the new one. But when two records run in parallel, every item is written twice, and when the two totals do not match, finding out which is right becomes a separate job.

A simpler way is to give the switch a start date:

• Set a start date: for example the first day of a month. From that day on, new records go only into the new tool.
• Close the old records: the notebook or old file is closed with the total up to that day and put in the archive. It can be read but is not written in.
• Treat history as a separate decision: whether old records are moved into the new tool is a separate question. Starting with only the opening position is also a valid choice.
• Do not make the backup paper the main record: when there is no connection, writing on paper may be necessary; that paper is entered into the new tool at the first chance and set aside.

Why entering the same information side by side into two programs, or into a program and a notebook, is so common, and how it can be simplified, is explained in detail in Why Am I Entering the Same Thing Twice?

Which one suits you: a decision table

The table below matches your business's current situation with a suggestion. If more than one row fits you, the row further down the table usually corresponds to a broader need.

The table gives no threshold; there is no fixed number that says after how many people or how many items a dashboard becomes necessary. The measure is whether the records answer your question in time.

What to prepare before switching: a checklist

Whichever tool you move to, answering these questions before the switch can make the work easier. Most of the list needs no software; sitting down with a sheet of paper and someone who knows the business can be enough.

• Income items: where does money come in from? Sales, services, subscriptions and one-off jobs are written separately.
• Expense categories: a short list that fits your business, such as rent, staff, materials, bills and transport. The simpler the list stays, the tidier the records can stay.
• Where money comes in and goes out: till, card terminal, bank account, card. Each appears in the records as a separate payment type.
• Who enters the records: the person at the till, the owner, or both? Who will be able to see what?
• How often: at every transaction or at the end of the day? A batch entry at the end of the day is also a routine, as long as it is done every day.
• Household and business split: how will the business payments the owner makes out of their own pocket, and the money they take from the business, be recorded?
• Start date and opening position: on which day do the new records begin, and what is in the till and the account on that day?
• Sharing with your accountant: discuss with your accountant in what format and when the records will be passed on.

Once this list is complete, the choice often becomes clear by itself: if the list is short and one person keeps the records, a notebook; if categories and comparison come first, Excel; if there are several people and tills, a dashboard.

Frequently Asked Questions