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!

Export Deposits to Intacct

 

Custom fields and reports can be added to your MinistryPlatform system so you can create a file that makes 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 an Integrations project.

Initial Setup

After Intacct functionality is added to your system, a SPoC must complete some initial setup for this to work. If a new Program, Bank, or Congregation is added in the future, this process must be repeated for the new additions. Pro Tip: Mass Assign will be your best friend for several steps in this process.
  1. Lookup Values > Banks > Add at least one bank, populating the following fields:
    • Required: Account Number
    • Optional: Intacct Location and Intacct Department
  2. Church Structure > Programs > Populate these fields for all Programs:
    • Intacct Department
    • Intacct Account
    • Intacct Fund
    • Intacct Location
  3. Church Structure > Congregations > Populate the Intacct Location for all Congregations.
  4. Events.
    • All Events: Add the Intacct Account.
    • Qualifying Events that go to Intacct
      • Project Code
      • Intacct Location
      • Intacct Department
  5. Products & Payments > Production Option Groups > Populate 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.

Intacct Reports

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

Deposit Export to Intacct

  1. Stewardship > Deposits.
  2. Confirm you have 0 Selected on the Deposits page.
  3. Select the "Ready to Export" view.
  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. If desired, run any preliminary reports for this selection of Deposits.
  6. Reports > 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 to Intacct as a Cash Receipts Journal.

Payments Export to Intacct

  1. Stewardship > Payments.
  2. Confirm you have 0 Selected on the Payments page.
  3. Select the "1. Not Processed" view.
  4. Select all Payments in the "1. Not Processed" view and change your Selection drop-down to Current/Unsaved Selection to confirm your selection.
  5. 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 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 to Intacct.

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.