MREPS – Commission Payment Entry & Check Reconciliation
The Payment Entry & Deposits module in MRSware Desktop (EYOND.MRSware.Modules.MREP) is the core financial reconciliation console for manufacturers' representative agencies. It provides dedicated accounting workflows for logging factory commission checks, recording electronic direct deposit (ACH/EFT) statements, matching gross payments against open factory invoices using the Payment Lookup Table, auditing factory deductions and adjustments, and automatically allocating sub-rep commission splits upon saving.
Press Ctrl+N to log a new commission check, Ctrl+E to edit, or use the Payment Lookup Table (Ctrl+L) to match open invoices against the check deposit amount.
Commission Payment Accounting & Deposit Logging Architecture
In rep agency accounting, a manufacturer commission check represents a lump-sum payment covering dozens or hundreds of individual customer invoices. The Payment Entry module bridges bank deposits with line-item reconciliation:
🏦 Bank Deposit Auditing
Record Check Number, Check Date, Deposit Date, and Bank Account references. Ensure every dollar deposited into agency bank accounts reconciles to the penny.
🔍 Interactive Payment Lookup Table
Multi-select open invoices for the manufacturer. MRSware displays running reconciled totals, outstanding balances, and payment variances in real time.
⚖️ Variance & Deduction Tracking
Categorize factory deductions (early pay cash discounts, coop advertising, catalog fees, return credits) to resolve statement discrepancies cleanly.
👥 Sub-Rep Split Automation
Saving a reconciled payment immediately calculates sub-rep commission earnings according to active agency split rules, feeding sub-rep payout statements.
Permissions & Navigation
- Required Base Permission:
MRSware/Manufacturers Rep/Payments– Governs access to payment ledgers and check records. - Sub-Permissions:
.../Payments/Edit(enables check logging and invoice reconciliation) and.../Payments/Delete(enables deletion). - Opening Payment Entry: Click Payment Entry on the Shortcut Bar or navigate to Modules → Payment Entry.
Payment Listing Table (PaymentListingTable)
The main table view displays all historical and in-progress check batches:
- Ref / Check # (
tcRefNumber): Manufacturer check number or electronic wire transfer identifier. - Manufacturer (
tcManufacturer): Linked factory principal paying the commission. - Issue Date (
tcIssueDate): Date written on the manufacturer statement. - Gross Amount (
tcAmount): Total dollar value of the commission deposit. - Memo (
tcMemo): Statement notes, commission period, or factory account codes.
The Payment Lookup Table & Invoice Matching
When creating or editing a payment (PaymentEntryForm.cs), click Lookup Invoices to launch the matching dialog:
- MRSware automatically queries all unpaid and partially paid invoices for the selected Manufacturer.
- Check the box next to each invoice appearing on the factory statement.
- The status banner displays a running counter:
Check Total: $24,500.00 | Selected Invoices: $24,500.00 | Variance: $0.00 (Balanced) - Click Apply to Payment. All selected invoices are marked as paid, commission balances are updated, and sub-rep splits are generated instantaneously.
Commission Payment Reconciliation Reports
Check the box labeled "Run Commission Payment Reconciliation Report on Save" to automatically generate a formal PDF audit summary showing all reconciled invoices, factory adjustments, and sales rep splits for the check.