Forum Discussion
Can someone please help me to make an easy spreadsheet with some formulas?
Hi there,
I have some basic knowledge of excel but it’s been such a long time ago I don’t remember any of the formulas.
Would someone be able to guide me through how to make a spreadsheet for income/expense with some extra formulas if it’s even possible?
These are the things I would need:
- income summary
- expense summary
- categories of kind of expense/income
- 13% tax on some categories that shows in 2 different columns for sales and income
Thank you for any help or advice in advance!
Cheers!
I've done a quick and dirty example of a slightly different--and highly recommended--way to record and summarize income and expenses. I used your database as a starting point, and did not fully understand the hidden column in yours (and as it was read-only I couldn't open it).... I added some random numbers for Feb and March, just to illustrate how easily this summarizes by both month and category. I also put all amounts into a single column, and used a separate column to desi
But what you'll see is I think a better way to track income and expenses, and makes use of the Excel feature known as a Pivot Table to summarize. Here's a screen grab of the Pivot Table, which was easily constructed from the database.
Here's a ink that explains how to construct and refine Pivot Tables.
https://exceljet.net/glossary/pivot-table
You'll find many resources on YouTube as well.
7 Replies
- You may want to take a look at some of the free templates available through the File menu, go to New and search for "income" or "expense".
- Pretty strange your request. What do you mean by "guide me"? In a remote session? There are hundreds of youtube-videos and books where you can learn from.
Werner_Geiger I have tried, that was the first thing I looked up I just couldn’t find anything about how to automatically take the tax portion off. I know how to do the sum for the income/expense and stuff I’m just not sure if it’s possible to make anything with the tax portion on some columns.
‘Guide’ might have been the wrong word to use though. Help me in anyway would work better I guess.
Thanks for your response!
You've written
I know how to do the sum for the income/expense and stuff
So that implies that you've got a worksheet going that does summarize and total those two categories. Why don't you share a copy of that workbook so we can work with what you've already done, perhaps improving it some, but definitely seeing something concrete to respond to. If you can't post the workbook to this forum, try saving it in OneDrive or GoogleDrive and granting access to the public (obviously delete any truly personal info first).
You also wrote:
I’m just not sure if it’s possible to make anything with the tax portion on some columns.
And I think you mean what you referred to in an earlier message, something to the effect, "taking off 13% from some income/expenses". And we should start with "OF COURSE it's possible." For example, if cell B1 contains the expense amount including a 13% tax, this formula in cell C1 would yield the amount of the expense before the tax was applied. =B1/1.13
