Built for AR managers and analysts matching customer payments to open invoices. Convert remittance advices, lockbox processing reports, ACH/wire payment notifications, and customer-deposited check detail into clean Excel for fast AR aging reconciliation.
AR automation tools focus on invoicing and dunning. Cash application — the actual matching of customer payments to open invoices — is still mostly manual. Customers send remittance advices as PDFs (one per check, one per ACH) listing which invoice numbers the payment covers. Lockbox banks send daily processing reports as PDFs with one-row-per-payment detail. ACH payment notifications come in via email as PDFs. Each one needs the invoice numbers, payment amounts, and any short-pay or discount detail extracted into the AR system.
AR analysts at growth-stage companies spend hours per week typing remittance detail into NetSuite / SAP / Sage to clear open invoices. Mid-market AR teams running lockbox have the same problem at higher volume — daily lockbox reports need to flow into the AR system within hours of receipt to keep the aging clean.
PDFExcel reads remittance advices, lockbox processing reports, and customer payment notifications. Each payment becomes a row with customer name, payment amount, payment method (check / ACH / wire), payment date, and the list of invoice numbers covered. Short-pays and discounts taken extract into separate columns for variance handling. Lockbox reports with 200+ payments per day extract as one batch.
Drop the export into the AR system's cash-application import (NetSuite / SAP / Sage / Microsoft D365 / Oracle Fusion AR). Pair with bank statement extraction — extract customer-deposited check detail from the bank statement (where the maker's name appears in the description) for additional cash-app coverage.
The model knows that one customer payment can cover multiple invoices (split-pay), and that a short-pay needs both the original invoice amount and the actually-paid amount preserved for variance research.
Most AR-automation tools focus on invoicing. PDFExcel focuses on the cash-application bottleneck — fast remittance extraction means clean aging.
One row per payment with the invoice numbers it covers. Multi-invoice payments split into separate rows when needed. Short-pay column flagged for AR variance research.
| # | Customer | Payment Date | Method | Amount | Invoices Applied | Short-Pay |
|---|---|---|---|---|---|---|
| 1 | Acme Corp | 03/04/2025 | ACH | $12,840.00 | INV-2024-1182, INV-2024-1184 | $0.00 |
| 2 | Northbridge Logistics | 03/05/2025 | Check | $8,420.00 | INV-2025-218 | $0.00 |
| 3 | Cascade Holdings | 03/06/2025 | Wire | $48,200.00 | INV-2025-220, INV-2025-222 | $0.00 |
| 4 | Summit Services LLC | 03/08/2025 | Check | $1,485.00 | INV-2025-228 | $15.00 |
| 5 | Pacific Tech Studios | 03/12/2025 | ACH | $24,800.00 | INV-2025-201, INV-2025-205, INV-2025-209 | $0.00 |
AR analysts at $20M-$200M companies, controllers running cash-application workflows, AR managers at companies on lockbox banking, fractional finance teams supporting AR for portfolio companies.
60+ customer payments per week — mix of ACH, wire, and check. Convert weekly remittance batch, drop into NetSuite cash-app import. Clears 60 open invoices in 30 minutes vs 4 hours of typing.
Daily lockbox processing report has 80-120 payments. Convert each daily report, drop into SAP AR cash app. Same-day cash application keeps aging clean.
Reconciles open AR aging vs GL. Convert the prior month's remittance batches, build a side-by-side variance worksheet showing applied vs unapplied payments for write-off review.
Yes. Split-pay scenarios extract with the full list of invoice numbers in one column, or as separate rows per applied invoice — your choice in step 2 based on what your AR system expects.
Yes. Short-Pay Amount and Discount Taken extract as separate columns when the source document shows them. Useful for variance research and write-off review.
Yes. Major lockbox banks (BofA, JPM, Citi, Wells Fargo, regional providers) have their own report layouts — the model recognizes each and normalizes the output to a consistent structure for AR cash-app import.
We export CSVs that those systems' AR cash-application imports accept natively. No direct API integration; by design keeps the tool simple. Most AR teams set up a saved import mapping per system and reuse it.
10 documents per month, free, forever. Plans from $69/month for 50 documents — most small AR teams fit Starter; growth-stage and mid-market teams handling daily volume fit Pro at $199/month or Business at $699/month.