Tabular Statements

Setting Out a Tabular Statement

A balance sheet presents the financial position of an enterprise on a specific date, illustrating what the business owns (assets) and how those resources are financed (liabilities and equity). The fundamental accounting equation underpins the entire tabular structure:

The balance sheet balances because every euro of resources has a source. A transaction can only ever do one of three things: change an asset and its source together, swap one asset for another, or swap one source for another. That is why every single column balances across.

There are two ways of laying this out and both are accepted in State Examinations Commission marking schemes. Many textbooks and examination solutions put each transaction (with its date) on a row across the page and each balance sheet item as a column, ending with a Total Assets column and a Total Liabilities and Capital column at the right-hand side. The presentation used throughout this note places balance sheet items as rows and transactions as columns across the page. Whichever layout you choose, you must (a) label the opening and closing columns with their dates, (b) keep assets clearly separate from liabilities and capital, and (c) show the two totals agreeing.

The Five Easy Transaction Patterns

Before tackling tricky adjustments, make sure you can record routine operational events instantly. The rule is always: identify the rows affected, then check that the net change in Total Assets equals the net change in Total Liabilities and Capital.

• Paid rates €7,000 by cheque: Assets: Bank (7,000); Liabilities & Capital: Profit & Loss (7,000). Net change: −7,000 = −7,000.
• Paid a trade creditor €4,500 by cheque: Assets: Bank (4,500); Liabilities & Capital: Creditors (4,500). Net change: −4,500 = −4,500.
• Received €6,200 from a debtor: Assets: Bank +6,200, Debtors (6,200); Liabilities & Capital: no entry. Net change: 0 = 0.
• Bought equipment for €15,000 by cheque: Assets: Equipment +15,000, Bank (15,000); Liabilities & Capital: no entry. Net change: 0 = 0.
• Paid VAT of €4,300 to Revenue: Assets: Bank (4,300); Liabilities & Capital: VAT (4,300). Net change: −4,300 = −4,300.

Notice that if an event only swaps one asset for another, both column totals are zero. You must still write both figures into the matrix because each correct cell earns individual marks.

Handling Bank Overdrafts

If cash payments exceed the bank balance, keep the resulting overdraft inside the asset section as a clearly bracketed negative figure. For example, opening Bank of €18,000, less payments of €4,800, €22,000 and €20,500, plus the €1,300 recovered in August, leaves Bank at (28,000) just before the November share issue. Write it in brackets in the asset section; it reduces Total Assets. Do not move the bank account down to current liabilities midway through the statement, as that breaks the continuous reconciliation of your asset rows. Reclassification to Creditors: amounts falling due within one year only takes place if you are asked to draft a separate closing balance sheet.

Capital Versus Revenue Expenditure and Loan Transactions

Every decision about whether a payment affects a fixed asset row or the Profit & Loss row depends on distinguishing capital from revenue.

Capital or Revenue? The Decision Behind Every Row

• Capital Expenditure is money spent buying, improving, or extending a fixed asset, or getting it ready for operational use (purchase price, delivery, installation, site legal fees). It is added to a fixed asset row and charged to profit gradually through depreciation.
• Revenue Expenditure is the day-to-day cost of running the business (rates, insurance, repairs, wages, light and heat). It goes straight into the Profit & Loss row as an expense.

Treating revenue expenditure as capital overstates profit and overstates net worth; treating capital expenditure as revenue understates both. Neither error presents a True and Fair View.

Own Employees Improving a Fixed Asset

Questions regularly feature internal work: "During the year the company's own workers built an extension to the premises. Wages of €18,000 and materials of €22,000 relating to this work had been included in wages and purchases."

Because this €40,000 represents capital improvement rather than running costs, it must be removed from trading expenses and added to the asset:

• Assets: Buildings +40,000
• Liabilities & Capital: Profit & Loss +40,000 (profit rises because €40,000 of operational expenses is reversed)
• Column net change: +40,000 = +40,000

If the reverse happens ("Repairs of €5,000 had been debited to the Buildings account in error"), reverse the entry: Buildings (5,000) and Profit & Loss (5,000).

Loans and Debentures in a Tabular Statement

Long-term borrowings sit in the liabilities section, usually titled 8% Debentures or Loan.

• Receipt of loan or issue of debentures: Bank + full amount; Debentures/Loan + same amount.
• Interest expense: Debenture interest is a business expense, never a reduction in the loan principal. Charge it as: $\text{Interest} = \text{Principal} \times \text{Rate} \times \frac{\text{Months Held}}{12}$.
• Splitting a repayment instalment: When a repayment combines principal and interest, you must split them. Suppose €100,000 8% debentures were issued on 1 April. On 30 November a repayment of €12,000 was made, of which €2,500 was interest. In November: Bank (12,000); Debentures (9,500); Profit & Loss (2,500). Column net change: −12,000 = −12,000.
• Interest accrued at year end: Any interest incurred but unpaid on 31 December is an accrual. Create a current liability row Debenture Interest Due (+amount) and reduce Profit & Loss by the identical amount.

Share Capital, Business Acquisitions, and Reserves

Share issues and business takeovers usually turn up in the first few transactions. The key is to split the money raised between Issued Share Capital (the nominal or par value of the shares issued) and Share Premium (anything received above nominal value). Authorised share capital is only the legal maximum the company may issue — it is never entered in the statement, but you need it to work out how many shares are still available to issue.

Share Issues at a Premium

When shares are issued at a price exceeding nominal value:

Share Premium is a capital reserve and cannot be used to pay a cash dividend. When instructed to issue the "remaining authorised shares", calculate the volume by subtracting all shares issued up to that date from the authorised share capital figure stated in the opening balance sheet note.

Business Acquisitions and Goodwill

When a company buys another business, it takes over that business's assets and assumes responsibility for its debts:

If the purchase consideration exceeds net assets, the excess is recorded as an intangible asset named Goodwill. If consideration is less than net assets acquired, the difference is a capital reserve on the liabilities side. Goodwill remains in the closing asset column unless the question instructs you to write off an amount, in which case reduce Goodwill and reduce Profit & Loss.

Bonus (Capitalisation) Issues

A bonus issue gives existing shareholders free extra shares funded out of reserves. No cash comes in, so no asset row changes at all:

Transaction: The company makes a bonus issue of 1 share for every 4 held on 300,000 ordinary €1 shares in issue, utilising the Share Premium account.

• Bonus shares = $300,000 \div 4 = 75,000 \text{ shares} = €75,000$ nominal.
• Liabilities & Capital: Share Capital +75,000; Share Premium (75,000).
• Assets: No entry. Column total: 0 = 0.

If the Share Premium account is insufficient, draw the remaining balance from the Profit & Loss revenue reserve. Update the total shares in issue immediately so that any later dividend calculation uses the correct share volume.

Fixed Assets: Revaluation, Disposals, and Depreciation

When a fixed asset is revalued, sold, or traded in, you usually adjust several rows: eliminate the old carrying value, record the replacement asset, and post the profit or loss.

Upward Revaluation of Property

When land and buildings are revalued upwards, the gain is an unrealised capital surplus. It must never enter the Profit & Loss row. Credit it to a non-distributable Revaluation Reserve:

It is a capital reserve because the gain has not been realised in cash; under the prudence and realisation principles, unrealised holding gains cannot be distributed as dividends.

• If fixed assets are recorded at Net Book Value (NBV) in one row: increase Land & Buildings by the full surplus.
• If separate Cost and Accumulated Depreciation rows exist: increase Cost by the difference between new valuation and old cost, and eliminate Accumulated Depreciation by writing it back to zero as a positive entry.

Asset Disposals and Trade-Ins

When an asset is traded in against a new model, apply this four-stage routine:

1. Remove the old asset at cost or net book value.
2. Remove its accumulated depreciation to date (if kept in a separate contra-asset row).
3. Enter the new replacement asset at the full cost agreed for it, before the trade-in allowance is deducted. If the question mentions a list price and a different agreed price, always use the agreed price.
4. Deduct only the net cheque paid (Agreed New Cost minus Trade-in Allowance) from Bank.

The trade-in allowance itself is never posted to Bank or Creditors. It is used solely in workings to find disposal profit or loss:

Enter a profit as positive (+) in Profit & Loss; enter a loss as negative (−) in Profit & Loss.

Time-Apportioned Depreciation

Depreciation allocates the cost of a fixed asset across its estimated useful life, matching capital consumption against operational revenue in line with the Matching Principle.

• Land is never depreciated because it has an indefinite life and does not wear out. Always deduct the land value from a combined property figure before calculating depreciation on buildings.
• Counting rule: an asset acquired or revalued on the first day of month $n$ is held for $(13 - n)$ months. Assets bought 1 March are held for 10 months; assets bought 1 May are held for 8 months.
• Posting: if fixed assets are presented at Net Book Value, deduct the depreciation from that row and reduce Profit & Loss by the identical figure.

Operational Transactions: VAT, Bad Debts, Tax, and Dividends

Credit Sales and Incomplete Pricing Data

Under the accruals concept, revenue is recognised when earned. On credit sales, the customer owes the gross amount (net price plus VAT). VAT charged is collected for Revenue and represents an immediate current liability. Only trading profit enters Profit & Loss:

• Debtors increases by the gross invoice price.
• Stock decreases by the historical cost of the goods sold.
• VAT increases by the VAT liability charged.
• Profit & Loss increases by trading profit (Net Selling Price minus Cost of Sales).

Income received in advance: if rent of €6,000 for 6 months is received on 1 November, only €2,000 (2 months) has been earned by 31 December. Bank +6,000; Profit & Loss +2,000; create a current liability row Rent Received in Advance +4,000 (column: +6,000 = +6,000). Accrued income works the other way — income earned but not yet received is a current asset (e.g. Rent Receivable +1,500; Profit & Loss +1,500).

When given selling price and profit rate rather than cost:

• Mark-up on Cost: $\text{Cost} = \text{Selling Price} \times \frac{100}{100 + \text{Mark-up}\%}$. If goods marked up 25% are sold for €15,000 net: $\text{Cost} = €15,000 \times \frac{100}{125} = €12,000$; Profit = €3,000.
• Margin on Sales: $\text{Cost} = \text{Selling Price} \times \frac{100 - \text{Margin}\%}{100}$. A 20% margin on €15,000 gives: $\text{Cost} = €15,000 \times \frac{80}{100} = €12,000$; Profit = €3,000.

Bankrupt Debtors and Bad Debt Recoveries

• Bankrupt debtor paying part of the debt: A customer owing €3,000 pays 35c in the euro, with the remainder written off as bad. Cash received is $€3,000 \times 0.35 = €1,050$; bad debt written off is $€3,000 - €1,050 = €1,950$. In the matrix: Assets: Bank +1,050, Debtors (3,000), giving a net asset change of (1,950); Liabilities & Capital: Profit & Loss (1,950). The column balances at −1,950 = −1,950. Debtors must fall by the full €3,000 because the balance is cleared from the sales ledger.
• Bad debt recovered: When cash is received from a debtor written off in an earlier financial year, increase Bank (+receipt) and increase Profit & Loss (+gain). Leave Debtors untouched because that debt was eliminated from the ledger in the prior year.
• Provision for Bad Debts: Adjusting the provision changes the deduction against debtors. An increased provision reduces net debtors and reduces Profit & Loss; a decreased provision increases net debtors and increases Profit & Loss.

Corporation Tax and Dividends

Always check whether cash was actually paid:

• Corporation tax provision for the year (unpaid): Create current liability Taxation Due +€18,000; reduce Profit & Loss by €18,000. Bank is untouched. Column net change: 0 = 0.
• Payment of tax previously due: Bank (14,000); Taxation Due (14,000). Column net change: −14,000 = −14,000.
• Dividend paid by cheque: Bank (20,500); Profit & Loss (20,500).
• Dividend declared/proposed before year end but unpaid: Create current liability Dividends Payable (+amount); reduce Profit & Loss by the identical amount. No Bank entry is made.

Closing Balance Sheet Formats and Sole Trader Adjustments

From the Last Column to a Vertical Balance Sheet

If an examination question asks you to draft the closing balance sheet from the 31/12 column, regroup the balances into standard vertical format rather than copying the matrix order:

• Fixed Assets: Intangible Fixed Assets (Goodwill) plus Tangible Fixed Assets (Cost less Accumulated Depreciation = Net Book Value).
• Current Assets: Stock + Debtors (less bad debt provision) + Prepayments + Bank (if positive).
• Less Creditors: amounts falling due within one year: Trade Creditors + VAT + Accruals + Dividends Payable + Taxation Due + Bank Overdraft (an overdraft moves here from the asset section).
• Net Current Assets (Working Capital): Current Assets minus Creditors due within one year.
• Total Assets less Current Liabilities: Fixed Assets plus Net Current Assets.
• Less Creditors: amounts falling due after more than one year: Debentures / Long-term Loans.
• Net Assets: Total Assets less Current Liabilities minus Long-term Creditors.
• Capital and Reserves (Financed By): Issued Share Capital + Capital Reserves (Share Premium, Revaluation Reserve) + Revenue Reserves (Profit & Loss balance). Capital Employed must equal Net Assets.

If the Business is a Sole Trader Instead of a Company

In a sole trader tabular statement, there are no Share Capital, Share Premium, or Dividend rows. Instead, equity is tracked in a single Capital row:

• Net profit for the period increases Capital; net losses reduce Capital.
• Cash drawings reduce Bank and reduce Capital; goods taken for private use reduce Stock (at cost price) and reduce Capital.
• Capital introduced by the owner increases Bank and increases Capital.

Transactions that merely swap one asset for another (such as buying machinery for cash or collecting a debtor) leave net worth entirely unchanged; only operating profits, losses, private drawings, and capital injections alter net worth.

Key terms

Tabular Statement

An analytical accounting matrix setting out balance sheet accounts as rows and transactions as columns to demonstrate the continuous double-entry effect of business activities on financial position.

Dual Aspect Principle

The core double-entry accounting rule requiring every business transaction to be recorded in at least two places so that the equation Assets = Liabilities + Capital remains balanced.

Goodwill

An intangible fixed asset representing the premium paid upon acquiring an existing business over and above the fair market value of its net identifiable assets.

Revaluation Reserve

A non-distributable capital reserve within equity created when tangible fixed assets are revalued upwards, recording the unrealised surplus over historical net book value.

Share Premium

A capital reserve representing the surplus consideration received from shareholders over and above the nominal par value of shares issued; it cannot be distributed as a cash dividend.

Net Book Value (NBV)

The net carrying amount of a tangible fixed asset in the balance sheet, calculated as historical cost or revalued figure minus accumulated depreciation.

Trade-in Allowance

The agreed credit value granted by a vendor against an old asset surrendered as partial settlement towards the purchase price of a replacement asset.

Prepayment

An expenditure paid during the current accounting period where the economic benefit extends into the subsequent period, classified as a current asset.

Accrued Expense

An operational expense that has been incurred and benefited the business during the accounting year but has not yet been invoiced or paid by 31 December, classified as a current liability.

Matching Principle

The accounting convention dictating that expenses incurred in generating revenue must be matched against and recognised in the same accounting period as that revenue.

True and Fair View

The overarching statutory requirement that financial statements must reflect an accurate, objective, and unbiased picture of an enterprise's financial results and state of affairs.

Bad Debt Recovered

A cash receipt from a trade debtor whose account had been formally written off as uncollectible in a prior financial year, recorded as an increase in Bank and a gain in Profit & Loss.

Capital Expenditure

Money spent acquiring, improving, or extending fixed assets, recorded in balance sheet asset rows and written off across future periods via depreciation.

Revenue Expenditure

Day-to-day operational expenses incurred in running a business and maintaining revenue-earning capacity, charged directly to the Profit & Loss row in the current period.

Authorised Share Capital

The maximum amount of share capital a company is legally permitted to issue to shareholders, as set out in its constitution.