---
title: Using Financial Transactions, Chart of Accounts, and Hierarchies in Pereview Analytics
description: Using Financial Transactions, Chart of Accounts, and Hierarchies in Power BI
---
[Skip to content](https://academy.pereviewsoftware.com/knowledge-base/using-financial-transactions-chart-of-accounts-and-hierarchies-in-power-bi#main-content)
[](https://academy.pereviewsoftware.com/knowledge-base?hsLang=en)
Open main navigation
Close main navigation
How can we help you?
- There are no suggestions because the search field is empty.
1. [Pereview Knowledge Base](https://academy.pereviewsoftware.com/knowledge-base?hsLang=en)
2. [Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en)
3. [Pereview Analytics](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#pereview-analytics)
October 2, 2026
# Using Financial Transactions, Chart of Accounts, and Hierarchies in Pereview Analytics
In this video, we show how to build financial reports in Pereview Analytics by combining Pereview’s Financial Transactions, Chart of Accounts, and Hierarchy Detail tables.
You’ll learn how to use period activity and inception-to-date balance metrics in tandem with the Chart of Accounts to create reports that resemble a trial balance. The video demonstrates how to display account codes, descriptions, and types – either as separate fields or combined – while sorting and grouping financial data effectively.
We also dive into the financial hierarchies that enable dynamic drill-down capabilities across nine levels, allowing you to display and explore structured income statements or cash flow summaries. You'll see how sort order and prefix numbers help maintain the correct reporting sequence – even when data isn't present for every account – and how to choose between matrix-style reports with expandable subtotals or flat tables for listing detail lines only.
- [Pereview 101](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#main-content)
- [Navigation](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#navigation)
- [Add Records](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#add-records)
- [Support](https://academy.pereviewsoftware.com/knowledge-base/pereview-101?hsLang=en#support)
- [Product Features](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#main-content)
- [Workflow](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#workflow)
- [Custom Forms](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#custom-forms)
- [Updates and User Experience](https://academy.pereviewsoftware.com/knowledge-base/product-features?hsLang=en#updates-and-user-experience)
- [Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#main-content)
- [Formatted Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#formatted-reports)
- [Pereview Analytics](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#pereview-analytics)
- [Custom Forms Reports](https://academy.pereviewsoftware.com/knowledge-base/reports?hsLang=en#custom-forms-reports)
- [Data Validation](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#main-content)
- [Overview](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#overview)
- [Data Validation Process](https://academy.pereviewsoftware.com/knowledge-base/data-validation?hsLang=en#data-validation-process)
- [Data Ingestion & Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#main-content)
- [Data Management](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#data-management)
- [AI Data Mapping](https://academy.pereviewsoftware.com/knowledge-base/data-ingestion-management?hsLang=en#ai-data-mapping)
- [System Admin & Technical Documentation](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#main-content)
- [User Management](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#user-management)
- [Configuration Options](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#configuration-options)
- [Pereview Outbound API](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#pereview-outbound-api)
- [SSO](https://academy.pereviewsoftware.com/knowledge-base/system-admin-technical-documentation?hsLang=en#sso)
- [Pereview Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#main-content)
- [2026 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2026-newsletters)
- [2025 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2025-newsletters)
- [2024 Newsletters](https://academy.pereviewsoftware.com/knowledge-base/pereview-newsletters?hsLang=en#2024-newsletters)
[](http://pereviewsoftware.com)
12400 Coit Rd, Suite 570, Dallas, TX 75251
[mailto:support@pereviewsoftware.com](mailto:support@pereviewsoftware.com)
Copyright © 2026, Pereview Software
```json
{
"@context" : "https://schema.org",
"@type" : "VideoObject",
"caption" : {
"@type" : "MediaObject",
"contentUrl" : "https://academy.pereviewsoftware.com/media-transcripts/191603901231/en.vtt",
"inLanguage" : "en",
"name" : "en Captions"
},
"contentUrl" : "https://stream.mux.com/bG3tmBdU01WTdOxexXORy01ITgbINAJXmhUaHhasgRo00E/capped-1080p.mp4",
"dateModified" : "2025-08-26T19:26:01.264Z",
"duration" : "PT14M23.055S",
"height" : 1080,
"name" : "Power BI Financial Transactions, Hierarchies, Chart of Accounts - Video",
"thumbnailUrl" : "https://20496164.fs1.hubspotusercontent-na1.net/hubfs/20496164/Power%20BI%20Financial%20Transactions%2c%20Hierarchies%2c%20Chart%20of%20Accounts%20-%20Video.mp4/medium.jpg",
"uploadDate" : "2025-06-20T16:38:33.294Z",
"width" : 1920
}
```