Cash Flow Report: Cash Transfers In line items drilldown all $0.00 while total is correct

leishirsute

Is there some setting to get the "Cash Transfers In" line item amounts to show the correct amount in the Cash Flow Report?

They are all showing as zero even though the total appears to be correct.

The transfer of each line is an IRA distribution and shows an action of Cash Entered Into Account. However, changing the action to Deposit displays the the amount. I have of line items and was hoping to have to change all to Deposit action.

Here is a drilldown of the report line showing $0.00 for all Amounts while total is $309.02.

Jim_Harman

This appears to work correctly for me. Please detail how your report is set up:

• What built-in report is your report based on - Banking > Cash flow or some other report?
• What customizations have you made to the report? It appears you have selected one account. What is the selection on the Display tab for Organization? What is the selection on the Advanced tab for Transfers? Any other customizations?

CaliQkn

@leishirsute what happens if you select "Include all" transfers on the Advanced tab?

leishirsute

Here's my setup for the report which is customized from Banking > Cash Flow

For category selection I selected All accounts and then removed _DivInc and _DivIncTaxFree. Since I included All Transfers to get the IRA distributions of dividends and didn't want Dividends counted twice.

Looking at the report for year 2024, I noticed that amounts for the line items were displaying correctly until around 10/2024, when transaction actions changed from Deposit to Transfers (see the drilldown below)

For example, if I drilldown into the report line shown:

I get the resulting drilldown:

The above drilldown has $0.00 and nonzero amounts. Yet the total includes the correct $'s for the nonzero amounts. If they didn't, the total would be $924.35

So drilldown down further into a non-zero transaction and zero transaction I found that the difference is in type of action: Deposit vs Transfer. Any transaction that is considered a Transfer show a $0.00 amount.

As an example, looking at the transaction dated 8/2/2024, the amount of $107.`9 is displayed in the report and the transaction is listed as a deposit:

For the transaction dated 10/2/2024, the amount in the report is $0.00, but the transaction is for $67.90, and the amount is included in the report's total. However, the transaction is listed as Cash Transferred into Account:

So is there some setting to get Cash Transferred In amounts to show on the cash flow report since their amounts are included in the total.

I hope this makes sense.

leishirsute

Extra note: changing the Report to Include all Transfers did not change any of the report results.

CaliQkn

@leishirsute - I noticed that you are on the "new" reports interface. Do you think that the issue started when you started using the new interface?

Nevertheless, I think you found a bug. But also, I think you found a workaround for the bug but changing the Xln transactions to Dep transactions.

leishirsute

I am not aware of a new reports interface. Is there a way to go back to the old interface to see if it makes a difference?

CaliQkn

@leishirsute yes you can go back to the old interface. Go to Edit→Preferences→Early Access, and uncheck both "Reports & Graphs Center" and "Customize Reports". There have been several issues reported from using the new report interface. Until they get the issues worked out, I think it's a good idea to remain on the old interface.

Jim_Harman

To switch to the old interface, go to Edit > Preferences > Early Access and un-check the Customize Reports box.

leishirsute

I unchecked both "Reports & Graphs Center" and "Customize Reports" in Early Access.

Unfortunately, there was no changed to the report results. It was worth a try.

It must be a legit bug.

Jim_Harman

Your setup excludes all dividend income, not just the income in the IRA. Is that what you intended?

Assuming the intent here is to include transfers from the IRA in the report but not income earned in the IRA, I would un-check the IRA account on the Accounts tab and on the Advanced tab, next to Transfers select Exclude internal.  "Internal" here means "accounts that are included in the report"

That may not fix the drill-down problem, but it is a cleaner way to just include the transfers.

There are other cases where Deposits with a Category of another account in [square brackets] are handled differently from XIns and Xouts in reports.

How are the dividends recorded in the IRA? Is it a Div followed by a separate XOut, or a DivX? Did this change when the receiving end changed?

leishirsute

@Jim_Harman There are only IRA dividends. None from other type accounts. I wanted to account for Withdrawals from the IRA and not the dividends.

Removing IRA accounts in Accounts Tab and selecting Exclude internal did not change the result.

Here's a sample of the IRA distributions. They are all listed as withdraw.

However, in the receiving account the 9/4/2024 transaction is listed as a deposit and the 10/2/2024 transaction is listed as a transfer. They were downloaded from Fidelity. It appears that new transaction are listed as transfer instead of deposits. Most likely it is from the transfer detection setting in Preferences. But that should not change the $ value reported. I unset the transfer detection.

Jim_Harman

What I have found is that everything works correctly, including tax withholding and the Tax reports and Tax Planner, if I enter IRA distributions as Deposits in the taxable receiving account with the IRA account in [square brackets] as in your 8/2 example. I have set up an income Reminder so both sides of the transaction are entered automatically a few days before the transactions download. Then when the transactions download, they will match to transactions you have already recorded.

You should delete and re-enter any existing transactions for the distributions rather then editing them, because sometimes editing investing transactions to a different type messes things up internally.

Here is the detailed procedure I use. You may be able to get away with variations on this, but I wouldn't count on it.

One-time setup: In the IRA, click on the gear at the top right and select Edit account details. Click on Tax Schedule and set Transfers out to "1099R:Total IRA taxable distrib."

If no taxes are withheld from the distribution, you can simply enter the distribution in the IRA as a transfer to the receiving account.

If taxes are withheld from the distribution, the process is more complicated because you must record the gross distribution as well as the withholding(s) in the receiving account. To do this, go to the receiving account and:

1)  Enter a Deposit transaction for the net amount of the RMD as a positive number.

2)  Split the Category:

• Line 1 of the split:  Category = the IRA account name in [square brackets] for the gross amount as a positive number. This will create a transfer from the IRA.
• Line 2 of the split:  Category = the Fed tax withholding category that you use, as a negative number.
• Line 3 of the split:  Category = the State tax withholding category that you use, as a negative number.
• Total of the split:  Must equal the net amount of the deposit.

If the deposit is made to a banking account between Jan. 1 and April 15, you will see a dialog titled “Confirm Your Contribution Tax Year”, even though this is a distribution and not a contribution. Select the current year, not the default of the previous year, and click on OK. This seems to be a bug.

If you receive the distributions regularly, you can set up this transaction as an Income Reminder.

If taxes were withheld, you must delete or not accept any downloaded transactions in the IRA for the net distribution and the withholding.

In the Cash Flow report, you should include the receiving account but not the sending account and as I said before, on the Advanced tab, select "Exclude internal" next to Transfers.

With this setup, the taxable income will be shown in the Tax Planner and the “1099-R Total IRA Taxable distrib.” and any tax withholding in the withholding sections of the Tax Schedule report.

leishirsute

" 1)  Enter a Deposit transaction for the net amount of the RMD as a positive number."

I think the issue is that "transfer detection" setting was on in the settings. Prior to that, the Withdrawals were treated as Deposits and all reported fine.

Jim_Harman

II think the key is to enter the correct transactions before downloading so that the downloaded transactions match transactions that are already in the transaction list. You can enter the transactions either manually out via s Reminder.