Moving this post to the Sage 50 CA Support Group.

Thanks,

Derek

Verify that all adjusting entries are ticked off on both side - sometimes only one side will automatically get ticked off but not the other side.

Thank you. I have verified that all items are  ticked off.  I believe the problem is when I begin the August reconcilation there is already an amount in the resolved transaction field. Past months this would be $0.00.  Once I tick off all amounts I am out by the transaction amount that is in the resolved field at the beginning of the  Reconcilation. Is there a way to delete this resolved transaction amount ?

To show the phantom transactions, uncheck 'Do not show corrections'

and then it will show why there is a 'resolved'

And also check the Worksheet, or the  'Income' 'Expense' tabs for bank transactions from the current bank reconciliation.  I personally prefer not to use these, since they cannot be adjusted if wrong - i.e. if you find out later that a 'loan payment' was a blended payment.

Hello RandyW,thank you.  Yes I see what you are telling me when I look at  my transactions there are two items checked off however it does not add up to the value of my resolved transaction. I have tried to troubleshoot what transaction = the amount of my transactions however I am having no success.

Any other words of much appreciated advise for me?

Try to run a report of the bank ledger account sorted by journal entry number instead of date. Use the start and finish date of the previously reconciled bank rec month. This may show a transaction within that month that was adjusted/revised AFTER the bank reconciliation done. You likely did the bank charges last so any transactions showing after the bank charges may be the culprit of the $1.

If nothing there then do the same bank account general ledger report sorting by JE nbrs but use the latest date possible for the finish date - then check all dates after the bank charge date to see if somehow there was a transaction posted using an earlier date.

In the example I showed above, one half of a *DELETED* transaction had been cleared, but not the other half.  

Sage 50 will let you do this to DELETED or ADJUSTED transactions, and it is mad confusing to fix when you're working several months or even fiscal years later.  

I find the most helpful report to be the one Under Reports | Bank | Account Reconciliation, and change the dropdown to 'Summary Report with Outstanding Transaction Detail'

Print of the last several months, and look for amounts that have never been cleared.   Those are where the original error will be.

***********************************************************

How to quickly test the Bank Reconciliation data with a 'Preflight Check':

1. Clear 'do not show corrections', and Uncheck *everything*.  The 'resolved' MUST be zero.

2.  Put the 'Beginning' balance in, as the 'ending' balance, and the 'unresolved' MUST be zero.

If all's good, close the bank reconciliation *without* saving it.

**********************************************************

If those two tests don't both work, then something is wrong with the reconciliation data.  

Nothing you enter, delete, or adjust will make it work, only make it more confusing and harder to fix.  

Only start reconciling when it in balance, *Then* start with the first day that has an ending balance on the bank statement as the ending balance, and reconcile each day.

Hello smithco and randyW, thank you both for your help. Unfortunately for me. I can not get the reconcilation to balance. Smithco I haveused the report you  suggested and it was most helpful. I can balance by using this report however the balance remaining does not equal the amount that I am out. I am really not sure what I am doing.

I am new to the program and my troubleshooting is not so good. I don't know what is acceptable with this site but would I be out of line if I asked the following

Can I forward (email/fax) copies of the statements and reconciliations and transaction reports for your review?  I have 4 months of statements with approximately 34 bank transaction and 9 bank deposits for a total of 18 cheques

Thank you kindly for the help

Hello smithco and randyW, thank you both for your help. Unfortunately for me. I can not get the reconcilation to balance. Smithco I haveused the report you  suggested and it was most helpful. I can balance by using this report however the balance remaining does not equal the amount that I am out. I am really not sure what I am doing.

I am new to the program and my troubleshooting is not so good. I don't know what is acceptable with this site but would I be out of line if I asked the following

Can I forward (email/fax) copies of the statements and reconciliations and transaction reports for your review?  I have 4 months of statements with approximately 34 bank transaction and 9 bank deposits for a total of 18 cheques

Thank you kindly for the help

Do a bank rec for one day. Make the closing balance the same as the opening balance. Nothing should be checked off except for correcting entries - in which case both the withdrawal and deposit side should appear, be checked off and equal.

The issue in this thread is that it's not possible to do start doing a bank rec at all, if it's not in balance at the beginning of the period.  

Owners often don't understand why steam comes out of a book-keeper's ears when a surprise, handwritten, scraggly mystery cheque from before yearend and the first reconciliation ever, finally clears the bank just before it's staledated.