Importing Member and Activity Data in Pear Suite
Import member and activity data into Pear Suite for streamlined data management and improved organization.
Table of Contents
Pear Suite allows organizations to import member data and activity records directly into the platform. This is essential for streamlining documentation, maintaining care continuity for programs like ECM and Community Supports, and generating accurate billing claims from external data sources.
Step 1 – Prepare your data
- Request the Member & Activity Import Template from your Customer Success Manager (CSM).
- Ensure your file is saved specifically in CSV (Comma-Separated Values) format.
- Review the Data Dictionary tabs in the template for specific formatting rules.
- Tip: Upload 1–2 test entries first to verify formatting before importing your entire dataset.
Member/Activity Import Template - Pear Suite
Step 2 – Import members
- Navigate to Data Management > Import Templates > Member Import.
- Upload your CSV file. Required fields typically include First Name, Last Name, DOB, Gender, and Insurance Info.
- Configure Constant Values (New Feature): Admins can set default values for required fields (e.g., Language or Country). If these columns are missing from your CSV, the platform will automatically fill them.
-
Import Multiple Contacts (New Feature): You can now import multiple Emergency Contacts, Caregivers, or PCPs at once.
- Assign a unique External Contact Number to group contact details (Name, Type, etc.) together.
- Mapped columns for the same person must share the same number to avoid duplicates.
- If errors occur, download the error log, fix the spreadsheet, and re-upload.


Step 3 – Import activities
- Once members are successfully in the system, go to Data Management > Import Templates > Activity Import.
- Each row in your file must include:
- A CIN or Unique ID that matches an existing member profile.
- An Activity Name that matches a template already in your platform.
- Start/End Date and Time, Place of Service, and Diagnosis Codes.
- "Yes" in both the Billable and Billing Consent columns.
Step 4 – Generate and review claims (after importing activities)
- Navigate to the Claims tab in the left-hand menu.
- Filter by Status:
- Error: Claims missing data (click to fix directly or re-import).
- Generated: Valid claims ready for final review.
- Review the billing codes and member info. Use Re-Generate to refresh the claim after making any manual edits.
Step 5 – Submit claims
- Open the specific claim and perform a final quality check.
- Click Mark as Ready for Screening.
- This moves the claim into the internal review queue for final billing submission.