Retuned partial advance payment

Dec 11, 2009 4 Replies

I received advance payment from the customer before creating an invoice. Using QB Pro 2009, this paymnet was credited to the name of customer under item paymnet. Then partial amount was adjusted against the invoice and the remaining amount was retured to the customer by cheque. How to link this retuned paymnet with advance paymnet that stll showed as a credit on the name of the customer. No doubt "open balance" for that customer is $0.00, but "open balance report" showed both the amount i.e. credit balance as well as retuened amount. I appreciate your feed back.



Jayesh Shah


##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - alt.comp.software.financial.quickbooks - 8410 messages and counting! ##-----------------------------------------------##


Jayesh,

In order for QuickBooks to link these items they need to be done in order. If you receive payment, issue a credit and then create the invoice they will not link. In order for this to work you need to create the invoice, recieve payment against the invoice and then issue the credit. To fix the problem now you would delete the deposit, then delete the payment, which should remove the credit, if not delete the credit also which should leave an open invoice. Now recieve payment, issue a credit returns and record the deposit. Before deleiting take not of dates and check numbers so you can recreate them accordingly. As long as the depsoit has not been cleared in your checking account this should be easy. If the deposit is marked cleared this will create a discrepancy in your bank reconciliation. Simply re-reconcile the account with only the uncleared depoist and all should be well.

Hope this is helpful even if it is not what you were looking for.

Randy

jayesh had written this in response to

formatting link
:

I received advance payment from the customer before creating an invoice. Using QB Pro 2009, this paymnet was credited to the name of customer under item paymnet. Then partial amount was adjusted against the invoice and the remaining amount was retured to the customer by cheque. How to link this retuned paymnet with advance paymnet that stll showed as a credit on the name of the customer. No doubt "open balance" for that customer is $0.00, but "open balance report" showed both the amount i.e. credit balance as well as retuened amount. I appreciate your feed back.

Jayesh Shah

Randy

Thank you for your help. Yes, it can work the way you showed but when I received payment I have to post it as money is already in bank account. And when I creat an invoice I adjust the invoice against that payment as it shows as credit for that customer. And it also link with it. But the problem this time is that partial payment is adjusted against the invoice and it also linked with that invoice. But the remaining credit and returned amount through chqeue is not linked. Please can you light on it. Thank you.

Jayesh Shah

------------------------------------- rtm4833 wrote:

##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - alt.comp.software.financial.quickbooks - 8416 messages and counting! ##-----------------------------------------------##

jayesh had written this in response to

formatting link
:

I received advance payment from the customer before creating an invoice. Using QB Pro 2009, this paymnet was credited to the name of customer under item paymnet. Then partial amount was adjusted against the invoice and the remaining amount was retured to the customer by cheque. How to link this retuned paymnet with advance paymnet that stll showed as a credit on the name of the customer. No doubt "open balance" for that customer is $0.00, but "open balance report" showed both the amount i.e. credit balance as well as retuened amount. I appreciate your feed back.

Jayesh Shah

Randy

Thank you for your help. Yes, it can work the way you showed but when I received payment I have to post it as money is already in bank account. And when I creat an invoice I adjust the invoice against that payment as it shows as credit for that customer. And it also link with it. But the problem this time is that partial payment is adjusted against the invoice and it also linked with that invoice. But the remaining credit and returned amount through chqeue is not linked. Please can you light on it. Thank you.

Jayesh Shah

------------------------------------- jayesh wrote:

formatting link
:

Randy Thank you for help. Yes, it works that way. Jayesh Shah

##-----------------------------------------------## Newsgroup Access Courtesy

formatting link
Tax and Accounting Software ForumsWeb and RSS access to your favorite newsgroup - alt.comp.software.financial.quickbooks - 8426 messages and counting! ##-----------------------------------------------##

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required