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. Follow these steps: Access Contribution Statements Go to the Finance menu. Select Contribution Statements. Selecting a Date Range Choose the date ...
      • Recent Articles

      • How to Enter Donations from Organizations or Companies in SteepleMate

        If your church receives contributions from organizations or businesses, you can track those donations in Offering Management just like you would for individual members or guests. This article will walk you through how to properly enable and record ...
      • Troubleshooting a Black Screen on SteepleMate Billboard

        If your SteepleMate Billboard screen goes black or stops cycling through slides, it's possible that more than one instance of the Billboard app is running. This can cause conflicts or prevent the display from working as expected. Step-by-Step Fix Use ...
      • Managing Web Kiosk Submissions

        Audience: Church administrators using SteepleMate Free Focus: Reviewing and managing prayer requests, testimonies, and messages submitted through the Web Kiosk What Can Church Members Do? From the Web Kiosk, members can: Sign In for Prayer or Fasting ...
      • Viewing Account Payments and Receipts in SteepleMate

        If you’re looking to view payment history, download receipts, or manage payment methods for your SteepleMate subscriptions and add-ons, this guide will walk you through the process. Access Requirements: You must be logged in as a Super User or ...
      • Export Contribution Statements in SteepleMate

        This guide will walk you through exporting contribution statements to PDF, XLSX, and image formats. While multiple file types are available, PDF and image formats are the most commonly used. Before You Begin Before exporting, ensure you have ...