FBR e-Invoicing for Any Accounting System
Use our Excel template to import invoices from any accounting software. No integration needed.
Excel Import
Download the template, fill your invoices, and upload. We handle the rest.
How Excel Import Works
Three simple steps from download to FBR submission.
Download the Template
Get our free Excel template pre-configured with all FBR-required fields. No guessing which columns you need.
View format guideFill in Your Invoices
Export your invoices from any accounting system and map the columns. Works with Excel, SAP, Oracle, or custom software.
See mapping guideUpload & Validate
Upload your completed Excel file. Our system validates every row against FBR schema, catches errors, then submits with one click.
Start uploadingExcel Format Guide
Our template includes all the columns FBR requires. Here's what each field means.
| Column | Required | Description | Example |
|---|---|---|---|
| Invoice Number | Yes | Unique invoice identifier from your system | INV-2026-00123 |
| Invoice Date | Yes | Date of invoice issuance (YYYY-MM-DD) | 2026-07-10 |
| Buyer NTN | Yes | Buyer's National Tax Number (7 digits) | 1234567 |
| Buyer Name | Yes | Registered name of the buyer | ABC Trading Co. |
| Buyer Address | No | Buyer's registered address | 123 Main St, Lahore |
| Item Description | Yes | Description of goods or services | Office supplies - A4 paper |
| HS Code | Yes | Pakistan Customs HS code (5-11 digits) | 4802.5600 |
| Quantity | Yes | Number of units sold | 50 |
| Unit Price | Yes | Price per unit in the invoice currency | 150.00 |
| Tax Type | Yes | Sales Tax type (S for standard, E for exempt, Z for zero-rated) | S |
| Tax Rate (%) | Yes | Applicable sales tax percentage | 18 |
| Total Amount | Yes | Total invoice amount including tax | 8850.00 |
| Currency | No | ISO currency code | USD |
| Notes | No | Any additional invoice notes | Payment due in 30 days |
Why Excel Import with TaxConnect
The simplest path to FBR compliance — no matter what software you use.
No API Needed
If your software doesn't offer an API, Excel import gives you the same direct connection to FBR/PRAL.
Works with Any System
Excel, SAP, Oracle, Tally, or custom-built software — if it exports to Excel, it works with TaxConnect.
Bulk Import
Upload hundreds of invoices at once. Our validator processes every row and flags any issues before submission.
Same Validation as Xero & QuickBooks
Excel imports go through the same FBR schema validation as our API integrations. No shortcuts, no surprises.
Sandbox Testing
Test your Excel imports in our sandbox environment before going live. No risk, no FBR rejections.
30-Minute Setup
Download, fill, upload — done in under 30 minutes. No integration project, no IT team required.
Ready to Simplify FBR Compliance?
Get started with Excel import in minutes. No integration, no IT project, no switching software.
Start Free Trial →Free 14-day trial · No credit card required · Cancel anytime