The Ledger
The Official Blog of The Financial Edge

Journal References Are Supposed to Mean Something?

Do you ever wonder what the transaction Reference column on the General Ledger Report or Post Report means? If you do, then this post is for you! The Reference, also known as journal reference, is created when you post from subsidiary ledgers (AP, AR, FA, CR, SB, and PY) or in detail from The Raiser's Edge. The journal reference defaults are defined in Configuration, can be customized for your organization's needs, and can even be defined for each transaction type.

Journal references are displayed on:

  • The transaction detail on an account record
  • The post report
  • The Journal Entry batch
  • All General Ledger reports where Reference is an available field

There are a few things to keep in mind when you set up your journal references. First, the total number of characters in a journal reference cannot exceed 50 characters. Secondly, changes to journal references are not retroactive, so the changes will only affect items that are not yet posted. Finally, when you create the references, make sure you include necessary details for an effective audit trail.

So let's get to the process...

For FE subsidiary ledgers, go to Configuration and click Posting Information. Then highlight the transaction type and select the appropriate field names and field lengths. Remember to define the journal reference for both the debit and credit side of transactions by marking the Debit or Credit option in the dark gray bar.

To define the journal reference in RE, go to Configuration, click General Ledger, and select the field names and lengths; you will see a sample of the journal reference at the bottom of the screen.

Don't see what you want?  You can add custom fields to FE or RE by clicking Fields and entering the new name. Not sure how or why you would need a custom field? Try using them to emphasize specific transaction types such as INT- for Interfund entries and APPL- for Application entries.

    For more information on customizing journal references or step-by-step instructions, take a look at the Posting Information section of the RE or subledger Configuration Guides.

    Comments

    Kimberly Winter said:

    Thanks for reminding everyone about the customized references.  I use that to record the RE Batch #, last name and payment method for my contributions. All of my credit card activity settles into one bank account, but my deposits may be in several.  Knowing which transactions are credit card payments makes reconciling so much easier.

    Love the new format too!

    # May 22, 2008 12:05 PM