Wanderlodge Gurus - The Member Funded Wanderlodge Forum
RV Expense Tracking using Excel - Printable Version

+- Wanderlodge Gurus - The Member Funded Wanderlodge Forum (http://www.wanderlodgegurus.com)
+-- Forum: Yahoo Groups Archive (/forumdisplay.php?fid=61)
+--- Forum: WanderlodgeForum (/forumdisplay.php?fid=63)
+--- Thread: RV Expense Tracking using Excel (/showthread.php?tid=1886)



RV Expense Tracking using Excel - Marv & Jean Wheeler - 01-21-2006 15:00

Is anyone on the forum using an Excel program to track their travel
expenses and RV expenses? I have all the data entered and I don't
guess I am smart enought to make the software massage the data.

If you are using something of this sort I would like to know what you
are using would you recommend it to someone else.

Thanks
Marv
2004 M380
Ocean Shores, WA


RV Expense Tracking using Excel - Pete Masterson - 01-21-2006 15:18

At 3:00 AM +0000 1/22/06, Marv & Jean Wheeler wrote:
>Is anyone on the forum using an Excel program to track their travel
>expenses and RV expenses? I have all the data entered and I don't
>guess I am smart enought to make the software massage the data.
>
>If you are using something of this sort I would like to know what you
>are using would you recommend it to someone else.
>
>Thanks
>Marv
>2004 M380
>Ocean Shores, WA
>

I use Quicken to track expenses for my small business. No reason it
couldn't be used for tracking expenses for travel and RV. It's simply
a matter of creating suitable expense categories, e.g. fuel, service,
campground fees, food, etc, --- and then entering the data.

Whenever you want to see what you've spent, you can go to the
"reports" section and select the time period and generate an
"income/expense" or "cash flow" statement.

As for Excel, you would need to sort the entries based on some kind
of expense categories --- e.g. fuel, service, campground fees, food,
etc. Hopefully, you included that information as a separate column
for each entry.

Select all of the columns and all of the rows where you have data.
Use the sort command on the category column (and, assuming you've
also entered dates for each entry) also do a secondary sort on the
date. (You'll will have those choices in the sort dialog.)

Once the spreadsheet is sorted, insert a blank row (or two) between
each category (that should all be grouped together after the sort)
and then use the sum function to total up the category.

It's a bit more work (than Quicken) but a spreadsheet can be an
effective way to track expenses.

--
Pete Masterson -- pete@...
Book Design and Production: A Guide for Authors and Publishers
Voice & FAX: (510) 222-6743 -- 9AM to 5PM M-F Pacific Time
Visit my web site at http://www.aeonix.com for publishing hints
P.O. Box 20985, El Sobrante, CA 94820-0985