Statement of Owner's Equity Report Customization

[Yawar Amin]

Hi,

On 2011-11-09, at 00:08, you wrote:

> […]
> ‘Equity:Kevin Gilmour, Capital’ account. The GL entry(ies) which put
> this $555,300CR in the account–are they by chance made on or after
> June 30, 2012? That would explain the report showing $0 starting
> capital."
> 
> That's just it . . . the entire "project" has transactions in July of
> 2012. Therefore, I set the dates "around" that time period to make
> sure I "collected" all of the transactions. So, no that cannot be the
> problem. Here is a screenshot of the Kevin Gilmour, Capital account.
> That was the first thing though that came to my mind is that I did not
> have the date range correctly configured. If you can think of any
> other possible cause of this, by all means let me know.

Well, problem solved. The credit entry into ‘Kevin Gilmour, Capital’ is dated June 30. Your Equity Statement report is run for the period beginning June 30. You need to either date the credit entry at June 29, or run the report for period beginning July 1.

If you credit equity after the starting date of your reporting period, that’s not opening equity–it’s a contribution. In other words, opening equity is anything that was in the books before June 30.

> Now, I will say this, how does GNC even know that "Kevin Gilmour,
> Capital" is the account it should query for this report? There is not
> setting on the report options to set this. Being a developer of many
> applications (mostly web based), I would think you have to have some
> way for GNC to "know" that this is the account that wil tell the story
> on the equity balance. I guess if it simply totalled all the accounts

Have you looked in the report options?

> […]
> 
> One other important item to discuss in the same sctrain. (Don't you
> like reading my walls of text?). Under my Equity ph (placeholder)
> account, I have an account called "Open" which holds all the "opening
> balances" I should probably move that to a category called "Other" so
> as not to include those numbers in the "Equity" of the company.

From my (basic) knowledge of accounting, opening balance is equity.

> The point -- I think EVEN though I have "hidden" the "Open" account --
> I think it's still numerating in this report. Do you follow my story?
> I won't be hurt if you say no. :)

Hiding an account doesn’t leave it out of reporting calculations–it just hides it.

> This program has some issues to fix. I'm just realizing how many. Take
> a look at the screenshots I attached. Look at the date on the entry
> for the Kevin Gilmour capital account. See how it says 6/30. When I
> entered that on a different computer (still Windows), it was entered
> as 7/1! Yes, I already checked my clock is right on my computer, it's
> not that. Something is screwy here. I might just go out and buy
> Quicken, lol. No, I wouldn't do that, but seriously, this stuff needs
> to be addressed.

As Maf. said, you may be facing this time zone issue: https://bugzilla.gnome.org/show_bug.cgi?id=137017

Regards,

Yawar


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 194 bytes
Desc: This is a digitally signed message part
URL: <http://lists.gnucash.org/pipermail/gnucash-user/attachments/20111110/61c1f440/attachment.sig>