Softwiro
Free Excel template

Accounting rules and equations summary sheet: double entry, statements and financial ratios

A free Excel sheet that puts the rules and equations of financial accounting in one file: the accounting equation, debit and credit rules for each account type, the journal, trial balance, financial statements and closing, accruals and adjustments, straight-line and declining-balance depreciation, inventory and cost of goods sold under FIFO and weighted average, break-even and margins, and financial ratios. Each of the 75 rules has its formula and an example using the sample numbers. The file also includes 19 model journal entries, calculators, a depreciation table, a small journal that posts to a trial balance and checks that it balances, a 40-question self-test and a review tracker. This is a general study summary; standards and taxes follow local law.

Excel file (.xlsx) · 64 KB · 12 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Try the sheet here, on the example

The sheet is open below with sample numbers. Change any white cell and watch the results update, or press the blank-copy button to type your own data from scratch. Nothing you type leaves your browser.

Example from the sheet

Example from the “حاسبات” tab (Arabic), with the numbers and formulas that are in the file.
1) المعادلة المحاسبية الموسعة
الخصوم28900
رأس المال أول الفترة50000
الإيرادات17000
المصروفات12900
المسحوبات1000
صافي الربح = الإيرادات − المصروفات4,100.00
حقوق الملكية آخر الفترة53,100.00
الأصول = الخصوم + حقوق الملكية82,000.00

Example from the “حاسبات” tab (Arabic), with the numbers and formulas that are in the file.

What is inside

  • المرجع (Reference): 75 rules in 8 sections: the formula, an example from the sample numbers, and a note or common mistake, with a filter on the «القسم» (Section) column.
  • بحث عن قاعدة (Rule lookup): Pick a rule name from the list and its formula, example, note and section appear immediately.
  • أمثلة القيود (Journal entry examples): 19 common transactions with their debit and credit accounts and a sample amount: cash and credit sales, purchases, paying a supplier, depreciation, accrued and prepaid expenses, unearned and accrued revenue, owner's drawings and bad debts.
  • حاسبات (Calculators): Five calculators: the expanded accounting equation, cost of goods sold and margins, cash basis versus accrual basis, break-even with target profit and margin of safety, and 11 financial ratios from your own statement figures.
  • الإهلاك والمخزون (Depreciation and inventory): A five-year depreciation table with straight-line and declining-balance side by side, and a FIFO versus weighted-average comparison over five purchase batches: cost of goods sold, ending inventory and gross profit.
  • اليومية (Journal): Record entries by choosing the account from a list. The sheet checks that each entry balances and that the account is defined, and shows total debits, total credits and the balance status.
  • ميزان المراجعة (Trial balance): The chart of accounts with account types, debit and credit totals per account pulled from the journal, debit and credit balances, a warning for any balance opposite to its normal side, and the trial balance status.
  • اختبار ذاتي (Self-test): 40 questions in four branches, answered with a number (no unit) or a choice from a list. A tick or cross appears, your score shows at the top, and the answer key sits in hidden columns.
  • المتابعة (Review tracker): Enter the topic, review date and your score. The sheet calculates the next review date from the score and highlights topics that are due, with a chart of your scores.
  • الملخص (Summary): Your score, the number of rules per section, your score per branch, and an income statement and balance sheet drawn from your journal, with six charts.

The file opens on a start tab (“ابدأ هنا”, Start here) that explains how to use it.

What makes it different

The sheet does more than state each rule. Every rule has its formula and an example with real numbers from one consistent sample, so the equation, entries, trial balance and statements all agree. You can then record your own entries and have the sheet check that they balance, try the calculators and test yourself. You see how a double entry becomes a trial balance and then an income statement and balance sheet, instead of memorizing rules.

How to use it

  1. Open «المرجع» (Reference) and go through the rules by section. Each rule has its formula, an example from the sample numbers, and a note or common mistake. You can filter the table by the «القسم» (Section) column.
  2. In «بحث عن قاعدة» (Rule lookup) pick a rule name from the list and its formula, example and note appear at once. In «أمثلة القيود» (Journal entry examples) you will find 19 transactions with their debit and credit accounts.
  3. Try «حاسبات» (Calculators): the accounting equation, cost of goods sold and margins, cash versus accrual basis, break-even, and financial ratios from your own statement figures. «الإهلاك والمخزون» (Depreciation and inventory) has a five-year depreciation table and a FIFO versus weighted-average comparison.
  4. Record your entries in «اليومية» (Journal) by choosing accounts from the list. The sheet posts them to «ميزان المراجعة» (Trial balance) and warns you about an unbalanced entry, an undefined account or a balance opposite to its normal side.
  5. Take the «اختبار ذاتي» (Self-test) and record your score in «المتابعة» (Review tracker), then open «الملخص» (Summary) to see the income statement and balance sheet from your journal, with the charts.

Before you start:

  • A general study summary; standards and taxes follow local law. The treatment of some items (such as doubtful debts and inventory methods) differs between standards and jurisdictions, so check what applies in your country.
  • The figures in «المرجع» (Reference) and «أمثلة القيود» (Journal entry examples) are illustrative examples from the sample, not standards. Reference ratios vary by industry, so compare your business with itself over time and with businesses in the same line of work.
  • «اليومية» (Journal) holds 80 lines (15 entries in the sample), «ميزان المراجعة» (Trial balance) holds 20 accounts (16 in the sample), the review tracker holds 20 topics, and the self-test holds 45 questions (40 in the sample).
  • A balanced trial balance does not prove the entries are correct: it will not reveal an entry left out entirely or a correct amount posted to the wrong account. Enter the type of each account in «ميزان المراجعة» (asset, liability, equity, and so on) so the sheet can build the statements.
  • In the self-test, a numeric answer is accepted within a tolerance of 0.01, so type the number as it is (such as 1.33 or 15) with no unit and no % sign. Multiple-choice questions are answered from the drop-down list.
  • The depreciation table shows five years. The declining-balance rate is entered by the user (multiplier = 2 ÷ useful life), and declining-balance depreciation never takes book value below salvage value.

Excel file (.xlsx) · 64 KB · 12 tabs · works in Excel and Google Sheets · no sign-up

The workbook is in Arabic (right-to-left, Arabic tab and column names). This page explains every tab in English.

The blank copy has the same formulas, charts and lists without the example data; categories and settings are ready.

Free cheat sheet for this field

Terms, abbreviations, tables and diagrams over several pages, in Arabic and English. Download it as a PDF or images, including a phone-size version.

Cheat sheet: accounting rules and equations (1/3)Cheat sheet: accounting rules and equations (2/3)Cheat sheet: accounting rules and equations (3/3)
0 downloads · 3 pages

Still running this on Excel?

This sheet depends on someone entering journal entries accurately and reviewing them. In ProfAcc, double-entry postings are made automatically, periods are closed, and the financial statements are produced directly from the entries.

In this sheetIn ProfAcc — Manufacturing Accounts
Changing any cell can alter the numbers of a period that has ended.Correct double-entry from day one, with automatic posting and period closing that locks what has been closed.
Tax is calculated in one place and invoices live in another.Every sales invoice calculates VAT within the journal entry that records it.
You only learn the stock balance after the month-end count.Stock balances are live and move with every posting.
One file per company you serve, and the files can get mixed up.Each company is created from a Google account in about a minute with nothing to install, its data is kept separate, and it is reached through its own link.

See ProfAcc — Manufacturing Accounts · Ask for a demo

Frequently asked questions

Does the sheet replace an accounting textbook or the standards?

No. It is a general study summary; standards and taxes follow local law. Some treatments (such as doubtful debts and inventory costing methods) differ between standards and jurisdictions, so check what applies in your country with your teacher or accountant.

Does a balanced trial balance mean every entry is correct?

No. A balanced trial balance only proves arithmetic balance. It will not reveal an entry that was left out completely, a correct amount posted to the wrong account, or two errors that cancel each other. That is why the sheet adds an account-type check and a warning for balances opposite to their normal side.

What happens if I record an unbalanced entry?

"قيد غير متوازن" (unbalanced entry) appears in red in the «فحص القيد» (Entry check) column on every line of that entry, and the difference shows in the journal status, the trial balance status and the summary until you correct the amount.

What are the limits of the depreciation and inventory tables?

The depreciation table shows five years, straight-line and declining-balance (at a rate you enter), and declining-balance never takes book value below salvage value. Inventory covers five purchase batches under the periodic system; LIFO is mentioned in the reference for information only.

Is the template free?

Yes, with no sign-up and no email address. Use it, edit it and share it as you like.

Does it work in Google Sheets and on mobile?

The sheet uses formulas supported by Excel 2016 and later, Google Sheets and LibreOffice, so you can upload it to Google Drive and open it with Google Sheets on a computer or a phone.

What is the difference between the white and the gray cells?

You type in the white cells; the gray cells are calculated automatically. Don't type in a gray cell, or you will erase its formula.

Can I use the sheet from an AI assistant?

Yes. Add our MCP server (URL https://softwiro.com/api/mcp, no key needed) to your assistant and ask it to do the calculation in this template. The numbers come from the sheet's own formulas, and we do not store your data. The steps and a ready-made prompt are in this article: https://softwiro.com/blog/mcp-excel-templates-ai-agent-guide.html

More free templates for: Accounting

More free templates

All templates · Free tools