Skip to main content
Bank Accounts Template

Use this template to see your bank account balances and your transactions

Laszlo Molnar avatar
Written by Laszlo Molnar
Updated over 6 months ago

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.

Did this answer your question?