Error message during bank rec: "GL Cash account balance out of balance by $XXX,XXX.XX

I think this is due to 6/30 invoices that are paid in July. How can I fix this? Any suggestions?
How do I find out what makes up this amount?

Comments

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

    @Jessica Coriz look at the top half and the bullet points of this KB :


  • @Jessica Coriz
    Hi Jessica,

    I run into this a lot. One of the first things that you should check is to run a report (I have built a query for this and recommend you do the same) to see if there are any transactions that are recorded to your cash account for the month in question, but not yet posted. Digging into the bank register may help, because you may have items that you have cleared on the recon, but have not yet been posted. I do this visual scan in NXT by going to Treasury > Bank Accounts > Select the account you are reconciling > Bank Register. Make sure you have the “Clear Date” and “Post Date” columns showing, and then filter for the month you want to look at. Hope this helps!