What would you like to know more about?

Show Page Sections

ACS Export

This section examines how to export deposits through ACS.

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

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

Initial Setup

After you add ACS to your system, a SPoC must complete some initial setup for it to work. If you add a new program, bank, or congregation in the future, you must repeat this process for new additions.
  1. In the navigation menu, click Lookup Values > Banks.
  2. Complete the account number field. You must have at least one bank set up. The account number must be formatted as 1=one (accounting company in ACS), a dash, and a five-digit account number (#-#####).
  3. Optional: Complete the ACS source field.
  4. In the navigation menu, click Church Structure > Programs.
  5. Complete the account number field for all programs. The account number must be formatted as 1=one (accounting company in ACS), a dash, and a five-digit account number (#-#####).
Once you complete these fields, you can test your setup as follows:
  • MinistryPlatform creates a CSV file that you can use as many times as you need to load in ACS if it doesn't work the first time. If you are familiar with ACS and what information the file needs, you can view the file to verify it before importing to ACS.
  • We do not recommend testing with a deposit that's already been exported and used in your legacy or current financial system.

Export Deposits to ACS

  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 - Export Preview ACS.
    1. Select the bank account.
    2. Click View Report.
    3. Review the report.
    4. If the report is correct, click the Prepare Export link in the report.
    5. Export the results to a CSV.
  7. Import into ACS.