How do you post to Fund Acctg after posted to Contribution

Postby rebekah868@gmail.com » Tue May 07, 2019 4:53 pm

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)?
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

Postby NeilZ » Tue May 07, 2019 10:22 pm

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.
NeilZ
 
Posts: 8905
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

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

Postby rebekah868@gmail.com » Wed May 08, 2019 7:04 am

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.
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

Postby NeilZ » Wed May 08, 2019 7:41 am

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.
NeilZ
 
Posts: 8905
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA

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

Postby rebekah868@gmail.com » Wed May 08, 2019 8:52 am

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.
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

Postby NeilZ » Wed May 08, 2019 9:42 am

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.
NeilZ
 
Posts: 8905
Joined: Wed Oct 08, 2003 12:20 am
Location: Connellsville, PA