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 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)
