Void Week Contribution

Fund Accounting, Accounts Payable, Accounts Receivable, Payroll

Moderators: Moderators, Tech Support

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

Re: Void Week Contribution

Post by NeilZ »

ngaham wrote:
NeilZ wrote:
ngaham wrote:
So only post these contributions to contributions and not fund accounting. Then, enter a transaction as you stated above, CR the correct income account(s), DB the EasyTithe Fee Expense Acct, then DB the corresponding checking accounts, depending on the fund account it was donated to.
Basically, yes. Or intercept the Post to Fund Accounting transaction sitting in the Unposted Transactions queue, and edit it to reflect the actual deposit and fees. Frankly, doing the EasyTithe Contributions separate from the Sunday collection is probably easier, as you can enter the EasyTithe and only post to Contributions, then do as I suggested above.
Neil,
I'm not at the church just yet so I can't look, but check out the transaction that established the beginning balance for the school. It was a negative amount in the accounting fund which resulted in a CR to the 01 bank account. This may be the problem?!
Remember, I did say that was not a good idea. It was a negative $7374 .. it could be the cause of some of the issue.
That's the balance now, but the starting balance was -5000 something.
I ran an Account Activity against the 03 Fund, and I see that transfer to checking of 4794.15. It looks like you used 9010-000 as the transfer in, when you should have used 9510-000

It should have looked like this:

01-1110-000 CR 4794.15
01-9010-000 DB 4794.15
03-1110-000 DB 4794.15
03-9510-000 CR 4794.15

Here's the example taken directly from the Powerchurch Manual:
In the following example, $750 is transferred from the 01 fund checking account into
the 02 fund checking account using the simple transfer setup.


01-1110-000 Checking Account CR 750.00
01-9100-000 Transfer to Other Funds DB 750.00
02-1110-000 Checking Account DB 750.00
02-9200-000 Transfer from Other Funds DB 750.00
This is why that shows a negative balance.

And why I recommend using the simple transfer :)
Neil Zampella

Using PC+ since 1999.

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

Re: Void Week Contribution

Post by NeilZ »

That last should have been a credit ..

02-9200-000 Transfer from Other Funds CR 750.00
Neil Zampella

Using PC+ since 1999.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

NeilZ wrote:That last should have been a credit ..

02-9200-000 Transfer from Other Funds DB 750.00
Ok. So that should take care of 4700, right?

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

Re: Void Week Contribution

Post by NeilZ »

ngaham wrote:
NeilZ wrote:That last should have been a credit ..

02-9200-000 Transfer from Other Funds CR 750.00
Ok. So that should take care of 4700, right?
Note I fixed that last line above.

Before you reverse that first transaction, DO A BACKUP of the accounting files.

Then reverse the transaction, and reenter using the correct accounts, and the correct DB & CR assignments. Then we'll see what happens. I'm being called to dinner .. :)
Neil Zampella

Using PC+ since 1999.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

Ok. I have PowerChurch do a daily backup to Google Drive.

I'll be at the church in about 10 mins and I'll give this a try.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

NeilZ wrote:
ngaham wrote:
NeilZ wrote:That last should have been a credit ..

02-9200-000 Transfer from Other Funds CR 750.00
Ok. So that should take care of 4700, right?
Note I fixed that last line above.

Before you reverse that first transaction, DO A BACKUP of the accounting files.

Then reverse the transaction, and reenter using the correct accounts, and the correct DB & CR assignments. Then we'll see what happens. I'm being called to dinner .. :)
Ok. I reversed the incorrect transaction and reissued the transaction as follows.
01-1110-000 CR 4794.15
01-9010-000 DB 4974.15
03-1110-000 DB 4794.15
03-9510-000 CR 4794.15

Instead of the school showing a negative balance of 7374.51, it now shows a positive balance of 2213.79.

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

Re: Void Week Contribution

Post by NeilZ »

OK ... so .. back to the reconcile .. ???
Neil Zampella

Using PC+ since 1999.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

It was still off by a lot. I have restarted accounting (I did a backup), and I am in the process of starting over as of 04/01/2017. I will be re-entering everything for the past month. I've got a big glass of Mountain Dew and I'm here for the night!

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

Re: Void Week Contribution

Post by NeilZ »

ngaham wrote:It was still off by a lot. I have restarted accounting (I did a backup), and I am in the process of starting over as of 04/01/2017. I will be re-entering everything for the past month. I've got a big glass of Mountain Dew and I'm here for the night!
Well ... take my advice about simplifying the accounts by not creating the restricted accounts, as the different funds take care of that. Let me know how it goes.
Neil Zampella

Using PC+ since 1999.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

NeilZ wrote:
ngaham wrote:It was still off by a lot. I have restarted accounting (I did a backup), and I am in the process of starting over as of 04/01/2017. I will be re-entering everything for the past month. I've got a big glass of Mountain Dew and I'm here for the night!
Well ... take my advice about simplifying the accounts by not creating the restricted accounts, as the different funds take care of that. Let me know how it goes.
I did take your advise. I'm not worrying about going as in depth as I did before on the chart of accounts. I can put that time in later.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

NeilZ wrote:
ngaham wrote:Those were actually entered, minus the Groupon. Those are from the EasyTithe. However, I was told to give the member credit for their entire gift, including the 3% they give to cover the transaction cost. What ends up happening is that deposit from EasyTithe (PaymentBrands) doesn't match the contributions because EasyTithe takes out the fees before deposit. The 3% doesn't cover all of the fees.
This is why Powerchurch recommends using Vanco as the online contributions system, since its fully integrated. The contributor gets the full credit, and the church gets the net contribution with the fees deducted, and the system is updated automatically.

In your case you give the Contributor the credit for the full amount In Contributions, then only post the contributions coming in through Easytithe IN CONTRIBUTIONS. You don't post them to funds accounting. Since Easytithe does a EFT deposit in your account, that's the only amount you're really concerned about, along with the fees they charge and take out. You need to show that expense, along with that income.

The obvious transaction would look like this based on 1000 contributions and 80 in fees

Income CR 1000
Fees DB 80
Checking DB 920

I suspect if you get a report from EasyTithe, you will see something like that spelled out.


Got a question on this and I want to make sure i did this trans right.
I had online giving of 1114.57. The fees were 35.39 and 1079.18 was deposited into our account. On the giving there were some designated funds that go into different accounting funds. Is this right?

CR Income Tithes & Offerings (AF 01) 426.57
CR Income Missions (AF 02) 85.00
CR Income Music (AF 01) 603
DB Bank Charges 35.39
CR 01-1110-000 35.39
CR 01-1110-000 1029.57
CR 021110-000 85.00

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

Re: Void Week Contribution

Post by NeilZ »

ngaham wrote:
Got a question on this and I want to make sure i did this trans right.
I had online giving of 1114.57. The fees were 35.39 and 1079.18 was deposited into our account. On the giving there were some designated funds that go into different accounting funds. Is this right?

CR Income Tithes & Offerings (AF 01) 426.57
CR Income Missions (AF 02) 85.00
CR Income Music (AF 01) 603
DB Bank Charges 35.39
CR 01-1110-000 35.39
CR 01-1110-000 1029.57
CR 021110-000 85.00
All the checking account lines should be DEBITS. If you run the Chart of Accounts report from Fund Accounting Reports, you'll see a column that has a header of DB/CR this tells you what is normally done to add amounts to the account. This can give you an idea of what needs to be done when you want to 'add' funds to an account.

That said, here's what it should look like:

01- Tithes & Offerings Income CR 426.57
02- Mission Offering Income CR 85.00
01- Music Income CR 603.00
01-1110 Checking DB 994.18
02-1110 Checking DB 85.00
01- Online GIving Fee DB 35.39

You included the amount of the fee in the checking account deposit. That's not what happened, if you left it that way you'd show an extra 35.39 in the account; that amount was already deducted before the EFT to your checking account from EasyTithe. You're accounting for it by adding to the expense account (DB) for Online Giving Fees.
Neil Zampella

Using PC+ since 1999.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

I re-entered everything and still not able to reconsile. I sent you a backup of the accounting files to check out. I am lost.

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

Re: Void Week Contribution

Post by NeilZ »

ngaham wrote:I re-entered everything and still not able to reconsile. I sent you a backup of the accounting files to check out. I am lost.
I think I emailed you with my idea. Since the number turned out the same after the restart, my suggestion is to accept the reconcile as is, then see what falls out after the May bank statement arrives.
Neil Zampella

Using PC+ since 1999.

ngaham
Posts: 194
Joined: Wed Mar 15, 2017 10:25 am

Re: Void Week Contribution

Post by ngaham »

NeilZ wrote:
ngaham wrote:I re-entered everything and still not able to reconsile. I sent you a backup of the accounting files to check out. I am lost.
I think I emailed you with my idea. Since the number turned out the same after the restart, my suggestion is to accept the reconcile as is, then see what falls out after the May bank statement arrives.
I didn't get an email. Do you think I should contact PowerChurch about this?

Post Reply