processing release accounts transactions

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

Post Reply
bjwhitson
Posts: 100
Joined: Wed Mar 19, 2008 2:19 pm
Location: Grayson, GA

processing release accounts transactions

Post by bjwhitson »

Powerchurch Ver 12 , Windows 10

I thought I had the whole concept of release accounts straight as I used them for years with another church. I've set up the Temporarily Restricted Income accounts, the Temp Restricted Release accounts and the Temp Restricted Expenses accounts. I've input the beginning balances in my restricted accounts such that the 6-30-2018 Balance Sheet in PCP matches the old software system reports. When I enter the transaction in Accounts Payable and release the funds, it appears that the amount is subtracted twice. I've looked at this every which way (but the right one - otherwise I would have figured it out :-)) and am just not seeing it. All transactions are currently unposted. When I run the reports, I check the "include unposted transactions" box . Here's the flow -

6-30-2018 Beginning balance - Soup Night Ministry $ 1,908.88

7-11-2018 check for $41.43 -
CR 01-1120-000 - Designated checking account - $41.43
DR 01-5005-107 - Soup Night Ministry expense account - $41.43
DR 01-4835-107 - Soup Night Ministry release fund - $41.43
CR 01-4999-000 - Released from restriction fund - $41.43

7-31-2018 Ending balance - Soup Night Ministry - $1,826.02 ( a difference of $82.86) but it should be $1,867.45

On the 7-31-2018 Income & Expense report, the "Release From Restrictions", "Temp Restricted Release" line shows ($41.43) and under "Expenses" "Temp Restricted" line shows $41.43.

The Cash Management Report shows the following -
01-3235-107 Soup Night Ministry
Posted balance $1,908.88
Total unposted in fund accounting (82.86)
Adjusted Account Balance $1,826.02

I'm sure this is something simple but I've looked at it so long, I'm not seeing it. I've actually got several transactions with this same problem so any help would be much appreciated.
BJW
Finance Committee-HPC
PC+ user since 2008
Grayson, GA

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

Re: processing release accounts transactions

Post by NeilZ »

bjwhitson wrote:Powerchurch Ver 12 , Windows 10

<snip>

6-30-2018 Beginning balance - Soup Night Ministry $ 1,908.88

7-11-2018 check for $41.43 -
CR 01-1120-000 - Designated checking account - $41.43
DR 01-5005-107 - Soup Night Ministry expense account - $41.43
DR 01-4835-107 - Soup Night Ministry release fund - $41.43
CR 01-4999-000 - Released from restriction fund - $41.43

7-31-2018 Ending balance - Soup Night Ministry - $1,826.02 ( a difference of $82.86) but it should be $1,867.45

On the 7-31-2018 Income & Expense report, the "Release From Restrictions", "Temp Restricted Release" line shows ($41.43) and under "Expenses" "Temp Restricted" line shows $41.43.

The Cash Management Report shows the following -
01-3235-107 Soup Night Ministry
Posted balance $1,908.88
Total unposted in fund accounting (82.86)
Adjusted Account Balance $1,826.02

I'm sure this is something simple but I've looked at it so long, I'm not seeing it. I've actually got several transactions with this same problem so any help would be much appreciated.

When creating a donor restriction, adding an expense account is always an option, however, it appears you've got the expense closing to the restricted fund balance, it should be closing to the unrestricted net assets account. When you release restricted funds, the system basically moves the funds from the restricted fund balance to the unrestricted funds balance.

The only thing you need to do is change the closing account to the unrestricted net assets - usually the xx-3110-000, and leave the checkbox for "This account users restricted money" checked.

You should test this first. Do a backup of the accounting files, then change the closing account on the expense account, it should change that Adjusted Account Balance to what you what you should see.
Neil Zampella

Using PC+ since 1999.

bjwhitson
Posts: 100
Joined: Wed Mar 19, 2008 2:19 pm
Location: Grayson, GA

Re: processing release accounts transactions

Post by bjwhitson »

Thanks, Neil! That solved my problem! :D
BJW
Finance Committee-HPC
PC+ user since 2008
Grayson, GA

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

Re: processing release accounts transactions

Post by NeilZ »

Good to hear !!
Neil Zampella

Using PC+ since 1999.

Post Reply