Overview
Journals are the heart of the accounting system, holding the details of all transactions against each account over time in the general ledger. They are used to build reports such as the Profit and Loss (aka Income) Statement, Balance Sheet and others.
Xero automatically creates Journal records for any transactions that are approved and are the heart of the accounting system, holding details of all transactions against each account over time.
Amounts are signed so that they can be summed to create totals. Positive amounts are income and negative amounts are used for expenses.
Unlike Invoices, they don't hold details of who was transacted with. They are complete, so expect to find Salary, Tax and other non-invoiced Financial information here.
Forecasting with Journals
To simplify forecasting and budgeting, Connectorly automatically creates additional Journal entries (which can be filtered by Journal Type).
Draft Invoice, Forecast Invoice, FX Exposure and Forecast Budget values are created and added to the Actual Journals that come from Xero. The Journal Type field is used to distinguish them as follows:
Journal Type | Notes |
ACTUAL | These are the Journals from Xero. |
DRAFT INVOICE | These are calculated so that the effect of DRAFT invoices on forecasts and budgets can be seen. These are invoices that you can see in DRAFT in Xero. |
FORECAST INVOICE | These are calculated so that the effect of future REPEATING Invoices on forecasts and budgets can be seen. |
FX EXPOSURE | Xero doesn't provide values for FX EXPOSURE through the API for: REALISED, UNREALISED AND REVALUATIONS. So these are calculated daily based on European Central Bank (ECB) FX rates.
A detailed description of the rates used in the calculations is provided in the Journal Description. |
FORECAST BUDGET | Forecast Budget amounts are calculated for the current month and future months, if the actuals are less than 25% of the Budget amount.
In this way, and particularly for the current month if you are tracking forecast against actuals, the budgeted amount will remain as a placeholder until actuals are available. |
Multi Currency Xero Support
As well as providing the Net, Tax and Gross values of the original Journal, values for your chosen Reporting Currency are calculated. These are signified by (RC) after their name.
If you are working with Xero Journal data from multiple organisations, use the Reporting Currency (RC) values for any calculations, to avoid adding amounts that are in different currencies.
Data Dictionary
Field | Type | Notes |
Account Code | Text | The Account Code for the Journal.\ne.g. 200 |
Account Name | Text | The corresponding Account Name.\ne.g. Sales\nIf want to report and link other sources of financial information (for example to link Budgets and Invoices data to compare actuals and forecasts) then use the linked Account Name field from the Accounts table. |
Account Type | Text | Account Type |
Connection Name | Text | The name of the Connection. Typically the name of the Xero Organisation. |
Contact ID | Text | The Contact ID associated with the Journal. Not all Journals have an associated Contact. |
Contact Name | Text | Name of the Contact associated with the Journal. Not all Journals have an associated Contact. |
Created | Text | When the Journal was created. |
Credit | Number | The amount credited (received or paid in) against the account for the Journal. |
Data current as of | Datetime | When the Data was taken from Xero. |
Debit | Number | The amount debited (spent or withdrawn) against the account for the Journal. |
Description | Text | The Journal Description.\n\n\nIn the case of the FX EXPOSURE entries, a detailed explanation is given for each Journal line to explain how it has been calculated. |
Gross Amount | Number | The Gross Amount (Net and Tax) in the base currency of the Xero Organisation. |
Gross Amount (RC) | Number | The Gross Amount (Net and Tax) in the Reporting Currency. You can safely sum use this value when you have multiple Xero Organisations in the same group, that have different base currencies. |
Journal Currency | Text | The 3 letter ISO currency code for the Currency the Journal is recorded in Xero. |
Journal Date | Text | The financial date of the Journal. Not the same as Created. |
Journal Number | Integer | For ACTUALS these are from Xero. DRAFT and FORECAST INVOICE Journal Numbers start from 800,000,000. FX EXPOSURE Journal Numbers start from 900,000,000 and FORECAST BUDGETS start from 910,000,000. Note these values are subject to change. |
Journal Type | Text | One of {'FORECAST INVOICE', 'ACTUAL', 'FX EXPOSURE', 'FORECAST BUDGET'}. |
Net Amount | Number | The Net Amount in the base currency of the Xero Organisation. |
Net Amount (RC) | Number | The Net Amount in the Reporting Currency. You can safely sum use this value when you have multiple Xero Organisations in the same group, that have different base currencies. |
Reference | Text | Reference |
Reporting Currency | Text | The 3 letter ISO currency code for the Reporting Currency. |
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 invoice date. |
Source ID | Text | e.g. in the case of Source Table of Invoice, the Invoice ID |
Source Table | Text | The source of the Journal entry. One of {'Bank Transactions', 'Bank Transfers', 'Budgets', 'Invoices', 'Overpayments', 'Payments', 'Prepayments'} |
Source Type | Text | {'ACCPAY', 'ACCPAYCREDIT', 'ACCPAYPAYMENT', 'ACCREC', 'ACCRECCREDIT', 'ACCRECPAYMENT', 'APCREDITPAYMENT', 'APOVERPAYMENT', 'APPREPAYMENT', 'ARCREDITPAYMENT', 'AROVERPAYMENT', 'CASHPAID', 'CASHREC', 'DIRECTCOSTS', 'EXPCLAIM', 'EXPPAYMENT', 'MANJOURNAL', 'OVERHEADS', 'SALES', 'TRANSFER'} |
Tax Amount | Number | The Tax Amount in the base currency of the Xero Organisation. |
Tax Amount (RC) | Number | The Tax Amount in the Reporting Currency. You can safely sum use this value when you have multiple Xero Organisations in the same group, that have different base currencies. |
Tax Type | Text | The Tax Type associated with the Tax Amount. E.g. One of (in the UK) {'ECZROUTPUTSERVICES', 'EXEMPTINPUT', 'EXEMPTOUTPUT', 'INPUT2', 'NONE', 'OUTPUT2', 'ZERORATEDOUTPUT'} |
Tracking Category 0 | Text | |
Tracking Category 1 | Text | |
Tracking Option 0 | Text | Tracking Options are concatenated with the Tracking Category e.g. '[Tracking Category 0] - [Tracking Option 0]' |
Tracking Option 1 | Text | Tracking Options are concatenated with the Tracking Category e.g. '[Tracking Category 1] - [Tracking Option 1]' |