Topic Options
#16954 - 04/27/09 03:19 PM Resetting bank reconciliation
Cool Aid Offline
Adagio Scholar

Registered: 12/30/08
Posts: 78
Loc: Victoria, BC, Canada
We have started the electronic bank reconciliation for February but had to re-reconcile manually the prior months due to discrepancies between ledger and BR. At this point I would like to start Feb over. I see that there is an option to Reset the pending statuses in the bank reconciliation. This seems to reset the BR transactions only (i.e. the recorded transactions), but does not reset the imported bank statement. If we want to start the Feb reconciliation over, would we reset pending statuses and then re-import the bank statement?

Also, is there a way to see what a BR transaction was matched up to from the bank statement? The reconciliation posting journal provides a list of the recorded items that were reconciled but does not show what they were matched up with. We have some items that have been reconciled but when comparing to actual bank statement there is nothing that matches them.

Thank you,
Tanja

Top
#16994 - 04/28/09 07:04 PM Re: Resetting bank reconciliation [Re: Cool Aid]
Douglas Dickie Offline
Adagio God

Registered: 06/02/99
Posts: 4414
Loc: Vancouver, BC
Your request is not very clear but I'll take a stab at what I think you are asking about.

The reset function should clear all pending statuses. This should also reset the imported statement's to clear the matched transactions to unmatched. You then need to click on OK before attempting to do anything else.

You will now need to delete the remaining imported transactions (highlight all and press the delete key) so that you can import the electronic statement again.

I don't believe there is a report that shows how the imported electronic statmenet matches up with the actual transactions.
_________________________
Douglas Dickie
AccSys Solutions Inc
Phone: 1.888.534.4344
ddickie@accsyssolutions.com

Top
#16995 - 04/28/09 07:14 PM Re: Resetting bank reconciliation [Re: Douglas Dickie]
Cool Aid Offline
Adagio Scholar

Registered: 12/30/08
Posts: 78
Loc: Victoria, BC, Canada
When I used the reset function, it reset all the bank rec transactions (i.e. the recorded transactions) but did not display the imported bank statement items that had been previously matched so I had to re-import the bank statement, as you indicate above. I expected that it would reset both the bank rec data and the imported bank stmt items but I guess this is not the case, the stmt needs to be re-imported with any original items deleted to avoid duplicates.

During the reconciliation process, once I hit OK, the matched bank statement items disappear and I cannot get them back into the view. I can hide/unhide the pending reconciled items on the bank rec data side, but once I've matched the bank stmt items and hit OK I cannot get those back. Is there any way to view the imported bank stmt items once they have been matched but prior to the reconciliation being posted?

Thanks,
Tanja

Top
#16997 - 04/29/09 11:26 AM Re: Resetting bank reconciliation [Re: Cool Aid]
Lars Offline
Adagio Specialist

Registered: 02/08/02
Posts: 301
Loc: Vernon, B. C.
Tanja:

Once you have matched the transactions on the bank statement panel, pressing OK will remove them. If you want to re-do the bank reconciliation you need to delete the items from the bank statement side as Douglas explained above. You can only import the bank statement again if the "Delete import file on success?" is deselected. Otherwise, you will need to download the bank statement again.

Once the bank statement items have been matched, they will be indicated as "Matched" in the bank statement panel, and pending (i.e., O > M) in the bank reconciliation panel. Printing the Worksheet report will give you a list of all the pending items.



Edited by Lars (04/29/09 11:27 AM)
_________________________
Lars Glimhagen
Adagio Certified Trainer
Email: lars@lng.bc.ca

Top


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 92 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14469 Topics
70667 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