Marg ERP 9+
The Business Backbone.
Accounting Software
Basic concept of accounting
Accounting : It is an art of recording, classifying and summarising in
significant manner and in terms of money, transactions and events which are of
financial character and interpreting the results thereof.
Business Transaction : A business transaction is “The movement of money and money’s worth
form one person to another”. Or exchange of values between two parties is also
known as “Business Transaction”.
Purchase : A purchase
means goods purchased by a businessman from suppliers.
Sales : Sales is goods
sold by a businessman to his customers.
Purchase Return or Rejection in or Outward Invoice : Purchase
return means the return of the full or a part of goods purchased by the businessman
to his suppliers.
Sales Return or Rejection out or Inward Invoice : Sales
return means the return of the full or a part of the goods sold by the customer
to the businessman.
Assets : Assets are the things and properties possessed by a businessman not
for resale but for the use in the business.
Liabilities : All the
amounts payable by a business concern to outsiders are called liabilities.
Capital : Capital is the
amount invested for starting a business by a person.
Debtors : Debtor is the
person who owes amounts to the businessman.
Creditor : Creditor is
the person to whom amounts are owed by the businessman.
Debit : The receiving
aspect of a transaction is called debit or Dr.
Credit : The giving
aspect of a transaction is called credit or Cr.
Drawings : Drawings are the amounts withdrawn (taken back) by the businessman
from his business for his personal, private and domestic purpose. Drawings may
be made in the form cash, goods and assets of the business.
Receipts : It is a document issued by the receiver of cash to the giver of
cash acknowledging the cash received voucher.
Account : Account is a summarised record of all the transactions relating to
every person, everything or property and every type of service.
Ledger : The book of
final entry where accounts lie.
Journal entries:
A daily
record of transaction.
Trail Balance : It is a statement of all the ledger account balances prepared at
the end of particular period to verify the accuracy of the entries made in
books of accounts.
Profit : Excess of
credit side over debit side.
Profit and
loss account: It
is prepared to ascertain actual profit or loss of the business.
Balance Sheet : To ascertain the financial position of the business. It is a statement of assets and liabilities.
Types of accounts
Personal account: Personal accounts are the accounts of persons, firms, concerns and
institutions which the businessmen deal.
Principles: Debit the receiver Credit the giver
Real Account: These are the accounts of things, materials, assets & properties.
It has physical existence which can be
seen & touch.
Ex. Cash,
Sale, Purchase, Furniture, Investment etc.
Principles: Debit what comes in Credit what
goes out
Nominal
account: Nominal account is the account of services received
(expenses and Losses) and services given (income and gain)
Ex. Salary,
Rent, Wages, Stationery etc.
Principles: Debit all
expense/losses Credit all income/ gains
Gateway of Marg ERP-Accounts info-Group
- Bank account
- Bank Od account
- Branch/division
- Capital account
- Cash in hand
- Current asset
- Current liability
- Deposit
- Direct expenses
- Direct income
- Indirect expense
- Indirect income
- Duties and tax
- Fixed asset
- Investment
- Loans and advance
- Loan (liability)
- Miscellaneous expenses
- Provisions
- Retained earning
- Reserves and surplus
- Purchase account
- Sales account
- Secured loan
- Stock in hand
- Sundry debtor’s
- Sundry creditors
- Suspense
- Unsecured account
Meaning:
Current asset:
It is
converted into cash within a year. Ex. Bills receivable
Direct expenses : These are the expenses which are directly related to manufacturing
of goods. Ex. Wages, factory rent, heating, lighting etc
Indirect expense : These
are the expenses which are indirectly related to manufacturing of goods. Ex.
Salary, rent, stationery, advertisement, printing
Depreciation: Decrease the value of the
asset.
Sundry debtors:
The person
who is the receiver or customer
Sundry creditors: The person who gives or
supplier.
Expenses Outstanding or Unpaid expenses or Expenses due: Expenditure incurred during
current year but the amount on which is not yet paid. (Added to the expenditure
on the debit side and entered on the liability side.)
Income received in advance or
Income received but not earned
Income received
during the current year but not earned or a part of which relates to the next
year. (Deducted from the concerned income on the credit side and entered on the
liability side)
Prepaid advance or Expenses or
Prepaid expenses
Expenditure paid during current year but not incurred or a part of
which relates to the next year is called expenditure prepaid. (Deducted from
the concerned expenditure on the debit side and entered on the assets side)
Income outstanding or income
earned but not received or Income accrued
Income outstanding means income earned during the current year but the amount on which is not yet received (added to the concerned income on the credit side and entered on the asset side)
Company creation process
NOTE: If You open Marg software caps lock will be automatically on.
·
Click on F2
Button
·
Click on Create
New company
Business Type: Choose as
your business is.
Password: To keep
password for different company.
Date Type: Choose Bikram
Samwat for Nepali Date.
While making a new company
a. Create New Company: To create new company.
b. Restore Default Demonstration: To restore demo
company.
c. Restore from My Demonstration: To restore your backup
company.
d. Delete Saved Password: To delete password of your
software.
e. Change Operator Powers: To make operate id and
password to login to software.
f.
Change ERP
Version: To change ERP version. GOLD, SILVER, BASIC & EDUCATION.
How to open company?
F
Open the Marg ERP
Program
F
Choose the select
company
F
Press Enter
F
Marg Gateway
F
Enter
How to Modify and Delete
the company?
F
Open the Marg ERP
Program
F
Choose the select
company
F
Press Enter
F
Delete Financial
Year
F
Choose Financial
Year if there is more than one
F
Enter until
Confirm window
F
Type “Delete”
there.
Note:
there will be auto Backup while you are deleting company.
How to Backup Financial Year Manually?
Marg ask Backup Automatically within 7 days if there
is no backup
F Open the Marg ERP Program
F Choose the select company
F Press Enter
F Backup of Financial Year
How to New Financial Year?
F Open the Marg ERP Program
F Choose the select company
F Press Enter
F New Financial Year
F Put your date.
How to Restore Backup?
F Open the Marg ERP Program
F Choose the select company
F Press Enter
F Restore Backup
F Restore from File
o if Your backup file is in
local Disk
F Restore from Marg Server
o If your Backup file is in
Server.
F Choose Your File and Click
on Restore
F Type Restore.
How to create ledger?
F
Masters Menu
F
Ledger Master
F
Ledger
F
New Ledger
F
First choose account
group
How to see ledger?
F Masters Menu
F Ledger Master
F
List of Account
F
View
How to edit the ledger?
F
Masters Menu
F
Ledger Master
F
Ledger
F
Modify Ledger
F
Choose Ledger
F
Press Enter or F3
F
Go to Ledger
Details
F
Click Below
Modify
How to delete the ledger?
F Masters Menu
F Ledger Master
F Ledger
F Modify Ledger
F Choose Ledger
F Press Enter or Delete
F Click Above Delete
F
Yes
How to Create Account
Group?
F Masters Menu
F Account Groups
F New Group
F Choose your Group
F Press Enter
F Type your New Group Name
F Enter Until Save
How to Edit Account
Group?
F Masters Menu
F Account Groups
F Modify Group
F Choose your Group
F Press Enter
How to Delete Account
Group?
F Masters Menu
F Account Groups
F Delete Group
F Choose your Group
F Press Enter
F Yes
Ledger
Group
Rs
Opening stock
Stock in hand
10000
Purchase
Purchase account
5000
Purchase return
Purchase account
2222
Fright charges
Direct expenses
12000
Carriage inwards or Purchases
Direct expenses
10000
Cartage and coolie
Direct expenses
1200
Octroi
Direct expenses
10000
Manufacturing wages
Direct expenses
12300
Coal, gas, water
Direct expenses
400
Oil and fuel
Direct expenses
500
Factory rent, insurance, electricity, lighting and heating
Direct expenses
5500
Sales
Sales account
1000
Salary
Indirect expenses
100
Postage and telegrams
Indirect expenses
200
Telephone charges
Indirect expenses
Rent paid
Indirect expenses
Rates and taxes
Indirect expenses
Insurance
Indirect expenses
Audit fees
Indirect expenses
Interest on bank loan
Indirect expenses
Interest on loans paid
Indirect expenses
Bank charges
Indirect expenses
Legal charges
Indirect expenses
Printing and stationery
Indirect expenses
General expenses
Indirect expenses
Sundry expenses
Indirect expenses
Discount allowed
Indirect expenses
Carriage outwards or sales
Indirect expenses
Traveling expenses
Indirect expenses
Advertisement
Indirect expenses
Bad debts
Indirect expenses
Repair renewals
Indirect expenses
Motor expenses
Indirect expenses
Depreciation on assets
Indirect expenses
Interest on investment received
Indirect income
Interest on deposit received
Indirect income
Interest on loans received
Indirect income
Commission received
Indirect income
Discount received
Indirect income
Rent received
Indirect income
Dividend received
Indirect income
Bad debts recovered
Indirect income
Profit by sale of assets
Indirect income
Sundry income
Indirect income
Loan from others
Loan Liabilities
Bank loan
Loan Liabilities
Bank overdraft
Bank OD
Bills payable
Current Liabilities
Sundry creditors
Sundry creditors
Mortgage loans
Secured loans
Expense outstanding
Current Liabilities
Income received in advance
Current Liabilities
Other liabilities
Current Liabilities
Capital
Capital account
Drawings
Capital account
Cash in hand
Cash in hand
Cash at bank
Bank account
Fixed deposit at bank
Deposit
Investments
Investments
Bills receivable
Current asset
Sundry debtors
Sundry debtors
Closing stock
Stock in hand
Stock of stationery
Current asset
Loose tools
Fixed asset
Fixtures and fittings
Fixed asset
Furniture
Fixed asset
Motor vehicles
Fixed asset
Plant and machinery
Fixed asset
Land and building
Fixed asset
Leasehold property
Fixed asset
Patents
Fixed asset
Goodwill
Fixed asset
Prepaid expenses
Current asset
Income outstanding
Current asset
Mix expenses
Indirect expenses
Deprecation
Indirect expenses
Bad debt
Indirect expenses
Telephone bill
Indirect expenses
Drinking water bills
Indirect expenses
Land
Fixed assets
Building
Fixed assess
Furniture
Fixed assets
Motor
Fixed assets
Loan from director
Loan
Loan from manager
Loan
Loan from accountant
Loan
Loan from others
Loan
Cash sales
Sales a/c
Sales account
Sales a/c
Pub pvt ltd
Sundry debtors
Db enterprise
Sundry debtors
Sanima bank Branch office Ithari
Branch and division
Sanima bank Branch office Dharan
Branch and division
Sanima bank ltd Inaruwa
Branch and divison
Sanima bank branch office Ktm
Branch and divison
Sanima branch office lahan
Branch and divison
Tax to government
Duties and tax
Vat
Duties and tax
Sales tax
Duties and tax
Receipt / payment voucher
How to entry receipt / payment / payment voucher?
F
Accounts
F
Voucher Entry
F
Receipt
F Payment
How to see cash / bank book report?
F
Book
F Cash / bank book
For receipt / Payment voucher
01-04 ABC company started business with cash at Rs.
10,00,000.
01-04 Bought furniture for office use at Rs. 50,000.
01-06 Bought computer at Rs. 35,000 for office use.
01-10 Commission received from ABC group at Rs. 30,000.
01-10 Bonus received from ABC Company at Rs. 10,000.
01-15 Rent paid to household at Rs. 5000.
01-18 Telephone bill paid at Rs. 2000.
01-20 Deposited cash at Rs. 20,000 for telephone.
01-20 Share investment in SKM company at Rs.
1,00,000.
01-20 Bought typewriter for Rs. 40,000.
01-25 Bought Printer for Rs.50,000.
01-25 Advertisement Bill paid Rs. 10,000.
Contra voucher
How to entry receipt / payment / payment voucher?
F
Accounts
F
Voucher Entry
F Contra
Cash deposited in bank
·
CR.
Cash a/c
·
DR. Name
of Bank a/c
Cash withdrew from bank
·
CR.
Name of Bank a/c
·
DR. Cash
a/c
Cash transfer bank to bank
·
CR. Name
of bank from transfer
· DR. Name of bank where you transfer
Problems:
1.
Cash Rs. 3,
00,000 deposited into Nubile bank.
2.
Cash Rs. 50,000
withdraws from Nubile bank cheque no 12244 for office use.
3.
Cash transfer
from Nubile bank to SBI Bank at Rs. 1,00,000 chquee no 23531.
4.
Cash deposit into
NCC bank at Rs. 1,00,000.
5.
Cash withdrew
from NCC bank at Rs. 25,000 for office use. Cheque no 339956
6.
Cash transfer
from NCC Bank to Nepal Bank at Rs. 50,000 chequee no 56666.
7.
Cash deposited
into Nepal Bank LTD Rs.1,00,000
8.
Cash withdrew
from NCC bank Rs.10,000 cheque no.5526
9.
Cash deposit Rs.5,00,000
into Global Bank.
10. Cash withdrew from Global bank Rs.200,000. according to cheque no. 8975
How to see reports of cash & bank
·
Book
·
Cash / bank book
· Choose the bank & press enter for details
Transaction
03-01 Sabin started
business with Rs 100000/-
03-02 Bought furniture at
Rs 30000/-
03-03 Bought typewriter at
Rs 5000/-
03-04 Cash Rs 300000
deposited into Nepal bank
03-05 Advertisement
exp. Paid of Rs 7000/- paid by Nepal
bank , cheque no 33399
03-06 Computer maintenance
charge Rs 3000/- paid
03-07 Cash
withdrew from Nabil bank for office use at Rs
50000 cheqee no 1332
03-08 Deposited for
telephone in Nepal telecom office at 10000/-
03-09 Rs 36000 withdrew
from proprietor his personal use by Nepal bank
cheque no 122554
03-10 Bought
motorcycle at Rs 130000 paid by Nepal bank cheque no 1256
03-11 Furniture Purchase at
Rs 4000
03-12 Bought share and investment in LIC Company at 100000
How to activate interest with ledger?
F
While Creating Ledger
F Put Interest Yearly.
F
If Interest is monthly convert to yearly n put there.
Interest calculation report
F
Interest Report
F
Ledger Interest
F
Single Party
F
Choose your
ledger
Interest Calculation Group:
·
Received
loan(loan &labilities)
· Give loan(loan & advance)
03-15 Give loan to sanu bahal Rs 100000 by 15% interest yearly
03-20 Loan received from kamala karki at Rs 70000 with 2%interest monthly
03-25 Give loan to mina subba at Rs 50000 with 18% interest yearly
03-14 Loan received from Anuja thapa Rs 40000 with 1% interest monthly
Mix Transaction:
03-01 Ramesh started a business with Rs 100000/-
03-02 Bought Computer at Rs 30000/-
03-03 Bought typewriter at Rs 5000/-
03-04 Cash Rs 300000 deposited into Agriculture Development Bank.
03-05 Advertisement exp. Paid of Rs 7000/- paid by Agriculture Development Bank, cheque
no 33399
03-06 Computer Repair charge Rs 3000/- paid
03-07 Cash withdrew from World bank for office use at Rs 50000 cheqee no
1332
03-08 Deposited for telephone in Nepal telocome office at 10000/-
03-09 Rs 36000 withdrew from proprietor his personal use by NIC Asia bank
cheque no 122554
03-10 Bought motorcycle at Rs 130000 paid by NIC Asia bank cheque no 1256
03-11 Furniture Purchase at Rs 4000
03-12 Bought share and investment in LIC Company at 100000
03-15 Give loan to Ramesh Dahal Rs 100000 by 12% interest yearly
03-20 Loan received from Ritu Karki
at Rs 70000 with16%interest monthly
03-25 Give loan to shardha at Rs 50000 with 18% interest yearly
03-14 Loan received from Sushant Rs 40000 with 14% interest monthly
Inventory info
How to create stock Group?
F Masters Menu
F Inventory Master
F Company Master, Group Master, Category Master
F Click F2 Button
E.g:
Company Master:
Sony, Samsung, L.G, Oppo, Vivo
Group Master:
Mobile, TV, Laptop, Desktop, Charger
Category Master:
If Needed you can fill it or Blank
Note:
You can rename or disable all Master.. from Control Room.
Note: for Decimal quantity
Decimal: Yes
How
to Rename or enable or disable Company, group and category?
F Masters Menu
F Marg Setups
F Control Room
F Search in All
F Search ‘Name of Item’
F Name of item Group Company ……………… ‘Company’
F Search ‘salt’
F Salt wise stock/search-------- ‘Y’ for Enable, ‘N’ for Disable.
F Search ‘Category’
F Category wise stock/search-------- ‘Y’ for Enable, ‘N’
for Disable.
How to modify the stock group?
F Masters Menu
F Inventory Master
F Company Master, Group Master, Category Master
F Click F3 Button
How to create stock item?
F Masters Menu
F Inventory Master
F Item Master
F Click F2 Button
Eg: Samsung A50, Sony x3, LG M4, etc
How to modify stock item?
F Masters Menu
F Inventory Master
F Item Master
F
Highlight the target
item
F Click F3 button
Purchase voucher
F Transactions Menu
F Purchase
F Wholesale: Bill(Alt+P)
Sale voucher
F Transactions Menu
F Sale
F Wholesale: Bill
Problems:
1. Goods purchase on Cash as
follows:
Stock Group: Mobile
Samsung A50 200
pcs @Rs.18,000 per pcs
Samsung A30 150
pcs @Rs.14,000 per pcs.
Sony
x3 200
pcs @Rs.20,000per pcs.
LG M4 200 pcs @Rs.18,000 per pcs.
2. Goods purchase on credit
from Nabin Trade as follows:
Stock Group : shoes
Panda 20
pairs@Rs.1200 per pcs.
Zara 10
pairs@Rs.1000per pcs.
Vista 30 pairs@Rs.3000per pcs.
3. Goods sold on credit to
Arzoo Trade house as follows:
Stock Group: Shoes
Panda 5 pairs @Rs.1800per
prs
Zara 5 pairs @Rs.2800
per prs
4. Cash paid to Nabin Trade
Rs.120000
5. Cash received Arzoo trade house Rs.34000
How to see report of purchase / sales register?
F
Books
F
Entry Books
F Sales Book/Purchase Book.
How to enable VAT in bill?
F Masters Menu
F Marg Setups
F Control Room
F Search in All
F Search ‘Sales Type’
F Ask if Party Type is L-Local O- Central ……….. set ‘B’
1. Goods
Purchase on credit to Uncle kirana Pasal.
Stock Group:
Micromax 500 pcs @ Rs.25000
per pcs.
Colors 600 pcs @ Rs.30,000 per pcs.
LG 700 pcs @ Rs.20,000 per pcs.
Samsung 300 pcs Rs.25,000 per pcs.
Sony 500pcs Rs.30,000 per pcs
VAT 13%
Purchase discount 5%
2.
Goods Sold on cash.
Stock Group:
Micromax 100 pcs @ Rs.25000
per pcs.
Colors 400 pcs @ Rs.30,000 per pcs.
LG 500 pcs @ Rs.20,000 per pcs.
Samsung 50 pcs Rs.25,000 per pcs.
Sony 350pcs Rs.30,000 per pcs
VAT 13%
Sales discount 5%
3.
Goods Purchase on Cash.
Stock Group: Beer
Cold Durbar 500 ctn @
Rs.50,000. per ctn.
Gorkha Strong 700 ctn @ Rs. 60,000 per
ctn.
Khukuri 1000 ctn @ Rs. 80,000 per ctn.
Turbog 800 ctn @ Rs. 60,000 per ctn.
VAT 13%
Purchase discount 5%
4.
Goods sold on credit to Dhulabari Pasal.
Stock Group: Beer
Cold Durbar 100 ctn @
Rs.50,000. per ctn.
Gorkha Strong 350 ctn @ Rs. 60,000 per
ctn.
Khukuri 800 ctn @ Rs. 80,000 per ctn.
Turbog 200 ctn @ Rs. 60,000 per ctn.
VAT 13%
Sales discount 5%
5. Cash paid to Uncle kirana Pasal Rs.120000
6. Cash received Dhulabari Pasal house Rs.34000
How to activate godown?
F Masters Menu
F Marg Setups
F Control Room
F Search in All
F Search ‘Store’
F Store 1,2,3,……65--------------‘1’
F Put here total store
How to Create Godown?
F Masters Menu
F Inventory Master
F Store Master
F F2 for New
Eg manakamana godown, birta godown , jalkanya
godown.
Account voucher
1. Goods purchase in cash for
manakamana Godown as follows
Stock group : mobile
Nokia 1616 10pcs @ Rs. 1500
L.G. 2626 15pcs @
Rs. 2000
Samsung 3131 10pcs @
Rs. 3000
purchase discount 5%
vat 13 %
2. Goods sold on cash from
manakamana godown as follows
Stock group: mobile
Nokia 1616 8pcs @
Rs. 2000
Lg 2626 10 pcs @ Rs. 2500
Samsung 5 pcs @ Rs. 3500
sales
discount 5%
vat 13 %
3. Goods purchase on credit
from Raju Trade for birta godown as follows
Stock group : Rice
Mansuli Rice 20 Qtl @ Rs. 1200
Basmati Rice 10 qtl @
Rs. 2000
Sona mansuli Rice 15 qtl @ Rs. 1000
Purchase discount 3%
vat 13 %
Other charge 500
4. Goods sold on credit to
Ramita from Birta Godown as follows:
Stock Group : Rice
Mansuli Rice 15
Qtl @ Rs. 1500
Basmati Rice 10 qtl @ Rs. 2500
Sona mansuli Rice 15 qtl @ Rs. 1200
Purchase discount 4%
Vat
13 %
Advertisement charge 300
5. Cash paid to Raju Trade at
Rs. 1,00,000.
6. Cash received from Ramita at 75,000.
How to see report Godownwise?
F
Stocks
F
Current Stocks
F
Choose Store
How to Transfer Godown?
F
Transactions
F
Stock Issue
F
Wholesale
F Choose ledger ‘ Store T/F ’
Stock transfer from
manakamana godown to jalkanya godown as follow:
Nokia 2
pcs
Lg 5 pcs
Samsung 5 pcs
How to see Godown report?
F
Stocks
F
Current Stocks
F
Choose Store
F Choose target Godown and press enter
Purchase return / Sales return
Purchase
return debit
note
Sales return credit note
How to entry purchase return or sales return?
F
Transactions
F
Purchase Return/Sales
Return
F Debit Note/Credit Note
How to see Debit Note/Credit Note report?
F
Books
F
Entry Books
F Debit Note / Credit Note.
Compound unit
How to Active Multi Unit?
F
Masters Menu
F
Marg Setups
F
Control Room
F
Search in All
F
Search ‘Multi Unit’
How to create Multi Unit?
F While Creating product.
F
Unit
1st : pcs
F Unit 2nd : dzn
F
Conv.
Box: 12
1. Goods purchase on credit from Rattna trade for himal godown as follows:
Pen
Starline 20
dzn 5 pcs @ Rs 120
Cello 30
dzn 7 pcs @ Rs 150
Pilot 25 dzn 6 pcs @ Rs 130
Purchase vat-13%
2. Goods sold on cash from
Himal godown as follows:
Pen
Star
line 5
dzn 2 pcs @ Rs 130
Cello 10 dzn 5 pcs @ Rs 160
Pilot 5 dzn 9 pcs @ rs 140
Vat:-13%
3. Stock transfer from himal
go down to mamata go down as follows
Star line 15
dzn 2 pcs
Cello 15
dzn 3 pcs
Pilot 15 dzn 7 pcs
4. Defective goods returns to
Rattan trade from Himal go down as follows.
Starline 2 dzn 9 pcs @ Rs 120
Cello 4
dzn 4 pcs @ Rs 150
Pilot 3
dzn 1 pcs @ Rs 130
Vat:-13%
5. Goods gold on credit to
ranju from mamata go down as follows.
Star line 10
dzn 3 pcs @ Rs 135
Pilot 10
dzn 11 pcs @ Rs 145
Vat:-13%
6. Defective goods returns
from ranju in mamata go down as follows.
Star
line 2 dzn 0 pcs @ Rs 135
Pilot 3
dzn 0 pcs @ Rs 145
Vat:-13%
Sales Order
F Transactions Menu
F Sales Order
F Wholesale/ Retail
Purchase Order
F Transactions Menu
F Purchase Order
F New
F Manual Order
How to see purchase order /sales order book?
F
Display
F
Inventory books
F
Purchase order
books/sales order books
Transaction
1.
Purchase order to
Ganesh trade order no–1, due on 7 days
Stock group cloth
T-shirt (ladies) 100 pcs @ Rs 600
T-shirts (Jeans) 300 pcs @ Rs 550
Vat:-13%
2. Goods received from Ganesh trade according to order no
-1 and made purchase invoice.
3.
Sales order from
Kamal trade order no-1. Due on -15 day.
T-shirts (Jeans) – 200 pcs @ Rs 620
T-shirts (ladies) – 50 pcs @ Rs 6720
Vat:-13%
4. Goods delivered to Kamal trade according to order no-I
and made sales vouchers.
5. Cash received from Kamal trade at Rs. 100000
6. Cash paid to Ganesh Trade Rs. 80000
Separate discount column invoice:
How to active?
·
Masters Menu
·
Marg Setups
·
Control Room
·
Search in all
·
Search ‘Volume
Discount’
Per
Unit :- u
Lumpsum
:- l
Weight
:- w
Percentage
:- p
1.
Goods purchase on
cash.
Stock Group:
Fan
Stock Qty Rate
Grishma 200
pcs 800
Nabin 160 pcs 900
2.
Goods solds on
credit to merina trade as follows:
Stock Group: Fan
Stock Qty Rate Separate discount
Grishma
100 pcs 2200 -2%
Nabin 110
pcs 1800 -2%
3.
Goods sold on
credit to Dhulabari trade as follows:
Stock Group: Fan
Stock Qty Rate Separate discount
Grishma
100 pcs 2200 -2%
Nabin 110 pcs 1800 -2%
Free Qty and Bill QTY
·
Masters Menu
·
Marg Setups
·
Control Room
·
Search in all
· Search ‘Free Quantity’
F
If your Working
Style is Normal w/o Secondary while creating company then Modify company and
keep to Self- secondary.
·
Marg Setups
·
Control Room
·
Search in all
·
Search ‘Batch’
Active Expiry Date
·
Masters Menu
·
Marg Setups
·
Control Room
·
Search in all
·
Search ‘Exp.’ AND ‘MFG’
How to see Report?
F
Stocks
F
Batch Stock/ Near
Expiry Stock/ Expired Stock
F Press Enter
Transaction
1. Good purchase on credit
from Raju Trade for Laxmi godown.
Stock Group:- Shampoo
|
Stock item |
Free QTY |
Billed QTY |
Rate |
|
Sunslik |
8pcs |
100pcs |
230 |
|
Clinic plus |
5pcs |
50pcs |
235 |
|
Vatika |
5pcs |
80pcs |
233 |
|
Dove |
10pcs |
200pcs |
350 |
VAT 13%
2. Goods sold on cash from
laxmi Godown
|
Stock item |
Free QTY |
Billed QTY |
Rate |
|
Sunslik |
2 |
50pcs |
255 |
|
Dove |
5 |
60pcs |
370 |
VAT 13%
3. Goods purchase on cash
Stock group – Biscuit
Parle-G 500pkt
@ RS.18
Batch no:- 123
MFG.
date: 01-03-2006
Exp
date: 01-12-2007
Coconut 800pkt
@ RS 17
Batch: - 444
MFG date: 01-03-2006
Exp date: 01-12-2007
VAT 13%
4. Goods sold on cash
Coconut: - 400pkt @ RS. 20
(From Batch no: - 444)
Parle- G 200pkt
(form Batch no:- 123)
VAT 13%
Cost Center:
How to active cost center?
·
Masters Menu
·
Marg Setups
·
Control Room
·
Search in all
·
Search ‘Cost Center’
How to create cost centers and cost categories?
Ø
Master Menu
Ø
Cost center
Master
Ø
Cost Category/
Cost Center
Ø
Create Click F2
Ø
Mouse,
keyboard…..
How to use cost center?
Ø
Master Menu
Ø
Cost center
Master
Ø A/C Group Setup yes for needed
1. bought computer
Rs.1,00,000.
Ø
Mouse Rs.30,000.
Ø
Keyboard Rs.20,000.
Ø
Monitor Rs.30,000.
Ø
CPU Rs.20,000.
2. Advertisement bill paid
Rs.70,000.
Ø
Sargam FM Rs.20,000.
Ø
Mechi Tunes FM Rs.30,000.
Ø Simana FM Rs.20,000.
3. Office Rent paid Rs.50,000.
Ø
Head office Rs.15,000.
Ø Branch office Rs.35,000.
How to see report of cost center/cost categories?
Ø
Books
Ø Cost Center
How to create budget?
Ø
Master Menu
Ø Ledger Master
Ø Budget
Ø Choose your Ledger or Create
New F2
Ø Enter
Ø Tab Button go to Annual Budget
1. Create Budget for Tea Expenses Rs.25,000/-
04-01 Payment for Tea 500/-
04-10 Payment for Tea 1500/-
04-25 Payment for Tea 100/-
05-29 Payment for Tea 2000/-
06-30 Payment for Tea 2500/-
07-14 Payment for Tea 1500/-
2. Create Budget for salary Rs.1,00,000/-
04-29 Payment for Salary 50,000/-
05-30 Payment for Salary 15,000/-
06-15 Payment for Salary 10,000/-
07-29 Payment for Salary 20000/-
08-30 Payment for Salary 25000/-
09-14 Payment for Salary 15000/-
3. Create budget for Advertisements bill paid Rs.70,000/-
04-29 Payment for Advertisement 5,00/-
05-30 Payment for Advertisement 1,000/-
06-15 Payment for Advertisement 2,000/-
07-29 Payment for Advertisement 5,000/-
08-30 Payment for Advertisement 11,00/-
09-14 Payment for Advertisement 15000/-
How to see report of budget?
Ø
Books
Ø
Budget Analysis
Ø
Ledger/ Group
Ø Enter to selected ledger for monthly view.
Journal Voucher (F7)
Dr the Receiver
A) Personal Account:-
Cr the Giver
Dr what comes in?
B) Real Account:-
Cr what goes out?
All exp and loss are Dr
C) Nominal Account:-
All income and gain are Cr
How to activate cash A/C in Journal?
F
Masters Menu
F
Marg Setups
F
Control Room
F
Search in All
F
Search ‘Cash
bank’
How to Entry Journal Voucher?
F Accounts
F Voucher Entry
F Journal
F Journal
Transaction
1. bought computer on credit from Ice Computer Center
Rs.40,000.
Dr. computer
a/c
2.
Depreciation on computer Rs.30,000.
Dr. Depreciation
Cr. computer a/c
3. Commission received from Ram Rs.30,000.
Dr. Ram a/c (C.A)
Cr. commission receivables(Indirect incomes)
4. payable Interest to priya Rs.30,000.
Dr. Interest paid()
Cr. Payable interest(CL)
5. furniture Rs.40,000 lost by fir and insurance
company was claimed only Rs.38000.
Dr. Profit/Loss a/c
Dr. Insurance company a/c
Cr. Furniture a/c
How to see report of journal?
·
Books
·
Entry Books
·
Journal Book
·
Enter your Date
·
For Detail View
Press F11
Multiple Price Level
How to Active Price list?
F Masters Menu
F Marg Setups
F Control Room
F Search in All
F Search ‘Qty Base’
How to create price list?
F
Masters
F
Rate Master
F
Bill, Quantity
& others
F
Qty.wise
Rate/Scheme
F
Yes
F
Select your Item
Problems:-
1.
Goods purchase on
cash as fallows:
Stock group: - T-shirt
T-shirt
(J) 1500pcs @ 450per pcs
T-shirt (L) 500pcs@ 500 per pcs
Purchase
discount – 5%
Vat - 13%
2.
Goods purchase on
cash as follow:
Stock
Group:- shoes
Panda
200 pcs @ Rs.550per pcs
Nike 450pcs @ Rs.700per pcs
Goldstar 800pcs @ Rs.900per pcs
Purchase discount: 6%
VAT 13%
3.
Make price list.
Stock group: - T-shirt
|
Name of
items |
Qty |
Rate |
Discount |
|
|
From |
Less than |
|||
|
T-shirt
(L) |
- 20 pcs 50 pcs |
20 pcs 50 pcs Above |
600 550 500 |
- 2% 3% |
|
T-shirt(J) |
- 20 pcs 50 pcs |
20 pcs 50 pcs Above |
750 700 650 |
- 2% 3% |
4.
Make price list.
Stock group: - T-shirt
|
Name of
items |
Qty |
Rate |
Discount |
|
|
From |
Less than |
|||
|
Panda |
- 20 pcs 50 pcs |
20 pcs 50 pcs Above |
1000 850 650 |
- 2% 3% |
|
Nike |
- 20 pcs 50 pcs |
20 pcs 50 pcs Above |
1200 950 700 |
- 2% 3% |
|
Goldstar |
- 20 pcs 50 pcs |
20 pcs 50 pcs Above |
1500 950 800 |
- 3% 4% |
T-shirt(L) – 10pcs
T-shirt(L) - 30pcs
T-shirt(L) – 55pcs
6.
Goods sold on Credit to Uncle shoes pasal.
Panda-18pcs
Nike-38pcs
Goldstar-54pcs
Manufacturing Journal
How to create
manufacturing journal?
F Masters Menu
F Marg Setups
F Control Room
F Search in All
F Search ‘BOM '
F
Purchase Following Item on Cash:
Name under unit Qty Rs
Keyboard Raw
materials pcs 30 250
Mouse Raw materials pcs 30 150
Monitor Raw materials pcs 30 65000
DVD R/W Raw materials pcs 30 2000
Casing Raw materials pcs 30 1200
Motherboard Raw materials pcs 30 3500
RAM Raw
materials pcs 30 2500
CPU Raw
materials pcs 30 7500
HDD Raw materials pcs 30 6500
Create stock item
Name under unit Qty
Computer finished goods pcs 20
How to create Manufacturing formula:
F Transactions
F Bills of Materials(BOM)
F Manufacturing Formula
F Choose Computer or create If
there not available.
F Place stock 1 then enter
After this you can view Production planning and total
costing of the product.
F Transactions
F Bills of Materials(BOM)
F Production Planning and Costing
Production Planning(to View total stock for it)
F From Current Stock
F Choose your Finished Product
F Then End and View
Costing Product(to View total costing for the
product.)
F Choose Finished Product.
F Then Enter and view it.
How to Manufacture the
product?
F First Create Ledger 'Production
Department' under (Sundry Creditor
'Manufacture')
F Transactions
F Bills of Materials(BOM)
F Direct Receipt
F Choose ledger 'Production
Department'
F Choose Finished Product.
Then place required quantity
Note: after it quantity will be auto deducted from the current stock… for this auto you should make manufacturing formula.
All
Transaction:
1.
ABC company
started business with cash at Rs. 10,00,000.
2.
Bought furniture
for office use at Rs. 50,000.
3.
Bought computer
at Rs. 35,000 for office use.
4.
Commission
received from ABC group at Rs. 30,000.
5.
Bonus received from ABC Company at Rs. 10,000.
6.
Rent paid to
household at Rs. 5000.
7.
Telephone bill
paid at Rs. 2000.
8.
Deposited cash at
Rs. 20,000 for telephone.
9.
Share investment
in SKM company at Rs. 1,00,000.
10. Bought
typewriter for Rs. 40,000.
11. Bought Printer
for Rs.50,000.
12. Advertisement
Bill paid Rs. 10,000.
13. Cash Rs. 3, 00,000 deposited into Nubile bank.
14. Cash Rs. 50,000 withdraws from Nubile bank cheque no
12244 for office use.
15. Cash transfer from Nubile bank to SBI Bank at Rs.
1,00,000 chquee no 23531.
16. Cash deposit into NCC bank at Rs. 1,00,000.
17. Cash withdrew from NCC bank at Rs. 25,000 for office
use. Cheque no 339956
18. Cash transfer from NCC Bank to Nepal Bank at Rs.
50,000 chequee no 56666.
19. Give loan to sanu bahal Rs 100000 by 30% interest
yearly
20. Loan received from kamala karki at Rs 70000
with16%interest monthly.
21. Give loan to mina subba at Rs 50000 with 18% interest
yearly
22. Loan received from Anuja thapa Rs 40000 with 24%
interest monthly
23. Goods purchase on credit from Rattna trade for himal
godown as follows:
Pen
Starline 20
dzn 5 pcs @ Rs 120
Cello 30
dzn 7 pcs @ Rs 150
Pilot 25
dzn 6 pcs @ Rs 130
Purchase vat-13%
24. Goods sold on cash from Himal godown as follows:
Pen
Star
line 5
dzn 2 pcs @ Rs 130
Cello 10 dzn 5 pcs @ Rs 160
Pilot 5 dzn 9 pcs @
rs 140
Vat:-13%
25. Stock transfer from himal go down to mamata go down as
follows
Star
line 15 dzn 2 pcs
Cello
15 dzn 3 pcs
Pilot 15 dzn 7 pcs
26. Defective goods returns to Rattan trade from Himal go
down as follows.
Starline 2 dzn 9 pcs @ Rs 120
Cello 4 dzn 4 pcs @ Rs 150
Pilot 3 dzn 1 pcs @ Rs 130
Vat:-13%
27. Goods gold on credit to ranju from mamata go down as
follows.
Star
line 10 dzn 3 pcs @ Rs 135
Pilot
10 dzn 11 pcs @ Rs 145
Vat:-13%
28. Defective goods returns from ranju in mamata go down
as follows.
Star
line 2 dzn 0 pcs @ Rs 135
Pilot
3 dzn 0 pcs @ Rs 145
Vat:-13%
Balance sheet/profit and loss/ trail balance report
F Final Reports
F Trial Balance, Profit & Loss, Balance Sheet, Group Summary
Stock
summary report
F Stocks
F Current Stock
 |
Day
book report
F Books
F Entry Book
F Day Book
New
Financial Company process:
F Exit Company(Alt+x)
F Select Company and press Enter
F New Financial Year
F Place your Date “31-03-20xx”
F Accept
F Yes
Best
of Luck