Skip to main content
Bank Transactions

Full details on the Bank Transactions data available in Microsoft Power BI from Xero with Connectorly.

Laszlo Molnar avatar
Written by Laszlo Molnar
Updated over a week ago

Overview

Bank transactions in Xero refer to individual records of money flowing in and out of your connected bank accounts.

Forecasting with Bank Transactions

To simplify forecasting and budgeting, Connectorly automatically creates additional Bank Transaction entries (which can be filtered by Bank Transaction Status).

Forecast Invoice value created and added to the Actual Bank Transactions that come from Xero. The Bank Transaction Status field is used to distinguish them as follows:

Bank Transaction Status

Notes

AUTHORISED

Actual Bank Transaction

FORECAST INVOICE

These are calculated so that the effect of future REPEATING Invoices on forecasts and budgets can be seen.

Multi-Currency Xero Support

As well as providing the Amount values of the original Bank Transaction, values for your chosen Reporting Currency are calculated. These are signified by (RC) after their name.

If you are working with Xero Bank Transaction data from multiple organisations, use the Reporting Currency (RC) values for any calculations, to avoid adding amounts that are in different currencies.

Data Model

Field

Type

Notes

Amount

Number

The Amount in the base currency of the Xero Organisation.

Amount (RC)

Number

The Amount in the reporting currency.

Bank Account Code

Text

Bank account code in Xero

Bank Account Name

Text

Bank account name in Xero

Bank Currency Code

Text

The Bank Transaction currency

Bank Transaction Status

Text

{'AUTHORISED', 'FORECAST INVOICE'}

Credit Amount

Number

The Credit Amount in the base currency of the Xero Organisation.

Credit Amount (RC)

Number

The Credit Amount in the reporting currency.

Currency Code

Text

Connection Name

Text

The name of the Connection. Typically the name of the Xero Organisation.

Contact ID

Text

The Xero contact ID

Contact Name

Text

The Xero contact name

Data current as of

Datetime

When the Data was taken from Xero.

Debit Amount

Number

The Debit Amount in the base currency of the Xero Organisation.

Debit Amount (RC)

Number

The Debit Amount in the reporting currency.

Reference

Text

Reporting Currency Rate

Number

The FX Rate used to calculate the Reporting Currency Amounts. Rates are taken as the closing rates as reporting by the ECB on the bank transaction date.

Source Type

Text

{'ACCPAY', 'ACCPAYCREDIT', 'ACCPAYPAYMENT', 'ACCREC', 'ACCRECCREDIT', 'ACCRECPAYMENT', 'APCREDITPAYMENT', 'APOVERPAYMENT', 'APPREPAYMENT', 'ARCREDITPAYMENT', 'AROVERPAYMENT', 'CASHPAID', 'CASHREC', 'DIRECTCOSTS', 'EXPCLAIM', 'EXPPAYMENT', 'MANJOURNAL', 'OVERHEADS', 'SALES', 'TRANSFER'}

Transaction Date

Datetime

The date of the Bank Transaction.

Did this answer your question?