Core Financial Modules

[drushing]

I have a December deposit that posted correctly to the G/L and is showing on the deposit tab of my bank rec. However, my currect bank balance in "Check, Deposit and Adj Entry" rec does not reflect that deposit amount (even though it's right there looking at me!).  The bank reconciliation is in balance.  How can I correct the current bank balance? 

[TomTarget]

The answer is .... it depends on why they don't agree.

Question #1 -  If you go to your general ledger and look out as far into the future as you can,  does the G/L balance agree to the balance you see for the same account in bank rec | main | bank code maintenance (or check deposit and adjustment entry)? 

Question #2 - If you  are in B/R | Main | reconcile bank and see the out of balance balance status,  is it the same number as you seen when you print a bank reconciliation report?

Question #3 -   Is the running balance on the bank recap report,  the same running balance you seen on a bank reconciliation report at the same date in time?

[drushing]

Question #1 - No, the system let me run a G/L Detail report as far out as 2015 and that report is still out of balance with the bank rec/main/bank code maintenance AND check deposit/adjustment entry.

Question #2 -  Well, when you go into B/R/Main/Reconcile bank, it appears you are balanced.  However, if you turn around and print a bank reconciliation report the out of balance amount shows up.

Question #3 - Yes, the running balance on a bank recap report agrees with the above printed bank reconciliation report (all dated for document date today).

[TomTarget]

This may not be everything,  but based on your answer to #2,  your first step would be to go to Library Master | Utilities |  Rebuild Sort Files and run it on BR..

[drushing]

Ran "Rebuild Sort Files"  and "Rebuild Key Files" on every module this morning.  Nothing changed.

[TomTarget]

Odd.  Rebuild sort files on BR would normally resolve the condition in #2.  You definitely did a rebuild sort files on B/R?

#1 Condition suggests that something has been recorded in bank rec,  but not in the G/L or vice versa.

This can happen for any of the following reasons:

A.  Used a general journal entry to post to the checking account (this will not put anything in G/L).

B.  Entered an item through check deposit and adjustment entry (this will not post to the general ledger,  unless you are in 4.4 (PU #3 and above and you posted the bank recon register).

C.  You have transactions stuck in your daily transaction register (run G/L Daily transaction register).

D.  You have posted to the checking account from other modules  (for example,  you entered an A/P invoice and distributed it to the checking account).

E.  You posted using G/L transaction journal entry hitting the checking account using a journal that is not linked to b/r.

F.  Someone manually deleted an item from B/R check deposit and adjustment entry (no entry will be made to G/L).

At this point you have to start comparing what is in B/R to what is in the G/L.