User Support Forum

Hello,
We have been tasked in creating a running month to month cash flow report. What we are looking to have is a beginning of month balance, contribution section, and a detailed list of all expenses occurred during that month. Finally, a section of the report that shows the outstanding liabilities that are still owed. Once that is all listed, a final balance of what should represent the cash balance on hand. The next month would then have the final balance (or the previous months ending balance) now at the top of the page, and we would start the report all over again. Can PCP build something like this (or close)? Has someone already created a report like this? (Is the SQL query available somewhere?)
Thanks in advance for your response!

JWedel wrote:Hello,
We have been tasked in creating a running month to month cash flow report. What we are looking to have is a beginning of month balance, contribution section, and a detailed list of all expenses occurred during that month. Finally, a section of the report that shows the outstanding liabilities that are still owed. Once that is all listed, a final balance of what should represent the cash balance on hand. The next month would then have the final balance (or the previous months ending balance) now at the top of the page, and we would start the report all over again. Can PCP build something like this (or close)? Has someone already created a report like this? (Is the SQL query available somewhere?)
Thanks in advance for your response!

You didn't mention what version of Powerchurch you're running.

Have you looked at the Check Register by Fund report under Funds Accounting (in Version 10). It used to be called the Cash Flow report.

It seems to be what you're looking for, or close to it at least.