Qoyod
Pricing

Monthly Financial Report Template (Income Statement, Balance Sheet, Cash Flow)

نموذج جاهز قابل للتعديل — حمّله مجانًا واستخدمه في عملك مباشرة.

A free, editable template — download and use it directly in your business.

Every month, owners of small and mid-sized businesses in Riyadh, Jeddah, and Dammam receive a pile of numbers: total sales, total expenses, bank balance, uncollected invoices. The numbers are there, but the decision is not. The owner looks at the page and cannot tell whether the company is actually growing or whether the growth is just price inflation, and whether the profit on paper is sitting in the bank account or locked inside receivables that will not be collected for 90 days.

The problem is not the absence of data, but the absence of a report. Bookkeeping gives you raw numbers; a financial report turns those numbers into a readable story: what happened last month, why it happened, and what should be done next month. The difference between a company that grows steadily and one that bleeds cash is, more often than not, a difference in reporting, not a difference in activity.

This guide gives you a ready-to-use monthly, quarterly, and annual financial report structure, with an Excel and Google Sheets template that includes an income statement, balance sheet, cash flow statement, performance indicators, variance analysis, and an executive summary. The template is built around Saudi figures, 15% VAT, and ZATCA requirements, and is ready to plug directly into your Qoyod account.

Free Download

Complete Financial Report Template in Excel + Google Sheets

Includes the income statement, balance sheet, and cash flow statement, with ready performance indicators, variance analysis, and an executive summary in a professional format using Saudi figures and 15% VAT.

Run it directly inside Qoyod

What a good financial report is and why companies differ in how they build one

A good financial report is not a collection of tables; it is a management document that answers three questions on a single page: where we were, where we are, and where we are heading. A company selling SAR 500,000 a month needs a very different report from a company selling SAR 5 million, but the logic is the same: number, reason, recommendation.

The difference between one company and another comes from three factors: the nature of the activity (retail, services, construction, manufacturing), the scale of operations, and the maturity of the finance function. A construction firm needs a report that focuses on project completion percentages and the cash flow tied to milestone payments, while a retail store needs a report focused on profit margin and inventory turnover.

Financial report vs. financial statements

Financial statements are three accounting documents: the income statement, the balance sheet, and the cash flow statement. A financial report is a larger package that includes these statements plus an executive summary, performance indicators, variance analysis, and recommendations. Statements are data; the report is decisions.

Who reads the report

The non-finance owner reads the executive summary and the indicators. The finance manager reads the details and the variances. The bank or investor reads the balance sheet and the cash flow. ZATCA reads the certified statements. One report, five audiences, and it must serve all of them without losing anyone in details that do not concern them.

The difference between accounting data and a financial report

Many business owners receive a file from the accountant with the trial balance and the income statement and think they have received a report. In reality, they have received raw data. Data tells you that expenses rose 18%. The report tells you why they rose, exactly which line item, whether the rise is a one-off or an ongoing trend, and what action is recommended.

The golden rule: every number in the report must be accompanied by a reason and a recommendation. The income statement says revenue is SAR 850,000. The report says revenue is SAR 850,000, growing 12% over the previous month, driven by a 22% increase in B2B sector orders, with a recommendation to double sales effort in that sector next month.

The reporting equation: story + number + recommendation

  • Story: what happened during the period, phrased so a non-finance reader can follow it.
  • Number: the actual value, the percentage, and the comparison against the previous period or the budget.
  • Recommendation: the operational action proposed, with the owner and the timeframe.

A report without recommendations becomes an archive. A report without numbers becomes an opinion. A report without a story becomes a table no one opens. The three together produce a decision document.

The mandatory sections of any monthly financial report

A professionally prepared monthly financial report contains five main sections in a fixed order: the executive summary first, then the performance indicators, then the three financial statements, then the variance analysis, and finally the recommendations and actions. The order is deliberate: from general to specific, and from result to detail.

Executive summary (one page)

Contains 5 to 7 sentences summarizing the month’s performance: revenue growth rate, gross margin, net profit, cash flow, the most important variance, and the most important recommendation. The owner who will read only this page must walk away understanding the state of the company.

Key performance indicators

6 to 10 carefully chosen indicators, displayed in a card grid or a comparison table. They should cover profitability, liquidity, operational efficiency, and revenue growth. They are compared against the previous month, against the same month of the previous year, and against the budget target.

The three financial statements

Income statement, balance sheet, and cash flow statement. Displayed in comparative form (current month vs. previous, or actual vs. budget). They should be concise, listing only the major lines, with the details kept in appendices.

Variance analysis

A narrative section that explains any variance greater than 10% between actual and plan, or between the current and previous month. It must identify the root cause, not the surface symptom: administrative expenses rose because two new employees were hired on the 5th of the month, not simply because expenses rose 14%.

Recommendations and actions

A list of 3 to 5 operational actions, each with an owner and a delivery date. A report that does not produce measurable decisions for the following month is a weak report, no matter how accurate its numbers are.

The income statement: how it is built and how it is read

The income statement (P&L) shows the company’s performance over a defined period. Its logical order is: revenue, cost of revenue, gross profit, operating expenses, operating profit, non-operating items, and finally net profit. Each line answers a specific question, and lines cannot be mixed.

The most common mistake in small companies is mixing cost of revenue with operating expenses. Cost of revenue is what is directly tied to the product or service sold (raw materials, direct labor, inventory transport). Operating expenses are what runs the company as a whole (office rent, management salaries, marketing). Mixing them distorts the gross margin and produces a misleading picture.

Sample monthly income statement (B2B services company)

Line item Current month (SAR) Previous month (SAR) Change
Total revenue 850,000 760,000 11.8%
VAT collected 127,500 114,000 11.8%
Net revenue 850,000 760,000 11.8%
Cost of revenue 340,000 308,000 10.4%
Gross profit 510,000 452,000 12.8%
Gross profit margin 60% 59.5% 0.5 pt
Operating expenses: salaries and admin 185,000 170,000 8.8%
Operating expenses: marketing and sales 62,000 48,000 29.2%
Operating expenses: rent and utilities 45,000 45,000 0%
Total operating expenses 292,000 263,000 11%
Operating profit 218,000 189,000 15.3%
Financing expenses 8,500 8,500 0%
Net profit before zakat 209,500 180,500 16.1%
Estimated zakat 5,238 4,513 16.1%
Net profit after zakat 204,262 175,987 16.1%
Net profit margin 24% 23.2% 0.8 pt

How to read this statement

The correct reading starts from top to bottom, stopping at three pivotal numbers: revenue growth, gross profit margin, and net profit margin. If revenue is growing and gross margin is stable or improving, the company is healthy. If revenue is growing while margin is shrinking, there is pressure on pricing or cost. If the net margin is improving faster than the gross margin, the company is controlling its operating expenses efficiently.

The balance sheet: assets, liabilities, and equity

The balance sheet is a snapshot at a point in time, showing what the company owns (assets), what it owes (liabilities), and what is left for the owners (equity). Its eternal equation: assets = liabilities + equity. A balance sheet that does not balance simply contains a posting error.

Reading the balance sheet for small companies in Saudi Arabia focuses on three things: the current ratio (current assets over current liabilities), the debt ratio (total liabilities over total assets), and net working capital (current assets minus current liabilities). These three are enough to diagnose the short-term financial position.

Sample condensed balance sheet

Line item Value (SAR) % of total
Current assets
Cash and equivalents 420,000 14.5%
Trade receivables 680,000 23.4%
Inventory 310,000 10.7%
Prepaid expenses 45,000 1.6%
Total current assets 1,455,000 50.2%
Non-current assets
Furniture and fixtures (net) 180,000 6.2%
Vehicles (net) 240,000 8.3%
Software and systems 95,000 3.3%
Total non-current assets 515,000 17.8%
Total assets 2,900,000 100%
Current liabilities
Trade payables 380,000 13.1%
VAT payable 92,000 3.2%
Accrued salaries 185,000 6.4%
Short-term loan 150,000 5.2%
Total current liabilities 807,000 27.8%
Long-term loan 350,000 12.1%
End-of-service benefits 120,000 4.1%
Total liabilities 1,277,000 44%
Equity
Paid-in capital 1,000,000 34.5%
Retained earnings 623,000 21.5%
Total equity 1,623,000 56%
Total liabilities and equity 2,900,000 100%

Warning signals in the balance sheet

  • Inflated receivables: if receivables exceed 25% of total assets, the company is selling but not collecting. A liquidity problem is on the way.
  • Stagnant inventory: inventory exceeding two months of average sales signals unplanned buying or a slow-moving product.
  • Current liabilities exceeding current assets: a working capital deficit. The company may struggle to meet short-term obligations.
  • Negative retained earnings: the company is accumulating historical losses. Immediate restructuring is needed.

The cash flow statement: the difference between profit and liquidity

The cash flow statement is the most important and the most misunderstood. Many companies profit on paper and go bankrupt at the bank. The reason is that profit is recorded when the invoice is issued, while cash arrives when it is collected. A company selling on 90-day terms may look profitable while bleeding cash.

The statement is split into three activities: operating cash flows (from the core business), investing cash flows (buying or selling assets), and financing cash flows (loans, capital, distributions). The real financial health shows up in the operating cash flow: if it is positive and growing, the company is generating cash from its core operations.

The practical equation

Operating cash flow = net profit + depreciation + (decrease in receivables) + (decrease in inventory) + (increase in payables). Any increase in receivables or inventory means trapped cash, and any increase in payables means deferred cash that remains in the company.

The 13-week rule

Every small company should prepare a cash flow forecast for the next 13 weeks, updated weekly. This forecast surfaces gaps before they happen and allows you to schedule collections, defer payments, or arrange financing in time. The monthly report tells you what happened; the 13-week forecast tells you what will happen.

The performance indicators the report must include

Indicators are the distillation of the report into a small set of meaningful numbers. The most common mistake is picking 30 indicators, with the result that no one reads them. The rule: 8 indicators maximum, 4 for profitability and efficiency, 2 for liquidity, and 2 for growth and market share. Each indicator must have a written target, otherwise it is a number without meaning.

Core indicators with their formulas

Indicator Formula Actual Target Status
Gross profit margin (Gross profit / revenue) x 100 60% 58% Above target
Net profit margin (Net profit / revenue) x 100 24% 22% Above target
Operating profit margin (Operating profit / revenue) x 100 25.6% 24% Above target
Return on assets (Net profit / total assets) x 100 7% 8% Below
Current ratio Current assets / current liabilities 1.80 1.50 Healthy
Quick ratio (Current assets, inventory) / current liabilities 1.42 1.20 Healthy
Average collection period (Receivables / credit sales) x 30 32 days 30 days Close
Average inventory age (Inventory / cost of sales) x 30 27 days 30 days Above target
Debt ratio (Total liabilities / total assets) x 100 44% 50% Healthy
Monthly revenue growth ((Current month, previous) / previous) x 100 11.8% 8% Above target

Reading the indicators together

A single indicator does not tell a story; the set does. A 60% gross margin with a 32-day collection period and a current ratio of 1.80 is the picture of a healthy company. The same margin with a 65-day collection period and a current ratio of 1.05 is a company on the edge of a crisis, even though the profitability is identical. A good report presents the indicators in one panel that allows this cross-reading.

Variance analysis: actual vs. budget and vs. previous month

Variance analysis is what turns the report from a narrative into an analysis. The idea is simple: for each major line, compare actual to plan (budget), then to the actual of the previous month, then to the actual of the same month last year. Three comparisons reveal the real pattern.

The rule: explain any variance greater than 10% by value, or greater than SAR 5,000 in absolute amount, whichever is larger. Do not explain every variance, only the material ones. Explaining everything means explaining nothing.

Types of variances

  • Quantity variance: you sold 1,200 units instead of the planned 1,000. A positive impact on revenue.
  • Price variance: you sold at SAR 95 instead of the planned SAR 100. A negative impact on revenue and margin.
  • Cost variance: raw material cost rose 12% because of a higher dollar rate. A negative impact on gross margin.
  • Timing variance: a marketing expense planned for March was spent in February. Zero impact annually, but it distorts the monthly comparison.

How to phrase a variance explanation

The correct phrasing: “Marketing expenses rose 29.2% (SAR 14,000) over the previous month because of the seasonal campaign launched on the 8th with a SAR 18,000 budget, offset by SAR 4,000 saved by deferring the Google Ads campaign to next month. The variance is planned and expected; the projected revenue impact is +6% within 30 days.”

The wrong phrasing: “Marketing expenses rose.” This is not analysis; this is an observation.

Quarterly and annual reports: what is added on top of the monthly

The quarterly and annual reports build on the monthly, but they add layers that do not exist in the monthly: trend analysis, market comparison, forecasts for upcoming periods, and a strategic assessment. The monthly is operational, the quarterly is tactical, and the annual is strategic.

The quarterly report

In addition to the monthly elements, it includes a three-month trend analysis (are the indicators steadily improving or deteriorating), a comparison with the same quarter of the previous year, an update to the annual forecast based on what has been achieved, and an assessment of quarterly target execution. Reading time is 30 to 45 minutes.

The annual report

It adds, on top of all that, performance analysis against the full annual plan, revenue breakdown by sector, customer, and product, profitability analysis for each business line, return on invested capital assessment, a budgeted plan for the coming year, and observations from ZATCA on the returns filed during the year.

Certified financial statements

The annual report is attached to financial statements certified by a licensed public accountant, if the company is obliged to do so (joint-stock companies, larger-activity companies, companies applying for bank financing). The obligation is set by the Saudi Companies Law along with the size and type of the entity.

How to write the executive summary for a non-finance owner

The executive summary is the part that is actually read. A busy owner will not open the statements but will read this one page. It must therefore be written in the owner’s language, not the accountant’s. No complex jargon, no numbers without context, no sentence carrying more than one idea.

A five-short-paragraph structure

  • Paragraph 1 (the big picture): two sentences on the month’s overall performance, with the two most important numbers: revenue growth and net profit.
  • Paragraph 2 (what worked well): three points that exceeded expectations, with the reason.
  • Paragraph 3 (what did not work): two or three points that fell short of target, with the reason.
  • Paragraph 4 (cash flow): the state of liquidity, the current balance, the forecast for the next 4 weeks.
  • Paragraph 5 (recommendations): 3 actions to take this month, each with an owner and a date.

Worked example

“The company closed September with revenue of SAR 850,000, growth of 11.8% over August, and a net profit of SAR 204,262 at a 24% margin. Performance is 6% above the Q3 budget. Growth was driven by the B2B sector, whose orders rose 22%, and by an improvement in gross margin to 60% after renegotiating with two suppliers. On the other hand, the average collection period stretched to 32 days (target: 30) because of a delayed payment from a single customer worth SAR 145,000. The current bank balance is SAR 420,000, and the four-week forecast is SAR 510,000 after collecting the due receivables. Recommendations: follow up on the delayed customer this week, launch a B2B campaign with a SAR 25,000 budget, and defer the planned vehicle purchase to Q4.”

The most common mistakes in small-business financial reports

Before we close with how Qoyod helps, here are the mistakes we see repeatedly in small-business reports in Saudi Arabia, all of which can be avoided with a simple review before the report is approved.

1. Mixing personal and company finances

The owner uses the company card for a personal expense, or transfers from the company account to their own without recording a drawing. The result is a report that does not reflect real performance. The fix: a fully separate bank account, and every personal withdrawal posted as drawings.

2. Ignoring depreciation

Fixed assets (vehicles, furniture, equipment) lose value over time. Ignoring depreciation inflates profit and misleads the report. The fix: a fixed depreciation schedule applied monthly.

3. Not separating cash from credit

A report that does not distinguish cash sales from credit sales will not surface a collection problem before it grows. The fix: an aging report on receivables every month.

4. VAT inside revenue

A very common error: recording the full invoice (amount + VAT) as revenue. The correct treatment: revenue is recorded without VAT, and the VAT collected appears as a liability to ZATCA. Mixing them inflates revenue by 15% and produces a misleading profitability picture.

5. Not updating the budget

A budget set in January and left unchanged for the whole year while the market shifts three times is not a useful comparison base. The fix: review the budget quarterly and update it based on what has been achieved and what is expected.

6. No forecasts

A report that only narrates the past without a forward look is incomplete. The fix: a closing section in the report forecasting revenue, expenses, and cash flow for at least the coming month.

E-invoicing, ZATCA, and their impact on the report

With the rollout of Phase 2 of e-invoicing in Saudi Arabia, every revenue line of a VAT-registered company is logged in real time on the Fatoora platform of the Zakat, Tax and Customs Authority (ZATCA). This shift has three direct effects on the financial report.

Effect 1: mandatory reconciliation

Revenue in the report must match what was sent to Fatoora. Any gap triggers a review by ZATCA. It has therefore become essential that the report comes out of the same system that issues the invoices, or is directly connected to it, to avoid manual reconciliation.

Effect 2: a permanent VAT section

Every monthly report must include a VAT section: output VAT collected, input VAT paid, and net VAT due to ZATCA. This section lets you estimate the quarterly liability before the filing deadline.

Effect 3: zakat and tax on the balance sheet

Annual estimated zakat and monthly VAT payable must appear as liabilities on the balance sheet, not only at the moment of payment. A report that ignores these liabilities overstates net assets and equity.

How Qoyod helps you generate financial reports automatically

A good financial report is not an Excel file updated by hand; it is the output of an accounting system running in the background and organizing itself. Qoyod builds that layer end-to-end and hands you the report ready, instead of you spending days assembling the data.

Certified financial statements at the click of a button

The income statement, balance sheet, and cash flow statement are all generated directly in Qoyod for any period you choose, with an automatic comparison against the previous period. The statement is ready to export to Excel or PDF to attach to the monthly report.

Performance and KPI reports

Qoyod provides an indicator dashboard showing gross margin, liquidity, receivables age, inventory turnover, and more, updated in real time. To see everything the system offers, visit the Qoyod reports page.

Certified e-invoicing

Every invoice issued from Qoyod is sent automatically to the Fatoora platform, and every revenue line in the report matches what is recorded at ZATCA. This automatic match eliminates hours of manual reconciliation at month-end. Details of the invoicing feature on the e-invoicing page.

Receivables and payables reports

An aging report is ready for each customer and supplier, showing what is unpaid at 30, 60, and 90 days. This report is what turns any sales operation into a real collections operation.

Budgeting and variance analysis

You set the annual budget in Qoyod, and the system compares actuals against it automatically at the end of each month, showing the variances by percentage and amount. You no longer need a parallel Excel.

Specialist support

The Qoyod support team is available for accounting and technical questions 24 hours a day, 7 days a week, including official holidays. Find the plan and subscription details on the pricing page.

Frequently asked questions

What is the difference between a financial report and financial statements?

The financial statements are three accounting documents: the income statement, the balance sheet, and the cash flow statement. The financial report is a larger package that includes these statements plus an executive summary, performance indicators, variance analysis, and operational recommendations. Statements are data; the report is a decision.

How often should I prepare a financial report?

A monthly report is essential for every company regardless of size. A quarterly report is added for companies whose annual revenue exceeds SAR 1 million. An annual report is mandatory for every registered company and is required by banks and ZATCA.

Do I need an accountant to prepare the report or can I do it myself?

If you have an accounting system like Qoyod that keeps your daily entries accurate, you can generate the statements yourself. However, drafting the executive summary and the variance analysis is best done by an accountant or finance manager, since the analysis requires experience that the system itself does not provide.

How do I make sure the numbers in my report are accurate?

Apply three checks before approving the report: reconcile the bank balance with the bank statement, reconcile VAT with the Fatoora platform, and run a random review of ten invoices for accounting posting accuracy. These three checks catch 90% of errors.

What are the top 3 indicators I should focus on as a small-business owner?

Gross profit margin (are you selling at a profitable price), average collection period (are sales turning into cash), and the current ratio (can you meet short-term obligations). These three are enough to diagnose financial health in 30 seconds.

Should I include VAT in revenue?

No. Revenue is recorded without VAT, and VAT collected appears as a liability to ZATCA on the balance sheet, not as revenue. Recording VAT as revenue inflates revenue by 15% and violates accounting standards.

How do I handle a loss month in the report?

Do not hide the loss; explain it. Identify the root cause (lower sales, a one-off expense, an exceptional discount), classify it as recurring or non-recurring, and propose actions for the coming month. A loss that is analyzed is solvable; a loss that is hidden compounds.

Does the attached template work for all types of businesses?

The template is built as a general structure suitable for services, trade, and retail. Manufacturing and construction companies need additional production statements and project completion percentages. The template is customizable by adding these sections without changing the core structure.

Start Free Now

Generate your monthly financial report automatically from Qoyod

Certified financial statements, real-time performance indicators, variance analysis against budget, and receivables and VAT reports matched to the Fatoora platform. A full trial with no credit card required.

Start your free trial

Fill in your information to download the template.

من النموذج إلى الدفاتر بدون عناء

قيود يسجّل ويصنّف ويُطابق العمليات في دفاترك تلقائيًا

جرّب قيود مجانًا لمدة 14 يومًا — بدون بطاقة ائتمان.

From template to ledger — effortless

Qoyod automatically records, classifies, and reconciles your transactions.

Try Qoyod free for 14 days — no credit card required.