Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I successfully imported iif file for customer payment of invoice but payment is not applied to related invoice. I need help to apply payment to related invoice. I attached the iif file used to import transaction in QuickBooks. Following are the transaction detail and the code I used to to import the transaction in QuickBooks Desktop:
A; Transaction Detail
1: Customer name ABC Party
2: Invoice no:051005
3: Payment method :Visa
4: Amount : 22.26
5: Date :09/26/2020
B: Code
!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM PAYMETH
!ENDTRNS
TRNS PAYMENT 09/26/2020 RBC Revenue ABC Party 22.26 051005 Visa
SPL 051005 PAYMENT 09/26/2020 Accounts Receivable ABC Party -22.26 051005 Visa
ENDTRNS
Thanks
I appreciate the complete details you've shared, @25Nick.
Currently, the ability to link imported payments with your invoices is not available. You'd have to manually mark your customer's invoice as paid.
Here's how:
Since you already imported the invoice payments, it will become a credit. Here's how to manually link the credit to your customer's open invoices:
You can read through this article for more detailed steps about the different ways you can track customer transactions in QuickBooks Desktop: Get started with customer transaction workflows.
Keep us posted if you have other questions. I'm always here to help.
IIF doesn't support many transactions types. You need a 3rd party app to do so.
https:// transactionpro.grsm.io/qbd
https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2
You will prepare the Receive Payment data with the following template
Customer | Check Number | Transaction Date | Payment Method | Memo | Apply to Invoice (blank auto-applies) | Amount | Deposit To | Discount Amount | Discount Account | Discount Class | AR Account | Exchange Rate |
Anne's Bakery | 123 | 01/11/2020 | Check | 100 | 10000 | Checking | ||||||
John's Barber Shope | 999 | 01/11/2020 | Check | 101 | 500 | Checking |
Thanks for your advise, I'm currently using manual process to apply payment to invoice.
Thanks for your suggestion. My employer doesn't like to pay any fee for 3rd party app.
Are there any other 3rd party apps that support customer payments and the applying process of those payments?
"Currently, the ability to link imported payments with your invoices is not available. You'd have to manually mark your customer's invoice as paid."
And this is yet another reason why so many Intuit customers look elsewhere for software solutions that fit their needs better.
Do you mean a 3rd party payment processor to integrate with QB Desktop?
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.
For more information visit our Security Center or to report suspicious websites you can contact us here