spreadsheets

Learning2Budget

I havent got a clue and i think i need a spreasheet to help with my budget. I used to have one yhat i got off here but it was on my old computer. could anyone help me please?L2B.x

datlex

Spread sheets can be very useful when it comes to budgeting particularly if you are paid weekly but have monthly bills. I use a spread sheet in conjunction with piggy banking.

Sheet one relates to my bills account, the money in this account as the name suggests covers bills. I make a payment calculated using the spread sheet to thisaccount every week;
This account is never used for spending

Sheet two relates to my current account.

It has a number of columns:- Incoming = pay Outgoing = moneyto bills account which leaves a balance Tesco shop= budgeted at £43.50 a week but normally come in under. The Tesco shop and slimming world columns deduct from the balance togive the non-allocated column. The spent column fills from sheet 3. This column is the deducted from thenon-allocated column to tell me what I have left to spend.

Sheet three is my spending record. Every time I spend I put it in sheet three which then automatically populates the relevant column in sheet 2.

This works for me as I have a current total of what I really have left to spend- banks can look artificially healthy before bills come out.

Learning2Budget

I have managed to create three columns for bills, outgoings and incoming but i don't know how to create a total for outgoing minus incoming? I have got it to add all the columns up so i have totals but how do i minus b from c?

datlex

In first cell of row D type =C1-B1 (or 1st cell in each column). Then copy it down to the rest of the cells in column D

azlan

I use this amazing spreadsheet from the old style board.

https://forums.moneysavingexpert.com/discussion/comment/39711066#Comment_39711066

datlex

Interesting spread sheet, could be useful to work out spending. I'm not sure though how it keeps you on top of your spending? Which I presume is why the OP asked about spread sheets in the first place. How without an income column do you know if you are staying within your means?