Docstoc

Cash Register Receipts + Wisconsin Taxes

Document Sample
Cash Register Receipts + Wisconsin Taxes Powered By Docstoc
					Filing Procedures


All departments within the University will report their monthly sales figures in an identical manner to the Corporate
Tax Office. This method will promote proper compliance with state and local sales tax laws.

Each department is responsible for keeping track of its gross sales, taxable sales and sales tax collected. At present,
each department has a different method of keeping track of these items (e.g., Quickbooks, cash register receipts and
handwritten paper receipts, etc.) Regardless of the method used, all departments within the University will be
responsible for reporting monthly sales and sales tax.


Information compiled by individual departments must be forwarded to the CTO on or before the 5 th day of each month.

Appendix 1
Gross sales, taxable sales and sales tax collected must be entered by object code into the attached “Monthly Sales-
Reconcilation to Ledger Worksheet”. Non-taxable sales will be calculated automatically once gross sales and taxable
sales have been entered. These totals must agree with Appendix 2 which is representation of a Wisconsin sales and
use tax return.
The total tax collected will populate into the second section of Appendix 1 under the "Monthly Worksheet" column.
Any necessary adjustments must be recorded in Object Code 2118 / Program Value 0149 including but not limited to:
· Adjustments for prior month return, refunds, or reclasses
· Any reclass for improperly booked sales tax (i.e. tax collected but booked improperly in revenue object code)
· Accrual of sales tax not collected to ensure that taxes inadvertently not collected from the customer are paid

Appendix 2
Taxable sales information must be entered by location in the "Input Information" section of the worksheet. The top
portion of the worksheet automatically calculates the sales tax due based on Appendix 1. Appendix 1 and 2 are the
underlying support for filed tax returns. However, all invoices and supporting documentation should be
maintained for 7 years for audits purposes.


Appendix 3
County and Stadium sales tax rates. Please note that these rates are subject to change. Contact the tax office if you
need to verify the current rates.


Appendix4
To the extent that a department begins selling any additional products or services during the month, the Corporate Tax
Office must be informed within two weeks of the introduction of the new item. A “New Product/Service Notification
Worksheet”, attached should be submitted, and should contain the following information:
(a) A description of the product,
(b) When the product was introduced,
(c) What is the expected customer base and
(d) The 26-digit account number for reporting the new revenue stream

Centers must collaborate with the Corporate Tax Office as soon as possible regarding the taxability of any additional
products or services but no later than two weeks prior to the sales of the new item(s).
Trustees of the University of Pennsylvania                                  APPENDIX 1
Monthly Sales - Reconciliation to Ledger


Department:
Month/Year:

Note: The state tax rate is 5% and varies by county (see appendix 3)


        Object                  Gross            Taxable   Non Taxable              Tax
        Codes                   Sales             Sales       Sales               Collected

                     4320   $            -   $         -            $0.00     $          -
                     4321   $            -   $         -            $0.00     $          -
                     4322   $            -   $         -            $0.00     $          -
                     4340   $            -   $         -            $0.00     $          -
                     4350   $            -   $         -            $0.00     $          -
                     4360   $            -   $         -            $0.00     $          -
                     4361   $            -   $         -            $0.00     $          -
                     4370   $            -   $         -            $0.00     $          -
                     4371   $            -   $         -            $0.00     $          -
                     4380   $            -   $         -            $0.00     $          -
                     4398   $            -   $         -            $0.00     $          -
                     4399   $            -   $         -            $0.00     $          -
                            $            -   $         -   $          -       $          -




                                Month          Monthly            BEN
                                Posted        Worksheet        Financials
Sales Tax                                    $       -
  Adjustments                                $       -
    Additions                                $       -




    Subtractions



Adjusted Sales Tax                           $         -   $           -
UNIVERSITY OF PENNSYLVANIA
Wisconsin Tax Commission                                                        APPENDIX 2


 1 Total Sales (Whole Dollars)   $                -

 2 Subtractions from sales       $                -

 3 Net Taxable Sales             $                -
                                                             Tax Rate
 4 State Tax                     $                -           5.00%            $              -

 5 Local Tax
     County (Schedule 1)                                                       $              -
     Stadium (Schedule 2)                                                      $              -

                                     Grand Total                               $              -




            Schedule 1               Input Info          See Appendix 3



               County            Taxable Sale             County Rate              County tax

                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                              0.50%                           -
                                                  0.00                                        -




            Schedule 2               Input Info          See Appendix 3



      11/15/2010                                               C:\Docstoc\Working\pdf\3238d565-e5b9-4b0c-bd8c-3e7309337c56.xls
         County   Taxable Sales    Stadium rate         Stadium Tax

                                      0.10%                           -
                                      0.10%                           -
                                      0.10%                           -
                                      0.10%                           -

                            0.00                                      -




11/15/2010                             C:\Docstoc\Working\pdf\3238d565-e5b9-4b0c-bd8c-3e7309337c56.xls
                                APPENDIX 3



Sales Tax Rate Chart
The following chart lists the total sales and use tax rate for each county.

 COUNTY STATE TAX                 COUNTY TAX            STADIUM TAX
NAME AND  RATE                       RATE &                RATE &
  CODE                             EFFECTIVE           EFFECTIVE DATE
                                      DATE
Adams (1)             5%          0.50% -- 1/1/94
Ashland (2)           5%          0.50% -- 4/1/88
Barron (3)            5%          0.50% -- 4/1/86
Bayfield (4)          5%          0.50% -- 4/1/91
Brown (5)             5%                                  0.50% -- 11/1/00
Buffalo (6)           5%           0.50% -- 4/1/87
Burnett (7)           5%           0.50% -- 4/1/89
Calumet (8)           5%
Chippewa (9)          5%           0.50% -- 4/1/91
Clark (10)            5%
Columbia              5%           0.50% -- 4/1/89
(11)
Crawford (12)         5%           0.50% -- 4/1/91

Dane (13)             5%           0.50% -- 4/1/91
Dodge (14)            5%           0.50% -- 4/1/94
Door (15)             5%           0.50% -- 4/1/88
Douglas (16)          5%           0.50% -- 4/1/91
Dunn (17)             5%           0.50% -- 4/1/86
Eau Claire            5%           0.50% -- 1/1/99
(18)
Florence (19)         5%           0.50% -- 7/1/06
Fond du Lac           5%
(20)
Forest (21)           5%           0.50% -- 4/1/95
Grant (22)            5%           0.50% -- 4/1/02
Green (23)            5%           0.50% -- 1/1/03
Green Lake            5%           0.50% -- 7/1/99
(24)
Iowa (25)             5%           0.50% -- 4/1/87
Iron (26)        5%   0.50% -- 4/1/91
Jackson (27)     5%   0.50% -- 4/1/87
Jefferson (28)   5%   0.50% -- 4/1/91
Juneau (29)      5%   0.50% -- 4/1/92
Kenosha (30)     5%   0.50% -- 4/1/91
Kewaunee         5%
(31)
La Crosse        5%   0.50% -- 4/1/90
(32)
Lafayette (33)   5%   0.50% -- 4/1/01

Langlade (34)    5%   0.50% -- 4/1/88

Lincoln (35)     5%   0.50% -- 4/1/87
Manitowoc        5%
(36)
Marathon         5%   0.50% -- 4/1/87
(37)
Marinette        5%   0.50% -- 10/1/01
(38)
Marquette        5%   0.50% -- 4/1/89
(39)
Menominee        5%
(72)
Milwaukee        5%   0.50% -- 4/1/91    0.10% --1/1/96
(40)
Monroe (41)      5%   0.50% -- 4/1/90
Oconto (42)      5%   0.50% -- 7/1/94
Oneida (43)      5%   0.50% -- 4/1/87
Outagamie        5%
(44)
Ozaukee (45)     5%   0.50% -- 4/1/91    0.10% --1/1/96
Pepin (46)       5%   0.50% -- 4/1/91
Pierce (47)      5%   0.50% -- 4/1/88
Polk (48)        5%   0.50% -- 4/1/88
Portage (49)     5%   0.50% -- 4/1/89
Price (50)       5%   0.50% -- 1/1/93
Racine (51)      5%                      0.10% --1/1/96
Richland (52)    5%   0.50% -- 4/1/89
Rock (53)        5%   0.50% -- 4/1/07
Rusk (54)        5%   0.50% -- 4/1/87
St. Croix (55)   5%   0.50% -- 4/1/87

Sauk (56)        5%   0.50% -- 4/1/92
Sawyer (57)      5%   0.50% -- 4/1/87
Shawano (58)     5%   0.50% -- 4/1/90

Sheboygan        5%
(59)
Taylor (60)      5%    0.50% -- 7/1/99
Trempealeau      5%   0.50% -- 10/1/95
(61)
Vernon (62)      5%   0.50% -- 1/1/97
Vilas (63)       5%   0.50% -- 4/1/88
Walworth         5%   0.50% -- 4/1/87
(64)
Washburn         5%   0.50% -- 4/1/91
(65)
Washington       5%   0.50% -- 1/1/99    0.10% -- 1/1/96
(66)
Waukesha         5%                      0.10% -- 1/1/96
(67)
Waupaca (68)     5%   0.50% -- 4/1/89

Waushara         5%   0.50% -- 4/1/90
(69)
Winnebago        5%
(70)
Wood (71)        5%   0.50% -- 1/1/04
TOTAL




5.50%
5.50%
5.50%
5.50%
5.50%
5.50%
5.50%
 5%
5.50%
 5%
5.50%

5.50%

5.50%
5.50%
5.50%
5.50%
5.50%
5.50%

5.50%
 5%

5.50%
5.50%
5.50%
5.50%

5.50%
5.50%
5.50%
5.50%
5.50%
5.50%
 5%

5.50%

5.50%

5.50%

5.50%
 5%

5.50%

5.50%

5.50%

 5%

5.60%

5.50%
5.50%
5.50%
 5%

5.60%
5.50%
5.50%
5.50%
5.50%
5.50%
5.10%
5.50%
5.50%
5.50%
5.50%

5.50%
5.50%
5.50%

 5%

5.50%
5.50%

5.50%
5.50%
5.50%

5.50%

5.60%

5.10%

5.50%

5.50%

 5%

5.50%
Trustees of the University of Pennsylvania                                                                                APPENDIX 4
New Product/Service Notification Worksheet

Department:
Month/Year:


                              Introduction
   New Product or Service          Date                                 Description                                Possible Customers




                            Please submit this form within 2 weeks of introduction of new product or service to: Corporate Tax Office
                                                                                                                 3451 Walnut Street
                                                                                                                 Room 329 Franklin Building
                                                                                                                 Philadelphia, PA 19104-6284

				
DOCUMENT INFO
Description: Cash Register Receipts + Wisconsin Taxes document sample