Home Page link  

Using QB 3005 Pro to download credit card charges

  
Groups | Search | About
User Password
Register Now! Lost Password?

QuickBooks Discussion board - Discussions about the popular financial software by Intuit

 Post an article  get this group's latest topics as an RSS feed add this group's latest topics to your My MSN content add this group's latest topics to your My Yahoo content  add this group's latest topics to your Google content  YahooMyWeb Yahoo!  Google Google  Windows Live Favorites Windows Live  del.icio.us del.icio.us  digg digg  Add to Netscape Netscape
Subject Author Date
Using QB 3005 Pro to download credit card charges PT 11-28-2007
Posted by PT on November 28, 2007, 1:13 am
Please log in for more thread options
 Our organization uses a set of a half dozen credit cards assigned to
specific employees for periodic business purchases. In a typical month,
each card may accumulate a half dozen charges.

Using the old fashioned manual method, here's what I do for each card:

I click on Banking | Record CC Charges | Enter CC charges. On the resulting
screen, and using data from either the CC provider's on-line statement or
hard copy statement I select and enter the vendor from my QB vendor file,
enter the transaction date, the amount and the appropriate account to charge
the purchase.

Now if I were to let QB download the data from the CC provider, how could QB
select the correct vendor, and how would it know which account to debit? Is
there a step in which I make the choices during the download?

I guess what I'm asking is whether there's any real saving to using the QB
download
--

PT





Posted by L on November 28, 2007, 8:02 am
Please log in for more thread options
> Our organization uses a set of a half dozen credit cards assigned to
> specific employees for periodic business purchases. In a typical month,
> each card may accumulate a half dozen charges.
>
> Using the old fashioned manual method, here's what I do for each card:
>
> I click on Banking | Record CC Charges | Enter CC charges. On the
> resulting
> screen, and using data from either the CC provider's on-line statement or
> hard copy statement I select and enter the vendor from my QB vendor file,
> enter the transaction date, the amount and the appropriate account to
> charge
> the purchase.
>
> Now if I were to let QB download the data from the CC provider, how could
> QB
> select the correct vendor, and how would it know which account to debit?
> Is
> there a step in which I make the choices during the download?
>
> I guess what I'm asking is whether there's any real saving to using the QB
> download

QB obtains the vendor name from the financial institution. The names rarely
match what you would enter as a vendor name.... they are often truncated, or
contain information specific to WHICH Staples, Shell Oil or whatever
location you visited. There is an opportunity to assign an 'alias' to the
downloaded name, so that if you have a CC charge that went to "19 PET. -
NEPTUNE Q39 NEPTUNE NJ" you could assign it as an alias to "19 Petroleum
Inc.".

After you download the transactions for your CC, QB will attempt to match
the transaction to ones already in your register. The help section for
online banking has a detailed explanation under 'matching transactions'. If
the transaction is in the register but hasn't been matched, you have the
opportunity to manually match it. If the transaction has not been entered
into the register, you can enter it. It is in the matching/entering stage
that you can create aliases, assign accounts, etc.

The real time savings come after you have downloaded and recorded
transactions for a couple of months. QB has the option to 'add multiple' and
it will bring up a screen, with transactions that match the vendor
names/aliases previously entered, and the accounts previously assigned. You
have the option AT ANY TIME to change vendor names or accounts (say your
purchase at Staples was not for 'office supplies' but instead for 'office
furnishings' or whatever... you can select the proper expense account from
the screen BEFORE the transaction is entered).



Posted by PT on November 28, 2007, 1:17 pm
Please log in for more thread options
Thanks for such a detailed and helpful explanation

--

PT

>
> QB obtains the vendor name from the financial institution. The names
> rarely match what you would enter as a vendor name.... they are often
> truncated, or contain information specific to WHICH Staples, Shell Oil or
> whatever location you visited. There is an opportunity to assign an
> 'alias' to the downloaded name, so that if you have a CC charge that went
> to "19 PET. - NEPTUNE Q39 NEPTUNE NJ" you could assign it as an alias to
> "19 Petroleum Inc.".
>
> After you download the transactions for your CC, QB will attempt to match
> the transaction to ones already in your register. The help section for
> online banking has a detailed explanation under 'matching transactions'.
> If the transaction is in the register but hasn't been matched, you have
> the opportunity to manually match it. If the transaction has not been
> entered into the register, you can enter it. It is in the
> matching/entering stage that you can create aliases, assign accounts, etc.
>
> The real time savings come after you have downloaded and recorded
> transactions for a couple of months. QB has the option to 'add multiple'
> and it will bring up a screen, with transactions that match the vendor
> names/aliases previously entered, and the accounts previously assigned.
> You have the option AT ANY TIME to change vendor names or accounts (say
> your purchase at Staples was not for 'office supplies' but instead for
> 'office furnishings' or whatever... you can select the proper expense
> account from the screen BEFORE the transaction is entered).
>



Similar ThreadsPosted
Anyone Else Not Able to Download Citibank Credit Card Charges June 30, 2008, 9:04 pm
Credit card charges as "bill payments" September 24, 2007, 1:59 pm
Re: Deductions from payroll for personal charges on company credit card January 31, 2007, 4:25 pm
Deductions from payroll for personal charges on company credit card January 31, 2007, 4:12 pm
Free to get your credit card report, will not even ask for your credit card number December 13, 2007, 1:20 am
Virtual Credit Cards With Download to Quickbooks March 22, 2008, 4:06 pm
Re: Credit Card February 26, 2007, 7:42 am
Credit Card February 26, 2007, 6:25 am
Credit Card deposit July 25, 2006, 5:03 am
Bill Pay With Credit Card? July 31, 2006, 8:28 pm

Contact Us | Privacy Policy
This site is not affiliated with Intuit - makers of Quickbooks and Quicken software
This site is not affiliated with Sage Software - makers of Peachtree accounting software
XML SitemapXML Sitemap