What would you like to know more about?

Show Page Sections

Format Your CSV File for Importing

You may work with a third party to collect donations. If the result of your process is a CSV file, you can import those donations into MinistryPlatform using the Batch Manager Tool! But first, make sure you formatted your CSV file correctly for a smooth and successful import.

Here's what you'll do:

  • Save the CSV file in your third-party solution, noting all transactions that need to be imported into MinistryPlatform.
  • Edit the CSV file to match the format that MinistryPlatform requires.
  • Import and finalize your batch using the Batch Manager Tool.
Important: With the Batch Manager Tool, you can import more than 1,000 records at a time, but the tool only shows 1,000 records at a time. Because the balance tabulates based on the displayed records, not the imported records, your calculations will be incorrect. Be sure to limit your imports to 1,000 records or fewer.

Edit Your CSV File

  1. Open the saved CSV file in your favorite CSV editor, such as Excel or Google Sheets.
  2. If your file includes a header row that describes the data in each column, remove it.
  3. Insert a row at the top, and enter the following:
    • In row 1 column A, enter "H".
    • In row 1 column B, enter "1656".
    • In row 1 column C, enter "2".
  4. Rearrange your data columns to match the following:
    • Column A should list the Payment Type.
    • Column B should list the Donor Number or Envelope Number.
    • Column C should list the Donation Amount.
    • Column D should list the date Donations were paid.
    • Column E should list the Account Number found in Program records.
  5. For all transaction rows, enter "C" in column A, and make sure it's capitalized. This stands for charge or credit card.
  6. In the last, below your final transaction row, enter "F" in column A. All columns after this should be empty.
  7. Ensure that there are no dollar signs on any amounts and that your dates are formatted as M/DD/YYYY.
    Your file should look similar to this:

    Example of a spreadsheet with Column A showing H, C, C, C, F in respective rows; Column B showing 1656, 904, 4285, and 3903; Column C showing 2, 50, 10, and 20; Column D showing nothing in the first row, 5/11, 5/18, and 5/18; and Column E showing nothing in the first row, 3, 1, and 3

  8. Save your CSV file.

Import and Finalize Your Batch

  1. In MinistryPlatform, click the bookmarks icon at the top, and select Batch Manager.
    The BMT displays in a new browser tab.
  2. Click Batch, and select Import.
  3. Drag and drop your formatted CSV file into the window.
    If your file is formatted correctly, the data from your CSV file displays.
  4. Select the check box for the batch you want to import.
  5. Confirm that the Default Campus (Congregation or Parish), Default Program, and Payment Type are correct.
  6. If your import file contains multiple Congregations or Parishes, select the option.
  7. Click Save Selected Batches.
    It may take a few moments to import the batch.
  8. When the import finishes, click Open.
  9. Confirm all the data from your file was imported.
  10. If needed:
    1. Correct any transactions that don't display in green.
    2. Add any additional transactions.
  11. Once all transactions display in green, you are ready to finalize the batch! Click Batch, and select Finalize.
  12. Click Finalize to confirm.