How Cash Receipts Entry Works
The process connects the actual receipt of customer funds with the related receivable in Sage 100. The user typically selects the appropriate bank or cash account, enters the receipt date and payment reference, identifies the customer, and records the amount received. The payment can then be allocated to one or more invoices, depending on the customer's remittance details.
Accurate entry depends on matching the payment to the correct customer and transaction. If a customer pays several invoices in one transfer, the receipt may need to be distributed across multiple open items. If the payment is short, includes an unexplained deduction, or lacks invoice references, the finance team should review the details before finalizing the allocation.
A Cash Accounting Entry records the accounting effect of a cash transaction. Cash Receipts Entry supports this broader accounting process by recording the receipt and helping maintain the relationship between cash, customer balances, and the general ledger.
Steps for Entering Customer Receipts
Exact navigation and field names may vary by Sage 100 version, company setup, and security permissions. A typical workflow follows these steps:
- Open Cash Receipts Entry: Navigate to the appropriate Accounts Receivable entry screen and select the relevant batch or transaction workflow, if applicable.
- Enter receipt details: Record the receipt date, payment method, bank or cash account, payment reference, and amount received.
- Select the customer: Confirm the customer account and review the outstanding invoices or balances available for application.
- Apply the payment: Allocate the receipt to the intended invoice or distribute it across multiple invoices according to the remittance advice.
- Review and post: Verify the receipt total, applied amounts, remaining balances, and accounting details before completing the applicable posting process.
After posting, review the customer account and relevant reports to confirm that the receipt was recorded as intended. Retain remittance advice, bank references, and supporting correspondence in line with the company's recordkeeping procedures.
Worked Example and Accounting Impact
Assume a customer has two open invoices: Invoice A for $1,800 and Invoice B for $1,200. The customer sends a payment of $2,000 and specifies that $1,800 should settle Invoice A, with the remaining $200 applied to Invoice B.
- Total cash received: $2,000
- Applied to Invoice A: $1,800
- Applied to Invoice B: $200
- Remaining balance on Invoice A: $0
- Remaining balance on Invoice B: $1,000
The receipt is fully allocated because the applied amounts total $2,000. In the accounting records, the transaction generally increases cash or the designated deposit account and reduces accounts receivable by the amount applied. The exact posting accounts depend on the company's configuration and the transaction workflow.
Controls, Matching, and Tax Considerations
Before posting, verify that the payment amount agrees with the bank record or remittance advice, the customer is correctly identified, and each invoice allocation is supported. Invoice matching and validation controls can help establish whether the supporting documents and recorded transaction details agree. The article Unmask Vendor Fraud with AI-Driven Invoice Matching discusses how matching documents, receipts, and transaction history can strengthen accuracy and support the detection of duplicate or unauthorized transactions in invoice workflows.
Tax-related adjustments should be reviewed separately when a receipt includes tax deductions, withholding, exemptions, or other jurisdiction-specific treatment. Understanding tax compliance requirements helps finance teams validate applicable rules, retain supporting evidence, and maintain audit-ready records. The treatment of a customer deduction depends on its nature and the company's accounting policies; it should not automatically be treated as a reduction in the invoice balance without appropriate review.
Cash Visibility, Forecasting, and Automation
Reliable cash receipts data supports short-term liquidity planning and working capital decisions. Receipts Modeling uses assumptions and business data to estimate expected incoming funds, while a Receipts Forecast projects when customer payments may arrive. Both depend on dependable receivables information, including payment history, open invoices, and unapplied receipts.
Finance teams using an ERP such as Datacor can extend their finance workflows through ERP integration and cash application capabilities that help match payments with invoices and route exceptions for review. For decisions involving cash visibility, liquidity, and treasury planning, Beyond Traditional Automation: The AI Advantage in Finance Functions explores how AI-led workflows can support more informed finance decisions.
Within the Hyperbots Platform, company-specific configurations can align workflows, roles, ERP connections, and general ledger structures with business requirements. Process Specific Capabilities support finance workflows using domain-trained AI, while Ready to Deploy Capabilities provide pre-trained agents and ERP connectors for relevant tasks. Self Learning Capabilities help refine workflows using human feedback, and Human in the Loop processes allow exceptions to be escalated for review and approval.
Best Practices and Summary
Enter receipts promptly, use consistent payment references, reconcile recorded receipts to bank activity, and investigate unapplied cash regularly. Review partial payments and deductions carefully, and ensure that posting periods and account mappings follow company policy. These practices improve the reliability of customer balances and provide a stronger basis for collections, reconciliation, and cash forecasting.
Sage 100 Cash Receipts Entry helps businesses record incoming customer payments, apply funds to outstanding receivables, and maintain accurate financial records. Consistent entry and review procedures improve cash visibility, support financial reporting, and help teams make better decisions about outstanding customer balances.