Setup of Interfund Management Module

(0) Share

Report

Posted on by Community Member

I am attempting to setup the Interfund Management Module to meet the requirements set forth by my client's CPA as follows for expenses posted through AP:

If a debit is posted to a fund expense account (01-6230-8000-000) then the two offsetting entries must be a debit to the particular fund's net asset account (01-6230-3000-000) and a credit to the general fund net asset account (01-0000-3500-000) the final balancing credit is to the account payable account (00-0000-2000-000).

I have setup the Interfund Management Module using both methods available and the result is the same. The automatic entries credit the particular fund's net asset account (01-6230-3000-000) and debit the general fund net asset account (01-0000-3500-000) - the exact opposite of my client's requirements.

Technical support did not offer any assistance other than to confirm that the application was functioning properly. I would be surprised if Microsoft Great Plains would go to the trouble of creating an application for fund management for non-profits and not design the application to meet the most basic fund accounting requirements.

Any assistance would be much appreciated.

*This post is locked for comments

I have the same question (0)

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report
Copy link

Link copied!

The entry it is creating is correct - the entry you indicated you are looking for will out your funds out of balance - you will be debiting fund 6230 twice and creaiting fund 0000 twice. The purpose of interfund is to keep the funds in balance

Was this reply helpful? Yes No
djp2880 50 on at

Like (0)

Report
Copy link

Link copied!

Setting up Interfund can definitely be a challenge. We've had success with Interfund by setting it up so that Cash accounts for all fund are setup in the IF setup window. The Checkbooks carry the offset cash account. A simple scenario: 01-6000 expense account would debited $10 and we, with customization, auto populate the corresponding AP accounts 01-2500 $10 to match the funds used in the expense accounts. Thus we pass a balanced entry. Interfund takes no action. Then when the payment is processed the distributions will show AP account 01-2500 is debited $10 and the cash account from the checkbook 00-1000 is credited $10. When the payment posts to the GL, Interfund kicks in and Offsets the $10 credit 00-1000 with a $10 debit to 00-1050, then credits 01-1000 with $10 and lastly the AP account is relieved with a $10 debit. There is a pretty limited amount of flexibility in the current GP Interfund product. We have been implementing Interfund for about 3 years and have yet to locate specific expertise within Microsoft. Good Luck and I Hope this helps.

Was this reply helpful? Yes No
Brenda Willey 2,520 on at

Like (0)

Report
Copy link

Link copied!

In the above scenario are you using Singe due to or Clearing Fund. are you saying you use the cash accounts as the Due to/Due from accounts or the clearing accounts? Do you know if this will work with Payroll as well?

Was this reply helpful? Yes No