Refundable Deposits in AR
Posted: Thu Jul 16, 2009 8:26 am
Hi All,
Customer pays a deposit and registers his sales order. The sales order could or could not be converted to a actual sales. If an invoice is raised the deposit will be applied and if an invoice is not raised the whole deposit will have to be refunded.
I thought the best way to handle the above is through the Deposit function within AR. Initially a receipt would be raised
DR Cash 5000.00
CR Receipt In Advance 5000.00
And a Deposit
DR Receivable 5000.00
CR Deposit Refundable 5000.00
I applied the receipt to the Deposit.
DR Reeceipt in Advance 5000.00
CR Receivables 5000.00
But the issue is when an invoice is raised for a lower amount, say for 3500.00
DR Receivable 3500.00
CR Revenue 3500.00
And Apply the deposit (Will be partially applied)
DR Deposit Refundable 3500.00
CR Receivable 3500.00
Ultimately all receipt , deposit and invoice will show 0s. But when u run the commitment balance report , it will show the 1500.00 as outstanding deposits. How can I clear this figure as anyway I will be rosining an Invoice (AP) debiting Deposit Refundable account and pay. Ultimately deposit account (GL account) will show the correct figure.
Please help me out in clearing the commitment balance report
Else suggest me a better idea to handle the above scenario..
Leaving for u all experts[:)]
Thanks,
Rihan
Customer pays a deposit and registers his sales order. The sales order could or could not be converted to a actual sales. If an invoice is raised the deposit will be applied and if an invoice is not raised the whole deposit will have to be refunded.
I thought the best way to handle the above is through the Deposit function within AR. Initially a receipt would be raised
DR Cash 5000.00
CR Receipt In Advance 5000.00
And a Deposit
DR Receivable 5000.00
CR Deposit Refundable 5000.00
I applied the receipt to the Deposit.
DR Reeceipt in Advance 5000.00
CR Receivables 5000.00
But the issue is when an invoice is raised for a lower amount, say for 3500.00
DR Receivable 3500.00
CR Revenue 3500.00
And Apply the deposit (Will be partially applied)
DR Deposit Refundable 3500.00
CR Receivable 3500.00
Ultimately all receipt , deposit and invoice will show 0s. But when u run the commitment balance report , it will show the 1500.00 as outstanding deposits. How can I clear this figure as anyway I will be rosining an Invoice (AP) debiting Deposit Refundable account and pay. Ultimately deposit account (GL account) will show the correct figure.
Please help me out in clearing the commitment balance report
Else suggest me a better idea to handle the above scenario..
Leaving for u all experts[:)]
Thanks,
Rihan