Topic Options
#39800 - 01/09/14 10:27 AM Bank Rec Issues
bd Offline
Adagio Guru

Registered: 11/29/01
Posts: 102
Loc: Peterborough, ON
I just started using Bank Rec - I did November manually but used electronic for Dec for our main bank account. It didn't go as smoothly as I had hoped. I watched the webinar and some videos. I have the latest version and I know the webinar had an earlier one, but on the webinar, he hid pending status and then unchecked that and you could see matched items again. I could not do that. Once I exited the reconciliation or hid pending statuses my matched items disappeared for good. I could change a cleared item to outstanding, but that didn't bring back the item it got matched to on the bank statement side from what I could see. This is a bit disturbing because that would be an easy way to make a mess of the reconciliation.

One issue that may be causing mismatching with deposits was that we enter some monies on the date we technically receive them and they show up in our bank the following business day. The webinar and help say it won't match items with an earlier date in the books than in the bank. We also have a lot of times when we may have the same amounts on different deposits as we take donations online and many donations may be $25 or $50 and we have visas and mastercards both going in separately. So there can be a few deposits with the same amount over a month. I've set things up carefully so that we are entering visa and mastercard in separate deposits to help match things correctly.

I ended up restarting my whole month's reconciliation and by matching the deposits manually it all worked out. So one change I would like to see or let me know if it's there is to have the option to only automatch cheques. That part was great. laugh

The other thing I'd like to see is to be able to see what matched what and to unmatch items on both sides at the same time and of course to keep the matching until the reconciation is posted. My hope is too that we will stay on top of the reconciliation instead of doing a month at a time.
_________________________
Barb

Top
#39801 - 01/09/14 11:01 AM Re: Bank Rec Issues [Re: bd]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Hi Barb,

During the matching phase of an imported bank reconciliation, you can toggle between showing everything or just unmatched, but if you close the Reconciliation screen with OK then this will remove the imported matched record(s).

If you are running the latest BankRec version 8.1E, check out the New Release video, which demonstrates a number of new features related to importing bank reconciliations, such as more control over how records are auto-matched (ie require a reference match, which typically means checks only) and allowing post-dated records to be matched within a defined threshhold. Let us know if any of these features address your concerns.
_________________________
Regards,
Softrak Tech Support

Top
#39802 - 01/09/14 11:24 AM Re: Bank Rec Issues [Re: Softrak Support]
bd Offline
Adagio Guru

Registered: 11/29/01
Posts: 102
Loc: Peterborough, ON
Okay, thanks, I've now unticked matching by date and amount. That should help.

It would still be nice if it could match deposits and be able to unmatch in case of an error. May involve setting up some rules though.
_________________________
Barb

Top
#39804 - 01/09/14 03:30 PM Re: Bank Rec Issues [Re: bd]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3611
Loc: Toronto ON, Canada
Hi Support:
I agree with Barb that it would be useful if closing/saving the reconciliation left the bank (left) side transactions intact. It makes sense to delete the ones marked as "Deleted" but I think the "Matched" ones should remain. Since matched transactions can be hidden with a single click, I don't see any advantage to deleting them
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#39805 - 01/09/14 03:53 PM Re: Bank Rec Issues [Re: Bruce Gardner]
Retired_Guy Offline
Adagio Master

Registered: 03/16/99
Posts: 10504
Loc: Canada
It's been recorded as a suggestion. They aren't saved on disk, so this will have to wait for the next Upgrade Cycle on BankRec.
_________________________
Andrew Bates

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 81 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14449 Topics
70594 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30