Systems and records
Exporting job history from Workiz, Service Fusion or Successware
By SourceX Editorial · Updated
Short answer
To export job history from Workiz, Service Fusion or Successware, pull each record family separately: customers and locations, jobs, estimates, invoices, payments, equipment, memberships and technician notes, each with its IDs. Run exports while your subscription is fully active, widen every date filter back to your account start date, and reconcile counts before you cancel.
Key takeaways
- Job history is a chain of linked records, so every export must keep the IDs that connect a job to its estimate, invoice and payment.
- Default date filters are a frequent reason exports come back short; set every range back to the day the account started.
- Treat the vendor's help center and support team as the source of truth for menus, plan limits and full-export options.
- Reconcile job counts and invoice totals by year against the live system and your accounting records before cancelling.
- Technician completion notes and job photos are the records most often lost when a company exports only invoices.
What job history should you export?#
Job history in a field service app is a chain of linked records: the customer and service location, the call that created the job, the estimate, the work done, the invoice, the payment and any callback. Export each record family separately, with its IDs, and you can rebuild the chain later in any tool.
| Record family | Why it matters | Fields not to lose |
|---|---|---|
| Customers and service locations | The anchor for everything else | Customer ID, location ID, tags, lead source |
| Jobs or work orders | What was done, when and by whom | Job ID, job type, status, technician, dates, completion notes |
| Estimates and quotes | What was offered, including declined options | Estimate ID, option lines, approval status, linked job |
| Invoices and line items | What was billed, part by part | Invoice ID, job ID, items, quantities, discounts |
| Payments and refunds | What was collected and when | Payment ID, invoice ID, method, date |
| Equipment at each location | Service history per unit | Make, model, serial, install date, linked jobs |
| Memberships and agreements | Recurring visits and renewals | Plan, start and renewal dates, visits used |
| Notes, photos and attachments | The technician's evidence | File names tied to job IDs |
Before you export: the setup checklist#
The setup work decides whether the export will be complete, so finish it before running a single report.
- Confirm you have an owner or admin login with full export and report permissions.
- Check that your plan includes the reports or exports you need, and ask support if it does not.
- Find your account start date so every date filter can reach back to it.
- Read the cancellation terms and write down the date access ends.
- List custom fields, job types, tags and price book codes you will need to decode the data.
- Pick one person to run the exports and one company-owned folder to store them.
- 01Your work records
- 02Personal details removed
- 03You approve the release
- 04Licensed to AI developers
Why default date filters cut exports short#
Default date filters cut job history exports short because list views and reports often open on a recent window rather than the full account history. The pattern shows up across field service apps: ServiceTitan's migration guide for FieldEdge tells users to set every filter on the Invoices tab to All, so the export includes all invoice data rather than only the previous six months.
Large date ranges can also fail outright. ServiceTitan's guide for Housecall Pro says to set the jobs date range back to when you started, select all table columns and, if a report errors, run it in one-year batches. Jobber's account-closure article describes the same basic move: pick a report, set the date range and click Export Excel Copy.
Assume Workiz, Service Fusion and Successware can behave the same way until you have proved otherwise. Check the first and last dates in every file against your account start date, and split big pulls by year.
Export routes to raise with Workiz, Service Fusion or Successware#
Workiz, Service Fusion and Successware each have their own screens, report names and plan rules, so the vendor's help center and support team are the source of truth. What you control is asking the right questions early, and in writing.
| Export route | What it usually gives you | Question to ask the vendor |
|---|---|---|
| List views and standard reports | CSV or Excel files, one record type at a time | Which reports cover jobs, estimates, invoices and payments in full? |
| Full data export from support | A bulk file set prepared by the vendor | Is a full export available, in what format, and is there a fee? |
| API or integration access | Structured records with IDs | Does our plan include API access, and do the terms allow bulk export? |
| Migration help from the new vendor | Imports into the new system | Which records and years will be imported, and which skipped? |
| Database copy | Everything, if the system was ever hosted on your own server | Can we receive a copy of our database or a vendor backup? |
Check the export before you cancel#
Checking the export means reconciling it against the live system while you still have access. Keep the vendor's written replies alongside the results; if support says some history cannot be exported, that answer belongs in your records before the account closes.
- Compare job counts by year in the export with the same report inside the app.
- Compare invoice totals by year with your accounting system, such as QuickBooks.
- Trace a handful of long-time customers end to end: call, estimate, job, invoice, payment, callback.
- Open a sample of photos and attachments to confirm they are real files, not broken links.
- Confirm that job IDs in the invoice file match job IDs in the job file.
- Write a short note listing every gap you found and how it was resolved.
Illustrative: a drain and plumbing company switching platforms#
Illustrative: a fictional plumbing and drain-cleaning company is moving from one of these smaller apps to a larger platform as it opens a new branch. The new vendor's onboarding team offers to import customers, equipment and open jobs, which is all the dispatchers need on their first morning.
The owner wants the full history kept as well. The first invoice export covers only recent months because of a default filter, so the office manager reruns it year by year. Drain camera photos turn out to be stored as job attachments, which the old vendor's support team exports separately on request.
The result is a company-owned archive in which every job links to its estimate, invoice and photos by ID. Callbacks by technician and job type can now be studied across the company's whole history, not just since the switch.
Who controls the job history once it is exported?#
The job history generally belongs to the company that created it, but the vendor's terms decide how you can get it out and what happens after cancellation. Read the service agreement and any API terms before relying on automated or bulk exports.
The records also hold homeowner names, addresses, phone numbers and sometimes gate codes or alarm notes. Privacy laws may apply to how that information is stored and reused, and franchise owners should check whether the franchise agreement gives the franchisor rights over customer records.
How SourceX approaches field service job history#
SourceX approaches field service job history as linked operating records: a request, a diagnosis, a price, the work and whether the fix held. In the SourceX five-step transaction, Supply starts with metadata such as systems, years and record families, and Rights checks vendor terms and franchise agreements before any file moves.
Preparation removes homeowner names, addresses, phone numbers and access notes from jobs and technician comments. Approval stays with the owner, and the SourceX Evidence Packet records which export routes produced the data and where the history has gaps.
Frequently asked questions
Will my new software import all of my old jobs?
Often not. Many onboarding teams import customers, equipment and open work, and leave closed jobs, old invoices and attachments behind or bring over summaries only. Ask the new vendor in writing exactly which records and years they will import, and keep a full archive of everything else.
Can I export photos and attachments in bulk?
Sometimes, but rarely from a standard report. Photos usually sit with each job and may need a support request, an API or a vendor export to retrieve in bulk. Ask early, because attachment exports can take longer to arrange than spreadsheets.
What if I have already cancelled?
Contact the vendor right away and ask in writing whether your data is still retained and how to retrieve it. What happens after cancellation depends on the agreement you signed, so find it and read the termination section before assuming anything is gone.
Are technicians' notes worth keeping?
Yes. Completion notes record what the technician found, what they tried and why a part was replaced. They are the most informative text in a job history and the part most often lost when a company exports only invoices.
How should I store the exported files?
Keep them in company-owned cloud or server storage with limited access, never on one office PC or a personal account. Leave the original exports unchanged, add a short readme that explains each file and its ID fields, and record when and how each export was run.
Sources
- ServiceTitan's FieldEdge guide says to set every filter at the top of the Invoices tab to All before exporting, so the export includes all invoice data rather than only the previous six months. Source
- ServiceTitan's guide says you export Housecall Pro jobs from See all jobs: set the Date Range back to when you started, select all Table Columns and click the Excel icon. The resulting jobs.xlsx includes invoice numbers, the customer for each job and line items. If a report errors, run it in one-year batches. Source
- Jobber's account-closure article says you can export CSV-format reports from jobber.com to keep for your records: go to Reports, pick a report, set the date range and click Export Excel Copy. Source
Related resources
See if your company qualifies
A short company assessment. No data uploads are needed.