i have made with the help of chat gpt simple program that will getch data from excel file to upload it to fbr if anyone needs can contact me
2 Likes
also after uploading data to fbr fbr’s invoice number needs to be embeded into qr code which will be printed on invoice
1 Like
@uzair94, the integeation part is the easy part, it’s already been done for other countries.
The hard part is making sure your Manager data are in compliance with your Tax regulations and information requirements.
That’s why I’m asking so much in depth questions.
More importantly, @Mabaega requested sample business file:
@uzair94, @Syed_Salman_Ali, @Mian_Waqas_Azfar, @Henryhompson, if anyone of you could provide a test business file, that would speed up the process.
I can contact PRAL and them to provide necessary data.
If they can provide sandbox account, will it help?
About terms and tax details, any accountant can help better.
Also, I heared they PRAL is offering free software which is already integrated with FBR , you may check that too.
Im not sure but I think PRAL is one who is responsible for testing and approval of softwares for FBR integration.
1 Like
That would indeed be helpful. Do you have the link?
It appears Manager itself has all the building blocks to make integration possible.
We have API which allows to edit any data in Manager and custom fields which allows to capture new data on any screen.
I think the best way would be to create spec file. Something similar to what has been created for ZATCA Phase 1.
See:
2 Likes
they dont have software they just give you api token to make your own software or you can purchase one from market
1 Like
I have not used it and I am not sure about it. Can you please check these two files?
1 Like
If required, I can provide you my FBR portal for testing (real account)
I have created the following tax codes in the localization:
| CustomFields2.Strings. 8a6a19800e08435ea6a88e5909cac237 |
Name | Label | TaxRate | Type | Rate |
|---|---|---|---|---|---|
| SN001 | Goods at Standard Rate (default) | 18% | CustomRate | SingleRate | 18 |
| SN002 | Goods at Standard Rate (default) | 18% | CustomRate | SingleRate | 18 |
| SN003 | Steel Melting and re-rolling | 18% | CustomRate | SingleRate | 18 |
| SN004 | Ship breaking | 18% | CustomRate | SingleRate | 18 |
| SN005 | Goods at Reduced Rate | 18% | CustomRate | SingleRate | 18 |
| SN006 | Exempt Goods | Exempt | ZeroRate | SingleRate | |
| SN007 | Goods at zero-rate | 0% | ZeroRate | SingleRate | |
| SN008 | 3rd Schedule Goods | 18% | CustomRate | SingleRate | 18 |
| SN009 | Cotton Ginners | 18% | CustomRate | SingleRate | 18 |
| SN010 | Telecommunication services | 18% | CustomRate | SingleRate | 18 |
| SN011 | Toll Manufacturing | 18% | CustomRate | SingleRate | 18 |
| SN012 | Petroleum Products | 18% | CustomRate | SingleRate | 18 |
| SN013 | Electricity Supply to Retailers | 18% | CustomRate | SingleRate | 18 |
| SN014 | Gas to CNG stations | 18% | CustomRate | SingleRate | 18 |
| SN015 | Mobile Phones | 18% | CustomRate | SingleRate | 18 |
| SN016 | Processing/ Conversion of Goods | 18% | CustomRate | SingleRate | 18 |
| SN017 | Goods (FED in ST Mode) | ZeroRate | SingleRate | ||
| SN018 | Services (FED in ST Mode) | ZeroRate | SingleRate | ||
| SN019 | Services | 18% | CustomRate | SingleRate | 18 |
| SN020 | Electric Vehicle | 18% | CustomRate | SingleRate | 18 |
| SN021 | Cement/Concrete Block | 18% | CustomRate | SingleRate | 18 |
| SN022 | Potassium Chlorate | 18% | CustomRate | SingleRate | 18 |
| SN023 | CNG Sales | 18% | CustomRate | SingleRate | 18 |
| SN024 | Goods as per SRO.297(1)/2023 | 18% | CustomRate | SingleRate | 18 |
| SN025 | Non-Adjustable Supplies | 18% | CustomRate | SingleRate | 18 |
| SN026 | Goods at Standard Rate (default) | 18% | CustomRate | SingleRate | 18 |
| SN027 | 3rd Schedule Goods | 18% | CustomRate | SingleRate | 18 |
| SN028 | Goods at Reduced Rate | CustomRate | SingleRate | 18 |
Are these taxes correct?
Also, I believe that SN017 & SN018 have two components, FED and Sales Tax, however, are these FED calculated? Is it on HS Code basis? or is it fixed for each scenario?
1 Like
Yes! these are correct but about FED any accountant can tell because in my business we dont use FED.
1 Like
Not in my country because I don’t live in Pakistan.
The point is if this localisation is wanted then someone in Pakistan will need to get all information required.
Federal Excise Duty (FED) in Pakistan is an indirect tax levied on specific goods and services. Here’s a detailed breakdown:
Overview and Legal Framework:
- Governing Law: FED in Pakistan is governed by the Federal Excise Act, 2005, which replaced the Central Excises Act, 1944.
- Purpose: It’s a legislated duty on certain goods or services at the point of purchase or provision, aiming to generate revenue for the federal government.
- Administration: The Federal Board of Revenue (FBR) is responsible for administering and collecting FED.
Scope of Application:
- Goods Manufactured/Produced: FED is leviable on goods produced or manufactured in Pakistan.
- Imported Goods: It also applies to goods imported into Pakistan.
- Specific Goods from Non-Tariff Areas: Certain goods produced or manufactured in non-tariff areas (like Azad Jammu and Kashmir, Northern Areas) and brought into tariff areas for sale or consumption are also subject to FED.
- Services Rendered: A wide range of services provided or rendered in Pakistan are also subject to FED. Examples include:
- International air travel tickets (club, business, and first-class).
- Telecommunication services (though many services are now under provincial sales tax).
- Financial services.
- Insurance services.
Key Characteristics and Changes Introduced by the 2005 Act:
- “Federal” vs. “Central”: The term “Federal Excise Duty” replaced “Central Excise Duty” to reflect the scope of the tax.
- Self-Assessment: The system of physical supervision has been abolished, and clearances are now self-assessed, requiring no prior permission.
- Monthly Payment: Duty on all clearances during a month is payable by the 15th of the next month, a shift from the previous requirement of payment prior to clearance.
- No Gate Passes: Gate passes are no longer required for clearances.
- Elimination of Double Taxation: Adjustment of excise duty paid on input goods used directly in the manufacture or production of other excisable goods is allowed to avoid double taxation.
- VAT Mode for Some Items: For some goods and services, FED is payable in a VAT-like manner, similar to the Sales Tax Act, 1990.
Examples of Dutiable Goods and Services (Illustrative, rates vary and are subject to change with annual budgets):
- Tobacco Products: Cigarettes, cigars, etc., are consistently subject to high FED rates.
- Beverages: Aerated waters, energy drinks, and certain fruit juices/syrups often attract FED.
- Cement: A significant item for FED collection.
- Automobiles: Depending on engine capacity and type, vehicles may have FED levied.
- Property Transactions (Historically): FED was levied on the allotment or transfer of commercial property and the first allotment/transfer of open plots or residential property by developers/builders. However, recent proposals indicate a move to abolish the 3% FED on property sales due to legal ambiguities and economic impact.
- Air Travel: Tickets for international travel in certain classes.
- Day-old chicks: A recent addition to the FED scope.
Exemptions:
- Specific goods and services are exempt from FED as outlined in the Third Schedule of the Federal Excise Act, 2005, subject to certain conditions and restrictions.
- Historically, there have been exemptions for certain goods and services related to disaster relief (e.g., flood affectees).
- Proposals are often made in budget cycles to withdraw or grant new exemptions, such as for the former FATA region or specific imported items.
Recent Trends and Budgetary Measures:
- The government frequently reviews and adjusts FED rates on various products to meet revenue targets, often targeting luxury items or those deemed harmful.
- There’s an ongoing effort to broaden the tax net, including bringing digital economy activities under tax laws.
- Debates often arise regarding the impact of FED on inflation and specific industries.
It’s important to note that FED rates and specific applications can change frequently with annual budgets and government notifications. For the most accurate and up-to-date information, it’s always best to consult the official Federal Board of Revenue (FBR) website or relevant tax laws and circulars.
2 Likes
In many financial transactions, especially involving banks, international transfers, telecom, and logistics, we face multiple layered charges, for example:
- Foreign Transaction Fee (e.g. 1.5% on amount)
- Then FED or other taxes (e.g. 16% on the Foreign Transaction Fee)
- Some payments include WHT + service charges + taxes on service charges
Currently in Manager:
- Tax Codes only post to one account (usually a liability)
- WHT Payable/Receivable is limited to basic invoice/payments
- There’s no way to define layered charges or allocate each to different accounts
This makes it hard to track actual cost breakdowns, especially in regulated environments.
Proposed Feature: “Charge/Deduction Codes” with Chained Calculations
Each charge/deduction code should allow:
| Field | Description |
|---|---|
| Name | e.g. Foreign Fee, FED on Fee, WHT, Handling Charges |
| Type | Deduction or Addition |
| Base Amount Source | Choose what to apply the % on (e.g. main amount, previous charge, total) |
| Percentage | e.g. 1.5%, 16%, etc. |
| Posting Account | Account where the charge/deduction is booked (e.g. Expense:Bank Charges) |
| Applies To | Transaction types (Receipts, Payments, Invoices, Journals) |
| Priority / Order | Allow sequencing of charges (e.g. FED applies after Foreign Fee) |
Example
Foreign Payment of $1,000
| Charge Code | Base Amount | % | Amount | Posted To |
|---|---|---|---|---|
| Foreign Fee | $1,000 | 1.5% | $15 | Expense:Bank Charges |
| FED on Foreign Fee | $15 | 16% | $2.40 | Liabilities:FED Payable |
| WHT | $1,000 | 5% | $50 | Liabilities:WHT Payable |
| Net Payment | $932.60 |
Why This is Needed
- Current Tax Codes can’t split amounts into different accounts
- WHT module is too limited
- Layered, rule-based charges are common in many industries and countries
- Users need full control over calculation logic and account mapping
1 Like
Welcome to the forum @gamee0077,
You could start by giving us a hint on which country we are talking about 
Thank you! I’m from Pakistan, and my business is mostly freelancing and online services. I often deal with charges like PayPal fees, international bank deductions, foreign transaction fees, FED on those fees, and WHT. Sometimes there are also platform-specific charges. It’s not difficult to manage in Manager, but it becomes manual and repetitive. A feature like this would really help automate the process and ensure proper allocation.
Great, I will merge this with an existing idea for Pakistan localization then.
1 Like
Thank you @gamee0077 for your interest on this post, regards.
any update on it?
because govt is already emailing that they will start imposing fines if we are not using software integration with FBR’s system.
Is there a Postman Collection provided by FBR for Integration Testing?
About a year ago, I created one for POS integration. While it’s far from perfect—especially since there’s no relay facility available yet—I was able to successfully report a POS invoice and generate a QR Code in the Sandbox environment.
Also, is there any official developer forum or community where we can discuss integration-related issues and share experiences?