Setting Up a Flexible Spending Account

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Setting Up a Flexible Spending Account

Post by kara »

I need to set up a flexible spending account for each of our pastors. How do I best set this up to show what the remaining balance is and the expenditures in the payroll module, etc.? Our pastors are paid once per month. Thank you.

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Setting Up a Flexible Spending Account

Post by JohnDMeyers »

Unless this is something I have not heard of, you probably don't want to track it in the payroll module.

The easiest way to set it up is as a budgeted expense in fund accounting. Create an account for each pastor in the expense range, and assign it a budget.

Using the budget report, or a modified income-and-expense report, you can easily see how much is spent and how much remains.
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

beas
Posts: 139
Joined: Mon Nov 17, 2003 11:29 pm
Location: Neighborhood Church (A/G), Albany, OR
Contact:

Re: Setting Up a Flexible Spending Account

Post by beas »

Is this an FSA associated with a cafeteria plan or something along that line...like a medical or dependent care FSA?
Bill Beasley
Secretary-Treasurer
Neighborhood Church
Albany, Oregon
User since ~1988

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Setting Up a Flexible Spending Account

Post by JohnDMeyers »

If this is something like a before-tax health savings plan, then you can add it in payroll:

First, create liability accounts in Fund Accounting as necessary to receive the deductions:
Fund Accounting / Setup / Maintain Chart of Accouts
ADD
Detail Liability
01-2021-000 pastor#1 savings plan

ADD
Detail Liability
01-2022-000 pastor#2 savings plan


Payroll / Setup / Maintain Item Descriptions
ADD
Other Deduction
21
Pastor#1 plan
liability account: 01-2021-000
bank account 01-1110-000

ADD
Other Deduction
22
Pastor#2 plan
liability account: 01-2022-000
bank account 01-1110-000

Assign the Payroll Item to each respective pastor.

To pay the money to the plan, use Accounts Payable:
CR 01-1110-000 checking $1000
DB 01-2021-000 pastor#1 $650
DB 01-2022-000 pastor#2 $350
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Re: Setting Up a Flexible Spending Account

Post by kara »

JohnDMeyers wrote:Unless this is something I have not heard of, you probably don't want to track it in the payroll module.

The easiest way to set it up is as a budgeted expense in fund accounting. Create an account for each pastor in the expense range, and assign it a budget.

Using the budget report, or a modified income-and-expense report, you can easily see how much is spent and how much remains.
Yes, this amount elected by each pastor would reduce their pay each month. For example, Pastor A wants $71.43 withheld from his pay each month. Pastor B wants $142.86 withheld each month. How do I reduce their taxable income each month with the respective amounts?

kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Re: Setting Up a Flexible Spending Account

Post by kara »

In addition, how do I get the taxable income portion of their checks to reduce. Taxable Income + Non Taxable Income - Deductions = Check Amount.

JohnDMeyers
Posts: 1338
Joined: Sun Oct 07, 2007 9:50 am
Location: Potsdam, NY
Contact:

Re: Setting Up a Flexible Spending Account

Post by JohnDMeyers »

When you create your Income Pay Items, you can designate them as taxable or non-taxable. The taxes will only be deducted from the taxable ones.

Payroll / Setup / Maintain Item Descriptions
ADD
Income
[sixth box down]
Taxable / Non-taxable / housing / etc...
You can watch my PowerChurch tutorials now on YouTube!

Visit http://www.youtube.com/user/EmpowerYour ... ture=watch

kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Re: Setting Up a Flexible Spending Account

Post by kara »

I'm not following. I set this up as a deduction.

kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Re: Setting Up a Flexible Spending Account

Post by kara »

It may help - I am using PowerChurch Plus 10.4. I have the FSA amount being deducted from each check and I used your instructions above, but I don't know how to have the amount reduce the taxable amount of income instead of just as a deduction.

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

Re: Setting Up a Flexible Spending Account

Post by NeilZ »

kara wrote:It may help - I am using PowerChurch Plus 10.4. I have the FSA amount being deducted from each check and I used your instructions above, but I don't know how to have the amount reduce the taxable amount of income instead of just as a deduction.
So this is a PreTax deduction .. and it is handled differently in v10.4, its much easier to setup in 11.x, which may be a reason you could use with your church board or trustees to get the money to upgrade ;)

When you added the deduction in the Maintain Item Descriptions, the Type of Item you should have selected was Other Deduction. Then on the full dialog screen where you would enter the item number, description, etc. You would select the Tax Option of Pre-Tax Deduction.

I'm fairly sure that this covers the pre-tax for federal & state taxes, as well as Medicare & SS.
Neil Zampella

Using PC+ since 1999.

kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Re: Setting Up a Flexible Spending Account

Post by kara »

This option is not available in the version I am using. I may have to upgrade my software from 10.4.

Zorak
Tech Support
Tech Support
Posts: 3171
Joined: Thu May 13, 2004 9:59 am
Location: PowerChurch Software
Contact:

Re: Setting Up a Flexible Spending Account

Post by Zorak »

In Versions 10.4 and prior, setting up pretax deductions are a much more convoluted process. It's a checkbox option on the deduction items in Versions 11 and higher.

Here's an example of how to set up a 403B, which would be similar to the flex spending account:
https://www.powerchurch.com/support/kb. ... =17&type=1

I believe the full amount would be pre-tax on Fed, SS, & Med, but you should verify that is the case.

kara
Posts: 27
Joined: Wed Nov 23, 2011 12:16 pm

Re: Setting Up a Flexible Spending Account

Post by kara »

I just ordered the upgrade!! Thanks to all who tried to help me.

Post Reply