Chapter 9 DRAFT - Office of the State Auditor
Contents
1. This Page Left Blank Inte ally CTAS User Manual 9 1 Vendors Introduction In the Vendors section you can enter the name and address of vendors you pay on a regular basis Then when entering claims or disbursement transactions you can type the first few letters of the vendor s name and the vendor s full name and address will appear in the appropriate fields In addition by entering vendor information you can print a Federal 1099 Form for selected vendors as well as vendor ledgers and mailing labels Accessing the Vendors Section To access the Vendors section from within the Accounting tab of CTAS click on the Accounting tab and then the Vendors icon The Vendors screen as shown below will 7 appear 1 F 4 gt gt 4 Te gt Accounting Payroll Investments Indebtedness pp Reports Admin Help Exit ae S amp S G28 Receipts Claims Disbursements Budget Cash Chartof Vendors l Accounts i l Vendors l lt 3 45 PM Vendors List Add Vendors l i l t nw I Vendor l V Active Vendors I Search Vendor YH Federal WV Address Lin VW Address Lin VW City ya State Ya ZipCod V ContactNa Y Phone No M W PhoneNo f W Phone NofF WV Email Adde V4 Require 10 V4 Active YH E E Credit Uni 65 There Street l Y a Diamond 569874125 56 Here Avenue Up North I MN 55287 Harvy Harrison 555 555 8974 45 harvy harrison Aj Y a Don s Gar 25 78 There Street Down South MN 23659 Rick James 552. and lt lt buttons allow you to move vendors out of the Selected Vendors box e Check the Form 1099 Only box if you want to display only those vendors that have the Form 1099 Required box checked on their vendor record e Select the Start Date and End Date for the report Manually enter dates or use the drop down arrow for calendar e Click the print Preview button and the print preview Report Viewer screen will appear as shown on the next page Office of the State Auditor CTAS User Manual 9 16 Vendors Printing the Vendor Ledger continued e After reviewing the preview click on the Printer icon to begin the printing of the report You can close the Report Viewer screen by clicking the red K _ aa ag Report Vi er onom O amp Me SF TH eo Fo 4 gt wii Main Report SAP CRYSTAL REPORTS DJ New Township Vendor Ledgers Yendor Name Federal ID Number Form 1099 Required Date 04 30 2014 04 30 2014 07 21 2014 07 21 2014 Yendor Name Federal ID Number Form 1099 Required Date 07 21 2014 07 21 2014 07 21 2014 07 21 2014 07 21 2014 Yendor Name Federal ID Number Form 1099 Required Date 07 21 2014 07 21 2014 07 21 2014 Yendor Nam e Federal ID Number Form 1099 Required Date 02 26 2014 Date Range 01 01 2014 To 08 28 2014 Credit Union Description Plow Truck Payment Plow Truck Payment Plow Truck Payment Plow Truck Payment Report Total Diamond
3. appear as shown on the next page Office of the State Auditor CTAS User Manual 9 12 Vendors Printing the Vendor Federal 1099 MISC Form continued e After reviewing the preview click on the Printer icon to begin the printing of the Office of the State Auditor CTAS User Manual 9 13 Vendors Printing the Vendor Federal 1099 MISC Form continued e After clicking on the Printer icon the Print screen appears Select Printer HP Laserlet PCL6 en PDF Com a 4 Status Ready Location Curent Page 1 2 Grier ihe a single page number or a single page fange For example 5 12 Send To OneNote 2010 By clicking the Pages radio button you can choose to print only certain pages of the report The Number of copies box allows you to enter the number of copies you would like printed After selecting the printer details click on the Print button to begin printing the report The following page has a sample of the report To close the printing of the report e Click the red X icon on the Report Viewer screen e Click the Cancel button on the Vendor Federal 1099 MISC Forms screen Office of the State Auditor CTAS User Manual 9 14 Vendors Printing the Vendor Federal 1099 MISC Form continued Sample Vendors Federal 1099 MISC Form Report Hew Township cee eeee meee eee enmmmeen eee emmenee eee enmemeeeeeeeeneeeeeeeeeeneneeeeeeeeGGaeeeeeeeeeeaeeseeeeeeGeeenseeeeeeeeeseeeeeGeeeeseeeeeeeeeeeeee
4. 1 B 2by7 3by10 Print Preview Cancel On the Vendor Mailing Labels screen Select the vendors whose labels are to be printed by moving their names from the Available Vendors box to the Selected Vendors box The gt gt button will move all vendors and the gt button will move the individually highlighted vendor s You can also select an individual vendor by double clicking on the vendor The lt and lt lt buttons move vendors out of the Selected Vendors box Check the Form 1099 Only box if you want to display only those vendors that have the Form 1099 Required box checked on their vendor record Enter the number of the row where you want the labels to begin to print in the Row field of the Starting Row Column box Enter the number of the column where you want the labels to begin to print in the Column field of the Starting Row Column box Click the Label Format radio button that matches the format of your labels Click the print Preview button and the print preview Report Viewer screen will appear as shown on the next page Office of the State Auditor CTAS User Manual 9 24 Vendors Printing the Vendor Mailing Labels continued e After reviewing the preview click on the Printer icon to begin the printing of the SAP CRYSTAL REPORTS 2008 WATERMAIN PROJ DEBT SERV 2008 WATERMAIN PROJ DEBT SERV ACCT 555 555 ACCT 555 555 A H HERMEL COMPANY POBOX555 MANKATO MN 55555 5555 A
5. Here Avenue Up North MN 55267 Form1099 Required Yes Contact Hary Harison Fax Phone 555 555 8974 45 Email hans harri s on email com Don s Garbage and Pest Control Federal ID Number 25 Yo There Street Down South MN 25659 Contact Rick Jarnes Phone 555 555 9574 Email rick james yahoo com FormLo99 Required Yes Fae Northern Tool 65 Dare Deil Road Closeby MN 45874 Federal ID Mumber Form1099 Required No Contact Fae Phone Email Post Master Federal ID Mumber 25 Main Form1099 Required No Here MN 55554 Contact Phone Office of the State Auditor Fae CTAS User Manual 9 23 Vendors Printing the Vendor Mailing Labels The Vendor Mailing Labels allow you to print mailing labels for selected vendors on pages with either 14 or 30 labels per page The Mailing Labels selection allows you to use partial pages of labels by selecting the starting row and column To print the Vendor Mailing Labels click on the Reports tab in the Task Bar and then the Vendors icon see page 9 10 for illustration Highlight Vendor Mailing Labels and click the Run button The Vendor Mailing Labels screen will appear Vendor Mailing Labels Available Vendors Selected Vendors Credit Union Diamond Asphalt and Plowing Don s Garbage and Pest Control Northem Tool Post Master Telephone Company WE Energies Form 1099 Only Starting Label Row Column Label Format 1 E Column
6. Todelete a vendor s information highlight the vendor s name on the Vendors List tab and click the Delete button e After the delete option is selected the Confirm Vendor Delete screen appears see below left e Click on the Yes button to delete the vendor s information e You will then receive a screen message see below right that indicates the information was deleted Click the OK button to complete the process Office of the State Auditor CTAS User Manual 9 7 Vendors Using the Search Feature In the Vendors screen there are two search options to search for vendors The first option is to search inactive vendors The default search in CTAS 1s by active vendors to search by inactive vendors see next page 6 eee CTAS ee Sl 7 A E _X_ Accounting Payroll Investments Indebtedness Reports Admin Help Exit Receipts Claims Disbursements Budget Cash Chartof Vendors Accounts Vendor F R Vendors List Add Vendors i j c Vendor J Active Vendors Search Vendor YH Federal Ya Address Lin VW Address Lin VW City YH State YH ZipCod Y ContactNa VY Phone No M 474 Phone No W Phone No F Y Email Addre 74 Require 10 Active Be p Credit Uni 65 There Street a Diamond 569874125 56 Here Avenue Up North MN 55287 Harvy Harrison 555 555 8974 45 harvy harrison Y af a Don s Gar 25 78here Street Down South MN 23659 Rick James 555 555 9874 rick james yah Y N
7. a Northern 65 Dgre Devil R Closeby MN 45874 N H Y a Post Mast 25 Maik Here MN 55554 Ny Y l Telephon 45 Main Upton MN 55526 W Y WE Ener 652 7th Avanue St Paul MN 55103 Y ha N x 7 AN AS N N A N N 4 DView edt 2 Delete 3 Export to CSV cs A N N 74 To search by active vendor W 4 N N e Enter all or part of the name jn the Vendor field e Click the Search button e Vendors meeting the criteria will be displayed Office of the State Auditor CTAS User Manual 9 8 Vendors Using the Search Feature continued The second option is to search by inactive vendors v an CTAS ee ee Accounting Reports Admin Help Exit Receipts Claims Disbursements Budget Cash Payroll Investments Indebtedness Chartof Vendors Accounts Vendors Vendors List Add Vendors _ sasou Vendor 4 Active Vendors YH Federal Y Address Lin VW Address Lin VW City yr A E F Credit Uni 65 There Street a Diamond 569874125 56 Here Avenue a Don s Gar 25 78 There Street Vendor Ya ZipCod Y ContactNa Y PhoneNo M Y PhoneNo W PhoneNo F Y Email Addre T Require 10 vf 99999 Up North MNI 55287 Y Harvy Harrison 555 555 8974 45
8. information click the Save button Office of the State Auditor CTAS User Manual 9 6 Vendors Deleting a Vendor The need to delete a vendor s information could result from a decision that the information is not needed after it was added or because the vendor s information has accidentally been entered more than once Note You can only delete a vendor s information if it has not been used in any transactions Danet Cm r A agny Accounting Payroll Investments Indebtedness Reports Admin Help Exit Receipts Claims Disbursements Budget Cash Chartof Vendors Accounts v s49 Pm Vendors List Add Vendors Vendor J Active Vendors sh Vendor WH Federal W Address Lin VW Address Lin VW City YH State Ya ZipCod Y ContactNa WR Phone No M Y PhoneNo Y Phone No F VW Email Adde WS Require 10 7 Active YH pa Credit Uni 65 There Street 99999 N Y a Diamond 569874125 56 Here Avenue gt Up North MN 55287 Harvy Harrison 555 555 8974 45 harvy harrison Y v a Don s Gar 25 78 There Street Down South MN 23659 Rick James 555 555 9874 rick james yah_ Y 4a Northern 65 Dare Devil R Closeby MN 45874 N 4a Post Mast 25 Main Here MN 55554 N Y a Telephon 45 Main St an Upton MN 55526 N N H WE Ener 652 7th Avenue q St Paul MN 55103 N Y N N N N N N N N N N Ay N N N D N N e
9. you can choose to print only certain pages of the report The Number of copies box allows you to enter the number of copies you would like printed After selecting the printer details click on the Print button to begin printing the report The following page has a sample of the report To close the printing of the report e Click the red X icon on the Report Viewer screen e Click the Cancel button on the Vendor Ledgers screen Office of the State Auditor CTAS User Manual 9 18 Vendors Printing the Vendor Ledger continued Sample Vendor Ledger Report New Township Vendor Ledgers 08 28 2014 Date Range 01 01 2014 To 08 26 2014 Yendor Name Credit Union Federal ID Hum ber Form 1099 Required Wo Date Description Check Humber Accounthum ber Amount 04 30 2014 Plow Truck Payment 110 201 47120 602 200 00 04 30 2014 Plow Truck Payment 110 201 47 220 612 100 00 07 21 2014 Plow Truck Payment 120 201 47110 601 5900 00 7 21 2014 Plow Truck Payment 120 201 47210 611 100 00 Report Total 1 300 00 Yendor Name Diamond Asphalt and Plowing Federal ID Hum ber 569874125 Form 1099 Required Yes Date Description Check Humber Accounthum ber Amount 07 21 2014 General Pamenta 115 201 45122 401 1 000 00 07 21 2014 General Pamenta 1143 201 43125 401 1 000 00 07 21 2014 General Payments LS 201 43160 381 1 000 00 07 21 2014 General Pamenta 115 201 43121 530 1 000 00 07 21 2014 General Payments 115 201 435121 5
10. 20 1 000 00 Report Total 5 000 00 Yendor Ham e Don s Garbage and Fest Control Federal ID Hum ber 25 Form 1099 Required Yes Date Description Check Humber AccounthNumber Amount 07 21 2014 Garbage and yveeds 114 100 43260 401 300 00 OF 21 7014 Garbage and yveeds 114 100 43230 401 300 00 OF 21 7014 Garbage and vveeds 114 100 435250 510 300 00 Report Total 900 00 Vendor Name Morthern Tool Federal ID Hum ber Form 1099 Required Wo Date Description Check Number AccountNumber Amount 02 26 2014 Sewer Connedion Parts 107 6001 49451 2721 300 00 Report Total 300 00 Office of the State Auditor CTAS User Manual 9 19 Vendors Printing the Vendor List The Vendor List will provide you the information contained in the vendor record for selected vendors The report can be used to review the information on each vendor so the information can be updated as needed Vendor List Available Vendors selected Vendors Diamond Asphalt and Plowing Don s Garbage and Pest Control Northem Tool Post Master Telephone Company WE Energies E Form 1099 Only Print Preview Cancel To print the Vendor List click on the Reports tab in the Task Bar and then the Vendors icon see page 9 10 for illustration Highlight Vendor List and click the Run button The Vendor List screen will appear On the Vendor List screen e Select the vendors whose information is to be printed by moving their names from the Available Vendors
11. 5 555 9874 rick james yah_ Y Y a Northern 65 Dare Devil R Closeby i MN 45874 N Y a Post Mast 25 Main Here I MN 55554 N M a Telephon 45 Main St Upton MN 55526 N a WE Ener 652 7th Avenue St Paul 1 MN 55103 N Y I I I I I I I I I I I I I I I I I I I I I I I I I I I I I I l I I I I I I I A S 1 View Edit 2 Delete 3 Exporttocsv lt z CS l v I I l l I l l l l I I You can View Edit Delete or Export to CSV a vendor from the Vendors List tab In addition by clicking the Reports tab and then the Vendors icon you can print Federal 1099s vendor ledgers a list of vendors or mailing labels Instructions on how to use these buttons can be found later in this chapter Office of the State Auditor CTAS User Manual 9 2 Vendors Adding a New Vendor To begin entering a vendor click on the Add Vendors tab at the top of the Vendors screen o _ 7 u Mme TAS ee ee am Accounting Payroll Investments Indebtedness Reports Adin Help Exit La os Cad Receipts Claims Disbursements Budget Cash Chart of Vendors _feunts Vendors ra 3 45 PM a Vendors List Add Vendors Vendor J Active Vendors Sach Vendor YH Federal VW Address Lin VW Address Lin VW City YH State Ya ZipCod Y ContactNa WH Phone No M Y Phone No YW Phone No F V Email Addre WS Require 10 VY Active YH p Credit Uni 65 There Street 99999 Y a Di
12. Asphalt and Plowing 569874125 Yes Description General Payments General Payments General Payments General Payments General Payments Report Total Don s Garbage and Pest Control 25 Yes Description Garbage and Weeds Garbage and Weeds Garbage and Weeds Report Total Northern Tool No Description Sewer Connedion Parts Report Total Post Master Total Page No 2 Check Number 110 110 120 120 Check Number 113 113 113 Check Number 107 Accou ccountNum ber 201 47120 602 201 47220 612 201 47110 601 201 47210 611 43122 401 201 43125 401 201 43160 381 201 43121 530 201 43121 520 AccountNumber 100 43260 401 100 43230 401 100 43230 510 AccountNumber 601 49451 221 Amount 200 00 100 00 900 00 100 00 1 300 00 Amount 1 000 00 1 000 00 1 000 00 1 000 00 1 000 00 5 000 00 Amount 300 00 300 00 300 00 900 00 Amount 300 00 300 00 Office of the State Auditor CTAS User Manual Vendors Printing the Vendor Ledger continued e After clicking on the Printer icon the Print screen appears m HP a LD aa Microsoft APS Document Writer ES PDF Complete 4 Status Ready Location Comment Fage Range Al Selection Curent Page 0 Pages 1 2 Enter ether a single page number or a single page range For example 5 12 l l l I l l 1 9 17 By clicking the Pages radio b ttton
13. FLAC INS 4 AFLAC INS ATTN REMITTANCE PROCESSING SERVICE ATTN REMITTANCE PROCESSING SERVICE 5555 WYNNTON ROAD 5555 WYNNTON ROAD COLUMBUS GA 55555 5555 COLUMBUS GA 55555 5555 ADVANCED WATER SYSTEMS ADVANCED WATER SYSTEMS 5555 ZENITH AVE 5555 ZENITH AVE _SPIRITLAKE IA 55555 SPIRIT LAKE IA 55555 Zoom Factor 100 Office of the State Auditor CTAS User Manual 9 25 Vendors Printing the Vendor Mailing Labels continued e After clicking on the Printer icon the Print screen appears Microsoft XPS Document Writer ej PDF Complete 4 Status Ready Location l 7 By clicking the Pages radio button you can choose to print only certain pages of the report The Number of copies box allows you to enter the number of copies you would like printed After selecting the printer details click on the Print button to begin printing the report The following page has a sample of the report To close the printing of the report e Click the red X icon on the Report Viewer screen e Click the Cancel button on the Vendor Mailing Labels screen Office of the State Auditor CTAS User Manual 9 26 Vendors Printing the Vendor Mailing Labels continued Sample Vendor Mailing Labels Report Credit Union Diamond Asphalt and Plowing 65 There Street 56 Here Avenue Yonder MN 99999 Up North MN 55287 Don s Garbage and Pest Control Northern Tool 78 There Street 65 Dare Devil Road Down South MH 23659 Close
14. amond 569874125 56 Here Avenue Up North MN 55287 Harvy Harrison 555 555 8974 45 harvy harrison Y Y a Don s Gar 25 78 There Street Down South MN 23659 Rick James 555 555 9874 rick james yah Y 1 a Northern 65 Dare Devil R Closeby MN 45874 N a Post Mast 25 Main Here MN 55554 N Y a Telephon 45 Main St Upton MN 55526 N y a WE Ener 652 7th Avenue St Paul MN 55103 N Dewe 2 Deete zj SD 1 After the Add Vendor tabis selected the Add Vendors screen will appear allowing you to enter the information for thenew vendor An example of the Add Vendors screen is shown on the next page Office of the State Auditor CTAS User Manual 9 3 Vendors Adding a New Vendor continued CTA o j gt ccountn g Payroll Investments Indebtedne Reports Admin Help Exit Receipts Claims Disbursements Budget Cash iari Vendo Vendors Federal ID Number Vendor Name Address Accounts encoceseseese New Vendor J Fom 1099 Required J Active Cancel When the Add Vendors screen appears complete the following steps For vendors that require a 1099 enter their Federal ID Number Enter the name of the vendor in the Vendor Name field Enter the address of the vendor in the Address fields The first two lines are the street address The third line is the city state and zip code Enter the name of the person that is your contact with the vendor in the Contact Na
15. box to the Selected Vendors box The gt gt button will move all vendors and the gt button will move the individually highlighted vendor s You can also select an individual vendor by double clicking on the vendor The lt and lt lt buttons allow you to move vendors out of the Selected Vendors box e Check the Form 1099 Only box if you want to display only those vendors that have the Form 1099 Required box checked on their vendor record e Click the print Preview button and the print preview Report Viewer screen will appear as shown on the next page Office of the State Auditor CTAS User Manual 9 20 Vendors Printing the Vendor List continued e After reviewing the preview click on the Printer icon to begin the printing of the a9 Report Vie er Boc M E o amp BSB e fale gt n New Township Vendor List Credit Union Federal ID Number i 65 There Street Form1099 Required No Yonder MIN99999 i Contact i Phone Email y l Diamond Asphalt and Plowing Federal ID Number 569874125 i 56 Here Avenue Form1099 Required Yes UpNorth MN 55287 Contac Harvy Harrison Main Report Phone 555 555 8974 45 Email harvy harrison gmail com Don s Garbage and Pest Control Federal ID Number 25 78 There Street Form 1099 Required Yes Down South MN 23659 Contac Rick James Phone 555 555 9874 Email rick james yahoo com Northern Tool Federal ID Number 65 Dare Dev
16. by MH 45874 Post Master Telephone Company 25 Main 45 Main St Here MH 55554 Upton MN 55526 WE Energies 652 7th Avenue St Paul MN 55103 Office of the State Auditor
17. eaay Newtown WNS5414 569874125 Diamond Asphalt and Rowing 5 000 00 56 Here Avenue Up North MN 55287 New Township 50 Main Street Newtown WINSS4 14 25 Don s Garbage and Pest Control 900 00 76 There Street Down South MN 25659 Office of the State Auditor CTAS User Manual 9 15 Vendors Printing the Vendor Ledger The Vendor Ledger is designed to provide a list of all disbursements made to selected vendors within a specified time period The report can be used to review the payments to a vendor to find any disbursements that have not been coded correctly To print the Vendor Ledger click on the Reports tab in the Task Bar and then the Vendor icon see page 9 10 for illustration Highlight Vendor Ledgers and click the Run button The Vendor Ledgers screen will appear Vendor Ledgers Available Vendors Selected Vendors Diamond Asphalt and Plowing Don s Garbage and Pest Control Northem Tool Post Master Telephone Company WE Energies Start Date 0v01 2015 End Date 02252015 e E Form 1099 Only Print Preview Cancel On the Vendor Ledgers screen e Select the vendors whose ledgers are to be printed by moving their names from the Available Vendors box to the Selected Vendors box The gt gt button will move all vendors and the gt button will move the individually highlighted vendor s You can also select an individual vendor by double clicking on the vendor The lt
18. harvy harrison Y N Down South MNI 23659 Rick James 555 555 9874 rick james yah Y Y Northern 65 Dare Devil R Closeby MN 45874 Wo Y Post Mast 25 Main Here MN 55554 Ny Y Telephon 45 Main St Upton MN 55526 NZ Y WE Ener 652 7th Avenue St Paul MN 55103 sA Y l 7 l l 7 7 l l l YA l 1 l 4 7 l 7 l 7 1 4 7 l 7 l l 7 l 1 l TA i l 7 I l 1 1 l l 7 l l 7 4 l 1 l l l 1 l 7 i l l 1 l Dweweat Doane 1 4 iy l 7 I 1 l 7 l 7 7 l l 7 I 7 To search by inactive vendor 7 l 7 TA I Uncheck the Active Vendors box e Click the Search button The inactive vendors will then be displayed To narrow the search enter all or part of the name in the Vendor field e Click the Search button Vendors meeting the criteria will be displayed Office of the State Auditor seh Active YH l CTAS User Manual Vendors Printing Reports Introduction 9 9 There are four reports you can create and print from the Vendors icon in the Reports tab They are the Vendor Federal 1099 Forms Vendor Ledgers a Vendor List and Vendor Mailing Labels To select the report you want to create click on Reports tab in the Task Bar and click on the Vendors icon at the top of the screen __ i N q yy A 2 Admin Help Exit rer i tee S Accounting Payroll Investments e en Reports Rece
19. il Road Form1099 Required No Closeby MN 45874 Contact Phone Ernail Post Master Federal ID Number 25 Main Form1099 Required No Here MN 55554 Office of the State Auditor CTAS User Manual Vendors Printing the Vendor List continued e After clicking on the Printer icon the Print screen appears om Microsoft XPS Document Writer f POF Complete 4 Status Ready Location Comment Fage Range Al Selection C Curent Page Pages 1 2 A Enteneither a single page number or a single pagerange For example 5 12 l l l 1 l l 9 21 By clicking the Pages radio button you can choose to print only certain pages of the report The Number of copies box allows you to enter the number of copies you would like printed After selecting the printer details click on the Print button to begin printing the report The following page has a sample of the report To close the printing of the report e Click the red X icon on the Report Viewer screen e Click the Cancel button on the Vendor List screen Office of the State Auditor CTAS User Manual 9 22 Vendors Printing the Vendor List continued Sample Vendor List Report New Township Vendor List 08 28 2014 Credit Union 65 There Street Yonder Wh 99999 Federal ID Murnber Form1099 Required Mo Contact Fax Phone Email Diamond Asphalt and Aowing Federal ID Nurnber 569574125 56
20. ipts Claims Disbursements Budget Cash Chartof Vendors Financial Tax Payroll Year Investments Indebtedness Accounts Reports Filing to Date Accounting Employee Investments _dndebt dness vo y 4 TA Report Name Vendor Federal 1099 MISC Forms Vendor Ledgers Vendor List Vendor Mailing Labels Office of the State Auditor CTAS User Manual 9 10 Vendors Printing Reports Introduction continued A Vendors Reports screen will appear listing the four reports eee eo oe Accounting Investments Ciro Payroll Indebtedness Receipts Claims Disbursements Budget Cash Reports Admin Help Exit a ee tee o Chartof Vendors Financial Tax Payroll Year Investments Indebtedness Accounts Reports Filing to Date Accounting Employee Investments Indebtedness Vonders yan N ai Report Name Vendor Federal 1099 MISC Forms Vendor Ledgers Vendor List Vendor Mailing Labels _ a To run a report highlight the report s name and click the Run button The following pages describe each report and illustrate how to create and print each report Office of the State Auditor CTAS User Manual 9 11 Vendors Printing the Vendor Federal 1099 MISC Form The Vendor Federal 1099 MISC Form report will print the 1099 MISC Form for all vendors selected The forms are the standard two per page a
21. james ya Y a Northern I 65 Dare Devil R Closeby MN 45874 N Y a Post Mast l 25 Main Here MN 55554 N M 4a Telephon l 45 Main St Upton MN 55526 N Y 4a WE Ener l 652 7th Avenue St Paul MN 55103 N Y l l I I I l l I l I I l l I l l l l l I I l I l I l I l Office of the State Auditor CTAS User Manual 9 5 Vendors Changing a Vendor continued After the View Edit button is selected the Update Vendor tab will appear The tab will be titled with its corresponding vendor name p7 CTAS d o h A Accounting Payroll Investments Indebtedness ms Reports Admin Help Exit Receipts Claims Disbursements Budget Cash Chartof yendors Accounts 7 1 LEE Vendors gt 3 48 PM Vendors List Add Vendors Don s Garbage and Pest Control X Federal ID Number 25 Vendor Name Don s Garbage and Pest Control Address 78 There Street Down South MN 23659 Contact Name Rick James Phone 555 555 9874 Ext Fax Email Address fick james yahoo com J Form 1099 Required v Active Save Cancel Eh Ss On the Update Vendor tab you can change any field including the status of the vendor The status of the vendor active or inactive can only be changed when the vendor has not been used in a transaction during the current fiscal year To complete updating a vendor s
22. me field Enter the telephone number for the vendor in the Phone field Enter the contact s telephone extension if appropriate Enter the fax number for the vendor in the Fax field Enter the vendor s e mail in the E mail Address field If the vendor will need a 1099 printed at the end of the year check the Form 1099 Required box Check the Active box You will then be able to select this vendor when entering transactions Click the Save button to add the new vendor Office of the State Auditor 3 47 PM 9 4 CTAS User Manual Vendors Changing a Vendor To change a vendor s information ME LA the vendor s name on the Vendors List tab and x eer aa click the View Edit button Py j Pg lt aell eee Investments eee Reports Admin Help Exit 3 47 PM Seda Accounting Disbuysements Budget Cash ae Vendors Accounts Y x semena ive Receipts Claims I I I 7 Vendors I of 7 Vendors List Add Vendgrs l ae Vendor I J 7 V Active Vendors l 1 I 7 Vendor VY Federaj VW Address Lin VW Address Lin VW City YH Sate WH ZipCod V ContactNa Y PhoneNo M Y PhoneNo Y Phone No F WV Email Adde y Require 10 Y Acti Yu Credit Uni l 65 There Street Yonder MN 99999 N Y Diamond 5698741 7 56 Here Avenue Up North MN 55287 Harvy Harrison 555 555 8974 45 harvy harrison Y N E F Don s Gar 25 78 There Street Down South MN 23659 Rick Jame 5 555 9874 rick
23. nd can be purchased at an office supply store Note Only those vendors with the Form 1099 Required box checked in their Vendor screen will be available to select for printing the 1099s To print the Federal 1099 MISCs click on the Reports tab in the Task Bar and then the Vendors icon Next highlight Vendor Federal 1099 MISC Forms and click the Run button The Vendor Federal 1099 MISC Forms screen will appear Vendor Federal 1099 MISC Forms Available Vendors Selected Vendors l Don s Garbage and Pest Control Vertical Adj No adjustment i Tax Year 2 Form 1099 Only Print Preview Cancel On the Vendor Federal 1099 MISC Forms screen Select the vendors whose forms are to be printed by moving their names from the Available Vendors box to the Selected Vendors box The gt gt button will move all vendors and the gt button will move the individually highlighted vendor s You can also select an individual vendor by double clicking on the name The lt and lt lt buttons allow you to move vendors out of the Selected Vendors box Select the Tax Year by manually entering or clicking on the up or down arrow in the Tax Year box You can adjust where the information is printed on the 1099 Form by clicking on the Vertical Adj down arrow This will allow you to line up the information for the 1099 within the boxes on the form Click the Print Preview button and the print preview Report Viewer screen will
Download Pdf Manuals
Related Search