Useful for Accounting people to explore the wonders of excel formulas.
Date | Debit particulars (DR.) |
Credit particulars (CR.) |
L.F. | Debit-Rs. | Credit-Rs | Narration |
|
2 | Enter Ledger account name | |||||||||
JOURNAL ENTRIES | Date | Debit particulars (DR.) |
Credit particulars (CR.) |
Folio | Debit-Rs. | Credit-Rs | Balance-Rs. | Narration | ||||||||||
cash A/c | capital A/c | 50000 | 50000 | capital introduce in the business | furniture A/c | Bank A/c | 0 | 10000 | 10000 | furniture purchased against cheque | ||||||||
Bank A/c | cash A/c | 35000 | 35000 | opened bank account | depreciation A/c | furniture A/c | 0 | 200 | 9800 | depreciate furniture@2% | ||||||||
Purchases A/c | ajay A/c | 20000 | 20000 | goods purchased on credit | 9800 | |||||||||||||
vijay A/c | Sales A/c | 14000 | 14000 | sold good on credit | 9800 | |||||||||||||
ajay A/c | Bank A/c | 19500 | 19500 | paid ajay in full settlement | 9800 | |||||||||||||
ajay A/c | Discount A/c | 500 | 500 | paid ajay in full settlement | 9800 | |||||||||||||
Bank A/c | vijay A/c | 13000 | 13000 | received in full settlement | 9800 | |||||||||||||
Discount A/c | vijay A/c | 1000 | 1000 | received in full settlement | 9800 | |||||||||||||
furniture A/c | Bank A/c | 10000 | 10000 | furniture purchased against cheque | 9800 | |||||||||||||
Travelling & conveyance expenses A/c | cash A/c | 3000 | 3000 | paid for travelling expenses | 9800 | |||||||||||||
cash A/c | Sales A/c | 10000 | 10000 | sold goods for cash | 9800 | |||||||||||||
Purchases A/c | cash A/c | 8000 | 8000 | goods purchased for cash | 9800 | |||||||||||||
Bank A/c | cash A/c | 5000 | 5000 | cash deposited in bank | 9800 | |||||||||||||
capital A/c | Bank A/c | 3000 | 3000 | withdrawn for personal use | 9800 | |||||||||||||
salary A/c | cash A/c | 2000 | 2000 | paid salary in cash | 9800 | |||||||||||||
telephone expenses A/c | outstanding expenses A/c | 1500 | 1500 | telephone expenses were unpaid | 9800 | |||||||||||||
depreciation A/c | furniture A/c | 200 | 200 | depreciate furniture@2% | 9800 | |||||||||||||
9800 |
Click Here To Download Journal to Balance Sheet in Excel
Whenever a company announces employee training session for skills development then it is supposed to…
If you are planning to immediately resign from your job but you can have your…
If you have been invited to serve in an honorary position at any institution and…
Violating the policy of the company will not be accepted by any organization and if…
Whether it is poor performance or unprofessional behavior that you have experienced at the restaurant…
If there is retaliation that you have observed in a particular team or department then…
View Comments
i like conveyance