home

MinistryPlatform

RealmRealm AccountingMinistryPlatformGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite
RealmRealm AccountingMinistryPlatformGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite

What would you like to know more about?

Show Contents

Show Page Sections

thumbnailMinistryPlatform

Exporting Deposits

Financial Edge Export

This section examines how to export deposits through Financial Edge.

You can add a report and custom fields to your MinistryPlatform system so you can create a file that creates debits and credits for Financial Edge journal entries.

If you want this functionality added to your system, a SPoC can contact Support and request this as a Professional Services project.

Notes About this Export

  • Financial Edge Export will look for the Events > BB Account Number first. If there isn't one, it will look on the Programs page. This is true for deposits and payments.
  • You only need to add the general cash accounts into the Banks page. This includes any account that you make regular deposits to for contributions, event registrations, and so on.
  • The Programs page has places for four different account numbers depending on if it is for payments or deposits.
  • The Deposits page has an account number for the account summary report only. Not included on exports.
  • You can use the exception report to help map out where the account numbers should go in MinistryPlatform and which ones you need it to hit on the export.
  • On deposits export, the cash account from Bank > Account Number (Debit) will offset the Events > BB Account Number (Credit) or Programs > BB Account Number (Credit). On the Programs page, BB Contra Income Account (Debit) and BB Liability Account (Credit) will offset each other on the deposits export.

Additional Financial Edge Reports

A SPoC can contact Support to have Professional Services deploy additional Financial Edge reports.

Account Summary - Financial Edge Export
This report summarizes donations between two dates by Blackbaud/Financial Edge account number.
Account & Date Exceptions - Financial Edge
This report identified donations that might have issues because of their date, the deposit date or their posting accounts.

Initial Setup

After you add Financial Edge to your system, a SPoC must complete some initial setup for it to work. If you add a new program, bank account, or journal reference prefix in the future, you must repeat this process for the new additions.

Do not include any spaces (except bank names) when adding information to the fields below. Hyphens and periods are okay.

  1. In the navigation menu, click Lookup Values > Banks.
  2. Add bank names using the GL account numbers.
  3. In the navigation menu, click Lookup Values > Journal Ref Pre.
  4. Add journal reference prefixes.
  5. In the navigation menu, click Church Structure > Programs.
  6. Enter the BB account information on all Program records:
    • BB account number project ID
    • BB contra income account
    • BB liability account
    • BB liability account project ID
Once you enter information into these fields, you can test your setup as follows:
  • MinistryPlatform creates a CSV file that you can use as many times as necessary to load in Financial Edge if it doesn't work the first time. If you are familiar with Financial Edge and what information the file needs, you can view the file to verify it before importing to Financial Edge.
  • We do not recommend testing with a deposit that's already been exported and used in your legacy or current financial system.
  • Add bank account information for any account where you make regular deposits to in Lookup Values > Banks .
  • Add funds to your Programs page.
  • Add revenue accounts to the appropriate fields on either the Program, Event, or Product Option Price pages.

Export Deposits to Financial Edge

  1. In the navigation menu, click Contributions > Deposits.
  2. Make sure you have no records selected on the Deposits page.
  3. Change your view to Ready to Export.
  4. Select all the deposits in the view, and change your selection drop-down to Current/Unsaved Selection to confirm your selection.
  5. Optional: Run any preliminary reports for this selection of deposits.
  6. Click Reports > Selected Deposit - Financial Edge Export.
    1. Select the bank account number.
    2. Select the journal ref prefix.
    3. Click View Report.
    4. Review the report.
    5. If the report is correct, click the Ready to Export link in the report.
    6. Export the results to a CSV.
  7. Import into Financial Edge.
portal
MinistryPlatform

Last updated: February 21, 2025

Related Articles: