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.