![]() Repeat that for all of your groups of expenses. I recommend having rows of three blocks, with a column in between them. Instead of creating a new block for each group of your expenses, copy what you created and paste it beside the first block. That’s one group of expenses out of the way. ![]() You’ll have something that looks like this: Repeat that for the cells under the Amount heading, and choose Currency instead of Date. Click the Format menu and select Number Format > Date. Next, select the cells under the Date heading. Type the the names of the expenses in the group into the cells under the Expense column. In the row below the heading you just typed, add the following three columns: So it stands out, make it bold and in a larger font (12 points is good). Type the name of the expense group in the first cell of the fourth row from the top of sheet. Let’s start by putting the group of your most important expenses at the top of the spreadsheet. There’s a reason I had you group your expenses: those groups will become blocks on the spreadsheet. Leave three rows at the top of the spreadsheet blank. ![]() Start LibreOffice Calc and create an empty spreadsheet. You might also want to have a group of expenses with a name like Various for those unexpected expenses we all run into each month. For example, group your gas, electric, and water bills under the heading Utilities. Once you’ve done that, group your expenses under headings that make the most sense to you. Focus on where you’re putting your money. Don’t worry about how much you’re spending. Take your time, go through your records, and note everything down no matter how small. Sit down with pen and paper and list your regular monthly expenses. Start with a List of Your Expensesĭon’t bother firing up LibreOffice Calc just yet. ![]() You can use the information in this article with spreadsheet editors like Gnumeric, Calligra Sheets, or EtherCalc. Say you don’t use LibreOffice? That’s OK. In this article, I’m going to walk you through creating a more scannable and, I think, more visually-appealing personal expense spreadsheet using LibreOffice Calc. Many folks create a very basic spreadsheet to do the job, one that’s consists of two long columns with a total at the bottom. There are a number of ways to do that, but that quickest and easiest way is to use a spreadsheet. You probably need to watch your monthly spending carefully. If you’re like most people, you don’t have a bottomless bank account. This post was first published at and appears here via a CC-BY-SA 4.0 license. How to Create a LibreOffice Calc Spreadsheet to Track Your Monthly Expenses How to Create a LibreOffice Calc Spreadsheet to Track Your Monthly Expenses Open Source Musings ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |