User Support Forum

Hi,

need some advice. After trying to get the accounting setup over the past year, and in the process doing a lot of reversals and so on, its time for the yearly audit.

The person who is doing it is used to the 'old way' of reporting the income and expenses. I'm trying to find a report that will satisfy his requirements.

He wants to see the starting balance, add all income, then subtract all expenses, which then should show the EOY checking account balance. I would have thought the standard Income/Expense report would do this, but its not what he wants.

Anybody have a suggestion ??

Thanks

Sounds like he wants to see the Check Register by Fund (which used to be the Cash Flow report). You can find that report in Accounting / Fund Accounting / Reports - Fund Accounting. The income/expense statement does not reflect liabilities paid such as principal payments for a building loan.

Sounds like the Account Activity report to me. But it won't work for the whole of the church, and the activity report for the register would be in date order, not income then expense. I currently have to re-type the inc/exp report into an excel document, because my council wants to see "the bottom line" for the church, and I can't get a single PCvs9 report that will do what they ask. Would it work to data-dump to excel? or Custom Report?

The auditor has rethought what he wanted, and we're going to sit and get a better idea of what he wants, but the Check Register by Fund (the old Cash Flow) report may be what he wants to see.