Topic Options
#35408 - 02/07/13 02:19 PM Bank Rec out of balance
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
I'm using Bank Rec module 8.1D

I was in a bank account and used Reverse (check Date) to fix a transfer that was booked backwards. It worked fine and I finished the bank rec.

When I went to the account on the other side of the reversed entry, I reconciled as usual, posted my reconciliation and printed my reports and found I'm off from Bank Rec to the GL.

On further inspection, that one item no longer shows up in the bank account (as it should since it was reconciled). If I am looking at the list of accounts, click the account, I can see item in the list and it has a Y next to it as reconciled (as it should). But if I print out a Bank Reconciliation Report (detail), the item shows up as an outstanding item. This item is exactly how much the Bank Rec and GL is off by.

Suggestions?

Top
#35413 - 02/07/13 04:05 PM Re: Bank Rec out of balance [Re: ASANTOS]
Softrak Support Offline

Adagio Action Team

Registered: 03/09/99
Posts: 11520
Loc: Vancouver, BC Canada
Are you printing your report with a date of today? Or are you back-dating the report date to something earlier?

When back-dating the Bank Reconciliation report, calculations have to be made to determine which transactions were outstanding as of the report date. This is done using the date of the reconciliation which changes the status date.

Reversals are unique in that they do not have to be processed with other transactions when matching against a bank statement - they can be done at any time. For this reason, the dates to determine when a transaction was outstanding before it wsa reversed are not as clear. The report makes an attempt to determine this correctly, but it appears that in your case the different dates stored on the transaction and reconciliation records are putting the check as outstanding when you didn't expect it to be?
_________________________
Regards,
Softrak Tech Support

Top
#35427 - 02/08/13 10:16 AM Re: Bank Rec out of balance [Re: Softrak Support]
ASANTOS Offline
Adagio Groupie

Registered: 02/07/13
Posts: 15
Loc: California
The reversal was dated 1/3/13. The bank statement is for the period ending 1/31/13. All the reports are dated for 1/31/13. The item which shows as reconciled everywhere but still shows up on the 1/31/13 Bank Reconciliation report (detail)shows up at 1/3/13.

So basically everything happened in January. This is basically a glitch in the software. It does not show up in the bank account since it was reconciled as of the 1/31/13 bank rec. It does show up with the Y reconciliation marker if you click on the specific bank account. And yet it still shows up as an outstanding item on the Bank Reconciliation detail report.

Top


Moderator:  Christa_Meissner 
Who's Online
1 registered (Tanya_Belanger), 189 Guests and 1 Spider online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14448 Topics
70593 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