The discount taken after the period
What the user reports
First week of January at Rockford. Brennock bought one ES-200 on BWU-PO-5752 with terms 2D10: 2% off if paid within 10 days, so by 31 December. Brennock's remittance advice is dated 30 December and says 4,237.89, the invoice less 2%. The bank's advice shows the money arrived on 4 January. The payment is on Calder's books, the invoice is cleared, and 86.49 sits on Cash discounts granted. Calder's controller checks every discount against the bank before the books close.
The error: Brennock's payment for BWU-PO-5752 is posted with value date 2026-12-30 and took a cash discount of 86.49, but the bank received the money on 2027-01-04, four days after the discount ran out.
What you'll do
- See the problem as the accounts receivable accountant: On Incoming payments, under Payments posted, compare the date of Brennock's payment for BWU-PO-5752 with the bank's advice: the money reached Calder's account on 2027-01-04. A discount may stand only when the money arrived by its last day.
- Find the cause: The discount ran out on 31 December and the money arrived on 4 January. Why did the system grant 86.49?
- Fix it as the accounts receivable accountant.
- Prove it: run the step that failed again.
The drill runs in the lab on its own prepared copy of the fictional Calder Pumpworks, saved in this browser apart from your company. All codes and values are fictional course labels.
Answer and explanation (open after the drill)
The fix: The payment was keyed with the remittance's date as its value date; the discount check reads that date, so it saw a payment made on 30 December.
The check is right; its input was wrong. A cash discount stands when the payment's value date is on or before the discount's last day, and the value date was typed from Brennock's remittance advice (30 December) instead of the bank's receipt (4 January). The terms count calendar days, the order's 2D10 is what billing copied, and the write-off limit only applies to a difference posted as a write-off, never to a discount.
Why it broke
The value date was typed from the customer's remittance advice, which says when Brennock sent the money, not when Calder received it. The discount check compared the right rule with the wrong date, so an unearned discount posted as if it were earned and the invoice closed.
How teams prevent it
Take the value date from the bank's statement, not from the remittance: post receipts from the statement where you can, and key by hand only with the bank's date in front of you. A worklist of discounts taken within a few days of their last day, checked at month end, catches the rest.
Across teams
Accounts receivable keyed the date, the controller found the discount at the close, the credit manager decides whether to ask Brennock for 86.49 or let it go as goodwill with a reason, and Brennock's accounts payable gets a short note instead of a dunning letter.
Where AI fits
Plain automation, with a prediction where it helps: matching receipts from the bank's statement fixes the date at the source, and a rule flags every discount whose money arrived after its last day. A model can rank which customers are worth asking for a small unearned discount, from their history; the credit manager decides.
Learn more: Order to cash end to end