Author: Benjamin Katz

  • Georgia CCDR Line-By-Line

    Applies To: Georgia – Candidate Committees, Political Action Committees (PACs), Party Committees

    NOTES:

    • GA 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 and/or Support/Oppose Memos as cash-impact transactions, and do not itemize the whole/parent transaction. 
    • GA efiling does not support the concept of negative transactions; please contact support if you need to report reversed transactions.

    SUMMARY REPORT

    RECEIPTS TOTALS
    Line 1 – These boxes depend on whether there are receipts on the report

    Line 2 – This will list starting Inkind or Monetary starting totals

    Line 3 – Itemized Receipts

       GROUP 1

    • Transaction Type(s): Monetary Contribution, Inkind Contribution
    • All contributions over $100 will be itemized

      GROUP 2

    • Transaction Type(s): Monetary Contribution with tag Common Source, Loan Received Balance Reduction
    • All of these specific transactions will be itemized

    Line 3a – Loans Received

    • Transaction Type(s): Loans Received
    • All loans received will be itemized

    Line 3b – Interest Earned

    • Transaction Type(s): Other Income
    • All other income transactions received will be itemized

    Line 3c – Investments

    • This line is unsupported at this time. Please contact support if required

    Line 3d – Cash Dividends and Interest Paid

    • This line is unsupported at this time. Please contact support if required

    Line 4 – Unitemized contributions

    • Transaction Type(s): Monetary Contribution, Inkind Contribution

    Line 5 – Total Receipts This Period

    • The sum of Lines 3 + 3a + 3b + 3c + 3d + 4

    Line 6 – Total Receipts To Date

    • The sum of Lines 2 + 5

    EXPENDITURES TOTALS
    Line 7 – These boxes depend on whether there are expenses on the report

    Line 8 – This will list starting Non-Monetary or Monetary starting totals

    Line 9 – Itemized Expenses

       GROUP 1

    • Transaction Type(s): Expense, Accrued Expense Payment
    • All contributions over $100 will be itemized

      GROUP 2

    • Transaction Type(s): Support/Oppose Memo, Refunded Contribution, Non-Monetary Expense, Refunded Expense, Loan Received Repayment
    • All Loan Received Balance Reduction transactions will be itemized

    Line 10 – Unitemized Expenditures

    • Transaction Type(s): Expense, Accrued Expense Payment

    Line 11 – Total Expenses This Period

    • The sum of Lines 9 + 10

    Line 12 – Total Expenses To Date

    • The sum of Lines 8 + 12

    INVESTMENTS
    Line 13 – Starting total of investments

    • This line is unsupported at this time. Please contact support if required

    Line 14 – Ending total of investments

    • This line is unsupported at this time. Please contact support if required


    OUTSTANDING INDEBTEDNESS

    Line 1 – Starting Outstanding Accrued Expenses & Loans Received per Election Cycle

    Line 2 – Total Loans Received in the period

    Line 3 – Total Accrued Expenses in the period

    Line 4 – Total Loans Received Repayments in the period

    Line 5 – Total Loans Received Balance Reductions in the period

    Line 6 – Total Accrued Expense Repayment in the period

    Line 7 – Ending Outstanding Accrued Expenses & Loans Received per Election Cycle

  • Contribution Summary API

    ISPolitical supports requests of summary contribution information via a rest API using basic access authentication.

    Your username will be a pipe delimited concatenation of the client account name & your integration login name. For example, the Civil War Online Donation System would use Washington|CWODS to submit data to the Washington account. Your same login can be used for any client accounts that have granted you access. Your password will be provided by ISPolitical staff.

    If you have not integrated with ISPolitical before, you will need to contact support@ispolitical.com to get an integration account setup. If you have integrated with ISPolitical before, contact support@ispolitical.com to request access to summary contribution information.

    A sample request submission follows. If you have questions, please contact ISPolitical staff.

    Submit to the API at https://app.ispolitical.com/api/ContributionReports

    Submit the following:


    FromDate: "2025-01-01"
    ,ToDate: "2025-12-31"
    ,IncludeMonetaryContributions: true
    ,IncludeInkindContributions: true
    ,SummarizeBy: "Day"
    }

    Each parameter is required.

    SummaryBy supports the following values: “Day”, “Week”, “Month”, “Year”, “All”

    Sample Response:

    {
      "success": true,
      "result": true,
      "responseText": "",
      "data": [
        {
          "PeriodStart": "2025-04-09T00:00:00",
          "PeriodEnd": "2025-04-09T00:00:00",
          "TotalContributions": 100
        },
        {
          "PeriodStart": "2025-05-06T00:00:00",
          "PeriodEnd": "2025-05-06T00:00:00",
          "TotalContributions": 500
        },
        {
          "PeriodStart": "2025-06-02T00:00:00",
          "PeriodEnd": "2025-06-03T00:00:00",
          "TotalContributions": 1400
        }
      ]
    }

  • Dropbox Best Practices

    Dropbox is extremely useful for storing documents all over ISP. However, to get the most out of it and to prevent any issues, we recommend adhering to the best practices listed below. 

    1. If you’re a firm manager, you can and should use a single Dropbox account for all your clients that you control. 

    2. Use the Dropbox desktop app to make it easier to access files through either Windows or ISP.

    3. If you’re using multiple Dropbox accounts, confirm that you’re linked to the right account before using Dropbox.

    4. If you have multiple Dropbox accounts, don’t stay logged into any account that’s not your main one.

  • Michigan Filing Best Practices

    Applies To: Michigan

    Can I file to MI directly from ISP?

    Sadly, you cannot. You must generate your report, then download a group of .csv files that are uploaded into the state’s system, which is commonly known as MiTN (Michigan Transparency Network).

    There is quite a bit of setup before the first import can be done on the new system. Please be sure this is all complete by following the steps laid out on the state’s site.

    NOTE: We have found it is best to use full screen in order to best navigate the MiTN.

    How are entity uploads handled?

    With Michigan e-filing, you’ll have to upload a list of entities separate from the list of transactions. You then upload the list of transactions, which will be linked on the back end through the Entity ID our system provides. 

    Michigan does not support uploading an entity more than once. Because of this, it is paramount that you mark reports as filed. This ensures that previously uploaded entities do not get uploaded again.

    Once you upload for a particular reporting period, you cannot upload for that period again. This means partial, early uploads are not possible.

    How are work addresses handled for unemployed individuals?

    Unlike the old system, Michigan no longer wants placeholder addresses for unemployed individuals. If you have existing placeholders in ISP that need to be removed, please email support@ispolitical.com with the details so we can take care of those for you.

    In addition, we will not pull an address marked as Work if the Individual’s occupation is one of the following:

    • Not Employed
    • N/A
    • Unemployed
    • Retired
    • Student
    • Self
    • Homemaker
    • Volunteer

    How do I associate a transaction with a Fundraiser?

    There are two ways to associate a Fundraiser with a transaction. Either one of these options must be done before generating a Compliance Report.

    First Option:

    1. Login to MiLogin and select the appropriate committee
    2. On the dashboard, select the Fundraisers option
    3. Click on Add Fundraiser, fill out the fields as appropriate, and click on Save
    4. Click on the newly added Fundraiser from the list, and make note of the Fundraising Event Sequence Number. It will likely be two numbers, a dash, and six more numbers (example: 00-123456)
    5. In ISP, navigate to Tools > Events (If you don’t have events in your database, please see this Events page for additional information.)
    6. Click on +Add Event at the bottom of the page. Fill out the appropriate information, including the entering the Fundraising Event Sequence Number into field Agency Assigned Identifier. Click on Add Event.
    7. You will now see the event drop down on transactions. Select the event if the transaction is associated with a fundraiser, or leave blank.

    Second Option (basically the reverse!):

    1. In ISP, navigate to Tools > Events (If you don’t have events in your database, please see this Events page for additional information.)
    2. Click on +Add Event at the bottom of the page. Fill out the appropriate information. Click on Add Event.
    3. You will now see the event drop down on transactions. Select the event if the transaction is associated with a fundraiser, or leave blank.
    4. When you are preparing to file your report, login to MiLogin and select the appropriate committee
    5. On the dashboard, select the Fundraisers option
    6. Click on Add Fundraiser, fill out the fields as appropriate, and click on Save
    7. Click on the newly added Fundraiser from the list, and make note of the Fundraising Event Sequence Number. It will likely be two numbers, a dash, and six more numbers (example: 00-123456)
    8. Back in ISP, navigate to Tools > Events once again
    9. Click on the corresponding event, then click on the small green triangle to the upper right of the event name, and add the Fundraising Event Sequence Number into field Agency Assigned Identifier. Click on Update Event.

    These steps must be taken before your report is generated for filing.

    MiTN Status Page for Outstanding/Resolved Bugs

    https://www.michigan.gov/sos/elections/disclosure/mitn-information

  • How Do I Get My Data From QuickBooks Into ISP?

    QuickBooks is not designed for campaign finance. If you used another political finance software along with QuickBooks, we would rather import the data from the competing software. If you only used QuickBooks, take the following steps to get your data to us for import.

    When you migrate to ISP from QuickBooks, it’s important that you send us the correct data for import. In order to import your data, we need two things:

    1. General Ledger – include as many columns as possible and export the entire time period. The more data, the better.
    2. Chart of Accounts – this includes Financial Account and Budget Category info.

    While the two items above will likely be good enough for an import, contribution data may need to be sent separately. Unfortunately, Quickbooks normally only has deposit batch information and not individual contributions. If you used a credit card processor to receive donations, please export your data from there and send to us.

    Once you have everything exported and ready for import, and assuming you qualify for support coverage, send it to us at support@ispolitical.com.

  • Reporting an Accrued Expense With A Support/Oppose Memo

    Applies To: Federal Election Commission

    There are a few things to consider when it comes to Accrued Expenses with Support/Oppose Memos:

    1. Who the Support/Oppose Memo is for – this will dictate what line the transactions will appear on: Federal Candidate/Committee on Line 23, Independent Expenditure (IE) on Line 24 / Schedule E, Non-Federal and/or Carey Candidate/Committee on Line 29, 100% FEA on Line 30
    2. If there is an associated payment in the period or not

    If there is no associated payment:

    • The total amount of the (parent) Accrued Expense will appear on Schedule D
    • A non-cash impact transaction with the Candidate/Committee information for Non-Independent Expenditures will appear on the corresponding line (Line 23, 29 or 30) for each Support/Oppose Memo with memo text that says “Contribution Made Details of an Unpaid Debt – See Sch. D for further information”
    • A non-cash impact transaction with the Candidate/Committee information for Independent Expenditures will appear on Line 24/Schedule E with memo text that says “Details of an Unpaid Debt-See Sch D for additional information”

    If there is an associated payment:

    • The payment amount and any outstanding amount will be reflected on Schedule D
    • The actual Accrued Expense Payment amount will pull to the appropriate line (Line 23, 24, 29 or 30 as appropriate)
    • A corresponding non-cash impact transaction with the Candidate/Committee information in the full amount of the Support/Oppose Memo will also pull to the appropriate line with memo text that says “Additional Contribution Made information related to Debt Payment in the period” (or “Additional Independent Expenditure Made information related to Debt Payment in the period” for Line 24 / IEs)
  • Your First Bank Reconciliation in ISP

    Using the Auto-Reconcile Historic Transactions feature

    If you just came over to ISP from a different system, you might be concerned about your first bank reconciliation in ISP. It might not be practical to go back several years and reconcile your data in ISP month by month. 

    If you have never done a reconciliation before and you have over 200 unreconciled transactions, you will see a button called Auto-Reconcile Historic Transactions at the bottom of the page. Please note that this button will only show if both criteria are met. 

    The Auto-Reconcile Historic Transactions button assumes that your data is correct up to the date you specified. For your first reconciliation to work smoothly, go back to the bank statement where all transactions are deposited. In other words, go back to the bank statement where you don’t have any outstanding checks. Going back three months should work most of the time. If you can auto-reconcile through that date, then you should only have a couple of months to manually reconcile. 

    What if everything appears to have cleared, but my bank statement doesn’t match the Register in ISP?

    In this case, add a bookkeeping transaction. Finding the source of the discrepancy would be ideal, but if that’s not practical, add a bookkeeping transaction.

    What if I have an uncashed check or two?

    Temporarily change the date of the uncashed check to after the date of your reconciliation. Then use the Auto-Reconcile button, then change the date back to the correct date. The point here is to remove it from the Auto-Reconcile window, reconcile, then change the date back.

  • How Do I Import Refunds in Bulk?

    If you need to do a mass refund, potentially because you or your client decided not to run, you can use the Bulk Refunds Quick Import format to import refunds into ISP.

    1. Under the Reports menu, select Financial.
    2. In the Report drop-down menu, select the Transactions report.
    3. Put Monetary Contribution in the Transaction Type box.
    4. Add Columns for Transaction ID, Amount, and Date.
    5. Hit Generate at the bottom and export to Excel.
    6. Do the appropriate math to determine how much to refund each person.
    7. Install the Bulk Refunds format. On the Quick Imports page, underneath the Tools menu, click Add New Import Format in the bottom left. Locate the format titled Bulk Refunds and click on it.
    8. Using this format, import the Excel file you created. The only columns that matter here are Transaction ID, Amount, and Date. Any other columns will be ignored.
    9. After the refunds are imported, navigate to Print Checks under the Accounting menu and print your checks.
  • How Do I Use the TAX1099 Integration?

    Applies To: Internal Revenue Service

    The Tax1099 integration isn’t an integration in our traditional sense, because you don’t install it on the Integrations > Add/Remove page.

    This integration works in conjunction with the IRS FORM 1099-MISC/NEC report on the Reports > Compliance Tools page. After you generate the report, click the white print/export button at the bottom. In the menu that pops up, you’ll see an option for a Tax1099.com Export.

    After downloading the 1099 export from ISP, navigate to your Tax1099 account and upload the file there. From there, you can send them to your recipients and the IRS.

  • How to Import Into NJ Elec System

    Applies To: New Jersey – Candidate Committees

    Filing with New Jersey is done via several imports. Here’s some basic steps to get your started.

    1. Login to ELEC

    2. Select the Report Period
    3. Go to Quick Links > Contribution Data Upload Manager
      • If there are Monetary Contribution transactions to be imported, select Monetary on the Upload Item Type drop down
      • Click on Select New Contribution CSV File button
      • Find and select the csv file downloaded from ISP that starts with MonetaryContrib
      • Review the imported data
      • Click on Commit Batch if all the data looks correct
      • If there are Inkind Contribution transactions to be imported, select In-Kind on the Upload Item Type
      • Click on Select New Contribution CSV File button
      • Find and select the csv file downloaded from ISP that starts with In-Kind
      • Review the imported data
      • Click on Commit Batch if all the data looks correct
    4. Go to Quick Links > Expense Data Upload Manager
      • If there are Expense transactions to be imported, select Expenses, Other-Exp, Cont-Made-to-Others, or Exp-Made-on-Behalf on the Upload Item Type drop down. For Expense SubPayees, see below
      • Click on Select New Expense CSV File button
      • Find and select the csv file downloaded from ISP that starts with Expense, OtherExp, ContMadeToOthers or ExpMadeOnBehalf as matches the Upload Item Type drop down
      • Review the imported data
      • Click on Commit Batch if all the data looks correct
      • If there are splits of Expenses, Other-Exp or Exp-Made-on-Behalf, first ensure all other expense CSVs are uploaded first
      • Select Expense SubPayees on the Upload Item Type drop down
      • On the Existing Expense Items List, find and click Select next to the whole (parent) transaction
      • Find and select the csv file downloaded from ISP that starts with SubPayees and has the whole (parent) transaction name, date, and amount
      • Click on Commit Batch if all the data looks correct
    5. The transactions on the following schedules need to be hand-entered:
      • Schedule 3 (Dividends/Interest) – hand-entered under Contributions
      • Schedule 4 (Refunded Disbursements / Reimbursements to Committee) – hand-entered under Expenses
      • Schedule 5 (Loans Received) – hand-entered under Contributions
      • Schedule 6 (Refunded Contributions) – hand-entered under Contributions
      • Splits of Schedule 9 (Other Disbursements) – hand-entered per corresponding Expense
      • Splits of Schedule 11 (Expenses Made on Behalf) – hand-entered per corresponding Expense
      • Payments of Standard Accrued Expenses, Other Disbursement Accrued
        Expenses, and Accrued Expenses Made on Behalf from prior periods –
        hand-entered per corresponding transaction
      • Payments of Loans Received – hand-entered per corresponding Loan Received transaction
    6. Review and File
      • After you’ve imported and/or hand-entered all of your transactions, in ELEC go to e-File > e-File Report
      • At the bottom of the page, click on View Report to preview your report
      • If you approve of the report, click on Certify to certify your report
      • Click on File with ELEC to file your report