How do I create a one-time category for one month?

Hi everyone.

Is there a way to have an item show up on the monthly budget sheet only once? For example: a one-time purchase that is planned, yet I want it to show up on my monthly budget sheet. In my case, a water heater replacement. I can put the amount in the “Home Improvement” category (or a similar category) but would really like it to show by itself so I don’t have to dig through transactions to remember what the high cost was for. But I DON’T want it to show on every other month with a $0 budget.

tl;dr: is there a way to have specific months in the Monthly Budget sheet have unique categories?

Thanks in advance!

3 Likes

That’s actually a very excellent question. What is the best way to handle big one-off’s category/budet-wise-speaking? I have several this year and would love a better way to manage them than just throwing them into a regular category - cat surgery in February is making my pets budget look weird.

2 Likes

How about just setting a category called “One-Time Purchases”? Add a note in your category cell if you want to remember from a high-level view on what that was for.

1 Like

Love this idea! You can also add a Note column directly to the Categories sheet (I usually insert left of the Account column to avoid it inheriting the format of some other non-text column). You can grab the column header letter and then drag to a new position if needed.

How I handle that is to have my regular category for Home Repair, and a second category of Home Repair: Special Projects. We usually only have one, or maybe two, larger purchases or projects with multiple purchases, per year. So if I have to go back and look then I would know that we got new siding in January 2019 and gutters in March 2019, so that’s what the category was used for in those months. This eliminates the need to create and archive categories. I do just leave it showing all year since I look back every month at my monthly totals as well as annual budget.

(You could have a generic Special Purchases category, but for me they are always home repair or home improvement projects. For other items, I just throw them into the most appropriate category even if it bumps it up an unusual amount for the month.)

1 Like

Lots of good ideas here.

@purplebudget : If you add a note to the category cell in the Month Budget sheet, the position of that note could change if you add or remove Categories. If you were adding the note in the Categories sheet, that would work fine. Or you could add a Notes column to the Categories sheet as @heather suggested.

If you want to view a list of all your “One-Time Purchases”, you could use this formula on a new sheet:

=FILTER(Transactions!A:F,Transactions!C:C="One-Time Purchases")

This assumes you want to view Transaction columns A thru F and your Categories are listed in column C of your Transactions sheet. You might want to be this formula in the 2nd row so you could add row headers to the top row.

A version of this formula could also be done using QUERY().
I use “Extraordinary Expenses” instead of “One-Time Purchases” for my unusual big expenses.

1 Like

@shanew

I do not do budgets so I would not know how that section is affected. I would get creative with the categories tab. Maybe create a group called extraordinary expenses and then create a category called water heater replacement, cat surgery, etc. Then make a pdf of the invoice, bill, paperwork, etc. and attach it to the receipt column on the transactions tab. Sort the transactions page by group if you ever want to see in the future all the transactions that hit this group.