Receivables Analysis in Power BI: From Debt Ageing to Collection
How to track customer and supplier debts, ageing buckets, collection speed and sales channels in Power BI when the data flows in automatically from Rivilė or Finvalda.
Read the articleArticles for managers, finance teams and accountants: which numbers to watch, how to read the reports, and how to turn Rivilė, Finvalda or R-Keeper data into decisions.
How to track customer and supplier debts, ageing buckets, collection speed and sales channels in Power BI when the data flows in automatically from Rivilė or Finvalda.
Read the article
How to track customer and supplier debts, ageing buckets, collection speed and sales channels in Power BI when the data flows in automatically from Rivilė or Finvalda.
9 min read
How to build a restaurant profit and loss report in Power BI: which KPIs to show, where to get the data and how to keep it up to date without manual work.
9 min read
How to build a supply forecast in Power BI from Rivilė or Finvalda data: the data you need, the steps, a DAX example, accuracy checks and automatic refresh.
7 min read
How to connect Finvalda and your CRM: what data to transfer, how the FVS API works, how to test the integration and turn the data into automated Power BI reports.
10 min read
How to connect the Rivile ERP API to Power BI: data sources, the API key, step-by-step setup, refresh limits and ready-made report packages.
9 min read
How to add Power BI reports to Microsoft Teams, which licences you need, and how to make sure your team always sees the latest figures.
10 min read
How to prepare a warehouse stocktake with Power BI: which Rivilė or Finvalda data you need, which KPIs matter and where mistakes are most often made.
10 min read
How to connect Rivilė data from Firebird or the Rivilė ERP API to Power BI: drivers, step-by-step setup, automatic refresh, security and common errors.
9 min read
How to move Rivilė and Finvalda data into Power BI on a regular schedule: what data is available, the steps involved, refresh, security and ready-made report packages.
9 min read
How to run horizontal analysis of financial statements in Power BI: absolute and percentage change, DAX formulas, visuals and automatic refresh.
9 min read
Parameterised Power BI reports: what Power Query parameters are, how to create them, use them in queries, change them after publishing and avoid errors.
10 min read
What a data catalogue is in Power BI, what to document in it, how to link Rivilė, Finvalda, Excel and SharePoint data, and how to manage access.
10 min read
How Power BI push and streaming datasets differ, how to connect Event Hubs, which limits apply and what changes by 31 October 2027.
10 min read
How DAX time intelligence works: the date table, TOTALYTD, SAMEPERIODLASTYEAR and DATEADD, sample measures, and common mistakes and how to fix them in Power BI.
10 min read
What Power BI data lineage is, how to open lineage view, which permissions you need and how to use it to check your accounting reports.
11 min read
How to connect HubSpot to Power BI: connector or API, authentication, pagination, scheduled refresh and the most common errors. A practical guide.
9 min read
How to build a cash flow forecast: the data you need, a worked example, Lithuanian tax deadlines and how to track the forecast in Power BI with Rivilė or Finvalda.
10 min read
Power BI implementation step by step: preparation, connecting data, the model, reports, publishing and maintenance. Includes an example implementation plan.
9 min read
Where to find Power BI audit logs in the Purview portal, which permissions you need, how to export records, how long they are retained and how to put them to work.
9 min read
How to analyse supplier SLAs: which metrics to track, how to calculate them, how to set targets and how to build an SLA report in Power BI that refreshes automatically.
11 min read
Star schema in Power BI: how to separate fact and dimension tables, build a model from accounting data and when to choose a snowflake schema instead.
10 min read
How to run cohort analysis in Power BI: the data you need, DAX formulas, a retention matrix, revenue cohorts and the most common mistakes.
9 min read
How to publish a Power BI report publicly: requirements, steps, embedding in a website, refresh, risks and secure alternatives for company data.
10 min read
How to build a reliable sales forecast in Power BI: the date table, Forecast settings, DAX measures, rolling forecasts and checking accuracy.
7 min read
How to turn on versioning in a SharePoint library, choose major or minor versions, view the version history and restore an earlier version of a file.
9 min read
Power BI governance without the confusion: content management strategies, roles, workspaces, RLS, sensitivity labels and rollout steps for small and mid-sized companies.
10 min read
How to move Rivilė data into Excel and Power BI: export and API routes, data preparation, automatic refresh, access control and pricing.
10 min read
Consolidated financial statements under Lithuania's 2024 law: who must prepare them, the exemptions, what the set includes, the consolidation steps, a worked example and deadlines.
10 min read
How to track project budgets in Power BI: plan and actual metrics, data from Rivilė and Finvalda, variance analysis and a six-step rollout.
10 min read
How incremental refresh works in Power BI: RangeStart and RangeEnd, the refresh policy, licences and the most common mistakes when working with accounting data.
9 min read
How to connect a Finvalda SQL database to Power BI: the SQL connection, data gateway, refresh limits and the most common mistakes. A practical guide.
9 min read
How to connect Dynamics 365 to Power BI: connection methods, licences, security, common mistakes and how to combine CRM data with Rivilė or Finvalda accounting.
11 min read
How to bring Finvalda data into Power BI via the API: protocols, authentication, ETL, gateway and automatic refresh. Three routes and what each costs.
9 min read
How to turn Rivilė and Finvalda data into accounting reports in Power BI: which reports to automate, the data gateway, licences, security and pricing.
10 min read
How automatic report refresh works in Power BI: licence limits, the data gateway, the most common failures and practical steps for Rivilė and Finvalda users.
10 min read
Learn how to segment B2B customers by needs, behaviour and firmographics, combine your data sources, tailor your offers and track the right KPIs.
15 min read
Learn how to analyse logistics routes in Power BI: prepare coordinates, build the point sequence and animate journeys on an Azure Maps map.
9 min read
Learn how route analysis compares scenarios by capacity, time windows and cost so you can reduce delivery times, transport spending and emissions.
8 min read
Learn how to account for exchange rate changes: apply the right transaction-date and period-end rates, measure the differences and disclose them properly.
10 min read
Learn how to combine subcontractor purchases, costs and hours in Power BI reports, automate data refresh and spot risks sooner.
9 min read
A financial control dashboard lets you track revenue, costs and profit in real time, compare key figures and make business decisions faster.
11 min read
Analyse food cost using actual yield, ingredient prices, labour time and overheads, and learn how to calculate it accurately.
10 min read
Automate purchasing reports from Rivilė or Finvalda data in Power BI. Track spending, suppliers and costs without manual work.
9 min read
Learn how to assess project profitability using discounted cash flows, NPV and IRR, and how to use ROI and the payback period as an initial screening filter.
9 min read
Choose Import for fast, standalone reports; choose DirectQuery when you need near real-time figures and cannot keep copies of the data.
10 min read
Learn how to prepare a supply chain report, from the materiality assessment to Scope 3 emissions, traceability and an automated data template.
13 min read
Revenue and cost analysis shows where a company earns and where it loses money, and sets out the metrics and workflow for monthly or quarterly reporting.
9 min read
Find out how to share data through Power BI: when to use the Share dialog, an app or a workspace, which licences you need and how to keep your data secure.
9 min read
Restaurant sales analysis helps you track food and drink costs, find where margin is being lost and adjust prices within a few days.
15 min read
Learn how a data model built for the financial sector standardises business terms, improves data quality and automates regulatory reporting.
9 min read
Learn labour cost analysis: turn employee costs into a cost per hour worked, compare departments and make decisions based on data rather than instinct.
15 min read
When analysing transport costs, start with a single route, set 3–5 key metrics, connect telematics and find your first savings within a week.
8 min read
SharePoint document reports in Power BI sync SharePoint and OneDrive data automatically with Rivilė or Finvalda, so finance managers can track revenue, costs and profit from a single source without manual work.
9 min read
Controlling construction costs means a two-stage budget, real-time data and variance analysis. Here are the practical steps.
9 min read
Standardised reports bring KPIs into line and automate Power BI refreshes from accounting systems, so managers can make decisions quickly.
14 min read
Learn how to build static, snapshot or dynamic ABC analysis in Power BI, with a DAX model, the KPIs that matter and a pre-handover checklist.
7 min read
How to make Power BI GDPR compliant: a documented risk assessment, row-level security, workspace management and a Purview audit trail.
13 min read
Mobile reports connected to Rivilė or Finvalda show revenue, profit and inventory, with data refreshing up to 48 times a day.
11 min read
Financial KPIs let you base decisions on facts: start with EBITDA and ROA, set SMART targets and automate the monitoring.
9 min read
Power BI lets you model a sales funnel quickly and, using the funnel chart and weighted pipeline value, pinpoint where opportunities stall.
10 min read
With Finvalda, debt management runs itself: the system sends reminders, generates reconciliation statements, exports documents and hands cases over to Teisininkas.pro.
12 min read
Learn how to record documents and prices correctly in Rivilė's sales module: a step-by-step guide to the price hierarchy, the "Pirminis Dok. Nr." field and posting to the general ledger.
12 min read
Set up three-layer data quality monitoring in Power BI, covering Power Query profiling, semantic model audits and automated alerts, so that errors are caught before your users spot them.
11 min read
Find out how Rivilė MSCAN enables mobile goods receipt, picking and location management, with data synchronised in real time with Rivilė GAMA.
14 min read
Learn how Finvalda's warehouse module brings stock operations together and lets you manage an unlimited number of warehouses, so you can reduce errors.
10 min read
How to build a reliable budget vs actual report in Power BI: net change, budget amount, variance %, drill-down to account level and a data-through date.
9 min read
Learn how to find, view and export Finvalda warehouse reports, including stock balances, stock movements, write-offs and stocktakes, and how to automate them with Power BI.
15 min read
Learn how to automate Finvalda sales analysis with Power BI through Analitika360 and get the key management metrics you need in real time.
8 min read
Learn how to prepare a Finvalda profit and loss statement: review account mappings, check your Finance PRO settings and compare the lines against the VAS template.
11 min read
Cash flow analysis in Power BI gives you a real-time view of cash, automatic forecasts and integration with Rivilė or Finvalda. Here is how to put it in place.
10 min read
Finvalda balance sheet analysis in practice: learn how to calculate liquidity, leverage and turnover ratios, which errors to avoid, and how to automate it all in Power BI with Analitika360.
13 min read
How to set up Power BI scheduled refresh: licence limits (up to 8 refreshes a day on Pro), on-premises data gateway requirements, best practice and the REST API.
9 min read
Automated board reports in Power BI give the board a real-time financial overview without manual data entry, with a pilot version ready within a few weeks.
12 min read
Subscription Power BI reports give managers an up-to-date financial overview and save the accountant's time. Here is how to assess a package, what licensing costs to plan for and how to get started.
13 min read
A practical guide for managers in Lithuania: what Rivilė or Finvalda with Power BI delivers, the ready-made Basic/PRO packages, pricing and how to get started.
8 min read
A practical guide for accountants using Finvalda sales: four Excel import steps, keeping reservations under control and Analitika360 integration.
9 min read
A practical, step-by-step guide for accountants in Lithuania: how to produce accurate debt reports in Rivilė and take them further with Power BI.
8 min read
A practical Rivilė guide for accountants: five steps to the profit and loss report, the key settings, the most common errors and integration with Power BI and Analitika360.
13 min read
Find out how to automate small business reporting within a few weeks, from Rivilė and Finvalda integration to Analitika360 packages and a fast start.
11 min read
A plan for companies in Lithuania: prepare your Rivilė sales data, connect it to Power BI and get automated reports up and running quickly.
8 min read
A practical guide for companies in Lithuania: prepare your Finvalda data, switch on automatic reminders in 1–2 weeks and integrate with Power BI.
11 min read
A practical checklist for producing the balance sheet in Rivilė: which parameters and account mappings to check, how to export the report and which mistakes to avoid before year-end.
8 min read
A practical guide for warehouse managers: where to find and run reports in Rivilė, how to export them and how to automate the transfer to Power BI.
8 min read
Practical tips for accountants in Lithuania: get your Rivilė GAMA debt settings in order, avoid errors and automate your analysis with Analitika360.
12 min read
A practical guide for finance and IT managers in Lithuania: the five implementation stages, architecture options, the infrastructure you need, the KPIs that matter and how Analitika360 can help.
9 min read
A practical plan for IT leaders: enable MFA, audit row-level security and apply sensitivity labels. Inside: the rollout sequence and what Microsoft's guidance recommends.
10 min read
A phased plan for managers: how data quality and Power BI solutions make real-time reporting pay for itself.
9 min read
Find out how a Power BI data warehouse improves report accuracy and speed by bringing different data sources together into a single system.
13 min read
A Power BI guide for Lithuanian companies: DAX formulas, monthly snapshots versus movement facts, and an Analitika360 implementation example, so that turnover metrics lead to real decisions.
9 min read
Protect your data with row-level security in Power BI and databases. Learn the key points of implementing and testing it.
9 min read
Learn how to prepare CFO reports properly and how they help you make decisions faster and manage cash flow.
13 min read
Learn how the Power BI data gateway provides a secure link to the cloud and how to set it up easily so you get the most out of your data.
10 min read
Use Power BI reports on your SharePoint page to keep staff better informed and improve collaboration. Find out how!
14 min read
Learn how CRM and Power BI integration turns your data into interactive reports that sharpen business decisions.
9 min read
The budget lives in Excel, the actuals sit in the accounting system, and the two meet once a quarter. Here is how to bring them together and see variances every month.
3 min read
Several companies, several accounting databases, and management sees the result two weeks later in Excel. How to bring group data into one report, and what not to overlook.
4 min read
The profit and loss statement shows a profit, yet the bank account is empty. Where the money goes, how to calculate the working capital cycle and what to do about it.
4 min read
Before connecting your accounting data to an analytics system, it is fair to ask about security. Here is how the connection, access rights and the VPN options work.
4 min read
A ready-made package goes live in days for a monthly fee; a bespoke project is built around your needs. Here is how to work out which one suits you.
3 min read
Manual reports eat up several days a month and invite errors. Four practical steps for moving to automated reporting without breaking anything along the way.
3 min read
R-Keeper collects all of a restaurant's data, but its reports don't make it visible. Which metrics are worth tracking for a restaurant or café chain, and what they reveal in practice.
4 min read
A Power BI implementation with a ready-built package takes a few days; a bespoke project takes weeks. Here is what drives the timeline and how much involvement is needed from your side.
4 min read
Excel isn't a bad tool; it's simply meant for a different job. We look at where Excel reaches its limits and the signs that tell you it's time to move to Power BI.
3 min read
An annual report shows what has already happened. These five metrics show what is happening now, and they are worth reviewing every week, not every quarter.
4 min read
The cost of Power BI has two parts: Microsoft licences and report development. We explain what each part costs and when a ready-built package works out cheaper.
4 min read
You can see your Finvalda data in Power BI reports that refresh automatically. Here is what changes in an accountant's work and which reports you get.
3 min read
Rivilė data can be connected to Power BI in a few days. We explain what your company needs to provide, how the connection works and which reports you get straight away.
4 min read
Business intelligence isn't for everyone, and not at every stage. We set out the specific signs that a company is already missing it, and what it delivers in practice.
4 min read
Power BI and Qlik solve the same problem, but in different ways. How they really differ on cost, learning curve and integrations, and when each one is the right choice.
3 min read
Power BI is Microsoft's business analytics platform: it gathers data from your accounting and other systems and turns it into reports that update themselves. We explain how it works and how it differs from Excel.
4 min read
The summary report brings a company's key figures together on one screen: revenue, costs, profit, margin, liquidity and a comparison with last year.
3 min read
The revenue report shows income month by month, compares it with last year and the budget, and lets you drill down from any total to an individual general ledger account.
3 min read
The cost report shows spending month by month, its breakdown by category and a comparison with budget and the previous year, with the option to drill into every figure.
3 min read
The profit report shows how gross, operating and net profit changed over a chosen period: month by month, year to date and by business unit.
3 min read
The variance report sets your chosen period against the same period last year and shows which ledger accounts changed the most, in euros and in percentages.
3 min read
The product report shows revenue, cost of sales, gross profit and margin for every product, so you can rank your range by profitability rather than turnover alone.
3 min read
The customer report shows sales for each customer, lists of new and lost customers, and payment discipline, so that customer management is grounded in data.
3 min read
This report shows late payments from your customers and your own late payments to suppliers: invoices, amounts and days overdue in one place.
3 min read
A profit and loss statement built on summary accounts, with every line open to drill-down and several years' results compared side by side.
3 min read
The debt report shows overdue receivables by how late they are (up to 30, 31–60, 61–90 and over 90 days), by customer and by sales manager.
3 min read
The report lets you set the slow-moving period in months and shows which items have not moved in that time, how much stock is left and when they were last purchased.
3 min read
The sales report shows sales after discounts, profit for the period, profitability, the number of invoices issued and the average invoice, broken down by product, department and sales manager.
3 min read
The balance sheet report shows the general ledger balance sheet by summary account, lets you drill into every line and compare several years side by side.
3 min read
Rivilė holds everything you need for analysis, but it delivers its reports as PDF and Excel files. Here are the Rivilė reports you can have automatically and what each one shows.
3 min read
Business analytics with Power BI means your accounting data turns itself into reports. What the system does, how it works in practice and when it pays for itself.
3 min read
Accounting software keeps data in good order, but it does not answer the questions a manager asks. Where the accounting system's capabilities end and what a business analytics system adds.
3 min read
Power BI has two parts: Power Query to prepare the data and Power BI to present it. How each one works and what that means in practice.
3 min read
Business data analytics does two jobs: it brings together data from unconnected systems and lets you present it clearly. How it works in practice and what correlations you can spot.
4 min readAnalitika360 builds Power BI reports from the data already in your accounting system — Rivilė, Finvalda or R-Keeper. They refresh automatically, from €59 a month.
See how companies like yours put Analitika360 reports to work in Power BI.