Skip to main content

Deposit Transactions Report

Run the Deposit Summary or Deposit Detail report in DoorLoop to see bank deposits and which tenant payments make up each one.

Written by Samuel

Overview

You might receive a bank deposit into your bank account from our payment processor, Stripe, that includes multiple tenant payments at once. This happens because if you receive multiple online payments that complete the ePay funding cycle on the same day, Stripe sends them all to you as one bank deposit.

DoorLoop automatically creates this bank deposit for you, clearly showing which tenant payments make up the ePay deposit.

DoorLoop offers two separate deposit reports, found under Reports:

  • Deposit Summary — shows one row per bank deposit, with the total amount.

  • Deposit Detail — shows each deposit broken down into its individual payments

Note: Only deposits that have been fully recorded — meaning a charge posted and a payment or credit applied — appear on these reports. Owner-held deposits don't appear here, by design. If a deposit is missing, see Why Doesn't My Security Deposit Show on the Lease, Statement, or Deposits Tab?

The Steps

Deposit Summary

  1. To view the Deposit Summary report, click Reports on the main menu. Search and click on the Deposit Summary report under the Banking & Reconciliation section.

  2. By default, the report shows deposits made this month. Use the date range filter to select a different time period.

  3. Use the filter bar to narrow down the report:

    • Search, Account, Portfolio, Property, Owner — Filter down to specific records.

    • More filters — Click this to reveal additional filters: Reference, Unit, Lease, Vendor, Tenant.

    • Grouping — Choose No grouping, By account, By property, By name, or By date.

  4. By default, the report shows the following columns:

    • Date — The date the deposit was made.

    • Deposit account — The bank account the funds were deposited into.

    • Property — The property associated with the deposit.

    • Name — The tenant, vendor, or owner associated with the deposit.

    • Amount — The total amount of the deposit.

    Click the Columns button to also enable Description, Reference, Payment method, Unit, Lease, Deposit status, Split, Deposit date, and Deposit reference.

Deposit Detail

  1. To view the Deposit Detail report, click Reports on the main menu Search and click on the Deposit Detail report under the Banking & Reconciliation section.

  2. By default, the report shows deposits from the last 7 days. Use the date range filter to select a different time period.

  3. Use the filter bar to narrow down the report:

    • Portfolio, Property, Account, Payment method — Filter down to specific records.

    • More filters — Click this to reveal additional filters: Status, Unit, Tenant, Lease, Vendor, Owner, Reference.

    • Grouping — By default, the report groups the report by deposit, showing each deposit's individual payments nested underneath.

  4. By default, the report shows the following columns:

    • Payment date — The date the individual payment was made.

    • Deposit account — The bank account the funds were deposited into.

    • Property — The property associated with the payment.

    • Type — The type of transaction (e.g., Lease Payment, Line Item).

    • Received from — Who the payment came from.

    • Payment method — How the payment was made (e.g., Cash, ePay).

    • Amount — The amount of the individual payment.

    Click Columns to also enable Deposit date, Unit, Reference, Memo, Status, Category, Lease, Deposit reference, and Notes.

  5. Use Expand all or Collapse all to show or hide the individual payments under each deposit.

  6. Click each individual deposit line to view its full details, including all the tenant payments that make up that deposit.

Either report gives you visibility into your bank deposits and the tenant payments that make them up.

Tip: To see only security deposit activity (excluding pet deposits, last month's rent deposits, etc.), use the report's filters to narrow by deposit type or by the Security Deposit liability account.

Note: You won't be able to edit or delete bank deposits DoorLoop automatically created when tenant portal payments are deposited into your bank account. This prevents you from deleting deposits DoorLoop knows you received, and ensures your accounting and reports remain accurate.

Did this answer your question?