Editing Real Time Disclosure (section)

= Introduction =

The process is substantially automated with an RTD Donations Report in CRM that extracts all donation records for the year (or campaign period) and an [[Media:RTD Template.xlsx|RTD Template workbook]] that takes this data and accumulates the donations by donor. Elections Ontario issues specification for the format of the file required to be submitted. The format was modified in 2017 and 2018, which required revisions to both the CRM extract procedure and the RTD Template spreadsheet.

See [[Media:RTD - Reporting Technical Specifications.pdf|RTD - Reporting Technical Specifications]] for layout. Note - It must be submitted in pipe (|) delimited text (*.txt) or comma separated values (*.csv) format.

'''Note: only Monetary contributions to the Party and Leadership Candidates are reported in RTD files.''' Do not include "In Kind" (Goods and Services) donations, or donations to Constituency Associations. (Need to confirm donations to Leadership Contestants are rerported in the same or separate files.)<sup>.</sup>  

The following instructions assume a working knowledge of Microsoft Excel or compatible spreadsheet application.