xMatix
Sign in Request demo
xMatix
PRODUCTS
SalesField Sales & SFACRMRewardsClaimsInventoryProcurementWarehouse ManagementField ServiceServiceSupportTelephony & MessagingFinance & AccountingPayrollExpense ManagementCommercePortalsAnalytics & ReportingData StudioMobile AppSee all products →
PLATFORM
Platform overviewApp BuilderAutomationIntegrationsSecurity & GovernanceChange ManagementDevelopers
SENSE AI
Sense AI overviewSense AssistSense ControlSense VisionAI StudioTrust & governanceIn Claude & ChatGPTUse cases
SOLUTIONS
Auto DMSConsumer Goods DMSSales Force Automation (SFA) FMCG & DistributionManufacturing & Dealer NetworksAutomotive & DealershipsPharma & HealthcareConsumer DurablesAgri-InputsBuilding MaterialsService NetworksWarehousing & 3PLFinancial AccountingERP SoftwareIndia GST ComplianceUAE VAT & e-InvoicingSaudi ZATCA & VATAll solutions →
RESOURCES
Knowledge CenterDeveloper & CLIBlogGuidesWhat is xMatix?Company facts
COMPANY
AboutCareersPartnersEventsContactAuthorsLegal
Sign in Request demo
Home/Docs/Entity Reference/Form 26AS Reconciliation Entry — entity reference
REFERENCE · Last reviewed

Form 26AS Reconciliation Entry — entity reference

One result row of a Form 26AS reconciliation: the summed Form 26AS lines and the summed TDS receivable rows of one company PAN, customer TAN, section and financial year, with the outcome, the books rows behind it and any decision taken on it from the Form 26AS Reconciliation Console. Written only by the reconciliation and the console's row actions. Reconciling the same statement again updates the entries in place, adds rows for new groups and removes rows for groups that no longer occur.

Fields

FieldLabelTypeRequiredWhat it does
CreatedByIdCreated ByLookup → UserAccountYes
CreatedDateTimeCreated OnDateAndTimeYes
DifferenceDifferenceDecimalBooks TDS minus Form 26AS TDS, a missing side counting as zero. Negative means the customers reported more TDS than your books hold.
FinancialYearFinancial YearTextFinancial year part of the match key, written as on the statement, for example 2025-26.
Form26ASAmount26AS AmountDecimalForm 26AS side: the summed Amount Paid of the statement's lines in the group, leaving out lines marked Invalid. Empty when the group is Missing in 26AS.
Form26ASLineIdForm 26AS LineLookup → Form26ASLineThe single Form 26AS line behind the group, set only when exactly one line has the key. Every grouped line also points back to the entry through its own Reconciliation Entry field.
Form26ASStatementIdForm 26AS StatementLookup → Form26ASStatementThe statement whose reconciliation produced this entry. Entries are rebuilt only for their own statement.
Form26ASTds26AS TDSDecimalForm 26AS side: the summed TDS Amount of the statement's lines in the group, leaving out lines marked Invalid. Empty when the group is Missing in 26AS.
IdIdGuidYes
LabelLabelTextShort text for the entry. The reconciliation writes the outcome and key, but the numbering setting replaces it with the entry number on save. It is kept on later runs.
LedgerAmountLedger AmountDecimalBooks side: the summed taxable amount of the TDS receivable rows behind the group. Empty when the group is Missing in books.
LedgerTdsLedger TDSDecimalBooks side: the summed TDS of the TDS receivable rows behind the group. Empty when the group is Missing in books.
MatchedDateMatched DateDateAndTimeWhen the group was first found on both sides. Kept on later runs while the group stays on both sides; empty for groups found on one side only.
ModifiedByIdModified ByLookup → UserAccountYes
NameNameTextYesEntry number, generated on save from the Form 26AS Reconciliation Entry Name Setting (series 26ASR). It is not the match key.
OwnerIdOwnerLookup → UserAccountYes
PANPANTextDeductee PAN part of the match key: your company's PAN, trimmed and upper-cased.
RecordTypeIdRecord TypeGuid, hidden
RemarksRemarksTextWhy the group is open, written by each run: an Amount Paid gap, the TRACES booking letters of a Not final group, a missing TAN or section on the Form 26AS line, a TAN to set on the customer, or how many books rows or Form 26AS lines were aggregated.
SectionCodeSectionTextTDS section part of the match key, for example 194C, compared as text.
SourceEntityNameSource EntityTextWhich kind of books record fed the group (TDS transactions), or Multiple. Empty when the group is Missing in books.
SourceRecordIdSource RecordGuidThe single books record behind the group, set only when exactly one record fed it. When several were summed it stays empty and Remarks gives the count.
StatusCodeStatus CodePickListOutcome of the last run for this group. Match: on both sides, TDS agrees within one rupee and every Form 26AS line is booked F. NotFinal: TDS agrees but a line is booked U, P or O. Unmatched: on both sides, TDS differs by more than one rupee (shown as Mismatched). TanMissing: books rows of a customer with no TAN were paired with the one Form 26AS group of the same section and TDS (shown as Mismatched). MissingInBooks: Form 26AS only. MissingIn26AS: books only. Amount Paid never decides the outcome.
SubscriptionKeySubscription KeyGuid, hiddenYes
TANTANTextDeductor TAN part of the match key: the customer's TAN as printed on Form 26AS, trimmed and upper-cased. For a TAN-missing group it is the TAN on Form 26AS, which the customer's account lacks. Blank when the Form 26AS line carried no TAN.
UpdatedDateTimeUpdated OnDateAndTimeYes

Actions

ActionLabelTypeWhat it does
BulkDeleteBulk DeleteDeleteBulk Delete
CloneCloneServerAction (Clone)Create a copy of this record
NewNewNewNew
← Form 26AS Line Form 26AS Statement →