The Charge Adjustments Report (FIN-31) lists the charge adjustments applied within a date range, including bad debt write-offs and billing corrections.
What the report shows
An adjustment is a negative line item applied to a charge to reduce its value.
Adjustments are often used for bad debt write-offs and billing corrections. Point of Sale returns also create adjustments automatically.
Use the report to reconcile adjustments, audit bad debt write-offs, spot billing issues and keep a record for compliance.
Each report ends with Summary Totals: the number and total amount of the adjustments in your results.
Open the report
Go to REPORTS, click Financial in the left-hand menu, and select Charge Adjustments Report (FIN-31).
Note
If the report isn’t in the Financial list, ask an administrator to turn on the Charge Adjustments Report permission. Your staff profile or your user group can grant the permission.
Choose which adjustments to include
- Adjustment Start Date / Adjustment End Date — the reporting period. Required. Starts on today’s date.
- Adjustment Type — ADJUSTMENT, ADJUSTMENT - BAD DEBT, or both. Both start selected.
- Locations — only locations you can view. All start selected.
- Adjustment Amount Min / Adjustment Amount Max — a dollar range.
- Staff Member (Created Adjustment) — who made the adjustment.
- Show Only Charges With Multiple Adjustments — charges adjusted more than once. Good for spotting repeat corrections.
Group and run the report
Organize By splits the results into tables:
- Adjustment Date (default) — one table per date.
- Adjustment Type — one table per type.
- Family — one table per family, sorted by charge.
Then pick HTML, PDF, XLS or CSV at the bottom of the report page. The report is created right away in that format.
Tip
Save filters you use often as a preset. Presets don’t save dates, so you set a new reporting period each time. See What are Preset Filters for Reports?.
More filters, columns and totals
▶ Columns and totals
Every report includes these columns:
- Adjustment Date/Time
- Adjustment Type
- Adjustment Amount
- Line Item Title
- Family Name
- Location
- Charge ID
Summary Totals shows Total Adjustments Count and Total Adjustment Amount. The totals count only your filtered results. The totals appear in every export format.
▶ Charge filters
Charge filters narrow results by the charge each adjustment was applied to. All charge filters are optional. The report runs with none selected.
- Charge Category
- Charge Line Item Type
- Program
- Charge Creation Start Date / Charge Creation End Date — when the charge was created.
- Original Charge Amount Min / Original Charge Amount Max — a dollar range for the charge’s original amount.
▶ Optional columns (Show)
The Show setting adds columns. All start unchecked. Add any of these:
- Staff Member Name
- Original Charge Amount
- Current Charge Balance — the whole charge’s balance today, not just the adjusted line item.
- Charge Category
- Charge Line Item Type
- Program
- Charge Creation Date
Troubleshooting and FAQs
▶ Common Questions
▶ I don’t see the Charge Adjustments Report in my Financial reports list. Why?
Access depends on the Charge Adjustments Report permission. Your staff profile or your user group can grant the permission. Administrators always have access.
▶ Is the Charge Adjustments Report permission the same as Apply Charge Adjustments?
No. Apply Charge Adjustments controls creating adjustments. Charge Adjustments Report controls viewing the report.
▶ Why don’t all of my locations show in the Locations filter?
The Locations filter only shows locations you have permission to view. If a location is missing, your account does not have access to that location’s data.
▶ How do Point of Sale returns show in the report?
Point of Sale returns show as type ADJUSTMENT. The staff member listed is the person who processed the return. Older adjustments made before adjustment types existed also show as ADJUSTMENT.
▶ Can I edit or remove an adjustment shown in the report?
No. Adjustments are permanent, so the report returns the same adjustments each time you run it for a date range. The charge an adjustment was applied to can’t be edited or deleted either. To fix the balance, create a new charge for the amount owed. The original adjustment stays on the report.
▶ When I load a preset, why are the date fields empty?
Presets don’t save date ranges. The fields are left empty on purpose, so you confirm a fresh reporting period each time you run the report.
Related: How Do I Apply Adjustment Line Items? · How Do I Edit/Correct an Existing Charge? · How Do I Configure Staff Permissions and User Groups? · What are Preset Filters for Reports? · Which File Format Options Are Available for Reports?