To find where a church is overspending, I need exactly one file: a general ledger export — every transaction, all accounts, the last 12 months. Every church accounting system can produce it in a few clicks, but the report goes by different names in each one. Here's where it lives.

Whatever your system, aim for these four things:

  1. A full 12 months (a calendar year or your fiscal year — either works)
  2. All accounts — income and expenses, not just one bank account
  3. Excel or CSV format (PDF works, it's just slower)
  4. The detail/transaction-level version, not a summary

QuickBooks Online

  1. Go to Reports and search for "Transaction List by Date" (or "General Ledger" — either works)
  2. Set the report period to the last 12 months
  3. Click the export icon → Export to Excel

Tip: if the report offers columns for Name/Vendor and Memo, include them — vendor names are where the findings hide.

Xero

  1. Go to Accounting → Reports
  2. Open "Account Transactions" (or "General Ledger")
  3. Select all accounts, set the date range to the last 12 months
  4. Export → Excel (or CSV)

Aplos

  1. Go to Reports
  2. Open the "Transactions" report (sometimes listed as Transactions by Account or Account Register)
  3. Set the date range to the last 12 months, include all funds and accounts
  4. Export to CSV or Excel

ChurchTrac

  1. Open the Accounting section
  2. Go to Reports and choose the transaction/register report
  3. Set the date range to the last 12 months, all accounts
  4. Export as CSV

PowerChurch

  1. Go to Accounting → Fund Accounting → Reports
  2. Run the transaction detail / journal report for the last 12 months
  3. Use File → Print to file (or the export option in newer versions) to save as CSV

PowerChurch is desktop software and menu paths vary by version — if you can find a report showing every transaction with dates and amounts, that's the one.

Realm / ACS (ACS Technologies)

  1. In the accounting module, go to reports
  2. Run the GL transaction or journal report for the last 12 months
  3. Export to Excel or CSV

Church Windows / Shepherd's Staff / other desktop systems

Look under the accounting reports menu for anything named journal, transaction detail, or register. Run it for 12 months, all accounts, and export or print-to-file as CSV.

No accounting software? Use your bank.

If your books live in a spreadsheet (no shame — a lot of churches under $500K run this way), download the last 12 months of transactions as CSV from your bank's online portal, plus your credit/debit card statements. It's missing your category labels, but vendor names and amounts are what matter most — I can work with it.

Two optional add-ons that make the report better

  • A balance sheet (one page, any recent month) — this unlocks the idle-cash analysis, which is often the single biggest dollar finding. Every system above has it under Reports → Balance Sheet.
  • Your budget (whatever format you have) — this unlocks the over-budget watch, which shows you which ministry areas are quietly running hot.

What happens next

Upload the file and within 24 hours you'll get back a free savings report — what I'd expect your church to save, category by category, from your actual numbers. I personally review every report before it goes out. If the export gives you any trouble, just send what you have — I've untangled worse.