well, i keep it pretty simple really. balancing the checkbook, etc i do all online with the banks web interface so i do not track that at all beyond looking at my accounts every couple of days.how do you have yours setup?
thanks for that. maybe i should try excel to do mine as well. i have to get organized like you are first i guesswell, i keep it pretty simple really. balancing the checkbook, etc i do all online with the banks web interface so i do not track that at all beyond looking at my accounts every couple of days.
i have one sheet setup with shared costs my girlfriend and i spend; every time we goto the market, or home depot, etc. and one of us pays we put the money in as a line item, split it in half and add it as a debit or credit; that keeps a running tally of how much money she owes me/i owe her at any given moment.
i have another sheet with basic client info like open invoices, what has been paid, what is due, etc.
all of my receipts go into a monthly folder that the accountant gets at the end of the year (this includes printouts of my utility bills i pay online and photocopies of cancelled rent checks since i write off part of that stuff as a home studio.) i also keep a sheet listing anything that is purely a business expense (computer stuff, office supplies, etc..) just as a reference.
theoretically i could do all this in some specific application (quickbooks, etc.) but i find excel easy to use and until i am managing more than myself and the occasional subcontractor i do not think i am going to change. i like to keep the money stuff as simple as possible. all you really need to know is take in more than you spend.
as far as the rest of my organizing goes, i am desperately trying to figure out some system that works for me (in terms of project management, to-do's, lists, calendars, etc.) as referenced on a post here, here and a few other forums.
Found this comment from one of the software support guys on the iBank forum:I have been looking at that one. Can you download your account information from your bank??
I think that Qucken and MoneyDance are the only two Mac apps that download directly into your register. The others use the two step export, import process.I use Moneydance, which is able to download transactions online using OFX/QFX, which is the same protocol Quicken uses to synch with the banks. The interface is not particularly pretty, but it does everything I want it to and with less hassle than Quicken or (shudder) GnuCash.
I've never seen a bank that provided Excel download format, but some of them have CSV, which can be imported into Excel and databases. QIF and OFX seem to be the typical formats.I have iBank but I'm still not convinced with it. I have used excel since switching to Mac, but I do wish my bank would allow me to download an xls file. Only options I have are money and quicken files and we all know only quicken is useful to Mac.