Accounts Balances showing wrong balances different from GL Balances

ERPNext Accounting
1

Hi,

I have recently implemented ERPNext and now, I am looking to close the fiscal year 2019-20. But all my reports are showing wrong balances in Chart of Accounts, Trail Balances and Balance Sheet.

For example a General Ledger Balance of an Expense Account - “Salary” is 1,49,234 (Dr) upto end of March 2020

Capture
Capture1165×524 87.3 KB

My Trial Balance Report shows the Salary Account Balance as 6230 (Dr)) upto end of March 2020 which is wrong. The same balance is shown in my Chart of Accounts

Screenshot%20from%202020-06-18%2015-57-45
Screenshot%20from%202020-06-18%2015-57-451195×541 47.9 KB

Same is the case with other expense and income balances too.
Please help me correct the balances.

Thanks in Advance

2

@VinodKumarkolli Hey Did you find any solution because i am also facing the same problem.

3

Hi Rohan,
I found the issue is with the filters applied on the Trial Balance. I’ve created a ‘Finance Book’. Added all the journal entries with this Finance Book. In my case, changing the appropriate filters gave the balances as expected.

4

There seems to be a bug in the v14 trial balance, mostly to do with Finance Books

Worked around by changing this code:
apps/erpnext/erpnext/accounts/report/trial_balance/trial_balance.py

if filters.get("include_default_book_entries"):
    additional_conditions += (
        " AND (finance_book in (%(finance_book)s, %(company_fb)s, '') OR finance_book IS NULL)"
    )

to

if filters.get("include_default_book_entries"):
    pass

AND the same in frappe/apps/erpnext/erpnext/accounts/report/financial_statements.py

if filters.get("include_default_book_entries"):
		pass
	else:
		additional_conditions.append("(finance_book in (%(finance_book)s, '') OR finance_book IS NULL)")
1 Like