Forum Discussion
Excel for my church financial reports
I have monthly, quarterly and annual reports. My quarterly reports are an accumulation of numbers for each category i.e. current, building fund, mission for January, February and March, I have been u...
The #REF errors happen because manual formulas break when you move or delete cells. If you're building monthly/quarterly/annual reports for your church, you might want to look at Excel add-ins designed for nonprofit and church financial reporting. They handle the report generation automatically from your transaction data, so you never deal with broken formula references again. Some even let you double-click any number to drill down to the underlying transactions.