Yes... It worked
Thanks so much Bruce!!!! You are my sunshine!
Corporate Staff Accountant
Hi Bruce –
When I reconciled my November banks the one that we fixed is off $11,277.36 again.
Here is the October reconcile to GL report after I made the below JE... perfect.
Now again off in November, because of this JE (The create a bank transaction decrease adjustment with the good 2019 date.)
Can you help me again please.
I made the final adjustment "good 2019 date" now I back to where I started.
Hi Bruce –
Here is the October reconcile to GL report after I made the below JE… perfect.
Rather than answer this specific question, let me provide the general solution. There are three cash balances, which will all equal if the books are in balance: ACTUAL Balance GL Balance Subsidiary Ledger Balance (here it is Bank Rec/Cash Management module, since we are entering payable correcting transactions as increase/decrease adjustments)
IF ACTUAL <> GL and GL = SUBS
Enter the correcting entry in SUBS (subsidiary module), so it will create a GL entry.
IF ACTUAL = GL and GL <> SUBS
Enter the correcting entry in SUBS only, but do not post the generated GL AJE.
IF ACTUAL = SUBS and GL <> SUBS
Enter the correcting entry as a GL adjusting entry ONLY.
IF ACTUAL <> GL and ACTUAL <> SUBS and GL <> SUBS
Step 1: Enter the correcting entry in either the GL or SUBS (subsidiary) to balance to ACTUAL.
Step 2: Then make the next correcting entry using the logic above.
How do you Enter the correcting entry in SUBS only, but not post the generated GL AJE?
Method 1.: Under posting setup for the transaction type, uncheck POST THROUGH GL, and delete the generated GL AJE.
Method 2: Under posting setup for the transaction type, uncheck POST TO GL, but be sure nobody else is posting, and that you check the box when you are done.
For bank transactions, Increase and Decrease adjustments show up in cash balances immediately.
Remember that CASH RECEIPTS transactions only show up in the cash balances after you print the deposit slips.
If you've found this thread useful, dive deeper into User Group community content by role