Skip to main content
Level 1
Oct 27, 2026 4:11 AM UTC
Question

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:

  1. 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?
  2. What would you recommend for determining the next available Prefix for a given Series so I don’t overwrite existing items?
  3. What would you recommend to validate writes or detect which Series/Code combinations are required vs. optional for a complete import?
  4. 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!

2 replies

Kathi_at_Intuit
Moderator
Oct 28, 2026 5:00 PM UTC

Hi ​@username189410 thanks for posting in the Community about importing a custom spreadsheet via Lacerte SDK. You may have already seen this information, however what we would have is found here: 

https://developer.intuit.com/app/developer/qbo/docs/develop/sdks-and-samples 

We would also recommend looking at prior posts in this group in case they help to answer any of the questions you have posted. 

**Click the 👍Thumbs up icon to say thanks on a post, and click Best Answer to mark the post that answered your question.**
Level 2
Nov 2, 2026 3:59 PM UTC

Thank you.