# Matching invoices to payments from quickbooks for an automated statement (they share a linked id)

**URL:** https://community.make.com/t/matching-invoices-to-payments-from-quickbooks-for-an-automated-statement-they-share-a-linked-id/87999
**Category:** Questions
**Tags:** connections, arrays, functions, mapping, filters
**Created:** [July 24, 2025, 3:07pm UTC](https://community.make.com/t/matching-invoices-to-payments-from-quickbooks-for-an-automated-statement-they-share-a-linked-id/87999 "2025-07-24T15:07:00Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![Claire\_Abram](https://avatars.discourse-cdn.com/v4/letter/c/ecae2f/32.png) [@Claire\_Abram](https://community.make.com/u/Claire_Abram)
#### Post date: [July 24, 2025, 3:07pm UTC](https://community.make.com/t/matching-invoices-to-payments-from-quickbooks-for-an-automated-statement-they-share-a-linked-id/87999/1 "2025-07-24T15:07:00Z")

</div>

I have a list of invoices from a customer which I want to put on a customer statement I also have seperate payment data that links to the ‘paid invoices’ with the details of the corresponding payment. im looking to match these to datasets so they correspond in a table on a google sheet however any method I try doesn’t seem to work so unsure where to go next. cant seem to filter/iterate through them to match which seems like it should be possible with a txn id that matches.

Thanks for any help.

 ![Screenshot 2025-07-24 at 16.00.02](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/d/4/d4a804e071635ce68c36ffa026d2c3a4b5979541.png)

 ![Screenshot 2025-07-24 at 16.00.13](https://europe1.discourse-cdn.com/flex013/uploads/make/original/3X/8/2/82291304861ec7610573836992bce5126d50339b.png)

---

<div class="post-metadata">

### Author: ![Make\_Bot](https://dub1.discourse-cdn.com/flex013/user_avatar/community.make.com/make_bot/32/14661_2.png) [@Make\_Bot](https://community.make.com/u/Make_Bot)
#### Post date: [October 22, 2025, 3:12pm UTC](https://community.make.com/t/matching-invoices-to-payments-from-quickbooks-for-an-automated-statement-they-share-a-linked-id/87999/2 "2025-10-22T15:12:06Z")

</div>