User Support Forum

In Fund 02, I track various Ministry transactions and they are defined by sub-group numbers.
I can generate monthly reports that tells me total income and total expenses, and a sub-account report.
I can also generate a report showing me income activity, and a separate expense activity report.

I'm looking for a report that combines these reports into one with 5 columns:
Date, Transaction Description, Income, Expense, New Balance.

I want to be able to generate this report for each ministry, at month end.

Is that doable?

Alaraujo wrote:In Fund 02, I track various Ministry transactions and they are defined by sub-group numbers.
I can generate monthly reports that tells me total income and total expenses, and a sub-account report.
I can also generate a report showing me income activity, and a separate expense activity report.

I'm looking for a report that combines these reports into one with 5 columns:
Date, Transaction Description, Income, Expense, New Balance.

I want to be able to generate this report for each ministry, at month end.

Is that doable?

I'm not sure if you can even create it under Custom Reports ..!!

Recommend that you run the Account Activity report for the income and expense accounts and then export the reports to Excel. Once in Excel copy and paste the data to get it in the format you are looking for.

Thanks for your input.