The Account Statement's balance and trial balance are different
AAUU-Ansari opened this issue · 13 comments
Hi, Dear
First thank you for the great package. A litter problem now I am facing the trial Balance and the Balance sheet report shows a balance without including the opening balances
it calculates only debit or credit
The Account Statement's balance and trial balance are different
For example
'ABC Bank' opening balance = $31052
In Trail Balance Report Shows
ABC Bank = $11000
But In Account Statement
ABC Bank = $42052.77
Hi @AAUU-Ansari ,
That is indeed a very peculiar issue. Are you sure that the statement and trial balance dates match exactly?
Hi @ekmungai
When I add the closing balances of 2023 to the opening balance of 2024 then the problem gets solved
hi @ekmungai
I am working on this package. All things are working fine but when I close the year 2023 and open the new year 2024 the trail balance & account statement balance do not match.
The trial balance report does not show a Capital balance and the account statement report shows a Capital balance from 2023 to 1-Feb-2024 $134.50283
when I started the year 2023 then I entered the opening balance in (ifrs_balances table)
is it correct way or not $8.86301
Hi @AAUU-Ansari ,
You need to create an opening balance equal to the previous years closing balance every time you close an year.
Cheers,
Ed
Hi @AAUU-Ansari,
Statement balances always include the opening balance amount. If the statement has no other transactions the statement and opening balances would be the same. Closing transactions are only meant for recognizing forex differences and would not help at all in this case.
Cheers,
Edward
Hey @AAUU-Ansari ,
I'm afraid I've not done any front end work on the package and so I cant help.
Hi @ekmungai
Thanks for your reply,
The Trail Balance report does not show the actual balance it shows only the balance without opening the balance
just for testing purposes, I created a new company which has an opening bank balance of $1500
I create a journal entry with $660 Expense
Account Statement report shows ($1500 - $660 = $840)
But the Trail Balance Report Shows only $660
if I eliminate the opening balance then the trial balance and statement balances are equal
Database Values
ifrs_entities
year_start | 7
ifrs_reporting_periods
OPEN | 2023
OPEN | 2024
ifrs_balances
transaction_date : 2023-07-01
balance_type : D
balance : 1500
Hey @ekmungai
same issue with us the Account Statement show inaccurate balance when we use opening balances of two years
Hey @ekmungai,
I hope this message finds you well. Firstly, thank you for this valuable package.
when "currency_id" is passed, the statement returns the sum of (Closed & Open year) opening balances of the account. However, when otherwise correct results are obtained.
$statement = new AccountStatement($request->account_id,null, $request->start_date, $request->end_date);
and update the Account Model Line No.350
// $period = ReportingPeriod::getPeriod($year . "-01-01", $entity);
$period = ReportingPeriod::getPeriod($year ."-". $entity->year_start."-01", $entity);