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
Accounts with Debits and Credits totals
Moderators: Moderators, Tech Support
-
- Tech Support
- Posts: 3015
- Joined: Thu May 13, 2004 9:59 am
- Location: PowerChurch Software
- Contact:
Re: Accounts with Debits and Credits totals
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.
-
- Program Development
- Posts: 1225
- Joined: Fri Sep 05, 2003 11:43 am
- Location: PowerChurch Software
- Contact:
Re: Accounts with Debits and Credits totals
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?
What is it you are trying to accomplish?
Re: Accounts with Debits and Credits totals
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
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
-
- Posts: 863
- Joined: Thu Jun 03, 2004 4:55 pm
- Location: New England Bible Church, Andover, MA
- Contact:
Re: Accounts with Debits and Credits totals
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
Re: Accounts with Debits and Credits totals
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
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