# Solar CRM field mapping worksheet | ArcSolar

> Map customer, site, owner and open-work fields before changing solar CRM. Download a CSV planning worksheet and check a small migration pilot.

Canonical: https://www.arcsolar.com.au/resources/solar-crm-field-mapping-worksheet  
Last updated: 2026-11-13

Practical checklists · By Argonix Digital · Published 2026-09-13 · Updated 2026-11-13

**Key point:** Map relationships as well as fields. Keep the customer, site, quote and next action connected, then reconcile a small pilot before cutover.

[Download the field-mapping worksheet (CSV)](https://www.arcsolar.com.au/downloads/solar-crm-field-mapping-worksheet.csv)

## Start with the source export

Keep a secure copy of the source export. List the record type, original ID, field meaning, proposed destination, transformation and test for each mapping. Agree the supported transfer method with the implementation team.

ArcSolar customer records keep the installation address, lead source, ownership and linked work together. Check the owner of the actual lead or opportunity; an account-owner label may mean something different in the old system.

Sources: [ArcSolar customer records and ownership](https://docs.arcsolar.com.au/customers/records); [ArcSolar team and access](https://docs.arcsolar.com.au/setup/team)

## Map the relationships that matter

| Record | Check before transfer |
| --- | --- |
| Customer and site | Retain source IDs; keep multiple installation sites distinct. |
| Lead and opportunity owner | Match to the intended active member and role. |
| Quote and acceptance | Keep the issued version and its acceptance evidence linked. |
| Payment | Preserve reference and actual status; pending stays pending. |
| Conversation and next task | Confirm available history, next owner and due date. |
| Contact preferences | Retain the recorded preference and its source evidence. |

These are planning checks. A row in the worksheet does not establish that a particular field, file or message can be imported.

## Example: one customer, two sites

Illustrative mapping: the source has customer C-104 with sites S-1 and S-2. Its open battery quote belongs to S-2. Record both site references and link the quote to S-2; do not merge the addresses simply because the customer ID matches.

If “account owner” identifies a former rep, agree the replacement owner before transfer. Keep the old reference in the mapping register so the pilot reviewer can trace the decision. The downloadable CSV includes this fictional example and five other planning rows.

## Check a small pilot before cutover

- Reconcile source and destination counts by record type, with an explanation for exclusions.
- Open a customer with multiple sites, a revised quote and unfinished work. Check the links and next owner.
- Have the intended rep or operations member complete their permitted next step. An administrator’s view does not prove everyone has access.
- Agree retry and duplicate handling, then resolve exceptions before expanding the migration.

Sources: [ArcSolar customer records and ownership](https://docs.arcsolar.com.au/customers/records); [ArcSolar team and access](https://docs.arcsolar.com.au/setup/team)

## Agree what transfers and what stays behind

This worksheet is a planning aid, not an ArcSolar import schema or upload template. Automated import coverage, supported formats and historical message or file transfers must be agreed separately. Keep source records available until the pilot and exception list are accepted.

## Take the map into your migration review

Use the migration checklist to agree the pilot and cutover. For an ArcSolar walkthrough, bring redacted column names and a fictional job; confirm migration scope, plan and connected services before deciding.

- [Plan the CRM migration and cutover](https://www.arcsolar.com.au/resources/solar-crm-migration-checklist)
- [Review ArcSolar plans and setup](https://www.arcsolar.com.au/pricing)

## Sources

- [ArcSolar customer records and ownership](https://docs.arcsolar.com.au/customers/records) (ArcSolar Documentation, checked 2026-11-13)
- [ArcSolar team and access](https://docs.arcsolar.com.au/setup/team) (ArcSolar Documentation, checked 2026-11-13)

## Related

- [Solar and electrification warranty claims: keep the handover connected](https://www.arcsolar.com.au/resources/solar-electrification-warranty-handover)
- [Victorian Solar Homes quote checks: seller identity and approval](https://www.arcsolar.com.au/resources/victoria-solar-homes-quote-checklist)
- [Solar quote follow-up: SMS templates for the customer’s actual stage](https://www.arcsolar.com.au/resources/solar-quote-sms-templates)
