Budget Transactions Log Template (Actual vs Budget, Variance Analysis)

A small business owner in Riyadh or Jeddah starts the year with a budget written on paper or in an Excel file, then discovers three months later that actual expenses have exceeded the plan by 40 percent, without knowing exactly where the money leaked. The reason is usually not poor management, but the absence of a budget transactions log that compares, line by line and month by month, what was actually planned against what was actually spent.

A budget transactions log is the tool that turns a budget from an estimated number on paper into a daily control instrument. Every expense or revenue line item is recorded against what the budget allocated to it, and the variance appears instantly, positive or negative, with its percentage. This lets you make a corrective decision before a small overrun turns into a chronic annual deficit.

In this practical guide we explain how to build a budget log for your Saudi business, the difference between it and the general journal, how to allocate the budget across operating and investment line items, how to read monthly variance analysis, and how to link the log to the income statement and balance sheet. All of this with realistic numbers from the Saudi services sector, plus a ready-to-download template.

What a Budget Transactions Log Is and How It Differs from the General Journal

A budget transactions log is a control document that records every financial transaction against the line item it was budgeted for, displaying the difference between the planned and actual values in real time. Its purpose is not double-entry accounting, but managerial monitoring and planning. Every row answers one question: did we spend more or less than planned on this line item, and why?

The General Journal Is One Thing, the Budget Log Is Another

The general journal in an accounting system follows the double-entry principle: every transaction has a debit side and a credit side. It has nothing to do with the plan, it only records what actually happened according to approved accounting standards. The budget log, by contrast, knows nothing about double entry, it only knows three core columns: planned, actual, variance. It is closer to an operational KPI than to an accounting document.

When to Use Each One

• General journal: for tax filings, statutory financial reports, external audits, and compliance with the Zakat, Tax and Customs Authority (ZATCA) requirements.
• Budget transactions log: for daily managerial decisions, performance evaluation, cost control, and mid-year adjustments to the annual plan.
• Both together: a healthy business uses both. The accounting entry feeds the log with actual numbers automatically, and the log alerts management before a variance turns into a liquidity problem.

Who Is Responsible for Maintaining the Log

In small businesses, the log is kept by the accountant themselves or by the owner. In mid-sized businesses, it is part of the financial analyst’s or finance manager’s duties. In large companies it belongs to the Financial Planning and Analysis (FP&A) department. What matters is that the person in charge must be close to spending decisions and have the authority to flag any overrun.

The Difference Between the Estimated Budget and the Actual Budget

The estimated budget is a written forecast prepared before the start of the fiscal year, defining how much you expect to sell, how much you expect to spend, and on what line items. It is built on historical data, market forecasts, and growth targets. The actual budget is what happened on the ground: the revenues actually realized and the expenses actually paid. The difference between them is called the variance.

Why Separating the Two Numbers Matters in the Log

Many owners fall into the trap of mixing the two numbers. They post the actual expense and overwrite the original budget with it, the planning trail disappears, and you no longer know whether you overran or not. The golden rule: the estimated budget stays frozen throughout the fiscal year except in formal reallocation cases. Actuals are updated monthly. The difference between them is the raw material for analysis.

The Annual Cycle for Each One

• Estimated: prepared once before the start of the year, reviewed semi-annually, and closed at year end to compare final performance.
• Actual: updated at the end of every month along with the accounting period close, and for some critical line items (such as payroll or rent) may be updated weekly.
• Analysis: monthly always, quarterly for senior management, and annually for shareholders or partners.

Log Components (Date, Line Item, Allocated Budget, Actual, Variance, Percentage, Notes)

An effective log sticks to a fixed structure. Any extra column should serve variance reading, not decorate the table. The seven columns below are the minimum you should never go under in any budget log, whether you run it in Excel or in an accounting system.

What Each Column Does

• Date: the transaction date or the end of the observed period (last day of the month for cumulative line items).
• Line item: the account name from the chart of accounts (rent, payroll, marketing, advisory service revenue).
• Allocated budget: the approved amount for this line item for the period (month, quarter, or year).
• Actual: what has actually been paid or collected up to the log date.
• Variance: the value difference (actual minus budget). Positive means overrun, negative means saving.
• Percentage: variance divided by budget, times 100. Gives a relative picture more meaningful than the absolute value.
• Notes: the reason in brief (Umrah season, late invoice, additional marketing campaign, supplier discount).

A Simplified Log Sample

How to Build the Annual Budget (Bottom-Up, Top-Down, Zero-Based Budgeting ZBB)

Before you start logging transactions, you need to build the original budget. There are three core methods, each suited to a stage in a company’s life and size. Choosing the wrong method produces an unworkable budget and a log full of meaningless variances.

Bottom-Up Method

Every department or manager prepares its own budget based on actual needs, then all are aggregated to form the company-wide budget. It suits companies that rely on decentralized decision-making and gives managers a sense of ownership. The drawback: it can inflate, because every department asks for more than it really needs as a hedge against cuts.

Top-Down Method

Senior management sets an overall ceiling for revenues and expenses, then distributes it across departments. It suits businesses in a cost-cutting phase or those that need strict financial discipline. Fast to prepare, but it may overlook genuine operational needs if management is not close to the field.

Zero-Based Budgeting (ZBB)

Every line item is justified from scratch each year, as if the business started today. No line item is accepted simply because it existed last year. Large corporations use it to cut operating fat, it is exhausting to apply but produces the most disciplined budget. Recommended after two or three years of conventional budgeting once you have spotted unproductive line items.

When to Use Each Method

• Less than a year old: start with Top-Down, your historical data is not enough for Bottom-Up.
• Two to five years old: Bottom-Up with an overall ceiling from management, a good balance.
• Mature business past five years: a mix of Bottom-Up with ZBB every two or three years to clean accumulated line items.

Monthly Variance Analysis (Favorable, Unfavorable, Causes)

Variance Analysis is the real value of the log. The numbers themselves mean nothing, the meaning comes from their interpretation. Every variance must be classified and linked to a cause, otherwise the log turns into an archive instead of a decision tool.

Favorable vs. Unfavorable Variance

A favorable variance is the one that benefits profitability: actual revenues higher than planned, or actual expenses lower than planned. An unfavorable variance is the opposite: lower revenues or higher expenses. The arithmetic sign alone is not enough to judge, you must understand the line item: higher actuals on payroll may be financially unfavorable but operationally favorable if it came from required hiring.

The 10 Percent Rule for Investigation

Any line item whose variance exceeds 10 percent, positive or negative, must have an explanation written in the Notes column. Below that is considered within a normal margin. This rule prevents the analyst from drowning in explaining every riyal and focuses effort on the truly large line items.

The Most Common Variance Causes in the Saudi Market

• Seasonality: Ramadan and the Hajj season lift services and hospitality sales while lowering retail sales in other sectors.
• Late invoices: an expense belonging to January gets invoiced in February, creating a fake overrun in the month of issue.
• Regulatory changes: changes to Phase Two of e-invoicing rules, or Mudad platform updates, may add unaccounted compliance costs.
• Late customer payments: do not change the revenue recognized for accounting purposes, but they create a liquidity gap that shows up in other line items.

Linking the Log to the Income Statement and Balance Sheet

The log does not live in isolation. Every line item in it must have a counterpart in either the income statement or the balance sheet. This linkage is what turns the log from a managerial tool into an integrated financial system and lets the accountant produce statutory reports directly without duplicate work.

Income Statement Line Items in the Log

Everything related to revenues and operating expenses flows into the income statement. Service revenue, payroll, rent, marketing, utilities, annual depreciation. These line items appear in the budget log with their monthly budgets and aggregate at year end to give planned versus actual net income.

Balance Sheet Line Items in the Log

Capital purchases (new fixed assets, equipment, vehicles) do not appear in the income statement all at once, they are spread over the years of depreciation. But they appear in the budget log in the month of purchase in full, because the purpose is to track cash flow and allocation. Same goes for staff advances, refundable deposits, and business loans.

Linkage Table Between the Log and the Statements

Budget Reallocation Between Line Items

A budget is not a sacred contract. During the year you may find that a line item with a large allocation has barely been touched, while another has blown past its ceiling and needs expansion. This is where Budget Reallocation comes in, a formal process with rules that are not left to improvisation.

When Reallocation Is Legitimate

• Shift in priorities: you decide to postpone opening a new branch, you move its budget to digital marketing.
• Real savings: the rent line item saved 20 percent after renegotiating the lease, you move the surplus to training.
• Emergency obligation: a regulatory change from ZATCA imposes a compliance expense, you move funds from lower-priority line items.

When Reallocation Is Not Legitimate

Reallocation cannot be used just to mask an overrun. If marketing exceeds its budget by 30 percent, the answer is not to pull from another line item to muffle the variance, it is to analyze the cause. Likewise, you cannot reallocate from capital to operating line items without documentation, because that mixes what flows to the income statement with what flows to the balance sheet.

Documenting Reallocations in the Log

Every reallocation needs its own row in the log, or a separate sheet, stating: date, source line item, target line item, amount, reason, and approver signature. Without this documentation, the log loses its reference value, and at year end you cannot judge how accurate the original budget was.

A Budget Log for a Saudi Services Company with Realistic Numbers

To make the idea concrete, here is a budget log for a tech advisory firm in Riyadh, with 8 employees, providing software development and data analytics services to the private sector. Numbers are in Saudi Riyals and reflect 2026 market averages.

The Company’s Operating Context

The company works under annual contracts with 6 major clients and short project contracts with 12 mid-sized clients. Monthly revenue fluctuates between 280,000 and 360,000 SAR, with a target of 15 percent annual growth. The budget was built bottom-up with a top-down ceiling on administrative expenses.

Budget Log for March 2026

A Quick Read of the Month’s Results

The month closed with a favorable total variance of 20.1 percent on net income, but a deeper read reveals points worth following: digital marketing with a 52 percent variance needs clear justification (if it produced new contracts it is an investment, if not it is waste). Postponing training produces an apparent saving but may cost the company later in output quality.

Warning Signs from the Log (Variance Above 10 Percent, Repeated Overruns)

A good log is not just a display tool, it is an early warning system. There are specific variance patterns that, when they appear, should stop normal business and escalate the decision to a higher level. Anyone reading the log, owner, accountant, or manager, should know these signals.

The Six Most Dangerous Patterns

• Variance above 10 percent on a single line item: needs a documented explanation in the same month, no postponement.
• Overrun in two consecutive months: no longer an exception, the cause is structural and the budget needs to be re-estimated.
• Payroll variance without a hiring decision: usually driven by accumulated overtime, a signal of team burnout.
• Actual revenues below plan for 3 consecutive months: a pipeline or market problem, calling for a strategic review.
• Marketing overrun with no matching revenue growth: negative ROI, the campaign should be frozen and the channel reassessed.
• Administrative expenses growing faster than revenue: a sign of bureaucracy, the structure is dragging on performance.

Escalation Procedures When a Warning Appears

Every warning must be reported within 5 working days of month-end close. The report contains the line item, the variance size, the cause, and the recommendation (reallocation, budget adjustment, activity halt, additional investment). The report is approved by the finance manager, then logged back into the budget log as a decision documentation row.

The Difference Between Operating and Capital Budgets (OPEX vs CAPEX)

Mixing the two types produces a misleading log that suggests the company is spending more than it can afford when in reality it is investing, or vice versa. Understanding the difference starts with defining each, then moves to how each is treated in the log.

Operating Budget (OPEX)

Covers all the day-to-day expenses needed to run the business: salaries, rent, utilities, marketing, subscriptions, routine maintenance, hospitality. Fully consumed in the financial period it was incurred in, and appears directly on the income statement. It is recurring and highly predictable on a monthly basis.

Capital Budget (CAPEX)

Covers purchases that produce value over years: vehicles, equipment, large office furniture, internal IT system development, real estate purchase, branch expansion. It does not appear in full in the income statement, it is spread across its useful life via depreciation. In the log it appears in the purchase month at full value, because the log tracks cash flow and allocation, not accounting recognition.

Separation Rules in the Log

• Minimum threshold for a capital asset: usually starts at 5,000 SAR with a useful life exceeding one year. Below that is treated as an operating expense.
• Two separate sections in the log: one for OPEX (refreshed monthly) and one for CAPEX (updated only at purchase).
• Dual tracking of the asset: the full value appears in the capital section, while the monthly depreciation charge appears within expenses in the operating section.

The Most Common Mistakes in Maintaining a Budget Log

Years of reviewing logs for small and mid-sized Saudi businesses have revealed recurring patterns of error. Avoiding them upgrades the log from a formality to a real decision tool.

Retroactively Adjusting the Original Budget

The single most common mistake. The person in charge spots an overrun, goes back, and increases the original budget value to muffle the variance. This practice destroys the log’s control value entirely. The rule: the original budget is frozen. The adjustment is logged in a separate row labeled “Re-estimation” with the approver’s signature.

Mixing Personal with Business

In small sole-proprietor businesses, the owner pays personal expenses from the business account and the lines blur. Accounting separation between the business’s accounts and the owner’s personal accounts is a prerequisite before the log means anything.

Ignoring Small Accumulating Line Items

A hospitality line item at 200 SAR per week looks like nothing, but over a year it is 10,400 SAR. Ignoring these line items creates a large annual gap between the log and reality. Every riyal spent must belong to a line item, even one called “Miscellaneous” with a clear monthly ceiling.

Not Linking the Log to an Accounting System

Keeping the log manually in Excel while keeping the accounting entries in a separate system produces two different numbers at month end. A good log imports actuals directly from the accounting system via export or API link, so the two numbers always match.

Not Analyzing Favorable Variances

A positive variance is celebrated and forgotten. But an unexpected saving may be a sign of a problem: a late invoice, an undelivered service, a hire that did not happen. Analyzing the positive is just as important as analyzing the negative.

How Qoyod Links the Log to the Budget and Generates Analysis Automatically

Moving from a manual log in Excel to an accounting system that links the budget to the entries automatically saves hours every week and eliminates the risk of human error. Qoyod integrates the budget and the log into one system, so you no longer move numbers manually between files.

Enter the Budget Once at the Start of the Year

The annual budget is entered, distributed monthly across each line item in your chart of accounts. The system accepts the budget bottom-up or top-down, and lets you reallocate later while documenting every change, who made it, and when.

Actuals Update Automatically from Daily Entries

Every invoice recorded, every payment voucher approved, and every revenue collected is instantly reflected on its line item in the budget log. No need to close the month first to see the variance, the number speaks in real time.

Ready-Made Variance Reports

The Budget vs Actual report is generated from the reports screen with a single click for any month, quarter, or custom period. It displays the budget, actual, variance by value and percentage, with color coding (red for overrun above 10 percent, green for on-target, yellow for caution). Exportable to Excel or PDF.

Alerts on Critical Line Items

You can flag critical line items (such as marketing, travel, hospitality) and turn on an alert that reaches you the moment the actual approaches 80 percent of the monthly budget. This flips your relationship with the log from reactive (after the overrun) to proactive (before it).

E-Invoicing and Business Zakat in the Same System

Since Qoyod is approved by the Zakat, Tax and Customs Authority (ZATCA) for Phase Two of e-invoicing, the actual revenues coming from your approved invoices feed directly into the log without duplicate work, and are filed in the tax return with the same numbers. The pricing tiers starting from Qoyod plans include these features for small and mid-sized businesses.

Frequently Asked Questions

What is the difference between a budget transactions log and the general ledger?

The general ledger aggregates all accounting entries organized by account under double-entry, with the goal of producing statutory financial reports. The budget transactions log has a purely managerial goal: compare planned to actual and analyze the variance. The first is mandatory in accounting, the second is optional but essential for management. The two complement each other, they are not substitutes.

Do I need an accountant to keep the log, or is the owner enough?

For very small businesses (fewer than 5 employees), the owner is enough if they have basic numeric literacy and a thought-out budget. For businesses with 5 to 20 employees, a part-time accountant or financial analyst is preferred. For larger businesses, a full-time financial planning and analysis officer becomes necessary.

How often should the log be updated?

The minimum is once a month with the accounting period close. The optimum is weekly for critical line items (sales, marketing, travel). Fixed line items such as rent only need monthly updates. The more frequent the update, the higher the chance of catching variances early.

How do I handle unexpected expenses that were not in the original budget?

Add a new row in the log under “Emergency line items” or under the closest line item by nature. Document the cause in the Notes, and consider it an unfavorable variance for its full value. If it recurs in two consecutive months, a formal line item must be added to the budget and allocations adjusted.

Should I include VAT in the log as part of the expense?

No, the budget is built on pre-VAT values because the 15 percent VAT paid is recoverable for VAT-registered businesses. VAT shows up in a separate account (input/output) within the accounting system, not in the budget log. The exception: businesses not registered for VAT include the tax as part of the expense.

What is a reasonable timeframe to prepare the annual budget?

For small businesses: two weeks to a month. For mid-sized businesses: two to three months. It usually starts in the last quarter of the fiscal year (October to December) so it is ready before January. Delaying preparation until after the year starts strips the log of its value in the critical first months.

How do I handle the variance when customer collections are delayed?

If the customer pays late, the revenue recognized in accounting does not change (it remains within realized revenues), but cash flow is affected. In the log, planned revenue versus actual revenue stays matched, and a note is added about the liquidity impact. Tracking accounts receivable aging (Aging Report) is a complementary tool to the budget log in this case.

When do I fully re-estimate the annual budget?

A full re-estimation happens when: a fundamental change in business size (new branch opening, product line shutdown), a major regulatory change from competent authorities (VAT rate increase, labor system amendment), or a total overrun exceeding 25 percent in the first half of the year. Re-estimation is not a routine process, it is an exceptional, documented step.