Numeric keypad data entry means typing amounts on the block of number keys at the right of a full keyboard, with one hand, without looking. For bank statements it beats the top row because every digit, the decimal point and Enter sit under three fingers. A plug-in keypad gives a laptop the same layout for little money.
Numeric keypad hand position for statement amounts
The standard keypad position puts your right index finger on 4, middle finger on 5 and ring finger on 6, with the thumb resting on 0. The little finger covers Enter and the plus and minus keys. Most keypads have a raised bump on 5 so you can find home without looking.
From that home row, each finger moves straight up or down its own column:
| Finger | Home key | Also types |
|---|---|---|
| Index | 4 | 7, 1 |
| Middle | 5 | 8, 2, / |
| Ring | 6 | 9, 3, the decimal point |
| Little | Enter | +, - |
| Thumb | 0 | nothing else |
Practise with the statement out of sight of your hands. Look at the PDF, read four or five digits, and let your fingers type them while your eyes stay on the page. The gain comes from never looking down, not from moving faster. It takes a few sessions before the minus key and the decimal point stop needing a glance.
Keep your left hand on Tab or the arrow keys. Right hand types the amount, left hand moves to the next cell, and neither hand reaches for the mouse. If you type into a sheet laid out like the one in typing bank statements into Excel with a faster setup, the amount column becomes the only place your right hand has to work.
Should you turn on Excel's fixed decimal for keypad entry?
Excel can add the decimal point for you, so 4250 typed on the keypad becomes 42.50. That saves one keystroke per amount. It is worth it for a long column of cents, and risky if you forget it is on, because it changes every number you type afterwards, in every workbook.
Microsoft documents the setting in Excel's advanced options. On Windows it sits under File, Options, Advanced, as "Automatically insert a decimal point", with a Places box. A positive Places value moves the decimal point to the left, so a value of 2 turns typed digits into dollars and cents. Typing a decimal point yourself overrides the setting for that one entry.
Here is an example with Places set to 2. The values are made up.
| You type | Cell shows with fixed decimal on | Cell shows with it off |
|---|---|---|
| 4250 | 42.50 | 4250 |
| 5 | 0.05 | 5 |
| 1200.00 | 1200.00 | 1200.00 |
| -6500 | -65.00 | -6500 |
Note the second row. A five-dollar amount must be typed as 500, not 5. Statements print cents on every amount, so this rarely bites if you type every digit you see, including trailing zeros.
The same options page has a setting called "After pressing Enter, move selection". If you type a whole column of amounts, set it to move down. If you type row by row, leave Enter alone and use Tab to cross the row.
An external numeric keypad for laptop data entry
Most smaller laptops have no keypad, and the top-row digits are slower because your hand must leave the home row for each one. A separate USB or wireless numeric keypad fixes that. They cost little next to the hours they save a frequent typist, and a standard one works with Excel or Google Sheets without software.
When you choose one, look for three things:
- A Tab or 000 key is a bonus, not a must. Some keypads add extra keys. The core layout matters more than extras.
- Same layout as a desktop keyboard. Enter at the bottom right, the decimal point next to 0. A keypad with a different layout undoes your practice.
- Its own Num Lock indicator. You need to see at a glance whether the keys type numbers or move the cursor.
Put the keypad to the right of the laptop, roughly where it would sit on a full keyboard. A keypad on the left can suit left-handed typists, but then the layout stays reversed from any desktop keyboard you use elsewhere.
How many minutes does a numeric keypad save per statement page?
A numeric keypad saves a second or two on each amount, so the gain per page is the number of amounts times that saving. On a page with 30 transactions and a balance on each row, that is 60 numbers. The example below shows the arithmetic with assumed values.
Assume, as an example, that an amount takes you 5 seconds on the top row and 3.5 seconds on the keypad, a saving of 1.5 seconds.
- 30 rows with an amount and a printed balance = 60 numbers.
- 60 x 1.5 seconds = 90 seconds saved on one page.
- A 4-page statement saves 6 minutes.
- Twelve such statements a year save 72 minutes.
These are illustrative figures, not timings. Time yourself on one page with each method, as you would any change to your routine. The saving only matters if you type often. For a dozen rows a month, learning the keypad is more effort than it repays.
A keypad also helps beyond statements. A simple invoice tracker spreadsheet is mostly amounts and invoice numbers, and the keypad handles both.
Numeric keypad pitfall: Num Lock and the fixed decimal left on
The two classic keypad mistakes are typing with Num Lock off, so the keys move the cursor instead of typing digits, and leaving Excel's fixed decimal setting on after the job. The first is obvious within a keystroke. The second is silent, and it can corrupt numbers in a workbook you open next week.
With Num Lock off, 4 moves left, 6 moves right and 2 moves down. You notice at once because the cursor jumps. Press Num Lock and carry on.
The fixed decimal setting is worse because it stays on across every workbook until you turn it off. A colleague who types 1500 for a salary gets 15.00. Make turning it off the last step of every typing session, and write it on the checklist you keep next to the statement. Turning it off later will not change numbers already stored, so a wrong value typed while it was on stays wrong until someone retypes it.
If you type a lot, structured input helps more than speed. An Excel data entry form shows one record at a time with labelled boxes, and Google Forms data entry into Sheets does the same in a browser. For a text-based PDF statement, you can skip the typing; CheapBankConvert is in early access, and its homepage shows the planned per-statement prices.