Xero Settings & Mapping

Xero Settings & Mapping

In Article Navigation can be found to the right of this article or via the buttons below


Front End Mapping

You’ll notice that you now can see back end mapping has been brought to your front end in Xero>Settings page under your Integration menu.
*mapping settings directly impact the accounting postings in Xero’ Loft cannot undo the changes, so ensure you proceed with caution’

Each section can be expanded by clicking on the dropdown arrow, like so


Mapping Sections

Bank Account Mapping

This section displays the banks you have mapped Loft to in Xero, to edit the Account name, Allowable Transactions, and offset Liability G/L accounts, click the pencil next to the account you wish to edit.


Please note, Trust & Escrow accounts must have Trust Liability selected in the Deposit and Payout Offset field. All other bank accounts will have Commission Trust Liability selected in this field.

Allowed Transaction tag key 

Choose the tag in the Allowed Transactions field that will happen for each account

Trust Deposit  = Add Deposit to this account
Trust Transfer In = Transfer Deposit into this account
Trust Transfer Out = Transfer Deposit out of this account
Excess Release = Release Deposit from this account
Brokerage Payout = Pay Outside Brokerages or Referrals from this account
Agent Payout = Pay your agent from this account
Include in Subledger = Include this account in your Subledger Report
Income Paid = Transfers Deduction(s) amounts out of the account you pay your agents from
Income Earned = Transfers Deduction(s) amounts into this account
Pay Sales Tax = Pay your Sales tax from this account

How Bank Mapping looks 

in a typical Brokerage that uses a Trust/Escrow account, a Commission account, and a General/Operating account.

Trust/Escrow Account

Commission Account

General/Operating

If you're unsure on how to map your bank accounts, please reach out to support and let us know your flow of funds.

General Ledger Mapping

This section displays the control G/L accounts that are mapped to Xero, If using our Chart of Accounts, this will be the correct way of mapping the GL. If not, you can change these, however we do not recommend that without the advice of your accountant. 


*Please note that if you do map to your own G/L, you must add a clearing account in your Chart of Accounts to clear , read more regarding how accounting transactions work. 


Tax Type

This section controls the tax types for those applicable States/Provinces


Post Schedules

This section is where you can add, delete, or edit the scheduling of Xero batches. Please note, since integrating with the Xero's 2.0 API, any previous schedules have been wiped and you will need to configure new schedules here. To add a schedule, click the Add Schedule button, to Edit, click the pencil, and to delete, click the red trash icon.


When adding a new schedule, the time you click on this button that is what time will be added, you will have to edit it further to set up exact times as shown above. In the edit box, change your time, click the Active checkbox to enable the newly scheduled time, click save.


*Clicking the clock in the daily at schedule brings up a clock


Offices

This section is where you can see your trackable offices in Xero.  To learn more about office tracking, read here https://central.xero.com/s/article/Set-up-tracking-categories-GL

*At this time we only support tracking offices, any other tracking categories you set up in Xero will only be accessed within the Xero App.


Chart of Accounts

This section is where your Chart of Accounts in Xero lives.  If you’re a new client and do not have your own chart of account, Click 'Upload Chart Of Accounts' button and feel free to use our approved Chart of Accounts for Real Estate. To download our COA, follow these instructions.



    • Related Articles

    • QuickBooks Online Settings/Mapping

      In Article Navigation can be found to the right of this article or via the buttons below Settings/Mapping Sections Bank Account Mapping G/L Mapping Tax Type Mapping Add Posting Schedule Office Mapping Chart of Accounts In this article we will outline ...

    • Setup a Xero account

      In Article Navigation can be found to the right of this article or via the buttons below Sign up Financial Settings Add Chart of Accounts Add Office Setup Taxes Invite Loft Settings/Mapping Sign up for Xero Navigate to ...

    • Xero/Loft - Common FAQ's

      In Article Navigation can be found to the right of this article or via the buttons below Xero Support Xero User Roles Xero Bank Feed Setup Bank Feed Support Bank Account Importing How Data is Shared Loft to Xero GL Posting Xero Income Statement ...

    • Setup a QuickBooks Online Account

      In Article Navigation can be found to the right of this article or via the buttons below Sign up Financial Settings Add Chart of Accounts Add Office Setup Taxes Invite Loft Settings/Mapping Sign up for QuickBooks Online Navigate to ...

    • Accounting Setup

      When integrating your accounting software, click the links for each step in the process. Xero Setup your Xero Account Connect your Xero Account Setup & Map Xero Settings QuickBooks Online Setup your QuickBooks Online Account Connect your QuickBooks ...