Why Your Back Office Needs Double-Entry Bookkeeping

Most small teams start with a spreadsheet: one row per payment, a column for income, a column for expense. It works right up to the first hard question. Then someone spends an afternoon rebuilding a figure that should have been one click away.

This post explains what double-entry bookkeeping adds, walks through a small worked example, and shows why it only pays off when it happens automatically.

The questions a list cannot answer

• A customer paid 12,000 TL against three invoices. Which one is still open?
• You collected a government fee on behalf of a customer. Is that revenue?
• A supplier invoice arrived in euro. What is the VAT you can deduct this month?
• Your accountant says the balance sheet is off by 4,300 TL. Where?

Each of these needs two facts per transaction, not one: what changed, and against what. That is what double-entry gives you.

What double-entry actually means

Every transaction is recorded as a journal entry with at least two lines. One or more accounts are debited, one or more are credited, and the two sides are always equal. In the Turkish uniform chart of accounts, a sales invoice touches 120 Receivables, 600 Domestic Sales and 391 VAT Payable. A collection touches 102 Banks and 120 Receivables. Nothing moves on its own.

That rule sounds like bureaucracy. In practice it is a built-in check: if an entry does not balance, it cannot be saved, and if a total is wrong, you can trace it to the entry that caused it.

A worked example

Take a small consulting firm in one month (example figures, VAT at 20%).

1. Invoice a customer for 10,000 TL plus VAT.

Account	Debit	Credit
120 Receivables	12,000 TL
600 Domestic Sales		10,000 TL
391 VAT Payable		2,000 TL

2. The customer pays 12,000 TL by bank transfer.

Account	Debit	Credit
102 Banks	12,000 TL
120 Receivables		12,000 TL

3. A supplier invoice for software: 5,000 TL plus VAT, paid by bank.

Account	Debit	Credit
770 General Administrative Expenses	5,000 TL
191 Deductible VAT	1,000 TL
102 Banks		6,000 TL

4. You collect a 3,000 TL government fee on the customer’s behalf, then pay it on.

Account	Debit	Credit
102 Banks	3,000 TL
336 Other Payables		3,000 TL
336 Other Payables	3,000 TL
102 Banks		3,000 TL

At month end, without any extra work:

• The customer’s balance in 120 is zero, because the invoice and the payment offset each other.
• Revenue is 10,000 TL. The 3,000 TL fee never touched a revenue account.
• VAT to report is 2,000 TL collected less 1,000 TL deductible, so 1,000 TL, read straight from 391 and 191.
• The bank moved by +12,000 − 6,000 + 3,000 − 3,000 = 6,000 TL, which you can match against the statement.

In a spreadsheet, each of those four answers is a separate calculation. In a double-entry ledger, they are account balances.

What balancing buys you

When every invoice, payment and expense writes a journal entry where debits equal credits:

1. Customer balances become derived, not typed. Nobody maintains a “still owes” column by hand.
2. Transit money stays out of your profit. A government fee you collect and pay on sits in a liability account; it never inflates revenue.
3. VAT reports are a query, not a reconstruction. Collected VAT and deductible VAT are separate accounts, so the monthly figure is already there.
4. Errors localise. If a total is wrong, the unbalanced entry tells you which record to look at.
5. The trial balance is always ready. Your accountant gets a balanced picture instead of a list to reinterpret.

The part people skip

Double-entry is only useful if it happens automatically. If someone has to remember to post a journal entry after issuing an invoice, it will be skipped in the week you are busiest; and the ledger you are supposed to trust becomes the thing you have to check.

So the rule we follow in the accounting module: no financial action without its entry. Issue an invoice, the entry is written. Record a payment, the entry is written. Import a bank statement and match a line, the entry is written. Delete a draft, nothing was written in the first place.

That is the difference between having accounting records and having a spreadsheet that resembles them.

Where it shows up at month end

The payoff is most visible when you close a month. Bank reconciliation compares account 102 with the statement. Customer balances come from 120, supplier balances from 320. The VAT report comes from 391 and 191. The month-end close guide walks through these checks in order; with a balanced ledger most of them are a comparison, not a rebuild.

Moving off the spreadsheet

If your records live in tables today, you do not need to re-enter years of history. Start from your accountant’s closing trial balance, enter opening balances and open invoices, and run the new ledger in parallel for one month. The guide to moving off spreadsheets lays out a four-week plan: clean-up, master records, opening balances and a parallel run.

Common mistakes

• Posting totals instead of documents. One monthly “sales” entry hides which invoice is open. Post each invoice and each payment.
• Booking pass-through money as revenue. Fees collected on a customer’s behalf belong in a liability account until you pay them on.
• Netting VAT by hand. Keep collected and deductible VAT in separate accounts; the difference is the report.
• Fixing balances with manual adjustments. If a customer balance looks wrong, find the entry that caused it rather than posting a correction on top.

The short version

A list tells you what happened. A double-entry ledger tells you what happened and what it changed, and it refuses to accept a record that does not add up. When entries are written automatically from invoices, payments and expenses, customer balances, VAT and the trial balance stop being monthly projects and become things you simply look up.