We are reconciling to the bank in FE using the bank reconcilation module. Our Bank Register in FE is in balance with the bank but our G/L is not in balance with the bank. Has anyone had this problem before and do you have any hints as to where the problem was or how you fixed it? It is terribly frustrating, we have spent a lot of time trying to figure it out.

We have this happen occassionally. The usual cause is that something has an invoice date that is in a different month than the posting date. Or a check was issued in an earlier month than the invoice was entered. Another option is that a check was run and posted in the month you are balancing, but void in the next month. Hence it is outstanding in the month you are doing the reconciliation, but doesn't show on the bank rec as outstanding because it is void. We have queries set up to look for invoice dates before posting dates or vice versa, and they help cut the time in searching for these out of balance problems.

You may have some unposted transactions. I think payments will appear in the register even if not posted yet.

Would you be willing to share your queries, you can contact me directly at [Email Removed].

I had this happen before. When posting journal entries, you have to make sure that the button is checked marked "create bank adjustments..." The difference is something is posted in either the bank file (check register) OR in the general ledger. You can probably print out both and compare them. You can also go back and open your recently posted journal entries to see if that box was checked. When you reconcile, to "fix" it, which is not necessarily the best way, but gets the job done, you can plug the amount that you are out. You have to go through the reconciling process, and it will tell you that you are out of balance (there are two balances at the bottom). I hope this makes some sense. Sonja

I have had this happen also. Just a warning - if you are integrated with RE, journal entries coming from RE do not have that box checked. You have to manually check it then post the entry. I actually still have a post-it on my monitor until I get in the habit of checking the box!

We had this issue also and decided that we would have every cash jounal entry (whatever the source) show in the bank cash module. We did this by going into Buisness Rules (GL), Jounal Entry and uncheck the box saying "Allow journal Entries to cash accounts without adjusting the bank reconcilation". This will force all cash gl entries to show and no one has to remember to check the box in the journal entry batches.