Using this option when importing your Fram Farmers statement; your statement is imported as a bank statement with each line of the statement being an individual entry against a bank account called ‘Fram Farmers’.
Bank rules can be used to help speed up data entry when using this method.
How does it work?
Formatting your statement file
Before beginning the import process for the first time, you will first need to customise the csv file you have received. NB - you will need to make these same customisations each time you import a new statement.
In cell S1 add a column title of ‘Import string’
In cell S2, paste the following formula: =CONCATENATE(B2, " | ", G2, " | ", H2, " | Quantity ", I2, J2, " | VAT ", L2, " | Inv No.: ", E2)
Press ‘Enter’.
Drag the formula down to the bottom line of data entry.
5. Save the new csv file.
Once this is done, the next step is to create a file import format specifically for your Fram Farmers file.
Once this format has been completed, you can then import your files received from Fram Farmers into the FF bank account. When you make the physical payment to Fram Farmers, this transaction in your main bank account will be coded as an inter bank transfer to your FF bank account.
Creating the correct file import format
You will first need to make sure you have setup a bank account called ‘Fram Farmers’ with an input method of ‘File Import’.
Go to Banking | Bank Accounts and select the option to Add New Bank Account
Enter the name and ensure the entry method is 'File Import', and then save the new bank account.
Once this has been created, follow the steps below.
1. Go to Banking | Bank Accounts.
2. From the bottom of the banking screen, select Enter Transactions and ensure your Fram Farmers bank account is selected in the drop down, and select Enter.
3. Select Custom Import Formats.
4. Add New Custom Import File
5. Give it a name of ‘Fram Farmers’ and drag and drop, or browse to your Fram Farmers file. Then select Upload Example File.
6. Set the top line as the ‘Headings?’ and the second line as ‘First Row of Data?’. Then select Create.
7. Configure the 3 columns as below:
Column 4 – Invoice Date – Linked to ‘DATE’ in format DD/MM/YYYY
Column 13 – Total Line Value – Linked to ‘AMOUNT’ in format ‘Money In & Out (CREDIT CARD)’
Column 19 – Import String - Linked to 'DESCRIPTION'
8. Save the custom import type.
Importing your monthly statement can be split into 3 simple sections.
1 – Formatting the statement:
1. Follow the steps higher up in this article to format the file correctly.
2. Save the new csv file (we would recommend giving it a name for the period your importing for, and to save in a location that you can easily find).
2 – Importing into Farmplan Business Cloud
1. Go to Banking | Bank Accounts.
2. From the bottom of the banking screen, select Enter Transactions ensure Fram Farmers is selected in the drop down and select Enter.
3. Select the green File Import button.
3. Add a description, ensure the upload type is the custom Fram Farmers format, and drag and drop or browse to the selected file.
4. Save and Upload
3 – Confirming the statement
1. Select the green ticks
2. You will be presented with a screen similar to the bank feed. Work your way through and confirm the transactions. You can hover over the description to see all of the information required to help you allocate each entry.
What happens when the payment is made to the buying group?
When the payment leaves your main bank account, you will need to code this as an interbank transfer to your ‘Fram Farmers’ bank account to complete the process.