{"id":291,"date":"2026-11-11T02:52:59","date_gmt":"2026-11-11T02:52:59","guid":{"rendered":"https:\/\/smartsource.com.sg\/blog\/filter-and-export-donations-to-excel\/"},"modified":"2026-11-11T03:11:08","modified_gmt":"2026-11-11T03:11:08","slug":"filter-and-export-donations-to-excel","status":"publish","type":"post","link":"https:\/\/smartsource.com.sg\/blog\/filter-and-export-donations-to-excel\/","title":{"rendered":"How to filter a Smart Source DMS list and export it to Excel"},"content":{"rendered":"<p>Use the <strong>Donations<\/strong> list in Power Apps to select the records you need before exporting them to Excel.<\/p>\n<h2>Choose the records<\/h2>\n<ol>\n<li>Open <strong>Donations<\/strong>.<\/li>\n<li>Apply filters for the records you need. For example, use <strong>Donation Date<\/strong> set to <strong>This year<\/strong> and <strong>Donation Status<\/strong> set to <strong>Payment Received<\/strong> to review received payments in the current year.<\/li>\n<li>Review the filtered list. For donations eligible for IRAS submission, also set <strong>Tax Deduction Required<\/strong> to <strong>Yes<\/strong>.<\/li>\n<\/ol>\n<h2>Export the list<\/h2>\n<p>Select <strong>Export to Excel<\/strong> to download the filtered list. Open the workbook and check that the exported records match the selection you intended.<\/p>\n<p><a href=\"https:\/\/smartsource.com.sg\/blog\/check-dms-iras-report-and-receipt\/\">Review the IRAS submission columns and filters<\/a>.<\/p>\n<p><a href=\"https:\/\/support.smartsource.com.sg\/\">Open a Ticket with Smart Source Support<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Use the Donations list in Power Apps to select the records you need before exporting them to Excel.Choose the recordsOpen Donations.Apply filters for the records you need. For example, use&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[202,13],"tags":[],"class_list":["post-291","post","type-post","status-publish","format-standard","hentry","category-dms","category-howtos"],"_links":{"self":[{"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/posts\/291","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/comments?post=291"}],"version-history":[{"count":1,"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/posts\/291\/revisions"}],"predecessor-version":[{"id":297,"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/posts\/291\/revisions\/297"}],"wp:attachment":[{"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/media?parent=291"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/categories?post=291"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/smartsource.com.sg\/blog\/wp-json\/wp\/v2\/tags?post=291"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}