| View previous topic :: View next topic |
| Author |
Message |
woodman33
Joined: 22 Jun 2008
Posts: 5
|
| Posted: Sun Jun 22, 2008 6:32 pm Post subject: QuickBooks - uploading bank transactions |
|
|
| I have a client whose bank provides a .csv file of the bank transactions for the month. How can I upload (import) the data into QB so it doesn't have to be keyed into QB? |
|
| Back to top |
|
Jennifer T
Joined: 10 Oct 2005
Posts: 170
Location: Southern California
|
| Posted: Sun Jun 22, 2008 8:03 pm Post subject: |
|
|
You'll have to convert it to an .iif format. You can search the Intuit Markeplace for conversion software.
Caution: be sure to backup the QB file before importing! You may not like the results of the import, and if you have a fresh backup, you can restore it.
Take care. |
|
| Back to top |
|
RobJ
Joined: 11 Jun 2008
Posts: 182
|
| Posted: Mon Jun 23, 2008 6:48 am Post subject: |
|
|
Jennifer T wrote: You'll have to convert it to an .iif format. You can search the Intuit Markeplace for conversion software.
Caution: be sure to backup the QB file before importing! You may not like the results of the import, and if you have a fresh backup, you can restore it.
I've not used the feature, but my QuickBooks Pro 2007 provides for online banking. According to HELP, that permits the downloading/importing of transactions into QuickBooks. Am I misunderstanding the feature? I use Quicken for my personal accounts and the downloading/importing feature is fantastic and saves a lot of time.
Thanks,
Rob |
|
| Back to top |
|
Jennifer T
Joined: 10 Oct 2005
Posts: 170
Location: Southern California
|
| Posted: Mon Jun 23, 2008 7:21 am Post subject: |
|
|
RobJ wrote: I've not used the feature, but my QuickBooks Pro 2007 provides for online banking. According to HELP, that permits the downloading/importing of transactions into QuickBooks. Am I misunderstanding the feature? I use Quicken for my personal accounts and the downloading/importing feature is fantastic and saves a lot of time.
Thanks,
Rob
I don't think I understand your question.
The only types of online banking files that can be imported to QB are .qbo and .iif. Other types of files cannot be imported directly - they must be converted to .iif.
Any type of import, but especially untested .iif imports, can go haywire. It's always a good practice to backup the QB file before importing.
More about QB online banking:
http://www.jenniferthieme.com/quickbooks-online-banking.html
HTH
Jennifer |
|
| Back to top |
|
RobJ
Joined: 11 Jun 2008
Posts: 182
|
| Posted: Mon Jun 23, 2008 7:33 am Post subject: |
|
|
Jennifer T wrote: I don't think I understand your question.
The only types of online banking files that can be imported to QB are .qbo and .iif. Other types of files cannot be imported directly - they must be converted to .iif.
Any type of import, but especially untested .iif imports, can go haywire. It's always a good practice to backup the QB file before importing.
Maybe I shouldn't have used the term "import". My QuickBooks Pro 2007 has an "Online Banking Center". Based on what I've read in the HELP files, I could use that to "download bank data".
This is from QuickBooks HELP - "With online banking (also called online account access), you can download electronic statements from your financial institution or credit card provider into QuickBooks. Then you can see what transactions have cleared your account, find out your current balance, and add transactions that have been processed but aren't in QuickBooks yet."
I directed my comment to you and not the OP because you are a "Certified QuickBooks Pro Advisor". I'm not and I didn't want to give out wrong information. I am quite familiar with QuickBooks, but have not used the online banking feature. I thought the OP might benefit from this information with any additional experience you might have to offer.
Thank you,
Rob |
|
| Back to top |
|
Jennifer T
Joined: 10 Oct 2005
Posts: 170
Location: Southern California
|
| Posted: Mon Jun 23, 2008 7:41 am Post subject: |
|
|
RobJ wrote: Maybe I shouldn't have used the term "import". My QuickBooks Pro 2007 has an "Online Banking Center". Based on what I've read in the HELP files, I could use that to "download bank data".
This is from QuickBooks HELP - "With online banking (also called online account access), you can download electronic statements from your financial institution or credit card provider into QuickBooks. Then you can see what transactions have cleared your account, find out your current balance, and add transactions that have been processed but aren't in QuickBooks yet."
I directed my comment to you and not the OP because you are a "Certified QuickBooks Pro Advisor". I'm not and I didn't want to give out wrong information. I am quite familiar with QuickBooks, but have not used the online banking feature. I thought the OP might benefit from this information with any additional experience you might have to offer.
Thank you,
Rob
Import = Download. Same thing. To download a file is to obtain a .qbo or .iif and import it into QB. |
|
| Back to top |
|
woodman33
Joined: 22 Jun 2008
Posts: 5
|
| Posted: Mon Jun 23, 2008 8:26 pm Post subject: Thanks for the discussion |
|
|
Jennifer & Rob,
Thanks for taking the time to give me your insight.
I'll try it out this weekend.
Take care :D |
|
| Back to top |
|
RobJ
Joined: 11 Jun 2008
Posts: 182
|
| Posted: Tue Jul 01, 2008 10:22 am Post subject: Re: Thanks for the discussion |
|
|
woodman33 wrote: Jennifer & Rob,
Thanks for taking the time to give me your insight.
I'll try it out this weekend.
Take care :D
How did you make out?
Rob |
|
| Back to top |
|
| |
