Xero SEASON Cash Flow Import

Login into P2PAgri and ensure that all the necessary data for the farming business has been entered. Before you start working on Cash Flow, make sure you enter the following in this order:

• Dashboard…through to

• Financials

This will ensure you have completed all the necessary income, expenses and lending needed for your account categories in P2PAgi, and will make matching account categories easier with your Xero account categories.

Go to SEASON > Cash Flow > Planned and ‘left click’ on the first income item.

Enter the expected monthly amount of income expected in this 12-month period.

Enter your expected income in the appropriate months, scroll to the bottom of the pop-up menu and select ‘Save’.

Please note in this ‘pop-up’ menu, the ‘Budgeted Total’ is the accrual estimate of the annual income of Barley for this farm. This number is provided as a guide and is based on the number of paddocks in barley, the estimated yields and prices. This may not be the annual cash income as this depends on when and how much barley is sold. Barley that is stored for this period to be sold next year will appear in next year’s cash flow budget.

Repeat this process until each income, expenditure and loan repayment are entered.

If you have a regular income or expense item you can use the grey area to the right to select equal month, equal bimonthly etc. and then select ‘Apply’. P2PAgri will split the amount and place in the correct months. If you are happy with this entry select ‘Save’ and continue.

When you are in SEASON > Cash Flow, select the year in which you wish to import the Xero data, by selecting the correct year in the ‘time-line’. In this example 2022 data is to be brought into P2PAgri.

‘Left-click’ on the ‘Import with Xero’ button, top right of the screen.

Left-click the ‘Connect to Xero’ button

Select the business entity you wish to connect with. If you have multiple business entities, bring the data in from the entity that is used to manage the check book. P2PAgri can only bring in one entity’s data.

Left-click ‘Continue with 1 organization

Note: If you have selected the incorrect business entity in Xero, you can disconnect from Xero by left-clicking on the ‘Disconnect with Xero’ button.

Once connected you can select the month you wish to import. Please note this should be past months where you have Xero data and preferably reconciled months in Xero. If you haven’t used reconciled data and wish You can re-import Xero data once reconciled if you wish to update that month. P2PAgri will remember previously saved data in bring in the updated data to be included into P2PAgri SEASON > Cash Flow > Actual.

Now work your way down the screen matching the Xero categories listed in the left column with the P2PAgri categories in the drop-down menu.

If you wish to split a Xero category between two or more P2PAgri categories select the associated ‘+’ and select the appropriate P2PAgri category. Split the payment amount accordingly into the correct boxes in the ‘Matched Item’ column.

If you do not have the correct P2PAgri category to select from, scroll down and left-click the orange ‘Save’ button, go back into P2PAgri and add the item into the appropriate part of P2PAgri. Note this could be in the menu areas of Paddock through to Financials. If it’s a variable cost category it is likely to be in Livestock, Pastures or Cropping. If it’s an overhead category it’s likely to be in Financials > Fixed Costs. Once you have entered the category then repeat from the start of Step 3. Repeat this until all categories are matched. Please note P2PAgri will remember your matching once ‘saved’, so each month’s Xero importing will become more automated.

Loan repayment data is not available for Xero, so P2PAgri has a table at the bottom of this popup menu that suggests what loan repayments you have made that month. If P2PAgri has guessed correctly then select ‘Save’ and continue. Otherwise put in the correct loan monthly payments for that month, select ‘Save’ and continue.

a) Chart – Selecting SEASON > Cash Flow > Chart will show a data graphically, showing the progress of the monthly cash flow. The ‘blue’ line showing planned and the ‘orange’ line showing actual.

b) Comparison – By selecting the ‘Start Month’ and the ‘End Month’ Comparison will show the difference of each category between the planned and actual. This highlights where the significant changes have been in the budgeting process.

You can create a pdf of any of the reports by left-clicking the ‘Print Report’ button and selecting which combination you require. These pdf file can be printed or emailed to other people involved in your business.

Please note the ‘Start Month’ and ‘End Month’ selected in SEASON > Cash Flow > Comparison will determine which group of months are reported.

If you wish to create a csv file of either the Cash Flow > Planned or Cash Flow > Actual, left-click the ‘Print Report’ button and select the appropriate ‘Excel’ icon to the right of the pop-up menu.