How do I import Expenses from a file?
If you’re not a fan of manual entry, or you’d like to bring in older Expenses than the ones brought in by your bank account, you can upload Expenses in bulk with a CSV file.
With the import option, you can specify the Amount, Category, Date, Description and Vendor you would like each Expense to be created under, which are required fields in your CSV file.
Import your file with the steps below:
- Ensure your CSV file has the required fields and necessary details (see below for possible errors)
- Go to the Expenses section
- Click on the More Actions button
- Select Import Expenses from a File
- Click on Choose File…
- Select your CSV
- Match the fields to the columns from your file using the dropdown (e.g., Date should match to the column in your file that is also labelled as Date)
- Once you’re done matching and specifying your Currency, click on Import Expenses
- New Expenses will be added and you can start reviewing them in your list of Expenses.
How are duplicate Expenses handled?
All Expenses will be imported in, regardless if they are duplicates or transfers to pay off a balance. We recommend checking the CSV before import to ensure only unique transactions are brought in.
Which types of transactions can be imported in?
Currently, only negative amounts as -x.xx (withdrawals, payments, or debits) can be imported in. If your file has both positive and negative amounts, the negative amounts will only come in.
If your file only has all positives or all negatives, they will still be imported in. Currently, only payments and debits can be tracked. If you've accidentally imported in credits or reimbursements, you can delete the expenses afterwards to keep your reporting accurate.
Why did I get an error uploading my file?
The CSV file may be invalid depending on the error:
- The CSV file itself is corrupt - copy the information to a new workbook and re-save as a .csv format
- There are no header columns in the file or one header column is missing - Description, Date, Amount, Vendor and Category are required to be the first row in the file (if headers are missing, the first row is skipped)
- There are unsupported characters like $ in the Amount column
- The dates under the Date column are not written with dashes (-) or slashes (/) in between numbers (e.g., 01/17/2020 and 01-17-2020 are accepted)
- There are empty cells in the file (right click and select Delete to clear out empty cells)
- The specified date format does not match the format in the file
- The file is larger than 2MB - try splitting it into two or more CSVs instead