Open RamkrishnaMondal opened 9 years ago
Fixed 3, 4
Fixed 1
Need more clarification regarding 2
I am using Dr / Cr in the following places.
From the above where using Dr / Cr is valid and where its not valid ?
Thanks for fixing 1,3 & 4.
Clarification regarding 2 :
A. Balance Sheet..... Invalid, because it is not a part of 'double entry system/ Book Keeping'.
It is prepared after the closing of "books of accounts".
It's main purpose is to determine the value of the firm / business.
B. P&L : Trading and Profit & Loss A/C / Profit And Loss A/C is a part of 'double entry system / book keeping'
so it should show Dr & Cr symbols.
But, P&L Statement is not a part of 'books of accounts'. It's a summery of detailed Trading and Profit & Loss A/C. It is prepared to show the earning and managing efficiency of the business to Share holders, Financers etc. It should not contain Dr / Cr symbols.
C. Trial balance: Trial balance is prepared to make sure that the 'Sum of Dr balances' is equal to 'sum of Cr balances', and if not equal, to find out the cause/ error and rectify that. However it has some limitations,errors such as, Amount received from Mr. Bill Gates but wrongly credited to Mr. Bill Clinton's A/C or Paid $100 as salary but posted as $10, or The book keeper forgets to post an entry in both Dr and Cr side etc will not reflect in Trial Balance . It should contain Dr and Cr columns.
D. Ledger Statement and Ledger Entry should contain Dr /Cr symbols to show which ledger A/C has what type of balance Dr/ Cr ?
E. BR Statement:
In theory, the A/C balance in Passbook and In the Books of Accounts should be same, but in reality it often differs, mainly due to communication gap between Bank and the Book Keeper.
For example, when a cheque is deposited for collection, the Balance in Books of Accounts increases but passbook balance increases only after the amount is collected by the bank or when Bank debits bank charges / credits interests, the passbook balance changes but the same is posted in Books of Accounts only after receiving the Bank statement . It should be prepared as follows:
Balance as per 'Passbook' (or 'Books of Accounts') $ XXXX Adjustments: $XXXX Adjusted Balance $xxxxx [this should be equal to Balance as per 'Books of Accounts' (or 'Passbook)' ]
It should not contain Dr or Cr symbols.
Hope this helps.
Thanks for the explanations. I will go through them.
One thing that I am stuck at is how to handle negative balance. For example a ledger under asset should be Dr balance, if in case it turns out to have Cr balance should I show it as negative number in balance sheet.
Lets consider, we run a business where the Customers pay in advance and we supply the goods after 7 days. When we receive the advance payments, the book keeper enters as follows:
Dr Cash / Bank A/C $xxx Cr Customers A/C $xxx
In a normal business, Customers A/C (which is called Debtors A/C as a whole) balance remains Dr due to credit sales. But in our business it will show a Cr balance, and it's a liability for our business. We have to show it under liability in the Balance Sheet .
General rule : Any Asset with a Cr balance is a Liability and any Liability with a Dr balance (for example, Tax paid in advance to Govt.) is an Asset.
ok
No 1 will be hard to change since if its a Cr. balance in Assets I would let user change or correct it accordingly. I don't want investments appearing in current liabilities automatically.
No 2 some users might want it, though I am planning to remove Dr Cr symbols
No 3 some users might want it, some user dont. So better to keep it for now.
No 4 Since its already there, no point in removing something if its there.
No 5 Yes that can be done
I don't want investments appearing in current liabilities automatically.
@prashants Why would an investment appear under liabilities? An investment is normally considered an asset with a debit balance. The only time an investment would have a credit balance is if someone invested in you, in which case it is a liability.
No 4 Since its already there, no point in removing something if its there.
In order to bring it in line with what most accountants expect, I would suggest removing the opening date. It doesn't make a lot of sense and can confuse users.
When there is only one Account in the database, is not it logical that a/c should be auto activated by default ?
I would greatly appreciate if the software remembered the last activated account and simply used that unless you change the account manually. Otherwise it gets very frustrating. I'll open a separate ticket for this.
For Balance Sheet, Profit & Loss Account (Net Profit) is part of Owners Equity. "Profit & Loss Account (Net Loss)" is also part of Owners Equity. It is not an Asset item. The Net Loss will reduce the Owners Equity.
The $startdate should not affect the Balance Sheet figures if the $enddate is the same. Profit and Loss report is for a period, but Balance Sheet is only for a point, the end of the period.
These lines from ReportsController.php, under BALANCESHEET CALCULATIONS, may be deleted: $liabilities->start_date = $startdate; $assets->start_date = $startdate; $income->start_date = $startdate; $expense->start_date = $startdate;