Compare Planned and Actual Spending on the Same Basis

Start with a comparison that can actually answer your question

A spending total can differ from a plan because prices changed, quantities changed, a purchase moved between months, or the two columns cover different things. Those explanations need different follow-up questions. Before describing an amount as an overrun or a saving, establish what the comparison includes. The goal of this guide is a readable explanation of a difference, not a verdict about the person who spent the money. A smaller number can reflect a missing bill, a deferred purchase or a narrower export rather than a lasting improvement.

This independent website guide uses wholly fictional household purchases. It is not a passage from Buying Wealth, an account of a reader's finances, or a recommendation to buy, cancel, borrow or invest. All amounts use one invented reporting currency. The simple quantity-and-price examples assume comparable items, complete amounts and no separate taxes, credits or delivery charges. Real records often fail those assumptions. The right response is to identify the missing definition before extending the arithmetic, rather than to make the table look complete by guessing.

The CFPB toolkit lists separate tools for tracking spending, using a bill calendar and creating a cash-flow budget. That separation is useful here: recording what happened, identifying when money moves and comparing a result with a plan are related tasks with different outputs. Our exercise begins after the fictional amounts have been assembled. It does not verify transactions, connect to accounts, establish available cash or decide which obligations should be paid. Keep the underlying records and the comparison question visible together.

Write the period and inclusion rule above both columns

Suppose the question is how much eligible spending differed from a plan for one fictional month. Define eligible spending before adding the amounts. Does it mean purchases made during that month, payments leaving an account during that month, or items consumed during that month? These are different reporting conventions. A purchase made on the final day can be paid later. A prepaid item can be used later. Choose the convention appropriate to the question and use it consistently; this guide does not select an accounting policy for your circumstances.

Include the exact start and end dates, currency, categories and treatment of refunds. Identify which accounts or source files are included. If one column covers a household and the other only one person's card, label that limitation instead of interpreting the gap as behavior. A card payment can represent purchases already listed elsewhere, so combining both indiscriminately can count the same activity twice. A transfer between a person's own accounts also needs a stated treatment. This educational comparison does not turn every cash movement into a consumption expense.

Keep the original plan as a dated version. If you revise expectations during the month, show that revised version in another column. Replacing the old plan with the result removes the reference point and can make every difference appear to vanish. A revision can be useful for understanding changed circumstances, but it should not silently rewrite what the original comparison meant. Label an original plan, a revised estimate and a recorded result separately, including the information available when each was prepared.

Use one sign convention and explain it in words

For this guide, the signed spending difference is actual amount minus planned amount. A positive difference means the recorded amount is higher than the plan. A negative difference means it is lower. Neither sign means good or bad by itself. A necessary purchase could be higher than expected; a lower payment could be late or missing. Put the sign rule in the table caption so a reader does not import the opposite convention from another report. Describe the direction explicitly when sharing a result.

A fictional plan of 200 and recorded amount of 230 produces a difference of positive 30. Dividing 30 by the planned 200 gives 15 percent above plan. That percentage uses the plan as its denominator. Dividing by 230 would answer a different question: the difference as a share of the recorded amount. Both divisions are possible arithmetic, but a label such as percent over plan requires the planned denominator. Show the amount difference before the percentage so readers can see the scale.

When the planned amount is zero, the usual percentage-over-plan formula has a zero denominator. Report the amount difference and mark the percentage as not defined under that formula. Do not replace it with zero percent, infinity or a made-up comparison rate. When the plan is small, a large percentage can accompany a small amount. When the plan is large, a modest percentage can still represent a large amount. The amount and percentage provide complementary descriptions rather than a universal priority score.

Work through an original four-line fictional schedule

The downloadable practice file has four rows. Fictional meal packs were planned at ten packs costing eight each, for a planned 80. The recorded case has twelve packs costing nine each, for 108. Fictional transit trips were planned at twenty trips costing three each, for 60; the recorded case has sixteen trips at the same price, for 48. These invented prices are not offers, fares, market observations or forecasts. Their round numbers make the comparison reproducible with a pencil or spreadsheet.

A fixed fictional membership line is 40 in the plan and 40 in the recorded case. A household-items line is an amount-only plan of 70 and recorded amount of 54. That last row deliberately has no comparable quantity or unit-price information. The four planned amounts total 250, and the four recorded amounts total 250. The overall difference is zero. Yet the individual differences are positive 28 for meal packs, negative 12 for transit, zero for membership and negative 16 for household items. Those signed differences also sum to zero.

The unchanged total does not mean nothing changed. Different category movements offset one another. Nor does it prove the fictional household met every need, maintained the same quality or followed an appropriate spending plan. A total is a useful reconciliation point, but it hides composition. Show both the total and its component differences. If a summary says all categories were on plan because the grand totals match, it is inconsistent with the visible schedule even though the grand-total arithmetic is correct.

Separate quantity and price with a stated bridge

For the meal-pack row, the planned amount is ten times eight, or 80, and the recorded amount is twelve times nine, or 108. First change quantity while holding the planned price: twelve times eight equals 96. Moving from 80 to 96 gives a quantity component of 16. Then change the price at the recorded quantity: twelve times the price increase of one gives a price component of 12. The two components, 16 and 12, add to the full difference of 28.

This bridge uses planned price for the quantity step and recorded quantity for the price step. Its identity is quantity component equals recorded quantity minus planned quantity, multiplied by planned price; price component equals recorded price minus planned price, multiplied by recorded quantity. Adding them reconstructs recorded cost minus planned cost. State that sequence because other valid decompositions allocate the interaction differently. A bridge is an explanatory convention. It does not discover a causal reason that a person bought more or a seller charged differently.

The transit example is simpler. Sixteen rather than twenty trips at a fictional price of three produces a quantity component of negative 12. Because the price is unchanged, the price component is zero. Together they reproduce the row difference of negative 12. This says the recorded quantity is lower within the example's definitions. It does not show that fewer trips were desirable, that transport needs were met, or that the difference will recur. Those questions require information absent from the practice file.

Compare a different bridge without changing the total

You can reverse the sequence for the meal-pack example. First hold the planned quantity of ten while changing price from eight to nine: the amount moves from 80 to 90, a price step of ten. Then increase quantity from ten to twelve at the recorded price of nine: the amount moves from 90 to 108, a quantity step of eighteen. Ten plus eighteen still equals the same total difference of 28. The earlier sequence assigned twelve to price and sixteen to quantity.

The two-unit quantity increase multiplied by the one-unit price increase creates an interaction of two. Each sequence places that interaction in a different component. Neither changes the original or recorded amount. If two reports disagree about the components, compare their sequence before declaring an arithmetic error. Use one declared bridge consistently across comparable rows, and retain the full signed difference as the common reconciliation point. Do not add components from both sequences; doing so would explain the same difference twice.

Understand what the intermediate comparison changes

OpenStax describes flexible budgets in a business setting as comparisons adjusted for an activity level. The useful idea for this limited exercise is to distinguish a change in activity from a change in the amount per unit. We are borrowing that comparison structure for two invented purchase rows, not treating a household as a manufacturing business or reproducing the textbook's examples. We do not assign household performance ratings or claim that every cost responds proportionally to activity. Many costs require a different model.

For the two quantity rows together, the original planned amount is 140: 80 for packs and 60 for trips. At recorded quantities but planned prices, the intermediate amount is 144: 96 for packs and 48 for trips. The recorded amount is 156: 108 plus 48. The activity step is therefore positive four overall, and the price step is positive twelve. Their sum of sixteen matches the difference between 156 and 140. A lower transit quantity partly offsets the higher pack quantity without erasing either movement.

Add the membership 40 and the amount-only household-items plan 70 to the intermediate 144 and the partial comparison becomes 254. The recorded total remains 250. The remaining difference of negative four consists of the pack price component positive twelve and the unexplained amount-only difference negative sixteen. Call this an intermediate comparison with a partial decomposition. Do not label the full negative four a price effect: the household-items row has no quantity or unit-price detail that would support that attribution.

Leave amount-only rows honestly unexplained

The household-items difference is 54 minus 70, or negative sixteen. That subtraction is supported. Splitting the sixteen between fewer items, lower prices, changed item mix, discounts, refunds or timing would require additional comparable details. A spreadsheet can generate numbers for those explanations, but a formula cannot create the missing observations. Preserve an unallocated amount difference and list the records that would be needed to explain it. An explicit unresolved amount is more informative than an apparently complete bridge based on invented quantities.

Even a count of items may be insufficient if their sizes or contents changed. Two containers are not automatically comparable units when one contains twice as much. A switch between products can change quality, purpose or package size. Decide whether a common unit is meaningful and available before applying a price-times-quantity identity. If comparability is uncertain, describe the amount movement without pretending it measures a pure price change. The practice file's uniform packs are a teaching assumption, not a claim about ordinary shopping data.

Do not force the fixed membership into a per-use calculation to explain its unchanged payment. Dividing a payment by visits can answer an average-cost question, but visit counts do not necessarily determine the amount due. An unchanged 40 with fewer visits still has a zero payment difference in this schedule. Whether the membership suits a person's needs is a separate renewal decision. Preserve that separate question instead of using a budget comparison to imply a recommendation about access, cancellation or personal priorities.

Check timing before calling a difference permanent

Imagine a separate version of the household-items example in which the missing sixteen appears in the following month's records. That is a hypothetical timing explanation, not another row in the downloadable base file. The current month's amount remains 54 under a payment-date convention, while a two-month comparison may show a different pattern. The observation would not retroactively change the original 250 total unless the reporting rule or underlying records were corrected. Keep the initial result and the later explanation distinguishable.

A planned monthly allocation for a less-frequent purchase also differs from the month in which money is actually paid. A planning allowance spreads an expected amount across periods; a payment record shows a particular cash movement. Comparing an allowance with a payment can be useful if labeled, but it is not automatically a failure when the payment month is higher. Use the separate less-frequent-expense guide for allowance and due-date questions. This guide focuses on explaining differences after the comparison's basis has been selected.

A refund or reversal needs a consistent sign and period treatment. If a purchase appears in one month and a refund in another, a single-month net amount can be misleading without that context. If a record is pending or disputed, identify its status. Do not treat an expected refund as cash already received, erase a valid original purchase without explanation, or infer that a charge can be ignored. This guide teaches report reading; it does not determine payment obligations, dispute rights or accounting treatment.

Build a short explanation that survives being copied

A useful summary preserves the total, the offsets and the unresolved questions. For the fictional file, write that planned and recorded totals both equal 250, while meal packs are 28 higher, transit 12 lower and household items 16 lower. Explain the pack bridge as 16 from quantity at the planned price plus 12 from the price step at recorded quantity. State that household items remain amount-only. This is longer than saying on budget, but it allows a reader to reconstruct the result without inventing a story.

An authored weak summary would say lower transport spending funded better food choices and proved successful budgeting. The data shows neither funding causality nor better choices nor success against personal needs. That sentence is an example written for this guide, not an output observed from an AI system. If you use an assistant to draft a summary, give it the sign convention, period, row definitions and known unknowns. Then compare every numerical and causal statement with the source schedule before sharing. Fluent prose does not verify a financial interpretation.

Keep a compact handoff containing the original plan version, source coverage, comparison convention, four-row schedule, signed differences and unresolved amount-only row. Remove personal account numbers and unnecessary identifying information from any practice or shared file. The downloadable example already uses invented categories and values. It has no account connection, upload feature or automated action. Replacing the fictional data with sensitive records changes the privacy context, so use an appropriate working environment rather than assuming a public teaching asset provides a private financial workflow.

Use the comparison to ask the next factual question

The first follow-up might be whether the quantities cover comparable items. Another might be whether an amount-only row includes a refund or whether a purchase was recorded in the wrong period. Ask questions tied to a specific uncertainty instead of selecting a target percentage from the table. An overall zero difference may still deserve explanation because its offsets are large; a nonzero difference may have a straightforward scope explanation. The table alone supplies no universal materiality threshold, emergency-fund target or instruction to change spending.

Once missing records are resolved, preserve the earlier version and note the correction. Recalculate both row amounts and the total bridge. If the question changes from original-plan comparison to next-month forecasting, start a separately labeled analysis with new assumptions. Do not carry a one-month price or quantity movement into every future month as though persistence had been established. A reproducible historical comparison is a foundation for a clearer conversation, not a forecast, financial approval or proof that a particular action will improve wealth.

Frequently asked questions

Does a zero total difference mean every category matched the plan?

No. In the original fictional file, the total difference is zero because positive 28, negative 12, zero and negative 16 offset. Three of four rows differ from their plans. Read the components alongside the total, and distinguish arithmetic reconciliation from a judgment about whether the spending served the person's needs. The file contains no information that could establish that broader judgment.

Which denominator should a percent-over-plan calculation use?

Use the planned amount when that is the stated question, and show the signed amount difference first. A difference of 30 on a plan of 200 is 15 percent above plan. A zero planned amount makes this particular percentage undefined. A negative planned amount or an unusual credit convention requires further explanation rather than an automatic label copied from a positive-expense example.

Can I split every amount difference into quantity and price?

Only when you have meaningful comparable quantities and prices and a model that fits the row. The household-items example has amount totals only, so its negative sixteen remains unallocated. Taxes, fees, bundles, package changes and refunds can require separate treatment. Do not invent unit information to make a bridge balance; preserve the supported amount comparison and describe the missing evidence.

Is the intermediate amount a replacement for the original plan?

No. It is a separately labeled comparison calculated using recorded quantities and planned prices for two rows. The original plan remains 250. The intermediate partial comparison is 254, and the recorded total is 250. Those columns answer different questions. Keeping all three visible prevents the activity adjustment from silently rewriting what was originally expected or implying that every remaining difference is a price effect.

Does lower spending establish savings that will repeat next month?

No. Lower recorded spending can reflect quantity, timing, scope, refunds or incomplete information. A permanent reduction is a separate claim needing support. The fictional schedule provides no future observations, account balances or assessment of unmet needs. Use a bill calendar for timing, an expense plan for less-frequent allowances and a separately stated forecast if you need to explore future scenarios.

Can an AI assistant decide what caused the differences?

It can help organize a draft explanation, but it cannot recover absent facts from a total. Require it to preserve the definitions, offsets and unresolved rows, then check the draft against the actual records. The authored examples here are not observed model results or an evaluation of any product. No narrative generated from this file authorizes spending, posting entries, cancelling services, borrowing or changing a financial plan.