Bulk Payment Entry for Multiple Invoices
For: Office Staff, Administrators
The Problem This Solves
Real Customer Issue (Potomac Selections):
"Maryland and DC customers commonly send one check to pay for multiple invoices. Currently, Aaron must manually enter the same check number and calculate/enter amounts for each individual invoice, which is extremely time-consuming."
Without bulk payment entry:
❌ Record same check number 5-10 times (once per invoice)
❌ Manually calculate allocation amounts
❌ Risk of data entry errors
❌ Hours of repetitive work each week
With bulk payment entry:
✅ Enter check information once
✅ System helps allocate amounts
✅ Save hours of time
✅ Reduce errors
Overview
Bulk Payment Entry allows you to record one payment that pays for multiple invoices from the same customer. This is ideal when:
Regional customers send consolidated payments (e.g., Maryland/DC restaurants)
Customers pay monthly for multiple outstanding invoices
One check covers several deliveries
Wire transfer pays for batch of invoices
How It Works
Simple 7-Step Process:
Find customer's unpaid invoices
Select invoices to pay (2 or more)
Click "Record Bulk Payment"
Enter check/payment details once
Allocate payment across invoices (auto or manual)
Verify totals match
Save - done!
Time Savings:
Individual entry: 2-3 minutes per invoice × 5 invoices = 10-15 minutes
Bulk entry: 2-3 minutes total for all invoices
Saves 80% of time!
Prerequisites
Before starting bulk payment entry:
✓ Same Customer - All invoices must be from the same customer account ✓ Delivered Status - All invoices must be in Delivered status (cannot pay draft or confirmed orders) ✓ Total Known - Know the total check/payment amount ✓ Remittance Slip (recommended) - Have customer's payment breakdown if provided
Step-by-Step: Bulk Payment Entry
Step 1: Find Customer's Unpaid Invoices
Navigate to Orders → Invoices
Filter by customer:
Click customer filter
Search for customer name
Select the customer
Filter by payment status:
Select "Unpaid" or "Partially Paid"
This shows only invoices that need payment
Sort if needed:
By invoice date (oldest first)
By due date
By invoice number
Tip: Save this filter combination for customers who regularly pay multiple invoices.
Step 2: Select Invoices to Pay
Use checkboxes next to each invoice
Select the invoices this payment will cover
Can select:
All unpaid invoices (if check covers everything)
Specific invoices (if partial payment)
Just oldest invoices (if applying to oldest first)
As you select:
System shows count: "3 invoices selected"
Shows total of selected invoices
"Record Bulk Payment" button appears
Note: Must select 2 or more invoices for bulk payment. For single invoice, use Recording Individual Payments.
Step 3: Click "Record Bulk Payment"
Look for "Record Bulk Payment" button (appears after selecting 2+ invoices)
Button location: Usually at top of invoice list or in bulk actions menu
Click to open the Bulk Payment Modal
Step 4: Enter Check/Payment Details
The bulk payment form appears with these fields:
Payment Method (required)
Select from dropdown:
Check (most common for bulk payments)
ACH / Electronic Transfer
Wire Transfer
Credit Card (rare for bulk)
Cash
Check Number / Reference (required)
For checks: Enter check number exactly as shown (e.g., #4821)
For ACH/Wire: Enter confirmation or reference number
This number will be applied to ALL selected invoices
Payment Date (required)
Date payment was received
Default: Today's date
Can be adjusted if received on different date
Total Payment Amount (required)
Enter the total amount of the check/payment
Example: If check is for $3,247.82, enter that amount
This is the amount you'll allocate across all selected invoices
Bank / Notes (optional)
Bank name (for checks)
Any notes about this payment
Example: "Monthly payment for Feb deliveries"
Step 5: Allocate Payment Across Invoices
After entering payment details, you'll see an allocation grid showing all selected invoices.
Allocation Grid Columns
For each invoice, you see:
Invoice Number: Invoice #
Invoice Date: When invoice was created
Original Balance: Full invoice amount
Amount Due: Current balance (may be less if partial payment already applied)
Payment Amount: Amount to apply from this payment (editable field)
Three Allocation Methods
Choose the method that fits your situation:
Method 1: Auto-Allocate (System Distributes)
Click "Auto-Allocate" button and system will:
Distribute payment proportionally across invoices, OR
Apply to oldest invoices first (FIFO)
Fill amounts automatically
Best for: When you don't have specific allocation from customer
Method 2: Pay in Full (For Exact Match)
Click "Pay in Full" button and system will:
Calculate each invoice's full balance
Fill in full amount for each invoice
Sum the total
Best for: When check amount exactly matches total of selected invoices
Example:
Selected 5 invoices totaling $3,247.82
Check amount: $3,247.82
Click "Pay in Full" → Perfect match!
Method 3: Manual Entry (Custom Allocation)
Manually enter amount for each invoice:
Click in "Payment Amount" field for first invoice
Type the amount to apply to that invoice
Move to next invoice
Repeat for all invoices
Best for:
Customer provides specific breakdown
Partial payment doesn't cover all invoices
Special allocation requirements
Step 6: Verify Totals Match
Critical Check: Running total must equal payment amount
Running Total Display
As you allocate amounts, system shows:
Allocated So Far: $XXX.XX
Remaining to Allocate: $XXX.XX
Total Payment Amount: $XXX.XX (entered in Step 4)
Validation Rules
System will prevent saving if:
❌ Allocated total less than payment amount (under-allocated)
❌ Allocated total more than payment amount (over-allocated)
✅ Must match exactly
Handling Mismatches
If amounts don't match:
Check entered correctly:
Verify total payment amount is correct
Re-check customer's check amount
Short payment (pennies difference):
Adjust one invoice by the difference
Add note explaining: "Adjusted $0.25 for check rounding"
Customer overpaid/underpaid:
Allocate what's available
Add note about discrepancy
Follow up with customer
Math error:
Click "Auto-Allocate" to recalculate
Or manually adjust amounts
Step 7: Save Bulk Payment
Review the summary:
Payment method and reference number
Total payment amount
Number of invoices
Allocation breakdown
Click "Save Payment" or "Record Bulk Payment"
System processes (may take a few seconds):
Records payment on each invoice
Updates all invoice balances
Creates transaction history entries
Syncs to QuickBooks (if connected)
Confirmation message appears:
"Payment recorded on X invoices"
Lists invoice numbers
Result:
All invoices show the payment applied
Same check number on all invoices
Each invoice balance updated
QuickBooks receives all payment records
After Bulk Payment
What You'll See
On each invoice:
Payment appears in transaction history
Shows: Payment date, amount, method, check number
Invoice balance reduced by payment amount
Same check number on all invoices (important for reconciliation)
Payment history indicator:
May show "Bulk Payment" badge or note
Links to other invoices paid by same check
QuickBooks Sync
Automatic sync:
Each invoice's payment syncs to QuickBooks individually
Same check number appears on all QB invoice payments
Usually syncs within a few minutes
Note: QuickBooks will show one check number applied to multiple invoices, which is exactly what you want for bank reconciliation.
Printing Payment Receipt
Generate a combined receipt showing all invoices paid:
Navigate to customer account or any paid invoice
Look for "Bulk Payment Receipt" option
Receipt shows:
Check number and amount
All invoices paid
Amount applied to each
Remaining balances (if partial payments)
Provide to customer as proof of payment allocation.
Common Scenarios
Scenario 1: Check Exactly Matches Invoice Totals
Situation:
Customer: Osteria (Maryland restaurant)
Check: #4821 for $3,247.82
Unpaid invoices: 5 invoices totaling exactly $3,247.82
Steps:
Filter invoices by "Osteria"
Select all 5 unpaid invoices
Click "Record Bulk Payment"
Enter: Check #4821, amount $3,247.82
Click "Pay in Full"
Verify total matches: ✓ $3,247.82
Save
Result: All 5 invoices marked paid with check #4821
Scenario 2: Check is Less Than Total Owed (Partial Payment)
Situation:
Customer owes: $5,000 across 8 invoices
Check received: $3,000
Customer says "apply to oldest invoices"
Steps:
Select all 8 unpaid invoices
Click "Record Bulk Payment"
Enter: Check info, amount $3,000
Click "Auto-Allocate" with "oldest first" option
System fills oldest invoices first until $3,000 used
Example result:
Invoice 1001: $850.00 (paid in full)
Invoice 1002: $720.00 (paid in full)
Invoice 1003: $695.00 (paid in full)
Invoice 1004: $735.00 (partial payment, $485 remaining)
Invoices 1005-1008: Unpaid
Verify total = $3,000
Add note: "Partial payment, applied to oldest first"
Save
Result:
3 invoices paid in full
1 invoice partially paid
4 invoices remain unpaid
All show same check #4821
Scenario 3: Customer Provides Specific Breakdown
Situation:
Customer sends remittance slip with exact allocation
Check: $2,500 for specific invoices with specific amounts
Example remittance:
Steps:
Select those 4 specific invoices
Click "Record Bulk Payment"
Enter: Check #5923, amount $2,500
Manually enter amounts for each:
Invoice 1234: Type $600.00
Invoice 1256: Type $450.00
Invoice 1289: Type $750.00
Invoice 1301: Type $700.00
Verify total = $2,500.00 ✓
Add note: "Per customer remittance slip"
Save
Result: Payment allocated exactly as customer specified
Scenario 4: Check Has Short Payment (Pennies Difference)
Situation:
Invoices total: $1,847.35
Check received: $1,847.10
Difference: $0.25 short
Steps:
Select invoices
Enter payment: $1,847.10 (actual check amount)
Use "Pay in Full" - will show $1,847.35 allocated
System shows: "Over-allocated by $0.25"
Adjust one invoice:
Pick any invoice (often the largest)
Reduce by $0.25
Example: Change $687.35 to $687.10
Now totals match: $1,847.10 ✓
Add note: "Check $0.25 short - adjusted invoice 1234"
Save
Follow-up: Decide with customer if $0.25 needs to be collected or written off as rounding difference.
Scenario 5: Monthly Payment for Multiple Weeks
Situation:
Customer pays monthly for all deliveries
12 invoices from February
One check for entire month
Steps:
Filter: Customer + Date range (Feb 1-28)
Select all February invoices
Enter payment with note: "Monthly payment - February deliveries"
Allocate (Pay in Full if matches, or partial if short)
Save
Benefit: Clear record that one payment covered entire month.
Best Practices
Before Starting
✅ Have customer's remittance slip or payment breakdown
Many customers include breakdown with check
Makes allocation much easier
Reduces errors
✅ Verify total before allocating
Check the physical check amount
Confirm decimal points correct
Ensure you have the right check number
✅ Contact customer if allocation unclear
Don't guess how to allocate partial payments
Customer may have specific preference
Document their instructions
During Allocation
✅ Use oldest-first for partial payments (unless customer specifies otherwise)
Industry standard practice
Customers typically expect this
Helps manage aging of receivables
✅ Add notes for unusual situations
Allocation differs from customer request: Note why
Rounding differences: Note adjustment
Partial payment: Note when remainder expected
✅ Double-check check number
Critical for bank reconciliation
Easy to transpose digits
Verify against physical check
After Saving
✅ Generate combined payment receipt
Send to customer showing allocation
Keeps everyone on same page
Reduces disputes
✅ Create payment report for deposit
List all checks received
Total amount for bank deposit
Use for reconciliation
✅ Follow up on partial payments
Note when remainder is due
Set reminder for follow-up
Track aging appropriately
For Maryland/DC Customers (Potomac Workflow)
💡 Save customer's remittance format
Many customers use same format each time
Keep example for reference
Train staff on that customer's pattern
💡 Batch process at end of day
Collect all checks received
Process bulk payments together
More efficient than throughout day
💡 Use customer payment patterns
Some always pay oldest first
Some always pay specific invoices
Document their preferences
Troubleshooting
"Total allocated doesn't match payment amount"
Problem: Sum of allocated amounts ≠ payment amount entered
Solutions:
Verify payment amount is correct:
Check the physical check
Confirm you entered the right total
Check allocation math:
Re-calculate manually
Use calculator to sum allocations
Adjust amounts:
If over-allocated: Reduce one or more amounts
If under-allocated: Increase or add more allocations
Use "Auto-Allocate" to recalculate:
Click Auto-Allocate to let system distribute
Then adjust as needed
Cannot select invoices from different customers
Problem: Trying to select invoices from Customer A and Customer B
Why: Bulk payment only works for same customer (one check = one customer)
Solution:
Record separate bulk payments for each customer
Or use individual payment entry if different customers
Invoice not appearing in list
Problem: Customer's invoice not showing when filtered
Check: ✓ Is invoice status Delivered? (Only delivered invoices can be paid) ✓ Is invoice already paid? (Filter might be hiding paid invoices) ✓ Is invoice for correct customer? (Check spelling/account) ✓ Is invoice cancelled? (Cancelled invoices cannot be paid)
Solution:
Adjust filters to show all statuses
Search by invoice number specifically
Verify invoice status with supervisor
Allocation grid not saving
Problem: Click save but nothing happens
Check: ✓ Do totals match exactly? ✓ Are there validation errors shown (red text)? ✓ Is any field blank or invalid? ✓ Browser console showing errors?
Solution:
Fix any validation errors shown
Ensure all required fields filled
Try refreshing page and re-entering
Contact support if persists
Check number already used warning
Problem: System warns check number exists
Possible causes:
Already entered this payment: Check if you already saved it
Bulk payment needs to be used: If same check pays multiple invoices
Duplicate check number from customer: Rare but possible
Typo in check number: Verify you typed correctly
Solution:
Search for existing payment with that check number
If not duplicate, add note explaining situation
For same check/multiple invoices: That's what bulk payment is for!
Verify check number is correct
Accidentally entered as individual payments
Problem: Realized after entering individually that should have used bulk
Solution:
Delete individual payments (if not yet synced to QB)
Re-enter using bulk payment entry
Or: Keep as is - functionally the same, just more work
See: Handling NSF Checks & Payment Reversals for deleting payments
Real-World Example: Potomac Selections Workflow
This is the actual workflow that prompted this feature.
The Scenario
Customer: Osteria Restaurant (Maryland) Check Received: #4821 dated 03/20/2026 Check Amount: $3,247.82 Invoices to Pay: 5 invoices from February deliveries
Invoices:
Invoice 136001: $687.00
Invoice 136023: $542.50
Invoice 136045: $728.32
Invoice 136078: $644.00
Invoice 136089: $646.00
Total: $3,247.82
The Old Way (Before Bulk Payment)
Aaron had to:
Open Invoice 136001
Click Record Payment
Enter: Check #4821, Date 03/20/2026, Amount $687.00
Save
Repeat steps 1-4 for Invoice 136023
Repeat steps 1-4 for Invoice 136045
Repeat steps 1-4 for Invoice 136078
Repeat steps 1-4 for Invoice 136089
Time: 2 minutes × 5 invoices = 10 minutes Errors: High risk (typos, wrong amounts, etc.)
The New Way (With Bulk Payment)
Aaron now:
Filters orders by "Osteria"
Selects all 5 unpaid invoices (checkboxes)
Clicks "Record Bulk Payment"
Enters once: Check #4821, Date 03/20/2026, Amount $3,247.82
Clicks "Pay in Full" (amounts auto-fill)
Verifies total matches: ✓ $3,247.82
Saves
Time: 2 minutes total Errors: Minimal risk (one entry point) Time Saved: 8 minutes per customer × multiple customers per day = Hours per week
Why This Matters
Potomac Selections processes dozens of these types of payments weekly from Maryland and DC customers. The bulk payment feature:
✅ Saves hours of staff time each week ✅ Reduces data entry errors dramatically ✅ Improves employee satisfaction (less tedious work) ✅ Allows staff to focus on customer service ✅ Ensures accurate bank reconciliation
Customer Feedback: "This has been a game-changer for our payment processing workflow."
Related Documentation
Payment Topics
Recording Individual Payments - For single-invoice payments
Handling NSF Checks & Payment Reversals - If check bounces or mistake made
Payments Troubleshooting - Common payment issues
Related Workflows
Need Help?
For payment entry issues:
Check Payments Troubleshooting
Verify all prerequisite steps completed
Contact your system administrator
Last updated
Was this helpful?