FA inconsistent equity reports?

[Eden Whitehead]

I'm stumped! Help, please!

There are no unposted transactions in either Contributions or Fund Accounting. The following transactions have been confirmed for March in Fund Accounting->View Posted Transactions:

DB General Checking 01-1110-000 $10,000
CR Special Needs Income 01-4210-130 $10,000

(01-4210-130 is a temporarily restricted account that closes to 01-3210-130)

Then I moved the monies from the checking account to a money market account:

CR General Checking 01-1110-000 $10,000
DB Money Market 01-1240-130 $10,000

The Detail Changes in Equity report is giving results I don't understand - but it may be that I don't understand the report. Or some other aspect of the situation....

If I set the report filter to account range of 3210 thru 3299 and leave the sub-account fields blank and leave the option "Include zero activity accounts" checked (default), then the report shows CR $10,000 for account 01-3210-130. However, I don't want to see the accounts that had no activity for the month of March, so I UNcheck the option "Include zero activity accounts" but set the other filters exactly as before. The activity for 01-3210-130 no longer shows! Why is it not there?

Now this apparent (to me) anomaly led me to investigate other reports.

The general Changes in Equity report shows income of $10,000 for March for account 01-3210-130. Why is this report correct but the Detail Changes in Equity for only March activity NOT correct?

Account Activity report filtered for accounts 3200 thru 3999, sub-account fields left blank, and the default "Include zero activity accounts" checked shows CR $10,000 for 01-3210-130; re-run the report with everything as before except UNcheck "Include zero activity accounts" (so, theoretically, I get only and ALL the accounts that had activity in March), and account 01-3210-130 vanishes from the report, just as happens in the Detail Changes in Equity report. Hmmm....

Trial Balance for March shows 01-3210-130 with the correct beginning balance but does not show the $10,000 income for March (even with "Include zero activity accounts" checked!) and, consequently reports an incorrect current balance (short by $10,000). Oddly, when I UNcheck the option, 01-3210-130 still appears in the report showing the correct beginning balance, 0.00 for Period Actual, and the incorrect current balance. In both cases (option checked and unchecked) the income account 01-4210-130 shows $10,000 under Period Actual.

Balance Sheet shows correct balance for 01-3210-130.

Statement of Activities shows the income.

Cash Management report shows the correct balance, reflecting the $10,000 credit to account 01-3210-130.

The Sub-account Report shows the $10,000 income in 01-4210-130 but no activity for the period for 01-3210-130.

I would love to understand why some reports show activity in March for 01-3210-130 and other reports do not; and why some reports show the activity for the income account 01-4210-130 but not for the equity account it closes to (01-3210-130). But mostly, how can I get the Detail Changes in Equity report to show the March activity for 01-3210-130?

And, oh yes - I reindexed and ran all the reports again, with all the same results.

(I apologize for the length of this post....)

Eden

[JohnDMeyers]

Eden:

I can get more detail when I get a chance. Here's right off the top.

The equity account that the income "closes to" creates a [system generated] amount in some account activity reports to show you what WILL happen when the year-end closes. Look for the bracketed words [system generated] in your reports.

Since these amounts are future amounts, they apparently show up when you include zero-activity, because, technically, no amounts have actually been posted.

When you look for actual amounts, these [system generated] amounts won't appear.

More later.

[Eden Whitehead]

The equity account that the income "closes to" creates a [system generated] amount in some account activity reports to show you what WILL happen when the year-end closes. Look for the bracketed words [system generated] in your reports.

Since these amounts are future amounts, they apparently show up when you include zero-activity, because, technically, no amounts have actually been posted.

When you look for actual amounts, these [system generated] amounts won't appear.

John,
Thank you for your reply.

Yes, I do see "[system generated]" in the report. I didn't think through what the implications of that might be.

What you say makes sense to me. It explains why the initial income to the -130 income/equity account that was transacted in December shows up as the beginning balance for 2011 but the March transaction is not "visible" in those reports.

If you discover any other information, I will certainly appreciate learning of it.

May the Lord prosper the work of your hands,
Eden

[Zaina]

There is currently a problem with the Detail Changes in Equity report that will be fixed in an upcoming maintenance release. It should be showing everything including transactions to income and expense that will close to that equity account.

[Eden Whitehead]

There is currently a problem with the Detail Changes in Equity report that will be fixed in an upcoming maintenance release. It should be showing everything including transactions to income and expense that will close to that equity account.

I am very happy to hear that! I just looked at the report again and observed that income activity in a different equity account DOES appear in the Detail Changes in Equity report when the option "Include zero activity accounts" is unchecked.... So I will look forward to the upcoming MR with great anticipation!

Thank you, Zaina!

Eden

[Ron]

There is currently a problem with the Detail Changes in Equity report that will be fixed in an upcoming maintenance release. It should be showing everything including transactions to income and expense that will close to that equity account.

Zaina, was this corrected in the latest mnt release?
Thx, Ron

[NeilZ]

There is currently a problem with the Detail Changes in Equity report that will be fixed in an upcoming maintenance release. It should be showing everything including transactions to income and expense that will close to that equity account.

Zaina, was this corrected in the latest mnt release?
Thx, Ron

The announcement for the 4/25/11 MR does not list this issue as one of the fixes.

[Zaina]

As Neil pointed out, as of the 4/25/2011 maintenance release, this report has not been fixed yet. We can't give an ETA at this time on the fix, but it will be fixed.