Is there a query for bad debt ?

[mzrdmd]

Is there a query that will show me who I have written off bad debt for, how much, and when ?

I've had it with people stiffing me and getting away with it, and I'm ready to take them to the magistrate.

Thanks,

Mike

[jordansparks]

Depends on how you "wrote it off". The usual way of doing it is to leave their full balance in place until you are ready to send them to collections. At that point, you enter an adjustment to bring their account down to zero. At the same time, you change their billing type to "sent to collections" and change them to inactive. They then owe the collections agency that money, not you. As checks trickle in from the collections agency, you put those payments onto their account along with another adjustment to keep their balance at zero.

[mzrdmd]

Thanks, Jordan. I just created an adjustment called "Bad debt". Is there a way to generate a report on that ?

Thanks,

Mike

[DavidWolf]

You can run that under reports, daily, adjustments, just select that type of adjustment and the dates and you are all set.

[Tom Zaccaria]

You understand that the report is from the time you first created the adjustment.
If you want to include previous months you must go back and manually recode the old accounts as 'Bad Debt'.
Might not be a bad idea because then you will have an accurate report as to the total dollar amount.

drtmz