Scribd
Upload
15 views4 pages

Accounting Excel Reports - Report Trialbalance Excel

Uploaded by

Mark Ceddrick Miole

This document is a trial balance for an accounting period. It lists accounts with their debit and credit balances. The trial balance shows the accounts and their ending balances to check that the debits equal the credits.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt

Accounting Excel Reports - Report Trialbalance Excel

Uploaded by

Mark Ceddrick Miole
15 views4 pages
This document is a trial balance for an accounting period. It lists accounts with their debit and credit balances. The trial balance shows the accounts and their ending balances to check that the debits equal the credits.

Original Title

Accounting Excel Reports.report Trialbalance Excel (2)

Copyright

© © All Rights Reserved

Available Formats

XLSX, PDF, TXT or read online from Scribd

Did you find this document useful?

Is this content inappropriate?

This document is a trial balance for an accounting period. It lists accounts with their debit and credit balances. The trial balance shows the accounts and their ending balances to check that the debits equal the credits.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
15 views4 pages

Accounting Excel Reports - Report Trialbalance Excel

Uploaded by

Mark Ceddrick Miole
This document is a trial balance for an accounting period. It lists accounts with their debit and credit balances. The trial balance shows the accounts and their ending balances to check that the debits equal the credits.

Copyright:

© All Rights Reserved
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 4

Trial Balance

Display Account With Movements


Date From 2022-01-01

Code Account Debit


110100 Cash In Bank - EastWest Bank 37140086.17
110200 Cash In Bank - BDO 12876232.14
110210 Cash In Bank - PBB 10000000
110300 Petty Cash Fund 10000
120100 Account Receivable 33181760.06
120200 Advances To Officers and Employee 435267.57
120300 Advances To Clients 411865
120500 Construction Bond 408477
130100 Input Tax 1009551.49
130200 Creditable Withholding Taxes 3842024.11
130300 Prepaid Expenses 1525652.67
140100 Furniture and Fixtures 769721
140110 Accumulated Depreciation Furnitur 0
140200 Office Equipment 220140
140210 Accumulated Depreciation - Office 0
140300 Vehicles 850000
140310 Accumulated Depreciation - Vehicl 0
140500 Investment Property 3134028
150100 Security Deposits 1641734.87
150200 Deferred Tax Assets - NOLCO 1543667
210100 Accounts Payable 8850953.83
210200 Accrued Expenses 5106692.37
210300 Advances From Officers and Emplo 0
210400 Advances From Customers 376680
220100 SSS, PHIC and HDMF Payable 86159.77
220200 Expanded Withholding Taxes 547824.26
220300 Final Withholding Taxes 0
220400 Withholding Taxes on Compensatio 23630.32
220500 Output VAT 3302731.37
230100 Loans Payable 5770413.8
230200 Retirement Obligations 0
301000 Capital 0
303000 Retained Earnings 4401391.52
410000 Earnings from Developers' Sales 0
430000 Earnings From Brokerage (Secondar 0
450000 Earnings From Leasing 0
510000 Bank Interest 0
510100 Final Tax Expenses 1510
610000 Association Commission Release 5532728.36
630000 Non-Associate Referral Fee 323877.41
640100 KW Royalty Fee 7% 574512.67
640200 KW Growshare 2% 190837.62
640201 Associate Fee 199400
640300 Education, Admin and System Fee 34650.94
710100 S & M Expense - Materials 113931.25
710300 S & M Expense - Representation 9319.06
710400 S & M Expense - Meals 51110.05
720100 Recruitment - Training 28452.39
740100 Utility Personnel - Salaries and Wa 220835.91
750101 Office Rentals 1763332.88
750102 Parking Rentals 82432.8
750103 CUSA 232236
750200 Transportation And Toll Fees 102938.81
750301 R & M - Office 150756.78
750401 Office Supplies 9822.56
750402 Pantry Supplies 17725.03
750600 Insurance Expense 13957
750800 Postage And Delivery Expense 4184.17
750901 Accounting Consultant 311500
751001 Notarial Fees 2886
751003 Donation 574
751004 Meal Expense 160170.15
751006 Admin - Water 1743.15
751007 Admin - Electricity 55281.71
751008 Admin - Telephone and Internet 33000
751009 Admin - Salaries and Wages 602541.4
751010 Admin- SSS, PHIC and HDMF 56486.37
760100 Taxes and Licenses 32672.01
770100 Depreciation Expenses - Furniture 89800.76
770200 Depreciation Expenses - Office Eq 25683
770300 Depreciation Expenses - Vehicles 99166.69
780000 Other Expenses 53255.8
810000 Provision For Income Tax - Current 1941.13
nce

Target Moves All Posted Entries


Date To 2022-06-30

Credit Balance
28230778.96 8909307.21
10866870.22 2009361.92
0 10000000
0 10000
33120440.06 61320
3496507.01 -3061239.44
54540.53 357324.47
258040 150437
925179.3 84372.19
14771.5 3827252.61
982750.39 542902.28
0 769721
395338.96 -395338.96
0 220140
148401 -148401
0 850000
439166.69 -439166.69
0 3134028
400858.71 1240876.16
0 1543667
24618295.11 -15767341.28
7970354.27 -2863661.9
1846015.22 -1846015.22
1140873.88 -764193.88
103529.77 -17370
2041870.18 -1494045.92
567320 -567320
28734.52 -5104.2
3388756.7 -86025.33
13436777.15 -7666363.35
152054 -152054
5000000 -5000000
0 4401391.52
3017649.63 -3017649.63
5420880.53 -5420880.53
541071.43 -541071.43
9705.61 -9705.61
1510 0
0 5532728.36
0 323877.41
0 574512.67
0 190837.62
0 199400
0 34650.94
22000 91931.25
0 9319.06
0 51110.05
0 28452.39
0 220835.91
0 1763332.88
0 82432.8
0 232236
0 102938.81
0 150756.78
0 9822.56
0 17725.03
1024.54 12932.46
0 4184.17
0 311500
0 2886
0 574
0 160170.15
333.93 1409.22
9538.38 45743.33
0 33000
0 602541.4
0 56486.37
0 32672.01
0 89800.76
0 25683
0 99166.69
0 53255.8
0 1941.13

You might also like