カテゴリ 古民家暮らしモカとの記録セキュリティの記録副業の記録

The record with MokaNovember 13, 2026

Tables Are Ledgers I Keep With Moka — How I Set Up Google Sheets and Build My Registers

Tables Are Ledgers I Keep With Moka — How I Set Up Google Sheets and Build My Registers

The result first: my work runs on tables. One line per item, the status written short, and the details kept elsewhere — that simple rule is enough to manage dozens of articles without losing track of anything. The table is the index, Google Drive holds the full text, and Moka does the writing in, the counting, and the sorting. I just look at the table and say, “Yes, that’s right.”

I am Kurashiki Bouzu (kurashiki-bouzu), born in 1971, a former funeral professional. Now I work on this blog and on making products together with Moka, my AI butler on Muse.

This time, the topic is tables.

When many people hear the word “spreadsheet,” they tense up a little. I did, too. But inside, it is just a big ledger on grid paper. A paper register or a tally sheet, placed as it is inside the screen. Thought of that way, it suddenly feels familiar.

A table is a big ledger on grid paper

A ledger has vertical and horizontal lines. Date, name, amount, notes. You write one item per line, so you can look back later. When I was working in funerals, the customer register had exactly this shape.

Google Sheets* is that ledger, living on the other side of the internet. Write letters or numbers in a box (a cell), and they stay there. You can see the same ledger on your phone and on your computer.

There are only four differences from paper:

That “the same thing can be seen from any device, and shared with someone else” is the heart of how I use it.

The heart of this article — the table is the index, Google Drive holds the text

My rule is this.

The index goes in the table (the spreadsheet), and the full text goes in Google Drive.

What goes in the table is only what fits in one line. A title, a status, a place, a date. Write a short summary, so it is clear that “the details are over there.” Long texts go into documents on the Google Drive side.

The reason is the effort of reading things back. If you read everything every time, it costs time and money. If you pick only the lines you need from the table index, the effort of searching becomes much smaller. Most list-like things run well with this division.

Examples from my own registers

Let me give real examples. My work runs on these table registers.

None of these is a special mechanism. Just the rule “one item per line, status written short.” With only that, even when there are dozens of articles, nothing gets lost.

What I do, and what Moka does

What I do

What Moka does

My role is to look at the table and say “yes.” The writing in and the tallying are Moka’s work. In the days of paper ledgers, I sometimes spent half a day just hunting for a counting mistake. Now, that half day is gone.

How to start — just make a new table and give it a name

You do not need any new tool to start.

  1. Open Sheets with your Google account (the address you made in the first episode of “Google Apps Basics” can be used as it is)
  2. Choose “Create a new table.” At first, a blank sheet of grid paper appears
  3. Give the table a name. A name you will understand later, like ”○○ Ledger,” is best
  4. In the first line, write the names of the items (date, title, status, and so on)
  5. From the second line on, write one item per line

It costs nothing. Within the free allowance, a ledger like this can be used for a long time. What gets heavy is photos and videos; a table of only letters is very small.

What to watch out for — the range of sharing, and one master copy

Important things about the house are also written in a ledger. Please be careful about just two things.

The shape of the table became a product, too

In fact, my relationship with tables is long, and it started long before Moka arrived. From the time I was working in funerals, I was using Google Sheets to manage customers. I wrote a name, what I had promised, and my impression of that person, one item per line, so I could look back later. In those days, I wrote everything alone and counted everything alone.

What I learned after using it for many years is that the rule “one item per line” matters far more than difficult functions. A tool can be used for a long time. Whether it continues depends on the rule.

This register shape — “one item per line, status written short” — became, just as it is, the model for a product I sell on note.

It is a tool for remembering promises made to customers and what those people were like. The product is called the “Customer Management Table Prompt.” From the time I was doing sales work, I gathered into it the way of asking Moka, including even the “impression of that person” that I used to write in my organizer. A ledger is not only for a company’s efficiency. It is a tool for not forgetting.

Finally — next, how to read the numbers

Once you can keep a table, the next thing you want is the number for “how much was it read?”

Next time, I will write about setting up Google Analytics*. It is a tool that receives, in numbers, how the blog is being read, and the place where those numbers are written out is the table from this article. Because the table comes first, you never wonder where to put the numbers.

First, just one table. Give it a name, write one line. With only that, the ledger starts to move.

*Spreadsheet is the name of the tool for making tables. In this article, I call it a “table.” *Analytics is the name of Google’s tool that tells you, in numbers, how much a homepage was viewed.


Related reading

Record of this article
  • November 18, 2026 ― English draft created (results-first rewrite of the Japanese article, ledger No. 78). Not published; publication is a separate step.(6,331 characters)

#Google #Google Sheets #Spreadsheets #Ledger #English

← Back to the article list / ← Back to the English top page