Simplify credit card entries for travel

I have a lot of clients. Pretty much all of those clients have a credit card or two (or three, or four...) that they use for business purchases. Clients take business trips. And on such business trips, they use their business credit card(s). A lot.

All these entries to record the purchases made while traveling can take a lot of time to enter, especially if the client patronized a lot of independent business.... "mom & pop" type places.

In the Vendor List in QuickBooks, you cannot delete a vendor once they have been used in a transaction. They can be made inactive and therefore hidden from view, but they cannot be deleted.

Many of the places my clients patronize when they travel, I do not expect them to return to in the future. To save myself entry time (and bookkeeping fees for my clients) as well as keep their Vendor Lists as lean as possible, I enter a lot of their travel expenses to generic vendors that I set up.

I generally set up four generic vendors in my clients' QB files for use when entering their travel expenses:

• Travel Meals
• Travel Entertainment
• Travel Misc
• Taxi/Shuttle

Let's say I'm working on the bookkeeping for a client who is based in Oregon. I'm entering transactions from their credit card statement and I see some entries from restaurants that are located in Las Vegas. If I see charges to Starbucks, I'll enter that under a vendor called Starbucks and coded to Meals as there are Starbucks located all over and chances are, the client will visit another Starbucks in the future if it's not already in their QB file from previous entries. The same goes for places like Burger King, The Cheesecake Factory, Red Robin, Taco Bell, etc.

But if I see a purchase from "Rosemary's Restaurant" and see from the statement that the restaurant is located in Las Vegas, I will enter it to the vendor Travel Meals, code it to meals, and enter Rosemary's Restaurant - Vegas in the memo area.



If there are purchases on the credit card for entertainment during the trip to Vegas such as a tour of some kind, tickets to a show, etc I will book those to Travel Entertainment, code them to Entertainment Expenses and notate in the memo who the charge was actually to.

Taxi and shuttle fares I will code to a vendor simply called Taxi/Shuttle and entered to the Travel Expense account. Clients who travel for business will use a lot of different cab and shuttle companies and it's not necessary to have all of them entered as separate vendors.

When it comes to the lodging expenses, it depends on what company the clients stayed with as to how I will code it. If they stayed at a major-name hotel such as Hilton, Marriott, Hyatt, etc then I will code it to vendors named as such. I will not create separate vendors for the same hotel chain in different cities such as "Marriott - San Francisco" and "Marriott - Seattle." I will just name the vendor "Marriott."

But if they stay at an independent place such as "Little Blue Moon Inn," then I will code to to the Travel Misc vendor and enter it to the Travel expense account, again notating in the memo area the actual name that appears on the CC statement.

Other odd expenses incurred when traveling such as gift stores, souvenirs, etc I will code to the vendor Travel Misc and then to an appropriate expense account depending upon what was purchased. If it was a personal purchase and non-deductible for their business, I will enter it to their Draw or Distribution account, depending upon the individual client.

I hope this helps give you guidance as to how to make credit card entries a bit more simple!

~Cathi