SoftwarePersonal Finance Software me-do

 

Press Ctrl+Enter to quickly submit your post
Quick Reply  
 
 
  
 From:  koswix  
 To:  ALL
41910.1 
That time of year again where I think there must be a better way than using silly spreadsheets to track how many pennies I've got (or not got, mostly).


What I currently have is an excel document with a tab for each month. Each line tracks a single debit or credit, with a date attached. Each new month is basically a copy of the previous one, with direct debits and standing orders already filled in but everything else blank. I also pre-fill a standard amount each week for food/household shopping, then revise it down to the actual receipt value when the transaction happens.  Balance is calculated on each line, and carried between tabs.



Then I've got conditional formatting that alerts if my balance goes below 0 (Yay, overdraft free!).


The main thing I like is that if I'm considering buying X, I can pop the figure into my sheet straight away it gives me an alert that in 2 weeks time I'll not have enough for a certain bill unless we eat pot noodles that week. 

Pretty basic, but fairly annoying to keep it all running and up to date, and hard to do any sensible analysis on where I'm actually spending my money.


Trouble is, every time I look at fancy pants software solutions they all seem to over complicate things and want to be more like accountancy than budget planning. And they don't (or at least, I've never managed to stick with them long enough to find) seem to do predicting future balances based on regular transactions. 

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.
0/0
 Reply   Quote More 

 From:  CHYRON (DSMITHHFX)  
 To:  koswix     
41910.2 In reply to 41910.1 
Mrs.D, a one time professional bookkeeper and tax return preparer does something very similar with an excel spreadsheet (and fucked if I understand any of it). Maybe that's as good as it gets
“Spiders could theoretically eat every human on Earth in one year”
0/0
 Reply   Quote More 

 From:  koswix  
 To:  CHYRON (DSMITHHFX)     
41910.3 In reply to 41910.2 
:(

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.
0/0
 Reply   Quote More 

 From:  milko  
 To:  koswix     
41910.4 In reply to 41910.1 
You Need A Budget
?

Think they might have moved to a subscription price or something which might be annoying. Otherwise could be what you're after.
milko
0/0
 Reply   Quote More 

 From:  Monsoir (PILOTDAN)  
 To:  koswix     
41910.5 In reply to 41910.1 
If it's of any help - I ran my Ltd company accounts from a (fairly complex, to be fair) Excel spreadsheet. It worked great, but I switched accountants and now I've got one of those fancy online accounting things.

Business wise it's great because things like bank reconciliation are flawless as it imports them in electronically (I.e., I don't have to go down my statement and add everything manually). It's also quite nice for past analysis and tracking, keeping HMRC happy and so on.

What it's RUBBISH for, though, is forecasting and budgeting. It was so easy to experiment with the numbers on a spreadsheet and you can take copies etc without any drama. The online one is all "real" - so if I want to run a forecasted profit & loss I can't, because it'd mean creating a made up invoice and then creating a credit note to get rid of it!

Honestly, for household stuff, I'd stick to Excel. 
0/0
 Reply   Quote More 

 From:  koswix  
 To:  milko     
41910.6 In reply to 41910.4 
So, so much :(

Even when I was earning a decent salary, I was perpetually skint and struggling to meet bills. Because a) I am absolutely awful with money and b) was, then at least, drinking far, far too much.

I've just finished doing an excel based budget for next month. I'm starting a new job on the 10th (yay!), having been out of work since graduating last year (boo!), and no matter what fancy formatting I try I can't make all the numbers look nice :(

The main issue really is that employers expect you to work for a month and then be paid, where as child care providers expect to be paid for a month and then do the work.

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.
0/0
 Reply   Quote More 

 From:  koswix  
 To:  Monsoir (PILOTDAN)     
41910.7 In reply to 41910.5 
>>Honestly, for household stuff, I'd stick to Excel.

... is pretty much the conclusion I always seem to end up at when ever I look at this stuff. Yet I live in hope that someone might, one day, create a decent software package for this. Ideally with a desktop & mobile client, perhaps linked through your own dropbox account or similar so you can CHECK YOUR FINANCES ON THE TRAIN  B-)

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.
0/0
 Reply   Quote More 

 From:  CHYRON (DSMITHHFX)  
 To:  koswix     
41910.8 In reply to 41910.7 
WRITE THE NEXT KILLER APP. YES, YOU!
“Spiders could theoretically eat every human on Earth in one year”
0/0
 Reply   Quote More 

 From:  koswix  
 To:  CHYRON (DSMITHHFX)     
41910.9 In reply to 41910.8 
Think I'll do a spreadsheet :((

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.

0/0
 Reply   Quote More 

 From:  milko  
 To:  koswix     
41910.10 In reply to 41910.6 
wait no.

I mean the piece of software called You Need A Budget.

As in, that's it. That's the thing. It probably doesn't do much your Excel sheet doesn't but it might be a tidier more automated way. They also have loads of little advice videos and stuff. There's a mobile app and I think it syncs through dropbox and everything.

edit: https://www.youneedabudget.com/pricing/ $50 a year though! I bought the previous version for about £10 on a Steam sale, though that obviously doesn't get the updates.
milko
0/0
 Reply   Quote More 

 From:  koswix  
 To:  milko     
41910.11 In reply to 41910.10 
Fuck me. I was even looking at that earlier last night. I blame sleep deprivation and lurgy (fail)

 ▪                    
             ┌────┐    ┌────┐                      
          │    │    │    │ ▪                    
          │    └────┘    │                      
          │   ──┐  ┌──   │ ▪                    
   ┌──────┤    ▪    ▪    │                      
  ┌┘      │              │ ▪                    
┌─┤       └──┐  │  │  ┌──┘                      
│ │          │ ││  ││ │   ┌─┐                   
│ │          └─┼┤  └┴─┴───┘ │                   
│ │           ─┘│           │                   
│ │   ┌──────┐  └┬──────────┘                   
  │   │      │   │                              
  │   │      │   │                              
  └───┘      └───┘                              
If Feds call you and say something bad on me, it may prove what I said are truth, they are afraid of it.
0/0
 Reply   Quote More 

Message 41910.12 deleted 23 Oct 2020 02:44 by MATT

Reply to All    
 

1–12

Rate my interest:

Adjust text size : Smaller 10 Larger

Beehive Forum 1.5.2 |  FAQ |  Docs |  Support |  Donate! ©2002 - 2024 Project Beehive Forum

Forum Stats