Author: Benjamin Katz

  • Utah Contributions and Expenditures Report Line by Line

    Applies To: Utah

    Utah Contributions and Expenditures Report

    IMPORTANT INFORMATION:

    • When adding individual transactions, expenses please ensure a Reporting Code is selected (this will pull as Purpose on the PDF/efile). In addition, please provide a general description in the Note for Compliance field.
    • Inkind Contributions require a general description in the Note for Compliance field. In addition, transactions that are PSA require a general description in the Note for Compliance field.
    • For contributions, the complete mailing address (Address, City, State, and ZIP) of the contributor is required.
    • Transaction-level amendments are not currently supported.
    •  On the PDF, the “Balance at the Beginning of Reporting Period” (Line 1) and “Ending Balance” (Line 5) are cash balance. These may not agree with summaries pulled from the official Utah Lt. Governor’s website which reflects working capital. These totals are only found on the PDF, and will not be impact the file.

    Utah efiling does not support the concept of splits or memos. Typically states want to see where the money originated/ended up, so we itemize splits as cash-impact transactions, and do not itemize the whole/parent transaction. 

    The report parameter fields are as follows: 

    Date Range: Please ensure that your date range lines up with the official Utah financial disclosure dates for the report you are generating.

    Current Election: Please select the current election.

    Report Period
    :  The available report periods will appear in the dropdown.

    All Caps: This will generate your entire report in all caps.

    We recommend, upon completion of generating your report, that you save it as a PDF for your records or to compare to other reports. This must be done at the time of generation, or you will not be able to save it as a PDF without regenerating it. You can also download the e-filing for your records as well.

    Utah Contributions and Expenditures Report 

    Below is a breakdown of each Receipt and Disbursement schedule based on the order found on the Utah Contributions and Expenditures Report

    Itemized Contributions Received

    Overall notes:

    – To check the “P” (Public Service Assistance) box on the PDF, ensure the “Is a PSA?” box is checked on the monetary contribution. (NOTE TO MASON: Make sure you use the same language as the label on the checkbox, and update the transaction types if more than one transaction type (Other Income, Refunded Contribution, etc) has that checkbox.)

    – The “I” (In-Kind) box on the PDF will automatically check if the transaction type is Inkind Contribution

    – The “L” (Loan) box on the PDF will automatically check if the transaction type is Loan Received

    GROUP 1:

    Transaction Types: Accrued Expense Balance Reduction, Accrued Income, Allocation Transfer, Asset Sale, Dues, Enforceable Pledge, Loan Received, Loan Received Balance Reduction, Monetary Contribution, Refunded Expense, Other Income, Inkind Contribution
    Reversed: excluded
    Splits: **see notes**

    Notes:
    – Splits are itemized as cash-impact transactions

    GROUP 2:

    Transaction Types: Accrued Expense, Accrued Income Balance Reduction, Asset Purchase, Expense, Loan Received Repayment, Refunded Contribution, Refunded Dues
    Reversed: required
    Splits: **see notes**

    Notes:
    – Splits are itemized as cash-impact transactions

    Itemized Expenses Made

    Overall notes:

    – The “L” (Loan) box on the PDF will automatically check if the transaction type is Loan Received Repayment

    GROUP 1:

    Transaction Types: Accrued Expense, Accrued Income Balance Reduction, Asset Purchase, Expense, Loan Received Repayment, Refunded Contribution, Refunded Dues
    Reversed: excluded
    Splits: **see notes**

    Notes:
    – Splits are itemized as cash-impact transactions

    GROUP 2:

    Transaction Types: Accrued Expense Balance Reduction, Accrued Income, Allocation Transfer, Asset Sale, Dues, Enforceable Pledge, Loan Received, Loan Received Balance Reduction, Monetary Contribution, Refunded Expense, Other Income, Inkind Contribution, Refunded Dues
    Reversed: required
    Splits: **see notes**

    Notes:
    – Splits are itemized as cash-impact transactions

  • West Virginia Form F-7 Campaign Financial Statement Line by Line

    Applies To: West Virginia

    West Virginia Form F-7 Campaign Financial Statement

    All PACs and political party committees are required to file campaign finance reports in a timely manner with the office in which they filed their Statement of Organization. PACs and political party committees that file with the Secretary of State are required to use the online Campaign Finance Reporting System (CFRS).

    The report parameter fields are as follows:

    Date Range: (bolded, please) Please ensure that your date range lines up with either standard West Virginia reporting dates or dates that are specific to your report. i.e. First Quarter, Primary, General, etc.

    Current Election: Please select the current election.

    Amended: Check the box if this is an amended report.

    Amended Compliance Report: Selected the previously filed report. (This dropdown is only seen if the Amended box is checked.)

    Termination: Check the box if this is a final report.

    Report Period:  The available report periods will appear in the dropdown.

    All Caps: This will generate your entire report in all caps.

    Sort Order: This will generate your report in the sort order of your choice.

    We recommend upon completion of generating your report, that you save it as a PDF for your records or to compare to other reports. This must be done at the time of generation, or you will not be able to save it as a PDF without generating it. You can also download the e-filing for your records as well.

    NOTES
    The West Virginia Excel efile is more of a bulk import, and does not directly match the paper report:

    • There is no way to designate a transaction as being associated with a fundraiser event on the efile
    • Receipt Of a Transfer Of Excess Funds & Disbursement Of Excess Funds is not supported. Please contact support if you need to file either of these schedules.
    • Aggregation for itemization is just in the report period – meaning, transactions associated with the entity included on prior reports do not impact itemization for the current report.
    • West Virginia efiling does not support the concept of splits or memos. Typically states want to see where the money originated/ended up, so we itemize splits as cash-impact transactions, and do not itemize the whole/parent transaction. This also applies to Support/Oppose Memos.
    • Not all transactions can be imported – there will be an indication below if the transactions on the schedule need to be hand-entered directly into West Virginia’s system. This includes (but not limited to): Loans Received & associated transactions, Loans Made & associated transactions. (Loans Received & related transactions used to be able to be imported, but can no longer be with the Excel import.

    The West Virginia Excel import has the option of choosing from a dedicated list of occupations. These can be found as a soft drop-down on individual records, and can be used if the client chooses, or they can supply their own occupation.

    Form F-7 Campaign Financial Statement

    Below is a breakdown of each schedule based on the order found on the Form F-7 Campaign Financial Statement.

    Contributions of $250 or Less
    Transaction Types: Monetary Contribution
    Entity Types: n/a
    Relationship Type: n/a
    Transaction Tags: n/a
    Reporting Codes: n/a
    Financial Account: n/a
    Allocation Type: n/a
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – Transactions will be itemized on this schedule if the entity’s per-report aggregate is $250 or less at the end of the report period
    – Transactions associated with events will be itemized on “Contributions of $250 or Less Associated with Fundraisers” (see below)

    Contributions of More Than $250
    Transaction Types: Monetary Contribution
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – Transactions will be itemized on this schedule if the entity’s per-report aggregate is greater than $250 at the end of the report period
    – Transactions associated with events will be itemized on “Contributions of More Than $250 Associated with Fundraisers” (see below)

    Contributions of $250 or Less Associated with Fundraisers
    Transaction Types: Monetary Contribution
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – Transactions will be itemized on this schedule if the entity’s per-report aggregate is $250 or less at the end of the report period
    – Transactions must be associated with an Event

    Contributions of More Than $250 Associated with Fundraisers
    Transaction Types: Monetary Contribution
    Entity Types: n/a
    Relationship Type: n/a
    Transaction Tags: n/a
    Reporting Codes: n/a
    Financial Account: n/a
    Allocation Type: n/a
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – Transactions will be itemized on this schedule if the entity’s per-report aggregate is greater than $250 at the end of the report period
    – Transactions must be associated with an Event

    Other Income: Interest, Refunds, Miscellaneous Receipts

    GROUP 1:
    Transaction Types: Other Income, Allocation Transfer, Refunded Expense
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – All transactions are itemized on this schedule regardless of amount

    GROUP 2:
    Transaction Types: Expense
    Reversed: Required
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – All transactions are itemized on this schedule regardless of amount

    Line/Schedule: Inkind Contributions
    Transaction Types: Inkind Contribution
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – All transactions are itemized on this schedule regardless of amount

    Itemized Expenditures

    GROUP 1:
    Transaction Types: Expense, Allocation Transfer, Support/Oppose Memo, Refunded Contribution, Accrued Expense Payment
    Reversed: excluded
    Splits: included

    Notes:
    – All transactions are itemized on this schedule regardless of amount

    GROUP 2:
    Transaction Types: Monetary Contribution
    Reversed: required
    Splits: excluded

    Notes:
    – All transactions are itemized on this schedule regardless of amount

    Unpaid Bills
    Transaction Types: Accrued Expense
    Reversed: excluded
    Splits: included

    Notes:
    – Splits are itemized as cash-impact transactions
    – All transactions are itemized on this schedule regardless of amount

  • How Do I Add Candidate and Committee Records Directly From the DE DOE Site?

    Applies To: Delaware

    In ISP you can add Committee and Candidate records to your database directly from the DE DOE site when using the Search option at the top of the screen. The imported information will include critical data, such as address, ID number, and other financial information.

    First, if you haven’t yet, enable the DE DOE Search feature by navigating to the System tab and then to Account Management. On the resulting screen, locate the Account Preferences section and toggle on the option to include the data in searches.

    After this feature has been enabled, when searching for committee records not already in your database, you’ll see the name you were searching for and a message allowing you to import from DE DOE data.

    Clicking this will automatically add the record to your database and any pertinent information required for filing and standard information purposes.

    On the Organization search page under the Add/Search tab, you’ll also see an option to Exclude matches from DE DOE data. This will help you limit the results on your screen.

  • How Do I Add Candidate and Committee Records Directly From the WY SOS Site?

    Applies To: Wyoming

    In ISP you can add Committee and Candidate records to your database directly from the WY SOS site when using the Search option at the top of the screen. The imported information will include critical data, such as address, ID number, and other financial information.

    First, if you haven’t yet, enable the WY SOS Search feature by navigating to the System tab and then to Account Management. On the resulting screen, locate the Account Preferences section and toggle on the option to include the data in searches.

    After this feature has been enabled, when searching for committee records not already in your database, you’ll see the name you were searching for and a message allowing you to import from WY SOS data.

    Clicking this will automatically add the record to your database and any pertinent information required for filing and standard information purposes.

    On the Organization search page under the Add/Search tab, you’ll also see an option to Exclude matches from WY SOS data. This will help you limit the results on your screen.

  • How Do I Add Candidate and Committee Records Directly From the TX TEC Site?

    Applies To: Texas

    In ISP you can add Committee and Candidate records to your database directly from the TX TEC site when using the Search option at the top of the screen. The imported information will include critical data, such as address, ID number, and other financial information.

    First, if you haven’t yet, enable the TX TEC Search feature by navigating to the System tab and then to Account Management. On the resulting screen, locate the Account Preferences section and toggle on the option to include the data in searches.

    After this feature has been enabled, when searching for committee records not already in your database, you’ll see the name you were searching for and a message allowing you to import from TX TEC data.

    Clicking this will automatically add the record to your database and any pertinent information required for filing and standard information purposes.

    On the Organization search page under the Add/Search tab, you’ll also see an option to Exclude matches from TX TEC data. This will help you limit the results on your screen.

  • How Do I Add Candidate and Committee Records Directly From the FL DOS Site?

    Applies To: Florida

    In ISP you can add Committee and Candidate records to your database directly from the FL DOS site when using the Search option at the top of the screen. The imported information will include critical data, such as address, ID number, and other financial information.

    First, if you haven’t yet, enable the FL DOS Search feature by navigating to the System tab and then to Account Management. On the resulting screen, locate the Account Preferences section and toggle on the option to include the data in searches.

    After this feature has been enabled, when searching for committee records not already in your database, you’ll see the name you were searching for and a message allowing you to import from FL DOS data.

    Clicking this will automatically add the record to your database and any pertinent information required for filing and standard information purposes.

    On the Organization search page under the Add/Search tab, you’ll also see an option to Exclude matches from FL DOS data. This will help you limit the results on your screen.

  • Why Don’t I See a Specific Office Sought for Michigan?

    Applies To: Michigan

    All of the MI Office Sought names are either under jurisdiction “State” or “Other Local”. This is because MI does limits by population size (rather than city/county/etc), so we put some in Other Local.

    Here are all of the existing offices under Other Local:

    Auditor (pop. 250,000+)
    Auditor (pop. 85,001-250,000)
    Auditor (pop. 85,000 or less)
    City Clerk (pop. 250,000+)
    City Clerk (pop. 85,001-250,000)
    City Clerk (pop. 85,000 or less)
    City Council (pop. 250,000+)
    City Council (pop. 85,001-250,000)
    City Council (pop. 85,000 or less)
    City Council at Large (pop. 250,000+)
    City Council at Large (pop. 85,001-250,000)
    City Council at Large (pop. 85,000 or less)
    City Supervisor (pop. 250,000+)
    City Supervisor (pop. 85,001-250,000)
    City Supervisor (pop. 85,000 or less)
    City Trustee (pop. 250,000+)
    City Trustee (pop. 85,001-250,000)
    City Trustee (pop. 85,000 or less)
    Circuit Courts (pop. 250,000+)
    Circuit Courts (pop. 85,001-250,000) 
    Circuit Courts (pop. 85,000 or less)
    Community College Board (pop. 250,000+)
    Community College Board (pop. 85,001-250,000)
    Community College Board (pop. 85,000 or less)
    Comptroller (pop. 250,000+)
    Comptroller (pop. 85,001-250,000)
    Comptroller (pop. 85,000 or less)
    County Clerk (pop. 250,000+)
    County Clerk (pop. 85,001-250,000) 
    County Clerk (pop. 85,000 or less)
    County Clerk/Register of Deeds (pop. 250,000+)
    County Clerk/Register of Deeds (pop. 85,001-250,000)
    County Clerk/Register of Deeds (pop. 85,000 or less)
    County Commissioners (pop. 250,000+) 
    County Commissioners (pop. 85,001-250,000)
    County Commissioners (pop. 85,000 or less)
    County Executive (pop. 250,000+)
    County Executive (pop. 85,001-250,000)
    County Executive (pop. 85,000 or less)
    Court of Appeals (pop. 250,000+) 
    Court of Appeals (pop. 85,001-250,000)
    Court of Appeals (pop. 85,000 or less) 
    District Council (pop. 250,000+)
    District Council (pop. 85,001-250,000)
    District Council (pop. 85,000 or less)
    District Courts (pop. 250,000+) 
    District Courts (pop. 85,001-250,000)
    District Courts (pop. 85,000 or less) 
    District School Board (pop. 250,000+)
    District School Board (pop. 85,001-250,000)
    District School Board (pop. 85,000 or less)
    Drain Commissioner (pop. 250,000+) 
    Drain Commissioner (pop. 85,001-250,000)
    Drain Commissioner (pop. 85,000 or less)
    Library Director (pop. 250,000+)
    Library Director (pop. 85,001-250,000)
    Library Director (pop. 85,000 or less)
    Library District Board (pop. 250,000+)
    Library District Board (pop. 85,001-250,000)
    Library District Board (pop. 85,000 or less)
    Mayor (pop. 250,000+)
    Mayor (pop. 85,001-250,000)
    Mayor (pop. 85,000 or less)
    Municipal Courts (pop. 250,000+)
    Municipal Courts (pop. 85,001-250,000)
    Municipal Courts (pop. 85,000 or less) 
    Probate Courts (pop. 250,000+)
    Probate Courts (pop. 85,001-250,000) 
    Probate Courts (pop. 85,000 or less) 
    Police Commission (pop. 250,000+)
    Police Commission (pop. 85,001-250,000)
    Police Commission (pop. 85,000 or less)
    Prosecuting Attorney (pop. 250,000+)
    Prosecuting Attorney (pop. 85,001-250,000)
    Prosecuting Attorney (pop. 85,000 or less)
    Public Works Commissioner (pop. 250,000+)
    Public Works Commissioner (pop. 85,001-250,000) 
    Public Works Commissioner (pop. 85,000 or less) 
    Register of Deeds (pop. 250,000+)
    Register of Deeds (pop. 85,001-250,000) 
    Register of Deeds (pop. 85,000 or less)
    Road Commissioners (pop. 250,000+)
    Road Commissioners (pop. 85,001-250,000)
    Road Commissioners (pop. 85,000 or less)
    Road Commissioners at Large (pop. 250,000+) 
    Road Commissioners at Large (pop. 85,001-250,000)
    Road Commissioners at Large (pop. 85,000 or less)
    School Board (pop. 250,000+)
    School Board (pop. 85,001-250,000)
    School Board (pop. 85,000 or less)
    Sheriff (pop. 250,000+)
    Sheriff (pop. 85,001-250,000) 
    Sheriff (pop. 85,000 or less) 
    Surveyor (pop. 250,000+) 
    Surveyor (pop. 85,001-250,000)
    Surveyor (pop. 85,000 or less) 
    Treasurer (pop. 250,000+)
    Treasurer (pop. 85,001-250,000) 
    Treasurer (pop. 85,000 or less)
  • When Are the Utah Filing Deadlines?

    Applies To: Utah

    Below are deadlines for Utah compliance report filing.

    The Filing Deadline information provided here is offered only as a reference aide. The provided deadline information may contain inaccuracies and may not include all special elections or deadlines. For agency specific details please visit the Utah Lt. Gov website.

    No deadlines are currently found.

    You’re able to add Filing Deadlines found in ISP to your own digital calendar with our Calendar Feed tool.

    To see more information about Utah compliance report filing with ISP, please visit our Utah Filing and FAQ Resources page.

  • How to View Change History for a Transaction

    Where to Find Transactions

    Transactions can be accessed from a few different places in ISP, including:

    From the Register

    1. Navigate to Accounting > Register
    2. Locate and open the transaction you want to review

    From an Entity’s/Organization’s Record

    1.  Use the magnifying glass search to search for the entity’s/organization’s record
    2. Select the option
    3. Scroll to the Transactions section and select the transaction you want to review.

    How to View the Change History

    On any transaction in ISP, you can view a complete log of edits, splits, reversals, and other modifications.

    1. Find the specific transaction
    2. Click the hot dog menu ( three vertical dots ) to the right of the transaction
    3. Select See Change History
    4. A log will appear showing all recorded changes made to that transaction.

    What You’ll See in Change History

    • Added or deleted splits
    • Updates to memos
    • Edits to amounts or fields
    • Undo actions ( such as reversing split )
    • Timestamps and user information for each change

    This feature helps you verify edits or troubleshoot unexpected changes by showing a detailed record of the transaction’s activity over time.

  • Iowa Dr-2 Line-By-Line

    Applies To: Iowa

    Iowa DR-2 Disclosure Summary Report

    Every committee is required to periodically report its financial activity to the Ethics Board using the Ethics Board’s web reporting system. Reports must be electronically filed by 4:30 p.m. on the due date

    The Iowa efiling is more of a bulk import; only transactions from Sch A & Sch B can be imported. The import format is .csv – we recommend only opening this file with a text editor like Notepad++ rather than Excel.

    The report parameter fields are as follows:

    Compliance Report Version: 

    There are two versions:

    • For Efiling – This should be used when generating the report to file. All transactions will be itemized on the import; additional itemization rules will be applied on the state’s site.
    • Paper Filing Only – This itemizes Schedule A transactions when the entity’s aggregate total is greater than $25 per year and Schedule B transactions when the entity’s aggregate total is greater than $5 per year. All Sch D & Sch E transactions are itemized regardless of amount or entity’s aggregate.

    Date Range: Please ensure that your date range lines up with either standard Iowa reporting dates or dates that are specific to your report. i.e. January 19 Report, Pre-Primary, etc.

    Current Election: Please select the current election.

    Amended: Check the box if this is an amended report.

    Amended Compliance Report: Selected the previously filed report. (This dropdown is only seen if the Amended box is checked.)

    Report Period: The available report periods will appear in the dropdown.

    All Caps: This will generate your entire report in all caps.

    We recommend upon completion of generating your report, that you save it as a PDF for your records or to compare to other reports. This must be done at the time of generation, or you will not be able to save it as a PDF without generating it. You can download the e-filing for your records, as well.

    NOTES:

    • Iowa efiling does not support the concept of splits or memos. Typically states want to see where the money originated/ended up, so we itemize splits as cash-impact transactions, and do not itemize the whole/parent transaction. This also applies to Support/Oppose Memos.
    • Not all transactions can be imported – there will be an indication below if the transactions on the schedule need to be hand-entered directly into Iowa’s system.
    • Loans Received & associated transactions, Loans Made & associated transactions are not supported on the report, and need to be hand-entered directly into Iowa’s system.

      DR-2 Disclosure Summary Report

      Below is a breakdown of each Receipt and Disbursement schedule based on the order found on the DR-2 Disclosure Summary Report

      Schedule A – Receipts

      Transaction Types: Monetary Contribution, Enforceable Pledge Payment, Other Income, Refunded Contribution
      Reversed: included
      Splits: **see notes**

      Notes:

      • Splits are itemized as cash-impact transactions
      • Reversals will be itemized as negative amounts
      • Refunded Contributions will be itemized as negative amounts
      • To check the Fund-raiser box, ensure the transaction is associated with an Event
      • To mark an Other Income as Interest, please use the Interest Transaction Tag 

      Schedule B – Expenditures

      Transaction Types: Expense, Refunded Expense, Support/Oppose Memo
      Reversed: included
      Splits: **see notes**

      Notes:


      • Splits & Support/Oppose Memos are itemized as cash-impact transactions
      • Reversals will be itemized as negative amounts
      • Refunded Expense will be itemized as negative amounts
      • If using the Mileage Reporting Code, please fill out the additional fields at the bottom of the transaction: Number of Miles and Mileage Reimbursement Rate

      Schedule D – Incurred Indebtedness

      Transaction Types: Accrued Expense
      Reversed: included
      Splits: excluded

      Notes:

      • This schedule will include any Accrued Expenses that are still
        outstanding at the end of the period, even if they were previously
        reported.
      • THESE TRANSACTIONS CANNOT BE IMPORTED – they must be hand-entered directly into Iowa’s system.

      Schedule E – In Kind Contributions

      Transaction Types: Inkind Contribution
      Reversed: included
      Splits: excluded

      Notes:

      • THESE TRANSACTIONS CANNOT BE IMPORTED – they must be hand-entered directly into Iowa’s system.
      • To check the Fund-raiser box, ensure the transaction is associated with an Event