IRS tax file
Q.In this new electronic age, the IRS wants it's information delivered in file form as opposed to the old paper. We have to produce a file from our customer 1099 and 1098 data (interest they paid us or we paid them.) The file is ASCII text with fixed width fields and lots of spaces (for future use as they say.) The records are all 750 positions long. And the key, I think to this project is there are 5 record typesThe codes are T=transmitter, A=Payor, B=Payee, C=Totals, K= Withheld totals, and 1998 is the tax year. The rest is just fields from different tables or blank spaces. Can Access produce a tax file of this type for submission to the IRS? Are there, maybe, some low level file handling functions? Thanks for the help
A.I feel very unqualified to answer this but... If it was VB I'd do this to open an array and write it to a file. This creates a file with a heading and the data spaced out as you wanted it. Im not sure about the 750 positions. I cut an pasted into access and it didn't complain so I guess its fine! I do this type of file handling at work all the time with VB, and since Access uses VBA now, you will not have any problem with this. What you do is use fixed length strings and write out the strings to the file, use something like this, assuming you are getting the data from the database: Dim db As Database, rs As Recordset, WS As Workspace Dim NAME As String * 30, TAXID as string * 20 outfile = FreeFile Open "C:\Taxes.txt" For Output As outfile Set rs = db.OpenRecordset("Taxes") Do Until rs.EOF NAME = rs!Name TAXID = rs!TaxId Print #outfile, NAME & TAXID rs.MoveNext ' Move to next record. Loop rs.Close ' Close table. Close outfile Since you are using a Fixed length string, if the value from the database is not the full length of the string, when you print it out, it will use spaces to fill in the missing characters. Good luck.
Other Questions :
My IRS tax refund error
I have two questions for you all. My IRS tax refund was more than double what I reported. I used Turbo Tax so a calculation error was less than likely. Should I call the IRS to report this error or investigate why this is or should I just ...
Estimated Tax _ Irs Form erro r ?
I am attempting to calculate my estimated Self Employment tax for last quarter (I'm a little late:) and I am not comfortable with this worksheet. I think it is wrong. Column one (1/1 to 3/31) of the worksheet looks like this: 27. Net earn...
OT: IRS back tax and land ownership
I need a question answered about IRS back tax and land ownership. Where do you think I could find the answer? (I would rather not talk to IRS.) The problem is this: I want to buy a small piece of land. The owner has not paid taxes in many yea...
IRS Form-free of charge
An original IRS Form 1722 listing tax information for the past three years" is required for the citizenship application. Anyone know if the tax transcripts provided by the IRS (free of charge) fits the bill?I couldn't find much reference to form...
Is anyone using IRS Free tax File program?
Is anyone using IRS Free tax File program? The web site lists several companies which offer "Free federal online tax preparation and e-filing for all taxpayers. No restrictions. Everyone qualifies". Are there any "gotchas"? Any reason NOT t...