write -offs

Hello,

I have not had a problem posting write-offs until this one transaction which was a partial payment and balance written off to bad debt.

For some reason, it keeps a balance in a/r and the bank reconciliation does not balance.

invoice $170  

paid $85 

balance $85 write off

receipt to offset balance of $85 and credit note of $85 so why does it read 2x receipt #6250 - that seems to be  throwing off the bank.

 Source  Date  Transaction Type  Total
1314-005 03/06/2013 Invoice 170.00
6174 16/08/2013 Payment (85.00)
6250 31/03/2014 Payment (85.00)
1314-005WRT-OFF 20/11/2013 Invoice (85.00)
6250 31/03/2014 Payment 85.00
0.00
Parents
  • Hi Dalal,

    You did not do anything incorrect.  

    After the invoice 1314-005 ($170.00) was paid by receipt 6174 ($85), the outstanding balance of the invoice was $85.00.  

    Since the remaining balance was not paid by the customer, you created another invoice 1314-005WRT-OFF with a negative amount of -$85.00.  You had 2 invoices.  One was $85.00 (remaining balance from 1314-005) and one was -$85.00 (new negative invoice 1314-005WRT-OFF) .

    You paid them both by using receipt 6250 and the net was zero.  That's why there are 2x receipt #6250.  You paid 2 invoices (1 positive and 1 negative) by 1 receipt and they offset each other so the net was zero

    Logically speaking, the only amount from this customer that was debited to you bank was the $85.00 from receipt 6174 as per your age report.  

    The $85.00 in a/r may be from another customer but not this customer.

    Hope this helps.

  • in reply to Keith L

    Keith,

    Look closer at the second transaction of this pair  it is an invoice that was reversed after it was paid, and there are two journal entries.  The payment wasn't reversed.

    This would have created a 'CM' transaction.  

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

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

     

  • in reply to RandyW

    Hi Randy,

    Thanks for the clarification.  :)

  • in reply to Keith L

    Thank you Randy, I will review it again.

Reply Children
No Data