View and Update Buyer ID Details Report
With the recent compliance update, ZATCA validates customer Tax Identification No. (TIN) and Commercial Registration No. (CRN) during invoice exchange. Therefore, ensure that your invoices are updated with accurate and valid Buyer ID details.
View Buyer ID Details Report
In TallyPrime, you can view all the Buyer IDs details on a single report.
-
Download the folder: KSA Buyer ID Details .
-
Unzip the folder.
-
Select the downloaded zip folder > right-click > Extract All.
-
Browse and select a destination for the files to be extracted.
-
Select Extract to view the following files under the KSA Buyer ID Details folder.
-
.tcp file: To load the TDL and view the Buyer ID Details report.
-
.tsf file: To import the Buyer ID details report to TallyPrime.
-
Buyer ID Details Excel sheet: To update and export the Buyer ID details report to TallyPrime.
-
-
-
Load the .tcp file in TallyPrime.
-
Press F1 (Help) > TDLs & AddOns > F4 (Manage Local TDLs).
-
In the TDL Configuration screen, set Load selected TDL files on statrtup: Yes.
-
Select the required File Name from File Selection to mention the path of the TCP file path.
-
Specify Path: Fill in the .tcp file path.
-
Select from Drive: Select the file path from the system.
-
-
Set Load TDL to Yes.
-
Select End of List.
In the TDL Management screen, the status of the .tcp file will appear as Loaded.
-
-
Press Alt+G (Go To) > Buyer ID Details.
Update Buyer ID Details
You can update the Buyer ID Details for individual ledgers from the Ledger alteration screen.
For updating the Buyer ID details of multiple masters, you can export the details from the report into an Excel, make the required changes and import it back into TallyPrime.
-
Move the mapping files (.tsf) from the KSA Buyer ID Details folder to TallyPrime installation folder > config > excelmaps.
Note: If you are downloading the .tsf files for the first time, you must manually create the config > excelmaps folder under the TallyPrime installation folder.
-
Update the Buyer ID Details for multiple ledgers through the export and import feature.
-
Export the Buyer ID Details Report to an Excel sheet.
-
Validate and update the details, as needed.
-
Import the Excel sheet with updated buyer details into TallyPrime.
-
Press Alt+O (Import) > Masters.
-
Select the File to Import, Worksheet Name, and Mapping Template.
-
Update Behaviour of Import if master already exists.
-
Select Ignore Duplicates, if you are importing the Buyer ID Details for the first time.
-
Select Modify with New Data, if you have already imported the Buyer ID Details and want to update additional data.
-
-
Set Backup Company Data before Import to Yes.
-
Press I to Import.
-
-
The Buyer ID Details Report helps you keep records accurate and compliant, ensuring smooth invoice validation with ZATCA.