CSV stands for “Comma Separated Values”, and is a standard file format offered by most financial institutions. You can use a CSV file to add data to GoDaddy Bookkeeping that didn’t come in automatically: older data not included in an automatic upload, data from a bank that is not on our list, or data from a source we don't currently partner with directly. Once you’ve downloaded the file ending in .csv, you’ll want to open it in a spreadsheet program such as Excel or OpenOffice.
CSV files need to be formatted in a specific way to ensure they'll upload successfully into GoDaddy Bookkeeping.
Things to keep in mind when formatting your file: (Want to skip the formatting and have us do all the tweaking for you? Give QFX a try!)
- You'll need to create two .CSV files, one for Income transactions and one for Expense transactions. You can use the Sort feature in Excel to make this easier: choose to sort by the Category column. Naming each file something like Chase-Income.csv and Chase-Expense.csv will make it easier to keep track of them. It is best to create a “new workbook” and paste the info in rather than re-format the file you’ve downloaded from the bank.
- Be sure that the dates are formatted as MM/DD/YYYY or MM/DD/YY and that there are no days of the week.
- In general, all numbers should be positive, not negative, in both the Income and Expenses files. The only time you should see a negative number would be if you are importing returns (negative income) or refunds (negative expense) or something along those lines (discounts, etc.).
- There should be an entry in the “Category” column for every transaction. If you leave the “Category” column blank, the entry will automatically come in as "Sales" for Income transactions and "Uncategorized" for Expense transactions. Anything categorized as "Uncategorized" won't be included on your Schedule C. The “Description” column can be left blank, but still needs to have a column header.
- Be careful with the Category names: you can’t use the same category name on both the "Income" and "Expense" sides:
Example: You can have a category called “Advertising Income” in the Income.csv and one called “Advertising Expense” in the Expense.csv
You CANNOT have a category called “Advertising” in both Income.csv and Expense.csv
- Try to stay away from special characters. Letters and numbers will give you the best results.
The end result should look something like this:
Once your file is formatted correctly, use this link to Upload Your Data. You can also get there by scrolling down to the bottom of the Income or Expense page, selecting 'Import' then clicking on the link 'Upload a spreadsheet instead of a QFX'.
Be sure you’ve selected either "Income" or "Expenses" to identify the type of transactions and select your file. Keep in mind, the bigger the file you're uploading, the longer it will take. We'll send you an email when it's finished. If there were any rows that were not successfully uploaded the email will tell you the row number of the failure. If you do have a few errors, keep in mind that the rest of the file was uploaded successfully, so if you choose to re-upload the failed rows you should NOT include the rows already successfully uploaded or you will have duplicates.