Tablora · Library
Check for a duplicated page before summing
A page scanned or exported twice repeats real-looking rows and doubles part of a total. Learn how to spot the copy before you add anything up.
How a page gets counted twice
Duplicates appear when the same page is photographed twice, when a PDF is assembled from overlapping exports, or when a printed report repeats the last page of one section at the start of the next. Every duplicated row is valid on its own: the dates, descriptions and amounts are real. Only the combination is wrong, and the total of the combined table is too high by exactly the duplicated block.
Nothing in the table structure gives this away. The rows have the right width, the numbers parse and the headers line up.
Because the copy repeats a whole block, sorting the merged table by date or reference can make it easier to see: each duplicated record then sits directly next to its twin.
What the tools do and do not remove
Repeated header cleanup in the browser removes rows that equal the chosen header row. It never compares data rows with each other, so two identical transactions both stay. In the Tablora app, Merge pages appends the rows of every table with the same column count and drops only a repeated header at the top of each later table. A duplicated page therefore becomes a duplicated block inside the merged table.
Deciding which copy is the real one is a judgement about the source, so it stays with you.
Spotting the duplicate
- Before merging in the app, open each table chip labelled Page n · n and compare the first and last record of each page.
- Look for page numbers, statement periods or running balances printed on the source; a running balance that jumps back is a strong sign of a repeated page.
- Check for a block of rows that repeats in the same order, rather than single identical rows, which can be genuine.
- When you confirm a duplicate, delete the extra copy in the app with Delete row, or remove the block from your text copy, and keep a note of what you removed.
Verifying the corrected total
Once one copy is gone, enter the amount column into the decimal totals checker, one value per line, with the document's own total in Expected total. If the Difference before the correction equalled the sum of the duplicated block and is zero afterwards, the duplicate accounted for the gap. If it is still not zero, look for another cause instead of removing more rows.
Two identical transactions on the same day can be genuine, such as two equal card payments. Remove a row only when the source shows it once.