how can a transfer from a checking account to a mortgage account be included in an expense report?

Mollie20

Hi, the transfer from a checking account to a loan is an expense (payment). How is the transfer set up such the loan is picked up in an expense report?

jacobs

@Mollie20  In strict accounting terms, the loan payment is a cash flow transfer (decreasing an asset, your checking account, and decreasing a liability, your loan), and is not an expense. But from a personal finance standpoint, a loan payment feels like an expense, and you logically want to be able to see it in a report.

To do this, make sure you create your expense report with Create Transaction Report or Create Summary Report on the Reports menu. (Do not use the old Category Summary report.) The trick is that when you go to Customize, you should select just your banking accounts, but not the loan account, on the Accounts tab; then go to the Advanced tab and select "Include only transfers with accounts outside of report". This will show your transfers at the bottom of the report. Or in the Advanced Tab, you can switch Organization to Cash Flow, and you'll see the transfer amount included in your Inflow (income) and Outflow (expense) subtotals.