Hi Peter, I am not allowed to export credit card transactions fro my bank statement. However, I can cut and paste the information. I saved this as a csv file and tried to import into Bullet. I'm getting the error message "There was a problem with the imported file: Invalid header" Is it possible to correct this? /Steve
I tried to upload a csv file in the same format as the bank transaction download but I still got the same error. You mention a spreadsheet that can be downloaded - can you clarify how to do this and I'll try again?
Sure when you go to 1) Bank Accounts 2) Import a Statement 3) Select the bank you want to import the data from. 4) When you're on the screen called "Import Statement for 'X Bank'. Click "other", from the drop down called "Which bank account is this data from?". 5) Then you'll see the link at the bottom "Click here for an example CSV file". 6) Copy your data into that and upload it. Make sure you clean out any of the empty cells.
I got the sample file, pasted the data under the sample file headings and saved the file. I deleted lots of columns and rows near the data. I'm still getting the same upload error!
"Cannot Import File There was a problem with the imported file: Invalid header: Expected 'Date, Description, Money Out, Money In'"
and "File '1501ETACCreditCardJan.csv' contained invalid data for bank: OTHER." See error message above"
We're going to be using a fantastic service soon that will suck that data in and automatically do your accounts, sadly due to the terrible Irish banks it's only in the US :(
Let me know if you need me to add anything to it.
Cheers
Pete
I am not allowed to export credit card transactions fro my bank statement. However, I can cut and paste the information.
I saved this as a csv file and tried to import into Bullet.
I'm getting the error message "There was a problem with the imported file: Invalid header"
Is it possible to correct this?
/Steve
You need to download the excel spreadsheet form Bullet as you probably have.
Delete columns and 20 rows that surround the data so clear out any crap that's been copied from the website.
* Don't delete the cells you need to delete the columns and rows.
Let me know.
I tried to upload a csv file in the same format as the bank transaction download but I still got the same error. You mention a spreadsheet that can be downloaded - can you clarify how to do this and I'll try again?
Many thanks,
/Steve
Sure when you go to
1) Bank Accounts
2) Import a Statement
3) Select the bank you want to import the data from.
4) When you're on the screen called "Import Statement for 'X Bank'. Click "other", from the drop down called "Which bank account is this data from?".
5) Then you'll see the link at the bottom "Click here for an example CSV file".
6) Copy your data into that and upload it. Make sure you clean out any of the empty cells.
Here is a screenshot http://screencast.com/t/Ds56QBIVV
Thanks
P
I got the sample file, pasted the data under the sample file headings and saved the file.
I deleted lots of columns and rows near the data.
I'm still getting the same upload error!
"Cannot Import File
There was a problem with the imported file: Invalid header: Expected 'Date, Description, Money Out, Money In'"
and
"File '1501ETACCreditCardJan.csv' contained invalid data for bank: OTHER." See error
message above"
Ok so there is still some data in the file that's outside of what Bullet needs.
Just try this:
1) Delete all the Columns to the right, but select the column from heading eg A, B, C etc not the cells.
2) Do the same for Rows.
If that doesn't work mail the file to help@bullethq.com
Thanks
Pete
Seems to have worked!
We're going to be using a fantastic service soon that will suck that data in and automatically do your accounts, sadly due to the terrible Irish banks it's only in the US :(
Pete