Deleting unwanted /wrong transactions from reconciliation window...

Question

New user here. Picking up from someone who has doubleposted a number of transactions, either through General Ledger Screen or Purchase Windows. These all show up as outstanding transactions in the reconciliation window. 
 If I go back and delete the journal entry, the posting stays in the rec window. I have 30 outstanding rec transactions that really need to be deleted. Clicking on deleted transactions shows a "There is no data to report" - so it seems to be gone in the GL. How do I clean up my rec window from these unwanted outstanding transactions? Thx Bryan

C White · Answer

As Anita said, the 'do not show corrections' button will make your reconciliation window much cleaner. However, I have found that just ticking that button without looking things over can cause problems. Here's what I suggest. 
 Step 1. Reverse/fix any bad transactions. 
 Step 2. Go into your reconciliation. Do NOT hide corrections yet. Look at all of your reversals/corrections. You will note that what Sage actually does when you delete a journal entry is to make a 2nd, mirror-image entry. (This is to keep a complete audit trail, in case you were wondering). When you delete a journal entry that affects your reconciliation, both the original entry and the offsetting entry are supposed to automatically be ticked as 'cleared', but this doesn't always happen. The problem is that this doesn't always happen, so you can end up with a reconciliation that just doesn't work. Find the mirror image entry for each of your deleted entries, and make sure that both are ticked as 'cleared'. 
 Step 3. Hide corrections, and go ahead with the reconciliation as usual.

Anita Simpson · Answer

When you in the reconciliation window there will be an option on the top right to click on "do not show corrections". This will clean up your rec.

RandyW · Answer

Bryan G. said: I'm pretty sure I need to undo 3 weekly reconciliations made in June. Reconciled in error with a $600 adjustment - can't have that. 
 Hi Bryan, 
 One possible reason for posting reconciliations more than monthly not knowing that there is a 'save' feature. 
 'Reconciling' by clearing half a mirrored pair of reversed transactions, leaving the imbalance forever uncleared, is not too uncommon, and it can't be fixed in the reconciliation module, but as you see, that doesn't stop anyone trying. 
 Bryan G. said: With Sage 50 Accountant Edition Version 2019 I can't see a way to undo. Can't move forward until this month is fixed. 
 There is no undo (automatic reversal) feature for some entries (including Deposits and Reconciliation entries) so a manual entry is required to correct / reverse the error. 
 The only way to actually undo a reconciliation, is to 'reset' ALL reconciliations and start over. There is no 'partial reset' that would clear off all the reconciliations back to May. 
 Except when there is a problem with the Company File data, always find the imbalance and post correcting entries, and make sure you can reconcile the next period with all past adjustments and reversals cleared, before taking the somewhat drastic step of clearing reconciliation data. 
 I hope that helps, please post back.

Sage 50 Canada

Deleting unwanted /wrong transactions from reconciliation window...

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING