Duplicate DetectedAlready exported to QuickBooks
View in QBO
Remit Customer—
QBO Customer—
Check / Advice No.—
Credit Memo No.—
Check Date—
Credit Memo Date—
Difference—
Remit Total—
Expected—
Deductions—
Inv. Paid—
Inv. Prepaid—
EPD—
EPD Prepaid—
EPD Settle—
Repayment—
0 / 0 deductions coded
Settings / MappingProfile-scoped — changes only affect the active profile
ProfileActive
RemitParse Company → QBO Customer
Map exactly what RemitParse reads from the remit header to the customer name in QuickBooks. Must match QBO exactly.
⚙ Advanced options are available per customer via the gear icon on each row.
Sub-customer routing — splits one remittance into separate QBO payments per sub-customer (e.g. Walmart + Sam's Club on the same check).
Early Payment Discount % — for distributors that report invoice amounts net of EPD (KeHE, UNFI prepaid rows, WinCo). Enables gross invoice amount imputation. Leave off for all other customers.
Remit capturesQBO Customer Name (exact)
Deduction Type → QBO Product/Service
Map RemitParse deduction types to QBO Product/Service names. Used when exporting Credit Memos. Custom types added here appear in the Type dropdown.
RemitParse TypeQBO Product / Service (exact)
Class Coding
Enable
Class List (one per line — must match QBO exactly)
These values appear in the Class dropdown in the table and are included in Credit Memo exports.
Location Coding
Enable
Location List (one per line — must match QBO exactly)
These values appear in the Location dropdown in the table and are included in Credit Memo exports.
Per-Customer Defaults
Set a default Class and/or Location by QBO customer name. Auto-fills when a remit is uploaded for a matching customer.
When enabled, RemitParse learns from your past exports and pre-fills the Type and Context fields after each upload. Only empty cells are filled — your edits always take priority. History is scoped to this profile and company and never shared.
Auto-Coding is available on Growth and Pro plans. Upgrade to unlock type and context pre-fill from your export history.
How it works
1. Export to build history Every time you export a coded remittance, the deduction types and context values you assigned are saved to your history for that distributor.
2. Upload learns from history On the next upload, RemitParse matches invoice numbers and descriptions against your history and pre-fills matching rows automatically.
3. Review and confirm Pre-filled cells are highlighted so you know which values came from auto-coding. Edit anything that looks wrong — your correction is used going forward.
Cell highlight colors
Green — High confidence (≥ 0.75) Strong match with consistent history. Safe to export without review in most cases.
Yellow — Reasonable confidence (0.50–0.74) Pattern matches history but with lower frequency or partial consistency. Worth a quick check.
Orange — Low confidence (< 0.50) First time seeing this pattern, or conflicting history. Verify before exporting.
Hover any highlighted cell to see the confidence score and what drove the suggestion. Editing clears the highlight.
Connect QuickBooks in your Account settings to configure payment posting options.
Deposit Accounts
Select the bank account each customer's ACH payments are deposited into. Must match a Bank or Other Current Asset account in QBO.
Loading accounts from QuickBooks…
No customer mappings found. Add customer mappings in the Customer Mapping tab first.
Processing remittance…
Credit Memo Export Preview
CSV Column
Value
Kroger — Reconstruct Remittances
Upload 3 Supplier Connect exports
Payments
payments.xlsx
Invoices
invoices.xlsx
Promo
promo.xlsx
—EFT check date range to reconstruct
Export all three files from Kroger Supplier Connect and upload each into the matching slot below:
• Payment Search — Transactions › Payments View › filter for the time frame requiring payment processing (e.g. today, last week, this month) › Download Icon › Export Grid › Excel
Payment Search: export a wider window (60+ days) so prior netting charges that offset this period's EFTs are included. Only EFTs within the date range above will be reconstructed — earlier nettings are used silently for linkage only. Invoice Search & Promo Payments: at least 3 months of data recommended.
Type
Ref #
Date
Invoice(s)
Total
Match Invoices to Payment
Match open QBO invoices to this remittance before posting payment.
Loading open invoices from QuickBooks…
Cash Received—
+
New CM (deductions)$0.00
=
Matched Invoices—
+
Repayment Rows$0.00
−
Pre-existing CMs$0.00
+
Rounding Adj
⚠ Not balanced
QuickBooks Period Locked
The remittance date falls in a closed accounting period.
QuickBooks won't accept transactions dated in a locked period. Enter a date in an open period to post this payment — typically the 1st of the following month.
Original remittance date:—
Free Export
Get your CSV
Drop your email and we'll keep you posted on new parsers and features. Your CSV downloads instantly.
🎉
Enjoy the CSV!
But could you imagine doing this for every remittance — with deductions auto-coded and payments posted directly to QuickBooks?
✓Auto-coding deductions from your history
✓1-click payment & credit memo posting to QuickBooks