How to Generate and Export the Consolidated Deposits Report | SteepleMate Finance

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 analyze and track contributions with ease.

Step 1: Accessing the Consolidated Deposits Report

  • From the Finance menu, select Consolidated Deposits.
  • Choose the time period or define a specific date range, then click Search to generate the report.

Step 2: Understanding the Report

1. Deposit Breakdown by Fund

The Deposit Breakdown by Fund chart displays the total amount contributed to each fund category (e.g., Building Fund, Missions Fund) within the specified time period. This visual overview helps you quickly assess how much each fund has received.

2. Deposit Breakdown by Source

The Deposit Breakdown by Source chart shows the distribution of contributions by source, such as:

  • Cash
  • Check
  • Online
  • Other

This helps you understand the contribution channels and the volume of contributions through each method.

Step 3: Analyzing the Source and Fund Table

The table offers a detailed view of contributions by both source and fund. You can filter and sort the data, which includes:

  • Source and Amount: This column lists the type of source (e.g., cash, check) and the total amount contributed through each source.

  • Fund Rows: Each fund (e.g., Building Fund, General Fund) is displayed in its own row, with additional data on:

    • Source Type: The specific method used for the contribution (e.g., online, cash).
    • Amount Given by Source Type: The contribution amount associated with each source type.

Step 4: Printing and Exporting the Report

To print or export the report:

  • Use your browser’s Print function to print the page.
  • Alternatively, click Export (located above the table) and choose from available formats such as PDF, Excel, CSV, DOCX, or RTF.

Exporting Tip:

If you need to perform further analysis or share this data with others, exporting to Excel or CSV formats can be particularly useful for more detailed sorting and filtering.


      • Related Articles

      • 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 ...
      • 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 ...
      • 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 ...
      • Recent Articles

      • 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 ...
      • How to Send Emails in SteepleMate

        This guide will walk you through using the email features in SteepleMate, including sending messages to individuals and groups. Composing a New Email Navigate to the Email Composer From the left navigation menu, select Communicate > Send Messages. ...
      • I accidentally deleted someone's profile. What can I recover?

        Can a deleted profile be recovered? Unfortunately, due to compliance requirements, once a profile has been expunged in SteepleMate, it cannot be recovered. This action is permanent and irreversible. Is any data retained after deletion? While the ...
      • How to Expunge a Person’s Data in SteepleMate

        SteepleMate provides an option to permanently delete a person's data from the system. This action is designed to help comply with privacy laws such as the California Consumer Privacy Act (CCPA/CPRA) and the EU General Data Protection Regulation ...
      • How to Connect Your QuickBooks Account to SteepleMate

        SteepleMate is the only cloud-based church management system certified by Intuit, offering a direct integration with QuickBooks Online. This integration allows you to post journal entries for online giving and in-person offerings directly to ...