Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowA 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?
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:
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:
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.
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.
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.
Receive Payment
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!
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?
@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.
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>
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.
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.
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.
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
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.