Blog · Topic
Roll-ups that add up, exports that do not, and the checks that catch the difference.
Match two business exports by a stable key and separate missing records from changed amounts. Use exact-match formulas, duplicate checks and a reconciliation that explains the full difference between the source totals.
Oct 25, 20266 min readDemand forecasting data starts with orders, shipments and stock availability at a consistent SKU and period. Use a worked example and spreadsheet checks to find missing history, duplicate rows and unexplained differences before accepting a forecast.
Oct 25, 20265 min readCompare missing fields, duplicate records, and failed checks without counting the same problem twice. This worked example shows source-level measures, a reconciliation, and the effect of changing one input.
Oct 24, 20266 min readStocktake analysis compares physical inventory counts with the inventory book at the same cutoff. Use a worked distributor example to calculate quantity and value differences, investigate exceptions and reconcile the totals before posting adjustments.
Oct 24, 20265 min readSupply chain visibility metrics measure milestone completeness and status freshness in operational records. Work through shipment coverage, missing events and stale status checks by supplier and lane.
Oct 24, 20266 min readChoose customer analytics data sources by the question each export can answer. Check customer identifiers, record uniqueness, dates, and unmatched revenue before combining results.
Oct 22, 20265 min readReconcile inventory counts with receipts, sales, returns and transfers by store and SKU. Use exact spreadsheet formulas to value recorded discrepancies and identify exceptions for investigation.
Oct 20, 20265 min readFlag repeated transaction keys in a Google Sheets ledger export with COUNTIFS. Separate review candidates from confirmed duplicates, preserve reversals, and reconcile the retained amount.
Oct 17, 20265 min readFinancial anomaly detection compares ledger amounts with prior periods and explicit review thresholds. Follow a worked expense review, spreadsheet formulas and a reconciliation that keeps unusual transactions visible until someone explains them.
Oct 12, 20265 min readCheck finance workbooks for missing periods, duplicate journal lines, incomplete mappings and totals that fail to reconcile. This walkthrough gives exact spreadsheet formulas, a small ledger example and a clear release checklist.
Oct 10, 20265 min readCheck a business workbook for missing fields, inconsistent identifiers, invalid dates and repeated records. Follow a worked invoice export through source-total reconciliation and an evidence-based exception review.
Oct 9, 20265 min readUse a practical checklist for cleaning an Excel spreadsheet before business analysis. Check dates, identifiers, amounts, missing values and duplicates, then reconcile the retained records to the source.
Oct 7, 20264 min readDefine renewed, lost, pending and late statuses at a stated cutoff. Preserve snapshots so renewal reports remain explainable.
Oct 6, 20263 min readDistinguish order customer, invoice recipient, delivery location and documented contracting entity, with a synthetic invoice and no duplicated revenue.
Oct 6, 20264 min readMeasure missing, vague and evidenced loss reasons before interpreting why clients left. Weight completeness by prior agency income.
Oct 5, 20263 min readMatch prior and renewal terms and flag changed exposure, limits, periods and cover before interpreting premium movements.
Oct 5, 20263 min readPrevent premium and commission duplication when invoices and carrier statements have several rows for one policy.
Oct 4, 20263 min readAvoid counting endorsements as new policies. Separate policy terms, transactions and reporting snapshots with a worked agency example.
Oct 4, 20263 min readUse dated producer assignments for historical book reports. Separate current ownership from the owner at the original reporting date.
Oct 4, 20262 min readJoin agency policy and accounting files using a reviewed ID crosswalk. Measure unmatched value and prevent row multiplication.
Oct 3, 20263 min readSeparate coverage-period and accounting-period views. Bridge effective and posted dates instead of calling their differences errors.
Oct 2, 20263 min readFinancial data reconciliation matches records across financial sources and explains every difference. Follow a subledger-to-ledger example, spreadsheet formulas and a closing control that proves the totals.
Oct 2, 20265 min readNormalize agency line codes without losing package and coverage detail. Keep unmapped values visible and prevent overlapping totals.
Oct 2, 20263 min readShow extract age and business-event lag separately. A fresh upload can still contain old policy or commission data.
Oct 2, 20263 min readFind duplicate insurance client records without merging distinct insured entities. Preserve an audit trail and restate affected metrics.
Oct 1, 20263 min readExplain why closed agency reports change after late endorsements. Use snapshots and a revision bridge to preserve trust.
Sep 30, 20263 min readMarketing data connects spending and recorded activity with agreed business outcomes. Learn which exports and identifiers to collect, how to test their readiness and how to reconcile costs and revenue before interpreting campaign results.
Sep 30, 20265 min readA dashboard audit checks whether reported measures match their source rows and agreed definitions. Follow a reconciliation from exported records to a corrected dashboard total, with spreadsheet formulas and an evidence checklist.
Sep 29, 20264 min readPrepare policy, client and income exports for agency analytics. Match periods, keys and totals before uploading a sample.
Sep 29, 20263 min readFind a balance-sheet difference by checking the trial balance, account mapping, current-period profit, and opening balances in order. A worked example shows how a balanced ledger can still produce an incomplete statement.
Sep 27, 20265 min readCompare Excel data cleaning tools for missing values, inconsistent names and duplicate business records. Use a small invoice export to choose a method and prove what changed.
Sep 27, 20266 min readA cash flow statement must reconcile to the same cash population on the balance sheet. Follow a worked reconciliation through restricted cash, opening balances, noncash purchases and exchange effects.
Sep 26, 20265 min readCompare each monthly ledger balance with its supporting schedule. Build an account reconciliation, explain differences and prove the remaining exception balance.
Sep 26, 20264 min readABC inventory cycle counting uses approved classes to organize count priorities and assess the results. Compare the items due with completed counts, then separate exact matches, net adjustments, and gross dollar discrepancies.
Sep 1, 20265 min readA data quality dashboard shows which business-file checks failed and who should resolve them. Work through missing fields, duplicates, invalid values, and control-total differences without hiding overlapping errors in one score.
Aug 17, 20266 min readThe complete out-of-stock inference on one SKU at one store over thirty days, small enough to check by hand: the SKU's own daily sales rate excluding earlier inferred runs, the probability of a zero-sales run of each length at that rate, the confidence threshold, the run that crosses it and the run that does not, lost units at the rate and lost sales at retail, the missing-file day that is not a zero, and why the same run at a slow-selling SKU would not be inferred, so a reader can reproduce every figure and then run it on their own sell-out data.
Aug 15, 20263 min readThe complete estate currency calculation on ten customer sites for one B2B telecom account, small enough to check by hand: the services on the estate record, the services on the billing file, the join on the service reference, the orphan billed but not on the estate, the ghost on the estate but not billed, the site whose circuit was ceased and still on the record, the currency rate as services that agree over services on either file, the revenue on the orphans, and the assertion that estate services equal matched plus ghosts and billed services equal matched plus orphans, so a reader can reproduce every figure and then run it on their own estate and billing exports.
Aug 12, 20264 min readThe five checks that make a sales roll-up agree with the reported number: value is numeric, every level is filled, the hierarchy is a tree, no duplicates, and level totals equal the grand total. With the variance each one produces when it fails.
Aug 8, 20264 min readFind repeated ledger rows with a transaction key and COUNTIFS. Work through a checked example, preserve the original export, and send possible duplicates for human review.
Aug 5, 20264 min readEvery report on this site rests on an identity, a sum that must hold before any measure is read, and the sum is different on every desk: revenue to the ledger, TEU to booked TEU, seats to contracted seats, controls to the register, rental days to invoiced revenue. This hub gives, for twelve industries, the identity, the exports it joins, the failure it most often catches, and the guide where it is used.
Aug 3, 20263 min readHow a forwarder builds one customer view across ocean and air without ever adding a container to a kilogram: mode as a dimension, units per mode, reconciliation per mode to invoiced volume, revenue as the only figure that sums across modes, and the reporting mistakes that follow when the two are blended.
Aug 2, 20262 min readThe ten questions a head of sales operations asks before anything is reported, does the CRM reconcile to the ledger, does every account have one owner, do the territories' quotas sum to the target, are the splits summing to one, is the pipeline clean, has any identifier drifted, which reps' data can be believed, did the definitions change, did the export match its control total, and what is on the exception list, each with the check that answers it, the identity behind it, and why sales operations owns the checks that everyone else's numbers rest on.
Jul 30, 20263 min readWhy every figure that depends on something the company does not hold, a customer's wallet, a project's value, a fee wallet, an estate, a held-away balance, carries a source column that says stated or estimated, the three grades of source, stated by the customer, norm from the company's own base, scaled from a public figure, what each grade lets a reader do, how a stated figure ages into an estimate, the rule that estimates never produce a claim, and how the source column changes the reading of a share, a gap and a list.
Jul 27, 20263 min readHow a financial services firm handles customers that cross a segment boundary during the year: what the norm was, what it becomes, why product fit and cross-sell measures jump at the boundary, and the reporting rule that shows the movement instead of hiding it as a gap that appeared from nowhere.
Jul 24, 20263 min readA checklist for the quarter-end reconciliation between an investment bank's sales desk roll-up and the revenue it submits to its benchmark provider: product mapping, client mapping, period cut, joint coverage and the variance report that turns three weeks of email into one page.
Jul 19, 20263 min readWhy a product list with four hundred SKUs produces whitespace everywhere and a concentration figure that means nothing, the three levels a product taxonomy needs, line, family and SKU, which measure is computed at which level, the rule that a SKU belongs to exactly one family and a family to exactly one line, the dated mapping that survives a range change, and the identity that revenue sums identically at every product level.
Jul 16, 20263 min readFive checks on the open pipeline that take a minute from a weekly export and remove most of the argument from the forecast call: close dates in the past, deals without a next step or activity in a stated window, deals in the same stage past the team's own median stage duration, values unchanged since creation on late-stage deals, and duplicate opportunities on one account. Each with the count, the value affected and the rep.
Jul 15, 20263 min readHow a CPG brand infers out-of-stocks per store per SKU from daily or weekly sell-out data without shelf audits: the SKU's own sales rate at the store, the gap that is too long to be chance, the lost sales valued at that rate, the stores and SKUs where gaps recur, and why the inferred figure is a list for the field team rather than a claim against the retailer.
Jul 14, 20263 min readHow a single large order distorts every measure built on it, the norm it inflates, the run rate it doubles, the concentration it spikes, the share of wallet above 100 percent it produces, how outliers are detected from the account's own history and the segment's distribution, the rule that they are flagged and shown rather than removed, the medians that make norms robust to them, and the two kinds of outlier that are not errors at all.
Jul 14, 20263 min readHow a financial services firm separates products held from products used, from the holdings file and the transaction ledger: accounts with no activity since opening, the share of a customer's products that are dormant, why a product count overstates the relationship, and the two lists that follow, activation for recent openings and attrition watch for products that went quiet.
Jul 13, 20262 min readWhy an oilfield services company's coverage numbers depend on a mapping table from every operator name in every source to one identifier: subsidiaries, joint ventures and abbreviations, the unmapped-rig count that says how complete the table is, and how to maintain it as operators merge and rename.
Jul 13, 20263 min readHow a foodservice distributor measures how closely each kitchen's orders follow the order guide it was set up with, from the order guide file and the delivery ledger: guide items ordered, guide items never ordered, off-guide items ordered instead, the substitution pairs that recur, the kitchens whose guide is stale, and why a low compliance figure is usually a guide problem before it is a customer problem.
Jul 13, 20263 min readWhy reach and frequency numbers drift when the call plan changes mid-cycle or calls are logged against prescribers who are not on it, how to keep plan versions with dates so every call is measured against the plan in force, and how to report off-plan calls as their own line rather than losing them.
Jul 12, 20263 min readWhy an education provider's coverage and renewal numbers depend on rolling schools, academies and legacy codes up to the entity that signs the contract, how to keep sites as a dimension underneath it, and the checks that catch a trust counted as ten small institutions.
Jul 11, 20263 min readSite penetration is only as good as the site count it divides by. This guide sets out where a business telecom provider gets each customer's estate, how to date and source it, how to reconcile it to billing so closed sites do not linger, and the review cadence that keeps the number honest.
Jul 10, 20262 min readWhat happens to every measure when a CRM migration, a merge or a re-numbering changes an account's identifier: the account appears new, its history appears lost, dormancy fires, concentration drops, and share of wallet resets. The dated identifier map that prevents it, the three ways drift is detected on upload, the rule that old identifiers are never reused, and the worked recovery after a migration that re-keyed a third of the base.
Jul 8, 20263 min readThe difference between an identity, a sum that must be true by construction, region equals team equals person equals account equals the ledger, and a reconciliation, the work of finding why it is not and fixing the source, why the identity is checked on every upload and the reconciliation is done on the exceptions it lists, the three causes that account for most failures, and why a number is never adjusted to make an identity hold.
Jul 8, 20262 min readHow a medical supplies company checks that what it invoiced each facility matches the price on the contract that facility is entitled to, from the invoice lines and the contract price files: overbilling that becomes a credit and a relationship problem, underbilling that is margin given away, the tier assignment errors that cause both, and the identity that ties the check to the ledger.
Jul 8, 20263 min readA method for reconciling the CRM's account list and revenue to the finance ledger: the join on the account identifier, the five kinds of mismatch that come out, accounts in one and not the other, revenue with no owner, duplicates, timing, and identifier drift, what each one means, who fixes it, and the identity that says when the two systems agree.
Jul 7, 20263 min readA practical method for pseudonymizing a sales export before it leaves the firm: which columns identify a person or a client, how to build a stable ID mapping in a spreadsheet the firm keeps, what stays personal data under UK GDPR anyway, and how to check the file still reconciles afterwards.
Jul 7, 20263 min readA customer master is the file that says what each account is, and most companies have three that disagree. This guide sets out the eight fields a master needs for coverage and share-of-wallet analysis, identifier, parent, segment fields, size, owner, status and dates, where each comes from, the fields that seem useful and are not, the rule that one system is the source for each field, and the monthly check that keeps the master true.
Jul 4, 20263 min readWhy two reports for the same month disagree when one uses the calendar month and the other the fiscal period, the four period conventions that appear in a single company, calendar month, 4-4-5 fiscal periods, week-ending Sunday, and invoice-date versus ship-date, the rule that every export states its cut and every report inherits it, the identity that a year's periods sum to the year, and the trap of comparing this March to last March across a 53-week year.
Jul 2, 20263 min readHow a pharmaceutical commercial team carries formulary and access status on every account so that reach, frequency and share are computed among the accounts where the product can actually be prescribed, the two lists that fall out, calls on blocked accounts and uncalled accounts with open access, and the dated status that makes a quarter's numbers comparable to the last.
Jul 2, 20262 min readHow a medical device or supplies company rolls hundreds of ship-to addresses up to facilities and facilities up to health systems, the identifiers that make it repeatable, the assertion that catches a hospital under two systems, and why GPO compliance and product depth are wrong until this is done.
Jun 30, 20263 min readHow a manufacturer that sells direct and through distributors builds one roll-up where the same shipment is never counted twice: channel as a dimension, separate reconciliation per channel, point-of-sale data where it exists, and the assertion that channels sum to shipped revenue.
Jun 29, 20263 min readHow a company with several legal entities and currencies builds one commercial roll-up that still reconciles: the entity as a level above region, one reporting currency at stated rates per period, the rule that conversion happens once at the entity ledger and never in the report, constant-currency comparisons beside reported ones, intercompany revenue excluded by rule, and the identity that the sum of entities in reporting currency equals the consolidated figure.
Jun 28, 20262 min readHow an investment bank's coverage group manages a banker's departure or move from the coverage file and the contact log: the clients whose last contact was with the departing banker, the days since any other banker touched them, the fee wallet at risk, the handover list ranked by it, and the ninety-day check that says which clients the new officer has actually met.
Jun 27, 20262 min readHow a building materials distributor or trade supplier finds the accounts whose purchasing is constrained by their credit limit rather than by demand: headroom from the credit file and the ledger, orders held or refused for credit, the accounts at the limit whose purchase pattern flattened, and the two decisions that follow, a limit review for the good payers and a collections conversation for the rest.
Jun 27, 20262 min readHow credit notes, returns and rebates enter the revenue measures without breaking them: the rule that every measure is net of credits, the period a credit belongs to, the original invoice's or the credit's, the credit-to-original link that lets a return reduce the right customer, product and rep, uncoded credits as their own leak, and the identity that gross less credits equals the ledger's net figure on every roll-up.
Jun 27, 20262 min readThe difference between a control total, which tests an uploaded file against the figure the source system showed, and an identity, which tests the computed tables against each other, why both are needed and neither replaces the other, the failure each catches that the other cannot, a filtered export against a duplicated account, the order they run in, and what a report says when one of them is unavailable.
Jun 26, 20262 min readHow to segment a B2B customer base from data the company holds: the two or three fields that make a segment useful for norms, size, sector and channel, why behavioral fields like order frequency and product mix belong in the measures rather than the segment definition, the minimum segment size that makes a norm mean something, the test that a segmentation is good, and why personas do not survive contact with a ledger.
Jun 22, 20263 min readThe difference between a baseline, an account's own typical level from its own history, and a norm, what similar accounts do when the relationship is full, why the two answer different questions, has this account changed and how far is it from where it could be, which measures use which, surge and dormancy against baseline, gap and share against norm, the case where an account is at its baseline and far from the norm, and the rule that both are stated on the line that uses them.
Jun 22, 20263 min readHow to score CRM data quality from the export rather than from complaints: five fields that every coverage and pipeline measure depends on, owner, close date, stage, activity date and account identifier, the check for each, the completeness and validity rate per rep, why the score is reported beside the measures that depend on it, and the rule that a measure computed on data under a stated score is shown greyed.
Jun 19, 20263 min readHow to build and use an account hierarchy for sales analytics: the levels that exist in most customers, group, legal entity, site, department, the one level where the buying decision is made and every measure is computed, the levels beneath kept as dimensions, the dated parent mapping that survives acquisitions, the identity that revenue sums identically at every level, and the two mistakes that produce forty customers where there is one and one where there are forty.
Jun 19, 20263 min readUse inclusive quartiles, interquartile-range fences and a row-level flag to identify unusual order values in Excel. Compare segment totals with and without flagged orders while keeping every real transaction in the reported total.
Jun 18, 20265 min read