What would you like to know more about?

Show Page Sections

Process Payments for Shelby v5

Learn more about processing payments for Shelby v5, including initial setup, processing payments greater than zero dollars, and answers to frequently asked questions.

Note: As of 2017, this report has been replaced with the Payment Export Tool, a Ready-Made Solution.
Payments are processed directly on the Payments page. There are two options for Shelby customers:
  1. If your server hosts both Shelby v5 Financials and MinistryPlatform in a single instance. You can send your payment information directly to Shelby from MinistryPlatform using the Process the Selected Payments to Shelby report. This report creates a Shelby Check Express entry.
  2. If you have a shared server, or you run Shelby and MinistryPlatform on separate server instances:
    • If you requested it before 2017, you may have a report that will export your Shelby financial information to be imported into Shelby v5 Financials.
    • You can request the Payment Export Tool be installed on your system. See the Exports section of this Ready-Made Solutions article for details.

Initial Setup

Complete the following to set up your system to process payments to Shelby:

  • Contact Support to let them know you want the report (for single server instance) or the tool (for separate server instances) added to your system.
  • Update the following configuration settings, if needed: ShelbyGlobafileID and SSRS, DefaultAccountingProject.
  • Ensure that all Program records have Shelby fund, department, and account numbers in the Shelby Fund, Department, and Account fields. This is very important.
  • Ensure that all Events records have Shelby project numbers in the Project Code field, if needed. Otherwise, this field should be zero or blank.

Process Payments Greater than Zero Dollars - Export to Shelby Report

Payments greater than zero dollars must reflect in your accounting system as deposits that match what displays on your bank statement at the end of the month. The following steps assume you are only processing 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. In the navigation menu, click Products & Payments > Payments.
  3. Select one or more payments that are part of the same merchant batch.
  4. Change your selection to Current/Unsaved Selection.
  5. Click Reports > Process Selected Payments to Financial Edge.
  6. Enter a value for merchant batch consistent with your gateway report.
  7. Select a bank account.
  8. Select the journal reference prefix.
  9. Click View Report.
  10. Confirm that the total of the selected payments matches what you expect from your gateway report.
  11. Click the Export link.
  12. Export the results to CSV.
  13. Import them into Financial Edge.
  14. From your selection, click Assign and mark all payments as processed so that these payments no longer display in the Not Processed view on the Payments page.

Shelby Processing Payments FAQ

Q1: Should we create a separate deferred program for event registrations?

It's up to you! It just depends on your preference for how the registration payments come into Shelby General Ledger and how it affects any MinistryPlatform program-based reporting you do. If you choose to, account information is set in the program. If you use projects in Shelby General Ledger, that can be set in the Project Code field on the event.

Q2: I'm running the Process Selected Payments to Shelby report, and the report says "an error has occurred during report processing" or "one or more items have been processed or Shelby account info is missing." How do I remedy the missing information?

The program related to the event is likely missing some or all of the Shelby-related information. Complete the necessary Shelby fund, department, and account information and re-run the report.

Or, along the same lines, the program's fund, department and/or account number or the event's project code could be improperly formatted.

Q3: I'm running the Process Selected Payments to Shelby report. I've set Summary Only to Yes. But the check express entry has over 100 entries (one for each registration). Why is this?

The Summary Only field affects the report generated, not the check express entry.