UNFI Cash Application with RemitParse — Full Walkthrough

UNFI sends you a multi-page remittance PDF every payment cycle. Inside is everything you need to close out the payment in QuickBooks — invoices paid, deductions taken, repayments collected. Getting all of it posted correctly without spending half a day on it is what RemitParse is built for.

This walkthrough covers the full flow: from uploading the PDF to a payment sitting in QBO with every invoice matched, every deduction coded, and the reconciliation confirmed. We'll use a real remittance structure throughout — numbers sanitized, format authentic.

What makes UNFI different from other distributors

UNFI remittances are among the more complex files you'll process as a CPG brand. A single payment can include:

• Invoices paid normally (positive amounts)
• Prepaid invoices with a PP suffix — paid before the due date
• Settlement offsets for those prepaid invoices — negative amounts that net the prepaid to zero
• Deductions — shortages, quality chargebacks, MCB chargebacks, fair share fees, retail ad programs
• CBPB repayments — amounts UNFI is collecting back for prior-period charges, appearing as positive amounts
• Early payment discounts in their own column, not as separate line items

Done manually, this takes 2–4 hours per remittance. With RemitParse, the same remittance takes about 10 minutes — most of which is reviewing auto-coded deductions and confirming the match.

Step 1 — Upload the remittance PDF

Select United Natural Foods, Inc. from the customer dropdown and upload the ACH PDF. RemitParse reads the full document — every page, every column — and loads all transactions into a structured grid.

Several things happen automatically on upload: every row is categorized by nature, early payment discount lines are calculated and pre-coded, and the reconciliation check runs against the TOTAL PAID on the remittance. If you've processed UNFI before with Auto-Coding enabled, Type and Context fields are already filled in on most deduction rows.

Step 2 — Match invoices to QuickBooks

Click Match Invoices in the toolbar. RemitParse connects to QuickBooks Online, pulls all open UNFI invoices, and auto-matches them to remittance lines by invoice number.

The recon formula at the bottom is the key safeguard: cash received + new credit memo = matched invoice balances. It must balance before the Confirm button activates. If something is off — a missing invoice, an amount mismatch — you see it here before any data touches QBO.

Step 3 — Code your deductions

Deduction rows need a Type and a Period before posting. Everything else — nature, amounts, invoice numbers — was set by the parser. If Auto-Coding is enabled and you've processed UNFI before, most rows already have Type and Context filled in based on your history.

What saves the most time across repeated UNFI cycles is Auto-Coding — RemitParse matches incoming deduction rows against your prior history and pre-fills Type and Context. On the first UNFI remittance you'll code everything manually; by the third or fourth, most rows come in already done.

The validation strip at the bottom shows exactly how many rows are still missing required fields. Click any warning chip to highlight those rows in the grid so nothing gets missed before posting.

Step 4 — Post to QuickBooks

Once deductions are coded and matches are confirmed, click Post to QBO. Three things happen in sequence — atomically, so if anything fails mid-way, the whole operation rolls back:

What ends up in QuickBooks

After posting, your UNFI account in QBO has three new objects:

QBO Object	What it contains	Reference number
Credit Memo	One line per deduction, coded to your Products/Services with Class and Location if enabled	UNFI-338499
Invoice	One invoice per CBPB repayment row, coded to the appropriate Product/Service	INV36893CBPB
Payment	Applied against all matched open invoices, the new credit memo, and the repayment invoice. Total equals the ACH deposit amount.	338499

All open invoices from this remittance are closed. The UNFI customer balance in QBO reflects only genuinely open items going forward — no manual application, no loose credit memos sitting unapplied.

The time difference in practice

A UNFI remittance with 50–80 line items takes 2–4 hours manually: download the PDF, open QBO, create the credit memo line by line, find and match each invoice, post the payment, reconcile the balance. Any CBPB repayments or prepaid offsets add more time and create more opportunity for error.

With RemitParse, the same remittance takes about 10 minutes. Most of that is reviewing the auto-coded deductions and clicking Confirm. The second time you process UNFI, it's faster — by the third or fourth cycle, the deduction coding step is largely automated.

Related guides

If you're newer to UNFI remittances or want a reference on deduction codes:

• How to Process UNFI Remittance Advice in QuickBooks — the full manual process explained
• UNFI Deduction Codes Explained — what every prefix on your remittance actually means
• The CPG Deduction Translation Guide — aligning sales, accounting, and finance terminology
• CPG Deduction Software: TPM vs. Cash Application — do you have a planning problem or an accounting problem?
• RemitParse QuickBooks Setup Guide — connect QBO, configure profiles, and enable Auto-Coding