Basically, if I look at my current bank account (for example), what I need to see in the brought forward is the closing balance of this account.

As example seems to be useless I'll give you the pseudo code which I think should be :

rather than displaying :

   balance(begin, from)["debit"]   | balance(begin,from)["credit"]

The trial balance should display something like
  balance(begin, from)["debit"] - opening_balance  | balance(begin,from)["credit"] -opening_balance

with opening_balance = balance('000, begin)["debit"] - balance(000, begin)["credit"]

(Once again, it's pseudo code but I hope you get the idea)

/Elax

Both values are correct. The result depends on how you have marked the checkbox, Only Balances. If you have not marked the checkbox, the answer is (1).
If you have marked the checkbox, the answer is (2).

Joe

Is think my question is clear and I don't understand why people can't answer it. In my example below, which is behavior is expected (1) or (2) ???

/Elax

@elax
Was this explanation better?

Joe

Looking at a test database in which I had closed a fiscal year; and generating a trial balance report from the first day of the new fiscal year, it looks like my version is resulting in the first scenario you described above - ie, it's showing debits and credits as the 'brought forward' amount.

If it's a non-balance account, you should see 0 brought forward.

If you read my question carrefully, you should notice that I said

Therefore I don't need any explanation about non-balance account.

I said "balance account", like a bank account or anything which is

The problem appears with any-type of balance account so for example Bank current account (class : Current Asset)

/Elax

What is the type and class of the account? 

Do you mean stock as in common shares? If so, wouldn't this be properly accounted under equity or liabilities?

I know that non-balance account show 0 as opening balance if selected from the beginning of the year.
My question is about balance account and I don't know if the current behavior is correct or if its bug.

So my question is :
Let's say I have at the end of the year in bank : debit 150 credit 50 before closing the year.
After closing the year (imagine I have no other transaction ) what should I see as brought forward

    (1) Debit 150 Credit 50
or
    (2) Debit 100 Credit 0.

/Elax

Please remember that non-balance account shows 0 as opening balance if selected from the beginning of the fiscal year.

Joe

I had a look at the code and nothing (neither in closing year bit or the trial balance code) is calculating the opening balance at the begining of the fiscal year.

I explain, let's say last year I have

Stock 150 | 50

and I have done this year (but before the end of the period)  20 | 10
I expect the Trial balance to be
Stock 120 | 10  ( I started with 100 | 0 and add 20 | 10 to it ) instead of
Stock 170 | 60

Obviously if I start the report at the beginning of the year I expect
Stock 100 | 0    20 | 10
but I get

Stock 150 | 50 20 | 10

/Elax

/Joe

My problem is when I go to Trial Balance (not trial report) starting at the beginning of the fiscal year, I am expectind the Brought Forward value to be the opening balance with either Debit or Credit being null but that's not the case.
All the non balance are reset to 0 which is fine, but for the example the Stock show, 150 | 50 instead of  100 | 0.
It's the same for the bank accounts anything else.

/Elax

The Trial Report should tell you about that. Remember that the Open Balances for non balance account is starting at 0 at the beginning of the fiscal year.

/Joe

Is it normal ? (or a bug or is there a setting to only bring the balance ? )

/Elax