Welcome, User

FBR CSV Format Guide

Back to Import

Understanding the CSV Format

This guide explains each column required in the CSV file for FBR multi-item invoicing. Please ensure your data follows this format for successful processing.

invoiceType Required

The type of invoice (e.g., SI for Sales Invoice).

Example: SI

invoiceDate Required

Date of the invoice in DD/MM/YYYY format.

Example: 15/08/2023

sellerNTNCNIC Required

Seller's NTN or CNIC number.

Example: 1234567890

sellerBusinessName Required

Legal business name of the seller.

Example: ABC Enterprises

sellerProvince Required

Seller's province code.

Example: Sindh

sellerAddress Required

Complete address of the seller.

Example: ABC Road, Karachi

buyerNTNCNIC Required

Buyer's NTN or CNIC number.

Example: 0987654321

buyerBusinessName Required

Legal business name of the buyer.

Example: XYZ Traders

buyerProvince Required

Buyer's province code.

Example: Punjab

buyerAddress Required

Complete address of the buyer.

Example: XYZ Street, Lahore

buyerRegistrationType Required

Buyer's registration type with FBR.

Example: Registered

invoiceRefNo Required

Unique reference number for the invoice.

Example: INV-001 / Your Own Invoice

scenarioId Required

FBR scenario identifier.

Example: SCN-001

hsCode Required

Harmonized System code for the product.

Example: 1234.5078

productDescription Required

Description of the product or service.

Example: Product A

rate Required

Unit price of the product.

Example: 18% / 25%

uom Required

Unit of measurement.

Example: PCS, KG

quantity Required

Quantity of items.

Example: 10

totalValues Required

Total value (rate × quantity).

Example: 1000.00

valueSalesExcludingST Required

Sales value excluding sales tax.

Example: 900.00

fixedNotifiedValueOrRetailPrice Required

Fixed notified value or retail price.

Example: 950.00

salesTaxApplicable Required

Sales tax amount applicable.

Example: 170.00

salesTaxWithheldAtSource Optional

Sales tax withheld at source.

Example: 0.00

extraTax Optional

Extra tax amount if applicable.

Example: 0.00

furtherTax Required

Further tax amount.

Example: 0.00

sroScheduleNo Optional

SRO schedule number if applicable.

Example: SCH-001

fedPayable Optional

FED amount payable.

Example: 0.00

discount Optional

Discount amount if applicable.

Example: 0.00

saleType Required

Type of sale (e.g., Standard, Export).

Example: Standard

sroItemSerialNo Optional

SRO item serial number if applicable.

Example: 001

Download Sample Master File

Download a sample CSV file with the correct format and example data to help you get started, in excel file enter your entries and goto Export sheet press Export button system.