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

Importing customer payments

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

 

 

7 Comments 7
IamjuViel
QuickBooks Team

Importing customer payments

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:

  1. Choose Customers at the menu tab.
  2. Select Receive Payment.
  3. In the Received From the drop-down, then choose the customer's name.
  4. Enter the payment.
  5. Set the correct date, then select the Payment method.
  6. Choose the invoices you'd like to pay. 
    payment.PNG
  7. Select Save and Close.

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:

  1. Open the deposit, then change the account to Accounts Receivable.
  2. Click Save & Close.
  3. Open the invoice.
  4. Select the Receive Payments button.
  5. Click Apply Credits.
  6. Go to the Credits tab.
  7. Select the deposit, then click Done
  8. Click Save & Close

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.

Fiat Lux - ASIA
Level 15

Importing customer payments

@25Nick 

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

CustomerCheck NumberTransaction DatePayment MethodMemoApply to Invoice (blank auto-applies)AmountDeposit ToDiscount AmountDiscount AccountDiscount ClassAR AccountExchange Rate
Anne's Bakery12301/11/2020Check 10010000Checking     
John's Barber Shope99901/11/2020Check 101500Checking     
25Nick
Level 1

Importing customer payments

Thanks for your advise, I'm currently using manual process to apply payment to invoice.

25Nick
Level 1

Importing customer payments

Thanks for your suggestion. My employer doesn't like to pay any fee for 3rd party app.

eyelean
Level 2

Importing customer payments

Are there any other 3rd party apps that support customer payments and the applying process of those payments?

eyelean
Level 2

Importing customer 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.

Fiat Lux - ASIA
Level 15

Importing customer payments

@eyelean 

Do you mean a 3rd party payment processor to integrate with QB Desktop?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us