Talent Bridge Hub offers a comprehensive Practical Accounting with ERP Training program designed to equip participants with essential accounting skills integrated with ERP (Enterprise Resource Planning) systems.

Practical Accounting with ERP:

Course Module:

AF Modules:

1. Chart of Accounts

MGP - Application of Fund (Assets)

MGP - Source of Fund (Equity and Liabilities)

MGP – Income (Revenue)

MGP – Expenses

1. MGP = Main Group of Chart of Accounts

1. Master Data Recording System:
2. Customers
3. Suppliers
4. Products
5. Employees
6. Common Transaction Recording System
7. Journal
8. Sales Invoice
9. Purchases Invoice
10. Receives’
11. Payments
12. Fund Transfer
13. Balance Transfer

1. MIS Report Generating.
2. Day Book Report
3. Sales Report
4. Sales Report by Assignee
5. Trial Balance
6. Statement of Profit and Loss Accounts
7. Statement of Financial Position
8. Statement of Cash Flow

Human Resource Management (HRM) Module:

1. Employees Register
2. Name
3. Designation
4. Employee Type
5. Job Grade
6. Employee Photo
7. Religious
8. Joining Date
9. Salary Profile
10. Tax Area
11. Salary Bank Transfer
12. Exist Type: (Resignation, Retirement, Instant Release, Termination.

Payroll Module:

1. Salary Configuration
2. Salary Profile as per individual Employee
3. Salary Structure as per individual Employee
4. Tax Configuration as per individual Employee

Session 01.

How to create COA and record in the ERP2ALL?

Preparation of Chart of Accounts in ERP System:

MGP - Application of Fund (Assets)

MGP - Source of Fund (Equity and Liabilities)

MGP – Income (Revenue)

MGP – Expenses

Application of Fund (Assets)

MGP- Current Assets

MGP – Non- Current Assets

MGP- Current Assets:

SGP – Cash

1. L- Main Cash
2. L- Petty Cash

SGP – Bank

1. L- Islami Bank PLC
2. L- Bank Asia PLC

SGP – Inventory

1. L- Materials
2. L- Work in Process
3. L- Finished Goods

SGP – Accounts Receivable

SGP- Debtors Control Accounts

L- Customers Name (Its to be created under Master Data)

SGP – Allowance for Doubtful Accounts

MGP- Non Current Assets:

SGP- Building and Land Development

L- Land Development

L - Building

SGP – Motor Vehicles

L- Micro Buss –Kha-0909

L- Private Car –gha-90890

SGP – Computers and Printers

L- Desktop -01

L- Laptop 01

L – Canon Printers

Session 02

Source of Fund (Equity and Liabilities):

MGP – Current Liability:

SGP1 – Accounts Payable

SGP2- Credit Control Accounts

L- (all Suppliers will be under credit control accounts as per suppliers group)

SGP2- Loan Payable:

SGP1- Accrued Expenses:

L – Salary Payable

L – Commission Payable

SGP1 – Inter-Company Loan

L- ABC Company Ltd

L- XYZ Ltd

MGP – Owners Equity

MGP1- Paid up capital

L- Mr. Chowdhury (MD)

L – Mr. Khan (Director)

MGP – Revenue (Income)

SGP1 – Direct Income

L – Income from Sales

L – Agency commission

SGP1 – Indirect Income

L- Interest Income

MGP- Expenses

SGP1- Director Cost

L-Purchases

L- Cost of Goods/Services Sold

SGP1 – Indirect Expenses:

SGP2- Administrative Expenses

L- Executive Staff Salary

L – Non Executive Staff Salary

L- Office Rent

L- Conveyance Allowances

SGP2 – Marketing and Promotional Expenses

L- Salary Allowance (Mkt officials)

L- Promotional Expenses

L- Travel Allowances

SGP2 – Financial Expenses:

L – Bank Charges

L – Bank Interest

Session 03

Master Data Recording System:

1. Customers
2. Suppliers

Navigation Menu: Customers

How to create Customer with Details information?

Customers:

1. Add new
2. Details
3. Default
4. Credit Control
5. Bank information

Note: Practice with some real example.

Navigation Menu: Suppliers

How to create Suppliers with Details information?

Suppliers:

1. Add new
2. Details
3. Default
4. Credit Control
5. Bank information

Note: Practice with some real example.

Session 04

Master Data Recording System:

1. Products
2. Employees

Navigation Menu: Products

How to create Product with Details information?

Products:

1. Add new
2. Details
3. Default Settings
4. Packing
5. Lead time

Note: Practice with some real example.

Navigation Menu: Employees (Payroll module)

How to create employees with Details information?

1. Employee name
2. Employee Gender
3. Designation
4. Employee Type (Need to create group from global configuration)
5. Blood Group
6. Phone No
7. Email
8. Joining Date
9. Leave profile
10. Date of Birth
11. Tax Area
12. Bank information
13. Exit Type

Session 05

Navigation menu: (Payroll module)

Salary Configuration:

1. Basic Salary Amount>Fixed Value>Amount>Effective from>Save.
2. House Rent Allowance>Fixed Value>Amount>Effective from>Save.
3. Medical Allowance>Fixed Value>Amount>Effective from>Save.
4. Travel Allowance >Fixed Value>Amount>Effective from>Save.

Salary Heads:

1. Basic Salary Amount>Earning>Monthly>Ledger (Executive Staff Salary/Non Executive staff Salary>Is basic> in Gross>in Regular>save
2. House Rent Allowance>Earning>Monthly>Ledger (Executive Staff Salary/Non Executive staff Salary>in Gross>in Regular>save
3. Medical Allowance>Earning>Monthly>Ledger (Executive Staff Salary/Non Executive staff Salary>in Gross>in Regular>save
4. Travel Allowance >Earning>Monthly>Ledger (Executive Staff Salary/Non Executive staff Salary>in Gross>in Regular>save

Tax Configuration:

Exemptions:

Either 33.33% of gross or 4,50,000 whichever is lower.

Tax Rule for PF

1. Employees contributions (Tax Exempted)
2. Employers Contributions (Taxable)

Calculation of Max Investment Limit:

1. 20% of Total Taxable Income or 1.00 Crore whichever is Lower.

Tax Rebate for Investment:

1. 3% of Taxable Income or 15% of Total Investment or 10 Lakh whichever is lower.

Other’s annualized heads:

1. Salary Heads
2. Area wise minimum Tax Liability
3. Tax Slab for Men
4. Tax Slab for women
5. Tax Slab for Senior citizen

Session 06

Navigation menu: Transactions:

Journals:

1. General Journal
2. Adjusting Journal
3. Depreciation Journal
4. Amortization Journal
5. Salary Journal (If we don’t Payroll module)
6. Closing Journal
7. Transfer Journal
8. Raw Material Issue Journal
9. Finished Goods Transfer Journal

Sales Invoice:

1. Customer Name
2. Date, Reference, assignee
3. Products
4. Description>Unit>Unit Price>discount (if any)>Ledger>Tax Code>Allocation (In case of warehouse maintaining)
5. Delivery Details
6. Payment Details
7. Installments

Purchases Invoice:

1. Supplier Name
2. Date, Reference, assignee
3. Products
4. Description>Unit>Unit Price>discount (if any)>Ledger>Tax Code>Allocation (In case of warehouse maintaining)
5. Warehouse (In case of stock maintain)
6. Product Specifications
7. Payment Details
8. Installments

Session 07

Navigation menu: Transactions:

Receives:

1. Receive from Customers
2. Receive from on account/advance
3. Receive from Others
4. Receive from Suppliers / Refund
5. Receive from employee

Payments:

1. Payment to suppliers
2. Payments on Account / Advance
3. Payment to Others
4. Payment to Customer / Refund
5. Petty Cash
6. Advance to Employee
7. Payment to Employee

Fund Transfer:

1. Cash Withdrawal
2. Cash Deposit
3. Bank Transfer
4. Cash Transfer

Balance Transfer:

1. Customer to Supplier
2. Supplier to customer
3. Employee advance to payable

Session 08,09,10,11,12 (Continuing Practice)

Jul-24

1-Jul-24

Cash Loan Tk. 50,000 from Mr. Khan to meet Organizational Expenses

2-Jul-24

The have applied to form a limited company to RJSC and paid 20,000Tk. As registration and others fees (Preliminary Expenses)

5-Jul-24

Open a Bank Account with Islami Bank Ltd (A/c # 9890) in the name of ABC Footwear Ltd by depositing 10,000.

10-Jul-24

Apply and Taken IRC (Licenses) in the name of ABC Footwear Ltd. The total expenses to take IRC Tk. 20,000 (Preliminary Expenses)

10-Jul-24

Company received 100,00,000 from each director as paid up capital against 100,000 Shares respectively.

10-Jul-24

Advance paid to Wings4 Property Management Tk. 5,00,000 as advance against office rent at Banani. Monthly Rent 30,000 excluding VAT and Tax. The rent agreement will effective from 1st July 2024.

25-Jul-24

Purchases a Desktop 01 Tk. 50,000, Laptop 01 Tk. 80,000 and Printers_Canon 02 Tk. 25,000 from Smart Computers Ltd. Excluing 15% VAT on All items.

20-Jul-24

Purchases Delivery Van # Gha-99-8877 for the amount of 20,00,000 and Staff Car # Ga-77-6655 for the amount of Tk 30,00,000 from Runner Motors Ltd.

30-Jul-24

Paid Tk. 50,000 to Smarts Computers Ltd their outstanding as partial payment. .

31-Jul-24

Provision for office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

31-Jul-24

Create the Purchases Invoice against office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

Aug-24

1-Aug-24

Open an Import L/c (Import LC # 7865342) with Islami Bank Ltd in the name of Dibang Footware, China for the value of 50,00,000 (Fifty Lac) for 5000 Pairs Mens shoe Tk as 100% cash Margin.

7-Aug-24

Paid to the Balance Amount to Smart Computers Ltd.

15-Aug-24

Received 5000 Pairs Mens Shoes from China against import LC from Dibang Footwear, China

25-Aug-24

Paid to RS Trading (C & F Agent) Tk. 2,00,000 as Advance against Customs duty, Customs Clearance, Trasportations and others)

30-Aug-24

Cash Withdrawn 10,00,000 to meet operational expenses from Islami Bank Ltd

31-Aug-24

Landed Cost till warehouse Total 5,00,000 (Five Lakh) taka (In this case we will considar that the landed cost will impose directly into L/C Value. (No need to considard cost center here due to it only trading company not manufacturing company) which will to be paid to RS Trading (C & F Agent)

31-Aug-24

Provision for office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

31-Aug-24

Provison for Staff Salary and Allowances for the amount of 1,20,000 against 4 officials. The salaries Amount of Mr. Sumon, Sales Executive Tk. 25,000, Mr. Zamil Ahmed, Manager (Accounts and Finance) Tk. 50,000, Mr. Mahfuz, Executive (Accounts) Tk. 25,000, Mamun, Office Assistant Tk. 20,000. (TDS on Zamil Ahmed Salary Tk. 500).

Sep-24

1-Sep-24

Sales Mens Shoe 2000 Pairs@2500 total 50,00,000 to XYZ company Ltd on credit excluding VAT 15% & Tax 3%

5-Sep-24

Paid to Staff Salaries for the amount of Tk. 1,20,000 through Bank.

7-Sep-24

Rent Paid to Wigns4 Property Management after deducting VAT 15% & 5% Tax.

10-Sep-24

Paid to RS Trading (C & F Agent) the rest of Balance Tk. 3,00,000 (Three Lakh) only.

15-Sep-24

XYZ Company Ltd has deducted 3% Tax from the Sales Value and Send us the Treasury Challan of payment to Govt.

15-Sep-24

TDS (Salary Tax) Tk 5,000 Paid to Govt through Treasury Challan.

30-Sep-24

Received Tk 56,00,000 (Fifty Six Lakh) aginst Sales Receiable through Bank including VAT amount after deducting 3% Tax.

30-Sep-24

Deducted VAT Balance has paid to Govt (if the client doesn’t deduct).

30-Sep-24

Provison for Staff Salary and Allowances for the amount of 1,20,000 against 4 officials. The salaries Amount of Mr. Sumon, Sales Executive Tk. 25,000, Mr. Zamil Ahmed, Manager (Accounts and Finance) Tk. 50,000, Mr. Mahfuz, Executive (Accounts) Tk. 25,000, Mamun, Office Assistant Tk. 20,000. (TDS on Zamil Ahmed Salary Tk. 500).

30-Sep-24

Provision for office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

Oct-24

7-Oct-24

Paid to Staff Salaries for the amount of Tk. 1,20,000 through Bank.

7-Oct-24

Rent Paid to Wigns4 Property Management after deducting VAT 15% & 5% Tax.

3-Oct-24

Delivery Expenses 20,000

4-Oct-24

Conveyance Expenses (Mkt) 10,000

6-Oct-24

Packing Expenses 35,000

10-Oct-24

Sales Mens Shoe 1500 Pairs@2500 total 37,50,000 to M/s Azad Traders on credit excluding VAT 15% & Tax 3%

30-Oct-24

Received Tk 37,50,000 (Thirty Seven Lakh)and Fifty Thousand only) aginst Sales Receiable through Bank including VAT amount after deducting 3% Tax.

31-Oct-24

Provision for office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

31-Oct-24

Provison for Staff Salary and Allowances for the amount of 1,65,000 against 5 officials. The salaries Amount of Mr. Sumon, Sales Executive Tk. 25,000, Mr. Zamil Ahmed, Manager (Accounts and Finance) Tk. 50,000, Mr. Mahfuz, Executive (Accounts) Tk. 25,000, Mamun, Office Assistant Tk. 20,000. (TDS on Zamil Ahmed Salary Tk. 5,000).

Nov-24

1-Nov-24

Open an Import L/c (Import LC # 7865342) with Islami Bank Ltd for the value of 1,00,00,000 (One Crore Only) for 10,000 Pairs Mens shoe Tk as 100% cash Margin.

7-Nov-24

Paid to Staff Salaries for the amount of Tk. 1,20,000 through Bank.

7-Nov-24

Rent Paid to Wigns4 Property Management after deducting VAT 15% & 5% Tax.

10-Nov-24

Sales Mens Shoe 1500 Pairs@2700 total 40,50,000 to M/S Zihan Footwear on credit excluding VAT 15% & Tax 3%

25-Nov-24

Received Tk 37,50,000 (Thirty Seven Lakh)and Fifty Thousand only) aginst Sales Receiable from M/s Azad Traders through Bank including VAT amount after deducting 3% Tax.

30-Nov-24

Provision for office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

30-Nov-24

Provison for Staff Salary and Allowances for the amount of 1,65,000 against 5 officials. The salaries Amount of Mr. Sumon, Sales Executive Tk. 25,000, Mr. Zamil Ahmed, Manager (Accounts and Finance) Tk. 50,000, Mr. Mahfuz, Executive (Accounts) Tk. 25,000, Mamun, Office Assistant Tk. 20,000. (TDS on Zamil Ahmed Salary Tk. 5,000).

Dec-24

7-Dec-24

Paid to Staff Salaries for the amount of Tk. 1,20,000 through Bank.

7-Dec-24

Rent Paid to Wigns4 Property Management after deducting VAT 15% & 5% Tax.

25-Dec-24

Received Tk 40,50,000 (Forty Lakh Fifty Thousand only)aginst Sales Receiable from M/s Zihan footwear through Bank including VAT amount after deducting 3% Tax.

30-Dec-24

Provision for office Rent at the end of month 30,000 Tk & VAT 15% on the Rent amount.

31-Dec-24

Provison for Staff Salary and Allowances for the amount of 1,65,000 against 5 officials. The salaries Amount of Mr. Sumon, Sales Executive Tk. 25,000, Mr. Zamil Ahmed, Manager (Accounts and Finance) Tk. 50,000, Mr. Mahfuz, Executive (Accounts) Tk. 25,000, Mamun, Office Assistant Tk. 20,000. (TDS on Zamil Ahmed Salary Tk. 5,000).