CONTACT USBack to MinistryPlatform Site
Your Knowledge Base is moving on 3/25/24! Our new Help Center provides all the articles you know and love (plus so much more) in a one-stop shop. Ask your SPoC for details!

Financial Edge

finance-officers
 

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. 

Contact Support if you would like to request Professional Service add this report and the related fields to your system.
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 Configuration Setting: "ShelbyGlobafileID" if needed.
  • Update the Configuration Setting: "DefaultAccountingProject" if needed.
  • 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.

See Also Financial Edge Deposits Export - Initial Setup

Processing Payments Greater than $0

Payments greater than $0 need to be reflected in your accounting system as deposits that match what will appear on your bank statement at the end of the month. The following steps presume you are processing only Payments that settled as a deposit together:

  1. Retrieve 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. Click Reports > Process Selected Payments to Financial Edge.
  5. Input a value for Merchant Batch consistent with your gateway report.
  6. Choose Bank Account.
  7. Choose 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 appear in the Not Processed view of the Payments page.

See Also: Exporting Deposits to Financial Edge