This template lets you easily see your bank account balances and transactions.
Test drive this template
You can click on the screenshots below to test drive the template with Demo Company data in Microsoft Power BI online.
Download the template
Click the button below to download the template.
Once downloaded, open the template in Microsoft Power BI Desktop and connect to your Connectorly database.
Key Tables
This template makes use of Bank Transactions, Journals and Account Views.
Description
The Connectorly Bank Accounts template provides a great understanding of financial health. It seamlessly integrates data from your connected bank accounts in Xero, offering a clear and insightful overview of:
1. Bank Account Balances:
View real-time balances for all your connected bank accounts in a single report.
Identify any discrepancies or potential issues quickly.
Track trends in your cash flow over time.
2. Transactions:
Analyze all your bank transactions in detail, including:
Date and time of transaction
Description of the transaction
Amount (inflow or outflow)
Category (e.g., Salaries, Rent, Supplies)
Payee/Payer information (if available)
Easily filter and search transactions to find specific details.
Understand the flow of money in and out of your accounts.
3. Balance Sheet Integration:
Provides a holistic view of your assets, liabilities, and equity, alongside your bank account balances.
Gain a deeper understanding of your overall financial position.