Request from my finance team “I’d like to have all balances under $1 on the AR report (doesn’t matter positive or negative) to be written off to account 94030 Rounding Gain / Loss.” Anyone ever dealt with something similar? theres 1000s of entries.

We have script to write off invoices which have balances less then $10 left on them. Script run at month end and create credit memo and apply it to invoice and close the invoice.

I'm not sure I'd drop it into a rounding gain/loss account, because uh.. not currency revaluation process generating it. That said, you should be able to do this with a CSV import as well

thank you guys I will try the csv import first. Not too great with scripting. @KevinJ of Kansas any insight on how should I proceed with the csv import? just downloading all by a search and changing it to a desired account and updating via csv import?

I'd capture the internal ID of the customer (i'd suggest using a column header text other than just internal ID), internal ID of the invoice (i would suggest using a column header text other than internal ID), the amount remaining. once I've downloaded it, I'd make my own external ID up, and then the rest of it is just mapping the amount and application on the import. Do one transaction first to make sure you have it right. Then try 2. If it works the same when you do that, then you should be good to do the rest

I hve come across AR Deduction and Charge back app in market place to automate write off small balances whichare less than $1. I found issues in running script, MR script is showing error: