Trial Balance
A trial balance is a bookkeeping worksheet in which the balances of all ledgers are compiled into debit and credit account column totals that are equal. A company prepares a trial balance periodically, usually at the end of every reporting period. The general purpose of producing a trial balance is to ensure the entries in a company's bookkeeping system are mathematically correct.
How to View Trial Balance Report?
In the Account Reports menu, select Trial Balance.a) View All Data.
1. Select From Date & To Date.
2. Select Show Columns.
3. Then Click Report.
b) View Customize Data:
1. Select From Date & To Date.
2. Select Show Columns.
3. Click Refresh Advance Option.
4. Select Group. How to create Group.
5. Select Ledger. How to Create Ledger.
6. Then Click Report.
c) Report:
Demo Company | |||||
Trial Balance | |||||
Date : 01/01/2018 to 31/03/2018 | |||||
Ledger | Opening Balance | Dr. Amount | Cr. Amount | Current Balance | Closing Balance |
---|---|---|---|---|---|
Assets | |||||
Account Receivables | |||||
Friends (Khulna Branch) | 2,40,000.00 Dr | 27,248.00 | 33,500.00 | 6,252.00 Cr | 2,33,748.00 Dr |
Friends (Mongla Branch) | 5,00,000.00 Dr | 0.00 | 40,000.00 | 40,000.00 Cr | 4,60,000.00 Dr |
Galaxy Media | 70,000.00 Dr | 0.00 | 0.00 | 0.00 | 70,000.00 Dr |
Habibur Rahman | 80,000.00 Dr | 0.00 | 0.00 | 0.00 | 80,000.00 Dr |
Mizan Mahmud | 1,20,000.00 Dr | 11,200.00 | 0.00 | 11,200.00 Dr | 1,31,200.00 Dr |
Ocean Paradise | 70,000.00 Dr | 2,41,000.00 | 2,00,000.00 | 41,000.00 Dr | 1,11,000.00 Dr |
Pioneer Bit Company Ltd. | 3,04,000.00 Dr | 0.00 | 0.00 | 0.00 | 3,04,000.00 Dr |
Sub Total : | 13,84,000.00 Dr | 2,79,448.00 | 2,73,500.00 | 5,948.00 Dr | 13,89,948.00 Dr |
Summary for Assets : | 13,84,000.00 Dr | 2,79,448.00 | 2,73,500.00 | 5,948.00 Dr | 13,89,948.00 Dr |
Expenses | |||||
Administration Overheads | |||||
Bank Charges | 0.00 | 6,000.00 | 0.00 | 6,000.00 Dr | 6,000.00 Dr |
Business Promotional Expenses | 0.00 | 9,000.00 | 4,000.00 | 5,000.00 Dr | 5,000.00 Dr |
Cleaning Expenses | 0.00 | 2,275.00 | 6,000.00 | 3,725.00 Cr | 3,725.00 Cr |
Conveyance | 0.00 | 8,000.00 | 0.00 | 8,000.00 Dr | 8,000.00 Dr |
Fuel & Oil Expenses | 0.00 | 9,500.00 | 0.00 | 9,500.00 Dr | 9,500.00 Dr |
Medical Expenses | 0.00 | 0.00 | 1,000.00 | 1,000.00 Cr | 1,000.00 Cr |
Sub Total : | 0.00 | 34,775.00 | 11,000.00 | 23,775.00 Dr | 23,775.00 Dr |
Summary for Expenses : | 0.00 | 34,775.00 | 11,000.00 | 23,775.00 Dr | 23,775.00 Dr |
Liabilities | |||||
Account Payables | |||||
Alam Store | 45,000.00 Cr | 1,06,420.00 | 1,00,920.00 | 5,500.00 Dr | 39,500.00 Cr |
Mahim & Brothers | 1,24,000.00 Cr | 4,05,240.00 | 2,86,040.00 | 1,19,200.00 Dr | 4,800.00 Cr |
Mamun & Sons | 50,000.00 Cr | 0.00 | 0.00 | 0.00 | 50,000.00 Cr |
MK Steel | 3,00,000.00 Cr | 0.00 | 0.00 | 0.00 | 3,00,000.00 Cr |
TM Enterprise | 2,30,000.00 Cr | 0.00 | 1,36,500.00 | 1,36,500.00 Cr | 3,66,500.00 Cr |
Wahid & Brothers | 60,000.00 Cr | 0.00 | 0.00 | 0.00 | 60,000.00 Cr |
Sub Total : | 8,09,000.00 Cr | 5,11,660.00 | 5,23,460.00 | 11,800.00 Cr | 8,20,800.00 Cr |
Summary for Liabilities : | 8,09,000.00 Cr | 5,11,660.00 | 5,23,460.00 | 11,800.00 Cr | 8,20,800.00 Cr |
Grand Total : | 5,75,000.00 Dr | 8,25,883.00 | 8,07,960.00 | 17,923.00 Dr | 5,92,923.00 Dr |