Deferred Revenue Jet Upload Template (not used between July 3rd through January 30th)

This template is used to move revenue to the new fiscal year for receipts received in the current fiscal year which relate to activities and services performed in future fiscal years or for products to be delivered in the new fiscal year, or to correct revenue transfers accidentally sent to the future fiscal year which relates to current year activities and services rendered. This upload form is available for use between February 1 and June 30.

Download Deferred Revenue Jet Upload Template Form (Excel)

Note: There are many versions of Excel on campus. The forms have been developed to print on one page. If you are having problems printing, on the Excel toolbar, select File, then Page Set Up. This will open a dialog box for you to select “Fit to 1 page.” If this solution does not work, please contact your IT support person for further assistance.


Template Instructions

The Deferred Revenue Jet Template documents and performs the following functions:

  • To move revenue to the new fiscal year for receipts received in the current fiscal year which relate to activities and services performed in future fiscal years or for products to be delivered in the new fiscal year.
  • To correct revenue transfers accidently sent to the future fiscal year which relates to current year activities and services rendered.

This upload is available between February 1 through June 30.

Examples of deferred revenue

  • Receipts received on or before June 30th for fall conferences.
  • Summer session tuition.
  • Prepayment for services and/or activities to be performed in a future fiscal year.
  • Down payments to be returned in a future fiscal year.

Things to remember

  • Enter each deferred revenue line based on what county tax code is to be used. Leave the county tax code field blank if the deferred revenue line is not subject to sales tax.
  • Preparer, supervisor and Dean’s Office contact names are required to be entered on the top of the Jet template.
  • Attach supporting documentation to each transaction.
  • Include on the Jet template the following (when applicable):
    • For distributing from a pooled revenue account, the journal ID and bank deposit date related to the original deposit receipt.
    • For a correction, the original journal ID.

Completing the Deferred Revenue Jet Upload Template

Preparer: (required) Enter preparer’s name and date.
Department Supervisor: (required) Enter department supervisor’s name and date.
Dean’s Office: (required) Enter Dean’s Office contact’s name and date.
 Transfer From: Funding, Amount, and Description Fields: Coding
Def. Rev. “D”: (if applicable)
  • Leave blank if it is deferred revenue transfer;
  • Enter “D” if it is a correction to move the revenue back to current year from future year.
Department: (required) Enter 6-digit Division/Department ID.
Fund: (required) Enter 3-digit Fund ID.
Program: (required) Enter 1-digit Activity Code such as 0,1,2,3,4,6,8,9,F,R.
Project: Enter 7-digit Project ID.
Act ID: Leave blank.
Account: (required) Enter 4-digit SFS Account Code (should be numeric numbers), 9XXX.
Tax Code:
  • Leave blank if it is deferred revenue transfer;
  • Leave blank if it is a correction to move nontaxable revenue back to current year from future year;
  • Enter a count tax code TXXX if it is a correction to move the taxable revenue back to current year from future year.
Amount:
  • Enter a positive amount (debit) for each revenue line being moved to future year;
  • Enter a negative amount (credit) if it is a correction to move the revenue back to current year from future year.
Description (30): (required) Enter the description of the original transaction being moved (max 30 alpha numeric characters).
Bank Deposit Date –
mm/dd/yyyy (10):
Enter the bank deposit date. This is the date US Bank received the receipts. (max 10 alpha numeric characters).
Journal ID (10): When applicable, enter the journal ID of the original transaction being moved (max 10 alpha numeric characters).
Check No. (10): When applicable, enter check number, starts with CKxxx (max 10 alpha numeric characters).
Invoice No. (12): When applicable, enter the invoice number related to this transfer (max 12 alpha numeric characters).
 Transfer To: Funding, Amount, and Description Fields: Coding
Def. Rev. “D”:
  • Enter “D” if revenue is to be moved to future year;
  • Leave blank if it is a correction to move the revenue back to current year from future year.
Department: (required) Enter 6-digit Division/Department ID.
Fund: (required) Enter 3 digit Fund ID.
Program: (required) Enter 1-digit Program Code such as 0,1,2,3,4,6,8,9,F,R.
Project: Enter 7-digit Project code.
Act ID: Leave blank
Account: (required) Enter 4-digit SFS account code (should be numeric numbers), 9XXX.
Tax Code
  • Leave blank if the deferred revenue is not subject to sales tax;
  • Leave blank if it is a correction to move the revenue back to current year;
  • Enter a county tax code TXXX if the deferred revenue is sales tax reportable. Choose the county tax code TXXX related to the county where services occur.
Amount:
  • Enter a negative amount (credit) for the revenue that needs to be moved to future year;
  • Enter a positive amount if it is a correction to move the revenue back to current year from future year.
Description (30): (required) Enter the description of the original entry being moved or provide a brief description which will help you identify this transfer (max 30 alpha numeric characters).
Bank Deposit Date –
mm/dd/yyyy (10):
Enter the bank deposit date. This is the date US Bank received the receipts. (Max 10 alpha numeric characters).
Journal ID (10): When applicable, enter the bank deposit account number when the receipt was originally deposited into or journal ID related to this transaction (max 10 alpha numeric characters).
Check No. (10): When applicable, enter the check number starts with CKxxxx. (max 10 alpha numeric characters).
Invoice No. (12): When applicable, enter the invoice No. related to this transfer (max 12 alpha numeric characters).
Total Leave as is; the cell will be automatically added up based on all amounts entered under “Amount”. The “Total” must equal to zero.

Preparer’s, Department supervisor’s and Dean’s Office’s names are required on the top of the Deferred Revenue Jet Upload Template.

How to submit the template

Please email all the supporting documents and the Deferred Revenue Jet Upload Template to Cash Management at Cashmgt@bussvc.wisc.edu, and CC your supervisor and your Dean’s Office contact person. Please do not send forms directly to staff for processing.

Questions regarding this should be directed to Cashmgt@bussvc.wisc.edu.

 

Direct Payment Form

Use this form to create a Direct Payment (DP) to individual non-employees who are vendors, companies (including LLCs), institutions, and organizations that provide an invoice.

Use this form to create a Direct Payment (DP) to individual non-employees who are vendors, companies (including LLCs), institutions, and organizations that provide an invoice.


When to use the Direct Payment (DP) Form

Use the Direct Payment (DP) form to make payments when an invoice is provided by the following:

  • Individual non-employee
  • Company (including LLCs)
  • Institution (Do not use the DP form to pay UW-Madison departments or other UW campuses.)
  • Organization

The following criteria must be followed:

  • Submit only one invoice per DP form.
  • Best judgment purchases ($5,000 or less) must comply with the University of Wisconsin-Madison’s purchasing policies and procedures, accounting policies and procedures, and with extramural funding agency restrictions.
  • UW-Madison requires that a completed and signed form W-9 (or W-8BEN-E for Foreign Businesses) be on file in Disbursements for all payments requested on Direct Payments (DP).
  • Non-U.S. Source Income payments are exempt from tax withholding and reporting.  For details on what constitutes Non-U.S. Source Income payments please refer to Federal Tax Withholding under the section on Non-U.S. Source Income. A W-8BEN or W-8BEN-E still must be on file in Disbursements.
  • Additional SFS Account code information is available on our Codes guide.

When not to use the Direct Payment Form

  • Payments to individual non-employees for services, payments to human research subjects and payments on entertainment contracts must be done on the Payment to Individual Report (PIR).
  • Reimbursement for travel and expenses to individuals (employees and non-employees) must be done through e-Reimbursement.
  • Use Purchasing Card guidelines for acceptable and non-acceptable purchases..

ShopUW+ Direct Payment Form Instructions

This form is not to be used to pay UW Students, UW Employees, or Refunds.

Auto-Reject: Please note that this form will auto-reject if you are requesting a DP greater than $5,000 AND you select “Other” as the category for this purchase on the “Questions” tab. You will need to use a Purchase Order – please complete a purchase requisition or use the Non-Conforming PO form (if you have already made a purchase) to have your payment processed – please read the instructions on the Non-Conforming PO form for more information.

Complete all required fields (will be indicated by an asterisk *) and attach the appropriate documentation (invoice, relevant contracts, application forms, registration forms, other supporting documentation, wire transfer form) necessary to process the payment request. DO NOT ATTACH W-8 OR W-9 WITH SOCIAL SECURITY NUMBERS TO THIS FORM. 

Supplier Instructions: If you need to update a supplier currently in ShopUW+ or create a new supplier, you will need to follow the supplier request process for your campus. Please consult the business services website for your campus for further instruction.

Access Direct Payment Form in ShopUW+

Contact

Questions regarding this form should be directed to uwsaproblemsolvers@uwsa.edu

Finding the Direct Payments Form in ShopUW+

  1. After you Login, Click on “Shop” on the left-hand side.
  2. Next, click on “Shopping” in the fly-out menu
  3. Click “View Favorites”. You will see all the forms you have access to in ShopUW+. If you need access to a form that is not listed please contact, uwsaproblemsolvers@uwsa.edu

Screenshot of ShopUW+ Forms

Deferred Revenue – Future Year Revenue

This form is used to account for revenues in the new fiscal year for receipts received in the current fiscal year when the activities and services are to be performed in the new fiscal year or products are to be delivered in the new fiscal year. Deferred revenue accounting relates to revenue received from external parties’ only; not between UW-Madison Divisions or other University of Wisconsin campuses. Examples include revenue received on or before June 30 for fall conferences, summer session tuition, tickets sales for a future fiscal year, prepayments for products yet to be delivered as of June 30, prepayment for services to be performed in a future fiscal year and down payments to be returned in a future fiscal year. This form is available for use between February 1 and June 30. Please do not use this form for new fiscal year receipts or internal billings.

This form is used to account for revenues in the new fiscal year for receipts received in the current fiscal year when the activities and services are to be performed in the new fiscal year or products are to be delivered in the new fiscal year.


Download Receipt Sales Credit Transfer Form – Future Year (Excel)

Do not use July 3 through January 31.

Form instructions

(Last updated April 10, 2015)

This form is available between February 1 and June 30. The form is used for recording current year revenue received related to future year activity. This form is used for revenue activity related to external customers.

This form is not used for internal billing between UW–Madison Divisions or activity between University of Wisconsin campuses. See Inter Departmental Billing Form.

This form documents and performs the following functions:

  • To account for revenue in the new fiscal year for receipts received in the current fiscal year related to activities and services performed or for products to be delivered in the next fiscal year.
  • To correct revenue transfers recorded in the new fiscal year related to current year activities and services rendered or products delivered.

By or before July 2nd, 2021, all deferred revenue forms must report receipts collected in fiscal year 2021 for fiscal year 2022 activity. These forms must be delivered to Cash Management at Suite 5301, 21 N. Park St. on or before July 2nd, 2021 along with review and approval from the Department and Deans Office and supporting documentation. See deadline dates.

Examples:

  • Receipts received on or before June 30th for fall conferences.
  • Tickets sales received in current fiscal year for a future fiscal year event.
  • Summer session tuition.
  • Prepayments for products yet to be delivered as of June 30.
  • Prepayment for services and/or activities to be performed in a future fiscal year.
  • Down payments to be returned in a future fiscal year.

Remember:

  • Enter each deferred revenue line based on what county tax code is to be used. Leave the county code field blank if the deferred revenue line is not subject to sales tax.
  • Attach supporting documentation to each form.
  • Department and Deans Office signature.
  • Include on form the following (when applicable):
    • For distributing from a pooled revenue account, the journal ID and bank date related to the original deposit.
    • For a correction, the original journal ID.

Note: After completing each field of information, use the key to move to the next field of information.

Completing the Deferred Revenue – Future Year Revenue Form
Contact information (person completing form)
Prepared By: Enter full name of person preparing form.
Department Name: Enter full name of the Department preparing documentation and approving the form.
Dept ID: Enter 6-digit Department ID code.
Date Prepared: Enter date the form is completed (mm/dd/yyyy).
Phone: Enter the preparer’s telephone number (xxx) xxx-xxxx.
E-mail: Enter the preparer’s e-mail address.
Fiscal Year: Enter the new fiscal year.
Reason for the transfer: Enter reason why the revenue is to be moved to the future fiscal year or why revenue is being moved from future fiscal year back to current fiscal year.
 Transfer from: Funding, Amount, and Description Fields: Coding
Def. Rev. “D”:
(if applicable)
Leave blank or enter “D” only if the revenue is being moved from future fiscal year back to current fiscal year.
Dept. Enter 6-digit Division/Department ID.
Fund: Enter 3-digit Fund ID.
Prog: Enter 1-digit Activity Code such as 0,1,2,3,4,6,8,9,F,R.
Project: Enter 7-digit Project ID.
Act ID: Leave blank
Account: Enter 4-digit SFS account code (numeric numbers starting with 9).
Tax Code Leave as is; the cell will be automatically filled if county tax code name is selected.
County Tax Code Name: Select county tax code name from drop down menu only if the revenue is subject to sales tax and it is being moved back from future fiscal year to the current fiscal year.
Amount: Enter a positive amount (debit) for each revenue line being moved.
Description(30): Enter the description of the original transaction being moved (max 30 alpha numeric characters).   .
Bank Deposit Date
mm/dd/yyyy (10):
Enter the bank deposit date from WISDM under Jrnl Line Ref field. This is the date US Bank received the receipts. (max 10 alpha numeric characters).
Journal ID: Enter the Journal ID of the original transaction being moved (max 10 alpha numeric characters).
Reference No.(10): When applicable, enter internal reference numbers relating to this transaction (max 10 alpha numeric characters).
Invoice No. (12): When applicable, enter the invoice number related to this transfer (max 12 alpha numeric characters).
Total Deposit: Leave as is; the cell will be automatically filled based on amounts entered above.
 Transfer to: Funding, Amount, and Description Fields: Coding
Def. Rev. “D”: Enter “D” if revenue is to be moved to future year.
Dept: Enter 6-digit Division/Department ID.
Fund: Enter 3 digit Fund ID.
Prog: Enter 1-digit Program Code such as 0,1,2,3,4,6,8,9,F,R.
Project: Enter 7-digit Project code.
Act ID: Leave blank
Account: Enter 4-digit SFS account code (should be numeric numbers), 9XXX.
Tax Code Leave as is; the cell will be automatically filled if county tax code name is selected
County Tax Code Name: Leave blank if the deferred revenue is not subject to sales tax. If deferred revenue is subject to sales tax, use drop down menu to select the county’s name where services occur or products were shipped.
Amount: Enter a negative amount (credit) for each transaction line being moved.
Description (30): Enter the description of the original entry being moved or provide a brief describe which will help you identify this transfer (max 30 alpha numeric characters).
Bank Deposit Date:
mm/dd/yyyy (10):
Enter the bank deposit date from WISDM under Jrnl Line Ref field. This is the date US Bank received the receipts. (max 10 alpha numeric characters).
Journal ID (10): Enter the Journal ID of the original transaction being moved (max 10 alpha numeric characters).
Reference No.(10): When applicable, enter internal reference numbers relating to this transaction (max 10 alpha numeric characters).
Invoice No. (12): When applicable, enter the invoice number related to this transaction (max 12 alpha numeric characters).
Total Transfer Leave as is; the cell will be automatically filled based on amounts entered above.
Total per Column Leave as is; the cell will be automatically total based on all amounts entered under “Gross Revenue”. The “Total per Column” must equal to zero.

Please keep a copy of this form and the supporting documentation in your office. Send originals to Cash Management by one of the following methods:

E-mail with signature to Cash Management at Cashmgt@bussvc.wisc.edu.

Mail with signature to 21 N. Park St., Suite 5301, Madison, WI  53715

Please do not send forms direct to staff for processing.

Questions regarding this form should be directed to Cash Management at Cashmgt@bussvc.wisc.edu.

 

Note: There are many versions of Excel on campus. The forms have been developed to print on one page. If you are having problems printing, on the Excel toolbar, select File, then Page Set Up. This will open a dialog box for you to select “Fit to 1 page.” If this solution does not work, please contact your IT support person for further assistance.

Calculating Gross Sales based on Net Sale Information Net Sale Results
Known:
Amount of Net Sale Unknown:
Amount of Gross Sale (Use for Dane County and all other counties, except for Sales Tax Exception A, B, & C below)
Calc for Gross Sale
(Net Sale x 1.055)
Gross Sale
Sales Tax “Exception A” Calculation Net Sale Results
Known:
Amount of Net Sale Unknown:
Amount of the Gross Sale (Use for Milwaukee, Ozaukee, and Washington Counties)
Calc for Gross Sale
(Net Sales x 1.060)
Gross Sale
Sales Tax “Exception B” Calculation Net Sale Results
Known:
Amount of Net Sale Unknown:
Amount of Gross Sale (Use for Racine and Waukesha Counties)
Calc for Gross Sale
(Net Sales x 1.051)
Gross Sale
Sales Tax “Exception C” Calculation Net Sale Results
Known:
Amount of Net Sale Unknown:
Amount of Gross Sale (Use for Calumet, Kewaunee, Manitowoc, Menominee, Outagamie, Sheboygan and Winnebago Counties)
Calc for Gross Sale
(Net Sales x 1.050)
Gross Sale

Cost Transfer Request (Non-Salary) Form

Use this form to transfer a previous payment from an incorrect funding source or department to another. Paper forms will be phased out in early May 2011. Use the Cost Transfer Workflow Tool instead. The tool is a web-based form and routing system that will be used to process both non-salary and salary cost transfers.

Use this form to transfer a previous payment from an incorrect funding source or department to another.


Download Cost Transfer Request (Non-Salary) Form (xls)

Cost Transfer Request (Non Salary) Instructions

  1. Complete appropriate sections of the form, including the original voucher number, appropriate accounting data, reason for transfer, and appropriate approvals.
  2. Submit form per instructions at bottom of form.

Cost Transfer Request (Non Salary) (FY8): redesign of the old Non Salary Payment Transfer

Non Salary Payment Transfer Form (FY7)

Collections Request Form

Use this form to submit an account to a Collection Agency.

Use this form to submit an account to a Collection Agency.


Download Collections Request (doc)

Instructions

  1. Complete appropriate sections of the form, including deposit coding and expenditure coding.
  2. Submit form with two copies of the original invoice and two copies of any follow-up correspondence and route to the address at the bottom of form.

Questions regarding this form should be directed to Janet Hamm.

Claim Unidentified Deposits Form

This form is used for claiming or excepting funds on the Unidentified Deposit List. Email it as an attached excel form to Cash Management along with supporting documents.

Use this form for claiming or excepting funds on the Unidentified Deposit List.


Instructions on how to claim unidentified deposits

  1. Review the Unidentified Deposit List.
  2. Identify receipt belonging to your department/division.
  3. Claim the receipt by completing the Unidentified Deposits: Jet Upload Form (Excel) along with submitting supporting documentation to claim the receipt. See steps 4 through 6 below.
  4. Complete the Unidentified Deposit Jet Upload Form using the Unidentified Deposit List Check issuer’s name and Wire/ACH Originator’s Name, Bank Deposit Date, PO No., Check No. (if applicable), Invoice No., and Journal ID.
    • For each receipt claimed, include the department ID (required), fund (required), program code (required), project (if applicable), account (required), tax code (if applicable), amount, PO number (if applicable) and invoice number (if applicable).
    • On the bottom of the form, enter your name, department name, 6 digit Department ID, phone number, and email.
    • Check reason for receiving funds by checking the type of receipts/processes which apply these checks, wires and/or ACH deposits.
  5. Provide supporting documents to claim the receipt. See examples below:
    • Receipt for accounts receivable invoice – copy of invoice(s).
    • Receipt for services/products – information on the type of services/products provided and copy of sales receipt (if available).
    • Receipt of fees – information on the type of fee and copy of sales receipt (if available).
    • Receipt for down payment – information on type of down payment and copy of sales receipt (if available).
    • Receipt for tuition – information on type of tuition and a copy of the tuition invoice(s).
    • Receipt of sponsored project/program – correspondence requesting receipt and/or agreement(s) with the sponsors.
    • Vender Refund related – copy of expenditure transaction in WISER and if applicable the accounts payable voucher and check number.
    • Purchase Order related – copy of purchase order funding in WISER.
    • Purchasing Card related – copy of purchasing card transaction in WISER.
    • Travel Reimbursement – copy of travel expense funding in WISER.
  6. Send email to Cash Management and CC your Dean’s Office contact along with attaching the Unidentified Deposit Jet Upload Form as an excel file and the supporting documentation.
  7. Please contact Cash Management if you have any questions.

Note: Your Dean’s Office/Division Office and Cash Management reserves the right to review and approve your requests to claim this money.

Bank Account Website Access

Used by Dean's Office/Departments/PI's having Custodian Fund or Contingent bank accounts. This website will give the capability of balance inquiry, stop payments, and monthly bank statements.

Dean’s Office/Departments/PI’s having Custodian Fund or Contingent bank accounts complete this form to have access to their bank account website. The bank account site will give the capability of balance inquiry, stop payments, and monthly bank statements.


Download Bank Account Website Access (Excel Doc)

Send signed, electronic copies to cashmgt@bussvc.wisc.edu.

Send any reactivation and password request to cashmgt@bussvc.wisc.edu.

Accounts Receivable Invoice Form

This form is used when campus departments need to bill an entity outside of the University for services or product.

This form is used when campus departments need to bill an entity outside of the University for services or product.


Download Accounts Receivable Invoice Form (Excel)

Form instructions

Based on the State statutes, all accounts receivable receipts received from customers belong to the University of Wisconsin-Madison. These payments may not be deposited with the University of Wisconsin Foundation or to an individual’s private bank account. It may not be deposited directly into the University’s imprest accounts, including petty cash accounts and Custodian Fund checking accounts; nor may it be used to make direct purchases of supplies. State statutes require receipts to be deposited at least once a week into a UW-Madison deposit bank account only.

If your Department has adequate separation of duties between the staff person entering accounts receivable payments and the staff person making the deposits, then please check with your Dean’s/Divisional Office for approval to collect receipts direct from your customers and to make your own deposits. Remember to make all deposits daily or at least once a week. Once approved by your Dean’s Office, follow the procedures at UW-3029 Revenue Accounting under “How can I set up a deposit procedure for our department?” (Section III).

If your Department is considering using Accounting Services as the collection point for your customer invoice deposits, please follow the procedure below:

  • Review options with your Dean’s/Divisional Office and Cash Management before using Cash Management as a collection point for your customer Accounts Receivable invoices.
  • Make sure your Dean’s/Divisional Office and Cash Management have approved your department for using Cash Management as a collection point for your customer Accounts Receivable invoices.
  • Make sure your customers send their payments directly to Cash Management, Suite 5301, 21 N. Park Street for deposit.
  • Use the Cash Management Accounts Receivable Invoice template and make sure Cash Management approves your final design and coding structure.

Things to remember

  • Check with your Dean’s/Divisional Office and Department to receive information on internal policies and procedures related to revenue collections.
  • Your Department is responsible for follow-up and collection on all unpaid invoices from your customers.
  • Request payments to be submitted in US dollars (foreign currency payments are not accepted).
  • If using Cash Management as the collection point for your customer payments, please make sure the customer sends the payment directly to Cash Management at 21 N. Park Street, Suite 5301. If customer sends payments back to your address, then either request a Bank Deposit Slip Order Form from Cash Management to make your own bank deposits or submit checks on a Receipt/Sales Credit Transfer Form.
  • If your customers would like to pay online, please see UW-Madison CASHNet to set up a web application.
  • If your customer is asking to make payments by Wire/ACH, instruct them to include your Department ID and Invoice number in the Wire/ACH reference/memo field (field is 25 characters long). See “Incoming Wire Form” for instructions on notifying Cash Management and requesting bank information. Use the memo field on the bottom of the incoming wire form to request bank information for routing and bank account number to inform your customer where to send payments electronically. Please do not put this information on the invoice.
  • Any revenue deposits involving Funds 133, 144, or 182, which do not use account code 9050, 9051, 9060, 9061, and 9062, please submitted to Research and Sponsored Programs at 21 N. Park Street, Suite 6401, Madison, WI  53715.
  • Any revenue deposits involving Funds 233 which do not use account code 9050, 9051, 9060, 9061, and 9062, please submit to Accounting Services at 21 N. Park Street, Suite 5301, Madison, WI 53715.
  • All deposits using account code 9050 through 9062 require a program code being either 0,1,2,3,4,6,8,9,F and cannot be a program code R.
  • All deposits involving Fund 161 require detail backup and must be submitted directly to University of Wisconsin System Trust Funds, 780 Regent Street, Madison, WI 53715; ATTN Trust Funds.

Note: After completing each field of information, use the tab key to move to the next field of information.

Setting up the Accounts Receivable Invoice Form

Contact Information (person completing form)
Letter Head Use the UW-Madison approved logo.  Header of all accounts receivable invoices would say “University of Wisconsin – Madison”
Department Information: Enter your Department Name and address.
Dept ID: Enter 6-digit Department ID.
Invoice No: Enter invoice number up to 12 digits long.
Date: Enter date the invoice is prepared.
Bill to: Enter the complete Customer Address. This area can be moved on the form to either the right or left side so it can easily be fitted into a window envelop.
Ship to: Include this section on invoice only if the ship to address will be different than the bill to address.
Work Order No: Keep on form only if you use this field.
Ship Date: Keep on form only if you ship product to your customer.
Description: Describe products and/or services being billed.
Quantity: Keep on form only if products and/or services are sold in quantity.
Rate: Keep on form only if products and/or services are charged by standard rate times the quantity.
Amount: Will auto fill if both quantity and rate column are used. Otherwise, enter amount of each product and/or service being billed.
Invoice Amount before Tax: Leave as is. Amount will auto fill based on amounts entered above.
Tax Due: Leave as is. Amount will auto fill based on financial details submitted in the section called University Use Only.
Total Invoiced: Leave as is. Amount will auto fill based on Invoice amount before tax plus tax due.
Department Contact: Enter department contact name.
Department Phone No: Enter the department’s contact 10-digit phone number.
Department e-mail: Enter the department’s contact e-mail address.
Tax Due: Leave as is. Amount will auto fill based on financial details submitted in the section called University Use Only.
Total Invoiced: Leave as is. Amount will auto fill based on invoice amount plus tax due.

University use only

Dept: Enter 6-digit Department ID.
Fund: Enter 3-digit Fund ID.
Prog: Enter 1-digit program code such as 0,1,2,3,4,6,8,9,F,R.
Project: If applicable, enter 7-digit Project ID.
Act ID: Leave blank
Account: Enter 4-digit SFS account code.
Tax Code: Leave as is. Amount will auto fill based on selection made in the “County Tax Code Name” column.
County Tax Code Name: If sales tax applies to sale, pick the county tax name which relates to the sale from drop down list.
Total Invoiced: Leave as is. Amount will auto fill.
Invoice Number Leave as is. Amount will auto fill based on “Invoice No” field above.

Please keep a copy of this form in your office and send the original form to the Cash Management, 21 N. Park Street, Suite 5301. Please review WISDM daily to determine if customers have submitted payment.  Payments will be posted to WISDM using financial coding provided on invoice, invoice number will be in the description field and the check number will be in the reference field. Accounting Services will return paid invoices by campus mail to those who have submitted invoice forms to Accounting Services before receipt of customer payments.

Questions regarding this form should be directed to Cash Management.

Note: There are many versions of Excel on campus. The forms have been developed to print on one page. If you are having problems printing, on the Excel toolbar, select File, then Page Set Up. This will open a dialog box for you to select “Fit to 1 page.” If this solution does not work, please contact your IT support person for further assistance.

Calculating Gross Sales based on Net Sale Information
(Use for Dane County and all other counties, except for Sales Tax Exception A, B, & C below)
Net Sale Results
Known: Amount of Net Sale
Unknown: Amount of Gross Sale
Calc for Gross Sale
(Net Sale X 1.055)
Gross Sale
Sales Tax “Exception A” Calculation
(Use for Milwaukee, Ozaukee, and Washington Counties)
Net Sale Results
Known: Amount of Net Sale
Unknown: Amount of the Gross Sale
Calc for Gross Sale
(Net Sales X 1.060)
Gross Sale
Sales Tax “Exception B” Calculation
(Use for Racine and Waukesha Counties)
Net Sale Results
Known: Amount of Net Sale
Unknown: Amount of Gross Sale
Calc for Gross Sale
(Net Sales X 1.051)
Gross Sale

Sales Tax “Exception C” Calculation
(Use for Calumet, Kewaunee, Manitowoc, Menominee, Outagamie, Sheboygan, and Winnebago Counties)Net SaleResults

Known: Amount of Net Sale
Unknown: Amount of Gross Sale
Calc for Gross Sale
(Net Sales X 1.050)
Gross Sale

Related documents