Xero Essentials Import

This is an easy way to get historical financial data loaded into the ESSENTIALS part of P2PAgri, straight from your Xero data. It’s a two-phase process:

Bring the financial year Xero ‘Trial Balance’ data into an editing page in P2PAgri. This allows the first view and edit ability of this data. Go to the bottom of this sheet to ‘save’ this data and bring into ESSENTIALS.
Once the Xero data is in ESSENTIALS you can do your final edits allowing you to further adjust your key assets to ‘market’ value numbers.
Then repeat this for each financial year you wish to import.

These are the 10 Steps to follow:

Step 1: Login to P2PAgri (click on the red ‘Login’ button)

Step 2: Go to ESSENTIALS > Dashboard and click on the year in the timeline you wish to bring your Xero data in. We suggest you work from the most recent completed financial year and work back, financial year by financial year.

Step 3: Click on the ‘Action’ button to the top right of your screen and select ‘Xero Import'.

Step 4: Click on the ‘Connect to Xero’ button

Step 5: You then login to your Xero account by clicking the blue ‘Log in’ button

Step 6: Select the business data you are bringing in from Xero. You can only bring in one business, which should be the business in which you do the most of your business transactions. Then select the ‘Continue with 1 organization’ button.

Step 7: Your Xero ‘Trial Balance’ data will be brought into a special page in P2PAgri which allows you to (1) view (2) edit, (3) adjust and (4) alter the accounting categories before you bring this data into the P2PAgri > ESSENTIALS section. The aim here is to start to convert your ‘tax accounting’ Xero data into P2PAgri ‘Management Accounting’ data. Scroll down and check the:

· Income,

· Expenses,

· Assets, and

· Liabilities entries.

Please note that you can still edit this data once you have accepted this data by click on the orange ‘Save’ button at the bottom of this screen. This then pulls this data into the P2PAgri > ESSENTIALS.

Step 8: Once you have checked over this Xero data and made your edits, scroll to the bottom of this page and select ‘Save’. This data will then be downloaded into your ESSENTIALS (1) Profit and Loss and (2) Balance Sheet.

Step 9: Your data should now be in ESSENTIALS > Profit and Loss and ESSENTIALS > Balance Sheet. You are now able to continue your editing of this data to make it reflect the ‘management’ information that you are after. Particularly look at:

Income – check that all this income looks legitimate income for that year. It generally is!

2. Expenses – Check the expenses, making sure they are legitimate expenses and allocate them by changing the % allocation to:

· Variable Costs,

· Overhead Costs,

· Depreciation, and

· Finance Costs. NB Finance Costs include (a) bank fees, (b) all interest payments and (c) Lease Costs.

3. Assets – Your Current Assets should be OK, but a lot of your Non-Current Assets will be valued using the ATO rules, which are

NOT Market Values!! We need the market values of your:

· Land and improvements,

· Machinery

· Water rights and

· livestock values.

So edit those numbers to represent the values at the end of that financial year.

4. Liabilities – Most of the liabilities should be correct unless your accountant is using some of these entries to shift money to other business entities. We are after your legitimate liabilities. In other words, what debts would you need paid off if the business were to be sold!

Sometimes you may need to change items to different categories. For example, we have seen ‘Financing Costs’ placed in as ‘Assets’. These should be shifted to ‘Expenses’. If you need to make these changes, click on the respective items ‘box’ to the right and select the category you wish this item to change to.

Step 10: Well done - you are now ready to bring in the next financial year of data from Xero. Go to the ESSENTIALS > Dashboard and click on the next oldest financial year in the timeline you wish to bring in from your Xero file and go back to Step 3.