Drop in any remittance advice PDF — from customers paying on account, ACH advice notes, or check stubs — and get a clean Excel file with customer, payment date, payment amount, and the list of invoices being paid (with deductions). Built for AR cash-application teams clearing receipts against open AR.
Convert your first remittance — free
Customer A sends a PDF check stub listing 47 invoice numbers paid. Customer B sends an ACH advice email with a PDF attachment. Customer C uses an EDI-derived PDF with deduction codes. Customer D pays a partial invoice. AR teams need to figure out which payment cleared which invoices — and post deductions or short-pays correctly to keep AR aging accurate. Manual matching for high-volume B2B AR is the cash-application bottleneck.
Generic PDF tools either flatten the invoice list into one cell or split deduction codes from amounts. The structure that matters for cash application — one row per invoice paid, with deduction reason coded — is exactly what generic tools mishandle.
PDFExcel reads remittance advices line-by-line. Customer name and remit-from extract once per remittance. Each invoice paid extracts as its own row — invoice number, original amount, paid amount, deduction amount, deduction reason code. Payment date, payment method (ACH / check / wire), and reference number tag every row. Multi-invoice remittances come back as one Excel sheet ready to drop into your AR sub-ledger.
Drop the result into your AR system (NetSuite AR, Sage AR, QuickBooks, or a custom AR sub-ledger) for batch cash-application posting. Built-in OCR handles scanned check stubs. Pair with AR persona for the broader cash-app workflow.
Trained on real B2B remittance formats — vendor portal exports, customer-AP ACH advice notes, EDI 820 derived PDFs, and traditional check stubs. Deduction codes preserved for short-pay analysis.
Cash application is the AR bottleneck. The faster a remittance becomes posted-to-Excel, the faster aging clears and the better DSO trends.
One row per invoice paid, with deduction reason codes preserved. Drop into the AR sub-ledger as a cash-application batch — match each row to an open invoice and post.
| # | Customer | Pay Date | Invoice # | Original | Paid | Deduction | Reason |
|---|---|---|---|---|---|---|---|
| 1 | Acme Industries | 02/14/2025 | INV-4821 | $8,200.00 | $8,200.00 | $0.00 | |
| 2 | Acme Industries | 02/14/2025 | INV-4822 | $3,450.00 | $3,200.00 | $250.00 | DAMAGED |
| 3 | Acme Industries | 02/14/2025 | INV-4830 | $2,150.00 | $2,107.00 | $43.00 | DISC-2% |
| 4 | Globex LLC | 02/14/2025 | INV-4811 | $5,400.00 | $5,400.00 | $0.00 | |
| 5 | Globex LLC | 02/14/2025 | INV-4815 | $1,800.00 | $0.00 | $1,800.00 | DISPUTED |
AR teams at B2B businesses, credit/collection departments, AR shared-services centers, AR-outsourcing BPOs supporting multiple clients.
200 customers, 80% of payments come with PDF remittance attachments. PDFExcel converts the day's remittances into one batch CSV; cash app posts in NetSuite in 30 minutes vs the prior half-day manual matching.
Short-pay analysis driven by deduction reason code. PDFExcel preserves the reason code; pivot reveals 'DAMAGED' deductions concentrated in one warehouse — fix shipping QA, recover $80k/quarter in formerly-eaten short-pays.
Cash app for 15 SMB clients with different AR systems. Standardize remittance extraction on PDFExcel, export to whatever each client's AR expects.
Yes. Deduction amount and reason code extract as separate columns. Short-pays show paid amount + deduction amount summing to the original invoice — the AR sub-ledger can post the cash and the deduction with the correct GL hit.
Each invoice on the remittance becomes its own row in the output. A single $50k payment covering 47 invoices comes back as 47 rows — directly drop-in to AR cash-application batch posting.
10 documents per month, free, forever. Most small B2B AR teams have 5-50 remittances per week — Starter at $69/50 docs/month covers a typical week.
Yes. Drop the week's remittances as a ZIP, get back one Excel with all invoice rows tagged by remittance. See batch processing for the broader workflow.
We export CSVs that those AR sub-ledgers accept for batch cash-application posting. No direct API integration — by design, keeps the tool simple. Most AR teams set up a saved import mapping per AR system and reuse it.