unit – 5 : accounting software package – gnukhata

FUNDAMENTALS OF COMPUTERISED ACCOUNTING 
Maintenance of accounting records with help of accounting software is known as computerised accounting. Ex: Tally.GNUKhata,Daceasy,Peachtree,Sap etc. 

ADVANTAGES OF COMPUTERISED ACCOUNTING SYSTEM 
a. Transactions are posted instantly to various accounts on voucher entry. b. Automatic balancing of accounts 
c. Easy alteration 
d. Storage and retrieval of large volume of data 
e. Reports can be prepared as user requirement 
f. Accurate and speedy processing of data 

Difference between Manual accounting and computerised accounting

Manual AccountingComputerised Accounting
1-Manually performing accounting works1-Works done with the help of computer and software.
2-Automatic processing of accounts is not possible2- Automatic processing is possible
3-Periodic reports are difficult to generate3-Can easily generate periodic reports
4- Time consuming4 – Speedy

Features of Accounting Software

  1. It is designed to automate and integrate all business operations like journalising,posting,ledger balancing and preparation of final accounts.
  2. Inventory management is possible.
  3. Can easily prepare payroll 
  4. Preparation of report for managerial decision making is possible.
  5. Timely generation of reports in desired format.

GNUkhata
GNUkhata a free and open source software for accounting and inventory management being developed by Digital Freedom Foundation funded by International Centre for Free and Open Source Software(ICFOSS).

Features of GNUKhata

  1. It is a free and open source accounting software.
  2. Based on double entry system of accounting
  3. Drill down facility is used for preparing reports.
  4. Financial reports like trial balance,trading and Profit and loss account ,balance sheet etc can be prepared.
  5. Password security and data audit facility provided.
  6. Documents can be attached in vouchers.
  7. Source document can be attached along with the voucher entry.
  8. Export import of data is possible in spreadsheet.

Starting GNUKhata
Application—->Office—–> GNUKhata

Create Organisation: The first step in operating GNUKhata is to create an organisation.It may be either profit or non-profit organisation. 

  1. Click on “Create Organisation”  tab and
  2.  enter “Organisation Name “ “Zion chemicals”  

Case                         : As Is

Organisation Type : Profit Making

Financial year        :01-01-2016 to 31-12-2016

Select “ Accounts only” and click “Proceed”  button

  1. Create Admin –  As part of providing security to the accounting information we have to setup the administrative features.It is mandatory to create ‘Admin’.Enter User name ,Password,security question for resetting password and answer for security question (Enter zion  in all fields) and click on “ Create & Login”.

Methods of maintaining Accounts 
Accounts only: Select this option if financial accounts only are to be maintained
Accounts with inventory:-Select this option if both financial accounts and inventory are required. 

Security Features 
1-Password: can restrict access to company’s data to authorised users using password.

2-Data audit: This feature is available to administrator to track any unauthorised changes have taken place in the data. 

3-Data vault:- This feature is encrypting data for additional security. 

Accounts Group 
Bringing together accounts of similar nature at one place is known as grouping of accounts.Grouping determines whether a ledger goes to P&L A/c or Balance sheet. GNUKhata has 13 pre defined accounting groups,of which 9 relates to the balance sheet and 4 to P&L A/c or income & Expenditure Account.

Profit and Loss Or Income and Expenditure Account Groups

SI.No:Group NameSub-Group name
1Direct incomeNone
2Direct expensesNone
3Indirect incomeNone
4Indirect ExpensesNone

Balance Sheet Groups

SI.No:Group NameSub-Group name
1Fixed AssetsBuilding,Furniture,land,Plant & Machinery
2InvestmentsInvestment in bank Fixed Deposits,Investment in shares & Debentures
3Loans(Assets)None
4Current AssetsBank,Cash,Inventory,Loans & Advances,Sundry Debtors 
5Miscellaneous Expenses (Assets)None
6Capital / CorpsNone
7Loans (Liability)Secured,unsecured
8ReservesNone
9Current LiabilityProvisions,Sundry creditors for expenses,Sundry creditors for purchases

Ledger

Ledger accounts is a formal record of transactions affecting a particular item. In GNUKhata an account itself is called ledger.

To create a Ledger Account ,select  ‘Create Account’ option from ‘Master’ menu.

Only accounts of assets and liabilities have opening balances.income and expenses are closed by transferring to Trading and Profit & Loss Account.

System Generated Ledger Accounts
When an organisation is created the software automatically creates the following ledgers.these accounts can neither be modified nor deleted.

SI.No:Account NameGroup NameSub-Group Name
1Closing stockCurrent AssetsInventory
2Opening StockDirect ExpensesNone
3Profit & Loss AccountOr Income & Expenditure A/cDirect IncomeNone
4Stock at the BeginningCurrent AssetsInventory

Treatment of Specific Items
Closing Stock:-Goods  lying unsold with the business at the end of the accounting are termed as closing stock.It is current asset and included in the asset side of B/S. At the same time it will appear in the credit side of P&L A/c.

Opening Stock:-The stock of goods available at the beginning of current financial year is termed as opening stock.It is treated as Direct expenses and appears in the debit side of P&L A/c.

Stock at the Beginning:-If the accounts of business are computerised for the first time,the amount of opening stock can be inserted through the following steps:

     Step 1 – Edit the Stock at the beginning Account

                   Master – -> Edit Accounts–>Select ‘Stock at the beginning Account’-> Click on Edit->Enter 

                   the Opening Balance 

     Step 2- Voucher->select Journal Voucher-> Enter Voucher No.& Opening date -> Debit Opening 

                  stock and credit stock at the beginning.

Voucher Entry: Transactions are recorded through voucher entry.A voucher contains all the details of a particular transaction. 

Pre-defined Accounting Voucher types 
Each voucher entry should be passed through appropriate voucher types. They are 

  1. Contra (F8)- Contra voucher is used to record transactions involving bank and cash accounts or between two bank accounts or two cash accounts.
  2. Payments(F5):-Used to record allpayments.(cash/bank) 
  3. Receipt(F4):- Used to record receipt of cah (cash/bank) 
  4. Journal(F9):- Used to record adjusting and closing entries, purchase and sale of fixed asset on credit etc.usually it is used as a non cash voucher. 
  5. Sales(F6) :-Used to record sale of goods( cash and credit)
  6. Purchase(F7) :– used to record all purchase of goods( cash and credit)
  7. Debit note(CTRL+4): Used to record purchase return or discount rebate received
  8.  Credit note(CTRL+3) :-used to record sales return or discount or rebate allowed. 

Accounting Reports 
Cash book: Cash book records all receipt and payment of cash. 
Bank Accounts: Banking transactions of the business can be recorded in ledger accounts placed under the group bank accounts. 
Bank reconciliation statement: A bank reconciliation statement is a statement prepared by the depositor to reconcile(agree)the balance as per pass book with that of bank account. 
Trial Balance :Trial balance is a statement of total or balances of various ledger accounts. 
Profit and Loss Account : Profit & Loss account displays the profit or loss of the business. 
Balance sheet : It displays the position of assets and liabilities of the business on a particular date. 

Download GNUKhata : Click here

GNUKhata Videos

How to Install GNUkhata – Malayalam

Try Demo

GNUkhata website : www.gnukhata.in

Company Creation in GNUkhata

Ledger Creation

Voucher Entry

Opening and Closing stock

Close books and Roll over