Hi Dalal,

Since your question relates directly to Sage 50 CA, I will move your post to that Support Group so that other users of the product will see it and be able to offer their thoughts and insight.

Please note that the Town Hall is for Sage City tips and tricks, as well as surveys and feedback on the site. For technical questions, please be sure to post those in the applicable Product Support Community.

Thanks,

Derek

Hi Dalal,

On the aging report, the payment should show twice, one a positive and one a negative.  

As long as the total of the payment to offset the writeoff credit not against the balance owing, was zero, it should be correct and will have no effect on the bank balance.

Thank you but why is the aging report showing 2 negative payments when I only offset the payment once.

Derek, did you see the screen print I included with my questions.   I`ve had 2 colleagues look at it as well and we can`t figure out why.

The two 6250 references balance each other out on the text part of what you sent.

Please attach another screen shot, it didn't follow when Derek moved your post to the Canadian Sage 50 forum.

I only attached the screen shot of the aging. The aging is at 0 but I don`t understand why my bank is off by $85.  Is there someway I can send you copies of the invoices and receipts.

The only thing I can see that might throw the bank off by $85 is if the payment marked 6174 in August was recorded to the wrong bank account.  

Or, you actually received two payments for $85 and shouldn't have written off anything.

Or, the $85 payment was reversed by the bank, and you should have written off the whole $170.

Run a Receipts Journal report, check to make sure that all your deposits are on it.  

ok, will do, thanks.  I hope I find it!

We only received one payment for $85 on ch204. When the cllent informed us she wouldn`t pay the balance we wrote it off.

I received one payment on ch204 receipt 6174 for $85 and it went to correct bank account as per the receipts journal you suggested I check.

We only received one payment of $85.

How can I check if the bank reversed the $85, not sure what you mean by this.

There is one extra withdrawal in the bank. Need a deposit to balance. ???

Is the withdrawal in the bank, related to an adjustment?  

When you 'drill down' into the transaction, what is it from?

Have you tried turning off 'show adjustments' ?

There are so many now that I've tried many ways to correct this.  I will cross check each one and see.

thx.

If you turn 'show corrections' off on reports, and on your reconciliation, you will get only the 'final' transaction.

The bank reconciliation can be confusing if you have made an adjustment after reconciling, since the reconciled transaction is still 'reconciled to' and there's a reversal showing as an uncleared item.

I cross reference the bank ledger.

16/08/2013 Iris Darhy 6174 J152 85.00

16/08/2013 Reversing J152. Correction is J1594. ADJ6174 J1594 85.00

17/09/2013 Iris Darhy 6180 J270 85.00

17/09/2013 Reversing J270. Correction is J489. ADJ6180 J489 85.00

20/11/2013 Iris Darhy 6244WRT-OFF J1592 85.00

20/11/2013 Reversing J1592. Correction is J1593. ADJ6244WRT-OFF J1593 85.00

20/11/2013 WRT-OFF1314-005, Iris Darhy Cash J1596 85.00

20/11/2013 Reversing J1596. Correction is J1598. ADJCash J1597 85.00

16/08/2013 Iris Darhy 6244 J1601 85.00

16/08/2013 Reversing J1601. Correction is J1606. ADJ6244 J1606 85.00

31/03/2014 Iris Darhy 6246 J1604 85.00

31/03/2014 Reversing J1604. Correction is J1605. ADJ6246 J1605 85.00

16/08/2013 Iris Darhy 6247 J1609 85.00

16/08/2013 Reversing J1609. Correction is J1618. ADJ6247 J1618 85.00

20/11/2013 Iris Darhy 6248 WRT-OFF J1610 85.00

20/11/2013 Reversing J1610. Correction is J1616. ADJ6248 WRT-OFF J1616 85.00

16/08/2013 Iris Darhy 6174 J1622 85.00

765.00 680.00

In total we received one payment of $85 to the bank.

When I turn off the corrections I am left with one deposit of $85 dated Aug.16. which I had already reconciled. As you wrote, after the fact is very confusing.

I cross reference the bank ledger.

16/08/2013 Iris Darhy 6174 J152 85.00

16/08/2013 Reversing J152. Correction is J1594. ADJ6174 J1594 85.00

17/09/2013 Iris Darhy 6180 J270 85.00

17/09/2013 Reversing J270. Correction is J489. ADJ6180 J489 85.00

20/11/2013 Iris Darhy 6244WRT-OFF J1592 85.00

20/11/2013 Reversing J1592. Correction is J1593. ADJ6244WRT-OFF J1593 85.00

20/11/2013 WRT-OFF1314-005, Iris Darhy Cash J1596 85.00

20/11/2013 Reversing J1596. Correction is J1598. ADJCash J1597 85.00

16/08/2013 Iris Darhy 6244 J1601 85.00

16/08/2013 Reversing J1601. Correction is J1606. ADJ6244 J1606 85.00

31/03/2014 Iris Darhy 6246 J1604 85.00

31/03/2014 Reversing J1604. Correction is J1605. ADJ6246 J1605 85.00

16/08/2013 Iris Darhy 6247 J1609 85.00

16/08/2013 Reversing J1609. Correction is J1618. ADJ6247 J1618 85.00

20/11/2013 Iris Darhy 6248 WRT-OFF J1610 85.00

20/11/2013 Reversing J1610. Correction is J1616. ADJ6248 WRT-OFF J1616 85.00

16/08/2013 Iris Darhy 6174 J1622 85.00

765.00 680.00

In total we received one payment of $85 to the bank.

There is one $85 debit in bad debts and one in bank which is the first payment.  I should balance. Not sure what to do with the bank rec.  If I clear the $85 it reads unresolved $85. If I don't clear it, it balances at 0 but shows $85 outstanding on the bank rec.  I give up!!

I think I just figured it out thanks to your suggested of breaking down the deposits.  

The first $85 cheque cleared the bank but the second was returned nsf.  I believe I forgot to create a new invoice, I only posted it in the bank.  I will try to fix this.  I've been working with simply for over 20 yrs, never had this problem..  I really appreciate your time.  thank  you.

I cross reference the bank ledger.

16/08/2013 Iris Darhy 6174 J152 85.00

16/08/2013 Reversing J152. Correction is J1594. ADJ6174 J1594 85.00

17/09/2013 Iris Darhy 6180 J270 85.00

17/09/2013 Reversing J270. Correction is J489. ADJ6180 J489 85.00

20/11/2013 Iris Darhy 6244WRT-OFF J1592 85.00

20/11/2013 Reversing J1592. Correction is J1593. ADJ6244WRT-OFF J1593 85.00

20/11/2013 WRT-OFF1314-005, Iris Darhy Cash J1596 85.00

20/11/2013 Reversing J1596. Correction is J1598. ADJCash J1597 85.00

16/08/2013 Iris Darhy 6244 J1601 85.00

16/08/2013 Reversing J1601. Correction is J1606. ADJ6244 J1606 85.00

31/03/2014 Iris Darhy 6246 J1604 85.00

31/03/2014 Reversing J1604. Correction is J1605. ADJ6246 J1605 85.00

16/08/2013 Iris Darhy 6247 J1609 85.00

16/08/2013 Reversing J1609. Correction is J1618. ADJ6247 J1618 85.00

20/11/2013 Iris Darhy 6248 WRT-OFF J1610 85.00

20/11/2013 Reversing J1610. Correction is J1616. ADJ6248 WRT-OFF J1616 85.00

16/08/2013 Iris Darhy 6174 J1622 85.00

765.00 680.00

In total we received one payment of $85 to the bank.

It looks like when you reversed J1596, a balance was recorded into J1598.   A 'Credit Note' may have been automatically created by the deletion of your write-off invoice, after it was recorded as paid.  You may have to record an 'un-write-off' manual reversal of the write-off invoice, that was recorded as paid, in order to completely balance off that journal entry.

I hope that helps,

Randy

I cross reference the bank ledger.

16/08/2013 Iris Darhy 6174 J152 85.00

16/08/2013 Reversing J152. Correction is J1594. ADJ6174 J1594 85.00

17/09/2013 Iris Darhy 6180 J270 85.00

17/09/2013 Reversing J270. Correction is J489. ADJ6180 J489 85.00

20/11/2013 Iris Darhy 6244WRT-OFF J1592 85.00

20/11/2013 Reversing J1592. Correction is J1593. ADJ6244WRT-OFF J1593 85.00

20/11/2013 WRT-OFF1314-005, Iris Darhy Cash J1596 85.00

20/11/2013 Reversing J1596. Correction is J1598. ADJCash J1597 85.00

16/08/2013 Iris Darhy 6244 J1601 85.00

16/08/2013 Reversing J1601. Correction is J1606. ADJ6244 J1606 85.00

31/03/2014 Iris Darhy 6246 J1604 85.00

31/03/2014 Reversing J1604. Correction is J1605. ADJ6246 J1605 85.00

16/08/2013 Iris Darhy 6247 J1609 85.00

16/08/2013 Reversing J1609. Correction is J1618. ADJ6247 J1618 85.00

20/11/2013 Iris Darhy 6248 WRT-OFF J1610 85.00

20/11/2013 Reversing J1610. Correction is J1616. ADJ6248 WRT-OFF J1616 85.00

16/08/2013 Iris Darhy 6174 J1622 85.00

765.00 680.00

In total we received one payment of $85 to the bank.

It looks like when you reversed J1596, a balance was recorded into J1598.   A 'Credit Note' may have been automatically created by the deletion of your write-off invoice, after it was recorded as paid.  You may have to record an 'un-write-off' manual reversal of the write-off invoice, that was recorded as paid, in order to completely balance off that journal entry.

I hope that helps,

Randy