Layout:
Home > Some close scrapes! and dealing with the overspending

Some close scrapes! and dealing with the overspending

July 17th, 2018 at 09:31 pm

Don't you hate the moment of panic when something goes wrong or almost goes wrong, but then love the endorphins that flood the body when you get back what you thought you might have lost?

Last week I was working in my Number Crunch worksheet. It's a Google Sheets file, about 12 years old, and I use it to keep my real-time budget; checking account balance at the top, future income and outgo below for anywhere from one to 4 months. Along the side I show the projected checking account balance after each transaction. I update the checking account balance frequently (at least a couple times a week, sometimes more than once a day) and delete transactions that have happened.

But that's not all; I also keep my own record of AS's freelance income on additional tabs (one for each year). It helps me track tax and retirement and see what income has already come in and what we're still expecting. It has also come in handy because AS sometimes misses things on her much more complicated tracking spreadsheet, so every once in a while we compare bottom lines to make sure we've got the same amounts, and if not we get to the bottom of the issue.

But that's not all! I also have a tab where I note utility costs for each month, and note the highest bill for each month for gas, electric and water/sewer/trash, as well as the average monthly cost each year. This helps me plan my annual budget.

But that's not all either! I also have a separate tab where I track all credit card purchases for the month. Between us we use our CC a lot, so this helps ensure I don't miss any transactions. That tab also has info on all open and closed cards.

Although much of the info in the sheet is "real time" meaning I delete old transactions, I'm also able to use the version history function to look back at changes if I ever think I've messed things up. I use that fairly often as well.

So yeah, that spreadsheet is a beast of burden that does a lot of heavy lifting in my personal finances! Anyway, I was working in it last week and my fingers slipped and I opened a new browser window. When I clicked back to Number Crunch, it said it was trying to update. So I closed out of it and tried to go back in. I got an error message! I tried another browser, same thing! I opened several other Google Drive files, no problem there, just with Number Crunch!

My stomach dropped. I called AS. I left a message on help forums. I went to the file on my phone and lo and behold it was there! I couldn't save it or email it, but I was able to copy the data on each tab and paste into a new sheet. However, it pasted values only, none of the many formulas I use throughout. And of course all the version history was lost! Ugh. But I was so relieved I at least had the info, and I updated a couple of the most-used formulas.

I kept checking the help forum and it said there was an overall problem with Sheets. I didn't think this could be what happened since my other Sheets files were fine, but then lo and behold, they said the problem with Sheets was fixed, I tried to go into my old Number Crunch, and there it was in all its glory! I was sooooo happy. I actually felt euphoric.

I kept the one where I pasted numbers only, just so I now have some kind of backup. AS says I should probably save a backup outside of Google Drive too, to be safe. I should look into that.

Anyway, it made me appreciate the file all the more; in 12 years I'd never even considered the possibility that I would ever not be able to access it. I didn't realize how much of my peace of mind is wrapped up in knowing that document exists!

This was a much smaller moment, but today as I was about to step off the bus to take my 6-year-old to summer care, I suddenly felt lighter. I looked back and realized I'd left my purse on the seat! I grabbed it and stepped off the bus, thinking about my work phone, my wallet, my keys and my expensive glasses. Boy was I glad I hadn't left that purse! And it made me remember last week's close scrape with the spreadsheet and decide to write about both moments.

***

In other news, AS has the big freelance job! She'll invoice them for hours worked each Friday and get paid the following week. She's also got another multi-piece writing job that she'll be billing hourly for and invoicing as she delivers each round of. So a huge job and a pretty big job that aren't reflected in the spreadsheet because we're not sure how much they'll be in total, but I'll be adding them to the spreadsheet incrementally as she invoices.

It's a good time to be pulling in regular work because booking our UK airfare earlier than expected has stretched our available funds. I'm actually keeping an eye on whether I need to transfer money from savings temporarily to cover that credit card balance when I pay it off in mid-August. It'll be close, but thanks to Number Crunch I'll be able to forecast whether or not we have enough in the account.

We normally have a lot of cushion in checking just because I budget out so far, but with shared spending money a lot in the red, vacay fund a little in the red, and NT's personal money quite a bit in the red due mainly to buying inventory for his hat business, the float margin is looking very tight in August when we pay off the big credit card balance we racked up from UK airfare, our recent Va. trip, NT's inventory, summer program tuition for the kids, and other things. Close to $10K all told will need to be paid off!

Luckily even if we have to transfer from savings temporarily, I'm feeling good about much of the deficit being cleared up over the next few months. AS's two new jobs will help a lot, plus the other jobs she's already worked and expecting payment on, and hopefully NT will see some return on investment at a few key events coming up.

On the down side, we do have another family trip in early August, and they always end up costing more than I'd like. But we won't have to worry about those charges until mid-September, by which AS should have received quite a bit of money from her various projects.

This summer is even spendier than usual! We're having a blast, but one good thing about fall will be lower child costs with school back in session. Not just child care during the day but we tend to spend more on treats and fun activities during the summer.

The worst case scenario is that we would have to use some of our renovation savings to make up the deficit. We haven't heard back from our design consultant, and I'm inclined not to ping her, because that way we haven't committed those funds and have them in reserve if we can't dig ourselves out of the spending hole another way. Paying off the deficit right this second would take about a quarter of our reno savings. I won't do it unless I see no other way, and at this point, I do see a potential other way, so I'll wait and see how the next few months unfold.

5 Responses to “Some close scrapes! and dealing with the overspending”

  1. Butteracotch Says:
    1531861109

    Email a copy of it to yourself as an attachment each month- then you’ll always have a backup available.

  2. ceejay74 Says:
    1531861625

    Ah, that's a brilliantly simple solution! Thanks butterscotch! Big Grin

  3. CB in the City Says:
    1531923951

    I would just curl up and die if I lost all my spreadsheets! Actually, it happened once, but, although I lost the history, I was able to piece together the current info. I save all mine in a flash drive now.

  4. My English Castle Says:
    1531924123

    wow--I'm impressed with super simple butterscotch solution. And your record keeping.

  5. rob62521 Says:
    1531926579

    So glad you didn't lose the spreadsheets and your purse! You are very organized on those spreadsheets!

Leave a Reply

(Note: If you were logged in, we could automatically fill in these fields for you.)
*
Will not be published.
   

* Please spell out the number 4.  [ Why? ]

vB Code: You can use these tags: [b] [i] [u] [url] [email]