7 Personal Expense Trackers using Excel – Download Today

Share

Facebook
Twitter
LinkedIn

Download Personal Expense Tracker - Free Excel TemplatesKeeping track of your expenses is one of the fundamentals of living good life. So I asked you to prepare a personal expense tracker as part of our 10,000 RSS Subscriber Milestone contest. I have received 7 excellent entries in this contest, each capable of making expense tracking a breeze while providing good analytics of the expense data to understand how you spend.

Thanks everyone for participating and making this a huge learning experience for you and I. Personally I have learned several useful formula and tracker related tricks from this.

How to vote?

Each of the 7 entries start with a title including authors name. Each entry includes a small image of the tracker along with few other thumbnails. Click on the images to see them in bigger versions. You can download the source workbooks and play with the trackers yourself.

Tell me which one you liked most by posting a comment with the option number. The winner (option getting maximum votes) will get Toshiba Mini 300 Series Netbook.

10 K Contest Winner Gets a Netbook

That is right. A Netbook. (find out more about the exact model and specs here)

Please note that these files are copyrighted to original authors and you cannot use them for commercial purposes.

I have included 3 comments against each entry based on my understanding of the tracker. Please share your opinions and reviews using the comments section of this post.

Excel Personal Expense Tracker by Bigtaff [Option 1]

Excel Personal Expense Tracker by Bigtaff
Excel Personal Expense Tracker by BigtaffExcel Personal Expense Tracker by Bigtaff

My comments:

  • Looks awesome
  • Can handle multiple currencies
  • Provides excellent analysis on various criteria (by month, monthly, annual, by person, by category etc.)

Download this tracker [Mirror]

Excel Personal Expense Tracker by Cnat [Option 2]

Excel Personal Expense Tracker by Cnat
Excel Personal Expense Tracker by Cnat

My comments:

  • Very cool frequency analysis of expenses by date
  • Good use of in-cell charts to compare income with expenses
  • Simple, easy to use tracker

Download this tracker [Mirror]

Excel Personal Expense Tracker by Ibrahim [Option 3]

Excel Personal Expense Tracker by Ibrahim
Excel Personal Expense Tracker by Ibrahim

My comments:

  • Separate sheets for each of the 12 months, good for yearly tracking
  • Analytics by month or by expense category
  • Simple Grid like structure for entering data

Download this tracker [Mirror]

Excel Personal Expense Tracker by Karthik [Option 4]

Excel Personal Expense Tracker by Karthik

My comments:

  • Tracks expenses for one month at a time
  • Tracks various payment modes (cash, check, card) and payment due dates
  • Nice summary of expenses by account, payment status, category and week

Download this tracker [Mirror]

Excel Personal Expense Tracker by Pedrowave [Option 5]

Excel Personal Expense Tracker by Pedrowave
Excel Personal Expense Tracker by Pedrowave

My comments:

  • Simple tracker with easy input sheet
  • Option to track by month or by day of month
  • A simple chart shows income compared to expenses and savings

Download this tracker [Mirror, Pedrowave’s Website]

Excel Personal Expense Tracker by Romeog [Option 6]

Excel Personal Expense Tracker by Romeog
Excel Personal Expense Tracker by RomeogExcel Personal Expense Tracker by Romeog

My comments:

  • Looks awesome, the expense dashboard is quite versatile with ability to view expense data for any month, any number of days etc.
  • Easy to compare categories and choose which categories to include in output
  • Simple data entry sheet

Download this tracker [Mirror]

Excel Personal Expense Tracker by Tessaes [Option 7]

Excel Personal Expense Tracker by Tessaes

My comments:

  • Clean input sheets, easy to enter the data
  • Summaries by category and daily, weekly and monthly statistics
  • Simple charts to understand how actual expenses differed from budgets

Download this tracker [Mirror]

Please vote for the option you liked most:

Use the comments and tell me which option you liked best. Go!

Thank you

I sincerely thank Bigtaff, Cnat, Ibrahim, Karthik, Pedrowave, Romeog and Tessaes for taking time to participate in this contest and make such beautiful and delightful trackers. Thank you so much for your generosity in sharing what you know.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

21 Responses to “Make a Pivot Table in Excel [15 Second Tutorial]”

  1. [...] First step is to create Pivot Table. Here is a video tutorial on making pivot tables. [...]

  2. Wilson says:

    Dear Sir,

    I would like to study pivot table from basics detailed.Pls send me the tips of that

  3. baran says:

    merccccccccccccccccccccccccccccccccccccc

  4. [...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]

  5. surbamanyam says:

    it is very useful

  6. jitender says:

    hello sir

    please send me some information of pivotable. and how to use it
    because I am beginer so how can i learn it the pivotable.
    and sir will you send me pivotable data because i have no data and i don't
    know how to applyed for the pivotable. give some videos so I learn quikely.

    thank you
    and my best
    anticipation

  7. keri says:

    Hi,

    This tutorail was helpful. If possible can you please email me some data, so I can create another pivot table? I am trying to learn ASAP and need some info.

    Thank you

  8. yemi says:

    Top of the day to you. can you pls send me a detailed tutorial on the pivot table tutorial? Thanks.

  9. karthick says:

    Hi,
    please tell me how to use Pivot table.

  10. Pooja says:

    Dear Sir,
    I visited this website of urs for the very first time and trust me this is fabulous.i learnt pivot table through this.Thanks a lot.In corporate world nobody gonna make u learn these things.m very grateful to u.This is a great initiative from ur side.Commendable job done.Hats off to u.For beginners also this is very helpful.The way this website makes u learn excel is very good.

    Pooja

  11. Priscilla says:

    Can you please email me information to put into a pivot table and possibly a complete set of instructions?  I am a beginner to pivot tables and am possibly interested in obtaining a position that requires pivot tables.  thank you.

  12. [...] Click here to see a video tutorial of making pivot tables in excel | One more Pivot Table Video Tutorial [...]

  13. Kawsar says:

    It's simply great..!!

  14. James Perry says:

    Cool!
    Fast but not furious.

  15. Adepoju Teniola says:

    Pls email me details of pivot table. I want to learn it asap because I just got a job that requires this. Thanks

  16. nihal ahmed says:

    it is very useful..............thanks

  17. Tabassum says:

    Sir please can u send me the complete explanation of pivot tables from basics

  18. Guruprasad says:

    hello,

    I wanted to know how to put pivot with emp id, emp name, emp position in one row.

    Ex:-
    cel A4 should have Emp id
    Cell B4 should have Emp Name
    Call C4 should have Emp Position

    many thanks in advance

  19. George Dorne says:

    Nice information, thanx my dear.

Leave a Reply