Exporting & Importing Accounting Transactions

In this article, you'll learn how to export approved transactions from Way2B1 into your general ledger software. Importing transactions that have been uploaded into Way2B1 is one of the biggest timesavers for accountants and for the families they support.

1. Synchronize data fields 
2. Export transactions from Way2B1
3. Import transactions into your general ledger

Synchronize data fields

To minimize any redundant data entry, you'll want to first make sure that any relevant fields in Greenlight match with how those fields are represented in your general ledger.

• Accounting Categories correspond with your Chart of Accounts
• Legal Entities correspond with your Companies or Entities
• Organizations correspond with your your general ledger's list of Vendors

It's important that the categories, entities, and organizations are correct prior to the final "green light" approval. For this reason we recommend that accountants are added as approvers on any accounting processes.

To further ensure that these data fields are used consistently in Decisions, you may want to restrict other users' abilities to modify them. To do so, other users will NOT have the following permissions turned on:

• Can manage accounting categories
• Can manage legal entities
• Can add organizations

Our general ledger integrations will remember corresponding data fields between Greenlight and your general ledger software, even if they don't match perfectly.

Export transactions from Decisions

1. Select the transactions you would like to export by using filters and then selecting all
   
   • Alternatively, manually select each line item
2. Export the transactions by clicking on the ". . ." at the bottom left of the screen and selecting the file type that is used by your general ledger software
   

You may want to rearrange your Greenlight table columns to match with how the columns are laid out in your general ledger software. 

While our general ledger integrations can handle split transactions, you will only be able to apply one category to a transaction if utilizing the .csv or .xls export feature in Greenlight. We recommend entering multiple transactions if you wish to use multiple categories.

Importing transactions into your general ledger

The instructions for importing transactions will vary depending on which general ledger software you are using. However, we've compiled a list of commonly-used software, and have linked it to specific importing instructions below.

• Quickbooks Enterprise
• Quickbooks Desktop
• Sage Intacct