Hi cleopas Madovi ,

Thank you for reaching out about how to handle unapplied cash on your AR aging report for a customer you will no longer trade with. 

From what you've described, here's a concise summary of the options available to you:

1. If the unapplied cash receipt should be removed completely, consider voiding it. Instructions for voiding a cash receipt can be found in this article.

2. If the receipt is valid and represents an overpayment, you can apply it to an invoice or adjust it to remove it from the AR aging report. If there are no unpaid invoices to apply the receipt to, you may need to temporarily unapply a cash receipt from a paid invoice and then reapply the receipts to net them off.

3. For positive and negative balances that result from unapplied cash receipts, you have two options:

   • Apply the receipts: Match the positive cash receipt with a negative one on an unpaid invoice.
   • Void the receipts: If they are from the same deposit date and net to zero, you can void them to clear the issue without affecting the cash management.

4. In cases where a cash receipt shows on the aging due to incorrect application or unapplication dates, you'll need to research and correct the accounting date.

Should you need more detailed guidance or if you encounter difficulties following these steps, Sage support is available to assist you further. Chat with support here.

Warm Regards,
Erzsi