Accounting SOP & User Manual
Bangladesh e-GP Contractor · 1st Class Government Subcontractor
Manager.io ব্যবহারের সহজ পথ
Version: 2.2 FINAL
Date: 2026-08-14
Audience: e-GP workflow জানেন, software-এ কাজ করতে পারেন; debit/credit জানাটা বাধ্যতামূলক নয়
Language: Natural Bangla + essential English software terms
Brand: নেই
Use: Operator training, NotebookLM source, internal slide-deck source
Non-inventory Item Source: Non-inventory Items_14-AUG-26.md
[STATED] এই manual হিসাববিজ্ঞানের বই নয়। একটি e-GP tender-এর ঘটনা Manager.io-তে কোথায় বসবে এবং কেন বসবে—সেটা সহজ করে বলাই এর কাজ।
[VERIFIED] Core architecture: site income/cost-এর জন্য Project; tender-specific standalone Balance Sheet movement-এর জন্য Ref.
[STATED] Final policy: Sales Invoice-Line Ref. = NO. RA Bill-এর tender identity থাকবে Customer + Project-এ; standalone Payment, Receipt, বা Journal Entry-এর Balance Sheet movement-এ Ref. ব্যবহার হবে।
[VERIFIED] Item names, descriptions, units, and account numbers in the operational item guide below are based on
Non-inventory Items_14-AUG-26.md. [IP RISK] This SOP intentionally excludes live UUIDs, API keys, passwords, internal URLs, and bank details.
PART 1 — শুরুতে গল্পটা বুঝে নিন
একটা tender শুরুতে শুধু সম্ভাবনা। তারপর fee হয়, security হয়, NOA আসে, কাজ শুরু হয়, RA Bill হয়, টাকা আসে, কিছু টাকা আটকে থাকে। একদিন সেই আটকে থাকা টাকাও ফেরত আসে।
[STATED] Manager.io-তে এই গল্পটি পরিষ্কার রাখার জন্য তিনটি জিনিস আগে বুঝতে হবে:
- Customer — যে সরকারি PE office কাজটি দিয়েছে
- Project — যে tenderটি awarded হয়েছে
- Ref. — একটি tender-specific Balance Sheet movement-এর ছোট পরিচয়
Customer office-কে চেনে। Project tender-কে চেনে। Ref. সেই tender-এর margin, retention, advance বা loan movement-কে চেনে।
1. PE কে?
[STATED] PE = Procuring Entity = Procurement Authority। সহজ কথা: যে সরকারি office tender দেয়, কাজ দেখে, bill certify করে এবং টাকা দেয়।
LGED, PWD, EED, RHD, BWDB—এগুলো agency-এর নাম। একই agency-এর আবার ভিন্ন city, district বা division office থাকতে পারে। LGED Barishal এবং LGED Patuakhali একই agency, কিন্তু একই office নয়।
[STATED] Manager.io-তে একটি PE office/branch = একটি Customer।
| Customer field | কী লিখবেন | Example |
|---|---|---|
| Name | PE office-এর পরিষ্কার official name | Local Government Engineering Department |
| Code | Agency + office/branch code | LGED-BSL, LGED-PTK |
| REGION/BRANCH/OFFICE | Office বা zone | BARISHAL, PATUAKHALI |
LGED Barishal office → Customer Code: LGED-BSL
LGED Patuakhali office → Customer Code: LGED-PTK
[INFERRED] একই Customer-এর নিচে দুই office রাখলে ভবিষ্যতে office-wise tender, receivable এবং history মিশে যাবে। তাই branch আলাদা হলে Customer-ও আলাদা।
ছোট নিয়ম
- করবেন: Customer Name পরিষ্কার রাখবেন
- করবেন: Customer Code-এ branch/office identity রাখবেন
- করবেন না: Customer Name-এর মধ্যে Tender ID, Project name বা কাজের পুরো description ঢোকাবেন না
[STATED] Customer হলো office identity। Tender হলো Project identity।
2. Tender ID কী?
[STATED] Tender ID বা Tender Proposal ID হলো e-GP tender-এর স্থায়ী পরিচয় নম্বর। NOA, security paper, certificate এবং bill-এ এই নম্বরটি সাধারণত পাওয়া যায়।
Project name-এ Tender ID থাকবে। Tender-specific Balance Sheet movement-এ Ref.-ও সেই ID দিয়ে হবে:
Project: JHLKT-RoadRehab-LGED-1142857
Ref.: LGED-1142857
[VERIFIED] Ref. format: PE-TenderID। শুধু 1142857 লিখবেন না; prefix থাকলে পরে চোখে দেখেই agency বোঝা যায়।
কোন number ব্যবহার করবেন?
| Number | ব্যবহার |
|---|---|
| Tender Proposal ID | Project name ও Ref.-এর tender identity |
| Package No. | Source document reference হিসেবে রাখুন; Project name-এ নয় |
| Contract No. | Project name-এ নয়; slash/long legal format থাকলে reference field বা source file-এ রাখুন |
3. NOA কী?
[STATED] NOA অর্থ Notification of Award। এটি আসার মানে tender আর সম্ভাবনা নয়—কাজটি আপনি পেয়েছেন।
NOA আসার আগে Project খুলবেন না। কারণ তখন কাজটি awarded হয়নি। NOA আসার পর Project খোলা হবে, এবং এখানেই একটি গুরুত্বপূর্ণ নিয়ম শুরু হয়।
4. RA Bill, Retention, Advance—একসঙ্গে বুঝুন
[STATED] RA Bill বা Running Account Bill হলো কাজ যতটুকু হয়েছে, তার progress bill। Manager.io-তে এটি Sales Invoice।
একটি RA Bill-এ সাধারণত তিনটি কথা থাকে:
- এই মাসে কত টাকার কাজ certified হলো
- PE কত টাকা Retention হিসেবে আটকে রাখল
- আগে দেওয়া Mobilization Advance থেকে PE কত টাকা recover করল
Retention
[VERIFIED] Retention হলো PE-এর কাছে থাকা আপনার পাওনা। এটি নতুন income নয়; Revenue RA Bill-এর সময়ই record হয়।
- Account: 1150 Retention Receivable
- DLP শেষে release পেলে: Bank-এ আসে
Mobilization Advance
[VERIFIED] Mobilization Advance হলো কাজ শুরুর আগে PE-এর দেওয়া টাকা। এটি income নয়; পরে RA Bill থেকে recover হবে।
- Account: 2100 Mobilization Advance Received
- Nature: liability
DLP
[STATED] DLP = Defect Liability Period। এই সময়ে কাজের defect থাকলে contractor-এর দায় থাকে। DLP এবং release condition সম্পূর্ণভাবে contract document দেখে confirm করবেন।
5. Security আর BG
Tender Security
[STATED] Bid করার সময় Tender Security লাগতে পারে। এটি cash, Pay Order, BG-only, অথবা BG-এর বিপরীতে cash margin—যে কোনোভাবে হতে পারে।
Performance Security
[STATED] Award-এর পরে Performance Security লাগতে পারে। এটি কাজের performance নিশ্চিত করার security। এর amount, method, expiry এবং release condition NOA/contract/BG document থেকে নেবেন—অনুমান করবেন না।
Bank Guarantee (BG)
[VERIFIED] BG face value নিজে income বা expense নয়। Cash margin এবং bank commission ledger-এ record হয়; BG number, issue date, expiry ও status আলাদা BG Register-এ রাখা হয়।
| ঘটনা | Manager.io treatment |
|---|---|
| Cash Tender Security | 1130 Tender Security Margin + Ref. |
| Cash Performance Security | 1140 Performance Security Margin + Ref. |
| BG-only, cash blocked নয় | Ledger entry নয়; BG Register update |
| BG + cash margin | Cash margin ledger-এ; BG details register-এ |
| BG bank commission | 5710 Expense অথবা approved 1300 prepaid method |
PART 2 — NOA আসার দিন
6. Award day rule: দুইটি record, একই সময়ে
[STATED] NOA পাওয়ার সঙ্গে সঙ্গে দুটি কাজ করবেন:
- Customer create/check — PE office আগে থেকে না থাকলে তৈরি করুন
- Project create — awarded tender-এর জন্য একটি নতুন Project
এটি আলাদা দিনে করার কাজ নয়। একই সময়ে করলে Code দেখে Code বসানো যায়। typo কম হয়। পরে কী লিখেছিলাম তা মনে করতে হয় না।
Step A — Customer আছে কি না দেখুন
Customers tab-এ search করুন। একই PE office-এর Customer আগে থেকে থাকলে আবার create করবেন না।
না থাকলে:
| Field | কী লিখবেন | Example |
|---|---|---|
| Name | PE office-এর নাম | Local Government Engineering Department |
| Code | PE CODE | LGED-BSL |
| REGION/BRANCH/OFFICE | Office/zone | BARISHAL |
[STATED] নতুন Customer বানানোর আগে একই Code বা একই office-এর duplicate আছে কি না দেখে নেবেন।
Step B — Project create করুন
প্রতি awarded tender-এর জন্য একটি Project।
| Project field | কী লিখবেন | Example |
|---|---|---|
| Name | Location-ShortName-PE-TenderID | JHLKT-RoadRehab-LGED-1142857 |
| Customer | সেই PE office Customer | LGED-BSL |
| PE CODE | Customer Code-এর exactly same value | LGED-BSL |
| Contract Value | NOA/contract-এ থাকা awarded value | source document থেকে |
| Retention Rate | contract-এ থাকা rate | source document থেকে |
The one check that matters
Customer Code: LGED-BSL
Project PE CODE: LGED-BSL
[STATED] দুইটি value হুবহু এক হতে হবে—capital letter, hyphen, সবকিছু।
LGED-BSL ✅
LGED BSL ❌
lged-bsl ❌
LGED ❌
[INFERRED] এক PE office-এর বহু Project থাকতে পারে। Customer Code ও Project PE CODE এক রাখলে বহু বছর পরে office, tender এবং Project history filter করা সহজ থাকে।
7. Project Name কীভাবে লিখবেন
[VERIFIED] Format:
[Location]-[ShortName]-[PE]-[TenderProposalID]
| অংশ | কাজ | Example |
|---|---|---|
| Location | site/area চেনার অংশ | JHLKT, SADAR, BAKRGNJ |
| ShortName | কাজের ছোট নাম | RoadRehab, Building, Supply |
| PE | agency code; branch suffix নয় | LGED, PWD, EED |
| TenderProposalID | e-GP identity | 1142857 |
JHLKT-RoadRehab-LGED-1142857
[STATED] Project Name-এ Contract No., package description, slash-ওয়ালা legal reference বা অনেক লম্বা বাক্য লিখবেন না। এই field দ্রুত খোঁজার জন্য।
Award-day checklist
[ ] NOA/source paper থেকে PE office, Tender ID, Contract Value, Retention Rate দেখেছি
[ ] Customers-এ same PE office এবং Code খুঁজেছি
[ ] না থাকলে Customer তৈরি করেছি
[ ] Project Name format মেনে Project করেছি
[ ] Customer Code = Project PE CODE, exact match করেছি
[ ] Ref. helper note লিখেছি: PE-TenderID
[ ] Source document link/file reference Project record-এ বা approved repository-তে রেখেছি
PART 3 — Manager.io-এর ছোট মানচিত্র
8. কোন ঘটনা কোথায় যায়
| বাস্তব ঘটনা | Manager.io form/object |
|---|---|
| PE office | Customers |
| Awarded tender | Projects |
| RA Bill / certificate | Sales Invoices |
| Material/supplier/subcontractor bill | Purchase Invoices |
| টাকা বের হলো | Payments |
| টাকা এলো | Receipts |
| Adjustment | Journal Entries |
| Bank/Cash | Bank & Cash Accounts |
[STATED] Entry দেওয়ার আগে একবার নিজেকে জিজ্ঞেস করুন: “এটা আসলে কী ঘটনা?” Answer পেলেই form বেছে নেওয়া সহজ হবে।
9. Project এবং Ref.—দুজনের কাজ আলাদা
Project
[VERIFIED] P&L account-এ Project ব্যবহার হবে। P&L মানে income বা expense—কোন site-এর লাভ/খরচ সেটা বোঝা দরকার।
RA Bill revenue → Project
Materials → Project
Site labor → Project
Subcontractor cost → Project
Equipment allocation → Project
Liquidated damages → Project, when directly project-related
Ref.
[VERIFIED] Tender-specific Balance Sheet line-এ Project selector available নাও থাকতে পারে। তখন Ref. দিয়ে tender identity রাখা হয়।
Tender Security margin → Ref.
Performance Security margin → Ref.
Retention release → Ref.
Mobilization Advance receipt → Ref.
Time Loan principal movement → Ref., only if clearly tender-specific
Time Loan interest
[VERIFIED] 5700 Interest on Time Loan: Project blank, Ref. blank। Bank facility interest সাধারণত lump sum হয়; safe tender-wise split না থাকলে tag দেবেন না।
Final Sales Invoice policy
[STATED] Sales Invoice line-এ Ref. ব্যবহার করবেন না।
- Invoice header-এ Customer থাকবে
- Invoice context-এ Project থাকবে
- Revenue, retention এবং advance recovery একই RA Bill-এর অংশ হিসেবে দেখা যাবে
- Standalone Balance Sheet Receipt/Payment/Journal Entry হলে Ref. ব্যবহার হবে
PART 4 — Non-inventory Items: ব্যবহার করার নিয়ম
10. Item select করার আগে
[VERIFIED] Non-inventory Items_14-AUG-26.md-এ item-এর account number, item name, bilingual description এবং unit name দেওয়া আছে। Manager.io-তে item list থেকে matching item select করলে line description এবং account selection consistent থাকে।
Operator rule
- ঠিক ঘটনার জন্য ঠিক item select করুন — শুধু account number দেখে কাছাকাছি item নেবেন না।
- Item-এর Unit বদলাবেন না, যদি source quantity ওই unit-এ থাকে।
- Tender identity item description-এ লিখবেন না; Balance Sheet movement হলে Ref. field ব্যবহার করুন।
- Site cost item হলে Project select করুন।
- New item দরকার মনে হলে নিজে create করবেন না; duplicate আছে কি না verify করে authorized setup process অনুসরণ করুন।
Item family quick map
| Item family | কাজ | Main account |
|---|---|---|
Tender Doc - ... |
Bid-stage document, submission, preparation expense | 5800 |
TS Margin ... |
Tender Security | 1130 |
PS Margin ... |
Performance Security | 1140 |
Retention ... |
PE / subcontractor retention | 1150 / 2050 |
Mobilization Advance ... |
PE advance receipt/recovery | 2100 |
Time Loan ... |
Time Loan cash movement / monthly adjustment | 2300 / 5700 |
| Material items | Construction material | 5000 |
| Labor items | Site labor | 5010 |
| Equipment items | Equipment/rental/allocation type cost | 5030 |
Bank Charge ... |
General bank fee | 5720 |
Tender Doc - ... |
Pre-NOA bid expenditure | 5800 |
11. Tender document and bid-stage items
Tender জেতার আগে Project নেই। তখন item select করবেন, কিন্তু Project blank রাখবেন।
| Situation | Use this item | Account | Unit | Project | Ref. |
|---|---|---|---|---|---|
| e-GP portal document/submission fee | Tender Doc - Submission Fee |
5800 | Fee | Blank | PE code only |
| Bid preparation, printing, courier | Tender Doc - Preparation Cost |
5800 | Cost | Blank | PE code only |
| Other bid-stage cost | Tender Doc - Misc Bid Expense |
5800 | Cost | Blank | PE code only |
Example
Form: Payment
Item: Tender Doc - Submission Fee
Unit: Fee
Project: blank
Ref.: LGED
[STATED] Tender জিততে পারেন—এই সম্ভাবনার জন্য dummy Project খুলবেন না। NOA না আসা পর্যন্ত Project নেই।
12. Tender Security items
Cash margin block
| Situation | Use this item | Account | Unit | Ref. |
|---|---|---|---|---|
| Cash margin blocked for tender security | TS Margin Cash Block |
1130 | Instrument | PE-TenderID |
| Partial cash margin against BG-backed security | TS Margin BG Partial Block |
1130 | UnitName* | PE-TenderID |
| Margin funded through a real Time Loan drawdown | TS Margin Loan Block |
1130 | Instrument | PE-TenderID |
after source note: *The source export displays UnitName for TS Margin BG Partial Block. [STATED] Treat this as a catalog-data label to confirm in Manager.io before use; do not change it from the SOP.
BG-only tender security
| Situation | Use this item | Account shown in item source | Operator treatment |
|---|---|---|---|
| BG issued, no cash block | TS Margin BG |
1130 | Do not create a cash-margin entry merely because a BG exists; record the BG in BG Register. Record only actual commission/cash block when applicable. |
[VERIFIED] The item source includes TS Margin BG under 1130, but BG face value itself is not a ledger asset or expense. Therefore, operator must record only the actual cash movement, not the BG face value.
Release and bank fees
| Situation | Use this item | Account | Unit | Project / Ref. |
|---|---|---|---|---|
| Tender Security refunded/released | TS Margin Release |
1130 | Instrument | Ref. = same tender |
| BG issue commission | TS BG Commission - Direct |
5710 | Fee | Pre-NOA: Project blank; apply approved reference convention |
| Bank processing charge | TS Margin Bank Charge |
5720 | Fee | Project blank; apply approved reference convention |
13. Performance Security items
| Situation | Use this item | Account | Unit | Project / Ref. |
|---|---|---|---|---|
| Cash margin blocked | PS Margin Cash Block |
1140 | Instrument | Ref. = PE-TenderID |
| Margin released after DLP | PS Margin Release |
1140 | Instrument | Ref. = same tender |
| Direct BG commission | PS BG Commission - Direct |
5710 | Fee | Project if clearly single-tender |
| Multi-year commission paid upfront | PS BG Commission - Prepaid Initial |
1300 | Instrument | Balance Sheet; follow approved reference method |
| Monthly prepaid commission amortization | PS BG Commission - Monthly Amortization |
5710 | Month | Project if clearly single-tender |
| Bank processing charge | PS Margin Bank Charge |
5720 | Fee | Project blank unless approved policy says otherwise |
[STATED] Direct vs prepaid BG commission depends on the approved accounting policy and supporting document. Do not select the prepaid item simply because the amount is large; duration/policy must support it.
14. Mobilization, Retention, and Time Loan items
Mobilization Advance
| Situation | Use this item | Account | Unit | Ref. |
|---|---|---|---|---|
| PE advance received | Mobilization Advance Received |
2100 | Advance | PE-TenderID |
| Advance recovered on RA Bill | Mobilization Advance Recovery |
2100 | Recovery | No Sales Invoice-Line Ref. |
[STATED] RA Bill-এ recovery line-এর context Customer + Project দিয়ে থাকবে; item সঠিক হলেও Sales Invoice-Line Ref. ব্যবহার করবেন না।
Retention
| Situation | Use this item | Account | Unit | Ref. |
|---|---|---|---|---|
| PE retention withheld on certified RA Bill | Retention Withheld |
1150 | Bill | No Sales Invoice-Line Ref. |
| PE retention released after DLP | Retention Release |
1150 | Bill | PE-TenderID |
| Retention withheld from subcontractor | Retention Subcontractor Withheld |
2050 | Bill | Ref. when standalone Balance Sheet line needs tender identity |
Time Loan
| Situation | Use this item | Account | Unit | Project / Ref. |
|---|---|---|---|---|
| Real cash drawdown/repayment | Time Loan Cash Movement |
2300 | Movement | Ref. only if clearly tender-specific |
| Monthly bank statement adjustment | Time Loan Monthly Adjustment |
5700 | Month | Project blank, Ref. blank |
[VERIFIED] The 14-AUG item catalog names the 5700 item Time Loan Monthly Adjustment; the item name does not change the locked rule that 5700 Time Loan interest/adjustment remains untagged unless a separate approved policy explicitly changes it.
15. Site materials: 5000 Direct Materials
[VERIFIED] These items are 5000 material-cost items from the 14-AUG catalog. For real site material/carrying/chipping cost, use Project = Yes and Ref. = No.
| Item | Unit | What it means |
|---|---|---|
| Binding Wire | Kg | GI binding wire purchase |
| Bitumen | Barrel | Bitumen purchase |
| Bitumen Carrying Cost | Barrel | Bitumen transport cost |
| Brick Carrying Cost - ft³ | ft³ | Brick transport cost by cubic foot |
| Brick Carrying Cost - হাজার | হাজার | Brick transport cost by thousand |
| Brick Chipping Cost | ft3 | Brick breaking/chipping cost |
| Bricks_ft3 | ft3 | Brick purchase by cubic foot |
| Bricks_হাজার | হাজার | Brick purchase by thousand |
| Cement | Bag | Cement purchase |
| Cement Carrying Cost | Bag | Cement transport cost |
| CI Sheet | Sheet | Corrugated iron sheet purchase |
| Electrical Item | Lot | Electrical materials |
| Floor Tiles | sft | Floor tile purchase |
| Glass - 5mm | sft | 5 mm glass sheet purchase |
| Iron | Kg | Iron purchase |
| Iron Carrying Cost | MT | Iron transport cost |
| MS Rod - 500W | Kg | MS rod purchase |
| MS Rod Carrying Cost | MT | MS rod transport cost |
| MS Sheet | Sheet | Mild steel sheet purchase |
| Paint - Enamel | Gallon | Enamel paint purchase |
| PVC Pipe | Rft | PVC pipe purchase |
| Sand | ft3 | Sand purchase |
| Sand Carrying Cost | ft3 | Sand transport cost |
| Stone Carrying Cost | ft3 | Stone transport cost |
| Stone Chips Carrying Cost | ft3 | Stone chips transport cost |
| Stone Chips_ft3 | ft3 | Stone chips purchase |
| Stone_ft3 | ft3 | Stone purchase |
| Timber - Sal Wood | Cft | Sal wood timber purchase |
| Welding Rod | Kg | Welding electrode purchase |
Material entry example
Form: Purchase Invoice
Item: Cement
Unit: Bag
Account: 5000 Direct Materials (from item)
Project: select the actual awarded Project
Ref.: blank
[STATED] If one supplier invoice covers two Projects, use separate invoice lines and select the correct Project line-by-line.
16. Site labor: 5010 Direct Labor
[VERIFIED] These labor items are 5010 site-labor costs from the 14-AUG catalog. For site labor, use Project = Yes and Ref. = No.
| Item | Unit | What it means |
|---|---|---|
| Electrician Labor | Day | Electrician wage |
| Helper Labor | Day | Helper wage |
| Mason Labor | Day | Mason wage |
| Overtime Labor | Hour | Overtime labor charge |
| Regular Labor | Day | Regular daily labor |
| Skilled Labor | Day | Skilled worker wage |
| Welder Labor | Day | Welder wage |
Labor entry example
Form: Payment
Item: Mason Labor
Unit: Day
Account: 5010 Direct Labor (from item)
Project: select the actual awarded Project
Ref.: blank
17. Equipment and handling: 5030
[VERIFIED] These items are recorded under account 5030 in the 14-AUG item catalog. Use Project = Yes when the cost relates to a specific site.
| Item | Unit | What it means |
|---|---|---|
| Concrete Mixer Rental | Day | Concrete mixer rental |
| Diesel - Equipment | Liter | Fuel for construction equipment |
| Equipment Rental | Day | Equipment rental charge |
| Loading Unloading Charge | Trip | Material loading/unloading charge |
| Scaffolding Rental | Set-Day | Scaffolding rental |
Equipment entry example
Form: Payment or Purchase Invoice (depending on source bill)
Item: Equipment Rental
Unit: Day
Account: 5030 (from item)
Project: select the actual awarded Project
Ref.: blank
[STATED] Equipment allocation or internal cross-project allocation requires approved usage evidence. Do not use rental/fuel item merely to create an internal allocation entry.
18. General bank charge item
| Situation | Use this item | Account | Unit | Project / Ref. |
|---|---|---|---|---|
| General bank fee not related to security | Bank Charge - General |
5720 | Fee | Both blank |
Form: Payment
Item: Bank Charge - General
Project: blank
Ref.: blank
PART 5 — Daily Workflows
19. Pre-NOA: e-GP document fee
Tender জেতার আগে Project নেই। এই অবস্থাকে ভুল ভাববেন না। তখন শুধু PE এবং bid-stage expense আছে।
| Field | Value |
|---|---|
| Form | Payment |
| Item | Tender Doc - Submission Fee |
| Account | 5800 Bidding & Tender Expenses |
| Unit | Fee |
| Project | blank |
| Ref. | PE code only, e.g. LGED, PWD, EED |
এক Payment-এ অনেক PE-এর fee হলে প্রতি PE-এর জন্য আলাদা line দিন।
Tender Doc - Submission Fee Ref: EED
Tender Doc - Submission Fee Ref: LGED
Tender Doc - Submission Fee Ref: PWD
[STATED] Bid করেছেন বলে dummy Project খুলবেন না। NOA না আসা পর্যন্ত Project নেই।
20. Tender Security: cash, BG, release
A. Cash / Pay Order / cash margin
| Field | Value |
|---|---|
| Form | Payment |
| Item | TS Margin Cash Block |
| Account | 1130 Tender Security Margin |
| Unit | Instrument |
| Ref. | PE-TenderID; ID unavailable হলে approved PE-only convention |
Dr 1130 Tender Security Margin
Cr 1010 Bank
[VERIFIED] 1130 asset account কারণ cash margin আপনার টাকা; অন্য পক্ষ বা bank নির্দিষ্ট সময়ের জন্য ধরে রেখেছে।
B. BG-only
[VERIFIED] যদি BG দেওয়া হয় কিন্তু কোনো cash margin block না হয়, ledger-এ margin entry হবে না। BG Register update করবেন। Bank commission বা actual processing charge থাকলে সঠিক item দিয়ে আলাদা payment record হবে।
C. Tender Security release
| Field | Value |
|---|---|
| Form | Receipt |
| Item | TS Margin Release |
| Account | 1130 Tender Security Margin |
| Unit | Instrument |
| Ref. | same PE-TenderID |
Dr 1010 Bank
Cr 1130 Tender Security Margin
21. Performance Security এবং BG Commission
Cash margin block
| Field | Value |
|---|---|
| Form | Payment |
| Item | PS Margin Cash Block |
| Account | 1140 Performance Security Margin |
| Unit | Instrument |
| Ref. | PE-TenderID |
[VERIFIED] 1140 asset account কারণ Performance Security cash margin contractor-এর resource, যদিও সেটি এখন temporarily blocked।
BG Commission
[STATED] Commission-এর treatment duration এবং approved accounting policy দেখে ঠিক হবে:
- Short-period commission:
PS BG Commission - Direct→ 5710 BG Commission Expense - Multi-period commission:
PS BG Commission - Prepaid Initial→ 1300 Prepaid BG Commission, followed byPS BG Commission - Monthly Amortization→ 5710
[STATED] কোন method ব্যবহার করবেন তা organization-এর approved policy এবং supporting document ছাড়া অনুমান করবেন না।
22. Mobilization Advance পেলেন
| Field | Value |
|---|---|
| Form | Receipt |
| Item | Mobilization Advance Received |
| Account | 2100 Mobilization Advance Received |
| Unit | Advance |
| Ref. | PE-TenderID |
Dr 1010 Bank
Cr 2100 Mobilization Advance Received
[VERIFIED] 2100 liability কারণ টাকা এলেও কাজের revenue তখনো earn হয়নি; RA Bill-এর recovery line দিয়ে advance কমবে।
Control
[STATED] Final RA Bill-এর পরে ওই tender-এর Mobilization Advance balance শূন্য হওয়া উচিত। অশূন্য থাকলে contract deduction schedule এবং ledger review করুন।
23. Site material, labor, subcontractor
| ঘটনা | Form | Use item | Account | Project | Ref. |
|---|---|---|---|---|---|
| Cement/material bill | Purchase Invoice | Matching material item, e.g. Cement, MS Rod - 500W, Sand |
5000 | Yes | No |
| Site labor cash | Payment | Matching labor item, e.g. Mason Labor, Skilled Labor |
5010 | Yes | No |
| Equipment rental/fuel | Payment or Purchase Invoice | Matching equipment item, e.g. Equipment Rental, Diesel - Equipment |
5030 | Yes | No |
| Subcontractor bill | Purchase Invoice | Approved subcontractor item/process | 5020 | Yes | No |
[VERIFIED] এগুলো site P&L activity। তাই সঠিক Project select করাই মূল কাজ।
24. RA Bill: net amount এক line-এ নয়
RA Bill-এর net payment দেখলেই সব বোঝা যায় না। Gross work, Retention এবং Mobilization recovery আলাদা না রাখলে report-এ সত্যিটা হারিয়ে যায়।
Sales Invoice header
| Field | কী দেবেন |
|---|---|
| Customer | PE office Customer |
| Project | Awarded Project |
| Cert. No. | Approved certificate number, if used |
Example structure
ধরা যাক certified work BDT 15,00,000। Retention BDT 1,50,000। Mobilization recovery BDT 3,00,000।
| Line | Item | Account | Amount | Tender identity |
|---|---|---|---|---|
| Certified work | Approved revenue item/process | 4000 Contract Revenue | +15,00,000 | Project |
| Retention withheld | Retention Withheld |
1150 Retention Receivable | -1,50,000 | Invoice Customer + Project; no Ref. line |
| Mob advance recovery | Mobilization Advance Recovery |
2100 Mobilization Advance | -3,00,000 | Invoice Customer + Project; no Ref. line |
Gross work 15,00,000
Less: Retention (1,50,000)
Less: Advance recovery (3,00,000)
------------------------------------
Net payable by PE 10,50,000
[STATED] Sales Invoice-Line Ref. = NO. এই policy বদলাতে হলে SOP update ও local UI validation লাগবে।
PE টাকা পাঠালে
Receipt খুলুন এবং invoice select করে settle করুন।
[VERIFIED] Invoice settlement Receipt-এ Project বা Ref. দ্বিতীয়বার দেবেন না; original invoice context বজায় থাকে।
25. Retention release
DLP/release condition পূরণ হলে PE retention দেয়।
| Field | Value |
|---|---|
| Form | Receipt |
| Item | Retention Release |
| Account | 1150 Retention Receivable |
| Unit | Bill |
| Ref. | PE-TenderID |
Dr 1010 Bank
Cr 1150 Retention Receivable
[VERIFIED] এটি নতুন Revenue না। পুরনো receivable cash-এ বদলে গেল।
26. Time Loan
Monthly interest / bank statement adjustment
| Field | Value |
|---|---|
| Form | Payment or approved adjustment method |
| Item | Time Loan Monthly Adjustment |
| Account | 5700 Interest on Time Loan |
| Unit | Month |
| Project | blank |
| Ref. | blank |
Dr 5700 Interest on Time Loan
Cr 1010 Bank
[VERIFIED] Time Loan interest সবসময় untagged।
Principal drawdown / repayment
[STATED] Bank statement-এ principal movement পরিষ্কার দেখা গেলে Time Loan Cash Movement item এবং approved method দিয়ে 2300 Time Loan record করা যায়। একটি নির্দিষ্ট tender-এর সঙ্গে সম্পর্ক documented হলে Ref. ব্যবহার করুন; না হলে unsupported split করবেন না।
Reconciliation
[STATED] Management বা audit request এলে bank statement-এর closing loan balance এবং Manager.io 2300 balance compare করুন। Difference থাকলে approved two-sided adjustment দিন এবং bank statement reference রাখুন।
27. Bank transfer, bank charge, office overhead
Bank-to-bank transfer
[VERIFIED] Native Inter Account Transfer form ব্যবহার করুন। Journal Entry বা separate Payment/Receipt দিয়ে bank transfer বানাবেন না।
General bank charge
| Form | Item | Account | Unit | Project / Ref. |
|---|---|---|---|---|
| Payment | Bank Charge - General |
5720 | Fee | both blank |
Office-wide expense
[STATED] Office rent, admin salary, trade licence, utility বা company-wide overhead tender-specific না হলে Project/Ref. দেবেন না।
PART 6 — মাস শেষের 20 মিনিট
28. Month-end checklist
[ ] 1. 5000–5030: কোনো site P&L line-এ Project blank আছে?
[ ] 2. 1130/1140/1150/2050/2100/2300: tender-specific standalone line-এ Ref. blank আছে?
[ ] 3. 1150 Retention: পুরনো balance-এর follow-up list আছে?
[ ] 4. 2100 Advance: deduction schedule-এর সাথে balance মেলে?
[ ] 5. 5700 Time Loan Monthly Adjustment: bank statement অনুযায়ী post হয়েছে?
[ ] 6. BG Register: expiry/release date review হয়েছে?
[ ] 7. Project completed + retention settled? Project Inactive হয়েছে?
[ ] 8. 5টি active Project sample check: Customer Code = Project PE CODE?
[ ] 9. New material/labor/equipment item দরকার হয়েছিল? Duplicate check ছাড়া কোনো item create হয়েছে কি?
ভুল পেলে কী করবেন
| কোথায় ভুল | প্রথম কাজ |
|---|---|
| Site cost-এ Project blank | source invoice/payment দেখে correct Project নির্ধারণ করুন |
| Tender-specific BS line-এ Ref. blank | source tender/PE দেখে correct Ref. দিন |
| Old Retention balance | DLP, certificate, PE follow-up status দেখুন |
| 2100 balance অস্বাভাবিক | advance receipt ও RA recovery schedule মিলান |
| Customer/Project code mismatch | Project save করার আগে approved source দেখে correction করুন |
| Item not found / wrong item suspected | Non-inventory Items_14-AUG-26.md দেখে item name/unit/account মিলান; duplicate create করবেন না |
[STATED] Source document ছাড়া guess করে Project, Ref., Contract Value, Retention Rate বা item/account mapping edit করবেন না।
PART 7 — BG Register
29. BG Register কেন আলাদা?
[VERIFIED] BG face value ledger-এ ওঠে না, কিন্তু expiry মিস হলে operational risk তৈরি হয়। তাই BG Register আলাদা রাখুন।
Redacted BG Register template
| BG Number | Type | Issuing Bank | Face Value | Issue Date | Expiry Date | PE Code | Tender ID | Status | File Reference |
|---|---|---|---|---|---|---|---|---|---|
| BG-XXXX | Tender / Performance | Bank name | [amount] | YYYY-MM-DD | YYYY-MM-DD | LGED-BSL | 1142857 | Active / Released | document path |
Review rule
[STATED] Month-end-এ register খুলুন। Expiry, extension, release এবং original BG document location confirm করুন। Contract-required renewal timing source document দেখে follow করবেন।
PART 8 — Advanced cases
এই অংশ প্রতিদিনের entry-এর জন্য নয়। যখন ঘটনাটি সত্যি ঘটে, তখন source paper নিয়ে supervisor/authorized accountant-এর সঙ্গে entry দিন।
30. Disputed claim
[STATED] PE যদি submitted amount-এর চেয়ে কম certify করে এবং আপনি difference formally contest করেন, disputed part আলাদা tracking দরকার হতে পারে।
- Account concept: 1160 Disputed Claims Receivable
- Tender identity: Ref.
- Supporting evidence: certified bill, claim letter, PE correspondence
[STATED] Claim approved, partly approved, বা rejected হওয়ার আগে amount বা treatment অনুমান করবেন না।
31. BG forfeiture
[STATED] PE BG/cash margin encash করলে entry দেওয়ার আগে encashment notice, bank debit advice এবং contract basis দেখুন।
- Margin release নয়—margin loss/settlement হতে পারে
- Project-related loss account প্রযোজ্য হতে পারে
- Margin account clear করার সময় Ref. লাগবে
- Bank যদি liability তৈরি করে, approved liability account ব্যবহার হবে
[STATED] এটি exceptional entry; operator নিজে policy choose করবেন না।
32. Equipment allocation
[STATED] একই equipment অনেক Project-এ ব্যবহার হলে approved usage log/rate অনুযায়ী month-end allocation করা যায়।
- Debit: 5030 Equipment Allocation with Project
- Credit/offset: approved internal allocation method
[STATED] Usage log, rate approval, এবং period ছাড়া allocation দেবেন না। Equipment Rental বা Diesel - Equipment item only real rental/fuel cost-এর জন্য; internal allocation-এর substitute নয়।
33. Subcontractor advance and retention
| ঘটনা | Basic treatment | Tender identity |
|---|---|---|
| Subcontractor advance | 1200 Subcontractor Advances | Ref. when standalone Balance Sheet movement |
| Subcontractor bill | 5020 Subcontractor Cost | Project |
| Subcontractor retention withheld | 2050 Subcontractor Retention Payable; item Retention Subcontractor Withheld |
Ref. when Balance Sheet line needs tender identity |
[VERIFIED] Supplier/subcontractor cost কোন Project-এর, তা P&L line-এর Project দিয়ে বোঝা যাবে।
PART 9 — 15-second desk card
NOA এসেছে?
→ Customer আছে কি দেখুন
→ না থাকলে Customer create করুন
→ Project create করুন
→ Customer Code = Project PE CODE, exact match
Site material / labor / equipment / subcontractor cost?
→ Correct non-inventory item select করুন
→ Project দিন
→ Ref. দেবেন না
Tender-specific standalone margin / retention / advance / loan movement?
→ Correct security/retention/advance item select করুন
→ Ref. = PE-TenderID
Sales Invoice?
→ Correct RA Bill item select করুন
→ Project yes; Ref. line no
Time Loan Monthly Adjustment?
→ Correct item select করুন
→ no Project, no Ref.
Tender এখনো awarded হয়নি?
→ no Project; Tender Doc item + Ref. = PE code only
Common mistakes
| ভুল | সঠিক কাজ |
|---|---|
| Award-এর পরে Customer না দেখে Project খোলা | Customer check/create + Project একই সময়ে করুন |
LGED-BSL এবং LGED-PTK-কে এক Customer ধরা |
আলাদা office হলে আলাদা Customer |
| Customer Code ও Project PE CODE আলাদা লেখা | হুবহু same value copy করুন |
| Customer Name-এ Tender ID লেখা | Tender ID Project Name এবং Ref.-এ রাখুন |
| Pre-NOA-তে dummy Project খোলা | NOA পর্যন্ত Project blank |
| Sales Invoice line-এ Ref. লেখা | Final policy: Ref. line = NO |
| BG-only face value-কে 1130 cash margin হিসেবে entry দেওয়া | BG Register update করুন; only actual cash margin/commission entry দিন |
| ভুল unit/item বেছে নেওয়া | 14-AUG item catalog থেকে item name, account, unit মিলান |
| Duplicate item নিজে create করা | আগে item list/search দিয়ে duplicate check করুন |
| Retention release-কে Revenue বলা | 1150 receivable থেকে Bank-এ receipt |
| Mobilization Advance-কে income বলা | 2100 liability ব্যবহার করুন |
| Time Loan interest/adjustment tag করা | Project এবং Ref. দুটোই blank |
| Bank transfer JE দিয়ে করা | Inter Account Transfer ব্যবহার করুন |
NotebookLM / Slidedeck instruction
এই file NotebookLM-এ upload করার পরে prompt দিন:
Create a brand-neutral training slide deck for Bangladesh e-GP contractors using Manager.io. Write in natural conversational Bangla with only essential English software labels. Do not translate every English word. Begin with PE office, Tender ID, NOA, RA Bill, Retention, Mobilization Advance and BG. Make the central slide: “NOA day = Customer (if missing) + Project at the same time; Customer Code must exactly match Project PE CODE.” Explain Project vs Ref. only after the e-GP story. Keep Sales Invoice-Line Ref. as NO. Include a practical non-inventory item section: Tender Doc - Submission Fee, TS Margin Cash Block, PS Margin Cash Block, Mobilization Advance Received, Retention Withheld, Retention Release, Time Loan Monthly Adjustment, Cement, Mason Labor, Equipment Rental, and Bank Charge - General. Show the correct account, unit, Project/Ref rule for each example. Use fictional examples only. Never include API keys, passwords, internal URLs, actual account numbers, live project values, UUIDs, or confidential data.
FINAL DECISIONS LOG
| Decision | Status |
|---|---|
| Brand-neutral cover | [STATED] Locked |
| Audience: e-GP fluent, software-ready, debit/credit optional | [STATED] Locked |
| Natural Bangla + essential English terms; not translation | [STATED] Locked |
| e-GP glossary before Manager architecture | [STATED] Locked |
| On award: Customer if missing + Project at same time | [STATED] Locked |
| Customer.Code must equal Project.PE CODE | [STATED] Locked |
| One PE office Code can hold many Projects | [STATED] Locked |
| Sales Invoice-Line Ref. = NO | [STATED] Locked |
| Pre-NOA bid fee: no Project; PE-only Ref. allowed | [STATED] Locked |
| 5700 Time Loan Monthly Adjustment untagged | [VERIFIED] Locked |
| Non-inventory item names/units follow 14-AUG-26 catalog | [VERIFIED] Locked for this SOP version |
GAPS
- [VERIFIED] AIT/VDS tax workflow is excluded until related accounts and approved tax engine are provisioned.
- [STATED] The source item export contains a repeated
Brick Chipping Costrow and a repeatedSand Carrying Costrow; this SOP lists each operational item once and does not decide whether the live duplicates need deactivation. - [STATED] The item export labels
TS Margin BG Partial Blockunit asUnitName; confirm this exact unit in live Manager.io before operator use. Do not silently change the catalog field. - [STATED] Verify any material/labor/equipment item is not a duplicate before creating or modifying it in the live item list.
- [STATED] Add redacted local UI screenshots only after the text workflow is accepted; screenshots must not expose internal URLs, credentials, bank details, tender values or API data. [IP RISK]
- [STATED] Before wide rollout, run one operator acceptance test: NOA → Customer + Project → material purchase → RA Bill → Mobilization Advance → Retention Release.
NEXT MOVE
- Treat this v2.2 FINAL — 14-AUG-26 Item-Aware file as the updated operator SOP source.
- Keep
Non-inventory Items_14-AUG-26.mdbeside it as the item catalog reference; do not replace it with a theme file. - Run the operator acceptance test using the listed item names and units.
- Before any live item creation/update, verify duplicates in Manager.io and obtain explicit confirmation for the write action.