Farm Focus has a direct feed with Farmsource which you can activate in the Connectors section of your Settings. If you have this connection set up, your monthly Farmsource statement will automatically appear as an invoice in the Needs Action screen with the item lines ready to be coded.

There is also the option to import your Farmsouce Statement as a CSV file via the upload icon in the top right-hand corner of your Needs Action screen:

If you do not have these set up you will need to manually record a Money Out Invoice to account for the FarmSource expenses.

As yet Farm Focus does not have a direct integration with Fonterra but this is currently in the planning stage.

When you get your payment from Fonterra on the 15th of the month, this payment will have your total milk production payment,

LESS deductions and/or Levies,

LESS your Farmsource monthly statement.

To be able to match the invoice with the transaction, follow these steps below:

  1. Create a Money In Invoice for the Fonterra income. Include the quantity of milk solids produced for the month as per your Fonterra statement (only for This Season milk production). Attach the pdf of the statement for your records.

    If you have retro payments included, enter these on a separate line but do not enter a milk solids quantity for this as it will distort your total production figures.

  2. Create a Money Out Invoice for your levies and deductions. Add lines to seperate your DairyNZ levies from any of your other deductions (if applicable).

  3. Code your Farmsource statement in full. If any items have been purchased in-store and are included on the Farmsource Statement you will need to delete these item lines from your invoice, and overtype the total amount to the correct value being charged.

  4. Once the bank transaction direct credit has been actioned on the 15th, you can click into the Bank Transaction and match to all three invoices: Farmsource, Fonterra income, Fonterra levies.

    * Choose the expense invoices before the income invoice when you match.


    Use the Quick Matching function by selecting the "equals" icon in the top right corner of your Needs Action Screen.

    Once inside the Quick Matching screen, check the boxes for all three invoices, and the corresponding transaction. Click the Match button.

Invoice Basis customers:

If you have an Invoice Basis business for your GST reporting you will need to ensure that you select the Issue Date on your Fonterra statement as the Invoice date. This is usually the 7th of the same month that your Fonterra income is paid.

When you file your GST return, ensure that any current Fonterra/Farmsource invoices remain in the Needs Action screen unmatched until you have your GST return completed for the previous period i.e. your May/June return is completed and filed before you match your July invoices.

Payments Basis customers:

If you are a Payments Basis business for your GST reporting, it is not so important which date the invoice date is, whether it is the 30th/31st of prior month, or the 7th of the current month. You will only need to make sure that for Year End processes that any June income is applied to the May of the previous year.

Did this answer your question?