How to Export Claims to a CSV File in ElderSuite

📝 Overview

Export Claims writes the claims currently listed on Scrub Claims to a comma separated value text file you can open in a spreadsheet. The file is a working copy for sorting, filtering, or review outside ElderSuite. It does not submit claims, change claim status, or create a complete backup that can be loaded back into ElderSuite.

The command lives on the Scrub Claims toolbar in the Claim Center. For preparing Pending claims before submission, see How to Scrub Claims in ElderSuite. For the Claim Center layout, see the ElderSuite Claim Center Overview. Submitting claims is a separate step; see How to Process Claims in ElderSuite.

⚙ How It Works

Where Export Claims Works From

Export Claims is a toolbar command on Scrub Claims in the Claim Center. It works from whatever claims the Scrub Claims list currently shows—the date range, payment type, and claim status filters already applied—and reads those listed claims, including unsaved scrub corrections, so a scrub does not have to be saved first. There is no client filter on Scrub Claims; for one client, filter the client column in the spreadsheet after you export.

Choose All Claims or Only Error-Free Claims

The window explains: “You are about to export your data to an external file for use by another program such as Microsoft Excel or Microsoft Word. Select either 'All Claims' or 'Only Error-Free Claims'.” There is nothing to type and no format to choose. CSV is the only file type this export writes.

All Claims writes every claim in the current list, flagged or not. Its description reads: “When you choose 'All Claims' ElderSuite will export all claims shown whether or not they have errors.”

Only Error-Free Claims skips every claim that carries an error flag. Its description reads: “When you choose 'Only Error-Free Claims' ElderSuite will export only claims shown that do not have errors.” The flag is the one set when Scrub Claims last checked the claims. The export does not run a fresh check. If every listed claim is flagged, Only Error-Free Claims still runs and can produce a file that contains only the header row, with no warning.

Name the File and Confirm the Save

After either choice, ElderSuite opens the standard save prompt when at least one claim is listed. The prompt offers only Comma Separated Value - Text File (*.csv) and opens in the Desktop folder. Canceling the save writes nothing and leaves the Export Claims window open so the other choice remains available. Closing the window with the title-bar close box leaves without exporting; this window has no Cancel button of its own.

Once a save location is accepted, a please-wait indicator appears while ElderSuite writes the file. The window closing by itself is the signal that the export finished. There is no success message. Control returns to the screen that opened the export, and the claim list is left on its first claim. Choosing a file that already exists replaces that file’s contents in full.

If another program is holding the chosen file open, ElderSuite shows Unable to Save with the text “ElderSuite is unable to export the claims to the selected file because it is in use by another process. Try again using a different file name.” Close the file in the other program, or choose a different name, then try again.

A second Unable to Save message begins “Windows did not allow ElderSuite to save the file to that location.” Desktop and Documents are folders Windows Security’s Controlled folder access protects by default. Save to Downloads, use a different file name if a read-only file is in the way, or ask a system administrator to allow ElderSuite through Controlled folder access. Nothing is written when the save is blocked.

What Ends Up in the File

Both choices write the same header row of column names, then one row per exported claim. Values are wrapped in double quotes and separated by commas. The client column shows the client’s search name, and the payment type column shows the payment type’s name. When no matching payment type can be located, the payment type column shows Not Found.

Exporting only reads. It does not save, change, or delete any claim in ElderSuite. The only new item is the file you named. For a similar spreadsheet export of client information from Client Center, see How to Export Client Records in ElderSuite.

When No Claims Are Listed

If the Scrub Claims list is empty when you press either export button, ElderSuite shows No Records Found with the text “There were no claims found to export at this time.” No save prompt appears, no file is created, and the Export Claims window stays open. Populate the list with Find, then start the export again. For reconciling after submission, see How to Reconcile Claims in ElderSuite.

⚠ Filters Limit What Is Exported

On Scrub Claims, payment type and claim status filters narrow the batch, not only the view. Whatever remains listed is what Export Claims writes. Set both filters back to All and click Find again when you need every claim in the date range.

💡 Need More Help?

For step-by-step instructions, click Ask Eddie from within ElderSuite.