Scribd
Upload
38 views9 pages

Audit - BBC

This document summarizes sales, purchases, and tax payments for Oriole Declarations from January to September 2023. Total sales were PHP 43.7 million with PHP 34.6 million in zero-rated sales. Purchases totaled PHP 4.6 million. Sales and purchase tax payments were made for some months in 2023, while others were filed but not paid or had penalties.

Uploaded by

andrea.begulbuilderscorp
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
38 views9 pages

Audit - BBC

This document summarizes sales, purchases, and tax payments for Oriole Declarations from January to September 2023. Total sales were PHP 43.7 million with PHP 34.6 million in zero-rated sales. Purchases totaled PHP 4.6 million. Sales and purchase tax payments were made for some months in 2023, while others were filed but not paid or had penalties.

Uploaded by

andrea.begulbuilderscorp
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/ 9

ORIO DECLARATIONS SUMMARY

PRIVATE SALES
MONTH NET OF VAT OUTPUT VAT ZERO RATED TOTAL SALES

EXCESS INPUT VAT 2022


JANUARY - -
FEBUARY - -
MARCH - -
TOTAL - - - -
- -
APRIL - 1,837,237.77 1,837,237.77
MAY 5,168,487.53 620,218.50 5,168,487.53
JUNE - -
TOTAL 5,168,487.53 620,218.50 1,837,237.77 7,005,725.30
- -
JULY 3,625,757.47 435,090.90 32,746,830.62 36,372,588.09
AUGUST - -
SEPTEMBER 281,250.00 33,750.00 281,250.00
TOTAL 3,907,007.47 468,840.90 32,746,830.62 36,653,838.09
- -
OCTOBER - -
NOVEMBER - -
DECEMBER - -
TOTAL - - - -

DETAILS
ORIO DECLARATION PURCHASES
PURCHASES BASED ON MITCH EXCEL SLSP EXPENSES SU
(net of vat)
JANUARY 255,163.12
FEBRUARY 122,653.12 JANUARY
user:
MARCH 251,230.67 *gross ang basis and ge FEBRUARY
APRIL 635,585.59 apil ang nonvat og declare MARCH
based on summary of
APRIL VAT DECLARATION 1,264,632.50 APRIL
purchase and expenses
MAY
JUNE
MAY 374,572.26 JULY
MAY VAT DECLARATION 374,572.26 AUGUST
SEPTEMBER
JUNE 96,213.17 OCTOBER
JUNE VAT DECLARATION 96,213.17 NOVEMBER
DECEMBER
JULY 467,742.18
JULY VAT DECLARATION 467,742.18

AUGUST 1,120,942.34
AUGUST VAT DECLARATIO 1,120,942.34
DATA AS OF JANUARY - SEPTEMBER 2023

SALES NET OF
TOTAL VAT
PURCHASES INPUT TAX VAT PAYABLE
ORIO 9,075,495.00
(7,159,536.61) BEGUL DATA 10,036,403.23
- -
- - VARIANCE - 960,908.23
- -
- - - RETURN 2550M/Q 9,075,495.00
- - ORIO 9,075,495.00
1,264,632.49 151,755.90 - 7,311,292.51
374,572.26 44,948.67 - 6,736,022.68 VARIANCE -
96,213.17 11,545.58 - 6,747,568.26
1,735,417.92 208,250.15 - 6,747,568.26
- -
467,742.18 56,129.06 - 6,368,606.42
1,120,942.34 134,513.08 - 6,503,119.50 *DETAILED COMPUTATION OF SALES KAY NAA SA SALES DA
- - 6,469,369.50
1,588,684.52 190,642.14 - 6,469,369.50 *DETAILED DATA SA RETURNS IS NAA SA RETURNS NA SHE
- -
- -
- -
- -
- - -

D ON MITCH EXCEL SLSP EXPENSES SUMMARY

GROSS NET OF VAT INPUT VAT NON VAT TOTAL


285,782.69 255,163.12 30,619.57 25,294.00 311,076.69
137,371.49 122,653.12 14,718.37 62,036.00 199,407.49
281,378.35 251,230.67 30,147.68 35,499.25 316,877.60
609,497.59 544,194.28 65,303.31 26,088.00 635,585.59
419,520.93 374,572.26 44,948.67 130,211.40 549,732.33
107,758.75 96,213.17 11,545.58 26,165.00 133,923.75
523,871.24 467,742.18 56,129.06 34,022.00 557,893.24
1,255,455.42 1,120,942.34 134,513.08 40,360.00 1,295,815.42
1,386,483.41 1,237,931.62 148,551.79 112,138.50 1,498,621.91
- - -
- - -
- - -
5,007,119.87 4,470,642.74 536,477.13 491,814.15 5,498,934.02
EMBER 2023

PURCHASES
OUTPUT VAT ZERO RATED NET OF VAT INPUT VAT TAX LIABILITY
(7,159,536.61)
1,089,059.40 34,584,068.39 4,562,034.05 547,444.09 - 6,617,921.30
1,204,368.39 48,560,257.31 4,470,642.74 536,477.13 - 5,950,030.04

- 115,308.99 - 13,976,188.92 91,391.31 10,966.96 - 667,891.26

1,089,059.40 34,584,068.39 4,562,034.05 547,444.09 - 6,617,921.30


1,089,059.40 34,584,068.39 4,562,034.05 547,444.09 - 6,617,921.30

- - - - -

OF SALES KAY NAA SA SALES DATA SHEET

S IS NAA SA RETURNS NA SHEET


AUDIT SUMMARY

BASED ON RETURN
2550-M/Q

NET SALES OUTPUT VAT ZERO RATED TOTAL SALES PURCHASES


JANUARY - - - -
FEBRUARY - - - -
MARCH - -
APRIL - -
MAY - -
JUNE 5,168,487.53 620,218.50 1,837,237.77 7,005,725.30 1,735,417.92
JULY - -
AUGUST - -
SEPTEMBER 3,907,007.47 468,840.90 32,746,830.62 36,653,838.09 2,826,616.13
OCTOBER - -
NOVEMBER - -
DECEMBER - -
TOTAL 9,075,495.00 1,089,059.40 34,584,068.39 43,659,563.39 4,562,034.05

1601-C
AMOUNT WITHHOLDING
JANUARY 258,359.92 3,400.20 FILED/NOT PAID
FEBRUARY - - FILED
MARCH - - FILED
APRIL 223,734.00 3,366.80 FILED AND PAID
MAY 223,734.26 3,366.80 FILED AND PAID
JUNE 223,734.26 3,366.80 FILED AND PAID
JULY 244,226.26 - FILED PENALTY 1000
AUGUST 468,452.51 3,334.20 FILED AND PAID
SEPTEMBER 234,226.26 1,667.10 FILED AND PAID
OCTOBER
NOVEMBER
DECEMBER

0619-E/1601-EQ
WITHHOLDING REMARKS
JANUARY 2,833.47 FILED AND PAID
FEBRUARY - FILED
MARCH 6,333.58 FILED AND PAID
APRIL - FILED PAID 1000 PENALTY
MAY 9,154.39 FILED AND PAID
JUNE 7,346.54 FILED AND PAID
JULY 5,181.42 FILED AND PAID
AUGUST 12,453.12 FILED AND PAID
SEPTEMBER 15,158.08 FILED AND PAID
OCTOBER
NOVEMBER
DECEMBER

ACTUAL SALES
EXCESS INPUT
INPUT VAT VAT VAT PAYABLE REMARKS
- - FILED/ZERO
- - FILED/ZERO
- - NO FILLING
- - NO FILLING
- - FILED/ZERO
208,250.15 7,159,536.61 - 6,747,568.26 FILED/NEGATIVE
- - NO FILLING
- - NO FILLING
339,193.94 6,747,568.26 - 6,617,921.30 FILED/NEGATIVE
- -
- -
- -
547,444.09 13,907,104.87 - 13,365,489.56
GROSS
OR VATABLE ZERO RATED EWT
Sta Clara International Corporation 3196 1,850,021.32 93,755.96
Sta Clara International Corporation 3229 194,102.39 6,470.08
Sta Clara International Corporation 3228 1,044,690.34 37,028.01
Sta Clara International Corporation 3230 636,296.85 31,098.90
Sta Clara International Corporation 3233 1,725,713.73 68,445.11
Sta Clara International Corporation 3232 8,532,480.46 4,772,859.80
Sta Clara International Corporation 3241 280,933.14 13,231.10
Sta Clara International Corporation 3242 2,937,037.74 98,666.82
Sta Clara International Corporation 3243 197,713.60 3,954.27
Sta Clara International Corporation 3244 6,498,983.93 129,979.68
Sta Clara International Corporation 3245 10,527,159.20 572,561.02
Sta Clara International Corporation 3250 170,500.00
Sta Clara International Corporation 3502 13,964,624.62
Cepalco Energy Services Corporation 3501 59,360.00 1,060.00
Home Plus Trading Depot Inc. 3505 65,000.00 1,160.71
Lapanday Diversified Products Corporation 3240 288,900.00 5,158.93
Robinsons Supermarket Corporation 3227 1,200,000.00 21,428.57
Robinsons Appliances Corporation 3510 250,000.00 4,464.29
Tanduay Distillers Incorporated 3200 645,000.00 -
Tanduay Distillers Incorporated 185,000.00 -
3231
Tanduay Distillers Incorporated 160,000.00 -
Tanduay Distillers Incorporated 3239 1,290,000.00 38,392.86
Tanduay Distillers Incorporated 3247 41,952.00 749.14
Tanduay Distillers Incorporated 3508 127,348.83 -
Universal Robina Corporation 3198 310,500.00 5,544.64
Universal Robina Corporation 3199 300,500.00 5,366.07
Universal Robina Corporation 3234 295,702.40 5,280.40
Universal Robina Corporation 3235 295,000.00 5,267.86
Universal Robina Corporation 3236 480,000.00 8,571.43
Universal Robina Corporation 3237 843,000.00 15,053.57
Universal Robina Corporation 3238 2,600,640.00 46,440.00
Universal Robina Corporation 3507 242,250.00 4,325.89
Universal Robina Corporation 3506 356,250.00 6,361.61

TOTAL 10,036,403.23 48,560,257.31 6,002,676.72


NET OF EWT
1,756,265.36
187,632.31
1,007,662.33
605,197.96
1,657,268.62
3,759,620.66
267,702.03
2,838,370.92
193,759.33
6,369,004.25
9,954,598.17
170,500.00
13,964,624.62
58,300.00
63,839.29
283,741.07
1,178,571.43
245,535.71
645,000.00
185,000.00
160,000.00
1,251,607.14
41,202.86
127,348.83
304,955.36
295,133.93
290,422.00
289,732.14
471,428.57
827,946.43
2,554,200.00
237,924.11
349,888.39

52,593,983.82

You might also like