cancel
Showing results for 
Search instead for 
Did you mean: 
sbaker1
Level 1

Receive Payments

A credit card payment for an invoice was processed through our store. When I go to Receive Payments to record, it shows in Record Deposits and then it will record it twice. How do you correct this?

10 Comments 10
Ashley H
QuickBooks Team

Receive Payments

Good morning, @sbaker1. Thanks for reaching out to the Community.

 

I need to ask, do you have QuickBooks Payments with us? If so, this could be the reason why you see duplicate deposits. I'm going to provide more information on how to apply customer payments in QuickBooks Desktop.

 

If you're using QuickBooks Payments when processing ACH payments, you have the option to link it to your company file. This way you can send invoices that will be deposited directly into your bank account. Here's how:

  1. Click the Customers menu.
  2. Select Link Payment Service to Company File.
  3. Enter your User ID and Password and select Link Service.
  4. Hit Transfer then Yes, transfer.

However, if you're using a different service, you can manually receive your customer payments. You can deposit them in the Undeposited Funds account to hold the funds until you're ready to deposit them. I've provided the steps below:

  1. Click the Customers tab, then Receive Payments.
  2. Enter the customer name in the Received From drop-down.
  3. In the Payment Amount field, enter the payment you received from the customer.
  4. Press the More button, then Add New Payment Method button.
  5. Set up your payment method then click OK.
  6. Mark the invoices you want to receive the payment.
  7. Hit Save & Close.

Here's a couple of articles that you may find helpful:

Let me know if you have any further questions. I'm always here to lend a helping hand.

sbaker1
Level 1

Receive Payments

Thank you for responding.  We do not use QuickBooks Payments.  When I receive a check for an invoice payment, I follow the steps your provided.  But, since this was a credit card payment through our gift shop, when I enter it in the daily sales report and then go through the receive payments steps, it ends up recording it twice in QuickBooks.

Catherine_B
QuickBooks Team

Receive Payments

Thanks for clarifying, sbaker1. 

 

I'd like to ask further questions when you said that you entered the daily sales report. Did you enter it as a Sales Receipt? If so, it can cause the duplicate. With a sales receipt, you enter the payment information at the same time you're entering the sale. Thus, you don't need to receive a payment. 

 

You have the option to either delete the invoice or the sales receipt. If you opted to delete the sales receipt, here's how we can record the payment.

 

Create a deposit affecting the A/R account. 

  1. Click the ( + ) New button and select Bank deposit
  2. Enter the Account and Date
  3. Under the Add funds to this deposit section, select these options:
    ·        Received From - customer's name.
    ·        Account - Accounts Receivable (A/R).
    ·        Amount - received payment
  4. Fill-out the rest of the fields and then click Save and close

Receive Payment

  1. From the ( + ) New button, click Receive payment.
  2. Enter the customer's name and the Payment date.
  3. Mark a check on the Invoice to be linked. 
  4. At the Credit section, also select the Deposit
  5. Verify the Amount and then click Save and close

We can review your customer's transaction if the invoice is now marked as paid and the balance is correct. I also suggest reaching out to your accountant on other ways on how to record your sales aside from the scenarios I provided. 

 

If you recorded it on a different way, please let me know. I'll be here to help!

Summitx316
Level 1

Receive Payments

My question is, if a payment method was added and it was set up incorrectly, can it be deleted or modified?

 

example, a payment method was set up with the name “Authorize.Net” and was set up as credit card. In reality, as far as QB is concerned it should be Cash. Can I delete and re-add or change it?

YvetteVelarde
Moderator

Receive Payments

@Summitx316 That's a great question.

 

To edit a pay method follow these instructions:

 

1. From the Main Menu select Lists

2. Place cursor over Customer & Vendor Profile Lists

3. Select Payment Method List

4. From the pay method list double click on Authorize.net

5. Change Payment Type to: Cash

 

 

 

If you need additional help let me know.

 

 

 

 

Depigaa
Level 1

Receive Payments

I'm not getting AppliedToTxnRet from ReceivePaymentQueryRs. How can I get AppliedToTxnRet's value.

Below is my XML 

<?xml version="1.0"?>

-<QBXML>


-<QBXMLMsgsRs>


-<ReceivePaymentQueryRs statusMessage="Status OK" statusSeverity="Info" statusCode="0" requestID="101">


-<ReceivePaymentRet>

<TxnID>7-1633083426</TxnID>

<TimeCreated>2021-10-01T15:47:06+05:30</TimeCreated>

<TimeModified>2021-10-01T15:47:07+05:30</TimeModified>

<EditSequence>1633083426</EditSequence>

<TxnNumber>3</TxnNumber>


-<CustomerRef>

<ListID>80000001-1633070406</ListID>

<FullName>DepigaaSV</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-01</TxnDate>

<RefNumber>123456</RefNumber>

<TotalAmount>1.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000001-1633070299</ListID>

<FullName>Cash</FullName>

</PaymentMethodRef>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>0.00</UnusedPayment>

<UnusedCredits>0.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>12-1633513884</TxnID>

<TimeCreated>2021-10-06T15:21:24+05:30</TimeCreated>

<TimeModified>2021-10-06T15:21:24+05:30</TimeModified>

<EditSequence>1633513884</EditSequence>

<TxnNumber>6</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-06</TxnDate>

<RefNumber>5656</RefNumber>

<TotalAmount>5.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>0.00</UnusedPayment>

<UnusedCredits>63.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>1A-1633616796</TxnID>

<TimeCreated>2021-10-07T19:56:36+05:30</TimeCreated>

<TimeModified>2021-10-07T19:56:36+05:30</TimeModified>

<EditSequence>1633616796</EditSequence>

<TxnNumber>8</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-06</TxnDate>

<RefNumber>111112</RefNumber>

<TotalAmount>7.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>6.00</UnusedPayment>

<UnusedCredits>57.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>1F-1633938838</TxnID>

<TimeCreated>2021-10-11T13:23:58+05:30</TimeCreated>

<TimeModified>2021-10-11T13:23:58+05:30</TimeModified>

<EditSequence>1633938838</EditSequence>

<TxnNumber>9</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-07</TxnDate>

<RefNumber>12345</RefNumber>

<TotalAmount>11.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>7946030996641fc367786b45dca3d6</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>8.00</UnusedPayment>

<UnusedCredits>55.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>24-1633938869</TxnID>

<TimeCreated>2021-10-11T13:24:29+05:30</TimeCreated>

<TimeModified>2021-10-11T13:24:29+05:30</TimeModified>

<EditSequence>1633938869</EditSequence>

<TxnNumber>10</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-07</TxnDate>

<RefNumber>1072021</RefNumber>

<TotalAmount>11.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>7946030996641fc367786b45dca3d6</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>9.00</UnusedPayment>

<UnusedCredits>54.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>29-1633941896</TxnID>

<TimeCreated>2021-10-11T14:14:56+05:30</TimeCreated>

<TimeModified>2021-10-11T14:14:56+05:30</TimeModified>

<EditSequence>1633941896</EditSequence>

<TxnNumber>11</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-11</TxnDate>

<RefNumber>1110</RefNumber>

<TotalAmount>12.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>0090857246b237de7de2274c118b32</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>10.00</UnusedPayment>

<UnusedCredits>53.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>2E-1633943490</TxnID>

<TimeCreated>2021-10-11T14:41:30+05:30</TimeCreated>

<TimeModified>2021-10-11T14:55:55+05:30</TimeModified>

<EditSequence>1633944355</EditSequence>

<TxnNumber>12</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-11</TxnDate>

<RefNumber>1110</RefNumber>

<TotalAmount>2.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>0090857246b237de7de2274c118b32</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>0.00</UnusedPayment>

<UnusedCredits>63.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>33-1633943986</TxnID>

<TimeCreated>2021-10-11T14:49:46+05:30</TimeCreated>

<TimeModified>2021-10-11T14:49:46+05:30</TimeModified>

<EditSequence>1633943986</EditSequence>

<TxnNumber>13</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-11</TxnDate>

<RefNumber>556677</RefNumber>

<TotalAmount>1.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>0.00</UnusedPayment>

<UnusedCredits>63.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>3B-1633954532</TxnID>

<TimeCreated>2021-10-11T17:45:32+05:30</TimeCreated>

<TimeModified>2021-10-11T17:45:32+05:30</TimeModified>

<EditSequence>1633954532</EditSequence>

<TxnNumber>14</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-11</TxnDate>

<RefNumber>1110</RefNumber>

<TotalAmount>12.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>0090857246b237de7de2274c118b32</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>10.00</UnusedPayment>

<UnusedCredits>53.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>40-1633955251</TxnID>

<TimeCreated>2021-10-11T17:57:31+05:30</TimeCreated>

<TimeModified>2021-10-11T17:57:31+05:30</TimeModified>

<EditSequence>1633955251</EditSequence>

<TxnNumber>15</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-11</TxnDate>

<RefNumber>1110</RefNumber>

<TotalAmount>12.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>0090857246b237de7de2274c118b32</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>10.00</UnusedPayment>

<UnusedCredits>53.00</UnusedCredits>

</ReceivePaymentRet>


-<ReceivePaymentRet>

<TxnID>45-1633958052</TxnID>

<TimeCreated>2021-10-11T18:44:12+05:30</TimeCreated>

<TimeModified>2021-10-11T18:44:12+05:30</TimeModified>

<EditSequence>1633958052</EditSequence>

<TxnNumber>16</TxnNumber>


-<CustomerRef>

<ListID>80000005-1633508041</ListID>

<FullName>John Doe</FullName>

</CustomerRef>


-<ARAccountRef>

<ListID>80000024-1633073204</ListID>

<FullName>Accounts Receivable</FullName>

</ARAccountRef>

<TxnDate>2021-10-11</TxnDate>

<RefNumber>1110</RefNumber>

<TotalAmount>12.00</TotalAmount>


-<PaymentMethodRef>

<ListID>80000002-1633070299</ListID>

<FullName>Check</FullName>

</PaymentMethodRef>

<Memo>0090857246b237de7de2274c118b32</Memo>


-<DepositToAccountRef>

<ListID>80000025-1633073206</ListID>

<FullName>Undeposited Funds</FullName>

</DepositToAccountRef>

<UnusedPayment>10.00</UnusedPayment>

<UnusedCredits>53.00</UnusedCredits>

</ReceivePaymentRet>

</ReceivePaymentQueryRs>

</QBXMLMsgsRs>

</QBXML>

jamespaul
Moderator

Receive Payments

Hello, Depigaa. 

 

I appreciate your time posting the code here to check for issues. I'd like to point you to the right direction so you can fix the AppliedToTxnRet value. 

 

I see that you're developing a plugin for QuickBooks Desktop. We have a dedicated channel to help you with code or plugin-related issues when developing an app for QuickBooks. 

 

You'll want to contact our Intuit Developer support so they can check on your QBXML file for issues. 

 

You can create a case here: Intuit Developer support

 

We also have articles to help you as you work on your code or plugin. Check out QuickBooks Desktop's help section here: https://developer.intuit.com/app/developer/qbdesktop/docs/get-started.

 

Do you have other questions regarding the processes in QuickBooks Desktop? Please let me know the details below. I'm here to help. 

Depigaa
Level 1

Receive Payments

Actually What I'm trying to do is, syncing the payment data from QBD to my application. But I'm not getting value for "AppliedToTxnRet" in my "ReceivePaymentQueryRs", so I couldn't able to sync the payment with its respective invoice id. I can able to sync payments to its respective invoice from my application to QBD. 

AbegailS_
QuickBooks Team

Receive Payments

Thanks for the clarification, Depigaa.

 

Allow me to help you get the resolution that you need in syncing your payment data.

 

Since we have a dedicated team to help you with code or plugin-related issues, you can contact our Intuit Developer to help you get the value for AppliedToTxnRet.

 

To create a case you can click this link here.

 

Additionally, I encourage checking our Help articles page to learn some tips in managing your QuickBooks Desktop account. From there, you can read articles that can guide you in completing your task.

 

Please know that you can always get back to us if you have any questions with QuickBooks. I'm always here to help. Have a good day.

 

jullianb94
Level 1

Receive Payments

Quick books making me wait several days to have a payment deposited. Bad for cash flow. Qb is getting worse and worse with the  bs. Don't use payment services. I am looking for an entirely new accounting program 

Need to get in touch?

Contact us