We are working with our suppliers to deliver automated invoices into Farm Focus. In the interim this a quick way to get your statements into Farm Focus. Importing your monthly supplier statement has the benefit of listing each item separately with additional purchase information loaded into the Description field. All you need to do is allocate a category and extended code to each line.
TIP: so that your coding is accurate and consistent, try creating some time-saving invoice coding rules.
Import your statement into Farm Focus
Download your suppliers file
Before you can import the file, you need to download the file from your supplier's website. This is usually a CSV file. All suppliers websites are different. Below is a guide (as of July 2023) to where to go on each suppliers website:
Log into PGG Wrightson website.
Go into Transaction Listings.
Enter the Transaction Date range required. This is usually for a month.
Then select Download.
Log onto the Ruralco website.
Find the required month.
Select the second icon which is the CSV file icon.
Log into the Ravensdown website.
Select My Finances.
Find the required month.
Click on the Save icon.
Import your file into Farm Focus
Go to the Actuals screen.
Click on the upload arrow in the top right corner of the screen. Select Supplier Invoice.
3. Select your provider.
4. Select Browse to locate the file on your device. Find the file you have recently downloaded.
5. Select Import.
You will find your invoice in the Needs Action screen, ready to code.
Tips and Tricks
Users can manipulate other supplier invoices into a format (CSV file) that is supported by Farm Focus import function. This can be useful if you have suppliers you buy various product from and have multiple lines to code. This is for experienced Excel/Word users and is not considered best practice.
To construct a CSV file so it can be inputed into Farm Focus:
Download PDF invoice from your supplier.
Open file using Word.
Open an historical CSV file (eg: PGG Wrightson file) in excel.
Copy transaction lines from Word file and paste into the PGG Wrightson CSV excel file (beneath the previous transactions... leave original transactions there until you have checked everything).
Make all the columns correspond. (i.e. copy and paste to get the amount and description into the right column).
Make sure there are no merged cells.
Delete all non-transaction lines (e.g. summaries, invoice totals etc) and the original PGG Wrightson lines but leave the column headings.
Save as a CSV file.
Go into Focus, download file as a PGG Wrightson file.
Make sure the statement date is correct and change the Other Party name.
Upload and code as normal.