Once a year accounting report for the national church
Posted: Sat Mar 12, 2022 10:40 am
The national church wants an income statement of 16 lines. They want all funds combined. Many/most accounts will be combined in a line called "All other operating expenses." I could export the data into a spreadsheet and do some sort of pivot table, once I manually identify which line item it goes to. Or I could print out the trial balance and type the values into a spreadsheet.
Best practice would be to design a custom report that put each account in the line where it belonged, for purposes of this report. To do this, I would need a free field. For example, I have determined that account 01-5150-001 goes on line 14. 02-5301-014 goes to line 13. If I had a free field, I could code 14 and 13 in the respective account.
I started to play with custom reports and do not see such a field. I had my eye on "Notes" but do not see any ability to filter or sort by "Notes." Anyone else solved this problem?
Another observation: Not interested in completely redoing chart of accounts to generate this once a year report.
Best practice would be to design a custom report that put each account in the line where it belonged, for purposes of this report. To do this, I would need a free field. For example, I have determined that account 01-5150-001 goes on line 14. 02-5301-014 goes to line 13. If I had a free field, I could code 14 and 13 in the respective account.
I started to play with custom reports and do not see such a field. I had my eye on "Notes" but do not see any ability to filter or sort by "Notes." Anyone else solved this problem?
Another observation: Not interested in completely redoing chart of accounts to generate this once a year report.