Financial Statements, MIS and Analytics

Introduction

Financial statements transform accounting records into information for decision-making. In a Tally-based accounting system, transactions are first recorded in vouchers, classified into ledgers, summarised in a trial balance, and then converted into financial statements and management reports. The accounting system therefore serves two purposes: statutory reporting and managerial control.

The principal statements are the income statement (profit and loss account), balance sheet, and cash-flow statement. Management information systems (MIS) extend these reports by presenting budgets, variances, ageing schedules, ratios and exception alerts. Their strategic importance lies in helping managers assess profitability, liquidity, solvency, operational efficiency and risk.

This chapter uses the term “Tally” to refer to computerised accounting software capable of maintaining ledgers, producing reports and supporting analysis. Exact menu names may differ between software versions, but the accounting logic remains consistent.

Learning Objectives

After studying this chapter, a learner should be able to:

1. Explain the purpose and structure of a trial balance.
2. Prepare and interpret a profit and loss account and balance sheet.
3. Distinguish profit from cash and explain the cash-flow statement.
4. Calculate and interpret fundamental accounting ratios.
5. Prepare receivables and payables ageing reports.
6. Design useful MIS reports and exception-based dashboards.
7. Identify data-quality, control, ethical and governance issues in financial analytics.

1. From Transactions to Reports

A typical accounting information flow is:

Source document → voucher entry → ledger posting → trial balance → adjustments → financial statements → MIS and analytics

Source documents include invoices, receipts, payment instructions, debit notes, credit notes, payroll records and bank statements. A voucher records the accounting effect of a transaction. Ledgers accumulate transactions by account. The trial balance lists ledger balances and tests the arithmetical equality of debits and credits.

The accounting equation is:

Assets are resources controlled by the entity; liabilities are obligations to outsiders; equity is the residual interest of owners. This identity applies when accounts are prepared under the double-entry system. It must hold after all valid entries and adjustments have been posted, although equal totals do not prove that every transaction is correct.

2. The Trial Balance

A trial balance is a schedule of debit and credit balances extracted from the ledger at a specified date. It may be prepared before adjustments, after adjustments, or after closing entries. A common pre-adjustment trial balance contains balances such as cash, bank, receivables, inventory, purchases, expenses, capital, payables and sales.

Purpose

The trial balance helps to:

• check the arithmetical equality of ledger postings;
• provide the starting point for financial statements;
• identify unusual debit or credit balances;
• support audit and review procedures; and
• connect the accounting database with reporting modules.

Limitations

A balanced trial balance cannot detect every error. It will not normally reveal:

• complete omission of a transaction;
• posting to the wrong account of the same class;
• compensating errors;
• an error of principle, such as treating equipment as an expense; or
• an incorrect amount entered equally on both sides.

Consequently, reconciliation, document verification, review of unusual entries and physical or external evidence remain necessary.

Adjustments

Financial statements generally require adjustments for accruals, prepayments, depreciation, provisions, closing inventory, bad debts and outstanding income. For example, if annual insurance of 12,000 is paid but 2,000 relates to a future period, the current-period insurance expense is 10,000 and prepaid insurance of 2,000 is an asset. Adjustments ensure that revenue and expenses are reported in the period to which they relate.

3. Profit and Loss Account

The profit and loss account, or income statement, reports financial performance over a period. A simplified structure is:

Revenue is recognised according to the applicable accounting framework, not merely when cash is collected. Expenses include the costs consumed in generating revenue, whether paid or unpaid.

A manufacturing or trading entity may present:

For a trading business:

Opening and closing inventory must be measured consistently under the applicable accounting policy. Direct costs are costs directly attributable to bringing inventory to its present location and condition, where relevant.

Worked Example: Profit Measurement

An enterprise reports sales of 480,000, sales returns of 20,000, opening inventory of 90,000, purchases of 260,000, purchase returns of 10,000, carriage inward of 8,000, closing inventory of 110,000, wages of 55,000, rent of 30,000 and depreciation of 12,000.

Net revenue = 480,000 − 20,000 = 460,000.

Net purchases = 260,000 − 10,000 = 250,000.

Cost of sales = 90,000 + 250,000 + 8,000 − 110,000 = 238,000.

Gross profit = 460,000 − 238,000 = 222,000.

Operating expenses = 55,000 + 30,000 + 12,000 = 97,000.

Profit before tax, assuming no other items, is 222,000 − 97,000 = 125,000.

This calculation is valid only if the inventory figures and expense classifications are complete and measured on a consistent basis.

4. Balance Sheet

The balance sheet, or statement of financial position, reports assets, equity and liabilities at a particular date. It is a position statement rather than a period statement.

Assets may be classified as non-current or current. Non-current assets include property, plant and equipment and certain long-term investments. Current assets normally include cash, bank balances, inventory and trade receivables expected to be realised within the operating cycle or approximately twelve months, subject to the applicable framework.

Liabilities may be current or non-current. Current liabilities include trade payables, short-term borrowings, accrued expenses and taxes payable. Equity may include paid-in capital, reserves and retained earnings.

A useful presentation is:

The balance sheet is affected by accounting judgements. Depreciation reduces the carrying amount of an asset and profit; provisions affect both profit and liabilities or contra-assets; inventory valuation affects both profit and current assets.

5. Cash-Flow Statement

Profit is not the same as cash generated. A credit sale increases revenue and profit but creates a receivable rather than immediate cash. Depreciation reduces profit without a current cash payment. The cash-flow statement explains changes in cash and cash equivalents through operating, investing and financing activities.

Classification

• Operating activities: cash from customers, cash paid to suppliers and employees, and other cash flows arising from the main revenue-producing activities.
• Investing activities: purchase or sale of long-term assets and investments.
• Financing activities: proceeds from shares or borrowings, repayment of borrowings, and certain distributions, according to the applicable reporting framework.

Under the indirect method, operating cash flow begins with profit and adjusts for non-cash items and working-capital movements:

This compact expression assumes that the relevant working-capital changes are identified correctly and that signs are applied consistently. An increase in receivables is subtracted because it represents revenue not yet collected; an increase in payables is added because expenses have been recognised without equivalent cash payment.

Worked Example

Suppose profit is 125,000, depreciation is 12,000, receivables increase by 18,000, inventory decreases by 7,000 and payables increase by 10,000. Ignoring tax and other adjustments:

Operating cash flow = 125,000 + 12,000 − 18,000 + 7,000 + 10,000 = 136,000.

The positive cash flow is higher than profit because depreciation is non-cash and working-capital changes released cash overall. A complete cash-flow statement must also include investing and financing flows and reconcile opening to closing cash.

6. Fundamental Ratios

Ratios convert accounting data into comparable indicators. They should be interpreted over time, against budgets, and against suitable industry or organisational benchmarks. A ratio by itself is not a conclusion.

Average inventory commonly means (opening inventory + closing inventory) ÷ 2, assuming those two observations reasonably represent the period. Credit revenue should be used for receivables days where available. If only total revenue is available, the limitation should be disclosed.

Interpretation Example

If revenue is 460,000 and gross profit is 222,000, gross margin is:

222,000 ÷ 460,000 × 100 ≈ 48.3%.

If closing receivables are 72,000 and annual credit revenue is 460,000, a simple closing-balance estimate of collection days is:

72,000 ÷ 460,000 × 365 ≈ 57 days.

This is an approximation because it uses closing rather than average receivables. A rising collection period may signal weak credit control, disputed invoices or customer financial difficulty.

7. Ageing Reports

An ageing report groups receivables or payables according to the age of outstanding documents. Typical bands are current, 1–30 days overdue, 31–60, 61–90 and over 90 days. The ageing basis must be defined: invoice date, due date or promised payment date. Due-date ageing is usually more useful for credit control because it identifies actual delinquency.

The report supports collection prioritisation, credit-limit review, expected-loss assessment and cash forecasting. It must reconcile to the receivables control account. Unallocated receipts, credit notes, disputed invoices and advances should not be concealed within an ageing bucket.

8. MIS and Exception-Based Dashboards

MIS converts transaction data into information appropriate for a decision-maker. An effective report answers four questions: What happened? Why did it happen? What may happen next? What action is required?

Operational reports may show daily sales, receipts, bank reconciliation status and overdue invoices. Tactical reports may show budget variance, branch profitability, inventory turnover and supplier concentration. Strategic reports may show return on capital, cash conversion, debt capacity and long-term trends.

A dashboard should contain defined measures, reliable data, appropriate frequency, responsible owners and thresholds. Exception-based reporting directs attention to conditions requiring investigation rather than displaying every transaction.

Examples of exceptions include:

• receivables more than 60 days overdue;
• payments above an approval limit;
• negative inventory balances;
• gross margin below a defined threshold;
• unusually high manual journal entries;
• duplicate invoice numbers;
• bank reconciliation items unresolved beyond a specified period; and
• budget variances exceeding a materiality level.

A useful variance calculation is:

The percentage variance, where budget is non-zero, is:

The absolute value in the denominator prevents the sign of a negative budget from reversing the interpretation. For expenses, an actual amount above budget is generally adverse, whereas for revenue it may be favourable; therefore, the dashboard must label favourable and adverse effects rather than relying only on arithmetic signs.

9. Tally-Based Implementation and Controls

A practical reporting workflow includes:

1. Create the company with the correct financial year, base currency and statutory settings.
2. Establish a chart of accounts with meaningful groups and cost centres.
3. Configure taxes, inventory, credit limits, approval authorities and voucher numbering.
4. Record sales, purchases, receipts, payments, journals and bank transactions using source documents.
5. Reconcile bank, receivables, payables, inventory and tax ledgers.
6. Post period-end adjustments and review the adjusted trial balance.
7. Produce statements, ratios, ageing reports and exception dashboards.
8. Lock or restrict the period after approval and retain an audit trail.

Segregation of duties is important. The person creating a supplier should not independently approve payment and reconcile the bank without review. Access should follow the principle of least privilege. Backups, password controls, change logs and tested restoration procedures protect the integrity and availability of accounting information.

10. Illustrative Case: Meridian Office Supplies

Background. Meridian Office Supplies is a small wholesaler using Tally to record sales, purchases, inventory and banking. Management reports strong sales but experiences cash shortages.

Problem. The monthly dashboard shows revenue growth of 14%, but receivables over 90 days have increased from 6% to 18% of total receivables. Inventory days have also risen. The current ratio is 1.4, but the quick ratio is 0.7.

Analysis. The current ratio appears acceptable only because inventory is included. The lower quick ratio indicates that immediately realisable assets may not cover current liabilities. Ageing analysis identifies three customers responsible for most severely overdue balances. Investigation finds that sales staff granted credit beyond approved limits and that several invoices were sent late. Inventory analysis identifies slow-moving products purchased in anticipation of demand.

Approach. Management introduces customer credit limits, weekly overdue alerts, electronic invoice dispatch, documented collection responsibility and a review of slow-moving inventory. Purchases require a stock-coverage check, and dashboard thresholds trigger a manager review when receivables over 60 days exceed 10% of total receivables.

Outcome. The case illustrates that revenue growth is not equivalent to cash growth. Integrated analysis of the income statement, balance sheet, cash-flow information, ratios and ageing reports produces a more reliable diagnosis than any single report.

Learning points. Reports must be reconciled, measures must have owners, and exceptions must lead to documented action. A dashboard that displays indicators without decisions is only a visual ledger.

11. Limitations, Ethics and Contemporary Developments

Accounting analytics depends on the quality of master data, transaction coding, cut-off procedures and assumptions. Ratios can be distorted by seasonality, inflation, unusual transactions, different accounting policies or window dressing near the reporting date. Automated classifications may also perpetuate errors if historical data are wrong.

Ethical reporting requires completeness, neutrality, confidentiality and faithful representation. Users must not manipulate dates, defer expenses improperly, create fictitious customers, suppress overdue balances or use dashboards to disguise adverse trends. Personal and financial data should be accessed only for legitimate purposes and protected according to applicable privacy and record-retention requirements.

Modern systems increasingly provide bank feeds, optical invoice capture, workflow approvals, cloud access and predictive alerts. Artificial intelligence can assist with duplicate detection, anomaly identification and cash forecasting, but it should not replace professional judgement. AI-generated classifications require human review, explainable rules, controlled access and an audit trail. Predictions should be distinguished clearly from verified historical figures.

Best practice is to combine automation with reconciliation, exception review, periodic access assessment, documented accounting policies, version-controlled report definitions and independent oversight.

Chapter Summary

Financial statements are the principal structured output of an accounting system. The trial balance checks the equality of debit and credit balances but does not prove complete accuracy. Adjustments are necessary to apply accrual accounting and produce meaningful profit and financial position information.

The profit and loss account explains performance; the balance sheet reports assets, equity and liabilities at a date; and the cash-flow statement explains movements in cash through operating, investing and financing activities. Ratios support comparison, while ageing reports identify the timing and risk of receivables and payables. MIS makes information useful by linking measures to decisions, responsibility and action. Exception-based dashboards focus attention on material deviations, control failures and emerging risks.

Reliable analytics requires reconciled data, clear definitions, appropriate thresholds, security, ethical conduct and professional judgement. Tally and similar systems improve speed and visibility, but they cannot compensate for poor source documents, weak controls or misleading interpretation.

Key Terms

Trial balance: A list of ledger debit and credit balances at a specified date.

Adjusted trial balance: A trial balance prepared after period-end adjustments.

Profit and loss account: A statement reporting revenue, expenses and profit or loss for a period.

Balance sheet: A statement of assets, equity and liabilities at a particular date.

Cash-flow statement: A statement explaining changes in cash and cash equivalents.

Accrual: Recognition of income or expense when earned or incurred rather than when cash moves.

Prepayment: An amount paid in advance for a future benefit.

Depreciation: Systematic allocation of the depreciable amount of a long-term asset.

Gross profit: Revenue less cost of sales.

Liquidity: The ability to meet obligations as they fall due.

Solvency: The ability to meet long-term obligations.

Ratio analysis: Evaluation using relationships between accounting amounts.

Ageing report: A schedule grouping outstanding balances by age or overdue period.

MIS: A system that supplies relevant information for management planning and control.

Exception report: A report highlighting items outside defined rules or thresholds.

Variance: The difference between actual and budget or standard performance.

Reconciliation: Agreement of two records or sources and investigation of differences.

Audit trail: A record showing how transactions or report results were created and changed.

Segregation of duties: Division of responsibilities to reduce error and fraud risk.

Working capital: Current operating assets less current operating liabilities.

Review Questions

5 Short Answer Questions

1. What is the purpose of a trial balance?
2. State two limitations of a balanced trial balance.
3. Distinguish profit from cash flow.
4. What information does an ageing report provide?
5. Define an exception-based dashboard.

5 Long Answer Questions

1. Explain the flow from source documents to financial statements in a computerised accounting system.
2. Describe the structure and interpretation of a profit and loss account.
3. Explain the three categories of cash flows and the indirect method of calculating operating cash flow.
4. Discuss the usefulness and limitations of ratio analysis.
5. Explain the controls required for reliable Tally-based MIS reporting.

3 Analytical / Application Questions

1. A business has rising sales, falling cash, increasing receivables and a growing proportion of invoices over 90 days overdue. Use financial statements, ratios and ageing analysis to diagnose the likely problem and recommend actions.
2. Actual administrative expense is 84,000 against a budget of 70,000, while actual revenue is 520,000 against a budget of 500,000. Calculate both percentage variances and explain why the dashboard should label the two variances differently.
3. Design five exception rules for a small wholesaler’s accounting dashboard. For each rule, state the data required, threshold, responsible person and likely management action.

Multiple Choice Questions with Answers

Question 1

Which statement best describes the purpose of a trial balance?

A. To prove that all transactions are free from error

B. To list ledger balances and check debit-credit equality

C. To calculate only cash generated from operations

D. To replace the balance sheet

Correct Answer: B. To list ledger balances and check debit-credit equality

Question 2

Revenue is 460,000 and gross profit is 222,000. What is the gross profit margin approximately?

A. 31.7%

B. 42.8%

C. 48.3%

D. 52.0%

Correct Answer: C. 48.3%

Question 3

Which item is normally an investing cash flow?

A. Cash collected from customers

B. Wages paid to employees

C. Purchase of equipment

D. Cash paid to suppliers

Correct Answer: C. Purchase of equipment

Question 4

Under the indirect method, an increase in trade receivables is generally treated as:

A. An addition to profit

B. A deduction from operating cash flow

C. A financing inflow

D. An investing inflow

Correct Answer: B. A deduction from operating cash flow

Question 5

Which ratio excludes inventory and prepayments from current assets?

A. Current ratio

B. Gross profit margin

C. Quick ratio

D. Debt-to-equity ratio

Correct Answer: C. Quick ratio

Question 6

Ageing by due date is especially useful because it:

A. Measures depreciation

B. Identifies actual payment delinquency

C. Calculates gross profit automatically

D. Eliminates the need for reconciliation

Correct Answer: B. Identifies actual payment delinquency

Question 7

If actual expense is 84,000 and budgeted expense is 70,000, the variance percentage is:

A. 10%

B. 14%

C. 20%

D. 84%

Correct Answer: C. 20%

Question 8

Which is an example of an exception rule?

A. Display every posted voucher alphabetically

B. Alert when an invoice is more than 60 days overdue

C. Print the company name on every report

D. List all accounts with zero balances

Correct Answer: B. Alert when an invoice is more than 60 days overdue

Question 9

Which control most directly reduces the risk that one person can create a supplier and approve its payment without review?

A. Segregation of duties

B. Increasing inventory levels

C. Changing the reporting currency

D. Using a wider ageing range

Correct Answer: A. Segregation of duties

Question 10

Why does a balanced trial balance not prove that the accounting records are completely correct?

A. Debits and credits are not used in accounting

B. Some errors affect equal debit and credit amounts or accounts

C. A trial balance contains only cash transactions

D. The balance sheet is prepared before the ledger

Correct Answer: B. Some errors affect equal debit and credit amounts or accounts