If you are interested in using our bulk import tool to bring in your past transactions from your bank statements, other account software, or your homegrown spreadsheets, you can request the spreadsheet from us.
This article will walk you through the steps, and there is also a video to guide you.
You will receive the template and then you will make a copy of the spreadsheet in Google Sheets or download it to open in Microsoft Excel or Apple Numbers.
You will go to the second sheet and enter your name and email address associated with your FarmRaise account at the top.
Add details for any transactions you want to see in FarmRaise Tracks.
You can use one sheet for both Revenues and Expenses
Note There is two example transactions at the top to help you get started. Make sure to delete these before you get going .
You can bring in information from other places
Feel free to copy and paste transactions from other sources (like your bank, your own spreadsheets, or accounting software) into this template.
Note! Most banks and accounting software will allow you to download your data in a CSV format, which you can then open and copy and paste into this template!
Every bank is different, but you can usually find this option by going to your transaction history and looking for an Export or Download option.
If copying / pasting from somewhere else, make sure the data is in the format specified below for each field.
If you need assistance with transferring your data into CSV format, you can use Adobe Acrobat or similar software.
When you're done:
If you are in Google Sheets, click "Share" in the upper right corner and enter "[email protected]" in the box and click "done"
You can also email us your downloaded, completed spreadsheet
Wait for Us!
We will import your transactions into your Tracks account in a few days!
We'll send you a message when your transactions have been added to your account!
Column | Field Name | Required? | Allowed Values |
A | Transaction Type | Yes | "Expense" or "Revenue" |
B | Vendor Name | Yes | Name of the vendor or person |
C | Amount | Yes | Dollar amount of the transaction |
D | Transaction Date | Yes | Date of the transaction in MM/DD/YYYY or MM/DD/YY format |
E | Account | Yes | Any value can be used here |
F | Category | No | If left blank, it will default to "Uncategorized" and you can categorize it in Tracks later |
G | Product | No | If left blank, it will default to "Unspecified" and you can categorize it in Tracks later |
H | Notes | No | Add any important notes for this transaction |