cancel
Showing results for 
Search instead for 
Did you mean: 
elainesun2
Level 2

QB online direct bank transfer showed $2100 received and refunded on SAME day by Co B. Received $0.Now create new invoices for Co B$1170,QB show paid with $930 in balance

After we found out this error on QB (no idea how it happened), Company B eventually send us a check for $2100. Invoice paid in full. But QB somehow shows $2100 in Co B account and use it to "pay" new invoices $1170 immediately after invoices created. Co B has not paid $1170 yet. Now on QB Co B has a balance $930.  How to correct this mess?
Solved
Best answer November 27, 2019

Best Answers
JonpriL
Moderator

QB online direct bank transfer showed $2100 received and refunded on SAME day by Co B. Received $0.Now create new invoices for Co B$1170,QB show paid with $930 in balance

Thank you for sharing additional details about your concern, @elainesun2.

 

There are two scenarios you can consider checking why both of these transaction has been recorded into your account. I'm here to share them and help you from there.

 

To start with, checking the Automatically apply credits option as discussed by my colleague above, is one of the reason. Meanwhile, you can review your Audit Log report to check if there are any other users who recorded these transactions. To do so:

  1. Go to the Gear icon.
  2. Under Tools, select Audit Log.
  3. On the Filter menu, select Custom under Date.
  4. Select the date of your transactions.
  5. Click Apply.

In addition, here's an article you can read to learn more about your audit log report: Learn about the Audit Log.

 

Now to fix this, you can delete the invoice amounting to $1170 since you didn't receive any transactions to prove it. Secondly, you don't have to record any refund for the invoice with the amount $2100. And wait for the actual payment so you can record it into your account.

 

In case you need some related articles in managing your customer's transaction, you can visit our Income and Expenses articles for reference.

 

You can always click the Reply button and leave a comment below. I'd be happy to lend a helping hand.

View solution in original post

4 Comments 4
ChristieAnn
QuickBooks Team

QB online direct bank transfer showed $2100 received and refunded on SAME day by Co B. Received $0.Now create new invoices for Co B$1170,QB show paid with $930 in balance

Hi there, elainesun2.

 

It could be the Automatically apply credits feature is turned on and you've created a credit memo. That's why the invoice shows paid with a $930 in balance.

 

To resolve this issue, you'll need to turn off the Automatically apply credits option and delete the created credit memo. Once done, unlink the payment from the invoice.

 

Here's how to to turn off the Automatically apply credits:

 

1. Click the Gear icon at the upper right corner.
2. Select the Advance tab.
3. Select the Automation section. Then, click the pencil icon.
4. Remove the checkmark in the Automatically apply credits box.
5. Click the Save and Done button.

 

Please follow the steps below on how to delete Credit Memo:

 

1. Click the Sales at the left panel. Then choose Customers tab.
2. Select the customer.
3. Choose Transaction List tab. Then open the credit memo and click it to expand the page.
4. Click the More button and hit Delete.
5. You'll be prompted with Are you sure you want to delete this? select the Yes button.

 

Instructions below are steps on how to unlink the payment from the invoice.

 

1. Select the Sales at the left panel. Then choose the Customer tab.
2. Select the customer.
3. Choose the payment transaction. Then click it to expand the page.
4. Remove the checkmark in the boxes beside the Invoice and Credit Memo option.
5. Hit Save and close.

 

After following the steps above, I suggest to create a refund receipt or check to record the refunded amount.

 

Here's how to use the refund receipt:

 

1. Click the Plus icon at the upper right corner. Then choose Refund receipt.
2. Select the Customer drop-down, then select the customer you want to refund.
3. Choose the Refund From drop-down, then select the bank you deposited the payment for the invoice too.
4. Add all products or services the customer returned in the Product or service column.
5. Fill in the necessary fields. Then click Save and close button.

 

You may check this article to learn different ways how you can send invoices to your customers in QuickBooks Online: Send an invoice.

 

Please let me know how it goes or if you have any other concerns with QuickBooks. I'll be around to help you out. Have a good one.

elainesun2
Level 2

QB online direct bank transfer showed $2100 received and refunded on SAME day by Co B. Received $0.Now create new invoices for Co B$1170,QB show paid with $930 in balance

Hi ChristieAnn,

 

Thank you so much for your help. I have not started anything as you suggested yet because I need to know the answer for this question before I do any correction:

If I create a refund receipt, will money really go back to Company B? Money will be taken out of my account and go to Company B? Or no real money involved, only book keeping record cancel out the $2100 error?

 

On 10/8/2019 QB transaction showed $2100 was automatically received and refunded on the SAME day. We have no idea how this happened in the QB system. What we know is no money has been deposited to our bank account. $2100 never came in. We have a bank statement to prove it. Company B eventually send us a check in the mail and paid the invoice in full. But in QB system, this "$2100" is still there, never refunded as system transaction indicated. So when we entered 2 new invoices for $400 and $770, immediately showed paid by this "$2100", with a remaining of $930 ($2100-$400-$770). The fact is: These 2 new invoices have not been paid yet. We have not received any payment. There is no "$2100" from Company B.

 

If create a refund will actually give money back to Company B, then we cannot do that. We do not owe them any money. If create a refund is only a record to zero out this $2100 system error, no real money involved, then we can do it. Please advice. Thank you.

 

 

JonpriL
Moderator

QB online direct bank transfer showed $2100 received and refunded on SAME day by Co B. Received $0.Now create new invoices for Co B$1170,QB show paid with $930 in balance

Thank you for sharing additional details about your concern, @elainesun2.

 

There are two scenarios you can consider checking why both of these transaction has been recorded into your account. I'm here to share them and help you from there.

 

To start with, checking the Automatically apply credits option as discussed by my colleague above, is one of the reason. Meanwhile, you can review your Audit Log report to check if there are any other users who recorded these transactions. To do so:

  1. Go to the Gear icon.
  2. Under Tools, select Audit Log.
  3. On the Filter menu, select Custom under Date.
  4. Select the date of your transactions.
  5. Click Apply.

In addition, here's an article you can read to learn more about your audit log report: Learn about the Audit Log.

 

Now to fix this, you can delete the invoice amounting to $1170 since you didn't receive any transactions to prove it. Secondly, you don't have to record any refund for the invoice with the amount $2100. And wait for the actual payment so you can record it into your account.

 

In case you need some related articles in managing your customer's transaction, you can visit our Income and Expenses articles for reference.

 

You can always click the Reply button and leave a comment below. I'd be happy to lend a helping hand.

elainesun2
Level 2

QB online direct bank transfer showed $2100 received and refunded on SAME day by Co B. Received $0.Now create new invoices for Co B$1170,QB show paid with $930 in balance

Thank you so much. Problem solved. Appreciate whole-hardheartedly for such super fast responses.

Need to get in touch?

Contact us