Why do my totals differ even when the raw data looks identical?

The most common causes are hidden decimals, where a cell displays £10.00 but actually contains £10.004, or 'numbers stored as text' which Excel ignores during SUM calculations.

How can I verify figures in a PDF report against a spreadsheet?

You should either use a PDF-to-Excel converter or the 'Data from PDF' feature in Excel's Power Query. Once the data is in a tabular format, you can use the lookup methods mentioned above.

What is the fastest way to find a specific discrepancy in a large file?

Create a 'Difference' column that subtracts the two values you are comparing. Filter this column to exclude zero, and you will be left only with the rows that contain errors.

Blog · DocumentChecker

How to verify figures across multiple spreadsheets and reports

7 August 2026 · 3 min read

Verifying figures across multiple spreadsheets and reports is a common but high-stakes task for accountants, analysts, and business owners. When data is spread across various Excel workbooks, PDF exports, and software reports, the risk of transcription errors or version control issues increases. Whether you are preparing year-end accounts or auditing a project budget, you need a systematic approach to ensure your final numbers are accurate and defensible. This guide outlines practical methods for cross-referencing data efficiently without relying solely on manual line-by-line checks.

Standardise your data sources first

Before you attempt to compare figures, you must ensure that all data sources are using the same units, date formats, and naming conventions. Comparing a report that uses a 'DD/MM/YYYY' format with one using 'MM/DD/YYYY' will lead to lookup errors, even if the underlying numbers are correct.

Clean your data by removing trailing spaces, ensuring all currency values are formatted as numbers rather than text, and aligning the reporting periods. If one report covers a calendar month and another covers a four-week period, your totals will never match. Establishing a 'Single Source of Truth' file where you aggregate these cleaned figures is the first step toward successful verification.

Utilise Excel functions for automated cross-referencing

Manual 'tick and tie' methods are prone to human fatigue. Instead, use Excel’s built-in functions to highlight discrepancies automatically. These tools allow you to compare two lists or tables instantly to see where values diverge.

The most effective functions for this purpose include:

XLOOKUP or VLOOKUP: Use these to pull a figure from a secondary report into your main sheet based on a unique identifier, such as an invoice number or employee ID.
Conditional Formatting: Set a rule to highlight cells where 'Sheet A Value' does not equal 'Sheet B Value'. This makes outliers immediately visible.
Pivot Tables: Summarise large datasets from different reports into a standard format to compare grand totals quickly.
Formula Audit: Use simple subtraction (e.g., =A1-B1) in a new column to find any non-zero results, indicating a mismatch.

Develop a reconciliation checklist

Consistency is key when verifying large volumes of data. A structured checklist helps you stay organised when switching between windows and files. Focus on the most common points of failure, such as manual data entry errors and broken formula links.

Verify the opening balances against the previous period’s closing balances, and ensure that any manual adjustments are documented with a reason. If you find a discrepancy, trace it back to the source transaction rather than adjusting the total to 'make it fit'. For teams managing high volumes of documentation, using a dedicated tool like DocumentChecker can automate the process of spotting mismatches and omissions between schedules and source files, saving hours of manual review.

Accurate reporting relies on systematic cross-referencing and the right digital tools to eliminate human error. By standardising your data and using automated lookups, you can verify figures with confidence.

Quick answers

Why do my totals differ even when the raw data looks identical?: The most common causes are hidden decimals, where a cell displays £10.00 but actually contains £10.004, or 'numbers stored as text' which Excel ignores during SUM calculations.
How can I verify figures in a PDF report against a spreadsheet?: You should either use a PDF-to-Excel converter or the 'Data from PDF' feature in Excel's Power Query. Once the data is in a tabular format, you can use the lookup methods mentioned above.
What is the fastest way to find a specific discrepancy in a large file?: Create a 'Difference' column that subtracts the two values you are comparing. Filter this column to exclude zero, and you will be left only with the rows that contain errors.