"Recopying" your File Name and Path to the Windows Clipboard
1099 E-Filing Overview
Applying for a Transmitter Control Code (TCC)
Checking Size of Uploaded File
FIRE System Upload: Navigating to your File
Navigating the IRS FIRE System Website
Printing Summaries and Reports
Payroll Return E-filing
E-filing Forms 94x with Payroll System
Modifying Your IRS E-file Application to E-file Forms 94x
Requirements to E-File Forms 94x
CA Forms DE 9 and DE 9C
Texas C3/C4 Employer's Quarterly Report
How do I back up/restore my data?
How do I backup to and restore from a CD or DVD?
How do I configure automatic backup?
How do I find missing backup data?
How do I move CFS programs and data to a new computer?
How do I move CFS programs and data to a new server?
How do I send client data to a colleague via email?
Why does Financial Planning Tools indicate restore database is being shared?
Why is the program not automatically backing up?
How do I download and install an update from within the program?
How do I download and install the single user version of a program?
How do I install a program or update in "safe mode?"
How do I install programs from CD?
How do I manually download and install an update?
How do I map a network drive?
How do I perform a network setup?
How do I perform a workstation setup?
What is the purpose of a network license?
Why does my desktop shortcut open the installer?
Why does the setup tell me to reboot the computer?
License Code/Firm Information
How do I change my address or firm name?
How do I edit my license code/firm information?
How does my license code work?
Where can I find my Customer ID number?
Where can I find my license code?
Why can't I call to update my firm name/address?
Why does my license code change?
Why does the installer tell me my license code is invalid?
Can I get a user’s manual for CFS programs?
Do I need a network license?
How do I contact CFS for technical support?
How do I print to a PDF?
How many computers am I licensed for?
Where can I get help for Fill-N-Print?
Where's my W2/1099 program?
Why aren't all the programs I ordered on the CD?
Why can't I order forms and envelopes over the phone?
Why didn’t you tell me to renew my programs?
Why do I need a MyCFS account?
Why does CFS no longer send renewal packets?
Instructions and Procedures
CSV Import Guidelines
Entering Data at a Client's Office
Health Insurance Compensation for 2% Owners of S-Corps
Hide/Display State Forms
Payroll System Database Reconstruction
Payroll System QuickBooks Import
Special Database Recovery Detail Instructions
Special Database Recovery Overview
CD install fails with message "Previous installation not found"
CFS Setup Runs Another Vendor's Installer
Error 12007 "Name not resolved" on Update from the Web
Error 12029 "Cannot Connect" on Update from the Web
Error 12031 when Downloading
Error 339 "File is not correctly registered" During Install
Error 339: CSCMD32.OCX etc failed to self-register
Error 339: THREED32.OCX is not correctly registered
Error 339: VSSPELL6.OCX failed to self-register
Error 35756 when Starting Program
Error 35761 when Attempting to Update
Error 35764 when Attempting to Update
Error 5001 on Installation
Error Message: "A previous version of [program] was not found..."
Error Message: "Not a Valid Win32 Executable"
Error Message: "Version of the application could not be determined"
Error Message: "Zip file damaged"
Move Data Process Error on Install
Setup Stalls During Full Install
Still Running Old Version after Update
Update Setup Reports File Is Locked
Update Setup Stalls
Error 16 when Printing Form
Error 2018: Page margins are too large, can't run report
Error 2019 when Printing Report
Error 429 when Printing Form
Error 482 when Trying to Print
Error 484 when Trying to Print
OCR-A (or OCR-ACFS) font is not properly installed
Program Crashes Without Error Message when Printing
"Small Fonts and Sans Serif can't be found" when Starting Program
"The feature you are trying to use..."
Error 1004: Error Accessing Database
Error 1706: No valid source could be found for product ( ). The Windows Installer cannot continue.
Error 3022 in Payroll System
Error 3031 when Restoring Payroll Data
Error 3045 in Payroll System
Error 3049 in Payroll System
Error 3050 in Payroll System
Error 3051 in Payroll System Network Installation
Error 3051 when Restoring Payroll Data
Error 3051: The Microsoft Jet database engine cannot open the file...
Error 3075 in Payroll System
Error 3112 in Payroll System
Error 3343 in Payroll System
Error 339: component missing or not properly registered
Error 3421 when Restoring Data
Error 3633 when Starting Payroll System
Error 3800 in Payroll System
Error 380: Invalid property value
Error 381: Invalid property array index
Error 400: Form already displayed; can't show modally
Error 429: ActiveX component cannot create object
Error 429: You don't have an appropriate license to use this functionality
Error 480: Can't create AutoRedraw image
Error 48: Trouble loading DLL
Error 52: Bad file name or number
Error 5: Invalid procedure call
Error 63 and Error 380
Error 6: Overflow
Error 7 when Starting Program
Error 70: Permission Denied
Error 75: Path/File Access Error
Error 9 and Error 381
Error 9 and Error 63
Error TX4OLE invalid property value 1-900
Items "Not Saved"
Message that something "needs to be installed" or "is on CD"
Your Network Data Is Read-Only
CFS Program Interface
Federal/State Tax Planner
Quick Reference Guide
Calendar and Notes
Data File List
Field Details for Numeric Fields
Label Setup Options
Repair Client Database
Using the Editor
Firm Information Screen
Importing/Exporting Client Data
Export Client List
Generic ASCII File Client List
Importing/Exporting Client Data
Lacerte Client List
ProSystem Client List
Table of Contents
Updated by John Logue
The Payroll System has the capability of importing payroll or 1099 data in a CSV file. A CSV ("Comma Separated Values") file can be created by organizing data in a spreadsheet program, such as Microsoft Excel, then saving the spreadsheet in CSV format.
There are five different CSV file input options:
- Payee name, address, and identification for the payroll grid,
- Payroll dollar information for the payroll grid,
- 1099 information for the payroll/1099 grid,
- W2 form input,
- 1099 form input.
The first three options import data into the payroll/1099 grid in the after-the-fact (941/940) program. This is where you need to import if the requirement is to create 941s and the 940. 1099 data imported to the grid is organized by recipient; when the program generates 1099s, the data from the grid will be appropriately accumulated to make one 1099 per recipient.
Dollars: Format dollar columns as numeric with 2 decimal places. Make sure there are no commas and no dollar signs.
Dates: Date fields should be formatted as MM/DD/YYYY. If you find something different, make sure your Regional Settings (in Windows Control Panel) are not causing a different separator to be used.
Addresses: Eliminate any apostrophes.
ZIP Codes: The ZIP code column should be formatted as Special – ZIP code or as text, especially where it contains a leading zero.
SSN: SSN column should be formatted as Special – Social Security Number or as text.
EIN: EIN should be formatted as text.
Name and Address fields have a length limit of about 30 characters.
Be sure that there are no empty rows being saved to the CSV file. Empty rows can cause rejection of the file.
Be sure that each row contains last name and ID number (SSN or EIN).