Xero Settings

Xero Settings

In this article we will outline Xero's API Settings & Mapping in Loft.

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 this article we will outline Xero's API Settings & Mapping in Loft. Front End Mapping You’ll notice that you now can see back end mapping has been brought to your front end in QuickBooks Online>Settings page under your Integration menu. *mapping ...

    • Setup a Xero account

      Sign up for Xero If setting up a new account: Navigate to Xero.com >Plans From Xero transfer acceptance: Purchase the standard/growing level  Once purchased, fill out the form below and follow the prompts to purchase. Last day of your financial year ...

    • User Roles in Xero

      Quick Reference of Xero User Roles Xero does have a number of options.  You can have a user with invoice-only access which will allow them to post invoices and bills and enter payments against them. They then wouldn't have access to bank ...

    • Xero Connecting/Disconnecting

      Connecting to Xero Head to Integrations>Xero Click the green 'Connect Xero button   Choose your Brokerage name from the dropdown ****If you have connected in the past you will see the option to continue with 1 Organization. Follow any login prompts ...

    • QuickBooks Online Contact Mapping

      When any transaction is posted we will look at profiles and the contact associated with a transaction and look for an existing QuickBooks Online Contact.  When the Contact does not exist in QuickBooks the contact is automatically created and then an ...