full Individual (1040) import from custom spreadsheet via Lacerte SDK
Hello,
I’m in the process of building a custom solution to import data from a comprehensive Excel spreadsheet (populated from tax organizers and source forms) into Lacerte Individual returns.
The spreadsheet covers essentially all input areas of the 1040 module.
I plan to use the Lacerte SDK (ODBC and/or .NET API) to write primarily to the client Detail table using Series + Code + Prefix (plus Amount/Description, Suffix, StateAbbr, TSJ, etc.).
I’ve reviewed the SDK docs and the usdbdef file approach, but I need your expertise before I get in over my head:
- What is the most reliable method for writing new multi-occurrence Detail records (e.g., multiple W-2s, Schedule C activities, rentals, K-1s) — pure ODBC INSERT, the .NET API, or a combination?
- What would you recommend for determining the next available Prefix for a given Series so I don’t overwrite existing items?
- What would you recommend to validate writes or detect which Series/Code combinations are required vs. optional for a complete import?
- Have any of you successfully built a broad (near-full return) import this way, and are there common pitfalls I should watch for with the 2025 SDK?
I’m comfortable with Python/pyodbc or C#/.NET and already plan to use the usdbdef.i25 file plus blank Input Sheets / Show Codes for mapping.
If you have any pointers, sample patterns, or warnings I would be greatly appreciate it.
Thank you!
