Field Mappings

Central Reach CSV Field Mappings

Qlarity maps CSV data from Central Reach (CR) using the following field mappings.

Central Reach Column ID	Quickbooks Mapping	Description
Id	None	The row Id field is used to track CR rows across imports. Changes to a row will be caught and data will be updated based upon this Id.
PayorCompanyId	Customer Record ID	The PayorCompanyId field is mapped to a QBO customer record Id.
PayorName	None	Used during the data mapping process to name a customer record in QBO when creating a new customer from a CSV mapping.
ProviderLocationId	Class ID	The ProviderLocationId field is mapped to a QBO class record Id.
ProviderLocationName	None	Used during the data mapping process to name a new Class in QBO when creating a new location from a CSV mapping.
ProcedureCodeId	Product/Service ID	The ProcedureCodeId field is mapped to a QBO service record Id.
ProcedureCode	None	Used during the data mapping process in the suggested name of the QBO service record when creating a new service item from a CSV mapping.
ProcedureCodeDescription	None	Used during the data mapping process in the suggested name of the QBO service record when creating a new service item from a CSV mapping.
DateOfService	Invoice Line Item Date	Invoices imported to QBO will have the date of service on the line item set to this field. It's also used to group related records into a single invoice in QBO.
ClientChargesAgreedTotal	Invoice Line Item Total	The invoice line for this row will have the line total set to this amount.
UnitsOfService	Invoice Line Item Quantity	The invoice line for this row will set quantity to this number. Unit price is calculated from ClientChargesAgreedTotal / UnitsOfService

Central Reach PHI Data

When uploading a CSV file into Qlarity it will likely contain PHI data. This data will be masked in the UI and will not be visible during the import process. Qlarity does not store PHI data in the database.