How Do I Export Data Out of WinRed and Quick Import It Into ISP?

If you choose to import WinRed data manually via Quick Imports in ISP, it’s important to be sure you are capturing and exporting the right data in your WinRed account. 

In WinRed, there are three different data imports you can select from.

Export of Donations: This export does NOT contain conduit/batch information so while this may provide donation data, it’s not the best export option for importing into ISP.

Export of Payouts: This can provide good info but it will be multiple files, as you will have to download each Payout one at a time. Again, we don’t recommend this one.

Export of Transactions: This is a more robust export, as it provides data on contributions, refunds, and expenses. We recommend using this option to pull data from your WinRed account.

Once you navigate to your desired export option, click the filter icon and filter the data you want to include in your export. Ideally, it would be wise to capture all data. However, if you choose to not include report disputes or other items, you can do so.

After you’ve created the desired filter, click Apply Filter and the page will refresh. Next, click Download. In order to actually retrieve the file, in your WinRed account navigate to Utilities, then to Data Export. In the list of generated reports, you should see the one you just created at the top. Click the green Download Ready button to export the data for import into ISP.

What is the difference between the automatic integration and Quick Imports for my WinRed data?

Simply put, the Quick Import tool is often faster to work with when you have large amounts of data. However, the Integration tool allows for real-time information to come in rather than having to upload batches on a regular basis. We have a separate help file for installing the WinRed integration.

Quick Import Method

You can use Quick Imports to get your WinRed data in quickly. If you have not used it before, please contact Support and ask to install the import option in your database.

Once installed, go to the Quick Imports page under Tools, then select the WinRed option in the Format dropdown. On the right side of the screen, in the About section, it will explain which fields on your spreadsheet are required and which are optional. 

You’ll also see a checkbox for Import as Conduit – Conduit Check Splits. When this box is checked, it will create a single transaction from WinRed on the Record Deposit screen with the entities as Splits. Each individual contribution that makes up that Conduit Check will have their own dates matching the data file.

If you have Agency fees as well as WinRed credit card transaction fees, both are taken out of the check you receive from WinRed. As a result, you will need to have two expenses added to the Batch Deposit. One for the processing fee and one for the agency fee. Both can be created the same way via Add Deducted Fees on the deposit screen.