Journal to Balance Sheet in Excel

 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

furniture A/c
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

Search Sample Formats: