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 ...
      • How to View and Export the Giving Detail Report in SteepleMate

        The Giving Detail Report in SteepleMate provides a comprehensive overview of recent donations, categorized by your chosen criteria. This guide explains how to view, filter, and export the report, as well as how to manage duplicates and understand the ...
      • How to Pull the Payments Received Report in SteepleMate

        The Payments Received Report in SteepleMate provides an overview of recent donations and allows you to generate reports for specific time periods. You can also export this report in various formats (e.g., CSV, Excel) or print it directly. This is ...
      • 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. ? Watch the video below or follow the step-by-step instructions to learn how to generate contribution statements in SteepleMate. Access Contribution ...
      • Recent Articles

      • How to Use the Family Communications Report in SteepleMate

        The Family Communications report helps your church review communication activity for specific groups in the system. This is useful when you want to see communication history for ministries or group-based follow-up, such as children’s ministry, Bible ...
      • How to Use the Communicator Report in SteepleMate

        The Communicator Report in SteepleMate helps your church review communication activity over a selected period of time. This report shows recorded communication touchpoints and helps you understand how your team has been connecting with people through ...
      • How to Track Communications in SteepleMate

        SteepleMate allows your church to record communication activity on a person’s profile so your team can keep track of follow-up and care efforts. This is useful for documenting guest outreach, member care, meetings, phone calls, texts, emails, and ...
      • How to Manage Tasks in SteepleMate

        Tasks in SteepleMate help your team keep up with follow-up, office responsibilities, and ministry workflows. You can create tasks for yourself or assign them to other people in the system, set due dates, track progress, and review assigned work from ...
      • How to Add and Use Tags in SteepleMate

        Tags in SteepleMate help you organize records, quickly find the right people or families, and create reports based on shared labels. You can apply tags to an individual person or to an entire family, then use Tag Search to locate and export those ...