Free Download: Frugal Pinoy Budgeting Spreadsheet
I made something special for you, Frugal Pinoy readers. It’s a spreadsheet that allows you to budget your money, track daily expenses, and track your income as well. Here’s a screenshot of it:
I made it with Open Office Calc, the free alternative to Microsoft Excel. I’m not sure if the file will work with Excel, so you might have to download Open Office first if you don’t have it yet (click here for the website). I’m sorry that I don’t have a version in Excel, since I don’t have a copy of the program. You’re free to convert this spreadsheet into an Excel file, though, if you know how.
To get the spreadsheet, right click the link below and click “Save target as” or “Save link as”:
The spreadsheet may be a bit confusing, so I made a tutorial video (presented in Tagalog – thanks for pointing it out dyoonet!). It’s 16 minutes long. If I’m explaining things too fast in the video, you can pause it and play it back. To see it in detail, you can view it in full screen by clicking the 
button on the bottom right of the player below.
To make sure that the video plays smoothly, play it first with the sound off so that the video loads completely. Then, watch it with the sound on.
If you have any questions/feedback about the spreadsheet or the video, feel free to comment below.
Do you use a spreadsheet to track your income and expenses? If so, share your tips with us.
14 comments
Leave a Reply
Help Iligan and CDO
Nice! I downloaded it na. Ok yan, me how-to video (ano ginamit mong software for creating the video?). Ang comment ko lang, Tagalog pala yung video…so siguro give notice na lang na in Tagalog lang sya. Or give subtitles or maybe create a version for those readers na di nakakaintindi ng Tagalog (I’m sure me babasa ng blog mo na di lang Pinoy).
*Correction: Nagbabasa ng blog mo. According to Alexa (if we’ll believe Alexa), as of this moment, 59.8% of your traffic come from the US, while only 40.2% originate from the Philippines.
http://www.alexa.com/siteinfo/frugalpinoy.com
Camstudio ginamit ko
Napaka user-friendly. Nakita ko lang sa Mashable. Try mo, masaya!
Hehe, baliktad sabi ng Analytics – pinakamaraming visitors galing sa Pilipinas. Anyway, kung may magrequest ng English gagawa ako, pero I was thinking more along the lines of gagawin ko yon para sa mga Pilipino na hindi sanay mag-Tagalog.
Nice spreadsheet! Meron din ako nagawa dati, parang format ng cashflow 101…madali kasi makita kung paano nagfo-flow yung cash…pero after a few months, di ko na rin na-maintain…kaya wife ko na may hawak ngayon ng bagong spreadsheet. hehe
May nakagamit na ba ng mga FREE online pesonal budgeting software like mint.com or wesabe.com or quicken online sa Pinas? Anong experience niyo dito? Yung mint.com mukhang automatic na niya ine-extract transactions mo from credit card at bank accounts…hassle free kasi di mo na kelangan manually ie-enter. downside lang, medyo scary kasi ina-access niya accounts mo although “read-only” siya for now. Ok sana siya pero mukhang di ata nagagamit sa Pinas.
Free software ba yung camstudio? Ok yun naka-capture niya yung screen ng PC. Galing! Matingnan nga rin one of these days.
Sinubukan ko na yung wesabe pero tama ka, hindi applicable yung pag-extract ng transactions sa Philippine bank/credit card accounts.
Oo, free ang Camstudio
I-google mo lang.
Hi! Nice spreadsheet. Actually you can save the spreadsheet in excel format. Just use the “save as” option. It will then save it to *.xls format. That way both Open Office and MS Office people can use it without downloading the freeware. ^_^
Open office is superb. it can open from old .xls files and .xlsx
. libre pa 
.
@Ning: Thanks for dropping in
The problem with saving in excel format via openoffice is that the formulae and some settings don’t always translate well. When I do that, I have to check it in Excel itself afterwards to see if everything converted properly. I’ll definitely upload an Excel version when I get the chance to do that 
@emilie: I agree.
I don’t know if it’s the same for everyone else, but it loads faster for me too.
Hey Celine. I was cleaning and backing up my hard drive when I found your spreadsheet again (haha huli ba?). Very timely, because I was budgeting earlier and I was reminded again of the many budgeting tools that I’ve researched and compiled. Now I should really USE them. Since I want it to be accessible anywhere I uploaded the file to Google Docs. Seems to work naman — I will let you know if there’s any macro or formula issues.
This would depend upon the user’s preferences, of course, but I thought that it would be a good idea to put SAVINGS before the UTILITIES section as a psychological reminder that savings should be set aside first, not as an afterthought. Or, since Savings technically isn’t an Expense, to put it on a separate section prior to the latter. Just a suggestion.
(This –and Allan’s comment above–also crystallized my idea for a POST.) Thanks!
That’s a good idea – to have the savings section before everything else as a reminder to pay oneself first.
Thanks Junnette, great tip, I’ll do that for my personal spreadsheet too.
Sorry, I meant that I uploaded your spreadsheet to Google Docs bec. I want it to be accessible anywhere — and that I should start using your spreadsheet and the other tools. (Yan ang hirap when you combine sentences or fragments without rereading the entire thing.) :p
Hi!
Good day! can you send me an excel file format of the spreed sheet. Hope you could provide the soonest. this will help me a lot on managing my personal finance. Thanks
Hi Manny,
I don’t have MS Excel so I can’t make the file available soon. Have you tried using the current file with Excel? It might still work.
Hi celine. trying to save your spreadsheet. not successful though.