Prepare Before Entering a Cash Receipt
Before entering a payment, gather the bank deposit information, remittance advice, customer details, and invoice references. Confirm the amount received and determine whether the payment covers one invoice, several invoices, or only part of an outstanding balance. If the customer has deducted a credit or paid several accounts together, identify the supporting documentation before allocating the receipt.
Preparation helps the AR team select the correct customer and apply the payment to the intended transactions. It also supports appropriate separation between recording a receipt and investigating an unresolved difference.
- Customer information: Confirm the customer account number and account name.
- Payment details: Verify the receipt date, amount, payment method, and check or reference number where applicable.
- Invoice references: Identify the invoices covered by the remittance advice.
- Supporting evidence: Keep bank records, remittance details, and any approved adjustments available for review.
Steps to Apply Cash Receipts in Sage 100
Step 1: Open Cash Receipts Entry. Navigate to the Accounts Receivable cash receipts function available in your Sage 100 installation. Select the appropriate deposit or receipt batch according to your organization's established process.
Step 2: Enter the receipt details. Select the customer account and enter the payment date, amount, and applicable payment reference. Confirm that the receipt information agrees with the bank record or other supporting evidence.
Step 3: Select the invoices. Review the customer's outstanding invoices and identify the transactions being paid. Apply the appropriate amount to each invoice. For a partial payment, enter only the amount received against that invoice and leave the remaining balance open.
Step 4: Review the allocation. Check that the total amount applied agrees with the receipt amount, taking account of any authorized discounts or adjustments. Investigate differences before finalizing the entry rather than assigning an unsupported amount to an invoice.
Step 5: Validate and post. Review the batch totals, customer details, and transaction references. Complete the applicable approval and posting steps under your organization's procedures, then confirm that the receipt and customer balances reflect the posted transaction.
Exact field names and posting behavior can differ by version and setup. Follow the relevant Sage 100 documentation and internal controls when performing these steps.
Worked Example: Applying a Customer Payment
Assume a customer has two outstanding invoices: Invoice A for $3,200 and Invoice B for $1,800. The customer sends a payment of $4,000 and remittance advice identifies both invoices. The payment is allocated as follows, assuming no discounts, fees, or other adjustments apply.
- Invoice A: Apply $3,200, leaving a balance of $0.
- Invoice B: Apply $800, leaving a balance of $1,000.
- Total applied: $3,200 + $800 = $4,000.
The receipt is fully allocated, and Invoice B remains partially outstanding. This distinction matters for customer statements, collection priorities, and aging reports. The remaining $1,000 should continue to be monitored until another payment or an authorized adjustment settles it.
Handle Exceptions and Maintain Accurate Records
Some receipts require additional investigation before they can be applied accurately. A customer may provide incomplete remittance information, pay multiple invoices with one transfer, or remit an amount that differs from the invoice balance. In these cases, retain the receipt details, investigate the difference, and follow the organization's process for unresolved or unapplied cash.
The cash application workflow can be supported by ERP-connected tools that match incoming payments to invoices and route exceptions for review. When extending an existing Sage 100 environment, teams should verify that the integration preserves customer identifiers, payment references, amounts, and posting status. Sage Intacct Integration is a related example of an ERP integration concept, although Sage Intacct and Sage 100 are distinct products.
Where automated finance workflows are used, Hyperbots Platform capabilities can be configured around relevant company processes and ERP requirements. Process Specific Capabilities support workflow-oriented finance tasks, while Ready to Deploy Capabilities provide preconfigured functionality that can be tailored to an implementation. Self Learning Capabilities use feedback from human actions to refine supported workflows. The Human in the Loop approach keeps designated employees involved in reviewing exceptions and making decisions that require judgment.
These practices complement established reconciliation and posting controls. They do not replace the need to verify payment evidence, confirm allocations, and maintain appropriate approval records.
Reconciliation, Forecasting, and Financial Impact
After posting, review the customer's account to confirm that the correct invoices were reduced and any remaining balance is accurate. Reconcile cash receipt totals with bank deposits and the relevant accounting records according to the organization's close procedures. This helps ensure that recorded receipts agree with actual funds received.
Receipts Modeling helps businesses analyze expected and actual incoming payments under different assumptions. A Receipts Forecast estimates the timing and amount of future receipts using information such as outstanding invoices, payment terms, and historical customer behavior. Accurate cash application strengthens these activities because the forecast can distinguish settled invoices from amounts still due.
Better receipt visibility supports working-capital decisions and cash flow planning. The article Beyond Traditional Automation: The AI Advantage in Finance Functions explores how AI-led finance workflows can improve visibility and decision-making. For related tax processes, tax compliance involves validating applicable tax rules and maintaining supporting records, while remaining distinct from the task of applying customer cash receipts.
Summary
To apply cash receipts in Sage 100, open the appropriate cash receipts function, enter verified payment details, select the customer invoices, review the allocation, and complete the required posting steps. Reconcile the posted receipt against bank and customer records, and investigate any unapplied amounts or discrepancies. Consistent procedures, accurate remittance information, and appropriate review controls help maintain reliable receivables balances and improve cash visibility.