Clear stale items from a Sage 50 US Aged Receivables report

If an old Sage 50 US receivables line looks wrong, identify the document and any matching payment or credit before correcting it. A remaining open item can reflect a balance, a refund or an unapplied credit.
Upload a case

Key facts

Keep the original report and the correction reference so someone else can reconstruct the change.

Trace the item back to the ledger

Run the report with detail and capture the customer, document reference, date and amount. Check the customer ledger and payment records for an unapplied item or an actual unpaid invoice. Continue collections on an invoice only when the outstanding amount is supported.

Check whether the transaction year is closed

Sage’s guide to old aging-report items describes applying an offsetting transaction dated in the first open period when the original transaction is in a closed year. The reversal changes the general ledger. Give finance the two documents and obtain approval for the posting treatment before recording the correction.

Check the report at the corrected cutoff

Rerun the report using a cutoff that includes the reversal. A historical report dated before that posting still reflects the open item at its cutoff. Compare the customer total and document results with the approved entry. If several items are affected, use the receivables reconciliation template and give each unresolved item an owner.

RELATED ARTICLES

Illustration of a free e-book representing the 'Free International Debt Collection Guide.' This guide offers proven debt collection techniques. Get your free copy now.
FREE GUIDE

Download our free debt collection guide

Practical steps to get unpaid invoices paid, at home and abroad. Download our debt collection guide for free.

Thank you! The guide will land in your inbox shortly
Oops! Something went wrong while submitting the form.