Date
Invoice No.
07/02/2018 00001-09 5/7/2018 00010 8/7/2018 00011 07/13/2018 00012 07/18/2018 00013 07/23/2018 00014 07/29/2018 00015 07/30/2018 00016
Customers Various Walk-In Customers CCSA Matalino High School Mr. Xander Retoke Makilala National High School Gevera Auditing Firm Aquarius Company Walk-In Customer
PR
DEBIT
Terms Accounts Receivable COD Less: 10%, 2/10, n/30 FOB Destination Less: 5%, 2/10, n/30 FOB SP Less: 5% COD 2/10, n/30, FOB SP 40% downpayment, balance 30 days 2/10, n/30 Less: 5% COD
₱ ₱ ₱ ₱ ₱ ₱ ₱
Cash ₱
455,000
₱ 1,125,000 68,400 ₱ 325,000 ₱ 3,983,400 ₱
66,500
1,800,000 665,000
45,600 95,000 662,100 4,645,500
CREDIT Sales ₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱
VAT Output 406,250 1,607,143 593,750 59,375 1,004,464 101,786 290,179 84,821 4,147,768
₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱
48,750 192,857 71,250 7,125 120,536 12,214 34,821 10,179 497,732 ₱ 4,645,500
-
Debits Date
O.R. No.
Description
Cash
Sales Disc.
1/7/2018 1/7/2018 07/18/2018 07/18/2018
12001 Mr. Cyber Henio 12002 CCSA 12003 Matalino High School 12004 Trilling Enterprise
₱ ₱ ₱ ₱
1,500,000 1,755,180 ₱ 654,700 ₱ 1,000
07/23/2018
12005 Abby's Merchandising
₱
15,200
07/28/2018 07/30/2018
12006 Makilala High School 12007 UM Cooperative
₱ ₱ ₱
1,102,500 ₱ 50,000 5,078,580 ₱
31,982 11,875
20,089 63,946
Debit Credit ₱ 5,150,200 ₱ 5,150,200
₱ ₱
875 980
Credits
Other Accounts
A/R
Account Title Henio, Capital ₱ 1,791,000 VAT Output ₱ 668,000 VAT Output Purchase Ret. VAT Input Sales Commission VAT Output ₱ 1,125,000 VAT Output Customer Deposit ₱ 3,584,000
Debit ₱ ₱
Credit ₱ 1,500,000
3,838 1,425 ₱ ₱ ₱ ₱
893 107 13,571 ₱ 1,629
13,571 ₱
1,629 ₱
44,643 ₱
5,357
₱
6,986
1734 -₱ 0.114078947 -₱
879 0.06
₱
2,411
₱
₱ 50,000 ₱ 7,674 ₱ 1,566,200
₱
7,674
105
14450 1734 16184
7672 ol;opipo;po;;op;opo; 160.7142857 1734
Date 1/7/2018 11/7/2018 07/17/2018 07/24/2018 07/25/2018
R. R. No.
Account Credited
1001 High Tech Company 1002 Voltes Five Company 1003 Trilling Enterprise 1004 High Tech Company 1005 Metro Appliance Center
Terms Less: 15% 3/10, n/45, FOB SP 3/10, n/45 FOB destination COD 3/10, n/45 FOB destination 2/5, n/30
Credits
Debits
Accounts Payable
Purchases ₱ ₱ ₱ ₱
1,745,536 224,018 4,464 2,000,000
Other Accounts Input Tax
₱ ₱ ₱ ₱ ₱
1,955,000 250,900 5,000 2,240,000 80,000
₱ ₱ ₱ ₱ ₱
₱
4,530,900 ₱
3,974,018 ₱
₱
4,530,900 ₱
4,530,900
Account Title
Debit
209,464 26,882 536 240,000 8,571 Office Equipment
₱
71,429
485,454
₱
71,429 ₱
Credit
-
Credits Date 1/7/2018 1/7/2018 3/7/2018 3/7/2018 4/7/2018 5/7/2018 6/7/2018 8/7/2018 9/7/2018 12/7/2018 07/15/2018 07/17/2018 07/18/2018 07/20/2018 07/25/2018 07/31/2018
Payee
CV No.
CK No.
Mr. Henio Aboiting Shipping Walk-in Customers Gevera Accounting Firm Gevera Accounting Firm Allied Cargo PHI Inc.
7-101 7-102 7-103 7-104 7-105 7-106 7-107
532101 532102 532103 532104 532105 532106 532107
₱ ₱ ₱ ₱ ₱ ₱ ₱
10,500 7,800 5,000 8,300 6,175 1,500 45,600
Allied Cargo High Tech Company Archer Company Payroll Master Trilling Enterprise Voltes Five Company Edmund Trabahador Mr. Henio Payroll Master
7-108 7-109 7-110 7-111 7-112 7-113 7-114 7-115 7-116
532108 532109 532110 532111 532112 532113 532114 532115 532116
₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱ ₱
3,000 1,883,983 15,500 12,300 5,000 243,373 6,500 4,300 13,900
₱
2,272,731
Cash
Credits
Debits
Purchases Discount
Accounts Payable
Freight In ₱
₱
₱ ₱
52,025 ₱
₱ 6,721 ₱
58,745 ₱ 58,746
Light & Water
6,964
₱
₱
Salaries Expense
Freight Out
1,500
1,942,250 ₱
12,300
₱
15,000
5,000 250,900
2,198,150 ₱
6,964 ₱
1,500 ₱
27,300 ₱
-
Debit ₱ 2,342,351
DEBIT Sales Returns
Input Tax ₱
₱
SSS/PHIC/HDMF Payable
DEBIT
CREDIT
Withholding Tax Payable
836
4,464
₱
₱
CREDIT
Credit ₱ 2,342,351
325
₱
2,400
₱
80
₱
2,805
1,661
4,464
₱ ₱
₱
2,497
-
₱
620
₱
620 ₱
-
SUNDRIES Account Title Miscellaneous Expense
₱
Debit 10,500
VAT Output Taxes and Licenses Professional Service Expense
₱ ₱ ₱
536 8,300 6,500
Prepaid Rent Rent Deposit Accounts Receivable VAT Input Store Supplies
₱ ₱ ₱
36,000 12,000 3,000
VAT Input Advances of Employees Henio, Drawing Advances of Employees
F
₱
₱ ₱
Credit
₱
6,243
₱
806
₱
400
13,839
6,500 4,300 ₱
₱
₱
101,475 ₱
14,800 ₱
₱ ₱
2,342,335.00 2342334 2,338,926.00 2,342,334.00
₱ ₱
2,342,334.00 2,342,335.00
7,449
7,049
2342334
Date 3/7/2018
Account Title
PR
Debit
Credit
NO entry 5/7/2018 Accounts Payable Purchase Ret. & Allow. VAT Input 10/7/2018 Sales Ret. & Allow. VAT Output Accounts Receivable 07/18/2018 NO ENTRY 07/27/2018 Accounts Payable Purchase Ret. & Allow. VAT Input TOTAL
a. b. c. d.
ADJUSTING ENTRIES Store Supplies Expense Store Supplies no Entry Doubtful Accounts Expense Allowance for Uncollectible Accounts Salaries Expense Salaries Payable TOTAL
CLOSING ENTRIES 07/31/2018 Sales Sales Commision Purchase Discount Purchase Returns and Allowances Income Summary 07/31/2018 Income Summary Sales Discount Sales Returns and Allowances Purchases Freight In Freight Out Salaries Expense Professional Service Expense
₱
₱ ₱
₱
₱
₱
12,750 ₱ ₱
11,384 1,366
₱
9,000
₱ ₱
1,786 214
23,750 ₱
23,750
8,036 964
2,000
4,456 ₱
4,456
₱
31,472
₱ 41,553 ₱
5,625 41,553
₱
31,472
₱
5,625
₱
₱ ₱ ₱ ₱
₱
4,147,768 13,571 58,745 14,063 ₱
4,234,147
₱ ₱ ₱ ₱ ₱ ₱ ₱
63,946 12,500 3,974,018 6,964 1,500 32,925 6,500
4,153,081
Miscellaneous Expense Taxes and Licenses Store Supplies Expense Doubtful Accounts Expense 07/31/2018 Income Summary Henio, Capital
₱
07/31/2018 Henio, Capital Henio, Drawing
₱
TOTAL
₱
₱ ₱ ₱ ₱
10,500 8,300 4,456 31,472
₱
81,066
₱
4,300
8,472,594 ₱
8,472,594
81,066
4,300
₱ 8,036 ₱ 964 ₱ 9,000 ₱ 14,750 ₱ 13,170 ₱ 1,580
₱
-
cf
Cash Date J. R. 07/31/2018 SJ 07/31/2018 CRJ BAL
₱ ₱ ₱ ₱
Debit Date J. R. 662,100 07/31/2018 CDJ 5,078,580 5,740,680 3,467,949
Credit ₱ 2,272,731 ₱ 2,272,731
Accounts Receivable Date J. R. 07/31/2018 SJ 07/31/2018 CDJ
BAL
₱ ₱
Debit Date J. R. 3,983,400 07/31/2018 CRJ 3,000 07/31/2018 GJ
Credit ₱ 3,584,000 ₱ 9,000
₱ ₱
3,986,400 393,400
₱ 3,593,000
Allowance for Doubtful Accounts Date
J. R.
BAL
Debit
₱ ₱
Date
J. R.
-
Credit
₱
-
Advances of Employees Date J. R. 07/31/2018 CDJ
₱
BAL
₱ ₱
Debit Date J. R. 6,500 07/31/2018 CDJ 6,500 6,100
Credit ₱ 400 ₱
400
Prepaid Rent Date J. R. 07/31/2018 CDJ
₱
Debit 36,000
BAL
₱ ₱
36,000 36,000
Date
J. R.
Credit
₱
-
Store Supplies Date J. R. 07/31/2018 CDJ
₱
Debit 13,839
BAL
₱ ₱
13,839 13,839
Date
J. R.
Credit
₱
-
Rent Deposit Date J. R. 07/31/2018 CDJ
₱
Debit 12,000
Date
J. R.
Credit
₱ ₱
BAL
12,000 12,000
₱
-
Delivery Van Date
J. R.
Debit
₱ ₱
BAL
Date
J. R.
-
Credit
₱
-
Furniture & Fixtures Date
J. R.
Debit
₱ ₱
BAL
Date
J. R.
-
Credit
₱
-
Office Equipment Date J. R. 07/31/2018 PJ
₱
Debit 71,429
BAL
₱ ₱
71,429 71,429
Date
J. R.
Credit
₱
-
Accumulated Depreciation - Office Equipment Date
J. R.
Debit
Date
J. R.
Credit
Accounts Payable Date J. R. 07/31/2018 CDJ 07/31/2018 GJ
₱ ₱ ₱
Debit Date J. R. 2,198,150 07/31/2018 PJ 14,750 2,212,900
BAL
Credit ₱ 4,530,900 ₱ 4,530,900 ₱ 2,318,000
VAT Output Date J. R. 07/31/2018 CRJ 07/31/2018 CDJ 07/31/2018 GJ BAL
₱ ₱ ₱ ₱
Debit Date J. R. 7,674 07/31/2018 SJ 536 07/31/2018 GJ 964 9,174
₱ ₱
Credit 497,732 1,629
₱ ₱
499,361 490,187
₱
-
VAT Input Date J. R. 07/31/2018 PJ 07/31/2018 CDJ
₱ ₱
BAL
₱ ₱
Debit Date J. R. 485,453 07/31/2018 CRJ 2,497 07/31/2018 CDJ 07/31/2018 GJ 487,950 479,214
₱ ₱ ₱ ₱
Credit 107 7,049 1,580 8,736
VAT Payable Date
J. R.
Debit
₱
Date
J. R.
-
Credit
₱ ₱
BAL
-
SSS/PHIC/HDMF Payable Date
J. R.
Debit
₱
Date J. R. 07/31/2018 CDJ -
BAL
₱
Credit 620
₱ ₱
620 620
₱
Credit 2,805
₱ ₱
2,805 2,805
Witholding Tax Payable Date J. R. 07/31/2018 CDJ
Debit
₱
Date J. R. 07/31/2018 CDJ -
BAL Customer's Deposit Date
J. R.
Debit
₱
Date J. R. 07/31/2018 CRJ -
Credit ₱ 50,000 ₱ ₱
BAL
50,000 50,000
Salaries Payable Date
J. R.
Debit
₱ BAL
Date
-
J. R.
Credit
₱ ₱
-
₱ ₱ ₱
10,973 10,973 -
Henio, Capital Date
J. R.
Debit
₱
Date J. R. 07/31/2018 CRJ -
Credit ₱ 1,500,000 ₱ 1,500,000 ₱ 1,500,000
BAL Henio, Drawing Date J. R. 07/31/2018 CDJ
₱
Debit 4,300
BAL
₱ ₱
4,300 4,300
Date
J. R.
Credit
₱
-
Income Summary Date
J. R.
Debit
Date
J. R.
Credit
Sales Date
J. R.
Debit
₱
Date J. R. 07/31/2018 SJ -
Credit ₱ 4,147,768 ₱ 4,147,768 ₱ 4,147,768
BAL Sales Commision Date
J. R.
Debit
₱
Date J. R. 07/31/2018 CRJ -
Credit ₱ 13,571 ₱ ₱
BAL
13,571 13,571
Sales Discount Date J. R. 07/31/2018 CRJ
₱
Debit 63,946
BAL
₱ ₱
63,946 63,946
Date
J. R.
Credit
₱
-
Sales Retun and Allowances Date
J. R.
Debit
Date
J. R.
Credit
07/31/2018 CDJ 07/31/2018 GJ BAL
₱ ₱ ₱ ₱
4,464 8,036 12,500 12,500
₱
-
Purchases Date J. R. 07/31/2018 PJ
₱
Debit 3,974,018
BAL
₱ ₱
3,974,018 3,974,018
Date
J. R.
Credit
₱
-
Purchase Discount Date
J. R.
Debit
₱
Date J. R. 07/31/2018 CDJ
-
BAL
₱
Credit 58,745
₱ ₱
58,745 58,745
₱ ₱ ₱ ₱
Credit 893 13,170 14,063 14,063
Purchase Return and Allowances Date
J. R.
Debit
₱
Date J. R. 07/31/2018 CRJ 07/31/2018 GJ -
BAL Freight In Date J. R. 07/31/2018 CDJ
₱
Debit 6,964
BAL
₱ ₱
6,964 6,964
Date
J. R.
Credit
₱
-
Freight Out Date J. R. 07/31/2018 CDJ
₱
Debit 1,500
BAL
₱ ₱
1,500 1,500
Date
J. R.
Credit
₱
-
Salaries Expense Date J. R. 07/31/2018 CDJ
₱
Debit 27,300
Date
J. R.
Credit
₱ ₱
BAL
27,300 27,300
₱
-
SSS/PHIC/HDMF Contribution Date
J. R.
Debit
₱
Date
J. R.
-
Credit
₱ ₱
BAL
-
Rent Expense Date
J. R.
Debit
₱ ₱
BAL
Date
J. R.
-
Credit
₱
-
Professional Service Expense Date J. R. 07/31/2018 CDJ
₱
Debit 6,500
BAL
₱ ₱
6,500 6,500
Date
J. R.
Credit
₱
-
Light and Water Expense Date
J. R.
Debit
₱ ₱
BAL
Date
J. R.
-
Credit
₱
-
Communication Expense Date
J. R.
BAL
Debit
₱ ₱
Date
J. R.
-
Credit
₱
-
Miscellaneous Expense Date J. R. 07/31/2018 CDJ
₱
Debit 10,500
BAL
₱ ₱
10,500 10,500
Date
Taxes and Licenses
J. R.
Credit
₱
-
Date J. R. 07/31/2018 CDJ
₱
Debit 8,300
BAL
₱ ₱
8,300 8,300
Date
J. R.
Credit
₱
-
Store Supplies Expense Date
J. R.
Debit
₱ ₱
BAL
Date
J. R.
-
Credit
₱
-
Depreciation Expense Date
J. R.
Debit
₱ ₱
BAL
Date
J. R.
-
Credit
₱
-
Doubtful Accounts Expense Date
BAL
J. R.
Debit
₱ ₱
Date
-
J. R.
Credit
₱
-
Date
J. R.
Debit
Date
J. R.
Debit
Date
J. R.
Debit
₱
10973 10,973
Date
J. R.
Credit
Date
J. R.
Credit
Date
J. R.
Debit
Date
J. R.
Date
J. R.
Credit
Date
J. R.
Debit
Date
J. R.
Date
J. R.
Debit
Date
J. R.
Date
J. R.
Debit
Date
J. R.
Date
J. R.
Debit
Date
J. R.
Date
J. R.
Debit
Date
J. R.
Credit
Credit
Credit
Credit
Credit
Credit
Account Title Cash Accounts Receivable Allowance for Doubtful Accounts Advances of Employees Prepaid Rent Store Supplies Rent Deposit Delivery Van Furnitures & Fixtures Office Equipment Accumulated Dep. - Office Equip. Accounts Payable VAT Output VAT Input VAT Payable SSS/PHIC/HDMF Payable Withholding Tax Payable Customer's Deposit Salaries Payable Henio, Capital Henio, Drawing Sales Sales Commision Sales Discount Sales Returns and Allowances Purchases Purchase Discount Purchase Returns and Allowances Freight In Freight Out Salaries Expense SSS/PHIC/HDMF Contribution Rent Expense Professional Service Expense Light and Water Expense Communication Expense Miscellaneous Expense Taxes and Licenses Store Supplies Expense Depreciation Expense Doubtful Accounts Expense TOTAL Net Profit
Unadjusted Trial Balance Debit ₱ 3,467,949 ₱ 393,400
Adjustments
Credit
Debit
c ₱ ₱ ₱ ₱
6,100 36,000 13,839 12,000
₱
71,429
Credit
₱
a
Adjusted Trial Balance
₱
Debit ₱ 3,467,949 ₱ 393,400
31,472
₱
₱ ₱ 4,456 ₱ ₱
6,100 36,000 9,383 12,000
₱
71,429
479,214
₱ ₱ ₱ ₱
620 2,805 50,000 d
₱
4,300
5,625 ₱
6,964 1,500 27,300
₱
6,500
₱ ₱
10,500 8,300
31,472
-
₱
71,429
₱
a
₱
c
₱ ₱
5,625
4,456 31,472 41,553 ₱
6,964 1,500 32,925
₱
6,500
₱ 10,500 ₱ 8,300 ₱ 4,456 ₱ ₱ 31,472 41,553 ₱ 8,632,856
Debit 3,467,949 393,400
₱ ₱ ₱ ₱
6,100 36,000 9,383 12,000
₱
71,429
31,472
479,214
Credit
₱
31,472
₱ ₱ 2,318,000 ₱ 490,187 ₱
₱ 620 ₱ 2,805 ₱ 50,000 ₱ 5,625 ₱ 1,500,000 ₱
479,214 ₱ 620 ₱ 2,805 ₱ 50,000 ₱ 5,625 ₱ 1,576,766
4,300
₱ 4,147,768 ₱ 13,571 ₱ 63,946 ₱ 12,500 ₱ 3,974,018
₱ ₱ ₱ ₱ ₱
₱ ₱
₱ ₱ 2,318,000 ₱ 490,187
4,300
58,745 14,063
d
₱
6,100 36,000 9,383 12,000
₱
₱ 63,946 ₱ 12,500 ₱ 3,974,018
₱ 8,595,759 ₱ 8,595,759
₱ ₱ ₱ ₱
Post-Trial Balance
Credit
₱
₱ 4,147,768 ₱ 13,571
₱ 63,946 ₱ 12,500 ₱ 3,974,018
₱ ₱ ₱
Debit ₱ 3,467,949 ₱ 393,400
₱ 620 ₱ 2,805 ₱ 50,000 ₱ 5,625 ₱ 1,500,000
₱ 4,147,768 ₱ 13,571
₱ ₱
Credit
479,214
₱ 1,500,000 ₱
Debit
Balance Sheet
₱ ₱ 2,318,000 ₱ 490,187
₱ 2,318,000 ₱ 490,187 ₱
Credit
Income Statement
58,745 14,063
₱ ₱
58,745 14,063
₱ 6,964 ₱ 1,500 ₱ 32,925 ₱ ₱ ₱ 6,500 ₱ ₱ ₱ 10,500 ₱ 8,300 ₱ 4,456 ₱ ₱ 31,472 ₱ 8,632,856 ₱ 4,153,081 ₱ 4,234,147 ₱ 4,479,775 ₱ 4,398,709 ₱ ₱ 81,066 ₱ 81,066 ₱ 4,234,147 ₱ 4,234,147 ₱ 4,479,775 ₱ 4,479,775 ₱
4,475,475 ₱ 4,475,475 4,475,475 ₱ 4,475,475