Accounts with Debits and Credits totals

Postby beckyc » Mon Jul 29, 2013 7:58 pm

Hi,
I'd like to create a report that is similar to the account activity report, but would be just a summary report. For example, in the checking account fund of 1111, the report would say the beginning balance, the total debits for the month, the total credits for the month and the ending balance. I can create a custom report right now that gives me beginning balance and ending balance but gives me the net change not a divided out listing of debits and credits.

Is this possible?
Thanks
Becky
beckyc
 
Posts: 18
Joined: Mon Jul 29, 2013 5:09 pm

Re: Accounts with Debits and Credits totals

Postby Zorak » Tue Jul 30, 2013 8:22 am

Unfortunately, no. The custom report writer in Fund Accounting only has accounts, balances, and budgets. It doesn't have the actual transaction details available to it. If you are using Version 11 or 11.5, there is an Export to Access under the Utilities menu, if you wanted to get the data out and report on it from there.
Zorak
Tech Support
Tech Support
 
Posts: 2493
Joined: Thu May 13, 2004 8:59 am
Location: PowerChurch Software

Re: Accounts with Debits and Credits totals

Postby Jeff » Wed Jul 31, 2013 7:53 am

The report you are talking about is a trial balance report. The trial balance report in PowerChurch lists the beginning balance, the net change in the account and the ending balance. It does not list the debits and credits separately.

What is it you are trying to accomplish?
Jeff
Program Development
Program Development
 
Posts: 1222
Joined: Fri Sep 05, 2003 10:43 am
Location: PowerChurch Software

Re: Accounts with Debits and Credits totals

Postby beckyc » Mon Nov 16, 2015 9:13 pm

Just saw this answer to an old question that I had. My purpose for trying to do this report is to print a list of our asset accounts (benevolence fund, church fellowship fund checkbook, regular checkbook, etc) for a trustee meeting. They would like the report to now only show the beginning and ending balances but also show how much money came in during the month and how much went out.

For example the benevolence fund - we received $500 in donations but we distributed $475 so a change of $25. But they would like to know that we actually helped people for $475 worth and not just see that our checkbook grew by $25.

Any way to easily automate this?

Thanks
Becky
beckyc
 
Posts: 18
Joined: Mon Jul 29, 2013 5:09 pm

Re: Accounts with Debits and Credits totals

Postby tborgal » Tue Nov 17, 2015 7:26 pm

If you are looking for totals from a fund and not just an account. The Accounting Fund Balances report should give you this. You can get the results by month as well as annually. Look under Accounting > Fund Accounting > Reports - Fund Accounting.

Tom
tborgal
 
Posts: 858
Joined: Thu Jun 03, 2004 3:55 pm
Location: New England Bible Church, Andover, MA

Re: Accounts with Debits and Credits totals

Postby beckyc » Tue Nov 17, 2015 8:20 pm

Thanks, but I'm not looking for a fund listing - I guess I kind of confused that by saying fellowship fund which is what our church people might call it when in PC+ terms it is really an the "fellowship" asset account.

I created a custom report that gives me a partially usable report. It gives me the account name and the beginning and ending balances. Then I just add 2 columns to the spreadsheet and physically type in the debit total and credit total (which I can find by doing the account activity listing). I was just hoping for a little less hand work as then there is more possibility of adding human error.
Thanks
Becky
beckyc
 
Posts: 18
Joined: Mon Jul 29, 2013 5:09 pm