home

MinistryPlatform

RealmRealm AccountingMinistryPlatformeGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite
RealmRealm AccountingMinistryPlatformeGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite

What would you like to know more about?

Show Contents

Show Page Sections

thumbnailMinistryPlatform

Processing Payments

Process Payments for Financial Edge

Payments are processed directly on the Payments page. To create a file that contains debits and credits for journal entry import into Financial Edge, a report can be added to your system on the Payments page.

Note: This report and a few custom fields must be installed. If you want this functionality added to your system, a SPoC can contact Support and request this as a Professional Services project.

Initial Setup

Complete the following one-time configuration for Programs, Bank accounts, or Journal Ref Prefixes. Repeat if new values are created in the future:

  • Add Banks to Lookup Values > Banks using GL account numbers.
  • Add Journal Ref Prefixes to Lookup Values Journal Ref Prefixes.
  • Populate the BB Account Number information on all Event records (new field).
  • Populate the BB account information on all Program records (new fields):
    • BB Account Number Project ID
    • BB Contra Income Account
    • BB Liability Account
    • BB Liability Account Project ID
  • Update the following configuration settings, if needed: ShelbyGlobafileID and SSRS, DefaultAccountingProject.
  • If you'd like to test your setup:
    • 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 look at the file to verify it before importing to Financial Edge.
    • We do not recommend testing with payments that have already been exported and used in your legacy or current financial system.

Also see Financial Edge Deposits Export - Initial Setup.

Process Payments Greater than Zero Dollars - Export to Shelby Report

Payments greater than zero dollars need to reflect in your accounting system as deposits that match what appears on your bank statement at the end of the month. The following steps assume you are processing only Payments that settled as a deposit together.
  1. Get the appropriate gateway report from your Authorize.net account reflecting the payments that settled in the deposit.
  2. Go to Products & Payments > Payments, and select one or more payments that are part of the same merchant batch.
  3. Change your selection to Current/Unsaved Selection.
  4. From the Reports menu, select Process Selected Payments to Financial Edge.
  5. Enter a value for Merchant Batch consistent with your gateway report.
  6. Select a Bank Account.
  7. Select the Journal Ref Prefix.
  8. Click View Report.
  9. Confirm that the total of the selected Payments matches what you expect from your gateway report.
  10. Click the Export link.
  11. Export the results to CSV.
  12. Import into Financial Edge.
  13. From your selection, click Assign and mark all Payments as Processed so that these Payments no longer display in the Not Processed view of the Payments page.
MinistryPlatform

Last updated: September 10, 2024