Looking for a good way to handle monthly mission payments

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
GFBCUser
Posts: 23
Joined: Mon Nov 09, 2015 4:32 pm

Looking for a good way to handle monthly mission payments

Post by GFBCUser »

Right now we write seven checks monthly to different local organizations, We have been just writing a check to each organization and debiting our "Local Missions Expense" fund for each of those transactions. It is $1050 per month total. I just became the treasurer, and I don't see an efficient way of tracking the amounts for reporting purposes going to those organizations.
I just created separate a Monthly Support group account, and under it, separate expense accounts for the seven organizations. The problem is that the missions director wants to pay these organizations using "local missions expense"
How would you suggest doing it?

NeilZ
Posts: 10569
Joined: Wed Oct 08, 2003 1:20 am
Location: Dexter NM
Contact:

Re: Looking for a good way to handle monthly mission payment

Post by NeilZ »

GFBCUser wrote:Right now we write seven checks monthly to different local organizations, We have been just writing a check to each organization and debiting our "Local Missions Expense" fund for each of those transactions. It is $1050 per month total. I just became the treasurer, and I don't see an efficient way of tracking the amounts for reporting purposes going to those organizations.
I just created separate a Monthly Support group account, and under it, separate expense accounts for the seven organizations. The problem is that the missions director wants to pay these organizations using "local missions expense"
How would you suggest doing it?
From your description I can't tell if the 'local missions expense' is a separate Accounting Fund from the normal operations, or just an account under it. I'm going to assume that it is a detail expense account.

Unfortunately, you can't move a detail account to a group account, so you're kinda stuck with the 'local missions expense' detail account until the start of the next fiscal year. But you can then rename the account and inactivate it, then:

Create a GROUP account 'local missions expense' which you budget against as a level 5. Say the number is 6050-000. Under that you can move the seven expense accounts you just created under the 6050-000 (6051 thru 6057) and set each budget line item as 'budget on the group',and set them as a level 6.

In this way you can satisfy the missions director whom I assume only wants to see one line item budget on the expense report, but you have granularity showing exactly how much is going to each group. When you provide the director with a report, just adjust the settings to show a level 5 report, and all the funds charged against those seven expense accounts will roll up and display under 'local mission expense'.

Does this help?
Neil Zampella

Using PC+ since 1999.

Post Reply