So the formula in the I cell for my bank statement will not just be Statements that have all been reconciled, my reconciliation section might So, for example, if I've gotten three credit card Instead what I do is I add the reconciled amount from each credit card payment However, that would lead to a lot of tabs sinceĮach one has to be subdivided by quarter, and I can't have tabs within tabs. Separate spreadsheets) for each of my accounts - one for each creditĬard and one for my bank. Now, I could deal with this by creating a separate set of tabs (or even That means that my bank statement has a line entry for eachĬredit card payment I made that doesn't appear in my own ledger. Problem here is that when I pay a credit card bill, I don't add a ledgerĮntry for that payment, since I've already accounted for them as individual This works great for creditĬard statements, but is slightly more complicated for bank statements. I usually have to add a few for receipts that I lost track of,īut once it's ready to pay I go ahead and pay it. Once column K shows a balance of $0, I've reconciled every transaction on the It looks "backwards" that I'm adding up the debits and subtractingīack out the credits, but I'm trying to match the amount shown on my credit Remember that the D columns were my payments and theĮ columns were my deposits (or, in the case of a credit card statement, my G column and add up the contents of it's D column". Plainer English, this says, "Find every row that has a 'MS3429_0513' in it's In the corresponding row in its third argument (the D column here). If theĬontents of any of those cells match the contents of its second argument H2, Is where I copy the reconciliation identifier (e.g. Of any cell in the range listed in its first argument here G1:G500, which What the SUMIF function does is it first checks the contents I define column I of the reconciliation line to the formula: The contents of the H cell (for the statement I'm reconciling) into column G Instead what I do in the spreadsheet is I copy The paper statement one line at a time, and check a checkbox once I found the So what about column I? This is the reconciled amount - and this is J, I put the amount shown on the statement, and in column K, I create a formula Mastercard, followed by last four digits, followed by due date in MMDD format). H, toward the top of the spreadsheet, something like MS3429_0513 (MS for Statement, I put a unique identifier for the card/statement tuple in column Penny every month (and so should you!), and I track both checks and creditĬard transactions in the same spreadsheet. I personally reconcile my statements to the Things get tricky when a statement comes and I Separate tab for each quarter the total for the Q4 '13 is the formula Now, to avoid running into a limit, I create a Row for the beginning balance in column F. I just copy that cell all the wayĭown to the bottom and I have a running total, as long as I reserve the first Or the credit amount in column E (for a deposit). The Payee in column C, and the debit amount in column D (for a withdrawal) I put the check number in column A, the date in column B, Of course the first thing I need to do is to keep track of individual I use OpenOffice (now LibreOffice), but all of this ought In GTK, but in the meanwhile, I've found that I can replace pretty muchĪll of the core functionality that I used from Microsoft Money with a fairly Tempted to (and who knows, maybe someday I really will) write my own replacement
Google microsoft money replacement windows#
Ran on the version of Windows I had installed and b) I had gotten tired ofīooting out of Linux and into Windows just to balance my checkbook. It from one computer to the next as I upgraded computers, until a) it no longer I installed it and used it to track my personal finances for years, migrating I bought a desktop computer many years ago (back when people still boughtĭesktop computers), and it came with a CD-ROM containing Microsoft Money '99. Replace Microsoft Money with a Spreadsheet
0 kommentar(er)
