Two Numbers Do Not Match. Before Changing Them, Find Out Why

When two numbers differ, the auditor is not asking the company to choose the nicer one. The task is to find out whether the gap comes from timing, different reporting rules or an actual error. Keep both original records, compare the dates, amounts and supporting documents, then write down the difference, its cause, the evidence and whether the accounts need changing. A clear timing difference may be perfectly valid. An unexplained plug removes the trail.

At 31 December, a company’s accounts show a bank balance of RMB 1.18 million. The bank statement shows RMB 1.20 million. Someone adds a line called “adjustment — RMB 20,000” to the bottom of the spreadsheet, and the two totals now match.

An auditor will usually keep asking questions. Who was paid? When did the company record the payment? When did the bank process it? Can it be seen in the January bank record? The auditor needs to know whether this is simply a two-day delay, a duplicate or missing entry, or money that no one can properly explain. Records do not have to be identical at every moment, but every difference needs a reason.

First ask whether the records show the same date

The RMB 20,000 may be a payment recorded by the company on 31 December and processed by the bank on 2 January. If the payment is genuine, the dates are clear and the later bank record completes the story, the gap may simply be a timing difference. It may not require an accounting adjustment, although it still needs to be documented.

Sales can create similar differences. Goods leave the warehouse at year-end, but the customer accepts them in January. An invoice is issued this year for a service completed next year. Accountants use the word “cut-off” for deciding which month or year a transaction belongs to. The answer depends on the contract and what actually happened, not just the date printed on the invoice. A temporary difference is normal. Not knowing when the business event happened is the real problem.

Then ask whether the two reports measure the same thing

Imagine comparing all of a household’s shopping receipts with its credit-card statement. The totals will probably differ because cash purchases do not appear on the card. Company reports often disagree for the same reason.

The sales team may report signed orders while finance reports revenue that is ready to be recorded. The warehouse may count cartons while finance counts individual items. One report includes tax while another excludes it. One covers the Guangzhou company while another includes several subsidiaries. Both files may be called “Sales Detail,” although they measure different things.

Accountants often call these rules and boundaries the “basis” or “scope” of a report. Before comparing two reports, write down the company, period, currency, tax treatment, unit of measure and whether the figures cover one entity or the whole group. Many mysterious differences disappear once those conditions are aligned.

Sometimes the transaction has simply gone missing between systems

A customer may be called “Guangzhou Huaxing” in the sales system and “Huaxing Technology Co., Ltd.” in the accounting system. The contract has no order number, and the payment record contains only a short name. A person may recognise the customer, but the systems cannot reliably connect the records.

Information can also stop halfway through a process. The customer returns the goods and sales approves the refund, but finance is not told. Materials arrive while the invoice remains in a buyer’s inbox. A contract is amended, but finance still has the old copy. The mismatch is not caused by one accounting entry. A handover between teams was missed.

A shared identifier, such as a contract or order number, helps one transaction travel across systems. Customer names should also be kept consistent. When a difference appears, tracing that identifier through the contract, delivery, invoice, cash record and accounting entry is much faster than searching thousands of rows for a similar amount.

Sometimes the record really is wrong

Duplicate entries, missing entries, transactions posted in the wrong month and overwritten spreadsheet formulas are ordinary mistakes. Once the cause is known, correct the record from the original contract, bank record, warehouse document or other evidence. Keep a visible record of the correction instead of silently replacing the old number.

Auditors may also use an “external confirmation.” Despite the formal name, the idea is simple: the auditor asks a bank, customer or supplier directly what amount it recorded on a particular date. A response obtained directly from an independent third party will generally be more persuasive than an explanation produced only inside the company. A different reply does not automatically prove the company is wrong, however. The difference still needs to be investigated.

A useful reconciliation lets someone repeat the work

Return to the RMB 20,000 difference. A helpful reconciliation shows the company balance of RMB 1.18 million, the bank balance of RMB 1.20 million, the exact payment causing the gap, the date the instruction was sent, the date the bank processed it, where the evidence is stored and whether an accounting correction is needed.

If the 2 January bank record shows that the payment cleared normally, and recording it on 31 December was appropriate in the circumstances, the difference may remain a documented timing item. If the investigation instead finds an unrecorded RMB 20,000 bank charge, the accounts need an entry. The amount of the gap is the same, but the answer is completely different.

List each difference separately with its cause, evidence, decision and owner. Start with large, old or unusual items, but do not ignore a small difference that returns every month. A single line called “other adjustment” may fix the arithmetic, but it does not explain anything.

Do not turn year-end into a search party

Bank accounts, customer and supplier balances, inventory, revenue and transactions within a group are easier to manage when they are reconciled every month. Decide who owns each reconciliation, when it is due and when an old difference must be raised with a manager.

If sales tells finance about returns one month late every month, correcting the accounts at year-end only cleans up the same problem again. Fixing the handover prevents it from returning. Reconciliation does more than shorten an audit. It shows where information is being lost, which balances have been neglected and which spreadsheet can no longer be trusted.

When two numbers do not match, start with two ordinary questions: Are they measured on the same date, and are they measuring the same thing? Then choose one difference and follow it from the business event to the accounting entry and the cash movement. Different numbers are not automatically alarming. Changing them merely to make the totals look the same is what turns a manageable question into an unexplained one.