2024 JAN FEB MAR 1st Quarter April
Sales Sales April
Total Gross Sales $ 2,353,327.02 $ 2,214,406.89 $ 2,343,830.05 $ 6,911,563.96 $ 2,250,689.36 Total Gross Sales $ 2,250,689.36 Total Sales and Income including VAT $ 2,250,689.36
EXEMPT SALES $ 29,750.90 $ 74,976.00 $ 51,651.00 $ 156,377.90 $ 75,503.40 EXEMPT SALES $ 75,503.40 Zero-Rated Supplies
VAT COLLECTED $ 258,175.12 $ 237,714.54 $ 254,686.56 $ 750,576.23 $ 241,687.33 VAT COLLECTED $ 241,687.33 Exempt Supplies $ 75,503.40
Net Sales $ 2,095,151.90 $ 1,976,692.35 $ 2,089,143.49 $ 6,160,987.73 $ 2,009,002.03 Net Sales $ 2,009,002.03 Substract Boxes 2 and 3 from Box 1 $ 2,175,185.96
Divide box 4 by 9 $ 241,687.33
Cost of Good Sold Non Vat Payment Adjustment to Vat Collected
Opening Stock $ 2,378,682.56 $ - $ - $ 2,378,682.56 FOB $ 994,432.26 Add boxes 5 and 6 here Total Vat Collected $ 241,687.33
FOB $ 1,157,217.88 $ 625,311.51 $ 1,034,427.43 $ 2,816,956.82 $ 994,432.26 Purchase $ 36,220.00
Purchase $ 66,853.46 $ 45,444.98 $ 63,306.95 $ 175,605.39 $ 36,220.00 Freights & Insurance $ 204,663.04 Total Purchases and Expenses Including VAT $ 1,639,849.26
Freights & Insurance $ 192,242.63 $ 171,994.95 $ 247,797.45 $ 612,035.03 $ 204,663.04 Import Levy $ 27,780.06 Non-Creditable Acquisition $ 1,460,896.54
Import Levy $ 34,687.80 $ 19,328.38 $ 35,316.22 $ 89,332.40 $ 27,780.06 Import Excise Tax $ 18,952.26 Substract box 8 from box 9 $ 178,952.72
Import Excise Tax $ 123,443.85 $ 30,001.97 $ 35,316.22 $ 188,762.04 $ 18,952.26 Acceptance Fee $ 33.00 Divide box 10 by 9 $ 19,883.64
Acceptance Fee $ 29.00 $ 35.00 $ 43.00 $ 107.00 $ 33.00 Rental charge $ - VAT paid on Imported Goods $ 108,934.88
Rental charge $ - $ - $ - $ - $ - Package Deposit $ - Government withhold Vat $ 3,886.06
Package Deposit $ - $ - $ - $ - $ - KPA $ 20,898.10 Adjustment to Vat
Shipping Agent Cost $ 86,164.31 $ 23,463.18 $ 17,982.00 $ 127,609.49 $ 13,712.78 Waste Levy $ 13,947.14 Total VAT Paid $ 132,704.58
KPA $ 23,332.60 $ 11,209.58 $ 15,861.42 $ 50,403.60 $ 20,898.10 Bank Fee $ 74.00 VAT to be paid $ 108,982.75
Waste Levy $ 7,420.40 $ 3,386.60 $ 6,516.40 $ 17,323.40 $ 13,947.14 Bonus $ 160.00
Total Inventory Cost $ 4,070,074.49 $ 930,176.15 $ 1,456,567.09 $ 6,456,817.73 $ 8,843,560.97 Building Rentals $ 30,000.00
Less Closing Stock $ - $ - $ - $ - Bus Fares $ 38.00
Cost of Good sold $ 1,676,121.52 $ 1,581,353.88 $ 1,671,314.79 $ 4,928,790.18 $ 1,607,201.62 DBK Loan Repayment $ 2,607.66
Depreciaton $ 23,553.75
Gross Profit $ 419,030.38 $ 395,338.47 $ 417,828.70 $ 1,232,197.55 $ 401,800.41 Housing Loang Repayment $ 1,213.60
Insurance $ 2,716.00
Operational Expenses KPF Contributions $ -
Bank Fee $ 94.40 $ 52.00 $ 554.91 $ 701.31 $ 74.00 KPF Loan Repayment $ 3,048.62
Bonus $ 120.00 $ 1,436.40 $ 1,932.80 $ 3,489.20 $ 160.00 Land Rent $ 2,600.00
Building Rentals $ 854.93 $ - $ 666.67 $ 1,521.60 $ 30,000.00 Licenses $ 13,463.17
Bus Fares $ 68.60 $ 28.60 $ 52.90 $ 150.10 $ 38.00 Management Fee $ -
Carpentry Repair / Maintenance $ 64.84 $ 197.78 $ 2,600.00 $ 2,862.62 $ 268.14 Overtime $ 1,192.35
Coins charges $ 1,264.07 $ 1,735.01 $ 1,534.84 $ 4,533.92 $ 1,945.24 PUB - Power $ 2,699.48
Company Supplies $ 2,493.15 $ 836.09 $ 186.49 $ 3,515.73 $ 764.49 Toll Fares $ 182.30
Container Storage $ - $ 133.33 $ - $ 133.33 $ - Wages / Salary $ 60,421.75
Damages $ 20,951.52 $ 19,766.92 $ 20,891.43 $ 61,609.88 $ 20,090.02 $1,460,896.54
DBK Loan Repayment $ 3,797.48 $ 2,425.96 $ 2,447.60 $ 8,671.04 $ 2,607.66
Depreciaton $ 23,553.75 $ 23,553.75 $ 23,553.75 $ 70,661.25 $ 23,553.75 VAT Payment
Donation $ 6,269.69 $ 4,626.34 $ 12,176.72 $ 23,072.75 $ 10,039.74 Shipping Agent Cost $ 13,712.78
Electrical Repair / Maintenance $ 287.92 $ 456.01 $ 861.76 $ 1,605.69 $ 526.32 Carpentry Repair / Maintenance $ 268.14
Entertainment / Refreshment $ 3,563.97 $ 7,783.66 $ 10,152.00 $ 21,499.63 $ 4,007.17 Coins charges $ 1,945.24
Fuel $ 9,396.25 $ 12,622.52 $ 8,635.60 $ 30,654.37 $ 10,261.53 Company Supplies $ 764.49
Housing Loang Repayment $ 1,626.83 $ 1,213.60 $ 1,174.45 $ 4,014.88 $ 1,213.60 Container Storage $ -
Information Technology $ 1,814.12 $ 312.19 $ - $ 2,126.31 $ - Damages $ 20,090.02
Insurance $ 693.33 $ 871.11 $ 897.78 $ 2,462.22 $ 2,716.00 Donation $ 10,039.74
Internet Fee $ 2,510.08 $ 904.10 $ 4,891.39 $ 8,305.57 $ 1,226.79 Electrical Repair / Maintenance $ 526.32
KPF Contributions $ 7,624.22 $ 9,414.64 $ 9,185.32 $ 26,224.18 $ - Entertainment / Refreshment $ 4,007.17
KPF Loan Repayment $ 4,981.02 $ 3,405.64 $ 3,179.14 $ 11,565.80 $ 3,048.62 Fuel $ 10,261.53
Land Rent $ 8,862.50 $ 5,400.00 $ 150.00 $ 14,412.50 $ 2,600.00 Information Technology $ -
Licenses $ 19,810.20 $ 557.20 $ 340.00 $ 20,707.40 $ 13,463.17 Internet Fee $ 1,226.79
Management Fee $ 900.00 $ - $ - $ 900.00 Mechanical Repair / Maintenance$ 1,514.88
Mechanical Repair / Maintenance $ 1,858.22 $ 1,315.22 $ 3,334.50 $ 6,507.94 $ 1,514.88 Office Utiliies $ 196.62
Office Utiliies $ 340.62 $ 507.00 $ 98.23 $ 945.85 $ 196.62 Others $ 14,643.67
Others $ 12,633.30 $ 12,718.17 $ 17,700.55 $ 43,052.02 $ 14,643.67 Overheads $ 19,495.09
Overheads $ 3,935.67 $ 3,935.67 $ 3,935.67 $ 11,807.00 $ 19,495.09 Phone Utility Cost $ 947.95
Overtime $ 303.45 $ 1,116.65 $ 762.00 $ 2,182.10 $ 1,192.35 Refund $ 311.11
Phone Utility Cost $ 430.78 $ 362.65 $ 361.34 $ 1,154.77 $ 947.95 Shrinkages $ 40,180.04
PUB - Power $ 18,840.90 $ 34,673.50 $ 38,958.09 $ 92,472.49 $ 2,699.48 Staff Oncredit $ 1,737.77
Refund $ 2,584.19 $ 5,146.66 $ 6,417.60 $ 14,148.45 $ 311.11 Travelling Expenses $ 37,083.37
Shrinkages $ 41,903.04 $ 39,533.85 $ 41,782.87 $ 123,219.75 $ 40,180.04 $178,952.72
Staff Oncredit $ 6.80 $ 568.89 $ - $ 575.69 $ 1,737.77
Toll Fares $ 2,384.10 $ 160.10 $ 177.80 $ 2,722.00 $ 182.30
Travelling Expenses $ - $ 15,616.44 $ 3,700.00 $ 19,316.44 $ 37,083.37
Wages / Salary $ 220,443.30 $ 129,198.12 $ 59,079.89 $ 408,721.31 $ 60,421.75
Total Operating Expenses $ 427,267.23 $ 342,585.77 $ 282,374.09 $ 1,052,227.09 $ 309,210.62
Net Profit before income Tax -$ 8,236.85 $ 52,752.70 $ 135,454.61 $ 179,970.45 $ 92,589.79
Income Tax to be Paid $ - $ 5,250.00 $ 5,250.00
$ 6,825.81 $ 40,636.38 $ 47,462.19 $ 27,776.94
Total Income Tax to be Paid $ - $ 12,075.81 $ 40,636.38 $ 52,712.19 $ 27,776.94