Business Name PPG and Co.

Members
FS Frequency Yearly Ilao, Mae Angela M.
Store Hours 8am-5pm Magnaye, Rona G.
Payroll Paid every 15th & 30th Sarcino, Dianne Angelee
Previous Period December 31, 2018 Villamonte, Deosa U.
Period ending December 31, 2019 BSA 5102

Employee Number Employee Name Position

1556 Mgr1 Operations Manager - AM Shift
1557 Mgr2 Operations Manager - PM Shift
1558 Staff1 Delivery Driver - AM Shift
1559 Staff2 Delivery Driver - PM Shift
1560 Staff3 Laundry Helper - AM Shift
1561 Staff4 Laundry Helper - PM Shift

Months Sets of Financial Statements

January Statement of Financial Position
February Statement of Financial Performance
March Statement of Changes in Equity
April Statement of Cash Flows
May
June
July
August
September
October
November
December

GL Account Code Account Type GL Account Name

1000 Asset Cash in Bank
1001 Asset Petty Cash
1002 Asset Accounts Receivable
1003 Asset Prepaid Rent
1004 Asset Prepaid Auto Insurance
1005 Asset Fixed Asset
2000 Liability Accounts Payable
2001 Liability Utilities Payable
2002 Liability Compensation Tax Payable
2003 Liability Income Tax Payable
2005 Liability Salaries Payable
2006 Liability SSS, PHIC & HDMF Payable
3000 Owner's Equity Bubbles Centro, Capital
3001 Owner's Equity Bubbles Centro, Drawing
3002 Owner's Equity Income Summary
4000 Income Sales
4001 Income Bank Interest Income
5000 Expense Bank Charges
5001 Expense Utilities Expense
5002 Expense Salaries & Wages
5003 Expense Income Tax
5004 Expense SSS, PHIC & HDMF Employer Expense
5005 Expense Supplies Expense
BMS
25,000.00
25,000.00
13,962.00
13,962.00
13,962.00
13,962.00
 PPG AND CO.
Trial Balance
For the period ending
GL Account Code Account Type GL Account Name
1000 Asset Cash in Bank
1001 Asset Petty Cash
1002 Asset Accounts Receivable
1003 Asset Prepaid Rent
1004 Asset Prepaid Auto Insurance
1005 Asset Fixed Asset
2000 Liability Accounts Payable
2001 Liability Utilities Payable
2002 Liability Compensation Tax Payable
2003 Liability Income Tax Payable
2005 Liability Salaries Payable
2006 Liability SSS, PHIC & HDMF Payable
3000 Owner's Equity Bubbles Centro, Capital
3001 Owner's Equity Bubbles Centro, Drawing
3002 Owner's Equity Income Summary
4000 Income Sales
4001 Income Bank Interest Income
5000 Expense Bank Charges
5001 Expense Utilities Expense
5002 Expense Salaries & Wages
5003 Expense Income Tax
5004 Expense SSS, PHIC & HDMF Employer Expense
5005 Expense Supplies Expense
Checking
G AND CO.
al Balance
December 31, 2018
Debit Credit Ending Balance
500,000.00 - 500,000.00
25,000.00 - 25,000.00
84,000.00 - 84,000.00
180,000.00 - 180,000.00
42,000.00 - 42,000.00
450,000.00 - 450,000.00
- - 23,000.00 - 23,000.00
- - 34,000.00 - 34,000.00
- - 1,256.38 - 1,256.38
- - 5,000.00 - 5,000.00
- - 52,090.80 - 52,090.80
- - 13,670.82 - 13,670.82
- - 1,181,495.81 - 1,181,495.81
- - -
- - -
- - 120,000.00 - 120,000.00
- - 125.00 - 125.00
300.00 - 300.00
26,000.00 - 26,000.00
105,848.00 - 105,848.00
- - -
8,490.81 - 8,490.81
9,000.00 - 9,000.00
1,430,638.81 - 1,430,638.81 - 0.00
Employee Number
Employee Name BMS Month Payroll Period Daily Rate Days Worked Basic Pay
1556 Mgr1 25,000.00 January 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 January 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 January 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 January 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 January 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 January 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 January 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 January 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 January 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 January 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 January 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 January 16-31 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 February 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 February 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 February 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 February 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 February 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 February 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 February 16-28 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 February 16-28 961.54 13.00 12,500.00
1558 Staff1 13,962.00 February 16-28 537.00 13.00 6,981.00
1559 Staff2 13,962.00 February 16-28 537.00 13.00 6,981.00
1560 Staff3 13,962.00 February 16-28 537.00 13.00 6,981.00
1561 Staff4 13,962.00 February 16-28 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 March 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 March 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 March 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 March 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 March 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 March 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 March 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 March 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 March 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 March 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 March 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 March 16-31 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 April 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 April 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 April 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 April 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 April 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 April 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 April 16-30 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 April 16-30 961.54 13.00 12,500.00
1558 Staff1 13,962.00 April 16-30 537.00 13.00 6,981.00
1559 Staff2 13,962.00 April 16-30 537.00 13.00 6,981.00
1560 Staff3 13,962.00 April 16-30 537.00 13.00 6,981.00
1561 Staff4 13,962.00 April 16-30 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 May 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 May 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 May 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 May 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 May 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 May 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 May 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 May 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 May 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 May 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 May 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 May 16-31 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 June 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 June 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 June 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 June 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 June 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 June 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 June 16-30 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 June 16-30 961.54 13.00 12,500.00
1558 Staff1 13,962.00 June 16-30 537.00 13.00 6,981.00
1559 Staff2 13,962.00 June 16-30 537.00 13.00 6,981.00
1560 Staff3 13,962.00 June 16-30 537.00 13.00 6,981.00
1561 Staff4 13,962.00 June 16-30 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 July 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 July 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 July 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 July 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 July 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 July 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 July 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 July 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 July 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 July 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 July 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 July 16-31 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 August 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 August 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 August 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 August 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 August 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 August 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 August 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 August 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 August 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 August 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 August 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 August 16-31 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 September 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 September 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 September 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 September 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 September 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 September 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 September 16-30 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 September 16-30 961.54 13.00 12,500.00
1558 Staff1 13,962.00 September 16-30 537.00 13.00 6,981.00
1559 Staff2 13,962.00 September 16-30 537.00 13.00 6,981.00
1560 Staff3 13,962.00 September 16-30 537.00 13.00 6,981.00
1561 Staff4 13,962.00 September 16-30 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 October 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 October 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 October 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 October 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 October 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 October 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 October 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 October 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 October 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 October 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 October 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 October 16-31 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 November 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 November 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 November 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 November 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 November 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 November 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 November 16-30 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 November 16-30 961.54 13.00 12,500.00
1558 Staff1 13,962.00 November 16-30 537.00 13.00 6,981.00
1559 Staff2 13,962.00 November 16-30 537.00 13.00 6,981.00
1560 Staff3 13,962.00 November 16-30 537.00 13.00 6,981.00
1561 Staff4 13,962.00 November 16-30 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 December 1-15 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 December 1-15 961.54 13.00 12,500.00
1558 Staff1 13,962.00 December 1-15 537.00 13.00 6,981.00
1559 Staff2 13,962.00 December 1-15 537.00 13.00 6,981.00
1560 Staff3 13,962.00 December 1-15 537.00 13.00 6,981.00
1561 Staff4 13,962.00 December 1-15 537.00 13.00 6,981.00
1556 Mgr1 25,000.00 December 16-31 961.54 13.00 12,500.00
1557 Mgr2 25,000.00 December 16-31 961.54 13.00 12,500.00
1558 Staff1 13,962.00 December 16-31 537.00 13.00 6,981.00
1559 Staff2 13,962.00 December 16-31 537.00 13.00 6,981.00
1560 Staff3 13,962.00 December 16-31 537.00 13.00 6,981.00
1561 Staff4 13,962.00 December 16-31 537.00 13.00 6,981.00
 Philhealth HDMF SSS
EE Share ER Share EE Share ER Share EE Share ER Share Total EE Share
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 508.70 1,041.30 800.68
191.98 191.98 100.00 100.00 508.70 1,041.30 800.68
191.98 191.98 100.00 100.00 508.70 1,041.30 800.68
191.98 191.98 100.00 100.00 508.70 1,041.30 800.68
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
 - - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
 - - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
343.75 343.75 100.00 100.00 581.30 1,208.70 1,025.05
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
191.98 191.98 100.00 100.00 490.50 1,004.50 782.48
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
 Min Max
Total ER ShareCompensation Tax Net Pay 1,000.00 1,249.99
1,652.45 211.59 11,263.36 1,250.00 1,749.99
1,652.45 211.59 11,263.36 1,750.00 2,249.99
1,296.48 - 6,198.52 2,250.00 2,749.99
1,296.48 - 6,198.52 2,750.00 3,249.99
1,296.48 - 6,198.52 3,250.00 3,749.99
1,296.48 - 6,198.52 3,750.00 4,249.99
- 416.60 12,083.40 4,250.00 4,749.99
- 416.60 12,083.40 4,750.00 5,249.99
- - 6,981.00 5,250.00 5,749.99
- - 6,981.00 5,750.00 6,249.99
- - 6,981.00 6,250.00 6,749.99
- - 6,981.00 6,750.00 7,249.99
1,652.45 211.59 11,263.36 7,250.00 7,749.99
1,652.45 211.59 11,263.36 7,750.00 8,249.99
1,333.28 - 6,180.32 8,250.00 8,749.99
1,333.28 - 6,180.32 8,750.00 9,249.99
1,333.28 - 6,180.32 9,250.00 9,749.99
1,333.28 - 6,180.32 9,750.00 10,249.99
- 416.60 12,083.40 10,250.00 10,749.99
- 416.60 12,083.40 10,750.00 11,249.99
- - 6,981.00 11,250.00 11,749.99
- - 6,981.00 11,750.00 12,249.99
- - 6,981.00 12,250.00 12,749.99
- - 6,981.00 12,750.00 13,249.99
1,652.45 211.59 11,263.36 13,250.00 13,749.99
1,652.45 211.59 11,263.36 13,750.00 14,249.99
1,296.48 - 6,198.52 14,250.00 14,749.99
1,296.48 - 6,198.52 14,750.00 15,249.99
1,296.48 - 6,198.52 15,250.00 15,749.99
1,296.48 - 6,198.52 15,750.00
- 416.60 12,083.40
- 416.60 12,083.40 Compensation Tax Rate
- - 6,981.00 10,417.00 20%
- - 6,981.00 16,667.00 25%
- - 6,981.00 33,333.00 30%
- - 6,981.00 83,333.00 32%
1,652.45 211.59 11,263.36 333,333.00 35%
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40 Legends:
- 416.60 12,083.40 Gray Fill Fixed Data / Hardcoded Data
- - 6,981.00 Red Font Formulated Cells
 - - 6,981.00 Blue Fill Manpower Expenses
- - 6,981.00 Green Fill Deductions from employee's salar
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
 - - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
1,652.45 211.59 11,263.36
1,652.45 211.59 11,263.36
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
1,296.48 - 6,198.52
- 416.60 12,083.40
- 416.60 12,083.40
- - 6,981.00
- - 6,981.00
- - 6,981.00
- - 6,981.00
 Monthly Salary Credit ER EC EE Total Hashtotal
1,000.00 73.70 10.00 36.30 110 3,479.99
1,500.00 110.55 10.00 54.45 165 4,839.99
2,000.00 147.30 10.00 72.70 220 6,449.99
2,500.00 184.20 10.00 90.80 275 8,059.99
3,000.00 221.00 10.00 109.00 330 9,669.99
3,500.00 257.80 10.00 127.20 385 11,279.99
4,000.00 294.70 10.00 145.30 440 12,889.99
4,500.00 331.65 10.00 163.35 495 14,499.99
5,000.00 368.40 10.00 181.60 550 16,109.99
5,500.00 405.30 10.00 199.70 605 17,719.99
6,000.00 442.10 10.00 217.90 660 19,329.99
6,500.00 478.90 10.00 236.10 715 20,939.99
7,000.00 515.80 10.00 254.20 770 22,549.99
7,500.00 552.75 10.00 272.25 825 24,159.99
8,000.00 589.50 10.00 290.50 880 25,769.99
8,500.00 626.40 10.00 308.60 935 27,379.99
9,000.00 663.20 10.00 326.80 990 28,989.99
9,500.00 700.00 10.00 345.00 1045 30,599.99
10,000.00 736.90 10.00 363.10 1100 32,209.99
10,500.00 773.85 10.00 381.15 1155 33,819.99
11,000.00 810.60 10.00 399.40 1210 35,429.99
11,500.00 847.50 10.00 417.50 1265 37,039.99
12,000.00 884.30 10.00 435.70 1320 38,649.99
12,500.00 921.10 10.00 453.90 1375 40,259.99
13,000.00 958.00 10.00 472.00 1430 41,869.99
13,500.00 994.50 10.00 490.50 1485 43,479.99
14,000.00 1,031.30 10.00 508.70 1540 45,089.99
14,500.00 1,068.20 10.00 526.80 1595 46,699.99
15,000.00 1,105.00 30.00 545.00 1650 48,329.99
15,500.00 1,141.80 30.00 563.20 1705 49,939.99
16,000.00 1,178.70 30.00 581.30 1760 35,300.00
832,839.70

xed Data / Hardcoded Data

rmulated Cells
anpower Expenses
eductions from employee's salary
 PPG AND CO.
Payslip

Employee Number 1561

Invalid Employee
For the period June 1-15 2019

Basic Monthly Salary 13,962.00

Salary for the fortnight 6,981.00

Salary Deductions:
SSS 191.98
Philhealth 100.00
Pag - Ibig 490.50
Taxes Withheld -

Net Pay 6,198.52

-

Legends:
Red Font Formulated Cells
Black Font Hardcoded Cells
Blue Font Data Validated Cells
 PPG AND CO.
Journal Entrie
As Of

Date JE # Transaction Number GL Account GL Account Name

02/01/2019 1 434971 1003 Prepaid Rent
02/01/2019 1 434971 1000 Cash in Bank
02/01/2019 2 434972 1004 Prepaid Auto Insurance
02/01/2019 2 434972 1000 Cash in Bank
02/01/2019 3 434973 5005 Supplies Expense
02/01/2019 3 434973 1001 Petty Cash
02/01/2019 4 434974 5005 Supplies Expense
02/01/2019 4 434974 1001 Petty Cash
02/05/2019 5 435015 2005 Salaries Payable
02/05/2019 5 435015 1000 Cash in Bank
02/05/2019 6 435016 1005 Fixed Asset
02/05/2019 6 435016 1000 Cash in Bank
02/12/2019 7 435087 1002 Accounts Receivable
02/12/2019 7 435087 4000 Sales
02/17/2019 8 435138 1002 Accounts Receivable
02/17/2019 8 435138 4000 Sales
02/15/2019 9 435119 2006 SSS, PHIC & HDMF Payable
12/15/2019 9 438149 2002 Compensation Tax Payable
12/15/2019 9 438149 1000 Cash in Bank
12/15/2019 10 4381410 5004 SSS, PHIC & HDMF Employer Expense
12/15/2019 10 4381410 1001 Petty Cash
12/15/2019 11 4381411 5002 Salaries & Wages
12/15/2019 11 4381411 5004 SSS, PHIC & HDMF Employer Expense
12/15/2019 11 4381411 2002 Compensation Tax Payable
12/15/2019 11 4381411 2006 SSS, PHIC & HDMF Payable
12/15/2019 11 4381411 1000 Cash in Bank
12/15/2019 12 4381412 2001 Utilities Payable
12/15/2019 12 4381412 1000 Cash in Bank
12/15/2019 13 4381413 2001 Utilities Payable
12/15/2019 13 4381413 1000 Cash in Bank
12/15/2019 15 4381415 1001 Petty Cash
12/15/2019 15 4381415 1000 Cash in Bank
12/15/2019 16 4381416 2005 Salaries Payable
12/15/2019 16 4381416 2006 SSS, PHIC & HDMF Payable

Legends:
Red Font Formulated Cells
Black Font Hardcoded Cells
Blue Font Data Validated Cells
 PPG AND CO.
Journal Entries
December 2019

Details Dr (Cr)
Payment of annual rental of commercial space 180,000.00
Payment of annual rental of commercial space - 180,000.00
Payment of annual auto insurance for two delivery van 42,000.00
Payment of annual auto insurance for two delivery van - 42,000.00
Purchase of Supplies to be used for the month of February - - Detergent 5,000.00
Purchase of Supplies to be used for the month of February - - Detergent - 5,000.00
Purchase of Supplies to be used for the month of February - - Fabric Conditioner 3,000.00
Purchase of Supplies to be used for the month of February - - Fabric Conditioner - 3,000.00
Payment for January 16-31,2019 Payroll 52,090.80
Payment for January 16-31,2019 Payroll - 52,090.80
Acquisition of additional washing machine 50,000.00
Acquisition of additional washing machine - 50,000.00
Billed Mapua University for the laundry services of varsity players' uniforms 30,000.00
Billed Mapua University for the laundry services of varsity players' uniforms - 30,000.00
Billed Bayleaf Hotel for the laundry services of comforters and pillow cases 150,000.00
Billed Bayleaf Hotel for the laundry services of comforters and pillow cases - 150,000.00
Government Statutory Remittance for January 2019 13,670.82
Government Statutory Remittance for December 2019 1,256.38
Government Statutory Remittance for December 2019 - 14,927.20
Government Statutory Remittance for December 2019 - Correcting Entry 220.00
Government Statutory Remittance for January 2019 - Correcting Entry - 220.00
Payment for December 1-31,2019 Payroll 52,924.00
Payment for December 1-31,2019 Payroll 8,638.02
Payment for December 1-31,2019 Payroll - 423.18
Payment for December 1-31,2019 Payroll - 13,818.04
Payment for December 1-31,2019 Payroll - 47,320.80
Paid BWC Bill for December 20,000.00
Paid BWC Bill for December - 20,000.00
Paid Meralco Bill for December 14,000.00
Paid Meralco Bill for December - 14,000.00
Replenishment of Petty Cash Fund in time for next month 8,000.00
Replenishment of Petty Cash Fund in time for next month - 8,000.00
Adjustment on government stat for December 72.80
Adjustment on government stat for December - 72.80
Balance Checking
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
13670.82
-13670.82
-13670.82
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
 GL Account Code Account Type GL Account Name
1000 Asset Cash in Bank
1001 Asset Petty Cash
1002 Asset Accounts Receivable
1003 Asset Prepaid Rent
1004 Asset Prepaid Auto Insurance
1005 Asset Fixed Asset
2000 Liability Accounts Payable
2001 Liability Utilities Payable
2002 Liability Compensation Tax Payable
2003 Liability Income Tax Payable
2005 Liability Salaries Payable
2006 Liability SSS, PHIC & HDMF Payable
3000 Owner's Equity Bubbles Centro, Capital
3001 Owner's Equity Bubbles Centro, Drawing
3002 Owner's Equity Income Summary
4000 Income Sales
4001 Income Bank Interest Income
5000 Expense Bank Charges
5001 Expense Utilities Expense
5002 Expense Salaries & Wages
5003 Expense Income Tax
5004 Expense SSS, PHIC & HDMF Employer Expense
5005 Expense Supplies Expense
Totals

Legends:
Red Font Formulated Cells
Black Font Hardcoded Cells
 PPG AND Co.
Accounting Worksheet
December 31, 2019

Beginning Balance Journal Entries Ending Balance

Debit Credit Debit Credit Debit

500,000.00 - - - 428,338.80 71,661.20
25,000.00 - 8,000.00 - 8,220.00 24,780.00
84,000.00 - 180,000.00 - 264,000.00
180,000.00 - 180,000.00 - 360,000.00
42,000.00 - 42,000.00 - 84,000.00
450,000.00 - 50,000.00 - 500,000.00
- - 23,000.00 - - -
- - 34,000.00 34,000.00 - -
- - 1,256.38 1,256.38 - 423.18 -
- - 5,000.00 - - -
- - 52,090.80 52,163.60 - 72.80
- - 13,670.82 13,670.82 - 13,890.84 -
- - 1,181,495.81 - - -
- - - - -
- - - - -
- - 120,000.00 - - 180,000.00 -
- - 125.00 - - -
300.00 - - - 300.00
26,000.00 - - - 26,000.00
105,848.00 - 52,924.00 - 158,772.00
- - - - -
8,490.81 - 8,858.02 - 17,348.83
9,000.00 - 8,000.00 - 17,000.00
1,430,638.81 - 1,430,638.81 630,872.82 - 630,872.82 1,523,934.83
Ending Balance Income Statement Balance Sheet

Credit Debit Credit Debit Credit

- - - 71,661.20 -
- - - 24,780.00 -
- - - 264,000.00 -
- - - 360,000.00 -
- - - 84,000.00 -
- - - 500,000.00 -
- 23,000.00 - - - - 23,000.00
- - - - -
- 423.18 - - - - 423.18
- 5,000.00 - - - - 5,000.00
- - - 72.80 -
- 13,890.84 - - - - 13,890.84
- 1,181,495.81 - - - - 1,181,495.81
- - - - -
- - - - -
- 300,000.00 - - 300,000.00 - -
- 125.00 - - 125.00 - -
- 300.00 - - -
- 26,000.00 - - -
- 158,772.00 - - -
- - - - -
- 17,348.83 - - -
- 17,000.00 - - -
- 1,523,934.83 219,420.83 - 300,125.00 1,304,514.00 - 1,223,809.83

Net Income (Loss) 80,704.17 80,704.17

Totals 300,125.00 - 300,125.00 1,304,514.00 - 1,304,514.00
- -
 PPG AND CO.
General Ledger
For the month
GL Account Code Account Type GL Account Name
1000 Asset Cash in Bank
1001 Asset Petty Cash
1002 Asset Accounts Receivable
1003 Asset Prepaid Rent
1004 Asset Prepaid Auto Insurance
1005 Asset Fixed Asset
2000 Liability Accounts Payable
2001 Liability Utilities Payable
2002 Liability Compensation Tax Payable
2003 Liability Income Tax Payable
2005 Liability Salaries Payable
2006 Liability SSS, PHIC & HDMF Payable
3000 Owner's Equity Bubbles Centro, Capital
3001 Owner's Equity Bubbles Centro, Drawing
3002 Owner's Equity Income Summary
4000 Income Sales
4001 Income Bank Interest Income
5000 Expense Bank Charges
5001 Expense Utilities Expense
5002 Expense Salaries & Wages
5003 Expense Income Tax
5004 Expense SSS, PHIC & HDMF Employer Expense
5005 Expense Supplies Expense
Checking

Legends:
Red Font Formulated Cells
Black Font Hardcoded Cells
Pink Fill Dates with financial transactions
Blue Font Data Validated Cells
PPG AND CO.
General Ledger
December 2019
Beginning Balance 02/01/2019 02/02/2019 02/03/2019 02/04/2019 02/05/2019
500,000.00 - 222,000.00 - - - - 102,090.80
25,000.00 - 8,000.00 - - - -
84,000.00 - - - - -
180,000.00 180,000.00 - - - -
42,000.00 42,000.00 - - - -
450,000.00 - - - - 50,000.00
- 23,000.00 - - - - -
- 34,000.00 - - - - -
- 1,256.38 - - - - -
- 5,000.00 - - - - -
- 52,090.80 - - - - 52,090.80
- 13,670.82 - - - - -
- 1,181,495.81 - - - - -
- - - - - -
- - - - - -
- 120,000.00 - - - - -
- 125.00 - - - - -
300.00 - - - - -
26,000.00 - - - - -
105,848.00 - - - - -
- - - - - -
8,490.81 - - - - -
9,000.00 8,000.00 - - - -
- 0.00 - - - - -
02/06/2019 02/07/2019 02/08/2019 02/09/2019 02/10/2019 02/11/2019 02/12/2019
- - - - - - -
- - - - - - -
- - - - - - 30,000.00
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - - 30,000.00
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
02/13/2019 02/14/2019 02/15/2019 02/16/2019 02/17/2019 02/18/2019 02/19/2019
- - - - - - -
- - - - - - -
- - - - 150,000.00 - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - 13,670.82 - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - 150,000.00 - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - 13,670.82 - - - -
02/20/2019 02/21/2019 02/22/2019 02/23/2019 02/24/2019 02/25/2019 02/26/2019
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
- - - - - - -
02/27/2019 02/28/2019 Ending Balance
- - 175,909.20
- - 17,000.00
- - 264,000.00
- - 360,000.00
- - 84,000.00
- - 500,000.00
- - - 23,000.00
- - - 34,000.00
- - - 1,256.38
- - - 5,000.00
- - -
- - -
- - - 1,181,495.81
- - -
- - -
- - - 300,000.00
- - - 125.00
- - 300.00
- - 26,000.00
- - 105,848.00
- - -
- - 8,490.81
- - 17,000.00
- - 13,670.82
 PPG AND CO.
Trial Balance
For the period ending
GL Account Code Account Type GL Account Name
1000 Asset Cash in Bank
1001 Asset Petty Cash
1002 Asset Accounts Receivable
1003 Asset Prepaid Rent
1004 Asset Prepaid Auto Insurance
1005 Asset Fixed Asset
2000 Liability Accounts Payable
2001 Liability Utilities Payable
2002 Liability Compensation Tax Payable
2003 Liability Income Tax Payable
2005 Liability Salaries Payable
2006 Liability SSS, PHIC & HDMF Payable
3000 Owner's Equity Bubbles Centro, Capital
3001 Owner's Equity Bubbles Centro, Drawing
3002 Owner's Equity Income Summary
4000 Income Sales
4001 Income Bank Interest Income
5000 Expense Bank Charges
5001 Expense Utilities Expense
5002 Expense Salaries & Wages
5003 Expense Income Tax
5004 Expense SSS, PHIC & HDMF Employer Expense
5005 Expense Supplies Expense
Checking

Legends:
Red Font Formulated Cells
Black Font Hardcoded Cells
PPG AND CO.
Trial Balance
December 31, 2019
Debit Credit Ending Balance
71,661.20 - 71,661.20
24,780.00 - 24,780.00
264,000.00 - 264,000.00
360,000.00 - 360,000.00
84,000.00 - 84,000.00
500,000.00 - 500,000.00
- - 23,000.00 - 23,000.00
- - -
- - 423.18 - 423.18
- - 5,000.00 - 5,000.00
72.80 - 72.80
- - 13,890.84 - 13,890.84
- - 1,181,495.81 - 1,181,495.81
- - -
- - -
- - 300,000.00 - 300,000.00
- - 125.00 - 125.00
300.00 - 300.00
26,000.00 - 26,000.00
158,772.00 - 158,772.00
- - -
17,348.83 - 17,348.83
17,000.00 - 17,000.00
1,523,934.83 - 1,523,934.83 - 0.00
 PPG AND Co.
Statement of Financial Performance
For the month endedDecember 31, 2019

Revenues & Gains

1 4000 Sales 300,000.00
2 4001 Bank Interest Income 125.00
Total Revenue & Gains 300,125.00

Expenses & Losses

1 5000 Bank Charges - 300.00
2 5001 Utilities Expense - 26,000.00
3 5002 Salaries & Wages - 158,772.00
4 5003 Income Tax -
5 5004 SSS, PHIC & HDMF Employer Expense - 17,348.83
6 5005 Supplies Expense - 17,000.00
Total Expenses & Losses - 219,420.83

Net Income 80,704.17

Legends:
Red Font Formulated Cells
Black Font Hardcoded Cells
Blue Font Data Validated Cells
 PPG AND Co.
Statement of Financial Position
December 31, 2019

ASSETS
Current Asset/s
1000 Cash in Bank 71,661.20
1001 Petty Cash 24,780.00
1002 Accounts Receivable 264,000.00
1003 Prepaid Rent 360,000.00
1004 Prepaid Auto Insurance 84,000.00
804,441.20
Non Current Asset/s
1005 Fixed Asset 500,000.00
TOTAL ASSETS 500,000.00 1,304,441.20

EQUITY AND LIABILITIES

Current Liabilities
2000 Accounts Payable 23,000.00
2001 Utilities Payable -
2002 Compensation Tax Payable 423.18
2003 Income Tax Payable 5,000.00
2005 Salaries Payable 72.80
2006 SSS, PHIC & HDMF Payable 13,890.84
TOTAL LIABILITITIES 42,386.82

Equity
3000 Bubbles Centro, Capital 1,181,495.81
3001 Bubbles Centro, Drawing -
3002 Income Summary -
TOTAL EQUITY 1,181,495.81
TOTAL EQUITY & LIAIBLITIES 1,223,882.63

*Reconciling item 80,704.17

Variance - 145.60