Management Accounting Sample

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 6

ABC Trading (Pty) Limited

Monthly Trial Balance - Current Year


© www.excel-skills.com - - -
Class Acc No Account Description Mar-2014 Apr-2014 May-2014
B-PPE BS-100 Property, Plant & Equipment 45,100.00 45,100.00 50,100.00
B-PPE BS-150 Accumulated Depreciation -30,700.00 -31,400.00 -32,400.00
B-VEST BS-200 Investments 8,000.00 8,000.00 8,000.00
B-CASH BS-300 Cash - Other - - -
B-BANK BS-399 Cash Transfer Control - - -
B-DEBT BS-400 Debtors - Other - - -
B-CREDT BS-500 Creditors - Other - - -
B-INT BS-510 Interest Payable - - -
B-DIV BS-520 Dividends Payable - - -
B-TAX BS-530 Provision for Taxation -1,570.00 -3,490.00 -4,575.00
B-PROV BS-550 Provisions -4,000.00 -3,000.00 -5,000.00
B-CREDT BS-600 Sales Tax Control -3,901.11 -2,100.80 -3,533.98
B-LOAN BS-700 Long Term Liabilities -49,380.00 -48,760.00 -48,140.00
B-SCAP BS-800 Share Capital -100.00 -100.00 -100.00
B-RET BS-900 Reserves - - -
I-REVS IS-100 Turnover -47,543.86 -96,192.98 -151,631.57
I-COS IS-200 Stock Purchases 21,643.22 44,776.04 72,921.40
I-ADM01 IS-305 Accounting Fees 701.75 1,403.50 2,105.25
I-ADV01 IS-310 Advertising & Marketing 1,052.63 2,105.26 3,157.89
I-ADM02 IS-315 Bank Charges 43.86 87.72 131.58
I-ADM03 IS-320 Commission - - -
I-ADM04 IS-325 Computer Expenses 350.88 701.76 1,052.64
I-ADM05 IS-330 Consumables & Cleaning - - -
I-ADM07 IS-335 Entertainment - - -
I-ADM08 IS-340 Insurance 280.70 561.40 842.10
I-ADM09 IS-345 Office Expenses - - -
I-ADM10 IS-350 Office Rent 7,017.54 14,035.08 21,052.62
I-ADM11 IS-355 Postage - - -
I-ADM12 IS-360 Professional & Legal Fees - - -
I-ADM13 IS-365 Salaries & Wages 10,000.00 20,000.00 30,000.00
I-ADM14 IS-370 Stationery 90.35 174.56 258.77
I-ADM15 IS-375 Subscriptions & Memberships - - 1,052.63
I-ADM16 IS-380 Telephone & Internet 969.30 1,956.14 2,934.21
I-ADM17 IS-385 Training - - -
I-ADM18 IS-390 Travelling & Accommodation - - 493.86
I-ADM19 IS-395 Utilities - - -
I-ADM06 IS-400 Depreciation 700.00 1,400.00 2,400.00
I-FIN IS-500 Interest Paid 440.00 880.00 1,320.00
I-TAX IS-600 Taxation 1,570.00 3,490.00 4,575.00
I-DIV IS-650 Dividends Paid -
I-OTX01 IS-700 Other Expenses - - -
I-REVO IS-800 Other Income - - -
I-REVO02 IS-810 Dividends Received - - -
I-REVO03 IS-820 Interest Received -89.00 -177.00 -258.00
I-REVO04 IS-830 Profit on Disposal of Asset - - -
B-BANK BS-BANKB1 B1 Bank Account 13,987.00 15,450.74 21,816.32
B-BANK BS-BANKB2 B2 Bank Account 1,800.00 1,800.00 1,800.00
B-BANK BS-BANKB3 B3 Bank Account 600.00 600.00 600.00
B-CASH BS-PCASHPC Petty Cash 1,100.00 1,100.00 1,100.00
B-DEBT BS-DEBTORS Trade Debtors 54,200.00 55,460.00 63,200.00
B-CREDT BS-CREDITORSTrade Creditors -26,073.26 -27,571.42 -38,985.72
B-INV BS-INVENTORYInventory 23,210.00 25,690.00 25,430.00
I-COS IS-INV MOVEM Inventory Movement -900.00 -3,380.00 -3,120.00
B-RET BS-RETAINED Retained Earnings -28,600.00 -28,600.00 -28,600.00
- - - - - - -
Jun-2014 Jul-2014 Aug-2014 Sep-2014 Oct-2014 Nov-2014 Dec-2014
50,100.00 50,100.00 50,100.00 50,100.00 50,100.00 50,100.00 50,100.00
-33,400.00 -34,400.00 -35,400.00 -36,400.00 -37,400.00 -38,400.00 -39,400.00
8,000.00 8,000.00 8,000.00 8,000.00 8,000.00 8,000.00 8,000.00
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
-9,455.00 -8,835.00 - -3,440.00 -4,540.00 -9,420.00 -7,820.00
-4,000.00 -3,000.00 -4,000.00 -5,000.00 -3,000.00 -5,000.00 -4,000.00
-3,141.84 -5,121.23 -662.33 -4,610.93 -3,309.83 909.71 -2,008.90
-47,520.00 -46,900.00 -46,280.00 -45,660.00 -45,040.00 -44,420.00 -43,800.00
-100.00 -100.00 -100.00 -100.00 -100.00 -100.00 -100.00
- - - - - - -
-215,842.09 -271,289.46 -326,947.36 -413,114.03 -493,114.03 -557,354.03 -619,547.01
104,507.88 135,349.98 174,532.94 222,217.15 264,672.29 295,177.55 332,179.06
2,807.00 3,508.75 4,210.50 4,912.25 5,614.00 6,315.75 7,017.50
4,210.52 5,263.15 6,315.78 7,368.41 8,421.04 9,736.83 11,052.62
175.44 219.30 263.16 307.02 350.88 394.74 438.60
- - - - - - -
1,245.14 1,245.14 1,245.14 1,245.14 1,245.14 1,245.14 1,245.14
85.96 85.96 85.96 131.57 131.57 177.18 177.18
- - - - - - -
1,122.80 1,403.50 1,684.20 1,964.90 2,245.60 2,526.30 2,807.00
- - 1,401.75 1,401.75 1,401.75 1,401.75 1,401.75
28,070.16 35,087.70 42,105.24 49,122.78 56,140.32 63,157.86 70,175.40
- - - - - - -
- - - - - - -
40,000.00 55,000.00 70,000.00 85,000.00 100,000.00 115,000.00 130,000.00
348.24 520.17 597.36 725.43 892.10 955.26 1,114.91
1,052.63 1,052.63 1,052.63 1,052.63 1,450.22 1,450.22 1,450.22
3,894.73 4,916.66 5,937.72 6,945.62 7,971.06 9,014.04 10,092.11
- - - - 592.11 592.11 592.11
493.86 670.18 826.32 826.32 3,457.90 3,457.90 3,633.34
- - - - - - -
3,400.00 4,400.00 5,400.00 6,400.00 7,400.00 8,400.00 9,400.00
1,760.00 2,200.00 2,640.00 3,080.00 3,520.00 3,960.00 4,400.00
9,455.00 8,835.00 9,605.00 13,045.00 14,145.00 19,025.00 17,425.00
- - - - -
- - 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00
- - -10,000.00 -10,000.00 -10,000.00 -20,877.19 -20,877.19
- - -1,000.00 -1,000.00 -1,000.00 -1,000.00 -1,000.00
-338.00 -428.00 -523.00 -624.00 -710.00 -807.00 -909.00
- - - - - - -
19,866.60 28,155.02 63,117.02 15,222.99 20,751.74 37,806.88 39,031.88
1,800.00 1,800.00 1,800.00 1,800.00 1,800.00 1,800.00 1,800.00
600.00 600.00 600.00 600.00 600.00 13,000.00 13,000.00
1,099.55 1,100.55 1,100.55 1,100.00 1,000.00 1,100.00 1,000.00
73,200.00 63,210.00 23,450.00 98,230.00 91,200.00 64,240.00 70,900.00
-37,208.58 -36,360.00 -45,868.58 -55,560.00 -49,598.86 -36,276.00 -43,681.72
30,870.00 31,003.00 35,200.00 34,800.00 31,200.00 29,730.00 26,300.00
-8,560.00 -8,693.00 -12,890.00 -12,490.00 -8,890.00 -7,420.00 -3,990.00
-28,600.00 -28,600.00 -28,600.00 -28,600.00 -28,600.00 -28,600.00 -28,600.00
- -
Jan-2015 Feb-2015
50,100.00 50,100.00
-40,400.00 -41,400.00
8,000.00 8,000.00
- -
- -
- -
- -3,900.00
- -
- -10,000.00
-7,600.00 -
-4,500.00 -5,000.00
-4,719.37 -5,165.43
-43,180.00 -42,560.00
-100.00 -100.00
- -
-684,283.85 -773,332.09
366,950.99 412,542.63
7,719.25 8,421.00
12,368.41 13,684.20
482.46 526.32
- -
1,245.14 1,245.14
263.14 336.82
- -
3,105.25 3,403.50
1,401.75 1,401.75
77,192.94 84,210.48
- -
- -
150,000.00 170,000.00
1,195.61 1,292.10
1,450.22 1,450.22
11,152.64 12,204.40
592.11 592.11
3,750.34 3,750.34
- -
10,400.00 11,400.00
4,840.00 5,280.00
17,205.00 19,955.00
- 10,000.00
1,000.00 1,000.00
-20,877.19 -20,877.19
-1,000.00 -1,000.00
-1,014.00 -1,122.00
- -
35,189.16 55,584.16
1,800.00 1,800.00
13,000.00 13,000.00
900.00 1,000.00
73,800.00 87,515.00
-41,140.00 -68,948.46
27,650.00 25,300.00
-5,340.00 -2,990.00
-28,600.00 -28,600.00

You might also like