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

Invoice and Payment record link

After exporting Invoices and Payments records, I cannot locate any reference key between them. What is the easiest way ( table or field) to match them up? Easy when 1pmt to 1 Invoice, but harder on 1pmt for many Invoices or many pmts on an Invoice. Any help/suggestions are appreciated.

3 Comments
Highlighted
Level 15

Invoice and Payment record link

Open any payment and the bottom shows where you applied it. The History, Ctl H, shows what it is linked to, as invoices and as DEP. Follow the link = click one, and then use Go To.

 

Open any invoice and the History icon, or Ctl H, shows what is linked to it. Here are those payments + any credit memos applied.

 

This is a relational database. Everything is linked to something else.

Highlighted
Level 1

Invoice and Payment record link

Thanks, but I am looking for the link in order to match the Payments/Credits with the Invoices outside of Quickbooks. I have exported the Invoices, Payments and Credits into sql tables but don't see a field in either which has the other's record number or field that has a link reference.

 

Is there a seperate xref table or a link field i'm not seeing? 

 

Regards,

Highlighted
QuickBooks Team

Invoice and Payment record link

Thanks for the response, @Tomalford54.

 

I appreciate you clarifying this concern. I have some information about exporting transactions from QuickBooks.

 

QuickBooks Desktop lets you export data on a CSV or MS Excel format file, but there's not a link you can click to match payments and invoices. However, I have a workaround that should work for you.

 

You may use the Memo field to add a note determining which payment was applied to an invoice. To do that, just follow the steps below:

  1. Open the Customer Center.
  2. Choose Customer and Jobs.
  3. Select the Transactions tab.
  4. Go to the View menu at the top.
  5. Select Customize Transaction List Columns.
  6. In the Customize Columns window, choose Memo.
  7. Click the Add button.
  8. Click OK.

After which, make sure to add a note on the payment transactions before exporting them. Please see below screenshots as an example.

 

payment memo.PNG

 

exported data.PNG  For more information about exporting transactions, check out the following articles:

That should provide information on how you can link payments to their invoices. Let me know if there's anything else you need from me by leaving a comment below. I'd be glad to answer. Have a nice day!

Need to get in touch?

Contact us