Accounts Receivable Out of Balance with GL

Linda Meadows
Linda Meadows
Fifth Anniversary
in Blackbaud Financial Edge NXT® General Discussions

Hello everyone! I am trying to reconcile my AR subledgers with with General Ledger balances and I don't see anything obvious. I am using the reports they recommend for reconciliations. Does anyone have a suggestion?

Comments

  • Deb Foos
    Deb Foos
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Linda Meadows UGH! I hate when this happens because it's usually not an easy find. I would start with a GL detail report of your AR account. Look for anything that posted from the General Ledger module instead of Accounts Receivable. Next, I would make sure you're using the correct transaction dates as well as post dates on your AR reports. These can get a little “funky” and mess up the data you're looking for in your report. Finally, double check to make sure you don't have any unapplied AR payments that you're not taking into account. I hope this helps….

  • Robin Waldinger
    Robin Waldinger
    Ninth Anniversary Kudos 2 Name Dropper Participant

    @Linda Meadows to piggyback on Deb's comment - we set up two GL queries to help us review the post dates to different periods:

    f7c44fcfab3b09236b0829ccd140276a-huge-im
    6d039f571b7e132b0782707708061a0f-huge-im


Categories