Deleting unwanted /wrong transactions from reconciliation window...

SUGGESTED

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

Parents
  • 0
    SUGGESTED

    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.

  • 0 in reply to C White

    Thanks!  I'm sure I'll be back.  It's nice to know I can ask someone!

    Bryan

  • 0 in reply to Bryan G.

    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.  With Sage 50 Accountant Edition Version 2019 I can't see a way to undo. Can't move forward until this month is fixed.  Thx for any help..b.

  • 0 in reply to Bryan G.

    Unfortunately Sage does not have that feature available.  They need to add this.  The only way is report your adjustment to balance and reprint the Reconciliation with the new balance.

Reply Children