Power Church

How to export data from Power Church

Members

  1. Within Power Church, navigate to Membership menu at the top, highlight Personal Profiles, then Other Output and select Export Data.
  2. Selection Criteria:
    • Write down all the Date Field Names (these will be the names for date1 - date 12, or take a screenshot and send it.). The list is located in the lower left corner.
    • Click OK.
  3. Introduction:
    • Click OK.
  4. What fields would you like to export:
    • Select the fields to import.
    • Click the >> button to select all fields.
    • Contributions are done by envelope number, so make sure you include it if importing contributions.
    • Click the Next button.
  5. Choose the type of export file format would you like to create:
    • Select Excel 5.
    • Click the Next button.
  6. Name the export file:
    • Click Location.
    • Browse and Name your file (Drive M: is your local C: drive).
    • Click the Next button.
  7. Finish:
    • Click the Finish button.

Contributions

  1. Within Power Church, navigate to the Contributions menu and select Reports - Contributions.
  2. Select the Posted Contributions report. 
  3. Click Send to Disk File.
  4. Click Run.
    • Select and set your dates.
    • Check Include Contribution Designations.
    • Check Include Contribution Memo.
    • Click the OK button.
  5. If you get a default printer error, select a different printer.  After you select it you will be given the file location dialog box.
  6. Save AsExcel Spreadsheet (include the file extension: .xls).
  7. If you have UnPosted Contributions repeat steps 2 through 6 with that report.