My bank recs on Simply are months behind and causing me great frustration. Instructions on this forum have been very helpful. My latest problem is that I have started all over (again) and there are double and sometimes triple entries on the screen for every item. I've tried changing the date, closing and reopening all windows, even closing down Simply, but still the multiple entries are there. It looks like a programming issue but in the meantime I can't carry on with the recs. I finally decided to restore from backup and that got rid of it but it means redoing today's work (haven't done much fortunately). Any advice?
You may need to reset the bank reconciliation if:
Note: Please make a BACKUP of your data before proceeding, and do not overwrite any of the other backups. The Account Reconciliation feature involves detailed procedures listed below that must be followed step-by-step:
Part A - Clearing old reconciliation information:
Part B – Setting up the Bank Reconciliation:
You are now ready to start reconciling your bank statement. Make sure your unresolved and discrepancy amounts are zero before you are ready to post.
I have followed these clear and helpful instructions each time I've started over. My problem is the double and triple entries of each item - pretty sure it's a programming thing.
I have another problem. An amount of $8.77 appears on the Simply rec window, I check it off because it has cleared the bank. Yet, an unresolved amount of $8.77 shows up. The payable ledger is correct.
Hi, I can commiserate with your frustrations, until I realized what was causing them these drove me crazy also. The double and triple entries are usually caused by correcting a posting. Make sure you have "show corrections" checked, click on the top icon that says to clear all items, make sure your opening and closing balances are accurate and so are your dates, then just uncheck all outstanding items. This is the easiest and fastest method of getting through the maze SA creates in order to preserve an accurate audit trail. BREATHE!! It's ok, this too shall pass.
I hope this will work for you, if not, come back to the forum and we'll try again. In the meantime, don't worry it has happened to a lot of us.
Almost magic. First part of my thinking:I did as you said by checking all and then just unchecking what hasn't cleared. Unfortunately, I'm still out the $8.77. However, if I uncheck a reversing entry of $8.77 for which there is "no data to report," everything balances.
Second part of my thinking:I think unchecking something that doesn't exist would be fine, right? If so, it IS magic. Karen
Hi, what triggered the $8.77? If it is something that shouldn't be there, just go in and reverse it or delete it and then you should reconcile perfectly. :)
The $8.77 is an actual bill. I incorrectly credited the owner's pocket instead of the bank first time around. So the reversing entry is to credit the bank. The $8.77 is entered in Simply as a payment coming from the bank and it has cleared the bank. The problem seems to be extra entries in the Simply reconciliation window.
In the General Journal, there are just 2 entries:Debit to Owner Credit to A/PthenDebit to A/P Credit to Bank
Can I uncheck the reversed entry that has no data to report? If I uncheck it, my resolved and discrepancy amounts are zero but the resolved and outstanding amounts change. If I check it, my unresolved goes to -$8.77
It's a puzzle to me.
Ok, I'm going to try and follow the chain of events, correct me if I'm wrong please.
#1 - Cr - Owner 8.77 Dr A/P [paying the vendor's invoice]
#2 - Dr - Owner 8.77 Cr A/Payable reversing the payment
#3 - Dr - A/P 8.77 Cr Bank [pay invoice correctly]
So when you check the box to show all corrections what entries are you seeing in your bank rec? Did you try to delete the payment from the owner or did you just do a journal entry to move it to the bank? Did all of these transactions take place in the same month? Or did the 8.77 clear the bank last month and you're trying to fix it now? Sorry, I am a little confused. Can you show me exactly what you did in the sequence complete with dates. Or, you can just uncheck it, but then you will have an outstanding [unresolved] amount forever of 8.77.
All the transactions took place in the same month.
When showing all corrections:Source, Date, Comment:Reversing J#. Correction J#. 8.77 in depositsSource, Date, Comment:Nameless Diner 8.77 withdrawal
The series of events as I recall it:I entered the invoice of $8.77 on Jan 7 to "Pay Later." Debit to "Due to Principals" credit to A/P Posted it
It was a while ago but I think I posted the payment By: Cash From: Due to Principals
When I realized the source was the bank, I went into the payments journal (via GJ), CTL A to adjust, and changed it from
By: Cash From: Due to Principles
to By: Cash From: Bank.
If I end up with an unresolved amount, Simply will post it to some income account and the accountant can take it from there. But, I'd like to know where I went wrong.
Just wanted to say a proper thank you for your help. It has saved me more hours of frustration.
I am also having a problem in bank reconciliation. I have unsolved amount of -$40,722.83. As i think i made lots of changes in previous month bank statement after posting the bank rec. But when i check in the previous posted entries from the bank rec. window, it still off by about $5000. I don't know what should i do. should i create a new bank rec and start for nex month bank rec. or is there any other way to resolve it.
Also how can i find out if the previous month posted was accurate.
Any help would be appreciated, thanks
In reply to Simple:
hi, I have the same issue with my bank reconciliation. there's an item already reversed but still included on the outstanding cheques. what is the way to correct this. please reply.
In reply to lele:
You can reset the bank rec and start like your first bank rec so you can add prior outstanding item again. Remeber to make a backup before you reset the bank rec. You can follow the link below to get the steps to reset your bank rec: How do I reset the bank reconciliation? Hope this helps
© 2015, Sage Software, Inc. All Rights Reserved. Sage energizes the success of businesses and their communities around the world through the use of smart technology and the imagination of our people. Sage has reimagined business and brings energy, experience and technology to inspire our customers to fulfil their dreams. We work with a thriving community of entrepreneurs, business owners, tradespeople, accountants, partners and developers who drive the global economy. Sage is a FTSE 100 company with 14,000 employees in 24 countries. For more information, visit www.sage.com.
Community Terms of Service | Community Guidelines | Blog List | Community Help