Skip to main content
All CollectionsFinancial Learning ResourcesEnd of financial year
Export to Xero General Ledger - for Accountants
Export to Xero General Ledger - for Accountants

Learn how to export Farm Focus to a Xero General Ledger.

Updated over 2 weeks ago

This resource is for Accountants.

Export out of Farm Focus and import into Xero, after you have undertaken the required preparation in Farm Focus:

  • Clear the Needs Action screen - ensure no invoices or bank transactions from the last Financial Year are left unresolved.

  • Check balance rollovers - last year's closing balances should match this year's opening balances for bank accounts, accounts payable and accounts receivable.

  • Check closing debtors and creditors - to confirm they are accurate and reasonable.

  • Confirm bank accounts are balanced - cross-check in Farm Focus

  • Ensure all codes are mapped including the General Ledger account codes- verify mapping using the AAR (Accountants Annual Report)

    Learn more about this process.

When importing into Xero, provided all codes are mapped, Farm Focus codes will align with the preselected Xero codes.

What is the process?

Log into Xero.

On the Landing page. Go to Business bank account > select Import a statement > Select file. Select the CSV file exported from Farm Focus.

NOTE: Ensure a business bank account has been set up in Xero for each bank account that has been used in Farm Focus.

Map the CSV file to the correct columns in Xero.

This mapping will need to be done every time a database is imported into Xero.

NOTE: Column 8 would normally show the quantity, but in this case, quantity is included in the Description field โ€” as long as itโ€™s greater than zero.

Do not tick this box.

IMPORTANT: If any code in Farm Focus was not mapped to an Accountant's code, it will go to the suspense code in Xero under Settings > General Ledger.

Cash coding will be required if the suspense code was not mapped in Farm Focus before exporting.

Did this answer your question?