How Customer Prepayments Work in Sage 100
The process starts when a customer pays an advance against a future order, contract, or service. The finance team identifies the customer, records the receipt using the appropriate Sage 100 workflow, and documents the order or agreement the payment relates to. Depending on the company's setup, the receipt may be tracked as a customer deposit, an unapplied receipt, or another designated balance until it can be applied appropriately.
When the invoice is created, the team reviews the original advance and determines how much should be applied against the amount due. The remaining balance becomes the customer's outstanding receivable, if any. The precise screens and posting accounts depend on the Sage 100 version, configuration, and accounting procedures, so teams should follow their documented process rather than assume all installations handle prepayments identically.
Recording and Applying an AR Prepayment
A reliable process connects the incoming cash to the correct customer and future transaction. Finance teams should retain the payment reference, receipt date, amount, order number, and any agreement specifying how the advance will be used. This documentation supports the later application of the payment and helps explain the balance during reconciliation.
- Identify the customer: Confirm the customer account and payment reference before recording the receipt.
- Link the advance: Record the associated sales order, contract, or deposit purpose where the system and workflow allow.
- Use the correct account: Apply the company's approved accounting treatment for customer advances and any related liability or deposit account.
- Apply against the invoice: When the related invoice is available, allocate the advance according to the agreed terms and verify the remaining amount due.
- Reconcile the balance: Compare customer activity, deposit records, and general ledger postings to confirm that the advance is accounted for consistently.
Strong cash application practices help match incoming receipts to customer records and invoices. When a receipt cannot yet be matched to an invoice, the team should preserve its identity and purpose instead of treating it as a settled invoice balance.
Worked Example of a Customer Advance
Assume a customer orders equipment for $5,000 and pays a $1,500 advance before delivery. The business records the receipt and tracks it against the order under its approved accounting policy. When the equipment is delivered and the $5,000 invoice is issued, the finance team applies the $1,500 advance to the customer balance.
The remaining amount due is calculated as follows: $5,000 invoice amount − $1,500 advance = $3,500 outstanding. This example assumes the entire advance is eligible for application and excludes taxes, additional charges, and other adjustments. The team should ensure that the accounting entries correctly reflect the receipt, any liability recognition, the invoice, and the advance application.
Accurate handling supports collections by ensuring that follow-up activity reflects the true balance. AR Automation Software can support invoice matching and customer follow-ups, while collections workflows can prioritize outstanding balances after the advance has been applied and the amount due is confirmed.
Controls, Reporting, and Process Improvements
Finance managers should periodically review advances that remain open, confirm that each balance is linked to a valid customer transaction, and investigate amounts that have not been applied after invoicing or delivery. Useful controls include authorized posting, clear ownership of exceptions, documented approval for adjustments, and reconciliation between customer records and the general ledger.
An AR Audit can help verify that receipts, applications, and related accounting entries are supported by appropriate documentation. AR Data Analytics can help teams examine deposit aging, unapplied receipts, and trends by customer or business unit. An AR KPI, such as the proportion of advances applied within a defined period, can help managers monitor whether the process is keeping pace with invoicing and fulfillment.
The Hyperbots Platform supports finance automation and ERP-connected workflows. Suitable integrations can help exchange customer, invoice, and receipt information across systems, subject to the supported connectors and the organization's configuration. These tools should complement clear accounting rules and review controls, not replace the company's responsibility to validate the appropriate treatment of customer advances.
Summary
Sage 100 Prepayments AR concerns customer money received before the related invoice is fully settled or the associated goods and services are delivered. Finance teams should identify the customer and transaction, record the receipt using the approved accounting treatment, apply the advance when appropriate, and reconcile the resulting balances. Consistent controls and useful reporting help keep customer accounts accurate, support collections, and improve cash flow visibility.