Accountant Forums


Reply
Thread Tools

Quickbooks credit card transaction download

 
 
Z Man
Guest
Posts: n/a
Thanked:
 
      04-05-2005, 10:51 AM
As a veteran of Quicken, I have been downloading many credit card
transactions for years. Now, a client that uses QuickBooks 2003 would like
me to track his transactions. He does heavy American Express, and MasterCard
to a lesser degree. Question: can we download his credit card transactions
into QuickBooks? Thanks.


 
Reply With Quote
 
 
 
 
L
Guest
Posts: n/a
Thanked:
 
      04-05-2005, 01:26 PM

"Z Man" <> wrote in message news:X4u4e.99$...
> As a veteran of Quicken, I have been downloading many credit card
> transactions for years. Now, a client that uses QuickBooks 2003 would like
> me to track his transactions. He does heavy American Express, and
> MasterCard to a lesser degree. Question: can we download his credit card
> transactions into QuickBooks? Thanks.
>

Yes, but it works differently than Quicken - and is not as seamless. Each
new(unmatched) downloaded transaction must be examined and added to the CC
register with the appropriate account.


 
Reply With Quote
 
 
 
 
Z Man
Guest
Posts: n/a
Thanked:
 
      04-05-2005, 05:26 PM

"L" <> wrote in message
newspw4e.72$...
>
> "Z Man" <> wrote in message

news:X4u4e.99$...
> > As a veteran of Quicken, I have been downloading many credit card
> > transactions for years. Now, a client that uses QuickBooks 2003 would

like
> > me to track his transactions. He does heavy American Express, and
> > MasterCard to a lesser degree. Question: can we download his credit card
> > transactions into QuickBooks? Thanks.
> >

> Yes, but it works differently than Quicken - and is not as seamless. Each
> new(unmatched) downloaded transaction must be examined and added to the CC
> register with the appropriate account.


Could you point me in the right direction? I just set up the Amex account In
Quickbooks 2003, but cannot find the method of downloading transactions. I
even searched the Help file, but found data only for Merchant accounts. My
client is just an end user. Thanks!


 
Reply With Quote
 
L
Guest
Posts: n/a
Thanked:
 
      04-05-2005, 06:55 PM
"Z Man" <> wrote in message news:3Tz4e.44$Fm5.20@trndny09...
>
> "L" <> wrote in message
> newspw4e.72$...
>>
>> "Z Man" <> wrote in message

> news:X4u4e.99$...
>> > As a veteran of Quicken, I have been downloading many credit card
>> > transactions for years. Now, a client that uses QuickBooks 2003 would

> like
>> > me to track his transactions. He does heavy American Express, and
>> > MasterCard to a lesser degree. Question: can we download his credit
>> > card
>> > transactions into QuickBooks? Thanks.
>> >

>> Yes, but it works differently than Quicken - and is not as seamless. Each
>> new(unmatched) downloaded transaction must be examined and added to the
>> CC
>> register with the appropriate account.

>
> Could you point me in the right direction? I just set up the Amex account
> In
> Quickbooks 2003, but cannot find the method of downloading transactions. I
> even searched the Help file, but found data only for Merchant accounts. My
> client is just an end user. Thanks!
>
>

Hmm. It *IS* in the helpfile with my QB 2003. I use the Premier Contractor
edition, but I did not think online banking was limited to the editions
above the QB basic level.

Here goes:
You must set up the account within QB to have online banking access. Go to
Banking==> Set Up Online Banking Services ==> Apply for Online Banking.
Complete instructions are in the helpfile under 'Online Banking' and
'Applying for online banking services'. If your client already uses AMEX
online website to check his account, you will not have to wait for pin,
etc.. Just ignore the advice to wait for an 'introductory package' and PIN.
You will use the userid and password your client already set up. Once you
have finished using the online banking setup wizard, the QB account you
created for the AMEX card will contain online access info. You can see it by
'editing' the account. There should be a check in the box saying 'Account is
enabled for:' 'Online Account Access'.

Once the AMEX account has been 'flagged' for online banking access, you will
see it in the drop-down list on the online banking screen. Go to Banking==>
Online Banking Center. You should see a mailbox with Items to Send. There
will be a checkmark next to Get new QuickStatement for account: American
Express. On the right side, click the tab for Go Online.

Now, here is where it gets wonky with AMEX. Even though QB has the info for
the AMEX website, you will not be connected and download. You must log in to
the AMEX website. On the left of the website is a button that says 'Download
to Quicken or Money'. Click on it. You will be given the option to change
your software to QuickBooks. Click Download Now. Do not save the file,
instead open it. QB will give you the option to save or import transactions.
Again, do not save, just import.

Now, on the online banking center screen there will be an item under the
mailbox for Items Received From Financial Institution. Select the American
Express QuickStatement and select View. Select each transaction in turn and
enter it into your QB account.



 
Reply With Quote
 
 
 
Reply

Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Credit Card Transaction Download Translation Tosh Microsoft Money UK 1 03-24-2007 06:42 PM
Quickbooks 2003->2006: will no longer download Citibank credit card transactions Z Man Quickbooks 1 06-08-2006 03:17 AM
download the Credit Card transaction date not the the posting date riskymanr Microsoft Money 6 05-02-2006 03:19 PM
Successful credit card transaction download yields no transactions in register Anom Microsoft Money 0 11-01-2004 02:33 AM
Which credit card company offer free statement(transaction) download? James Microsoft Money 6 02-27-2004 06:24 PM


All times are GMT. The time now is 10:47 AM.
Posts in this forum do not constitute the advice of AccountantForums.com or its members. Financial advice should always be taken from qualified advisors before committing to a financial decision.