|
You have data in Excel or
some type of spreadsheet and you want to import that data into the 1099Fire
software. Its easy to do. Our 1099FIRE software has the ability
to import up to 2.5 million records per file directly from Excel (.xls, .xlsx),
which is the largest file size acceptable to the IRS. You can also
import from CSV file format.
1099FIRE supports Excel
97-2003 binary formats (xls) and Excel 2007/2010 xml formats (xlsx).
Supports Unicode and 64-bit platforms.
If you are importing an
Excel file, the first row should be the column headers. The software
will automatically detect and count how many rows of data you are using and
proceed to import starting from the second row. If you are importing a CSV
file, the first row should be the total number of records. The second
row begins your data.
The order of the data for
each module along with sample Excel and CSV file formats can be downloaded
below. If you have any questions or difficulty importing, please call
support at (608) 444-6575 or by email at support@1099fire.com.
|
Order of Data |
CSV, TXT |
XLS |
XLSX |
|
1042-S |
|
1042-S (xls) |
1042-S (xlsx) |
|
1097-BTC |
|
1097-BTC
(xls) |
|
|
1098 |
1098 (csv, txt) |
1098
(xls) |
1098 (xlsx) |
|
1098-C |
|
|
|
|
1098-E |
1098-E (csv, txt) |
1098-E
(xls) |
1098E (xlsx) |
|
1098-T |
1098-T (csv, txt) |
1098-T
(xls) |
1098-T (xlsx) |
|
1099-A |
|
|
|
|
1099-B |
1099-B (csv, txt) |
1099-B
(xls) |
1099-B (xlsx) |
|
1099-C |
1099-C (csv, txt) |
1099-C
(xls) |
1099-C (xlsx) |
|
1099-CAP |
|
|
|
|
1099-DIV |
1099-DIV
(csv,
txt) |
1099-DIV
(xls) |
1099-DIV (xlsx) |
|
1099-G |
1099-G
(csv,
txt) |
1099-G
(xls) |
1099-G (xlsx) |
|
1099-H |
|
|
|
|
1099-INT |
1099-INT
(csv,
txt) |
1099-INT
(xls) |
1099-INT (xlsx) |
|
1099-K |
1099-K (csv, txt) |
1099-K
(xls) |
1099-K (xlsx) |
|
1099-LTC |
|
|
|
|
1099-MISC |
1099-MISC (csv,
txt) |
1099-MISC
(xls) |
1099-MISC (xlsx) |
|
1099-OID |
|
|
|
|
1099-PATR |
1099-PATR (csv,
txt) |
1099-PATR
(xls) |
1099-PATR (xlsx) |
|
1099-Q |
|
|
|
|
1099-R |
1099-R (csv, txt) |
1099-R
(xls) |
1099-R (xlsx) |
|
1099-S |
1099-S (csv, txt) |
1099-S
(xls) |
1099-S (xlsx) |
|
1099-SA |
1099-SA (csv, txt) |
1099-SA
(xls) |
|
|
3921 |
3921 (csv, txt) |
3921 (xls) |
3921 (xlsx) |
|
3922 |
3922 (csv, txt) |
3922 (xls) |
3922 (xlsx) |
|
5498 |
5498 (csv, txt) |
5498 (xls) |
|
|
5498-ESA |
5498-ESA (csv, txt) |
5498-ESA (xls) |
|
|
5498-SA |
5498-SA (csv, txt) |
5498-SA (xls) |
|
|
8027 |
8027 (csv, txt) |
8027
(xls) |
8027 (xlsx) |
|
8955-SSA |
8955-SSA (csv, txt) |
8955-SSA
(xls) |
8955-SSA (xlsx) |
| W-2G |
|
W-2G (xls) |
|
|
W-2 |
W-2 (csv, txt) |
W-2 (xls) |
W-2 (xlsx) |
| W-2C |
W-2C (csv, txt) |
W-2C (xls) |
W-2C (xlsx) |
|
CA 592 |
|
CA 592 (xls) |
CA 592 (xlsx) |
Frequently used abbreviations and codes
are as
follows:
Common questions with solutions are
below:
Excel Questions
CSV Questions
Technical Support
If you still have any problem
importing your data into our software, please email or call
technical support. Technical support can be reached by email
at support@1099fire.com or
by phone at (608) 444-6575.
Please send an e-mail to
info@1099fire.com with any comments you might have.
|
