|
Aug 2022
10:53am, 19 Aug 2022
138,444 posts
|
GregP
Be gentle, for I am just a simple soul.
|
|
Aug 2022
10:56am, 19 Aug 2022
138,445 posts
|
GregP
I but a widget today for £10,000. I put in in my home spreadsheet as an entry in the outgoings. Job done.
With me so far? Good.
|
|
Aug 2022
10:56am, 19 Aug 2022
8,992 posts
|
Dooogs
I just used a basic for spend monitoring when we were skint. I can imagine some fancy software where you could e.g. import your credit card and bank statements and then tag entries with categories, would be helpful, though...
|
|
Aug 2022
10:57am, 19 Aug 2022
8,993 posts
|
Dooogs
Ahhh, it's a narrative... 
|
|
Aug 2022
10:58am, 19 Aug 2022
138,446 posts
|
GregP
But suppose the salesperson at Widgets-R-Nosotros offers me interest free credit? So the £10,000 can stay in my bank account earning a teeny-tiny bit of interest and I pay it back in £1,000 instalments over the next 10 months.
What do I do with my spreadsheet?
Please be gentle. And no pointing-and-laughing.
|
|
Aug 2022
10:58am, 19 Aug 2022
138,447 posts
|
GregP
Yes, sorry Dooogs, should have been one post.
|
|
Aug 2022
11:01am, 19 Aug 2022
8,994 posts
|
Dooogs
I'd be minded to do it on a cashflow basis (i.e. recognise zero expenditure now, and include the instalments as paid off instead).
Not how you'd do it in a company (I'm assuming you're not bothering with a balance sheet, depreciation, etc) but you presumably don't need to get this audited at year-end...
|
|
Aug 2022
11:04am, 19 Aug 2022
138,450 posts
|
GregP
I have more idea what the second sentence means than the first.
I'm sure what you said was very well intentioned, but it made as much sense as VLOOKUP would to my father*
|
|
Aug 2022
11:05am, 19 Aug 2022
138,451 posts
|
GregP
*late father
|
|
Aug 2022
11:07am, 19 Aug 2022
8,996 posts
|
Dooogs
Hahaha, sorry.
Right, I'd:
a) Record nothing for the day of purchase;
b) Record the 10 x £1,000 instalments over the next ten months;
c) Don't forget the interest income if you're being fussy over everything tying up to the penny
|
