The exact three-column format
The tool’s downloaded workbook uses the headings below. Keep them unchanged for the clearest, most predictable import.
| Column | Use | Safe example | Common failure |
|---|---|---|---|
Payee Name | Name printed on the payee line | MAURYA OFFICE SUPPLIES | Extra spaces, spelling copied from an informal nickname |
Amount | Numeric amount used for figures and words | 24500.50 | ₹24,500.50, formulas that return text, blank cells |
Date (DDMMYYYY) | Eight characters placed in the date boxes | 07062026 | 7/6/26, Excel converting it to a serial number, leading zero removed |
The importer also recognizes Payee or Name, Amt, and Date as aliases. Still, the downloaded headings are preferable because they make the file self-explanatory to the next reviewer.
Prepare the workbook so Excel does not “help” too much
Keep the date as eight visible digits
Dates beginning with zero are vulnerable to automatic formatting. Set the date column to Text before entering data, or prefix a value with an apostrophe in Excel so 07062026 remains eight digits. After saving and reopening the file, inspect the first, middle and last dates again.
Use plain numbers in Amount
Enter 24500 or 24500.50. Avoid currency symbols, comma separators and words in the amount cell. If the source workbook calculates an amount with a formula, paste the final values into the upload copy. This keeps the batch independent of broken links or calculation settings.
One payment per row
Remove blank headings, subtotal rows, notes and merged cells. A human-friendly accounting report is not automatically a clean import file. Create a small upload sheet containing only the three required columns and one payment per row.
A sample upload sheet
| Payee Name | Amount | Date (DDMMYYYY) | Reviewer note (do not upload) |
|---|---|---|---|
| MAURYA OFFICE SUPPLIES | 24500 | 07062026 | Invoice and spelling checked |
| NORTH CITY TRANSPORT | 18750.50 | 07062026 | Decimal amount confirmed |
| R K SERVICES PRIVATE LIMITED | 100000 | 08062026 | Long name preview checked |
The fourth column above illustrates a review note, but keep such notes in a separate control sheet. The uploaded sheet should contain only fields the cheque tool needs. Never place bank account numbers, identity documents, passwords or unrelated personal data in the workbook.
The controlled batch workflow
- Download a fresh template. This avoids guessing the column names and gives you a known-good first row.
- Create an upload copy. Preserve the approved source workbook. Work in a separate file containing only the three required columns.
- Validate the list. Check blank rows, duplicates, unusual amounts, leading-zero dates and long payee names. Compare the number of rows and total amount with the approved source.
- Upload the file. The tool reads the first worksheet. If your workbook has multiple tabs, place the upload table first or use a single-sheet copy.
- Use Previous and Next. Inspect every imported record in the cheque preview. Pay special attention to long names, decimals and dates beginning with zero.
- Run one calibration print. Use plain paper cut to the cheque size. Confirm scale, feed direction and field placement.
- Print only the reviewed batch. Reconfirm row count before Bulk Print. Keep unattended people away from the printer tray and collect output immediately.
- Inspect physical output. Compare figures and words, verify dates and payees, and remove any damaged or misfed leaves before signing.
Fast pre-upload tests
| Test | How to perform it | Why it matters |
|---|---|---|
| Blank row check | Filter each required column for blanks | Prevents empty or partial records from entering the review queue |
| Duplicate check | Highlight duplicate combinations of payee, amount and date | Catches accidental copy-paste repetition; a real repeat can then be approved deliberately |
| Date length | Confirm every visible value contains eight digits | Finds missing leading zeros and automatic date conversions |
| Amount outliers | Sort smallest to largest and inspect extremes | Exposes an extra zero, decimal shift or text value |
| Row-count reconciliation | Compare upload rows with the approved payment list | Detects lost filters, hidden rows and accidental additions |
| Total reconciliation | Sum the upload Amount column and compare it with the approved total | Provides a second independent completeness check |
The browser can parse a workbook and still receive the wrong spelling, amount or date. “Loaded” means readable, not approved.
Privacy and retention
The workbook is read by browser code on the cheque tool page. The page also loads external libraries and may use advertising or analytics services, as described in the Privacy Policy. Use the minimum data necessary: payee, amount and date. Do not add bank account numbers, addresses, phone numbers, identity documents or passwords.
After printing, follow your organization’s retention policy for the local workbook. If you do not need the upload copy, delete it securely from the device and any synced folder. The website cannot manage files stored on your computer.