How to Generate and Export Deposits by Fund Report | SteepleMate Finance

How to Generate and Export Deposits by Fund Report

The "Deposits by Fund" report provides a detailed view of your financial transactions for a specific time period. This report includes two insightful charts and a detailed table, offering an easy-to-follow breakdown of deposits, fees, and more. You can filter, sort, and export the data to analyze your church’s financial activities efficiently.

Step 1: Accessing the Deposits by Fund Report

  • From the Finance menu, click on Deposits By Fund.
  • Select a time period or specify a custom date range, then click Search to generate the report.

Step 2: Understanding the Report

1. Net Deposit Analysis

The Net Deposit Analysis chart provides a visual representation of your net deposit as a percentage of your gross receipts. For example:
"Your gross receipts were $X, yielding a net deposit of $X. Your effective discount rate for credit card transactions was X%."

2. Deposit Trending Table

The table below provides a detailed breakdown of each transaction. You can sort and filter the following columns for better insight:

  • Batch Number
  • Number of Entries
  • Gross Amount
  • Per Transaction Amount
  • Discount Fees
  • Credits
  • Deposited Amount
  • Net Amount
  • Deposit Date
  • Transaction Number
  • Initiated Date
  • Donor's First and Last Name
  • Account Type (e.g., Checking, MasterCard)
  • Fund Deposited To
  • Transaction Type (e.g., -CK Pending, +CC)
  • Gross Amount
  • Transaction Fee
  • Discount Fee
  • Credit Amount
  • Deposited Amount
  • Net Amount

Step 3: Printing and Exporting the Report

To print or export the report:

  • Click the Print button in your browser to print the current page.
  • Alternatively, click Export (located above the table) and choose your preferred format from PDF, Excel, CSV, DOCX, or RTF.

Exporting Tip:

If you are preparing this data for sharing or further analysis, exporting to Excel or CSV may be ideal, allowing for more advanced sorting and filtering features.


      • Related Articles

      • How to Generate and Export the Consolidated Deposits Report

        The Consolidated Deposits Report provides a comprehensive view of your organization’s financial contributions, breaking them down by fund and source over a selected time period. This report includes two charts and a detailed table, enabling you to ...
      • Creating Absence Reports

        1. Click Reports on the main menu. 2. Click Absence Report on the dropdown menu. 3. Enter # of service months you want to include in your search (default is 3 months). 4. Click Church Attendees to generate church service attendance report or choose ...
      • How to Generate Contribution Statements in SteepleMate

        As a Finance Administrator, you can easily generate contribution statements for your church members. Follow these steps: Access Contribution Statements Go to the Finance menu. Select Contribution Statements. Selecting a Date Range Choose the date ...
      • How to Create and Manage Offerings in SteepleMate

        SteepleMate’s Offering Management feature helps you efficiently record and manage donations, both physical (cash and checks) and external payments from sources outside your merchant account. One of the core features in this system is the ability to ...
      • Generate Contribution Statements for Individual Family Members

        Learn how to generate contribution statements for individual family members using the SteepleMate Finance module. This guide provides a step-by-step process to ensure each family member receives their own contribution statement. 1. Navigate to the ...