Scribd
Upload
81 views8 pages

Bir 1701Q

The document shows sales and purchase figures for a company from January to September 2022. It also includes calculations for gross income, deductions, net income, and tax payable amounts. For the first three months, net income was ₱1,012,057.79. For April to June, net income was ₱476,811.25, bringing the total for the first half of the year to ₱1,488,869.04. Tax payable for the second quarter was calculated to be ₱114,421.27. Sales and costs are also shown for July to September, with a net income of ₱441,806.23 for that period.

Uploaded by

Carl Joseph Ninobla Josue
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
81 views8 pages

Bir 1701Q

The document shows sales and purchase figures for a company from January to September 2022. It also includes calculations for gross income, deductions, net income, and tax payable amounts. For the first three months, net income was ₱1,012,057.79. For April to June, net income was ₱476,811.25, bringing the total for the first half of the year to ₱1,488,869.04. Tax payable for the second quarter was calculated to be ₱114,421.27. Sales and costs are also shown for July to September, with a net income of ₱441,806.23 for that period.

Uploaded by

Carl Joseph Ninobla Josue
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 8

SALES PURCHASES

JANUARY 2022 3,728,597.37 3,209,143.27


FEBRUARY 2022 4,162,312.62 3,593,481.22
MARCH 2022 5,005,740.87 4,317,166.02
12,896,650.86 11,119,790.51

January-March 12,896,650.86
SALES ₱ 12,896,650.86
LESS: COST OF SALES
Beg. Inventory ₱ 43,142,663.25
Purchases ₱ 11,119,790.51
Ending Inventory ₱ 45,045,001.00
COST OF SALES ₱ 9,217,452.76
GROSS INCOME ₱ 3,679,198.10

LESS: DEDUCTION

Salary 1,109,531.25

Rent ₱ 1,557,609.06

Light and Water

Miscellaneous

TOTAL DEDUCTION ₱ 2,667,140.31

NET INCOME ₱ 1,012,057.79

EXCESS OVER ₱800,000 ₱ (800,000.00)


EXCESS OVER ₱800,000.00 ₱ (800,000.00)

₱ 212,057.79
₱ 130,000.00 + 30% OF THE EXCESS OVER ₱800,000.00 0.30
₱ 63,617.34

₱ 130,000.00

2% REQUIRED REPORT ₱ 193,617.34

1.50%

1ST QTR 2307 ₱ 45,999.48

TOTAL PAYABLE ₱ 147,617.86


SALES
APRIL 2022 4,853,483.57
MAY 2022 4,690,585.37
JUNE 2022 4,254,992.87
13,799,061.81

April-June
SALES ₱ 13,799,061.81
LESS: COST OF SALES
Beg. Inventory ₱ 45,045,001.00
Purchases ₱ 11,377,067.33
Ending Inventory ₱ 45,882,331.00
COST OF SALES ₱ 10,539,737.33
GROSS INCOME ₱ 3,259,324.48

LESS: DEDUCTION

Salary 1,114,487.51

Rent ₱ 1,668,025.72

Light and Water

Miscellaneous

TOTAL DEDUCTION ₱ 2,782,513.23

NET INCOME ₱ 476,811.25

1ST QTR ₱ 1,012,057.79


₱ 1,488,869.04

EXCESS OVER ₱800,000 ₱ (800,000.00)


₱ (800,000.00)
EXCESS OVER ₱800,000.00

₱ 688,869.04

₱ 130,000.00 + 30% OF THE EXCESS OVER ₱800,000.00


₱ 206,660.71

₱ 130,000.00

2% REQUIRED REPORT ₱ 336,660.71

1ST QTR 2307 1ST QTR 2307 ₱ (45,999.48)


₱ (147,617.86)

2nd QTR 2307 ₱ (28,622.11)

TOTAL PAYABLE ₱ 114,421.27


PURCHASES SALES
4,028,895.46 July 4,056,563.87
3,876,955.87 august 3,688,819.52
3,471,216.00 september 3,950,071.05
11,377,067.33 ₱ 11,695,454.44

₱ 13,799,061.81 july-September
SALES ₱ 11,695,454.44
LESS: COST OF SALES
Beg. Inventory ₱ 45,882,331.00
Purchases ₱ 9,348,685.25
Ending Inventory ₱ 46,979,687.00
COST OF SALES ₱ 8,251,329.25
GROSS INCOME ₱ 3,444,125.19

LESS: DEDUCTION

Salary (July-Sept) 1,114,730.78

Rent Fixed Rent(July-Sept) ₱ 1,887,588.18

Light and Water

Miscellaneous

TOTAL DEDUCTION ₱ 3,002,318.96

NET INCOME ₱ 441,806.23


1st Quarter ₱ 1,012,057.79
2nd Quarter ₱ 476,811.25
₱ 1,930,675.27

EXCESS OVER ₱800,000 ₱ (800,000.00)


₱ (800,000.00)
EXCESS OVER ₱800,000.00

₱ 1,130,675.27

30% ₱ 130,000.00 + 30% OF THE EXCESS OVER ₱800,000.00


₱ 339,202.58

₱ 130,000.00

2% REQUIRED REPORT ₱ 469,202.58

2.44%

1ST QTR 2307 ₱ (45,999.48)


Total Payables 1st ₱ (147,617.86)
Total Payables 2nd ₱ (114,421.27)
2nd QTR 2307 ₱ (28,622.11)
3rd QTR 2307 ₱ (21,070.58)

TOTAL PAYABLE ₱ 111,471.29


PURCHASES
3,306,839.16
3,030,664.21
3,011,181.88
9,348,685.25

36a

37a
38a

39a
41a

42a
30%

4.01% 46a

57a

56a
57a
58a

You might also like