devliner.blogg.se - Balance my checkbook

they have showed up on your bank's website) Transactions that have "cleared" (e.g.

you swiped your card, you wrote a check, etc)

Transactions that you have executed/paid (e.g.

Transactions that you have not actually executed/paid yet (typically this is bills that are due in the future).

There are three basic kinds of transactions: I basically use this for "Income" and "Expense" because I used to have reports (TODO).ĭay-to-day, everything revolves around transactions. Each account has a broader "category", which can be whatever you want. For instance, you may create an "Electric Bill" account, or maybe "AEP Electric Bill". An account represents a granular category of transaction. Then, you'll need to create at least one account. You can create ledgers for other checking accounts, savings accounts, mutual funds-anything where you want to transact with and track the balance. For instance, I have a CapitalOne 360 Checking account, so I'd create a ledger for that. A ledger typically corresponds to an account.

Then, you'll need to create at least one ledger. Once you setup the web server (I only run it locally, of course, since there is no authentication involved), you'll need to create a SQLite database file, run the schema creation scripts (TODO) on it, and point the Web.config to the SQLite file. I'm open-sourcing this because a) why not, b) it's been incredibly valuable for me over the years, c) why not. Since then, I've moved that data from Access 2000, into Access 2002, Access 2003, Access 2007, then into MySQL with a CakePHP app, and now into a SQLite file and an ASP.NET MVC app (which is the repo you're looking at now). I was double charged, I made a typo, I forgot something, my wife forgot to tell me something, etc). Any discrepancies I would then address individually (e.g. Then, as those transactions actually cleared (as shown online via my banks' websites), I would mark them as "reconciled". I would input every check I wrote, every purchase, every withdraw, every deposit, etc. So, I wrote a Microsoft Access.uh.program? database? Whatever. So this made my bank's website not completely reliable to give me an idea of the exact amount of money I have. Another issue was that when I buy gas at the pump, it may only appears as $1 at my bank initially, but I know it would be much more when it actually cleared. I didn't really have a grasp on what my balance(s) were, how much of that money was actually waiting around for someone at Columbia Gas to cash my checks, how much money I was spending dining out every month, etc. Historyīack around, say, 2005, I was struggling to keep track of my money. This is just a little web-based "checkbook balancing" app that I wrote. Groves Proof that data always lives longer that the applications that access it.