Home » Import Transactions into Your General Ledger

Import Transactions into Your General Ledger

Like most church administrators or accountants, you’ve all been there…staring at multiple spreadsheets from your bank, your payroll provider, or other third-party expense tracking tools wondering how you are going to input the hundreds of transactions in front of you into your accounting software.

Let’s take a look at how the General Ledger (GL) Import in Realm Church Accounting Software can equip you with a simple way of importing your transactions.

GL Import

Create Templates

You most likely receive the same formatted spreadsheet every month, and having to map the same columns isn’t an efficient use of your time. Using the GL Import in Realm Accounting, you can create templates to ensure your imports are consistent. Templates save your import settings, so you don’t have to reenter the information.

GL Templates

Map Columns to Fields

It’s almost inevitable that your bank and other companies provide spreadsheets in different formats with different columns. One spreadsheet may have debits that are positive and credits that are negative, while another spreadsheet may place debits in column E and credits in column F but both are positive.

With the GL Import, you can map columns in your spreadsheet to fields in Realm Accounting. For example, Column A in the spreadsheet is the transaction date in Realm, and Column B in the spreadsheet is the transaction comment in Realm.

Review GL Transactions

Review Imported Transactions

When you use GL Import, you can review imported transactions before accepting them in order to correct any errors. Let’s say you have an employee who always codes his expense report to an inactive GL account. When importing the file, you will receive an error that the transaction doesn’t match a Realm account code. 

Realm Accounting’s GL Import provides you with a flexible tool that facilitates regularly importing large files of transactions from different sources.

Leave a Reply

Your email address will not be published. Required fields are marked *