Thread revival.
I have not balanced my checkbook in about 10 years. I just look at the online balance and say yeah that looks about right. However, what I would like is a program that allows me to download my bank records for the month, automatically categorize them and simply tell me how much income I had, and how I spent my money.
Based on this simplistic agenda, I started with Numbers 09 and it's checkbook template. First I downloaded the .cvs report and imported it into a plain Numbers spreadsheet. So far so good. Then I loaded up the Numbers Checkbook template that included a categories box and added up the categories for me. I messed with that for about 2 hours editing it so that the cvs report from my bank would load into it and the categories would register properly. The format is different than what my bank report so I've been trying to move the category column and insert new columns so the Numbers spreadsheet would match the banks report. I have managed to move the category column, but the individual amounts no longer register in the separate category totals.
Does anyone know how to add a category box to an existing Numbers spreadsheet? I've got an iWork9 Missing Manual book, but it's not novice user friendly at all.
Thinking it would be easier to try out some commercial software, I downloaded trial versions of of both
Checkbook Pro and
iBank 5. I setup and account in iBank and found out that to have "online connect to your bank capabilities, you have to pay $4 per month through a 3rd party or you have to manually download .cvs files. Looks like with CBP, there is no direct connect and you have download there too. Well, ok, I did this when I used to use Quicken, download files.
I turned to iBank, designated a checking account, selected the import feature for the .cvs file I had previously downloaded, and to my surprise nothing appeared. The account page is just blank.
Then I tried to import this file into CheckbookPro and it came up with all sorts of funky stuff, like 1,200,000 in my account (I wish

), and no values for anything imported with the same balance of 12000000 all the way down the page.
This must be operator error ? I'm not interested in balancing my check book, just want an expense tracker with automatically assigned categories.
I'll play with it more tomorrow, but can anyone tell me if I overlooked something basic in setting up accounts in these programs? At this point, if I can get the numbers spreadsheet to register category info summaries, that would be golden! Thanks!
