Bad Debts

In order to identify the practice's bad debts you will firstly need to know what money is currently owing to the practice. There are two in-built reports within Genie which can assist in determining this.

1. Unpaid Invoices report

The Unpaid Invoices report can be accessed by navigating to File > Maintenance and Reports > Monthly tab. This report can be run to show all outstanding invoices owing for a specified period of time and can include unprinted invoices if the preference is marked. For further information on using this report have a look at the Unpaid Invoices Report article.

2. Aged Debtors report

The Aged Debtors report can be accessed by navigating to File > Maintenance and Reports > Practice Analysis tab. This report can be run to show how long an account has been owing for.  It is important to remember that the Aged Debtors report will not include invoices which have not been printed - i.e. the sale does not have a print date recorded against it. This is based on the theory that if an account holder has never been presented with an invoice (e.g. it hasn't been printed) then they can't know that it is outstanding and as such the debt should not be aged.

In order to reflect that you will not be receiving payment for an invoice you will need to apply a credit to the invoice. This can be done by following the below steps:

1. Navigate to Open > Account Holders
2. Search for the account holder with the balance to be credited off by entering the name of the account holder in the relevant field and clicking OK
3. With their record highlighted, navigate to Billing > Account History
4. Select the invoice in question from the list of invoices down the left of the window
5. On the right side of the window slow double click in the Credit column cell for the relevant item to highlight
6. Enter the amount to credit off (usually the balance)
7. Hit Enter and type a reason for the credit, such as ‘Bad Debt’ (the default response which will appear automatically)
8. Repeat for any other items on the invoice

In the Payments section at the bottom of the Account History window, the credit will appear with the code of ‘2’ for credit, and the reason you have entered will appear in the Form column.

In order to quickly identify how much you have credited off within a given period, you can run a Credits Report by performing the below steps:

1. Navigate to File > Maintenance and Reports > Administrator > Payments > Show Credits
2. Choose a date range from the Period drop-down or enter your date range you wish to search for bad debts in
3. Select whether you want to view credits for all providers or just the one you select
4. Click the OK button
5. The resulting window shows the individual credits that fit into your search criteria, as well as the total of these credits, at the bottom right hand corner of the window
6. Double click on a result here to open a window that details more information about that particular credit, such as the reason you gave for the credit in the Payment Type area

This report can be printed by the printer icon available in this window which will open the Report Builder window. You can then select the Columns tab, drag across any desired fields you would like your report to display and print, preview, or export as desired. For further information regarding the use of QuickReports refer to the Using QuickReports article.

There are a number of reports (in addition to the Credits Report mentioned above) which will show credited amounts or account for credited amounts so it's worthwhile being aware of how these various reports work:

• Credits will display in the Receipts Report through File > Maintenance and Reports > Practice Analysis, by holding the Alt key while clicking on Item Report.
• In the Item Report through File > Maintenance and Reports > Practice Analysis > Item Report. In the Item Report, the Value column is the total amount payable (i.e. Total Fee less Credits and Discounts). As such, only partially credited items will appear as part of the Value column. If a partial credit has been applied, the value will be adjusted to the outstanding amount, not the original fee charged.
• Fully credited items are included in the Items by Month Report. If the Items by Month Report does not match the Item Report (which is based on Service Date), you may wish to cross reference with the Receipts Report to check whether a credit has been applied.
• In the Daily Billing Report the Credits column will show any partial credits that have been applied, but fully credited invoices won’t appear in the Daily Billing Report at all.
• In both the Transaction Summary in the Monthly tab of Maintenance and Reports, as well as the Daily Transaction Report through the Daily tab, all credits applied for the given time frame are shown.
• In the Practice Analysis tab, the Billing vs Income Report shows total credits. The totals are broken down when you click Print Sales, and credits also appear in Print Breakdown, Print Receipts and Summary Records.