Personal Finance Manager – Excel Template v2

Posted on

Hello Everyone,

I am glad to announce that the Personal Finance Manager template has been upgraded with the following key enhancements. The files are available for download in the same page.

  1. Increased number of accounts – Now can handle 20 bank accounts, 20 credit card accounts and 20 cash accounts.
  2. Increased number of categories and subcategories to unlimited
  3. Added new chart on account balance trendsPersonalFinanceManager_Excel_Template_Report_4
  4. Improved Year – Month slicers in the Report sheet. I am using calculated fields (Year, Month) in the Transactions sheet.
  5. A new version compatible with Excel for Windows 2007 and Excel for Mac 2011 has been added.

Please try the new version and provide feedback.

12 thoughts on “Personal Finance Manager – Excel Template v2

  1. Why can’t I see ‘ did I exceed my overall budget ‘ ? Even when I have filled them in setting section

    1. Please email file to
      Best wishes.

  2. Thanks for this wonderful Template. While this is good for monthly expenses ? How would you suggest factoring in expenses which happen may be once or twice a year- such as Insurance premiums, property tax, vacations etc. Typically for expenses like these, we save certain amount every month and pay it once a year or so. Hence can’t accurately predict it in Monthly budget under expense category.

    1. You are welcome. You are correct. Non-monthly expenses can show up as exceeding budget when they happen. This is a feature I need to figure out for future version.
      Thanks for feedback.
      Best wishes.

  3. Hi,
    I have started using this template and it is awesome for my person financial management. I have friends and family members to whom either I have lent to or borrowed money from. How to keep track of such transactions?

    1. Thanks. Please try creating dummy bank accounts in the name of each friend and enter transactions accordingly. Best wishes.

  4. hi what the password for ur excel sheet

    1. Password is indzara

  5. Iam unable to refresh the report and the year is not getting updated

    1. Please clarify what ‘unable to refresh’ means. Are you refreshing with DATA — refresh option, but report data is still the same? Please send file or screenshots to indzara at gmail and I will be happy to address your questions. Thanks. Best wishes.

  6. Is it possible to make Expensive subcategory linked to Categories? Like a dropdown that will show only subcategories linked to the category already selected.

    1. Yes, this can be done. There might have to be some limit on the number of categories, to enable this feature. I need to consider this for the next version. Thanks & Best wishes.

Leave a Reply

Your email address will not be published. Required fields are marked *