Create a new custom sheet for me?

[jessmillion1]

Ever since I sold my business, I have been trying different systems to track spending for 3 different people in my family.

My son, my disabled mother, whom I care for and manage her finances, and I.

I have struggled with dyslexia and OCD for 44 years lol. I say this because I am highly functioning, but things with numbers have to be a certain way for my brain to focus without confusion.

So when I happened upon tiller a couple of years ago, things were not yet set up with my banks and such, so when I tried this time, they finally were, except silly Synchrony, they are always a problem.

I was so excited when I saw how the categories sheet was set up, so I thought.

My brain works in colors and organized numbers, fantastic.

But the data is not what I need.

Ie, the categories sheet is exactly what I was looking for in terms of how I’d like things to be organized.

Except, I need another sheet that is a replica of the categories sheet, that pulls data.

I need the totals per category totaled per month.

Delete (HIDE FROM REPORTS) Column D, and Jan - December needs to have the actual totals per category per month.

Exactly as it is, but with the transaction totals in the month/category box.

Obviously, the categories sheet is for the budget sections of the other sheets.

But I need a sheet laid out like the categories sheet that has the totals for the categories under the months.

To me, the monthly budget and yearly budget tabs do not do me any good. Because I don’t need a budget that I have to look at daily or weekly to see if I can afford something. I have that in my brain. But I need a spending calculation monthly and yearly, so I know how much I need to bring in to afford everything for everyone in the current economic state. So I can complete the yearly reports needed for SSA spending for my mom, filing taxes, what I can spare for debt payoffs, cost of living, and my son’s college/ Army life that I fund.

If I knew how to format a new sheet to do this, I would, but unfortunately, I do not.

I may be asking a lot, or something that you do not offer, which is OK. I’ve tried all avenues of other companies that can pull my financial data, both budgets and spending, and none of the other companies have come close to what I need until I found tiller.

[morgan]

This should be pretty easy formula-wise. I’m not a wiz on how to apply it to a whole sheet without going cell by cell though. I made a copy of my Categories tab, cleared out my budget amounts and renamed the tab to “Monthly Totals by Categories” then in the first cell did a formula that basically says “sum the total of (Amount column) if (categories column) says “Cars” (or whatever your category is) and (Date column) is in January of 2026.”

Then you would use that formula over and over ( this is where my skills aren’t stellar) but change the “cars” and “January 2026” to the different month and category for each cell. Looks something like this: =SUMIFS(Transactions!F2:F349, Transactions!D2:D349, “Cars”, Transactions!B2:B349, “>=”&DATE(2026,1,1), Transactions!B2:B349, “<”&DATE(2026,2,1)) and it works!

[morgan]

Hopefully someone smarter than me can chime in and help us bring that formula to the finish line to eliminate some manual work

[ghsubs1]

Take a look at the topic “ Income and Expense Report with One Formula “ Does that do what you want? I’m going to use it very much like you described, “I need a spending calculation monthly and yearly, so I know how much I need to bring in to afford everything for everyone in the current economic state.”

For myself I’m considering figuring out (with help) a version that will give monthly trend lines. However, seems that the budget sheets can do the same because it populates what you spent already, even if you do not have a budget

https://community.tiller.com/t/income-and-expense-report-with-one-formula/34078

[PCB]

Hello.

Try this. Copy it to your workbook and enter your categories, it should pull the numbers.

Formulas are in the cells of the months columns so don’t change that. That’s why the are white.

Let me know it it worked for you

Transactions per month

[jessmillion1]

Hello, PCB

Thank you for the insight. This is perfect and exactly what I was looking for! I was able to copy and paste the sheet and my categories, and it is totaling everything just as I needed.

Thank you so much!

[morgan]

This is awesome! Do you know what the conditional formatting formula would be if I want the amounts red if they are over budget (referencing Categories sheet) and green if they are under budget?

[PCB]

Maybe have a look at this discussion. If it’s only for the numbers and not the entire cell it looks like it would be less memory demanding to do it this way.

How to always show negative numbers in red

Conditional formatting would work, but it might give you a lot of fragmented rules if you copy paste a lot. I use the below number format: [image] if you want this for the transaction sheet, apply this to the whole row except the header, and because of the way transactions are added when filled it’ll keep that formatting. but either way works depending on what else you need and how you interact with your file

[PCB]

How To Format Negative Numbers In Red In Google Sheets [2026 Guide]

Found a video also if it helps

[nlynton]

Jess its great that you know how brain works. I also can’t use the monthly or yearly budget. I had to create something different for myself as well. What Morgan gave you below should work perfectly.
I use an average and do my totals per by by group.

[jessmillion1]

Thank you. That’s awesome.