Export FRS 102 Journals to Xero, Sage, Dynamics 365
Connect Lease102 to your accounting system to automatically post FRS 102 journal entries. Once configured, you can sync lease accounting journals directly from the Reports page.
Supported ERP Systems
Lease102 supports direct integration with the following accounting systems:
| System | Connection Type | Features |
|---|---|---|
| Xero | OAuth 2.0 | Manual Journals, Fixed Assets, Tracking Categories |
| Dynamics 365 Business Central | OAuth 2.0 (Azure AD) | General Journals, Dimensions, Fixed Assets |
| Sage 50 | Via Codat middleware | Nominal Journals, Departments, Fixed Assets |
| Sage 200 Standard | OAuth 2.0 | Nominal Journals, Analysis Types, Ledger Accounts |
How ERP Integration Works
The integration follows a four-step process:
Step 0: IT Setup (One-Time)
Your IT administrator must register Lease102 as an OAuth application with each ERP provider and configure the credentials in your Lease102 deployment. This is a one-time setup per ERP system. If you see 'Not Configured' on a system, this step is pending.
Step 1: Connect
Once IT has configured credentials, the Connect button becomes active. Click it to authorize Lease102 to access your ERP. You'll be redirected to the ERP's login page to grant permission via OAuth.
Step 2: Configure GL Mappings
After connecting, click 'GL Mappings' to map FRS 102 account types to your chart of accounts. This tells Lease102 which GL codes to use when posting journals.
Step 3: Sync Journals
Go to Reports → Journal Entry Export, select a date range, then click 'Sync to ERP'. Entries can be posted as draft (recommended) for review in your ERP before finalizing.
GL Account Mappings
You must map each FRS 102 account type to your chart of accounts before syncing. These mappings determine which GL codes appear in the posted journals.
Tracking Categories
| FRS 102 Account Type | Description | Typical Code |
|---|---|---|
| Right-of-Use Asset | Initial recognition of lease asset | 0030 (Fixed Assets) |
| Accumulated Depreciation - ROU | Contra account for ROU asset depreciation | 0031 |
| Lease Liability (Current) | Portion due within 12 months | 2109 (Creditors) |
| Lease Liability (Non-Current) | Portion due after 12 months | 2300 (Long-term Liabilities) |
| Depreciation Expense | ROU asset depreciation charge | 8004 (Admin Expenses) |
| Interest Expense | Lease liability interest charge (Finance Costs) | 7903 |
| Lease Clearing Account | For payment reconciliation (optional) | 2110 |
Per-Asset-Class GL Mappings
Each FRS 102 account type has a default mapping that applies to every lease. You can also add asset-class overrides so a single account type posts to different GL codes depending on the leased asset. For example, map the Right-of-Use Asset to one fixed-asset nominal for Vehicles and another for Land & Buildings. On a mapping row click 'Add asset-class override', choose the asset class, and select its GL account (and tracking values if used).
How the override is chosen
Platform OAuth Setup
OAuth client credentials for each ERP are configured once per Lease102 deployment by the Lease102 platform team, not by individual tenants. If a system shows 'Not Configured' in Settings → Integrations, email support@lease102.co.uk so we can complete the platform-side setup.
Connecting to Your ERP
Once the platform OAuth credentials are in place, any user with Owner or Accountant role can connect their organisation:
Navigate to Integrations
Go to Settings → Integrations tab.
Click Connect
Click the 'Connect' button on your ERP system. You'll be redirected to the ERP's authorization page.
Grant Permission
Log in to your ERP and authorize Lease102 to access your accounting data. You'll be redirected back to Lease102.
Verify Connection
The system should now show 'Connected' with your organization name. Click 'Test' to verify the connection is working.
Choosing the Organisation
If your Xero login can access more than one organisation (common for accountants and bookkeepers), the connection card shows an 'Organisation' dropdown beneath 'Connected to'. Pick which organisation Lease102 should post journals to - the change is instant and does not require disconnecting and reconnecting, because the authorization you granted at sign-in already covers every organisation you selected. The 'Connected to' name updates to confirm the active organisation.
Re-check GL mappings after switching
Syncing Journal Entries
To post journal entries to your ERP:
1. Generate Journals
Go to Reports → Journal Entry Export. Select the date range for journal entries.
2. Review Entries
Preview the journal entries before posting. Ensure GL mappings are correctly configured.
3. Sync to ERP
Click 'Sync to ERP'. Choose whether to post as Draft (recommended) or Final. Draft entries can be reviewed in your ERP before posting.
Include opening / transition entries
By default a sync posts only the ongoing entries for the period (interest, depreciation, and the full lease payment), so a routine monthly sync does not post opening balances twice. Tick 'Include opening / transition entries' in the sync modal to also post the Day-1 amounts: the transition opening (Finance Lease Asset, Lease Liability, and the Retained Earnings cumulative adjustment) for transitioned leases, and the initial recognition for leases that commence in the period. Map 'Retained Earnings' under Equity in GL Mappings before using this option. What the sync posts reconciles exactly to the Journal Entry Export for the same period and scope.
4. Check Sync History
View sync history from Settings → Integrations. Each sync shows records sent, succeeded, and any errors.
Currency scope
A sync posts one currency at a time, matching the Journal Entry Export. Each ERP manual journal posts in the connected organisation's base currency, so Lease102 will not mix currencies in a single sync. If you select a specific portfolio, its currency is used. If you sync 'All portfolios', the sync uses the currency selected on the Reports page, so only leases in that currency are posted. To post another currency, switch the currency on Reports (or connect that currency's organisation) and sync again.
Troubleshooting
Common issues and solutions:
| Issue | Cause | Solution |
|---|---|---|
| 'Not Configured' shown | Platform OAuth credentials not yet in place for this ERP | Email support@lease102.co.uk so the Lease102 team can complete the platform-side setup |
| 'Token Expired' status | OAuth token has expired (typically 30-60 days) | Click 'Refresh' to renew the token, or disconnect and reconnect |
| 'Error' status | Connection issue with ERP | Check ERP availability, then disconnect and reconnect |
| Sync fails with 'No GL mapping' | Account type not mapped | Go to GL Mappings and map all required account types |
| Journals not appearing in ERP | Posted as draft | Check draft journals in your ERP and approve them |
| Journals posted to the wrong company | Your Xero login has multiple organisations and the connection points at the wrong one | On the Xero card use the 'Organisation' dropdown to select the correct company, then re-check GL mappings before syncing |
Permissions
Only users with Owner or Accountant roles can manage ERP integrations. Viewers can see connection status but cannot connect, disconnect, or modify mappings.
Disconnect Carefully