|
Reap the benefits of accumulating important
management information in QuickBooks by making an the investment
of time required to
complete the American Express download set-up. More companies are
beginning to follow suit in American Express's lead establishing a
secured link from their website into your QuickBooks company file.
Downloading credit cards into QuickBooks renders a credit card
company that does not offer this feature, obsolete.
Plus they pay you cash as a rebate once a year. Want
more information on
this nifty benefit? Benefits:
- Always know what your complete liability
picture is when it is time to pay bills. Doing so may
allow you to budget accordingly and put aside enough to pay the
credit card off in full each month rather than incurring
expensive liabilities.
- Searching for a purchase detail becomes
easier when the vendor name, not the credit card company name is
on the transaction.
- If you do not enter each transaction, how
do you record any partial payments? For example, if you
pay 25% of current months charges, which transactions will you
book today, what accounts would you choose for categorizing and
how will you remember this next month? Using the credit card
feature in QuickBooks lets you book the entire months activity
and make partial payments, keeping you abreast of what is owed
and keeping you informed of total purchases.
- The charge date is entered as of the date the transaction took
place, and places the expense in the month that it was incurred not when payment is made,
providing a better view of your current month income and
expenses.
- Credit card statements can be reconciled in QuickBooks so each
transaction can be verified. This leads to more accuracy and
prevents extraneous charges from slipping through. Details entered
provide an opportunity to see who is spending money and how
providing tighter controls on company funds.
- Entering credit card charges individually is time consuming and
detailed, but that can be mitigated by using generic names like
Restaurant, Parking, Gas, Hotel, and General Vendor, when it is
not
necessary to have a specific vendor's name on the transaction.
|
|
American Express offers a
seamless interface for downloading transactions into
QuickBooks
This procedure provides set-up assistance
for downloading American Express credit card transactions, tips
on entering credit card transactions, tips on reconciling the
credit card account at month end and a lead on how to get money
back (not points on your American Express purchases..
Downloading the transactions
using the direct method is the most efficient method, but
will take a bit more effort to set up:
With the direct method, it takes just a couple of clicks (Banking
menu > Online Banking Center) to download the latest
transactions into QuickBooks. Once you have completed the set-up,
entering each transaction is easy. Just assign the account, a
customer name and/or class (if applicable), click ok and your
reports will now have detail you need. If you have purchased
from the vendor previously, QuickBooks will auto-fill these
details in for you. Just review and click ok.
Also available for American Express business accounts is an
indirect method using Web Connect by visiting
http://www.americanexpress.com/cards/quickbooks.shtml.This
method takes more steps and requires remembering
more access codes, web addresses and passwords but once the
download is complete, accepting the data works the same way.
To get started using the direct
method:
- On your chart of accounts (list menu), set up a new account.
Select the account type to credit card
Name
the account any name you would like, but "American Express" seems
a logical choice
- Next connect to the internet
- Next- From the Banking menu, select set up online financial
services, click on apply for online banking, .
Click through and select Apply now
Click on Credit/charge card access
Click on American Express.
There is direct telephone number on this page (1-800-297-7500) that you can call if
you have difficulty. (It has been my experience that calling this
phone number and having them walk you through the set-up speeds
the process tremendously, but you are welcome to continue with the
steps below.)
- To continue with the online application -
Click on apply now and complete your information.
It was my experience that you will then be mailed a customer
number and a pin number.
- Once you receive the customer number and
pin number (in the mail) you must "enable" QuickBooks to
receive the American Express transactions.
To enable your American express
From the QuickBooks Banking menu:
Select ‘Set Up Online Financial Services’
Select ‘Apply for Online Banking’ in the drop down sub-menu.
Follow the prompts in the ‘Online Banking Setup Interview’
starting with ‘Apply for Online Banking’.
Click the Next button.
The next window you’ll see is ‘Have you already applied for online
banking with your Financial Institution?’
Select ‘I have already
completed an application with my institution.’
Click the Next
button.
The ‘What happens next’ window appears.
Click the Next button.
Next window is ‘Confirm account information’ within the ‘Enable
Accounts setup’ window.
Click the Next button.
Next window is ‘Select a financial institution’. Click the drop
down menu and select American Express. If American Express
is not in this menu, see**** below for what to do next
Click Next button. .
To enable your American Express account, enter your account name,
account number, routing id (for American Express this is always
000000000 – nine zeroes), making sure you select credit card as
the account type.
Click the Next button.
A window with the Service Agreement will display.
Click the OK
button to continue.
Respond Yes or No to the next question displayed, ‘Do you want to
enable additional accounts?’
Respond to the next question ‘Enable accounts at another Financial
Institution?'
Your account is now enabled to download in QuickBooks and you are
now ready to use online banking.
****If your financial institution was not on the list. select, ‘My
financial institution is not on the list’.
Click the Next button.
The Financial Institutions directory is displayed. Select
‘American Express’, click Add to QuickBooks button then click Exit
on the menu bar. You will then make an Internet connection to add
American Express to your personal Financial Institution list in
QuickBooks.
When the previous step is complete, follow the above steps again
to get to the ‘Select a financial institution’ window.
- To download credit card charges into
QuickBooks.
Change to single user mode in order to
download charges.
From the Banking menu, choose online banking
center
Select American Express as the Financial Institution
Click on Send
Enter your pin number. You may need or opt to enter a new pin
number at this time
American express downloads your transactions.
- Click on the icon that appears in the bottom part of the online
banking window labeled
American Express Quick Statement
A register will open which will allow you to add each transaction
to the register.
- To add the transaction to your register
Select only those transactions you wish to enter (see step
9 below)
Highlight the transaction
Click on Add credit card charges
Click on OK
Enter an account and memo and class (if you use class)
Save and close and go to the next transaction.
Then click on done. Click through any message that appears if the
remaining transactions in this window have already been
accounted for (see step 9 below)
Not interested in having all those names created in your vendor
or other names list? Cut (highlight the payee name then
CTRL + C) then paste into both memo fields (mover cursor to the
memo field CTRL + V - repeat with the second memo field). You
can type your description of the purchase (if necessary) after
the payee name in the bottom memo field. Leave the name
field blank it is not required to save the transaction.
Your reports will be meaningful and your list names will remain
manageable. For payments to payees that you use regularly, go
ahead and keep the name in the "purchased from" field.
Also, using generic vendor names such as food, parking, gas, hotel, and
Misc Vendor can be set up when it is
not necessary to have a specific vendor's name on the transaction
and you dont need the detail in the memo field.
- For the initial set-up. You will
want to enter only those transactions that are unpaid. This is
assuming the transaction has already been accounted for in
QuickBooks. For assistance
with this step, we offer
QuickBooks support through via telephone, e-mail or
remote access
- With the click of done in step 8 you will
return to Online banking center window
At this point you can use the delete button in the lower right of
the window (next to items received from
financial institution) to delete all unwanted transactions.
- In many small businesses credit card
charges do not have packing lists, receipts, purchase orders or
other documentation for the bookkeeper to refer for reference in
categorizing the expense. By downloading new credit card
transactions into QuickBooks every few days your memory will be
fresh and your books and records will become more accurate.
- Reconcile this credit card account before making a payment.
Works just like the bank reconciliation.
From Banking > Reconcile > select the appropriate credit card
account and enter the ending balance information.
When you are through marking all the transactions that have
cleared, and the difference is zero, click reconcile now.
At this point, QuickBooks will generate a payment for you
If you are not paying the balance in full, enter a bill for
a payment to be made later. The reconciled balance is then transferred to
accounts payable.
One more adjustment is needed. From the accounts payable
summary, drill down on the credit card vendor and find the
transaction that was just created and change to the amount you
intend to pay. This will set the numbers straight for next
months credit card reconciliation.
While the set-up looks complicated. The
time invested will be repaid very quickly. The accounting
for credit card transactions each month will be significantly
reduced and your internal financial reports will become more
meaningful. If you charge your business expenses this is one
QuickBooks feature that you should not live without. Contact
us if you would like assistance.
Get
cash back rather
than points
when you use your American Express card.
Costco American Express - Cash Rebate Credit
Card. Get money back and save time with transaction entry to boot!
Download into QuickBooks your daily purchases to maintain better
control on how, where, and why the purchases were made. An annual
membership fee of under $40 gets you membership to Costco plus may net you thousands of dollars in
a rebate check depending on your volume of purchases.
American Express Blue
We found this card to provide a better dea! No annual membership
fee applies. The rebate is an annual rebate equal to the following
percentages of your annual level of purchases: .50% on everyday
purchases and 0.25% on other purchases for the first $2,000; 1% on
everyday purchases and 0.5% on other purchases for the next
$4,000, and 3% on everyday purchases and 1.5% on other purchases
for purchases in excess of $6,000. If your account is carrying a
balance, you will receive an additional 2% rebate for that billing
period.
Everyday purchases include purchases at
stand-alone U.S. supermarkets, gas stations, drugstores, and home
improvement stores. Stand-alone locations do not include the
departments of superstores or warehouse clubs where the standard
rebate of up to 1.5% applies
Discover
software that integrates with QuickBooks to get the job done
faster, easier and more thoroughly.
QuickBooks Add Ons
QuickBooks Help Home
|
