How to Write Off Transactions in Accounts Receivable for Sage 300

Before You Start

  • Decide on the type of transactions or balances to write off. You can write off outstanding transactions, overdue transactions, overdue balances, outstanding balances, or outstanding retainage.
  • Decide on the type of customer account whose transactions or balance you will write off. You can write off balances for open item, balance forward, or all customers.
  • Decide whether to select amounts to write off by a range of amounts or by a percentage of the original document or account balance. For example, you might decide to write off all documents with an outstanding balance of between 0 and 5 dollars, or with overdue balances of up to 5 percent of their original amounts.

To write off overdue or outstanding transactions:

  1. Open Accounts Receivable > Periodic Processing > Create Write-Off Batch.
  2. In the Run Date field, specify the date to use as the document date for all the adjustments in the write-off batch.
  3. In the Posting Date field, specify the date to which to post the batch. The posting date also determines the year and period to which the adjustments are posted in General Ledger.
  4. In the Write-Off Type field, specify whether to write off outstanding transactions, overdue transactions, overdue balances, outstanding balances, or outstanding retainage.
  5. Specify the As Of Date from which to age documents or balances to be written off, and (depending on the write-off type) specify the Days Outstanding or the Days Overdue.
  6. If you use multicurrency accounting, type the currency code.
  7. In the Account Type field, select a customer type or select All Customers.
  8. If you are writing off outstanding or overdue transactions, select the types of transactions to write off from the Include group of fields.
  9. For the Select By option, indicate whether to write off by amounts or percentages, and then enter the range of amounts or percentages.
  10. In the bottom Select By group of fields, specify the ranges of records from which to select transactions to write off.
  11. If you use adjustment optional fields, specify optional fields and values on the Optional Fields tab.
  12. Click Process

After creating a write-off batch

  • Use the A/R Adjustment Entry screen to make any changes you need to the transactions created by the Create Write-Off Batch screen. 
  • Print the batch listing.
  • Post the adjustment batch using the A/R Adjustment Batch List screen or the A/R Post Batches screen