Rekeying data means typing numbers that already exist somewhere else in digital form, such as copying a statement into a spreadsheet and then typing the same rows again into a budgeting or accounting app. Each pass costs the full typing time again and adds fresh typos. The cure is one entry, then imports.
What is rekeying data, and where does it happen with statements?
Rekeying data is any manual re-entry of figures that a computer already holds. With bank statements it hides in ordinary routines: the bank's system holds your transactions, prints them to a PDF, and then you or someone else types them back into a sheet. If the sheet then feeds an app by hand, the rows are typed a second time.
The bank's data starts as digital records. The PDF statement is a printout of those records, and typing it is the first rekey. Many people go on to add more:
- Sheet to app. You keep a spreadsheet, then copy its totals or rows by hand into budgeting software or tax software.
- App to report. You read figures off one screen and type them into a form, such as a loan application or a report for a club treasurer.
- Person to person. A family member or bookkeeper receives your sheet and types parts of it into their own file.
- Month to year. You retype twelve monthly summaries into a yearly sheet instead of linking them.
Some rekeying is invisible because each step feels small. Typing six monthly totals into a tax organizer does not feel like data entry. It still is, and each figure is a fresh chance to swap two digits.
Counting the rekeying handoffs from statement to app
A handoff is any point where the numbers move from one place to another. Count how many of those moves are typed by hand, rather than copied, imported or linked. That count is how many times your data is rekeyed, and it is the number to bring down.
Draw the route once for a typical month. Here is an example handoff map for a household that budgets in an app and keeps a yearly sheet for taxes. The minutes are example values.
| Handoff (example) | From | To | Method | Minutes |
|---|---|---|---|---|
| 1 | Bank PDF statement | Monthly spreadsheet | Typed by hand | 30 |
| 2 | Monthly spreadsheet | Budgeting app | Typed by hand | 25 |
| 3 | Budgeting app | Yearly tax sheet | Category totals typed | 10 |
| 4 | Yearly tax sheet | Tax software | Totals typed | 10 |
In this example, every handoff is typed. The same transactions are entered twice in full, and their totals twice more. That is 75 minutes a month spent moving numbers that were already digital at the start.
Questions for each handoff
For each row of your own map, ask:
- Could the destination import a file, so nothing is typed?
- Could the destination read the source directly, through a link or a formula?
- Does this handoff need to exist at all, or does the destination duplicate a place you already keep the data?
A handoff you can delete is better than one you can speed up.
What does each rekeying pass cost in time and typos?
Each rekeying pass costs roughly the same time as the first entry, because typing is typing whether the source is a PDF or a sheet. It also adds its own errors at a similar rate. Two full passes cost about twice the minutes of one, and they carry the errors of both, not just the first.
Work it through with example values. A month has 100 transactions. Typing one row takes 18 seconds, and the typist makes one wrong cell in every 200 entered, also an example figure.
One pass
- Time: 100 rows x 18 seconds = 1,800 seconds, 30 minutes.
- Expected wrong cells: 100 rows x 3 fields = 300 fields, so about 1.5 wrong cells.
Two passes
- Time: 30 minutes for the sheet, plus about 25 for the app, since the sheet is easier to read than the PDF. That is 55 minutes.
- Expected wrong cells: about 1.5 from the first pass, carried forward, plus about 1.5 new ones from the second. That is about 3.
At an example value of $25 an hour, one pass costs $12.50 of time and two cost $22.92. Over a year, the second pass alone costs about $125 in time and doubles the typos your data carries.
The time figures depend heavily on how you type. For a direct comparison between typing and software reading the page, manual data entry vs OCR puts the two side by side on speed and accuracy.
Rekeying errors that compound across statement handoffs
Rekeying errors compound because each pass inherits the mistakes of the pass before it and adds its own. Nothing in a typed handoff checks the source again. A wrong amount typed into the sheet is faithfully copied into the app, and a typo in the app's total then reaches the tax figure.
Three things make compounding worse:
- Each copy looks authoritative. The person typing pass two trusts the sheet. They have no reason to reopen the PDF, so an error from pass one is never seen again.
- Errors change shape. A swapped digit in a row becomes a wrong category total, which becomes a wrong yearly figure. By the end, nobody can trace it back to a single cell.
- Fixes do not travel backward. If you correct the app, the sheet is still wrong. The next person who uses the sheet uses the bad figure.
An example of drift
These figures are made up. A grocery charge of 84.60 is typed into the sheet as 48.60. The budgeting app, typed from the sheet, shows groceries 36.00 under the true figure. At year end, the category total typed into a tax sheet is wrong by the same 36.00, plus a second error from a different month. The two together are small, but the person reviewing the yearly figure sees a total that matches the app and has no way to know both are wrong.
The only reliable defence is a check against the original source at each stage, such as comparing a total with the bank's printed figures. Every typed handoff you remove is one less place that check has to happen.
Cutting statement rekeying down to one handoff
Cut rekeying to one entry by getting the rows into digital form once and moving them only by file, link or import after that. The single entry can be a download, a copy and paste, or a conversion. From then on, the sheet feeds every other place without anyone typing a figure twice.
Step 1: get the rows in once without typing
Look for the cheapest way to get transactions into a file:
- Download a CSV from online banking, if your bank offers one for the dates you need.
- Copy the text from the PDF, if it has a text layer. How to copy a PDF into Excel and fix the paste covers the cleanup.
- Convert the PDF. CheapBankConvert, which is in early access, plans to turn a text-based PDF statement into CSV or Excel rows with date, description, amount and balance columns. The homepage lists the early per-statement prices.
- Type the rows, only if the source is paper or a photo.
Step 2: make every later handoff an import or a link
- Into an app: most budgeting and accounting apps can import a CSV file. Format the sheet the way the app expects once, and reuse that layout.
- Into a yearly sheet: link to the monthly sheets with formulas, or keep all months in one table and summarise with a pivot table. Do not retype totals.
- Into a form: if a form or a person needs figures, give them the file or a printout of a summary instead of retyping.
Step 3: keep one source of truth
Decide which file is the master, usually the sheet built from the bank's rows. Corrections go there first and flow outward. For a small business, a simple setup like the one in tracking business expenses for free can be the single place everything else reads from.
How often you do the single entry changes the work too. A monthly batch and a daily habit have different costs, compared in entering transactions daily or monthly.
Rekeying edge case: when a second typed copy is deliberate
A second typed copy is sometimes the point. Double entry, where two people key the same data and a comparison flags differences, uses rekeying on purpose to catch errors. And some systems simply cannot import, so a typed handoff is the only route. In both cases, keep the rekeying, but know why.
Cases where typing again is reasonable:
- Error checking. Two independent typists, compared afterward, catch most typing slips. The cost is deliberate, and the copies are compared, not chained.
- A closed system. An old desktop program or a government form may accept typed input only. Type from the master file, then check the totals.
- Very few figures. Five category totals into a tax organizer take two minutes. Building an import for that is not worth it.
- Learning. Typing a month by hand teaches you the layout of your statement and your spending, which some people find useful once.
The difference between deliberate and accidental rekeying is a check. Deliberate rekeying is followed by a comparison with the source. Accidental rekeying passes numbers forward and trusts them. If a handoff on your map has no check after it, either remove it or add one.