HomeMy WebLinkAbout158450 04/15/2008 CITY OF CARMEL, INDIANA VENDOR: 00350929 Page 1 of 1 ONE CIVIC SQUARE INDIANA DEPT OF REVENUE CARMEL, INDIANA 46032 CHECK AMOUNT: $917.90 SYSTEM SERVICES •c off PO BOX 6197 CHECK NUMBER: 158450 INDIANAPOLIS IN 46206 -6197 CHECK DATE: 4/15/2008 DEPARTMENT ACCOUNT PO NUMBER INVOICE NUMBER AMOUNT DESCRIPTION 905 4359200 SALES TAX 917.90 SALES TAX PAID Brookshire Golf Club Sales Tax Revised April 10, 2008 Total Non Taxable Taxable Tax Sales Sales Sales Payable 2008 January Sales Tax 5,819.93 5,738.00 81.93 4.92 Interest 0.00 Penalty 0.00 Collection Allowance (0.04) 4.88 February Sales Tax 2,767.71 1,552.00 1,215.71 72.94 Interest 0.00 Penalty 0.00 Collection Allowance (0.61) 72.33 March Sales Tax 51,147.14 35,720.80 15,426.34 925.58 Interest 0.00 Penalty 0.00 Collection Allowance (7.68) 917.90 Total 59, 734.78 43, 010.80 16, 723.98 YTD SALES TAX PAID 1,003.44 YTD INTEREST PAID 0.00 YTD PENALTIES PAID 0.00 YTD COLLECTION ALLOWANCE (8.33) TOTAL 995.11 Amount paid with check 156645, dated 2/21/08 4.88 Amount paid with check 157361, dated 3/18/08 72.33 AMOUNT TO BE PAID 917.90 Brookshire Golf Club Reconciliation to Clerk Treasurer's Numbers Revised April 10, 2008 Clerk Treasurer YTD Revenue Audit Trail as of 03108: Total Non Taxable Taxable Sales Sales Sales Green Fees 1,816.10 1,816.10 0.00 Membership Fees 33,237.00 33,237.00 0.00 Cart Fees 218.10 218.10 Member Cart Fees 13,900.00 13,900.00 Pro Shop Non Taxable 7,617.70 7,617.70 0.00 Pro Shop Taxable 1,146.12 1,146.12 Food and Beverage Non Taxabl 340.00 340.00 0.00 Food and Beverage Taxable 1,459.76 1,459.76 Total 59,734.78 43,010.80 16,723.98 Prev. Page Totals 59, 734.78 43,090.80 16, 723.98 Brookshire Golf Club Food and Beverage Tax Revised April 10, 2008 Carmel Hamilton Total Non Taxable Taxable FAB Tax FAB Tax Sales Sales Sales Payable Payable January FAB Tax 0.00 0.00 0.00 0.00 0.00 Interest 0.00 0.00 Penalty 0.00 0.00 Collection Allowance 0.00 0.00 0.00 0.00 February FAB Tax 515.71 0.00 515.71 5.16 5.16 Interest 0.00 0.00 Penalty 0.00 0.00 Collection Allowance (0.04) (0.04) 5.12 5.12 March FAB Tax 944.05 0.00 944.05 9.44 9.44 Interest 0.00 0.00 Penalty 0.00 0.00 Collection Allowance (0.08) (0.08) 9.36 9.36 1,459.76 0.00 1,459.76 YTD FAB TAX PAID 29.20 YTD FAB INTEREST PAID 0.00 YTD FAB PENALTIES PAID 0.00 YTD COLLECTION ALLOWANCE (0.24) TOTAL 28.96 No January payment owed 0.00 Amount paid with check 157360, dated 3/18/08 10.24 AMOUNT TO BE PAID 18.72 Brookshire Golf Club Sales and FAB Tax Amounts Collected vs. Owed Revised April 10, 2008 YTD SALES TAX OWED/ PAID 1,003.44 YTD SALES TAX COLLECTED Pro Shop Tax 69.52 Golf Cart Tax 847.09 Sales Portion of FAB Sales 67.26 983.87 OVER (UNDER) COLLECTED (19.57) YTD FAB TAX OWED/ PAID 29.20 YTD FAB TAX COLLECTED 22.42 OVER (UNDER) COLLECTED (6.78) Prescribed by State Board of Accounts City Form No. 201 (Rev. 1995) ACCOUNTS PAYABLE VOUCHER CITY OF CARMEL An invoice or bill to be properly itemized must show: kind of service, where performed, dates service rendered, by whom, rates per day, number of hours, rate per hour, number of units, price per unit, etc. Payee Purchase Order No. Terms Date Due Invoice Invoice Description Amount Date Number (or note attached invoice(s) or bill(s)) 4 (�J.. �aX f `7. qO Total c ((`1 a hereby certify that the attached invoice(s), or bill(s), is (are) true and correct and I have audited same in accordance with IC 5- 11- 10 -1.6. 20 Clerk- Treasurer VOUCHER NO. WARRANT NO. ALLOWED 20 IN SUM OF Of ON ACCOUNT OF APPROPRIATION FOR Board Members PO# or INVOICE NO. ACCT #/TITLE AMOUNT DEPT. I hereby certify that the attached invoice(s), or X 16$` 0 t 7, 9 0 bill(s) is (are) true and correct and that the materials or services itemized thereon for which charge is made were ordered and received except A, L 0. S'gna re- Cost distribution ledger classification if Title claim paid motor vehicle highway fund