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

Exporting Deposits

Export Deposits to Intacct

Custom fields and reports can be added to your MinistryPlatform system to allow you to create a file that creates debits and credits for Intacct journal entries. If you want this functionality added to your system, a SPoC can contact Support and request this as a Professional Services project.

Reports for Intacct

  • Selected Deposit Intacct Export
  • Selected Deposit Intacct Export Other Receipts
  • Process Selected Payments Intacct Export
  • Process Selected Intacct Export Other Receipts

Other Receipts

According to Intacct, Other Receipts are receipts that are not associated with a customer or invoice and can include cash, card charge, cash transfer, or check payment. This feature goes hand in hand with undeposited receipts. These are used to document that money has been received, but has not yet been deposited. Once deposited, the Other Receipts should be rolled over to Deposits and Journal Entries.

A SPoC can contact Support and request this as a Professional Services project.

Initial Setup

After Intacct functionality is added to your system, a SPoC must complete some initial setup for this it to work. If a new Program, Bank, or Congregation is added in the future, this process must be repeated for the new additions.
Tip: We recommend using Mass Assign for several steps in this process.
  1. Go to Lookup Values > Banks, and add at least one bank with the following fields:
    • Required: Account Number
    • Optional: Intacct Location and Intacct Department
  2. Go to Church Structure > Programs, and enter these fields for all Programs:
    • Intacct Department
    • Intacct Account
    • Intacct Fund
    • Intacct Location
  3. Go to Church Structure > Congregations, and enter the Intacct Location for all Congregations.
  4. Go to Events.
    • All Events: Add the Intacct Account
    • Qualifying Events that go to Intacct: Project Code, Intacct Loaction, and Intaact Department
  5. Go to Products & Payments > Product Option Groups, and enter these fields for all Product Option Groups:
    • Intacct Account
    • Project Code
    • Intacct Location
    • Intacct Department
Once these fields are populated, test your setup:
  • MinistryPlatform creates a CSV file that you can use as many times as necessary to load in Intacct if it doesn't work the first time. If you are familiar with Intacct and what information the file needs, you can look at the file to verify it before importing to Intacct.
  • We do not recommend testing with a Deposit that's already been exported and used in your legacy or current financial system.
  • If you need to know what fields take precedence over others, see the Intacct Precedence chart (PDF).

Export Deposits to Intacct

  1. Go to Stewardship > 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 Ready to Export view, and change your Selection drop-down to Current/Unsaved Selection to confirm your selection.
  5. Optionally, run any preliminary reports for this selection of Deposits.
  6. From the Reports menu, select Selected Deposit Intacct Export.
    1. Select the Bank account.
    2. Click View Report.
    3. Review the on-screen report.
    4. If the report is correct, click the Prepare Export link in the report. If not, close the report and make any changes.
    5. Export the results to a CSV.
  7. Import into Intacct as a Cash Receipts Journal.

Export Payments to Intacct

  1. Go to Stewardship > Payments.
  2. Make sure you have no records selected on the Payments page.
  3. Change your view to 1. Not Processed.
  4. Select all the Payments in the 1. Not Processed view, and change your Selection drop-down list to Current/Unsaved Selection to confirm your selection.
  5. From the Reports menu, select Process Selected Payments Intacct Export.
    1. Select the Bank account.
    2. Enter Merchant Batch to add to all select payments.
    3. Click View Report.
    4. Review the on-screen report.
    5. If the report is correct, click the Prepare Export link in the report. If not, close the report and make any changes.
    6. Export the results to CSV.
  6. Import into Intacct.
MinistryPlatform
portal

Last updated: July 16, 2024