Sign Up

Introduction to export account mappings

Introduction to export account mappings

What are export mappings?

Export mappings are a way for Greenback to associate your transactions to the appropriate accounts in your accounting system. In order to export transactions quickly and autonomously, Greenback leverages an export mapping library to automatically associate future transactions with the right accounts in your accounting file. Let's first take a look at the anatomy of an export.

Anatomy of a transaction export

If you are not familiar with the how Greenback exports data to an accounting file, we recommend that you first check out:

Anatomy of a sales export.
Anatomy of an expense export.

How are export mappings created

Export mappings are created in 1 of 3 ways, via memory mappings, customized mappings or SKU mappings.

Memory mappings

The most common way Greenback maps accounts is with memory mappings. As you manually export transaction from Greenback to your accounting system, Greenback builds a library that correlates the attributes of the transaction with the previously used accounts. We then use this library to associate future transactions with similar attributes to the same accounts as previous transactions. This process of leveraging your export history to define future transactions is called Memory Mapping.

Customized mappings

For more complex scenarios Greenback employs a rules engine to create pre-defined transaction mappings. Custom mappings can be helpful when there are multiple attributes that play a role in determining the appropriate account to map a transaction.

SKU mappings

SKU mappings is a great way to automatically map transactions to an appropriate product or service item within your accounting program. In many cases, Greenback will have access to the underlining product SKU associated with your sales and purchases. When a SKU from the upstream provider matches a SKU within your accounting file, Greenback will map the line item to the appropriate product or service during export.

Precedence of mappings

When there are multiple mapping methods in play, Custom Mappings will take precedence over SKU mappings and SKU mappings will take precedence over memory mappings.

Join the world's most advanced pre-accounting system.

Start a free trial on our growth plan now.

  • Start your free trial
  • Easy set-up
  • Cancel any time