Methods, systems, and computer program products for linking data schemas to electronic tax return
A method and computer program product for identifying errors in a computerized preparation of an electronic financial document to be submitted to an agency. A financial document preparation program is executed, a first connection is initiated with a computer of the agency, the schema requirements are received from the agency via the first connection, data entry fields are generated, data entered into the data entry fields is received, error rules are generated from the schema requirements, each error rule associated with a respective one of the data entry fields associated with the electronic financial document, the data entered into the data entry fields is checked against the respective error rules to identify schema errors in the data entered into the data entry fields, the electronic financial document is generated based on the data entered into the data entry fields, and the electronic financial document is electronically transmitted to the agency.
1. A method for identifying errors in a computerized preparation of an electronic financial extensible markup language (XML) document formatted according to a modernized e-file (MeF) standard to be submitted to an agency that promulgates schema requirements for the MeF standard, the method comprising:
executing, by a processor, a financial document preparation program;
initiating, by a transceiver in communication with the processor, a first connection with a computer of the agency in response to the execution of the financial document preparation program;
receiving, by the transceiver, the schema requirements from the agency via the first connection, the schema requirements including XML data entry requirements based on the MeF standard;
generating, by the processor, a plurality of data entry fields;
receiving, by the processor, data entered into the plurality of data entry fields through a user interface;
generating, by the processor, a plurality of error rules from the schema requirements, each error rule associated with a respective one of the plurality of data entry fields associated with the electronic financial document, and each error rule defining a respective XML data entry requirement for the respective one of the plurality of data entry fields;
checking, by the processor, the data entered into the data entry fields against the respective error rules to identify data entered into one or more of the data entry fields that does not comply with the respective XML data entry requirement for each of the one or more of the data entry fields;
identifying, by the processor, one or more schema errors for the one or more of the data entry fields in the data entered into the data entry fields based on the checking;
receiving, by the processor, corrected data into the one or more of the data entry fields through the user interface;
generating, by the processor, the electronic financial document based on the data entered into the data entry fields and the corrected data; and
electronically transmitting, by the transceiver, the electronic financial document to the agency.
2. The method of claim 1 , further comprising performing, by the processor, at least one numerical calculation based on the data entered into the data entry fields.
3. The method of claim 1 , wherein the agency is a governmental agency.
4. The method of claim 3 , wherein the governmental agency is a tax agency, the financial document preparation program is a tax preparation program, the electronic financial document is an electronic tax return, the data entered into the data entry fields is tax data.
5. The method of claim 4 , wherein the tax agency is the Internal Revenue Service (IRS).
6. The method of claim 1 , further comprising:
associating, by the processor, a plurality of tags with the respective plurality of data entry fields, each of the tags being linked to a respective one of the error rules; and
for each data entry field, reading, by the processor, the error rule linked to the tag of the respective each data entry field, and checking, by the processor, the data entered into the respective data entry field against the linked error rule to identify a schema error in the data entered into the respective data entry field.
7. The method of claim 1 , wherein the data entered into the data entry fields is manually entered into the data entry fields by a preparer of the electronic financial document.
8. The method of claim 1 , wherein the data entered into the data entry fields is electronically scanned into the data entry fields.
9. The method of claim 1 , wherein the data entered into the data entry fields is imported from a database into the data entry fields.
10. The method of claim 1 , wherein the financial document preparation program is locally executed on a user computer.
11. The method of claim 1 , wherein the financial document preparation program is remotely executed on an intermediary computer of a host, and the method further comprises creating a second connection between the intermediary computer and a user computer, wherein the executed financial document preparation program is remotely accessed on-line by the user computer over the second connection.
12. The method of claim 1 , wherein the first connection is between the computer of the agency and an intermediary computer of a host, the method further comprising creating a second connection between the intermediary computer and a user computer, wherein the schema requirements are received from the agency via the first and second connections.
13. The method of claim 1 , wherein the one or more schema errors are identified as the data is entered into the data entry fields.
14. The method of claim 1 , further comprising compiling the one or more schema errors in an error report.
15. The method of claim 14 , wherein the report is one of a log file, an email, web page configured for display on a web browser, and an electronic document.
16. The method of claim 1 , further comprising alerting a preparer of the electronic financial document of the one or more schema errors.
17. The method of claim 16 , wherein alerting the preparer comprises displaying a message on a screen of a user computer utilized to prepare the electronic financial document.
18. The method of claim 16 , wherein alerting the preparer comprises highlighting or identifying the data entry field in which data having a schema error was entered.
19. The method of claim 16 , wherein the preparer is alerted in real time during preparation of the electronic financial document in response to input of data having a schema error into one of the data entry fields.
20. The method of claim 16 , wherein the preparer is alerted before the electronic financial document is completed.
21. The method of claim 1 , wherein one or more of the error rules is associated with one or more respective error explanations, the method further comprising, by the processor, generating a narrative explanation utilizing the one or more error explanations associated with the identified one or more schema errors.
22. The method of claim 21 , wherein the one or more error explanations comprise templates having fillable fields, and the narrative explanation is generated using the templates and filling in the fillable fields using the data entered into the data entry fields.
23. The method of claim 21 , wherein the one or more error explanations comprises fragments, expressions, and partial statements, and generating the narrative explanation comprises converting the one or more error explanations into natural language expressions.
24. The method of claim 21 , wherein the narrative explanation is automatically generated.
25. The method of claim 21 , further comprising generating, by the processor, additional, more detailed narrative explanations in response to user prompts.
26. A computer program product comprising a non-transitory computer readable storage medium having stored thereupon a sequence of instructions which, when executed by a computer, identifies errors in a computerized preparation of an electronic financial extensible markup language (XML) document formatted according to a modernized e-file (MeF) standard to be submitted to an agency that promulgates schema requirements for the MeF standard, the computer program product comprising:
a financial document preparation program configured for being executed, initiating a first connection with a computer of the agency in response to the execution of the financial document preparation program, receiving the schema requirements from the agency via the first connection, the schema requirements including XML data entry requirements based on the MeF standard, generating a plurality of data entry fields, receiving data entered into the plurality of data entry fields through a user interface, generating the electronic financial document, and causing the electronic financial document to be electronically transmitted to the agency;
a schema error module configured for receiving the schema requirements from the agency via the first connection, generating a plurality of error rules from the schema requirements, each error rule associated with a respective one of the plurality of data entry fields associated with the electronic financial document, and each error rule defining a respective XML data entry requirement for the respective one of the plurality of data entry fields; and
an error check engine configured for checking the data entered into the data entry fields against the respective error rules to identify data entered into one or more of the data entry fields that does not comply with the respective XML data entry requirement for each of the one or more of the data entry fields, and identifying one or more schema errors for the one or more of the data entry fields in the data entered into the data entry fields based on the checking;
wherein:
the financial document preparation program is further configured for receiving corrected data into the one or more of the data entry fields through the user interface, and
the generating of the electronic financial document is based on the data entered into the data entry fields and the corrected data.
27. The computer program product of claim 26 , wherein the financial document preparation program is configured for performing at least one numerical calculation based on the data entered into the data entry fields.
28. The computer program product of claim 26 , wherein the agency is a governmental agency.
29. The computer program product of claim 26 , wherein the governmental agency is a tax agency, the financial document preparation program is a tax preparation program, the electronic financial document is an electronic tax return, the data entered into the data entry fields is tax data.
30. The computer program product of claim 26 , wherein the tax agency is the Internal Revenue Service (IRS).
31. The computer program product of claim 26 , wherein the financial document preparation program is further configured for associating a plurality of tags with the respective plurality of data entry fields, each of the tags being linked to a respective one of the error rules, and wherein the error check engine is configured for, for each data entry field, reading the error rule linked to the tag of the respective each data entry field, and checking the data entered into the respective data entry field against the linked error rule to identify a schema error in the data entered into the respective data entry field.
32. The computer program product of claim 26 , wherein the data entered into the data entry fields is manually entered into the data entry fields by a preparer of the electronic financial document.
33. The computer program product of claim 26 , wherein the data entered into the data entry fields is electronically scanned into the data entry fields.
34. The computer program product of claim 26 , wherein the data entered into the data entry fields is imported from a database into the data entry fields.
35. The computer program product of claim 26 , wherein the first connection is between the computer of the agency and an intermediary computer of a host, and the financial document preparation program is configured for creating a second connection between the intermediary computer and a user computer, wherein the schema error module is configured for receiving the schema requirements from the agency via the first and second connections.
36. The computer program product of claim 26 , wherein the error check engine is configured for identifying the one or more schema errors as the data is entered into the data entry fields.
37. The computer program product of claim 26 , wherein the error check engine is configured for compiling the one or more schema errors in an error report.
38. The computer program product of claim 37 , wherein the report is one of a log file, an email, web page configured for display on a web browser, and an electronic document.
39. The computer program product of claim 26 , wherein the error check engine is further configured for alerting a preparer of the electronic financial document of the one or more schema errors.
40. The computer program product of claim 39 , wherein alerting the preparer comprises displaying a message on a screen of a user computer utilized to prepare the electronic financial document.
41. The computer program product of claim 39 , wherein alerting the preparer comprises highlighting or identifying the data entry field in which data having a schema error was entered.
42. The computer program product of claim 39 , wherein the preparer is alerted in real time during preparation of the electronic financial document in response to input of data having a schema error into one of the data entry fields.
43. The computer program product of claim 39 , wherein the preparer is alerted before the electronic financial document is completed.
44. The computer program product of claim 26 , wherein one or more of the error rules is associated with one or more respective error explanations, the computer program product comprising an error explanation engine configured for generating a narrative explanation utilizing the one or more error explanations associated with the identified one or more schema errors.
45. The computer program product of claim 44 , wherein the one or more error explanations comprise templates having fillable fields, and the narrative explanation is generated using the templates and filling in the fillable fields using the data entered into the data entry fields.
46. The computer program product of claim 44 , wherein the one or more error explanations comprises fragments, expressions, and partial statements, and generating the narrative explanation comprises converting the one or more error explanations into natural language expressions.
47. The computer program product of claim 44 , wherein the narrative explanation is automatically generated.
48. The computer program product of claim 44 , wherein the error explanation engine is further configured for generating additional, more detailed narrative explanations in response to user prompts.