Double-Entry Accounting - Based on Logic
In 1983 the author started developing the double-entry tables using only plus and minus. In the framework presented here, the four classes of accounts are:
- Financial accounts,
- Tangible (or real) asset accounts,
- Profit accounts (income and expenses),
- Private/non-company accounts (deposits and withdrawals).
Some combine profit accounts and private/non-company deposit and withdrawal accounts into equity accounts. This gives them three classes of account. Others, like the standard U.S. GAAP financial statement classification, categorise revenue (income) and expenses separately. This results in five groups. You may see systems with ten groups. However, if you delve deeper, you will always end up with four classes.
Before digitalisation, calculations were performed using mental arithmetic. To make it manageable, traditional bookkeeping used a convention in which each number column contained only one sign, more precisely the positive sign. This convention led to the debit-and-credit entry system.
Today, calculations are performed digitally. A plus or minus sign can be assigned to each entry, and both signs can appear in the same number column.
This facilitates teaching:
- understand accounting without learning debit/credit,
- teach double‑entry bookkeeping in two hours,
- derive profit,
- understand deposits and withdrawals,
- analyse equity, even if it is negative.
In that direction you can find voices around the world: See page Home / Why is this website interesting for you?
For more details download my article Finally digital – Double-entry. pdf
The Double-entry Table
The Double-entry Table shown here is perhaps the simplest and most transparent representation of double-entry bookkeeping ever created. In my judgement, the mentioned four classes of accounts are necessary for a complete entrepreneurial interpretation of double-entry bookkeeping.
Yet, some columns have been duplicated in the double-entry table shown, such as the current account and the cash desk, in order to provide a better overview. It should be clear that "private" accounts have to be divided into deposits and withdrawals.
First, a shortened double-entry table is presented as to get the principle.
Here is an empty double-entry table with 20 number columns.
Download this Excel-file called i Double-entry Table Digital Logic.xlsx
Adapt it to your language and sector – and start testing !
The table is designed to be printed in A3 format or a similar size.
This table contains — or requires :
- the four account classes,
- plus/minus signs for each entry,
- duplication rules,
- and — most importantly — checksums.
The checksums are the heart of the system
There are three kinds of checksum (Quersumme in German):
1. The checksums on both sides of the table in the third-last lines indicate the equity change.
The two must be exactly equal after every doubled entry!
2. The checksums of the financial accounts plus tangible assets indicate the equity,
once in the opening balance and once in the closing balance.
3. The final line of the profit accounts shows the year's profit.
However, before the entries for assets and special items at the end of the year are finalised, the gross cash surplus is shown.
The following examples reflect this kind of checksums. The lines show a selection of entries from a farm. However, as mentioned previously, the double-entry table is universal.
Duplication rules — simple and logical
- Duplication
within financial and tangible asset accounts, or
within profit and private accounts :
If money leaves one account and becomes an asset in another, e.g., buying a machine.
-> money gone → minus
-> machine there → plus
The signs reverse.
- Duplication
across the central vertical line between
financial/assets accounts and profit/private accounts :
If money is earned, e.g., selling a product.
-> money there → plus
-> product sold → plus
The signs remain the same.
The same when money is spent for the company, e.g. for material.
-> money gone → minus
-> material used → minus
The signs remain the same.
Two other examples in the table above:
a) Look at the second line after 'Gross cash surplus'. It demonstrates how double-entry bookkeeping works when a company provides meals for an employee or apprentice. A plus sign appears next to 'withdrawals' and a minus sign appears next to 'wages'. Equity remains untouched, but profit decreases.
b) There are three lines for the different double entries of monthly milk sales.
-> Start of year: once (+) current account, contra-entry (-) receivable account.
-> Normal entry: once (+) current account, contra-entry (+) livestock account.
-> End of year: once (+) receivable account, contra-entry (+) livestock account.
This makes it clear to which booking year the entries belong.
This system provides a complete logical framework for digital double‑entry bookkeeping theory:
- a theoretical foundation,
- a didactic tool,
- a bridge between traditional accounting theory and modern digital accounting theory.
The double‑entry table enables students to grasp the principles of double-entry accounting in about two hours :
-> One hour is spent on the four classes of accounts and the checksums.
-> The other hour is spent on double-entry examples, such as the ones above.
The double‑entry table explains also what accounting programmes have to do internally.
Modern coding
In practice, today accountants’ work is coding. That is assigning entries with numbers.
With a code system - for example:
4‑digit codes → thousands of “columns”.
This allows:
detailed in‑year “journal of individual entries” and
automatic duplication
Bill scanning is now in use. This partly replaces manual coding.
The bridge to Cash flow 1, 2 and 3
As already mentioned on the first page of this website: The four classes of accounts form the basis of accounting. These four classes lead directly to entrepreneurial analysis. They form the basis of cash flow 1–3 and the benchmarks of cash flow 3.
- Profit accounts → Gross Cash Surplus → Cash flow 1
- Private accounts → Deposits / withdrawals → Cash flow 2
- Financial accounts → Repayments of debts → Cash flow 3
- Asset accounts → Depreciation benchmarks