Skip to Content
Open Books for developers

Tax documents and workpapers

Process Form 26AS, AIS, FIRA, Form 1099-B and trial balances, with source evidence and document-level reconciliation checks.

Start with an export from the source portal or system and verify the fields and totals the provider supports. Each layout supplies its own release checks, so review the assertions on each file.

1. Identify the input

InputReview after a release
Form 26ASCheck the tax amounts and group totals against the source statement.
Annual Information Statement (AIS)Review the source fields, reported values and any printed totals.
Foreign Inward Remittance Advice (FIRA)Inspect the remittance amount, currency and references before matching to a bank credit.
Form 1099-BInspect proceeds, basis and dates. The layout is tested on synthetic data.
Trial balance or supported Excel workpaperInspect the totals and the selected sheet's evidence.

2. Prepare a workbook

  1. Keep one supported table in the workbook. If two sheets match known layouts, export the intended table to its own workbook.
  2. Preserve the header row and printed totals. Use plain values for required fields. A total based only on a workbook formula is insufficient evidence.
  3. For a trial balance, confirm that the debit and credit columns represent the same reporting period and currency. Keep the original workbook available during review.

3. Process the files

After following the Node.js installation guide, install the tax wrapper with npm install @lumeo_hq/openbooks-tax. Save this example as an .mjs file and run it from the directory containing the Form 26AS CSV and trial balance workbook.

import { runFiles } from "@lumeo_hq/openbooks-tax";

for (const result of await runFiles(["form-26as.csv", "trial-balance.xlsx"])) {
  if (result.kind === "released") {
    console.log(result.file, result.document.file.layout_version);
    console.log(result.document.assertions);
  } else {
    console.error(result.file, result.code, result.message);
  }
}

4. Review the records and proof

Check the released layout ID and compare the applicable amounts in the table above with assertions and evidence. The output contract describes the record collections and evidence fields. If the layout is unknown, compare the source headers with the format matrix. If an assertion fails, review the source totals and route the refusal for review.

Use the workspace samples to practice these checks. For Form 26AS (TDS), open Checks and look for the printed totals for tax deducted and tax deposited. For Trial balance workbook, review both the equality of debits and credits and each side's comparison with its printed total. In Evidence, locate the source used for a reported amount before carrying it into another system.

View this page as Markdown