Double-entry accounting: how to keep track of mortgage installments as expenses?
Understandably, it appears as if one must construct the flows oneself because of the work involved to include every loan variation. First, it would be best to distinguish between cash and accrued, otherwise known as the economic, costs. The cash cost is, as you've identified, the payment.  This is a reality for cash management, and it's wise that you wish to track it. However, by accruals, the only economic cost involved in the payment is the interest.  The reason is because the rest of the payment flows from one form of asset to another, so if out of a $1,000 payment, $100 is principal repayment, you have merely traded $100 of cash for $100 of house. The cash costs will be accounted for on the cash flow statement while the accrued or economic costs will be accounted on the income statement. It appears as if you've accounted for this properly.  However, for the resolution that you desire, the accounts must first flow through the income statement followed next instead of directly from assets to liabilities. This is where you can get a sense of the true costs of the home.  To get better accrual resolution, credit cash and debit mortgage interest expense & principal repayment.  Book the mortgage interest expense on the income statement and then cancel the principal repayment account with the loan account.  The principal repayment should not be treated as an expense; however, the cash payment that pays down the mortgage balance should be booked so that it will appear on the cash flow statement. Because you weren't doing this before, and you were debiting the entire payment off of the loan, you should probably notice your booked loan account diverging from the actual.  This proper booking will resolve that. When you are comfortable with booking the payments, you can book unrealized gains and losses by marking the house to market in this statement to get a better understanding of your financial position. The cash flow statement with proper bookings should show how the cash has flowed, so if it is according to standards, household operations should show a positive flow from labor/investments less the amount of interest expense while financing will show a negative flow from principal repayment.  Investing due to the home should show no change due to mortgage payments because the house has already been acquired, thus there was a large outflow when cash was paid to acquire the home. The program should give some way to classify accounts so that they are either operational, investing, or financing. All income & expenses are operational.  All investments such as equities, credit assets, and the home are investing.  All liabilities are financing. To book the installment payment $X which consists of $Y in interest and $Z in principal: To resolve the reduction in principal: As long as the accounts are properly classified, GnuCash probably does the rest for you, but if not, to resolve the expense: Finally, net income is resolved: My guess is that GnuCash derives the cash flow statement indirectly, but you can do the entry by simply: In this case, it happily resembles the first accrued entry, but with cash, that's all that is necessary by the direct method. If your mortgage is an interest only one then the full amount of the payment you make should be to an expense account perhaps called mortgage interest. If the mortgage is a repayment mortgage you need to split the amount of the payment between such an expense account called mortgage interest and between a liability account which is the amount of the loan. In practice I have not found it very easy to do all this as the actual amounts vary depending on number of days in the month and then there are occasional charges etc made by the mortgage company so some approximations seem to be needed unless one is to spend hours trying to get it exactly correct...... Steve The best thing for you to do will be to start using the Cash Flow report instead of the Income and Expense report. Go to Reports -> Income and Expense -> Cash Flow Once the report is open, open the edit window and open the Accounts tab.  There, choose your various cash accounts (checking, saving, etc.).  In the General tab, choose the reporting period.  (And then save the report settings so you don't need to go hunting for your cash accounts each time.) GnuCash will display for you all the inflows and outflows of money, which appears to be what you really want. Though GnuCash doesn't present the Cash Flow in a way that matches United States accounting rules (with sections for operating, investing, and financial cash flows separated), it is certainly fine for your personal use. If you want the total payment to show up as one line on the Cash Flow report, you will need to book the accrual of interest and the payment to the mortgage bank as two separate entries. Normal entry for mortgage payments (which shows up as a line for mortgage and a line for interest on your Cash Flow): Pair of entries to make full mortgage payment show up as one line on Cash Flow: Entry #1:  Interest accrual Entry #2:  Full mortgage payment (Tested in GnuCash 2.6.1) Because a paying down a liability and thus gaining asset equity is not technically an expense, GnuCash will not include it in any expense reports. However, you can abuse the system a bit to do what you want.  The mortgage payment should be divided into principle, interest, and escrow / tax / insurance accounts. For example: A mortgage payment will then be a split transaction that puts money into these accounts from your bank account: For completeness, the escrow account will periodically be used to pay actual expenses, which just moves the expense from escrow into insurance or tax. This is nice so that expenses for a month aren't inflated due to a tax payment being made: Now, this is all fairly typical and results in all but the principle part of the mortgage payment being included in expense reports. The trick then is to duplicate the principle portion in a way that it makes its way into your expenses. One way to do this is to create a principle expense account and also a fictional equity account that provides the funds to pay it: Every time you record a mortgage payment, add a transfer from this equity account into the Principle Payments expense account. This will mess things up at some level, since you're inventing an expense that does not truly exist, but if you're using GnuCash more to monitor monthly cash flow, it causes the Income/Expense report to finally make sense. Example transaction split:
"First of all, you need to stop using the card completely. Yes, that means you lose out on cash back, double miles, whatever, but that's how you got to this mess in the first place.  Switch to a cash budget until you can consistently spend less than you bring home.  Keep better track of your expenses, build an emergency fund, and learn to save for expenses rather than borrow for them until you have your spending under control.  If you can't cut your expenses any more, consider ways to increase your income (more hours at work, part-time jobs, sell stuff, etc.) Assuming that the employer match is 1-to-1 up to 4%, and you're saving an additional 7 percent to get to 15% total, I would definitely lower your contribution down to 4%, get the card paid off, and ONLY bump your contribution back up once you can safely pay off the card each month and know how much you can contribute.   It is not wise to put 15% in retirement if that causes you to spend more than your net take-home pay.  Your ""13%"" in your Roth is not guaranteed by any means, but the interest you pay on your credit card is. I would even be tempted to cut your retirement completely until the debt is paid, but more for motivational reasons that mathematical: I would be more concerned about living within your income at this point than getting a company match.  I believe the benefits of spending wisely will outweigh a temporary loss in matched retirement funds in the long run." I hate to sound harsh, but he's right. No technology, innovation, service or product can overcome your own lack of discipline. That doesn't mean you should give up, though - just like everything else, financial discipline is a learned skill, not something we're born with.  Everyone can learn to be financially responsible. If you find you can't keep track of your expenses, try merely saving your receipts.  Whenever you get home, pull them all out of your pockets, and look over how much you spent.  Once you get to the point where you're consistently keeping your receipts, start keeping a register (either paper or electronic) that you update when you empty your pockets.  From there, you can begin tracking how much you spend in various categories, and being setting budgets and adjusting your spending habits. It's not easy, but it's something that we all have gone through.  Keep at it, and you can succeed in turning your finances around. "Trying to figure out how much money you have available each day sounds like you're making this more complicated than it needs to be. Unless you're extremely tight and you're trying to squeeze by day by day, asking ""do I have enough cash to buy food for today?"" and so on, you're doing too much work. Here's what I do. I make a list of all my bills. Some are a fixed amount every month, like the mortgage and insurance premiums. Others are variable, like electric and heating bills, but still pretty predictable.  Most bills are monthly, but I have a few that come less frequently, like water bills in my area come every 3 months and I have to pay property taxes twice a year. For these you have to calculate how much they cost each month. Like for the water bill, it's once every 3 months so I divide a typical bill by 3. Always round up or estimate a little high to be safe. Groceries are a little tricky because I don't buy groceries on any regular schedule, and sometimes I buy a whole bunch at once and other times just a few things. When groceries were a bigger share of my income, I kept track of what I spent for a couple of months to figure out an average per month. (Today I'm a little richer and I just think of groceries as coming from my spending money.) I allocate a percentage of my income for contributions to church and charities and count this just like bills. It's a good idea to put aside something for savings and/or paying down any outstanding loans every month. Then I add these up to say okay, here's how much I need each month to pay the bills. Subtract that from my monthly income and that's what I have for spending money. I get paid twice a month so I generally pay bills when I get paid. For most bills the due date is far enough ahead that I can wait the maximum half a month to pay it. (Worst case the bill comes the day after I pay the bills from this paycheck.)  Then I keep enough money in my checking account to, (a) Cover any bills until the next paycheck and allow for the particularly large bills; and (b) provide some cushion in case I make a mistake -- forget to record a check or make an arithmetic error or whatever; and (c) provide some cushion for short-term unexpected expenses. To be safe, (a) should be the total of your bills for a month, or as close to that as you can manage. (b) should be a couple of hundred dollars if you can manage it, more if you make a lot of mistakes. If you've calculated your expenses properly and only spend the difference, keeping enough money in the bank should fall out naturally. I think it's a lot easier to try to manage your money on a monthly basis than on a daily basis. Most of us don't spend money every day, and we spend wildly different amounts from day to day. Most days I probably spend zero, but then one day I'll buy a new TV or computer and spend hundreds.  Update in response to question What I do in real life is this: To calculate my available cash to spend, I simply take the balance in my checking account -- assuming that all checks and electronic payments have cleared. My mortgage is deducted from my checking every month so I post that to my checking a month in advance. I pay a lot of things with automatic charges to a credit card these days, so my credit card bills are large and can't be ignored. So subtract my credit card balances. Subtract my reserve amount. What's left is how much I can afford to spend. So for example: Say I look at the balance in my checkbook today and it's, say, $3000. That's the balance after any checks and other transactions have cleared, and after subtracting my next mortgage payment. Then I subtract what I owe on credit cards. Let's say that was $1,200. So that leaves $1,800. I try to keep a reserve of $1,500. That's plenty to pay my routine monthly bills and leave a healthy reserve. So subtract another $1,500 leaves $300. That's how much I can spend. I could keep track of this with a spreadsheet or a database but what would that gain? The amount in my checking account is actual money. Any spreadsheet could accumulate errors and get farther and farther from accurate values. I use a spreadsheet to figure out how much spending money I should have each month, but that's just to use as a guideline. If it came to, say, $100, I wouldn't make grandiose plans about buying a new Mercedes. If it came to $5,000 a month than buying a fancy new car might be realistic. It also tells me how much I can spend without having to carefully check balances and add it up. These days I have a fair amount of spending money so when, for example, I recently decided I wanted to buy some software that cost $100 I just bought it with barely a second thought. When my spending money was more like $100 a month, lunch at a fast food place was a big event that I planned weeks in advance. (Obviously, I hope, don't get stupid about ""small amounts"". If you can easily afford $100 for an impulse purchase, that doesn't mean that you can afford $100 five times a day every day.) Two caveats: 1. It helps to have a limited number of credit cards so you can keep the balances under control. I have two credit cards I use for almost everything, so I only have two balances to keep track of. I used to have more and it got confusing, it was easy to lose track of how much I really owed, which is a set up for getting in trouble." "I wrote a little program one time to try to do this.  I think I wrote it in Python or something. The idea was to have a list of ""projected expenses"" where each one would have things like the amount, the date of the next transaction, the frequency of the transaction, and so on.  The program would then simulate time, determining when the next transaction would be, updating balances, and so on.  You can actually do a very similar thing with a spreadsheet where you basically have a list of expenses that you manually paste in for each month in advance.  Simply keep a running balance of each row, and make sure you don't forget any transactions that should be happening. This works great for fixed expenses, or expenses that you know how much they are going to be for the next month.  If you don't know, you can estimate, for instance you can make an educated guess at how much your electric bill will be the next month (if you haven't gotten the bill yet) and you can estimate how much you will spend on fuel based on reviewing previous months and some idea of whether your usage will differ in the next month.  For variable expenses I would always err on the side of a larger amount than I expected to spend.  It isn't going to be possible to budget to the exact penny unless you lead a very simple life, but the extra you allocate is important to cushion unexpected and unavoidable overruns. Once you have this done for expenses against your bank account, you can see what your ""low water mark"" is for the month, or whatever time period you project out to.  If this is above your minimum, then you can see how much you can safely allocate to, e.g. paying off debt.  Throwing a credit card into the mix can make things a bit more predictable in the current month, especially for unpredictable amounts, but it is a bit more complicated as now you have a second account that you have to track that has to get deducted from your first account when it becomes due in the following month.  I am assuming a typical card where you have something like a 25 day grace period to pay without interest along with up to 30 days after the expense before the grace period starts, depending on the relationship between your cut-off date and when the actual expense occurs." One approach would be to create Journal Entries that debit asset accounts that are associated with these items and credit an Open Balance Equity account. The value of these contributions would have to be worked out with an accountant, as it depends on the lesser of the adjusted basis vs. the fair market value, as you then depreciate the amounts over time to take the depreciation as a business expense, and it adjusts your basis in the company (to calculate capital gains/losses when you sell). If there were multiple partners, or your accountant wants it this way, you could then debit open balance equity and credit the owner's contribution to a capital account in your name that represents your basis when you sell. From a pure accounting perspective, if the Open Balance Equity account would zero out, you could just skip it and directly credit the capital accounts, but I prefer the Open Balance Equity as it helps know the percentages of initial equity which may influence partner ownership percentages and identify anyone who needs to contribute more to the partnership. I don't think there is a definite single answer for this. I think it largely depends on where you are on your financial journey. In the ideal world you'd have everything in bucket 2 built into your budget and be putting a little bit aside every paycheck to cover each of those things when they do come up but that takes a fair bit of discipline to do and experience (and data) to estimate reasonably. When you are just starting out in actually setting and keeping a budget or digging yourself out of CC debt/living paycheck to paycheck the odds are you aren't going to have the experience or disciple necessary to actually budget for those things in bucket 2 and even if you did the better option might well be to pay off that high interest debt you already have rather than saving up for an eventual expense. How ever as you start to improve your situation and pay off that debt, develop the disciple to set and follow a budget that is when you should start adding more of those things into your budget. How you track them doesn't really matter. A separate account at your bank. A total for a category in your budgeting software. An XLS file or even paper (ick). Ultimately it isn't about how you plan for and track things but more about actually doing that. So my question to the OP is where are you? If you already have a budget and do a good job of following it but don't have those items in it then consider that the next step in your financial journey. One piece of documentation that might help here is a confirmation of your benefit selections through your employer for each year since the expenses in question were incurred, assuming you have a job with eligibility for benefits.  If you can prove which accounts you maintained through your/your spouse's (if applicable) employer(s), then it is relatively simple to go back through the records for those specific accounts and see if a specific expense was ever reimbursed.  Obviously, you can't prove through documentation that you didn't have accounts that don't exist. This seems like it would be more important for the accounts elected by a significant other, since I believe reimbursements from an account in your name would typically be reported to the IRS on your behalf anyway. Also, keep in mind that the IRS won't care about each line item individually.  Their focus will be on whether, for any given snapshot in time, your total reimbursed amount exceeded your total eligible expenses. There are several reports under the Reports>Income & Expenses menu which could be useful. Cash Flow - shows, for a particular set of accounts, where incoming and outgoing money from those accounts came from and went to. Expense BarChart/PieChart - shows top N expenses. Income Statement (also called Profit & Loss) - shows all incomes and expenses for the time period. Each of these reports have an options dialog which will let you change the period that they are reporting on and the accounts to be included in the reports. The Cash Flow report sounds particularly useful for your second scenario.