Standard Invoice Payment Process
The most common method for paying invoices in Sage 100 involves using the Invoice Payment Selection feature. This systematic approach ensures proper documentation and accurate record-keeping.
Initial Setup Before processing any payments, ensure you have proper vendor information and payment methods configured in your system. Navigate to Vendor Maintenance and verify that all vendor details, including payment terms and preferred payment methods, are correctly set up.
Payment Selection Process
- Navigate to Accounts Payable > Main > Invoice Payment Selection
- Enter the payment date and select the invoices you wish to pay
- Hold the Control key to select multiple specific invoices, or choose to pay all available invoices
Payment Processing Once you've selected the invoices, you can process the payments through various methods:
- Check printing for traditional paper checks
- ACH file generation for electronic payments
- Credit card processing for card payments
Credit Card Payment Processing
When paying invoices using a corporate credit card, follow these specific steps to ensure proper recording and reconciliation.
Credit Card Vendor Setup
- Go to Vendor Maintenance
- Select the credit card vendor (e.g., American Express, Visa)
- Check the "Credit card vendor" box in the vendor profile
Transfer Process To transfer vendor invoices to your credit card account:
- Access A/P Invoice Data Entry
- Enter the credit card vendor information
- Input the statement reference number
- Enter the total statement amount
- Navigate to the Lines tab and click the "Transfer" icon
- Select the specific vendor invoices paid by credit card
Manual Check Entry
For situations requiring immediate payment or special handling:
Direct Payment Steps
- Navigate to Accounts Payable > Main > Manual Check Entry
- Enter the vendor number
- Input the check number and payment amount
- Select the specific invoice(s) being paid
Electronic Payment Processing
Modern payment methods often involve electronic transfers and ACH payments. Sage 100 supports these payment types with integrated processing.
ACH Payment Setup
- Configure vendor electronic payment information
- Select eligible invoices for payment
- Generate the ACH file for bank upload
- System automatically sends remittance advice to vendors
Payment Verification and Reporting
After processing payments, it's crucial to verify and document all transactions properly.
Verification Steps
- Review the Daily Transaction Register
- Check the AP Aged Invoice Report
- Verify vendor open invoice status
- Confirm payment posting in the general ledger
Available Reports
- AP Aged Invoice Report
- Vendor Payment History
- Check Register
- Payment Transaction Detail
Special Considerations
Invoice Adjustments If you need to adjust a posted invoice before payment:
- Select Accounts Payable > Main > Invoice Data Entry
- Enter the vendor number and invoice number
- In the Adjust Invoice window, click "Adjust"
- Enter the adjustment amount (use minus sign for decreases)
- Specify the GL account for the adjustment
- Update the Invoice Register
Payment Holds To place an invoice on hold:
- Access the invoice in Invoice Data Entry
- Check the "Hold Payment" option
- Enter a comment explaining the hold reason
- Save the changes
Multi-Company Processing
When dealing with multiple companies in Sage 100:
Company Selection
- Verify the correct company is selected before processing payments
- Ensure proper inter-company accounting if applicable
- Confirm company-specific payment settings
Batch Processing
- Group similar payments together
- Process payments by company code
- Maintain separate payment runs for different entities
Payment Documentation
Maintaining proper documentation is essential for audit purposes and tracking:
Required Documentation
- Original vendor invoices
- Payment authorization forms
- Remittance advice copies
- Bank reconciliation records
Electronic Records
- Store digital copies of all payment-related documents
- Maintain audit trails of payment processing
- Keep electronic remittance records
System Maintenance
Regular system maintenance ensures smooth payment processing:
Periodic Tasks
- Update vendor payment information
- Review and adjust payment terms as needed
- Verify bank account information
- Check payment processing settings
Security Considerations
- Maintain proper user access controls
- Regular review of payment authorization limits
- Monitor system audit trails
Integration with Other Modules
Sage 100's payment processing integrates with various modules:
Bank Reconciliation
- Automatic clearing of processed payments
- Real-time payment status updates
- Integrated bank statement reconciliation
General Ledger
- Automatic posting of payment transactions
- Detailed audit trails
- Comprehensive financial reporting
Best Practices
To ensure efficient and accurate payment processing:
Payment Scheduling
- Establish regular payment processing schedules
- Review due dates and payment terms regularly
- Plan for holiday and weekend payment processing
Quality Control
- Double-check payment amounts and vendor information
- Verify bank account details for electronic payments
- Review payment batches before final processing
Record Keeping
- Maintain detailed payment records
- Document any special payment arrangements
- Keep audit trails of all payment activities
By following these comprehensive guidelines and maintaining proper procedures, you can effectively manage invoice payments in Sage 100 while ensuring accuracy and maintaining proper financial controls. Regular review and updates of these processes will help optimize your accounts payable operations and maintain strong vendor relationships.
Citations: [1] https://www.dwdtechgroup.com/sage-100-mas-90-200/adjust-an-accounts-payable-posted-invoice-in-sage-100/ [2] https://www.rklesolutions.com/blog/settle-vendor-invoice-paid-credit-card-sage-100 [3] https://help.ebizcharge.com/2024/03/15/dont-delete-ebizcharge-for-sage-100-user-guide-updated-copy/ [4] https://www.youtube.com/watch?v=v4z9l9eapog [5] https://support.paya.com/44627-sage-100/video-how-to-process-a-credit-card-payment-against-a-sales-invoice-in-sage-100-erp [6] https://help-sage100.na.sage.com/2024/Subsystems/AP/APMAINFIELD/Manual_Check_Entry_-_Fields.htm [7] https://www.youtube.com/watch?v=lS8pGLGAyTA