General Ledger Reports custom reference IDs

Is there a way to add a column to the GL report to include the deposit ID?

I am trying to recreate as closely as possible a report I use every month for our various student program advisors. Many of the deposits I record come from credit card payments that we all track using the assigned batch number. The other's come from cash bags that are delivered to the bank.

I use those batch numbers and cash bag numbers as the deposit ID and it helps the advisors look up needed information on their end. I've created a General Ledger report that works pretty well but I need to include an identifier for deposits to the cash account. The reference number that shows on the report right now is auto generated through the system based on the payer's name. That's not going to help any of the advisors.

I'd appreciate any advice on this. Thanks!

Comments

  • Kevin Brazell
    Kevin Brazell Blackbaud Employee
    Tenth Anniversary Kudos 5 First Reply Name Dropper

    @Ann Barden
    No , not on a column. Now you can change up what information is posted to the GL for the journal reference column. Look to add deposit ID, but that will only affect new posts moving forward. Should be located under Posting Information section.

  • @Kevin Brazell

    Thanks for that information. I'll look into that. Right now I'm using the “Payer” line to record identifying info as that's what shows up under Reference on the GL report.

Categories