Detailed Account Activity Report
The Detailed Account Activity report lists every transaction across all of your ledgers for a chosen date range, including tenancy, owner, contractor, suspense, deposit and agency ledgers. It's useful for tracking down a missing or misallocated payment without opening each ledger one at a time.
To get started head to Reporting > Accounting > Detailed Account Activity.
Note - To access this report you will need a role with the permission 'Allow this user to manage client accounting' enabled.
For more information, see our Roles and Permissions help article.
What the report shows
Each row is a transaction, with the following columns:
Date - the accounting date or date entered, depending on your filter.
Type - Receipt, Charge, Payment or Journal.
Reference and Description.
Posted to - the ledger the transaction was posted to.
Created by - the person who raised the entry.
Ledger type and Amount.
Click on any row to see every ledger that transaction touched. For example, a rent receipt will show the charge it paid, the owner's income and the agency fee together, so you can follow the full trail in one place.
Bulk payment runs show as a single 'Bulk payment run' row, with each beneficiary listed inside it when you open it.
Filtering the report
You can narrow down the report using the following filters:
Date - the date range to report on. This defaults to the last 7 days and can cover up to 12 months.
Date range applies to - choose between Accounting date and Date entered.
Type - Receipt, Charge, Payment and/or Journal.
Branch - one or more branches.
Ledger group - Tenant deposits, Tenancies, Owners, Portfolios, Contractors, Agency, Suspense or Bank accounts.
Ledger - search for and select up to 16 specific ledgers.
Show voided entries - tick to include voided transactions.
Tip! - Looking for a missing payment? Set the date range around when it was received, filter the Type to Receipt and search for the amount or reference, then click into the row to see where it was posted.
Exporting the report
The report can be exported to CSV, including every payment line within bulk payment runs.
Street is constantly being updated. This can mean that some of these articles become slightly out of date. If you spot something that looks a little bit different to your Street account, please let us know on the live chat so we can get it updated!