Business banking quirks: positive pay, lockbox, ACH batches break spreadsheet imports

Business banking statements include features like positive pay, lockbox processing, and ACH batches that can break standard spreadsheet imports. Here's how to handle them.

Business banking features

• Positive pay: Check verification system that may show matched/unmatched items separately
• Lockbox: Customer payments processed by the bank, appearing as batch deposits
• ACH batches: Multiple transactions grouped together with summary totals
• Wire transfers: Large transactions that may have separate fees

Conversion challenges

• Batch transactions may appear as single line items instead of individual transactions.
• Positive pay items may duplicate transactions (original + matched entry).
• Lockbox deposits may not include individual customer details, requiring separate remittance files.
• ACH batches may have net settlement amounts that don't match individual transaction sums.

Workflow recommendations

1. Request detailed transaction files (not just summary statements) when available.
2. Convert PDF statements to Excel, then supplement with detailed export files if needed.
3. Flag batch transactions for manual review and client follow-up.
4. Keep separate reconciliation tabs for different transaction types (checks, ACH, wires).