How do you post to Fund Acctg after posted to Contribution

Contributions, Faith Promises

Moderators: Moderators, Tech Support

Post Reply
rebekah868@gmail.com
Posts: 5
Joined: Fri Dec 28, 2018 4:44 pm

How do you post to Fund Acctg after posted to Contribution

Post by rebekah868@gmail.com »

We were behind and needed to get the 2018 Giving Statements printed. In order to do this we entered all the contributions and posted to Contribution Module only. Now we need to take these contributions and post to Fund Accounting Module. Can this be done? If so How?

Or do I need to export the Contribution data and post by using an external source (i.e. the data extracted)?

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

Re: How do you post to Fund Acctg after posted to Contributi

Post by NeilZ »

rebekah868@gmail.com wrote:We were behind and needed to get the 2018 Giving Statements printed. In order to do this we entered all the contributions and posted to Contribution Module only. Now we need to take these contributions and post to Fund Accounting Module. Can this be done? If so How?

Or do I need to export the Contribution data and post by using an external source (i.e. the data extracted)?
Can't .. once Contributions are posted, you cannot recover that. You can manually run a Funds Report for each Sunday, or day you have contributions deposited, and enter the data manually. However, I'm going to assume that your bookkeeper was keeping Funds Accounting up to date in some way, as you have to have reconciled your monthly bank statements.

The only issue is making sure that the income was properly shown in the correct income accounts.

Not knowing how you took care of the deposits in Funds Accounting, I can only speculate on what you may or may not need to do.
Neil Zampella

Using PC+ since 1999.

rebekah868@gmail.com
Posts: 5
Joined: Fri Dec 28, 2018 4:44 pm

Re: How do you post to Fund Acctg after posted to Contributi

Post by rebekah868@gmail.com »

I am finding this difficult to believe. If I can import data to process - then it would stand to reason that I should be able to extract data to feed into Power Church to apply it to Fund Accounting. There has to be a way to export the data in the proper format - to turn around and import that data for processing.

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

Re: How do you post to Fund Acctg after posted to Contributi

Post by NeilZ »

rebekah868@gmail.com wrote:I am finding this difficult to believe. If I can import data to process - then it would stand to reason that I should be able to extract data to feed into Power Church to apply it to Fund Accounting. There has to be a way to export the data in the proper format - to turn around and import that data for processing.
Nothing says you can't fiddle with the data, export the database to Access, and try and fiddle with it to pull out data. However, you can do the same thing by running the Funds Report, and manually entering a few Transactions into Funds Accounting.

You'd spend more time doing the first, than just manually doing the second. In fact, since there was obviously a period of time in 2018 where the data was not entered, and I suspect it was a continuous period, all you would have to do is run ONE Funds Report for that time frame, and enter that data using a transaction in Funds Accounting. Example: Contribution data was not entered from Nov 11th thru Dec 30th 2018. All you would need to do is run one report with the date range listed, and use that data to create one transaction. If you wanted the Income & Expense reports for Nov & Dec to be properly updated, you'd run two, one for Nov and one for Dec. In either case, you would have to set the date to the end of the month in 2018, and post to the month in question, hopefully the months are still open.

This is not something that is normally needed. Normally, if you're also using Accounting, you would post to Funds Accounting, or to a file which then would be imported into Funds Accounting.

However, that is done when you have unposted contributions, which is a separate transaction queue. Much easier to create the needed Fund Accounting transactions at this time.

However, you also have the issue of how your bookkeeper or Treasurer tracked the deposits made in 2018 to update the system to be able to pay the bills. You have to take that into account no matter HOW you get the data from Contributions, otherwise you'll going to have duplicate deposits and income listed.
Neil Zampella

Using PC+ since 1999.

rebekah868@gmail.com
Posts: 5
Joined: Fri Dec 28, 2018 4:44 pm

Re: How do you post to Fund Acctg after posted to Contributi

Post by rebekah868@gmail.com »

Posting for Fund Accounting usually occurs from Contributions "Update Fund Accounting". But in this situation the posting was only made from "Only Update Contribution Module". Based on the information below it infers - a file can be exported to use as input to update Fund Accounting.
The manual refers to:
Importing Contribution Transactions
PowerChurch Plus can import contribution transactions data from other computers
running PowerChurch Plus. This feature is useful if your church runs Accounting and
Contributions on two different, non-networked computers.
Transferring data is a two-step process:
1. Post Contributions on the computer where Contributions are entered. When
PowerChurch Plus asks you how to post the transactions, select Update Fund
Accounting via File. PowerChurch Plus will create a file of journal transactions. Refer
to Posting Contributions for more information.
2. Import the transactions to the computer running Accounting.

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

Re: How do you post to Fund Acctg after posted to Contributi

Post by NeilZ »

rebekah868@gmail.com wrote:Posting for Fund Accounting usually occurs from Contributions "Update Fund Accounting". But in this situation the posting was only made from "Only Update Contribution Module". Based on the information below it infers - a file can be exported to use as input to update Fund Accounting.
The manual refers to:
Importing Contribution Transactions
PowerChurch Plus can import contribution transactions data from other computers
running PowerChurch Plus. This feature is useful if your church runs Accounting and
Contributions on two different, non-networked computers.
Transferring data is a two-step process:
1. Post Contributions on the computer where Contributions are entered. When
PowerChurch Plus asks you how to post the transactions, select Update Fund
Accounting via File. PowerChurch Plus will create a file of journal transactions. Refer
to Posting Contributions for more information.
2. Import the transactions to the computer running Accounting.
Again, this is if you Post to Funds Accounting and SAVE TO A FILE. Please RE-READ item #1. When PCPlus asks you how to POST the transactions, select Update Fund Accounting via FIle.

As I said above, you have ALREADY posted Contributions TO Contributions Module. This cannot be undone. You've cleared out the Unposted Contributions queue.

The only information Funds Accounting needs is the amount being deposited to the bank account, and what income accounts to credit. As I mentioned above, the Contribution Module's Standard FUNDS REPORT will give you this information.

Again, you HAVE NOT said how you were updating the Funds Accounting module to cover the deposits made at that time, and how the bank reconciliations have been done. If Funds Accounting was not updated to account for these deposits, how were the Income and Expense, and end of year reports created?
Neil Zampella

Using PC+ since 1999.

Wagner
Posts: 6
Joined: Tue Nov 02, 2021 3:30 pm

Re: How do you post to Fund Acctg after posted to Contribution

Post by Wagner »

In reviewing a 'Posted Contributions' report I noticed a discrepancy between the contributions report total and the income for the associated account in the Fund Accounting module. Specifically, the Fund Accounting module account did not show all of the postings made in the contributions module. Inspecting more, I saw that our bookkeeper, upon occasion, only posted to the Contributions module and not the Fund Accounting module. Sometimes, when a prior posting needs adjustment (reversal and reposting) our bookkeeper would post only to the Contributions module thinking that the entry, having already been posted once, might be wrongly (double) counted on the reposting. We've discussed this.

It appears that I can not go back and repost a prior transaction that was posted only to the contributions module and designate that the contribution should be applied to the Fund Accounting module. But, can I make an adjusting journal entry to the Fund Accounting module to reflect the shortfall? I was thinking about posting a credit to pledge income and a debit to our fund balance (Unrestricted Net Assets).

Any advice would be greatly appreciated. Thanks.

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

Re: How do you post to Fund Acctg after posted to Contribution

Post by NeilZ »

Wagner wrote:
Thu May 23, 2024 11:18 am
In reviewing a 'Posted Contributions' report I noticed a discrepancy between the contributions report total and the income for the associated account in the Fund Accounting module. Specifically, the Fund Accounting module account did not show all of the postings made in the contributions module. Inspecting more, I saw that our bookkeeper, upon occasion, only posted to the Contributions module and not the Fund Accounting module. Sometimes, when a prior posting needs adjustment (reversal and reposting) our bookkeeper would post only to the Contributions module thinking that the entry, having already been posted once, might be wrongly (double) counted on the reposting. We've discussed this.

It appears that I can not go back and repost a prior transaction that was posted only to the contributions module and designate that the contribution should be applied to the Fund Accounting module. But, can I make an adjusting journal entry to the Fund Accounting module to reflect the shortfall? I was thinking about posting a credit to pledge income and a debit to our fund balance (Unrestricted Net Assets).

Any advice would be greatly appreciated. Thanks.
You will have to create a manual deposit transaction in Funds Accounting to correct the issue. Basically, just create the transaction as you would a normal deposit, accessing the income (credit) and checking accounts (debit) ... the system will properly update the net asset/fund balance account. If there is an adjustment that results in a negative amount you would debit income and credit checking.

FWIW ... if a correction is made in Contributions, the system will properly create the transactions to reverse and repost the amounts in Funds Accounting. The times I post to Contributions only are few and far between, usually when a contribution was attributed to the wrong envelope. In that case the reverse and correction does not affect the amount received and previously posted to Funds Accounting so posting there is not needed.

Finally, its always better to create a new topic as posting to 5 year old topics tends to get lost, and is a tactic often used by spammers.
Neil Zampella

Using PC+ since 1999.

Post Reply