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

Importing IIF for Payments and Invoices, Linking, marking PAID?

We are importing Invoices and Payments via IIF imports to Quickbooks Enterprise Desktop 2015.

Invoices and Payments imports correctly, the problem is now that we have to manually link the payments and invoices together to zero out the balance and mark it PAID.

Question is if there is a way to IIF import the payments and Invoices in already linked and marked PAID?

This would eliminate thousands of transactions linking to be done manually.

 

Thank you.

6 Comments 6
Fiat Lux - ASIA
Level 15

Importing IIF for Payments and Invoices, Linking, marking PAID?

You may need a 3rd party app to do so.

Carsco
Level 1

Importing IIF for Payments and Invoices, Linking, marking PAID?

Do you know of any 3rd party apps that does that?

Fiat Lux - ASIA
Level 15

Importing IIF for Payments and Invoices, Linking, marking PAID?

You may keep using IIF data to be imported into QBD. But you have to use a 3rd party tool to import Receive Payment data in XLS/CSV into your QBD. 

https:// transactionpro.grsm.io/qbd

https:// partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

The template should be like this

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     

 

BigRedConsulting
Community Champion

Importing IIF for Payments and Invoices, Linking, marking PAID?

@Carsco 

RE: Question is if there is a way to IIF import the payments and Invoices in already linked and marked PAID?

 

There is not.  QB will not link payments to invoices as you import them.  Intuit could change this at any time, but they have not.

Reconciler
Level 2

Importing IIF for Payments and Invoices, Linking, marking PAID?

If I import invoices and then payments into QB (I'm using Mac Desktop), how do I then apply credit memos and payments against the outstanding invoice(s)?

 

ZackE
QuickBooks Team

Importing IIF for Payments and Invoices, Linking, marking PAID?

Thanks for joining this thread, Reconciler.

 

You can apply credit memos and payments to invoices through your Receive Payment screen.

 

Here's how:

  1. In the top menu bar, go to Customers.
  2. Choose Receive Payment.
  3. From your Received From drop-down list, pick the customer's name.
  4. If you need to apply credits to an invoice, tick your Apply Existing Credits? checkbox. To apply existing payments, enter the payment details and select the appropriate invoice(s) to apply them to.
  5. Click Save.

 

You'll also be able to find many detailed resources about using QuickBooks in our help article archives.

 

Please don't hesitate to send a reply if there's any additional questions. Have a great day!

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up