The profit on every claim, and the books for the whole shop
The Claimory Financial Center is one screen with six tabs. Every figure on it is computed from the claims, payments, cost entries, labor entries, shop expenses, and payroll entries your collision repair shop already records in Claimory. The financial tabs run for the year and period you pick, by full year, quarter or month. Nothing is re-keyed, and there is no report builder to set up.
No credit card. Works with CCC ONE and Mitchell.
Financial Overview tab, demo shop, full year: most and least profitable claims, revenue by source, top expense categories
Computed the way the app computes it
Claimory takes every payment recorded on the claim that is not still marked Pending, subtracts the claim's cost entries, and subtracts each labor entry as hours multiplied by its rate. What is left is the profit, and profit over revenue is the margin. The Financial Overview tab ranks the shop's claims by that profit, most and least, for the selected year and period. Below is the same arithmetic on one sample claim. Change anything.
- Insurance paymentInsurance
- DeductibleCustomer
- Supplement 1Insurance
- PartsOEM bumper, bracket, sensor
- SubletADAS calibration
- MiscPaint and materials
- Body$823.60
- Paint$556.80
- Frame$216.00
- Revenue, payments not Pending
- $7,340.00
- Cost entries
- $3,223.20
- Labor
- $1,596.40
- Profit
- $2,520.40
- Margin
- 34.3%
Flip the supplement to Received and the revenue moves; leave it Pending and it stays out, which is exactly what the app does with a payment that has not landed. Sample figures, the app's own arithmetic.
The shop's month on one screen
The tab opens on the Claimory Health Score, a number out of 100 with a letter grade from A+ to F and its change against the previous period. Under it sit total revenue, total expenses, payroll, and net profit for the selected year and period, with a toggle that compares each against the same period the year before, and a monthly chart of revenue against expenses.
Further down the same tab
- Most and least profitable claimsFive each, by claim number and customer, with profit and margin.
- Revenue by source and top expense categoriesInsurance, customer and other payment sources against parts, sublet and the other cost categories.
- Labor efficiencyTotal labor hours, hours per employee and revenue per labor hour for the period.
- Cost per claimEach claim's costs against the shop's own average, the largest gaps first.
- Vendor spendSpend per vendor with a warning when one vendor carries more than 40 percent of it.
- Recurring expense detection and forecastVendor-and-category pairs seen in two or more of the last six months, and overhead by category projected month by month.
- Expense anomaliesAny entry at least twice its category's average for the period.
- Profit and loss statementRevenue, cost of goods sold, gross profit, payroll, overhead and net income, with a copy button for the bookkeeper.
- Quarterly tax deadlinesThe next of April 15, June 15, September 15 and January 15.
- Financial activity calendarEvery day of the period colored by whether revenue or expenses were larger.
Cycle time, age, and who is carrying the work
The first tab is the shop's claim load as it stands: how many claims are open, how long a delivered claim took, how old the open ones are, what came in this month against last, and how the work is spread across technicians. Each number is defined below the screen, in the terms the app uses to compute it.
- Active claims
- Every claim whose status is not Delivered or Total Loss.
- Avg cycle time
- Days from a claim's creation to its last update, averaged across Delivered claims.
- Avg age
- Days since creation, averaged across the active claims.
- Revenue (MTD)
- Payments received this calendar month, with the change against last month.
- Active techs
- Technicians holding at least one claim as primary tech, out of all workspace members.
- Claims by status
- The count and share of claims in each status, as a bar list and a donut.
- Technician workload
- Assigned and completed claims for each primary technician.
- Carrier performance
- The scorecard below, for each carrier with at least three claims.
Each insurance company on its own row
At the bottom of Claims Analytics, each carrier gets a card with its cycle time, payment speed, on-time rate, supplement rate and average revenue, and a Payment Reliability bar rated Excellent, Good or Needs Attention from the on-time rate. The same rows export from the Export Center as the Insurance Scorecard, in PDF, Excel or CSV, with these columns.
- Insurance Carrier
- The carrier named on the claim.
- Claims
- All of that carrier's claims in the workspace.
- Completed
- Those with the status Delivered.
- Avg Cycle (days)
- Creation to last update, averaged over the completed ones.
- Avg Payment (days)
- Claim creation to the date each insurance payment was received.
- Supplement %
- Share of the carrier's claims in Supplementing status or flagged Supplement Requested.
- On-Time %
- Share of the carrier's insurance payments received within 30 days of the claim opening.
- Revenue
- Insurance payments on the carrier's claims, and the average per completed claim on screen.
Revenue, expenses, and payroll, each on its own ledger
Revenue
Every claim payment and every cash job payment in the period on one table: date, amount, source, customer, a Claim or Cash type, job number and reference. Search by customer or job number, filter by source and by type, sort by date or amount, and read the total of what is on screen. Export CSV writes the filtered rows with the payment method included.
Expenses
Job-related costs from claims and cash jobs beside the shop's overhead, with the three totals on top. Add an overhead expense with its category, vendor, amount, date and a recurring frequency; Sync Recurring generates the entries that are due. Overhead rows can be deleted here, job costs stay on their job. Export CSV writes the filtered rows.
Payroll
Gross pay, tax withholdings, net pay and the entry count for the period. Each entry carries hourly, overtime and gross pay with federal, state, Social Security, Medicare and other deductions, and the net is computed as you type. Export CSV writes the ledger, and the W-2 summary totals each employee's year with its own export.
Estimated tax, and what the accountant gets
- 01Tax configurationThe shop's state, county, tax ID and fiscal year start, and separate parts, labor, materials and sublet rates. A countdown to the April 15 deadline appears as it approaches.
- 02Export for accountantClaimory PDF, a statement generated in the browser with the workspace name on it. Full CSV, the whole summary. QuickBooks and Xero, two summary CSVs with the same six columns, one row per revenue source and per expense category.
- 03Profit and loss statementRevenue by source and expenses by category for the period, then estimated tax obligations computed from the configured rates, net profit before tax, and net after estimated tax.
Every file it produces, and what is in it
Each report comes out as a PDF with the Claimory logo and styled tables, as an Excel workbook with a cover sheet and auto-filters, or as a plain CSV. The record count on each card is live, and a report with no records stays disabled instead of producing an empty file.
- Claims Report
- Claim #, Customer, Insurance, Status, Vehicle, VIN, Priority, Created
- Payments Report
- Claim ID, Source, Payer, Reference #, Amount, Date Received, Method, Status
- Financial Summary
- Claim ID, Type, Vendor / Source, Description, Amount, Date, one row per cost entry and per labor entry
- Insurance Scorecard
- Insurance Carrier, Claims, Completed, Avg Cycle (days), Avg Payment (days), Supplement %, On-Time %, Revenue
- Technician Performance
- Technician, Assigned, Completed, Completion %
- Full Financial Center
- All five in one PDF