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. |