Ratios and the Finance Scorecard

1Finance measures and business questions

A managed services provider (MSP) earns money from technology services and products. The profit and loss statement reports earned revenue and expenses for a period. The balance sheet reports assets, liabilities and equity at a date. A finance scorecard selects a small set of measures from those records and related operational records so the business can review results regularly.

A ratio compares two quantities by dividing one by the other. A percentage ratio expresses the result per hundred. A useful ratio has a clear numerator, denominator and period. Revenue for one month divided by costs from another month answers no clear margin question. A balance sheet amount at a date also needs an appropriate comparison when it is used with a period's revenue.

Begin each measure with a business question. Gross margin can help investigate how much revenue remains after the direct delivery and product costs in the company's classification. Operating margin can help investigate the amount remaining after operating overhead. A receivables aging report can identify invoices needing collection work. The measures answer different questions and should keep their definitions visible.

QuickBooks Online supplies accounting reports. Syncro supplies contract, service and billing information. Excel can calculate and present the measures. The admin manager prepares the scorecard with source dates and checks the calculations. The CEO leads decisions about prices, staffing, investment and cash commitments. The scorecard should let both people explain a change and agree what evidence is needed next.

2Gross and operating margins

Gross profit is revenue minus the direct delivery and product costs under the stated classification. Gross margin is gross profit divided by revenue. Operating profit is gross profit minus operating overhead. Operating margin is operating profit divided by revenue. The classification of payroll, benefits and other expenses affects these margins, so use the same accounting basis each month.

The supplied January through September 2026 accrual export reports revenue of $1,109,891.18 and gross profit of $357,386.64. Dividing gross profit by revenue gives approximately 32.20% gross margin. Operating income is $100,144.81, giving approximately 9.02% operating margin. These are calculations from the supplied aggregates. The completed calendar months have not been confirmed as approved monthly closes.

September reports revenue of $150,866.87 and gross profit of $44,030.45. September gross margin is approximately 29.19%. Operating income of $9,168.21 gives approximately 6.08% operating margin. A lower margin than the nine-month figure is a reason to investigate the mix of revenue and costs. It does not establish a staffing or pricing problem by itself.

A weighted period margin uses total period profit divided by total period revenue. Use that calculation for the January through September result. Averaging the nine monthly percentages would give each month equal weight even though the revenue amounts differ. Keep the weighted total and the monthly series available so the CEO can see both the overall result and changes within the period.

The company financial reference records the supplied aggregate figures, reporting periods and missing supporting records. Use that reference when checking this lesson's company calculations.

3Liquidity and the current ratio

Liquidity is the ability to meet payments as they come due. A current asset is expected to be converted to cash, sold or used within the relevant short-term classification. A current liability is an obligation classified as due within that period. The accountant determines the correct classification for the company's reporting basis.

The current ratio is current assets divided by current liabilities. Working capital is current assets minus current liabilities. These measures compare balance sheet amounts at the same date. Cash is one component of current assets. Receivables and some other current assets may take time to become usable cash.

The supplied September balance sheet reports current assets of $375,155.70 and current liabilities of $88,994.30. The reported current ratio is approximately 4.22. Reported working capital is $286,161.40. Label both as calculated from the reported classifications. The supplied file does not establish whether the current portion of long-term debt and all other required adjustments are included.

September reported bank balances total $364,295.70. That amount is a starting figure for reconciliation and payment planning. The amount available for a new commitment depends on cleared transactions, payroll, taxes, card payments, debt, client deposits and other commitments. A high current ratio cannot tell the CEO which week an overdue client will pay or whether a particular cash balance is restricted. Use the dated cash forecast for payment decisions.

4Receivables and recurring revenue measures

Accounts receivable is the amount recorded as owed by customers. An aging report groups unpaid balances by age or due status. The aging report should reconcile to the receivables control total in the accounting record. The admin manager uses the detail to identify disputed, overdue or misapplied invoices.

Days sales outstanding (DSO) is an estimate of collection time calculated using a stated receivables balance and revenue basis. One version divides average receivables by credit revenue for a period, then multiplies by the days in that period. Use an agreed formula and label the inputs. Revenue mix, credits, upfront billing and the choice of ending or average receivables can change the result. The supplied aggregates do not establish the credit-revenue basis needed for a reliable company DSO calculation.

Monthly recurring revenue (MRR) is a contract-based monthly value of recurring services under a stated definition. The supplied profit and loss report's recurring revenue category is an earned-revenue account total. It does not by itself establish committed MRR. Discounts, one-time adjustments, service dates and contract changes may produce differences. Reconcile the signed contract schedule to billing and accounting before placing an MRR measure on the scorecard.

The supplied September recurring revenue category is $106,456.25. That amount can be shown as the reported account total for September. Label the figure accordingly. The supplied October 1-6 recurring revenue is $106,417.33, but the company bills on the first day of the month. Comparing those amounts as if they represented two completed monthly service results would ignore the reporting dates and the billing cycle.

5Scorecard definitions and review rules

A measure definition states the formula, source, period, responsible preparer and review action. A target is an outcome the business intends to achieve. A review threshold is a condition that prompts investigation. The CEO chooses targets and thresholds using the company's circumstances and approved plans. The course does not supply an industry percentage as a company rule.

Measure	Question	Required context
Gross margin	What remains after stated direct costs?	Cost classification and revenue mix
Operating margin	What remains after operating overhead?	Complete expenses and period
Overdue receivables	Which unpaid invoices need action?	Reconciled aging and disputes
Lowest forecast cash	When could payments exceed cash?	Dated assumptions and commitments

Choose the smallest set that supports the regular finance conversation. Add contract MRR, client contribution or delivery capacity when their supporting records are reliable. A measure requiring unreliable time records should include a data-quality note until the records improve. A missing figure should remain explicitly unavailable instead of becoming zero.

Show actual results, the agreed comparison and an explanation of important changes. A comparison can be an approved plan, the previous completed period or the same period in the prior year. Keep the basis consistent. Color can help draw attention, but the explanation should still make sense without color. A reader needs the amount, reason and next action in ordinary words.

6Partial periods and unusual balances

A partial period includes only part of the reporting month. Revenue and expense entries may arrive at different points in that period. The supplied October 1-6 export reports high income while some wage entries are blank. The CEO says payroll synchronizes after the fifth and fifteenth. Those are synchronization timings, rather than confirmed bank payroll payment dates.

Do not present the partial October operating margin as evidence of a permanent profitability improvement. Complete the expense review, confirm the reporting cutoff and investigate missing entries before relying on the month. The calendar date and the accounting close status should appear together on the scorecard. An elapsed calendar month also needs its close checks before being described as approved.

The supplied July and August aggregate receivables balances are negative. Negative receivables can arise from credits, unapplied receipts, presentation choices or errors. The aggregate alone does not identify the cause. Request customer-level detail and reconcile the balances. Avoid interpreting a negative balance as exceptionally fast collections or using the value mechanically in a collection-time ratio.

Ratios become misleading when a denominator is zero or changes sign. A gross margin percentage cannot be calculated in the usual way when revenue is zero. A report should explain the condition rather than show a fabricated percentage. Keep unusual records in the exception list so the admin manager can resolve the cause and the CEO can understand the limits of the current scorecard.

7Finance scorecard practice

Use the supplied January through September and September-only aggregates in the company reference. Treat the results as reported figures awaiting close confirmation. Keep October separate as a partial period.

Calculate January through September gross margin and operating margin using the total period figures.
Calculate September gross margin and operating margin using only September figures.
Calculate September working capital and current ratio from the reported current classifications.
Write one limitation for each of the three groups of calculations.
Choose four measures for an initial scorecard and specify each measure's source, formula and review question.

Check your work

Period gross margin is $357,386.64 / $1,109,891.18, approximately 32.20%. Period operating margin is $100,144.81 / $1,109,891.18, approximately 9.02%. September gross margin is $44,030.45 / $150,866.87, approximately 29.19%. September operating margin is $9,168.21 / $150,866.87, approximately 6.08%.

Reported working capital is $375,155.70 - $88,994.30 = $286,161.40. Reported current ratio is $375,155.70 / $88,994.30, approximately 4.22. Close approval and classification review remain outstanding. The lower September margins need a revenue and cost explanation before a business conclusion.

A useful initial scorecard could contain gross margin, operating margin, overdue receivables and lowest forecast cash. The last two require additional dated records. Mark them pending until those records are available. The chosen measures should lead to clear review questions and a named preparer.

8Your company scorecard

The admin manager prepares a draft scorecard from the latest reviewed accounting period. Attach the source report date, accounting basis and close status. Include the definition of each measure and keep the calculation file in the approved finance location. Link to the reconciled aging and cash forecast instead of replacing those details with a single unexplained indicator.

The CEO reviews which measures influence current decisions. Agree which changes require investigation and who supplies the explanation. Do not choose a target merely because another MSP reports that number. The company's client mix, cost classification, debt and growth plans determine which comparisons are useful.

The deliverable is a scorecard with documented definitions, supported figures and a short exception list. Include one action for an observed change and one action for a missing input. A successful review lets the admin manager explain the calculation and the CEO explain what business question the measure helps answer.

9Going deeper

Going deeper

A cash reserve measure compares available cash with a defined future expense or payment requirement. The definition needs to state which cash is available and which costs belong in the denominator. Dividing a bank balance by an average monthly expense can provide a rough historical comparison, but payment dates and upcoming commitments may differ from the average. Use a dated forecast before approving a cash commitment.

Benchmarks require comparable definitions. A reported service margin from another business may exclude owner labor, allocate benefits differently or include hardware revenue. Before comparing percentages, identify the reporting basis and included costs. A consistent internal series can reveal a change even when an external benchmark is unavailable. The next step is investigating the cause of the change, rather than assuming the comparison itself explains the business.

10The completed work

A finance scorecard with definitions, supported figures and an exception list.

Keep approved company work in your finance workspace. The course records study progress in this browser; it does not store your reports or forecast files.

12Glossary

Ratio: A comparison calculated by dividing one quantity by another.
Finance scorecard: A selected set of regularly reviewed measures from financial and related operational records.
Gross margin: Gross profit divided by revenue, expressed as a percentage.
Operating margin: Operating profit divided by revenue, expressed as a percentage.
Liquidity: The ability to meet payments as they come due.
Current ratio: Current assets divided by current liabilities at the same reporting date.
Working capital: Current assets minus current liabilities at the same reporting date.
Receivables aging: A report grouping unpaid customer balances by age or due status.
Days sales outstanding: An estimated collection-time measure using a stated receivables balance, credit-revenue basis and period.
Monthly recurring revenue: A contract-based monthly value of recurring services under a stated definition.
Review threshold: A condition agreed by the business that prompts investigation.
Partial period: A report covering only part of its usual reporting period.

13Sources

Company examples use the accrual reports supplied on October 6, 2026. Report periods, selected totals and limits are recorded in the company reference. Examples labeled practice use hypothetical inputs.

SEC: Financial statements: Definitions and relationships among financial statements and ratios.