--- title: How to do an Excel Statement Match description: Support Site --- [Skip to content](https://pages.synchtank.com/support-site/how-to-do-an-excel-statement-match#main-content) English - United States Show submenu for translations [![Synchtank Logo](https://pages.synchtank.com/hs-fs/hubfs/social-suggested-images/www.synchtank.comsynchtank_logo-tm.png?width=250&height=51&name=www.synchtank.comsynchtank_logo-tm.png)](https://pages.synchtank.com/support-site?hsLang=en-us) Open main navigation Close main navigation - English - United States Show submenu for translations - [Submit a Ticket](https://pages.synchtank.com/support-site/create-a-ticket) [Submit a Ticket](https://pages.synchtank.com/support-site/create-a-ticket?hsLang=en-us) How can we help you? - There are no suggestions because the search field is empty. 1. [Support Site](https://pages.synchtank.com/support-site?hsLang=en-us) 2. [Royalty Platform (IRIS)](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us) 3. [Royalties](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us#royalties) February 17, 2026 # How to do an Excel Statement Match ### Search Excel statement match can be used to bulk match songs to IRIS songkeys outside of the system. 1. Load your statement via Electronic or Manual entry. ![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.34.22.png) 2. Once statement is loaded, open, right click and export to Excel making sure that Income statement Detail ID is present (if not, right click on any column header and select Column Chooser and drag and drop Income Statement Detail ID onto the header). ![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.34.40.png) 3. Open statement file in excel and add a column for the statement header ID. Enter and copy and paste it to all lines.![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.34.54.png) 4. If you have a table from which you will be matching, copy it to a separate worksheet on this file and in the IRIS Song Code column, use a VLOOKUP to match song code or song title to the IRIS songkey in your table. When complete, copy and paste value (to erase formula) and delete worksheet, then save. (Delete n/a’s where v lookup could not find a match and leave blank). 5. If no table, then just add the IRIS songkey into the IRIS Song Code column, then save (leave unknowns blank). ![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.35.14.png) 6. Back in IRIS, open Excel Match at the top of the Royalty Income Statement tab in the Royalty Income Processing area.![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.35.25.png) 7. Load your file and map Income Statement Header, Income Statement Detail ID, IRIS Songkey and click Upload & Match.![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.35.41.png) 8. You’ll be notified that the matches were made. 9. Open statement and filter by IRIS Song Code to find all NULL (no songkey listed) and research and match if possible or leave deferred for movement to suspense.![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.35.53.png) 10. Click Save.![](https://pages.synchtank.com/hubfs/Knowledge%20Base%20Import/Screenshot_2021-09-21_at_12.36.04.png)   - [Ticket Help](https://pages.synchtank.com/support-site/ticket-help?hsLang=en-us#main-content) - [Ticket Help](https://pages.synchtank.com/support-site/ticket-help?hsLang=en-us#ticket-help) - [Submit a Ticket](https://pages.synchtank.com/support-site/submit-a-ticket?hsLang=en-us) - [Customer Portal](https://pages.synchtank.com/support-site/customer-portal?hsLang=en-us) - [Asset Platform](https://pages.synchtank.com/support-site/asset-platform?hsLang=en-us#main-content) - [Synchtank Admin/ Back-End](https://pages.synchtank.com/support-site/asset-platform?hsLang=en-us#synchtank-admin-back-end) - [Front-End](https://pages.synchtank.com/support-site/asset-platform?hsLang=en-us#front-end) - [Premium Partner Services](https://pages.synchtank.com/support-site/asset-platform?hsLang=en-us#premium-partner-services) - [FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#main-content) - [Front-End FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#front-end-faqs) - [Dashboard FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#dashboard-faqs) - [Artist FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#artist-faqs) - [Masters FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#masters-faqs) - [Compositions FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#compositions-faqs) - [Albums FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#albums-faqs) - [Cue Sheets FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#cue-sheets-faqs) - [Productions FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#productions-faqs) - [Placements FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#placements-faqs) - [Playlists FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#playlists-faqs) - [Import Tools FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#import-tools-faqs) - [Artist Portal FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#artist-portal-faqs) - [Micro-Licensing FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#micro-licensing-faqs) - [Metadata FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#metadata-faqs) - [Website FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#website-faqs) - [Purchasing FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#purchasing-faqs) - [Reports FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#reports-faqs) - [Delivery FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#delivery-faqs) - [Contacts FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#contacts-faqs) - [SyncUp FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#syncup-faqs) - [Users FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#users-faqs) - [Website Settings FAQs](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#website-settings-faqs) - [Admin Settings FAQS](https://pages.synchtank.com/support-site/faqs?hsLang=en-us#admin-settings-faqs) - [Royalty Platform (IRIS)](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us#main-content) - [Setup](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us#setup) - [Royalties](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us#royalties) - [Copyright](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us#copyright) - [A&R/Creative Functions](https://pages.synchtank.com/support-site/royalty-platform-iris?hsLang=en-us#ar-creative-functions) - [Product Updates](https://pages.synchtank.com/support-site/product-updates?hsLang=en-us#main-content) - [Release Notes](https://pages.synchtank.com/support-site/product-updates?hsLang=en-us#release-notes) - [What's New in Synchtank](https://pages.synchtank.com/support-site/product-updates?hsLang=en-us#whats-new-in-synchtank) [![www.synchtank.comsynchtank\_logo-tm](https://pages.synchtank.com/hs-fs/hubfs/social-suggested-images/www.synchtank.comsynchtank_logo-tm.png?width=250&height=51&name=www.synchtank.comsynchtank_logo-tm.png "www.synchtank.comsynchtank_logo-tm")](https://www.synchtank.com/) [mailto:enquiries@synchtank.net](mailto:enquiries@synchtank.net) Copyright © 2026, Synchtank Ltd.