¶ Report Categories
Report Categories in Tangilla are updated as new report categories are required and not all users will see every Report Category. Every Report Category contains one or more report filters or "report generators." See examples below.
¶ Report Generation (Running A Report)
To generate a new report, click on the - - icon next to the report generator you'd like to edit. This will cause the "Run Report" window to slide out from the left side of the specific Report Category dashboard.
Every Report Category can contain multiple report generators, and each report generator has a custom set of selectable items that can be configured when present. Each of these operate in the same way. In the example below, clickin on the "General Ledger" button will reveal which general ledger or ledgers you wish to include in the report.
Double-click on any of the options in the "Available" column and they will transfer to the "Selected" column. You may also drag from the Available column to the Selected column. Once you've made all of your selections, hit save.
New options for filtering will appear as you progress through the report creation process and you will follow the same steps for each option. Once you have chosen all of your filters, date ranges and output formats (CSV or Screen), you can either run the report or save the report. If your output format is "CSV," your CSV will immediately download when you hit run.
If your output format is "Screen," a window with the report will pop up and you will be able to navigate through the report, search and reorder columns immediately in your browser. You will also be able to print (to a printer or to PDF, download a CSV or download HTML. These options will be located at the top right of the page.
¶ HTML Reports
Downloading an HTML report is a great way to share a report. This allows you to forward the report.html file (you may, of course, rename the file if you wish) to anyone you would like to see the report and it will function with the same controls as the screen output. HTML reports are active reports and draw from live data. Here is a simple report example: simple_report.html
¶ Operations Reports
Operations reports are designed to monitor and evaluate the effectiveness and efficiency of the several operations elements and to assist you in making informed decisions based on the data presented in the reports.There are several report types that may appear based on the configuration of your Tangilla environment.
¶ 3rd Party API Transaction Report
The purpose of the third party API integration report is to provide an overview of the integration between Tangilla and specific entities, like your MLS, which may be integrated with out API. It will show specific API calls (messages) and their outcomes (response and response code).
¶ API Response Codes
RESTful API response codes are standardized HTTP status codes used to indicate the outcome of an API request. We show you these response codes in the 3rd Party API Transaction report for each call made to an API. These codes are divided into various categories based on the nature of the response. Here are some of the most common ones:
-
2xx Success
-- 200 OK: Successful request and response.
-- 201 Created: A new resource has been successfully created.
-- 204 No Content: The request was successful, but there's no content to send back. -
3xx Redirection
-- 301 Moved Permanently: The resource has been moved to a new URL permanently.
-- 304 Not Modified: Indicates that the resource has not been modified since the last request. -
4xx Client Error
-- 400 Bad Request: The server cannot process the request due to a client error.
-- 401 Unauthorized: Authentication is required and has failed or has not been provided.
-- 403 Forbidden: The client does not have permission to access the requested resource.
-- 404 Not Found: The requested resource could not be found.
-- 405 Method Not Allowed: The request method is not supported for the requested resource. -
5xx Server Error
-- 500 Internal Server Error: A generic error message when the server encounters an unexpected condition.
-- 502 Bad Gateway: The server received an invalid response from the upstream server.
-- 503 Service Unavailable: The server is currently unavailable (overloaded or down).
¶ Recent 3rd Party API Transactions for a 3rd Party Service
This report will show you the last 25, 50, 100 or 200 API transactions (calls) for any of the services available for you to see. The services available to you will be listed in the "3rd Pary Service" dropdown and may include M1, your MLS, your Lockbox service, and other integrations.
As with the 3rd Pary API Transaction Report that can be run on an individual or company, this will include the message we send, the response and the response code.
¶ SSO Activation Status Report
The SSO Activation report is available to Tangilla SSO clients for the 30 days after the launch of the SSO. The report logs for SSO activation are kept for 30 days, so you can track and encourage adoption. After 30 days, this report will no longer be valid.
¶ Report Categories List
- My Favorites
- Accounting (Available for third-party accounting firms or upon request)
- Committees
- Communications
- Data Feeds
- Education
- Events
- Finance
- Forms
- Members
- Offices
- Operations
- RPAC/Foundation
- Segments
- Subscriptions
- Texas (State Reports)
- Saved Reports
- Shared Feeds
- Reports Inbox
¶ Report Category Details
This list will be updated form time to time to reflecct the currently available reports. Some state reports are unique to the State product and will not appear for all users.
¶ My Favorites
- This section contains reports that a user has marked as favorites. It is the default menu when you land in Reports.
- You can remove a report from your favorites by navigating to the Report Category the where the report is located and unchecking the save box on the left hand side of the report.
¶ Accounting
These reports were requested by and designed for third-party accounting firms. Most of these reports are what we call "Requested Reports."
Requested Reports will run in the background and once completed will be available in the [Reports Inbox] section. The Requested Report will be sent via email as well.
- AR By Member - Shows each member’s outstanding accounts-receivable balance so you know exactly who owes what.
- AR By Revenue Product – Detail (Requested Report)
- AR By Revenue Product – Summary (Requested Report)
- Deferred Revenue by Class/Event/Tag (Requested Report)
- Invoices by Tag (Requested Report)
- Invoices Created – Detail (Requested Report)
- Invoices Created – Summary (Requested Report)
- Payments by Product – Detail (Requested Report)
- Payments by Product – Summary (Requested Report)
- Payments by Payment Types (Requested Report)
- Course Revenue (Requested Report)
- State/National Dues in Transit – Summary (Requested Report)
¶ Committees
- Committee Applications for a Period
- Committee Members (Position, Year)
- Committee Meeting Attendance
- Member Committee History
- Committee Information
¶ Communications
- Channel Opt-outs
- Email Performance
- People Suppression List
¶ Data Feeds
- Active Member Roster
- CasePro Data Feed
- Forewarn Data Feed
- Forewarn REALTORS Members Feed
- Noterouter Data Feed
- Open Invoices Data Feed
- Product Catalog Data Feed
- RESO MLS Member Roster
- RESO MLS Office Roster
- ShowingTime Office
- ShowingTime Roster
- Website Roster Feed
¶ Education
- Bundle Purchases
- Class No Show Report
- Outstanding Code of Ethics
- Outstanding Course Requirements
- Course Revenue
- RSVPs by Event/Class
¶ Events
- Closed Events
- Late Cancellations and No Shows by Class/Event
- Event Revenue
¶ Finance
- Ad-Hoc Invoice Aging
- Ad-Hoc AR by Income Account
- Ad-Hoc, Batch and Sponsorship Invoices for a Date Period
- Unpaid Bill Run Invoices
- Autopay Opt-ins
- Bill Run Auto Pay Invoices
- Bill Run Fees by Bill Type
- Draft Bill Run Invoices
- Bill Run Payments by Day
- Bill Run Receivables
- Suspended People for Non-payment of Bill Run Invoices
- Credit Request Report
¶ Forms
- Form Responses Report
¶ Members
- Member Counts
- Active Affiliate Roster
- Active Members with Unpaid Bill Run Invoices
- Duplicate Emails
- Get Designated Realtors
- Languages Spoken
- Inactive/Invalid Licenses
- Member Notes
- Get Primary Members by Orientation Date
- Membership Events, Classes and Contributions
- REALTORS where License Number in M1 Record Is Invalid
- Non-Member Licensee Payments for a Bill Year
- COE Suspended Members with Unpaid Bill Run Invoices
- Pending Amendments
- Incidents in Grace Period
- Secondary Membership Counts
- System Member Notes
- Unreported Licensees
¶ Offices
- Get New Offices from a Join Date
- Non-Member Salespeople Counts for Active Offices
- Office Roster with Subscription Status
- Offices with Corporate Structure Issues
- Corporate Structure Information from M1
- Corporate Structure Details
- Offices with Inactive DR
- Offices with Invalid DL
- Primary Offices with No Active Relationships
- Offices with RESO Office Type Issues
- Small Offices
- Top Offices
¶ Operations
- 3rd Party API Transactions
- Unresolved Tangilla Support Tickets
- NRDS Errors (No longer supported)
- Recent 3rd Party API Transactions for a 3rd Party Service
¶ RPAC/Foundation
- Campaign Finance Details (Local Only)
- Contributions Summary/Detail (Local Only)
- Last 5 Years Contribution History for a Segment (State Only)
- Aristotle Export (State Only)
- TREPAC Board Performance Report (State Only)
- TREPAC Investments with Missing Member Data (State Only)
- TREPAC Investor Detail Report (State Only)
- TREPAC Hall of Fame Watchlist (State Only)
- TREPAC Investment Summary by Board (State Only)
- TREPAC Summary Report (State Only)
- Unfulfilled Pledges (State Only)
¶ Segments
- Segment Report
¶ Subscriptions
- Association Subscriptions Summary/Detail
- Key Services Subscriptions
- Key Services Requiring Provisioning
- MLS Incompatible Subscriptions (Requested Report)
- Multiple Non-terminated MLS Subscriptions
- MLS User Class Overrides
- MLS Subscriptions Summary/Detail
- Subscription Report
¶ Texas Reports
- Abandoned Agents
- Active Members by Association
- Active Members With Invalid/Inactive/Expired Licenses Summary
- Active Unpaid Members – Detail (Requested Report)
- Active Unpaid Members Summary
- Posting Batch Subledger Detailed Report
- Emeritus Members
- LFRO Status
- Life Members
- TR Magazine Mailing List
- Members with Potential Orphaned Secondary Record
- Agents with Terminated Flag Set
- Unallocated Payment Items
- Under/Over Payment Items
¶ Saved Reports
- Any saved reports will appear here.
¶ Shared Feeds
- Any shared data feeds will appear here.
¶ Reports Inbox
- This is where your "Requested Reports" will appear. These are reports that take a long time to run and have the risk of timing out if they are run in the browser. These are run in the cloud and you are notified when complete.