Cash Flow Power BI
1. Objective
Develop a Power BI report “Cash Flow (CF)” that collects data from multiple tables, calculates key metrics, and displays them for the selected period (day/week/month), with the ability to drill down by subcategory.
2. Data Sources
Regular Expenses: Date, Expense Category, Subcategory, Amount, Payment Description, Status, Norm, …
Irregular Expenses: same fields
Supplier Expenses: same fields
Transportation Services: same fields
Receipts: Date, Receipt Category, Subcategory, Amount, Description, Status, Norm, …
Balances: Date, Balance Type (Opening/Closing), Account, Account Type, Balance
All tables are available in a shared storage (CSV/Excel/SQL).
3. Data Model and Transformations
Import all tables into Power BI Desktop.
Ensure correct data types:
Date → Date
Amount → Decimal
Normalize field names and values: consistent casing, no extra spaces.
Append the four expense tables into a single table “AllExpenses.”
Append receipts into “AllReceipts.”
Build a single table “CF_RawData” by combining:
Rows from “AllExpenses” (tagged as Expense)
Rows from “AllReceipts” (tagged as Receipt)
Rows from “Balances” (using Balance Type = Opening/Closing)
Calendar table: create a Date dimension with Day, Week, Month, Quarter, Year fields.
5. Visualization
Matrix/Table with hierarchical rows:
Level 1: Period (Day/Week/Month)
Level 2: Category → Subcategory
Columns:
Opening Balance
Total Revenue
Total Receipts
Total Payments
Closing Balance
Slicers:
Period selector (Day/Week/Month)
Category/Subcategory filter
Status filter (Paid/Unpaid)
6. Conditional Formatting
Status ≠ “Paid” → red font in the Status column.
Norm = “NOT OK” → red cell border around the Norm column.
Use Power BI’s conditional formatting rules on the corresponding fields.
7. Subcategory Drill-Down
When drilling into Subcategory, aggregate all five metrics at the subcategory level.
Enable drill-down by clicking a Category to expand its Subcategories.
8. Non-Functional Requirements
Performance: report refresh time ≤ 10 seconds with 50 000 input rows.
Scalability: easy to add new expense or receipt tables with minimal model changes.
Documentation: include a README explaining all transformations, DAX measures, and visual configurations.
The project is very similar to https://freelancehunt.com/project/excel-financial-report/1515026.html but should be done in PowerBI
I forgot to include one thing in the requirements: there are only excel files that contain all the tables
-
2 days250 USD
405 2 days250 USDHi!
I’m very interested in your “Cash Flow” Power BI project. I have solid experience building financial dashboards that integrate data from multiple sources (CSV, Excel, SQL), perform advanced transformations in Power Query, and calculate DAX metrics for dynamic analysis
-
7 days200 USD
129 7 days200 USDHappy to create the dashboard following your detailed description. The data will be cleaned transformed and modelled according to the requirements. I’ll apply smart visuals and conditional formatting so insights are easy to spot at a glance. I’ll also provide clear documentation so you can maintain or expand it in the future with confidence.
I can start ASAP.
-
8 days700 USD
99 8 days700 USDHello,
I can build this so everything feels smooth and clear when you use it. The numbers will update fast, the layout will stay simple, and all the key totals will be right where you expect them. You'll be able to zoom into any category or subcategory without getting lost.
I'll set things up from the start. I build the model so that adding a new table later takes almost no effort. You won’t need to redo your setup or fix broken measures. It will just work.
I'll also include a small view that shows which tables were used, when they last updated, and if anything looks off. That way, you don’t have to wonder if something is missing.
If you send a sample, I can show you how the final report would look and feel before we begin. I'm ready when you are.
-
7 days600 USD
1117 4 0 7 days600 USDHeya! I can make this report feel really smooth to use, with all the numbers in one place and easy to explore by day, week, or month. I'll keep the layout clear so you don't have to search for anything, and I'll set it up in a way that's easy to grow later without redoing things. I'd also add a small touch, like flagging days where balances drop below a safe level, just so nothing gets missed. If you already have a folder with the files, I can start right away.
Current freelance projects in the category Data Parsing
Database of websites on WooCommerceIt is necessary to compile a database of Ukrainian online store websites on WooCommerce with the contact information provided on the sites. Only active websites (indicator: updated catalog/content, working domain) Table format - website address, phone number, e-mail. Data Parsing ∙ 1 day 13 hours back ∙ 20 proposals |
Create a dashboard in https://airtable.com/ for the performance of advertising creatives from Facebook ads.Full specification https://docs.google.com/document/d/1_n_oYRNZWYxalUA---DM5AD1b5ZSrtePw5J4G42svGw/edit?usp=sharing Databases & SQL, Data Parsing ∙ 3 days 3 hours back ∙ 17 proposals |
Creation of an Excel file for uploading products to the websites of other partners.I am interested in creating an Excel table with all parameters. Here is the website - https://heiztechnik.com.ua/ And the positions I am interested in to be transferred: Manual boilers: 1) TIS UNI 15-95 kW (10) pcs 2)TIS HARD 150-500 kW (7) pcs Pellet boilers: 1)TIS PELLET… Data Parsing ∙ 3 days 7 hours back ∙ 34 proposals |
A developer is required for parsing the catalog and automating data import.Detailed technical specifications in the attached document Please indicate the estimated cost and timeline in your response Do you have experience working with parsing large catalogs What possible difficulties or limitations do you see in this task Databases & SQL, Data Parsing ∙ 3 days 10 hours back ∙ 40 proposals |
Find a product feed (Google Merchant XML) for a website on OpenCart
16 USD
It is necessary to find a direct link to the active product feed (XML) of a competitor for Google Merchant Center Platform (CMS): OpenCart / ocStore Find the original feedRequirements for the result: Working link to the XML file Python, Data Parsing ∙ 3 days 15 hours back ∙ 24 proposals |
Almaty (Alma-Ata)