# Double Entry Transition Tables: How We Track State Changes At Shopify

DevFeed: [Double Entry Transition Tables: How We Track State Changes At Shopify](<https://devfeed.tech/articles/double-entry-transition-tables-how-we-track-state-changes-at-shopify-1375.md>)

Original publisher: [Read original article](<https://shopify.engineering/double-entry-transition-tables-shopify>)

Author: Justin Pauley

Published: 2022-05-18T13:30:00Z

Content type: article

Language: en

Sources: [Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering.md>), [Shopify Engineering - Shopify Engineering](<https://devfeed.tech/sources/shopify-engineering-shopify-engineering.md>)

Topics: [data](<https://devfeed.tech/topics/data.md>), [Shopify](<https://devfeed.tech/topics/shopify.md>)

Tags: [build](<https://devfeed.tech/tags/build.md>), [data](<https://devfeed.tech/tags/data.md>), [shopify](<https://devfeed.tech/tags/shopify.md>), [use-cases](<https://devfeed.tech/tags/use-cases.md>)

## AI overview

Shopify explains how it used double entry transition tables in a data pipeline to measure historically how many merchants actively use Shopify Balance. The approach tracks simultaneous state changes across merchant and Balance accounts, simplifies reporting queries, and supports future product complexity.

## Source excerpt

Explore how Shopify built a data pipeline using double entry transition tables to answer the question: how many Shopify merchants are using Shopify Balance?