Overview
The Invoice Adjustments Report provides a comprehensive list of items invoiced before a specified date ('item dated before') and tracks modifications made within a defined adjustment period ('adjustments made').
Who this report is for
This report is designed for bookkeepers and payroll staff to identify changes made to invoices that fall within a previous adjustment period, such as a payroll cycle that has already been processed. It surfaces items that were deleted, had their fee changed, were discounted, or were newly created within a date range that has already been paid or reconciled.
Because these adjustments happened after the relevant payroll cycle was already processed, they need to be factored into the next payroll cycle rather than the one they originally belonged to. For example, if an item was included in payroll and later deleted, the amount already paid out for it should be deducted from the next cycle. If a new item was added retrospectively into a closed period, or a fee was increased, the corresponding amount should be added to the next cycle instead.
This report is not for checking whether a specific patient's invoice was altered. Because it is filtered by adjustment date range rather than by patient, it is not designed to isolate changes to one patient's invoice and will be difficult to use for that purpose.
To check whether a specific patient's invoice was altered, use one of these instead:
Patient/Payer Audit Log — the easiest option, as it is limited to a single patient. Open the patient file, click the cog icon next to their name, and select Patient/Payer Audit Log. Set the log area to Invoice and choose a date range.
Audit Log Report — covers all patients, so it is more difficult to sort through, but useful when you don't know which patient's invoice was affected. Go to Reports → General → Audit Log and filter by Invoice.
How to Use
1) Setting the Adjustments Made filter
The date range selected here defines the adjustment period, with all modifications made to the selected Items in that range being shown.
Example: Setting this to Today will show all adjustments that were made today, for the selected Items. Setting a range will include all adjustments made between the two dates.
2) Setting the Items Dated Before filter
The date selected here sets the cut-off for which items will be included based on the item's date, with all items invoiced before the selected date being included.
Example: Setting this to the 1/1/2025 will show items that were invoiced before that date and the adjustments made to them in the adjustment period.
3) Select a Business / Practitioner
This filter allows for only items invoices to select businesses and/or practitioners to be shown. For all adjustments, leave this unchecked.
4) Set your Group by preference
These options enable the results to be grouped by the business and/or the practitioner that they were invoiced against.
Once your preferred filters have been set, click Generate Report.
Results
The results section will show all of the adjustments that were made based on the filters set, including the actions performed, any details that were adjusted, the user responsible, and more.
Note: The patient name and invoice number are clickable and will take you to the patient's file and invoice respectively.