home

MinistryPlatform

RealmRealm AccountingMinistryPlatformGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite
RealmRealm AccountingMinistryPlatformGivingPDSACSConnectShepherdGrowth MethodHeadMasterRefresh WebsitesTrust CenterGo MethodMissionInsite

What would you like to know more about?

Show Contents

Show Page Sections

thumbnailMinistryPlatform

Exporting Deposits

Intacct Export

This section examines how to export deposits through Intacct.

You can add custom fields and reports to your MinistryPlatform system so you can create a file with 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 together with undeposited receipts. These are used to document that you've received money but haven't deposited it yet. Once deposited, you should roll over the "other receipts" to deposits and journal entries.

Initial Setup

After you add Intacct 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 the new additions.
Tip: We recommend using the mass assign feature for several steps in this process.
  1. In the navigation menu, click Lookup Values > Banks.
  2. Add at least one bank with the following fields:
    • Required: Account number
    • Optional: Intacct location and Intacct department
  3. In the navigation menu, click Church Structure > Programs.
  4. Enter these fields for all programs:
    • Intacct department
    • Intacct account
    • Intacct fund
    • Intacct location
  5. In the navigation menu, click Church Structure > Congregations or Parishes.
  6. Enter the Intacct location for all congregations.
  7. In the navigation menu, click Events.
    • All Events: Add the Intacct account
    • Qualifying Events that go to Intacct: Project code, Intacct location, and Intaact department
  8. In the navigation menu, click Products & Payments > Product Option Groups.
  9. Enter these fields for all product option groups:
    • Intacct account
    • Project code
    • Intacct location
    • Intacct department
Once you enter information into these fields, 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 view 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. 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 Intacct Export.
    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. 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. In the navigation menu, click Products & Payments > Payments.
  2. Make sure you have no records selected on the Payments page.
  3. Change your view to Not Processed.
  4. Select all the payments in the Not Processed view.
  5. Change your selection drop-down list to Current/Unsaved Selection to confirm your selection.
  6. Click Reports > 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 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.
  7. Import into Intacct.
portal
MinistryPlatform

Last updated: February 21, 2025