Skip to content
Enjoy complimentary data migration when switching from your existing bookkeeper or CPA to Institution.

Bookkeeping & finance

Map SaaS customer identifiers before a billing migration sends charges

Connect legal payers, product workspaces, subscriptions and usage identifiers so imported records and later events reach the intended account.

By Institution3 minute readPublished View sources
In this guide

Start with the payer relationship

List the legal customer responsible for payment, its product workspaces and the source billing accounts. A corporate group can have several legal payers; one payer can cover several workspaces. Preserve those relationships before creating destination records. Matching on a familiar company name or email domain alone is insufficient when the business has subsidiaries, resellers or shared billing contacts.

Assign one owner to resolve uncertain relationships using contracts and customer records. Keep unresolved accounts out of automatic charging until their mapping is approved. The migration team's technical task is easier once finance has explained which records belong together and which similar-looking names must remain separate.

Build a cross-system reference table

Include source customer and subscription IDs, destination IDs, internal account IDs, workspace IDs and relevant usage identifiers. Retain the original identifiers as history. Stripe supports storing internal references in metadata, but its documentation cautions against putting sensitive financial data there. Use identifiers and a controlled reference store, not copies of bank or card details.

Check the mapping's cardinality: which links should be one-to-one and which legitimately connect several records? Flag one source subscription mapped to two live destinations, destination customers without a known payer and workspaces with no billing relationship. Require an explanation for intentional consolidations rather than letting a deduplication script make commercial decisions.

References: Stripe: Store internal references in metadata

Trace a charge from product activity to invoice

Choose a representative account and follow one usage event or seat change through the integration into the intended subscription and invoice preview. Confirm the payer, currency and service identifier at each step. Repeat for a multi-workspace customer and a customer whose billing account was deliberately consolidated.

In an illustrative group, the parent company may pay for two workspaces while a separately contracted subsidiary pays for a third. A mapping based only on the group's email domain could send all three charges to the parent. The test should reproduce the contractual grouping, including any approved consolidation, before production events enter the destination system.

Control events arriving during cutover

Decide which mapping applies to events created before cutover but received afterward. Preserve event timestamps and source identifiers so delayed activity can be resolved without guessing from a current workspace name. Record how retried events are identified to prevent replaying an old charge under a newly assigned customer ID.

Stripe's migration guidance separates integration setup, customer and payment information, and subscription import. Coordinate those workstreams around the same approved map. A destination customer may exist before its subscriptions or event routing are ready, so use an explicit readiness check rather than assuming record creation completes the handoff.

References: Stripe: Migrate subscriptions to Stripe Billing

Keep the map useful after the project

Reconcile account counts and expected relationships after import, then inspect the first live invoices and exception events. Investigate charges with missing payer references, unexpected customer names or usage on inactive source records. Retain corrections as dated changes so the mapping can explain both the original migration and later repairs.

Make the reference table accessible to authorized support, finance and engineering staff through an agreed process. Future refunds, disputes and reporting comparisons will still refer to old IDs. A durable mapping allows those teams to find the correct customer without reopening retired systems or merging records simply because their names look alike.

Sources

Requirements and product details can change. Check the linked guidance for the facts that apply to your situation.

Related reading

Need help with this work?

General information, not personalized accounting, tax, legal, or investment advice. Have the appropriate qualified professional review decisions that depend on your circumstances.