Positive pay with Zoho Books: from check register to bank file
Zoho Books is good at recording and printing checks, but it does not produce a positive pay file. That is not a gap in the product so much as a feature most accounting systems leave out: a positive pay file is a list of the checks you issued, formatted to one specific bank's specification, and every bank writes that specification differently. Zoho Books gives you the data. Your bank tells you the layout. The job is to get one into the shape of the other.
This guide covers how to pull your issued-check data out of Zoho Books, what a positive pay file actually contains, and how to turn the export into the file your bank's treasury portal will accept. You can do the conversion for free in your browser with the PositivePayMaker tool, which never sends your check data anywhere.
What positive pay is, briefly
Positive pay is a check-fraud control offered by your bank's treasury or business-banking department. Each day you send the bank a file listing the checks you wrote: typically the account number, check number, issue date, amount, and often the payee name. When a check is presented for payment, the bank matches it against your list. Anything that does not match by check number and amount gets flagged as an exception for you to approve or reject before it clears. Q2's Centrix positive pay product, used by many regional banks, reports it stopped hundreds of millions of dollars in check and ACH fraud in a single year, which gives a sense of why banks push the service.
One detail worth knowing: many setups match only check number and amount unless payee positive pay is specifically turned on. If a fraudulent check carries a real check number and the right amount, it can still clear. That is a reason to include the payee field in your file when your bank supports it.
Getting your issued checks out of Zoho Books
Zoho Books records checks under Purchases, in the Payments Made section. You can filter that list by status, including To Be Printed, Uncleared, Cleared, and Void, and each payment carries the check number, the vendor (payee), the payment date, the amount, and the bank account it draws on. Those are exactly the fields a positive pay file needs.
Zoho Books does not advertise a one-click "export check register to CSV" button, and its check PDF export works one check at a time rather than in bulk. A few practical routes to a spreadsheet:
- Reports module. Open Reports, then look under Banking or run a payments/expense report that lists your check payments. Most Zoho Books reports have an Export dropdown that offers CSV and XLS/XLSX. Filter to the bank account and date range you are submitting, then export.
- Payments Made list view. Filter Payments Made to the relevant account and check status, then use the export option in that view if your edition exposes it. Verify the result includes check number, date, and amount before relying on it.
- Custom report. If the standard reports do not give you a clean check list, build a custom report with the columns you need (check/reference number, payee, date, amount) and export that.
Whichever route you use, the goal is the same: a CSV or Excel file with one row per check and columns for check number, date, amount, and payee. Zoho's exact menu labels shift between editions and updates, so confirm the column contents in the file rather than trusting the column headers alone. Open the export and spot-check a few rows against checks you know you wrote.
Find your bank's file specification
This is the step people skip, and it is the one that determines whether your first upload works. Your bank publishes a positive pay file format, and it is the source of truth. No accounting export and no third-party tool can guess it for you. Get the spec before you build anything.
Where to find it:
- Log in to your business or treasury online banking and look for Positive Pay, Check Positive Pay, Fraud Prevention, or Account Reconciliation, often under a Treasury Management or Cash Management menu.
- Look for a file-format guide, an import map, or a sample template attached to the positive pay setup screen. Banks running platforms such as Q2/Centrix, Fiserv, or FIS usually let you define or download a column map there.
- If you cannot find it, ask your treasury contact or relationship manager for the "positive pay file specification" or "check issue file format." They deal with this request constantly.
The spec tells you the file type (delimited CSV or fixed-width), which fields are required, the date format (MM/DD/YYYY versus YYYYMMDD is a common stumbling block), how amounts are written (with or without a decimal point, sometimes zero-padded), and whether void checks use a separate status code. Many banks let you define your own column order, which makes the Zoho export easy to match.
Convert the export to the bank's format
Once you have the Zoho Books CSV and the bank spec, open the PositivePayMaker converter. It runs entirely in your browser, so your check register is read locally and nothing is uploaded to a server. The workflow:
- Load your exported CSV or Excel file.
- Map your Zoho columns to the positive pay fields: check number, amount, issue date, account number, payee, and a status field if your bank distinguishes issued from voided checks.
- Pick your bank's layout if it is one of the built-in presets, or use the custom format builder to match your spec exactly, including delimiter, date format, header and trailer rows, and fixed-width column positions.
- Generate the file and download it.
PositivePayMaker ships with eleven bank layouts, six of them built from published specifications, plus a generic CSV and fixed-width option and a validator you can run on the result to catch obvious structural problems before you submit. If your bank lets you design your own import map, building the map to match a clean generic export is often the smoothest path.
When a paid desktop tool makes sense
The free browser tool fits most small and mid-size Zoho Books users. If you process high check volume, want a saved-and-scheduled workflow, or need a layout the presets and custom builder cannot express, paid desktop software exists. Big Red Consulting's Positive Pay File Creator runs about $119 the first year and $99 a year after; it is Windows-only, and the QuickBooks Online edition needs Excel installed (it is built for QuickBooks rather than Zoho Books). Treasury Software's Bank Positive Pay is an installed Windows product roughly $29.95 to $89.95 a month with 350-plus layouts. MoneyThumb and ProperSoft also sell paid desktop converters. For occasional positive pay from a Zoho export, paying a subscription is usually more than the task needs, but for a busy AP desk those tools earn their keep.
Always verify the first file with your bank
No matter how you build it, treat the first positive pay file as a test. Submit it through your bank's portal and confirm the bank accepted it cleanly, that the check count and total match what you issued, and that the dates and amounts read correctly on their side. A misplaced delimiter or the wrong date format will be rejected or, worse, silently misread. Once one file goes through clean, you have a repeatable process: export from Zoho Books, run it through the converter, validate, upload.