Prerequisites
- Purchase Orders exist with valid suppliers and amounts
- Suppliers have Payment Terms set (e.g., Net 30, Net 60)
Overview
Overview
What it does:
Allows you to define payment schedules on purchase orders and then create, track, and submit payment entries when due.Why it matters:
Allows you to define payment schedules on purchase orders and then create, track, and submit payment entries when due.Why it matters:
- Ensures on-time supplier payments
- Improves cash-flow planning
- Reduces late-payment fees and strengthens vendor relationships
1.0 Define Payment Terms on Purchase Orders
- Go to
Buying > Purchase Order > New(or open an existing PO). - In the header, find Payment Terms Template.
- Select a template (e.g., Net 30).
- Add or adjust Payment Schedule rows specifying:
- Due Date (e.g., 30 days from invoice date)
- Amount (%) or Fixed Amount
- Click Save and Submit your PO.
Create custom Payment Terms Templates under Buying > Setup > Payment Terms for repeated use.
2.0 Generate Payment Reminders
- Go to
Buying > Reports > Supplier Due Date. - Filter by:
- Supplier (optional)
- From Date / To Date
- Click Refresh to see all upcoming and overdue payments.
- Export or schedule the report to email yourself or your team.
Bookmark this report on your dashboard for daily monitoring.
3.0 Create a Payment Entry
- Navigate to
Accounts > Payment Entry > New Payment Entry. - Select Payment Type:
- Pay (outgoing) for supplier invoices
- Receive (incoming) if refunding
- Set Party Type = Supplier and Party = [Supplier Name].
- Link the related Purchase Invoice or Journal Entry in the References table.
- Confirm Paid Amount, Payment Account, and Bank Charges (if any).
- Click Save, then Submit.
The system automatically applies the payment to the invoice based on the schedule you defined.
4.0 Reconcile Payments
- Go to
Accounts > Bank Reconciliation. - Select your Bank Account.
- Enter Statement Date and Closing Balance.
- Click Get Entries to fetch unreconciled Payment Entries and bank statement lines.
- Match each payment entry to its bank transaction.
- Click Reconcile to finalize.
Regular reconciliation keeps your ledger and bank statement in sync and highlights discrepancies early.