AmountPaid | Amount Paid | Decimal | | Amount paid or credited on which the tax was deducted. Summed per group; a difference from the books of more than one rupee is only a remark and never changes the outcome. |
BookingStatus | Booking Status | Text | | TRACES booking status letter: F (final), U (unmatched), P (provisional) or O (overbooked). Blank counts as F. Any other value, including a spelt-out word such as Final, makes a group whose TDS agrees Not final, so import the single letter. |
CreatedById | Created By | Lookup → UserAccount | Yes | |
CreatedDateTime | Created On | DateAndTime | Yes | |
DeductorName | Deductor Name | Text | | Name of the deductor as printed. Shown in the reconciliation console; not used for matching. |
FinancialYear | Financial Year | Text | | Financial year of the row. If blank, the statement's year is used. If filled, it must be written exactly as on the statement (for example 2025-26, not 2025-2026), otherwise the row forms its own group and never meets the books. |
Form26ASStatementId | Form 26AS Statement | Lookup → Form26ASStatement | | The statement this row belongs to. The console's upload fills it in for every imported row. A line without it is never reconciled. |
Id | Id | Guid | Yes | |
Label | Label | Text | | Optional short text for the row. Not used by the reconciliation. |
ModifiedById | Modified By | Lookup → UserAccount | Yes | |
Name | Name | Text | Yes | Line number, generated on save from the Form 26AS Line Name Setting (series 26ASL). |
OwnerId | Owner | Lookup → UserAccount | Yes | |
PAN | PAN | Text | | Deductee PAN printed on the row, which is your company's PAN. It ties the statement to the company: every line of a statement must carry the same PAN, matched ignoring case and spaces. A blank PAN is allowed and treated as the company's, but at least one line must carry it. |
Quarter | Quarter | Text | | Quarter as printed (Q1 to Q4). Display only: the console places a result in a quarter by the latest transaction date and uses this only when no line has a date. Not derived from the date. |
ReconciliationStatus | Reconciliation Status | PickList | | Outcome written by the last reconciliation for this line's group: Match, NotFinal, Unmatched, TanMissing, MissingInBooks or OutOfScope (TCS). Cleared and rewritten on every run for lines that are not Invalid. A line can never be MissingIn26AS, because that outcome has no 26AS rows. |
RecordTypeId | Record Type | Guid, hidden | | |
SectionCode | Section | Text | | TDS section the tax was deducted under, for example 194C or 194Q. Part of the match key and compared as text with the section on the books rows; it is not checked against the TDS section list. Sections starting 206C (TCS) are marked Out of scope and not reconciled. |
SubscriptionKey | Subscription Key | Guid, hidden | Yes | |
TAN | TAN | Text | | TAN of the deductor (the customer who withheld the tax). Part of the match key, compared with the TAN on the customer's account, ignoring case and spaces. A blank TAN adds a remark asking you to correct the import. |
TdsAmount | TDS Amount | Decimal | | Tax deducted, as reported by the deductor. Summed per group and compared with the books TDS; a difference of more than one rupee makes the group Mismatched. A blank counts as zero. |
TransactionDate | Transaction Date | DateAndTime | | Date the amount was paid or credited. Display only: decides the quarter the console shows a result under. Matching runs on the whole financial year. |
UpdatedDateTime | Updated On | DateAndTime | Yes | |
ValidationMessage | Validation Message | Text | | Why the row is invalid, as supplied by the import. Nothing reads or writes it. |
ValidationStatus | Validation Status | Text | | Pending, Valid or Invalid, set by whoever imports the line; nothing validates lines or writes it. Only Invalid, in any capitalisation, has an effect: the line is counted as an error row and left out. A line marked Invalid keeps the Reconciliation Status from its previous run. |
