BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//UST Education - ECPv6.18.4//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-ORIGINAL-URL:https://usteducation.org
X-WR-CALDESC:Events for UST Education
REFRESH-INTERVAL;VALUE=DURATION:PT1H
X-Robots-Tag:noindex
X-PUBLISHED-TTL:PT1H
BEGIN:VTIMEZONE
TZID:America/New_York
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20250309T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20251102T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20260308T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20261101T060000
END:STANDARD
BEGIN:DAYLIGHT
TZOFFSETFROM:-0500
TZOFFSETTO:-0400
TZNAME:EDT
DTSTART:20270314T070000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0400
TZOFFSETTO:-0500
TZNAME:EST
DTSTART:20271107T060000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/New_York:20261209T110000
DTEND;TZID=America/New_York:20261209T120000
DTSTAMP:20261119T202724Z
CREATED:20261119T202724Z
LAST-MODIFIED:20261119T202724Z
UID:10000938-1796814000-1796817600@usteducation.org
SUMMARY:From AMS Export to Board Report: Using Copilot in Excel to Simplify Association Finance
DESCRIPTION:Course Description:  \nAssociations pull data from many places\, including the AMS\, payment processors\, and event platforms. Getting that information to line up with the general ledger so management and the board can use it can take hours of cleanup. In this session\, we’ll explore how Copilot in Excel can help clean up and reconcile detailed data exports\, allocate revenue by program or chapter\, and summarize the results for board and committee reporting. We’ll also look at how chart of accounts design can make that reporting easier from the start. You’ll leave with practical tips that can save you hours of that cleanup. \n  \nLearning Objectives: \nIdentify the common data and reporting challenges in moving from AMS and payment-system exports to financial reports. \nApply Copilot in Excel prompts to clean\, organize and summarize association revenue data. \nDescribe how chart of accounts and class or tracking design supports chapter\, program and board reporting. \n  \n 
URL:https://usteducation.org/event/from-ams-export-to-board-report-using-copilot-in-excel-to-simplify-association-finance-free-cpe-credit-free-cae-credit/
LOCATION:zoom.us/j/94488503964
CATEGORIES:Accounting,Association IT,ASSOCIATIONS & NONPROFITS,Data Management,Finance
ATTACH;FMTTYPE=image/png:https://usteducation.org/wp-content/uploads/2026/11/Christine26-2.png
ORGANIZER;CN="Christine Chacko%2C CPA":MAILTO:christine.chacko@yptc.com
END:VEVENT
END:VCALENDAR