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.