Hello everyone! Before you continue, beware! This is a big post... 
I'm making a personal expense tracker/budget sheet and I've gotten a lot of input from Chandoo's posts.. but now I got a lil stuck and would appreciate your ideas.
I import my bank statement to my transaction sheet and then I categorize every transaction (I find this more practical than keeping track of every expense by hand). I managed to conciliate 2 checkings accounts and 3 credit cards, but I am not sure how to manage money payments...
I have the columns below:
Type - Expense | Income | Investment
Category - Education | Health | Personal etc - and a special 'conciliation' one
Sub-Category - linked to the category, it's pretty straight forward, however, for the 'conciliation' category I have the 'credit card | checking | money' options
Base - checking | credit card | savings | money
Movement - bank A | bank B | credit card A | credit card C
So I might have transactions like this:
(1)Value Type Category Subcategory Base Movement
(2) -1.300,00 Expense Conciliation Checking Checking Santander (money wired)
(3) +1.300,00 Income Conciliation Checking Checking Citibank (money recvd - zero effect)
(4) -500,00 Expense Health Dentist Checking Citybank (actual expense)
So this works great as I can follow up on my money from many different angles.. but how do I conciliate money transactions? So far I kind of see 2 options:
1. My checkings account will show a withdrawal transaction that I would categorize like the ones above (-200 expense conciliation checking pocket), suppose I manually enter what I did with the money I got: -100 goes to fuel, -50 goes to food. My "pocket" balance is +50, so for each manual transaction I input I'd have to make a manual conciliation transaction. This is good because it allows me to see all my transactions in one report, but this sucks because it requires manual inputs
2. I keep track of my "pocket" checkings on a different sheet - make a formula that captures the total amount withdrawn from the transactions sheet and bring that amount as income to my pocket checkings and manually input the money transactions here. Seems like a more elegant solution, as "pocket positive balance" doesn't necessarily mean money in my pocket, most likely it'd mean I just don't know what I spent it with!
So, lemme hear your thoughts.. any input would be most appreciated!
Regards,
Katia
I'm making a personal expense tracker/budget sheet and I've gotten a lot of input from Chandoo's posts.. but now I got a lil stuck and would appreciate your ideas.
I import my bank statement to my transaction sheet and then I categorize every transaction (I find this more practical than keeping track of every expense by hand). I managed to conciliate 2 checkings accounts and 3 credit cards, but I am not sure how to manage money payments...
I have the columns below:
Type - Expense | Income | Investment
Category - Education | Health | Personal etc - and a special 'conciliation' one
Sub-Category - linked to the category, it's pretty straight forward, however, for the 'conciliation' category I have the 'credit card | checking | money' options
Base - checking | credit card | savings | money
Movement - bank A | bank B | credit card A | credit card C
So I might have transactions like this:
(1)Value Type Category Subcategory Base Movement
(2) -1.300,00 Expense Conciliation Checking Checking Santander (money wired)
(3) +1.300,00 Income Conciliation Checking Checking Citibank (money recvd - zero effect)
(4) -500,00 Expense Health Dentist Checking Citybank (actual expense)
So this works great as I can follow up on my money from many different angles.. but how do I conciliate money transactions? So far I kind of see 2 options:
1. My checkings account will show a withdrawal transaction that I would categorize like the ones above (-200 expense conciliation checking pocket), suppose I manually enter what I did with the money I got: -100 goes to fuel, -50 goes to food. My "pocket" balance is +50, so for each manual transaction I input I'd have to make a manual conciliation transaction. This is good because it allows me to see all my transactions in one report, but this sucks because it requires manual inputs
2. I keep track of my "pocket" checkings on a different sheet - make a formula that captures the total amount withdrawn from the transactions sheet and bring that amount as income to my pocket checkings and manually input the money transactions here. Seems like a more elegant solution, as "pocket positive balance" doesn't necessarily mean money in my pocket, most likely it'd mean I just don't know what I spent it with!
So, lemme hear your thoughts.. any input would be most appreciated!
Regards,
Katia
