Skip to main content

What is the Expenses by Vendor Summary report?

Explains the report that totals what your church spent with each vendor or payee in a date range, and how to run it.

You will need the Full Read Accounting permission to run this report. If your account has more than one organization, the report reads one organization's books, chosen in the Accounting for: strip.

The Expenses by Vendor Summary totals your expenses for each vendor over a date range. Use it to see how much your church spent with a contractor, supplier or other payee, or to check spending before renewing a service.

The Expenses by Vendor Summary report listing vendors and totals

Run the report

  1. Go to Accounting > Reports in the left-hand menu.

  2. In the Reports widget on the Accounting Dashboard, click Expenses by Vendor Summary.

  3. Choose a Date Range, then click Refresh.

What the report shows

  • Vendor - each vendor or payee, listed in alphabetical order.

  • Total - the total of that vendor's expenses in the date range.

  • TOTAL - the last line, adding up every vendor.

The header shows the accounting method, the date range and the campuses. A red PRELIMINARY label means the report includes periods that are not closed yet. See Why does my accounting report say PRELIMINARY?

Tip: The report is only as good as the payees on your entries. Choose the vendor on every bill and expense entry so the spending is counted against the right name.

Using it for 1099s

One Church Software does not track which vendors need a 1099. To prepare 1099s, run this report for the calendar year, export it, and check it against your own list of 1099 vendors. See How do I manage 1099s for a business?

Report options

Click additional options below the Date Range, make your changes, click Done, then click Refresh.

  • Accounting Method - Accrual counts a bill on its bill date. Cash Basis counts it when it is paid. See What is the difference between cash and accrual accounting?

  • Group By - None, Tag, Days, Weeks, Months, Quarters or Years. Choose Months to see each vendor's spending month by month.

  • Comparison - adds Previous period (PP), Previous year (PY), % of row or % of column.

  • Funds - All, or Specific to choose the funds to include.

  • Options - Include draft entries? adds entries that have not been posted yet.

  • Formatting - Don't show zero amounts and Color negative numbers in red. Both are on by default.

To download the report as a PDF or CSV file, see How do I export an accounting report?

Other Helpful Articles

Did this answer your question?