How to Create a Positive Pay File From SAP Business One
SAP Business One can export your check data, but turning it into a positive pay file your bank accepts is not a single click for most companies. The system has the building blocks for an outgoing payment file, including a format named US_POSIPAY, yet it is not on by default and does not always match what your bank wants. This guide shows which report to pull your check register from and how to convert it into a bank-ready file for free.
If positive pay is new to you, read what is positive pay first. The short version: your bank matches each check that clears against a list of checks you issued, by check number, amount, and sometimes payee, and flags anything that does not match before it pays. That list is the positive pay file, also called a check issue file.
Does SAP Business One have a built-in positive pay export?
Partly, and that is the honest answer. SAP Business One ships with bank file format tooling for outgoing payments, and a TXT format called US_POSIPAY exists among the predefined formats. But this is not an out-of-the-box button. Generating the file through the Payment Wizard requires the Payment add-on, and editing or building a format usually requires the Electronic File Manager add-on. Formats are assigned to payment methods under Administration > Setup > Banking > Payment Methods.
This differs from some other ERPs. Dynamics 365 Finance has a built-in positive pay feature through Electronic Reporting, though even there the output often needs reshaping to a specific bank's layout. In SAP Business One, the predefined formats also rarely match a bank exactly, because each bank sets its own column order, widths, and date rules. When the built-in format does not fit, exporting your check register and converting it separately is the simpler path.
Step 1: Run the Check Register Report
SAP Business One has a dedicated report for this. Go to Banking > Banking Reports > Check Register Report. It lists checks with their check number, status, payment amount, related account code, vendor information, and printing details, an audit trail for everything you have issued.
Set the bank account and posting date range to cover the checks you need, then export to Excel or CSV to review and clean the data first. Confirm the export includes, at a minimum, the check number, check amount, issue date, and the payee or vendor name if your bank matches on payee.
Step 2: Filter to issued checks only
Your file should contain checks you actually issued, not drafts, not voided checks unless your bank wants them flagged, and not incoming payments. Use the report's status and check number columns to keep the right rows.
- Keep printed and issued checks. The report shows status, so filter out anything still in a draft or unconfirmed state.
- Handle voids correctly. A void in SAP Business One has its own status. Most banks want voided checks reported as void rather than dropped silently, so check your bank's rule and see void checks in positive pay.
- Confirm check numbers are real. SAP Business One assigns check numbers from the house bank account next-number setting or during Document Print. A row with no check number does not belong in the file.
Step 3: Watch the amount and date columns
Two details cause most rejected files. First, the amount. Your bank's spec will state whether it wants a decimal point, such as 1042.50, or an implied-decimal whole number, such as 0000104250, where the last two digits are cents. Mixing these up is a common failure. See implied decimal amounts if your bank uses the whole-number style.
Second, the date format. SAP Business One displays dates by your company's regional settings, so your export might read 06/14/2026 or 14/06/2026. Your bank's spec expects one exact format, often MM/DD/YYYY or YYYYMMDD. If the export does not match, the file is rejected or the dates are silently misread. Fix the date column before you generate the file.
Step 4: Convert the export with PositivePayMaker
Once you have a clean export, reshape it into your bank's exact layout. Banks define their own fixed-width or delimited formats, and typing one by hand is error-prone. For the two layout styles, see fixed-width vs CSV positive pay and the full positive pay file format reference.
PositivePayMaker does the conversion in your browser. You upload the SAP Business One export as CSV or Excel, map the columns so each field lands in the right place, pick your bank's layout, and download a file ready for your bank's portal. It runs client-side, so your data never leaves your browser.
If your bank is not a built-in layout, the custom format builder lets you set field positions, widths, the date format, and amount style to match your bank's spec exactly. Reach for this when the SAP Business One predefined format, including US_POSIPAY, does not line up with what your bank published.
Always validate the first file with your bank
However you build it, treat the first file as a test. Run it through the file validator to catch structural problems, then send it to your bank and confirm the check numbers, amounts, and dates match. A field off by one position can reject the whole batch. See why a file gets rejected if your first upload bounces.