Skip to content
Mindover Software Logo with tagline

How to Write Off Transactions Using A/R Periodic Processing in Sage 300

in: Accounting, Sage 300 ERP, Company News

In this tutorial, we review how to use periodic processing in Accounts Receivable to write off transactions, such as short pays or overdue balances. For our example we will look to write off balances on all customers at 5% of the original balance 180 overdue.

Sage 300 Accounts Receivable

Start by navigating to the Accounts Receivable → A/R Periodic Processing → Create Write-Off Batch.

In the Run Date field, enter the date for write-off batch. In the Posting Date field, select the date to post the batch.

In the Write-Off Type field, specify what type of transactions to write off. For this demo, it will be overdue balances. Select the As Of Date from which to age the overdue balances, and enter the Days Overdue. This is only necessary depending on the write-off type. As we are writing off overdue balances, then it needs to be specified how far overdue the balances should be.

Next, specify the Account Type from the dropdown list.

In the Select By area, indicate whether to write off by amounts or percentages, and then enter the range of amounts or percentages.

*Please note: When choosing to write off outstanding or overdue transactions (as selected in the Write-Off Type), check the types of transactions to write off from the Include group of fields.

In the bottom Select By fields, specific ranges of transactions to write off may be selected. For example, if it is a specific customer’s balances or short pays that need to be written off, then this is where it would be specified. Also, if used, optional fields and values may be entered in the Optional Fields tab. For this tutorial, these will not be used.

Once all necessary information is entered, then click the Process button at the bottom of the screen.

A message window will appear to confirm the processing completed and which adjustments were created.

After creating the write-off batch, navigate to A/R Transactions and go to the A/R Adjustment Entry screen to make any changes necessary. Save, print, and post the batch listing.

See it in action with this video!

Mindover Software Logo with tagline

Mindover Software

15901 Central Commerce Drive, Suite 203
Austin, Texas 78660
Phone: 512-990-3994
Fax: 512-251-8992

About Us

Started in Austin, Texas in 2000, Mindover Software has been providing award-winning software and consulting solutions spanning the business lifecycle to small and medium sized business. Now, with consultants in Dallas, San Antonio, Austin, Boise, and San Diego, Mindover Software provides strong local support with the resources of a national company.

Acumatica Cloud ERP Gold Certified Partner logoSAGE Authorized Partner logo