Pages

Tuesday, September 4, 2012

Introduction of Tally 9 (Part 4)


Down Ribbon: Session - 10

Trading Account &Profit & Loss Account

Trading Account:-
Trading account is one of the financial statements which shows the result of buying and selling of goods and / or services during an accounting period

Profit & Loss Account:-
The Profit & Loss account is one of the financial statements. It shows the financial performance of business during an accounting period


Gateway of Tally → Profit & Loss A/c

Trading & P& L A/c




          Detail Profit & Loss A/c

Click F1: Detail to get Detail Profit & Loss A/c Showing next level Groups / Ledgers.
Click F1: Condensed toggle button to get back to Primary Group Profit & Loss A/c.





Gateway of Tally → Profit & Loss A/c → F1


Profit & Loss A/c Configuration

Gateway of Tally → Profit & Loss A/c → F12

Down Ribbon: Session - 11

Balance Sheet

A Balance Sheet is one of the financial statements. A Balance Sheet is a statement of assets and liabilities of an enterprise at a given date. It is called a Balance Sheet because it is a sheet of balance of those ledger accounts which have not been closed till the preparation the Trading and profit and Loss Account

Gateway of Tally → Balance Sheet





Detail Balance Sheet

Click F1: Detail to get Detail Balance Sheet Showing next level Groups / Ledgers.
Click F1: Condensed toggle button to get back to Primary Group Balance Sheet.










Gateway of Tally → Balance Sheet → F1



Balance Sheet Configuration

Gateway of Tally → Balance Sheet → F12

Down Ribbon: Session - 12

Unconventional Voucher

These special vouchers are used to record provisional or non-accounting transactions. They do not clutter the main books of accounts with unnecessary entries and at the same time make the information available. These vouchers enable valuable reports in terms of provisional accounts and forecasting. This aspect of reporting has been dealt with under a separate section ‘Scenario Management”.

Types of unconventional vouchers:-
Ø  Memorandum voucher                                                            Ctrl+F10
Ø  Reversing Journal Voucher                                                     F10
Ø  Optional Voucher                                                                   Ctrl+L
Ø  Post Dated Voucher                                                               Ctrl+T

Scenario Management

Scenario management is a management tool that enables different displays of accounts and inventory related information, by selectively including certain types of vouchers without affecting the source data. It is useful in generating provisional reports, where entries are not actually made in the main books. It is also a useful forecasting tool i.e., you can forecasting the expenses using provisional Vouchers and include them in your reports.

The vouchers that are used in Scenario Management are:-
Ø  Optional vouchers
Ø  Memorandum voucher
Ø  Reversing journals

Creating a Scenario:-

Name: Give a suitable name to the scenario. In this case, it is Provisional.

Set Include Actuals to Yes

Set Exclude: Forex Gains/Losses Calculations to Yes if you do not want the Unadjusted Forex Gain/Loss element to appear in the scenario

Set Exclude Inventory
Tracking Calculations to Yes if you do not want the Sales/Purchase Bills Pending element to appear in the scenario.

Include:- From the list of vouchers, include the type of vouchers required. Notice that it picks up the voucher Types created for this company. Provisional Vouchers an Register voucher that are marked Optional are permitted for selection.

Exclude: Exclude from the list of vouchers already included in the type of voucher that you do not want to affect this scenario. This option is used in Alter mode and hence is discussed under Alter/Display Scenario Information.


Gateway of Tally → Accounting Features → Use Reversing Journal & Optional Voucher (Yes)





Reversing Journals

Reversing journal are special journals that are automatically reversed after a specified date. They exist only till that date and are effective only when called for in reports like the Balance Sheet. These are used in interim reporting in the course of the financial year where accruals are required. These accruals are usually short term and are cleared in the subsequent period. However, to get a proper perspective, decision makers require the reports with full impact of all aspects and transactions.



Optional Voucher

This is another non-accounting voucher. However, it differs from the Memo Voucher in that it is not a separate voucher type. You mark an existing voucher, (e.g., a payment voucher or a receipt voucher) as ‘Optional’. Press {Ctrl}+ {L} or click on the button. This button toggles with ‘Regular’. By marking it ‘Optional’ the voucher does not get posted anywhere but remains in the have the Optional Register.

Use of Optional Vouchers:-
Ø  If a transaction has not been completed, you may not want it to affect the accounts. But you want to record it so that you simply modify the voucher and remove the ‘Optional’ mark by ‘Regular’ it. Display the voucher in ‘Alter’ form and click on ‘Regular’.
Ø  You might want to see the impact of transactions without actually posting them. Optional vouchers allow you to do this.


Sale Voucher


Receipt Notes



Memo Voucher

This is a non- accounting voucher and the entries made using it will not affect your accounts. That is, Tally does not post these entries to ledgers but stores them in a separate Memorandum Register.
Some uses for Memo Vouchers:-
  1. Making suspense payments
  2. Vouchers not verified at the time of entry
  3. Items given on approval


Post-Dated Voucher
While entering vouchers, you can post-date them, and Tally will not update the ledgers until the date in question. This is most useful for entering transactions that take place on a regular basis. For example, if you pay for something by installments, you can set-up the payments in advance, and Tally will only enter them in the ledgers as they fall due. Mark vouchers ‘Post Dated’ by {Ctrl}+{T} or click on the button. The button toggles with ‘Regular’


3 comments

Inroduction of Tally 9(Part 3)


Down Ribbon: Session - 8

Voucher

Voucher is a document which serves as an evidence of a transaction. E.g., in case of cash purchases, cash memos and in case of credit purchases, purchase invoices are vouchers. The vouchers act as source documents on the basis of which transactions are recorded in the books of accounts.
In other words, it is a basic recording document or also called accounting voucher. In computerized accounting, we record all transaction through voucher entry.

Tally gives us two type of voucher:-
Ø  Conventional Voucher
Ø  Unconventional Voucher

Conventional Voucher: - Conventional Voucher are used to record all accounting transactions. These vouchers directly affect to your final accounts.

Ø  Contra Voucher                                                          :           F4
Ø  Payment Voucher                                                       :           F5
Ø  Receipt Voucher                                                         :           F6                               
Ø  Journal Voucher                                                          :           F7                   
Ø  Sale Voucher                                                               :           F8
Ø  Purchase Voucher                                                       :           F9
Ø  Credit Voucher / Sales Return Voucher                     :           Ctrl+F8          
Ø  Debit Voucher / Purchase Return Voucher                :           Ctrl+F9

Contra Voucher: - Contra voucher is used for fund transfer. Like-
  1. Cash to Bank                                      3. Bank to Cash
  2. Bank to Bank                                      4. Cash to Petty Cash

Payment Voucher: - Payment voucher are used for all type of Payment. Like-Purchase, Expenses, Acquisition of fixed asset, dues to creditor, loans/advance etc.

Receipt voucher: - Receipt voucher are used for receipt all incomes. Like- Debtors, cash, bank etc.

Journal Voucher: - Journal voucher are used for all adjustment entry with involving cash & bank A/c.

Sales Voucher: - Sales voucher are used for all sales transaction {whether for goods or services}

Purchase Voucher: - Purchase voucher are used for all purchase transaction {whether for goods or services}

Note: - Whether is cash or credit
Credit Notes: - Credit notes are used for Sales Return.
Debit Notes: - Debit Notes are used for Purchase Return.
Qs. 2.  Enter the following transactions in the Journal of Pran

Date                Particulars                                                                                          Amount
2009
01 Jan              Asset in hand: Cash, Rs. 27,030/-; Cash at Bank, Rs. 23,100/-;
                        Mohan Datta & Co., Rs. 6,750/-.
                        Liabilities: Marathi & Co.., Rs.3,880/-; Ram Sons, Rs. 3,000/-
02 Jan              Received a cheque from Mohan Datta & Co., in full settlement…….   6,650
03 Jan              Sold goods to Dass & Co.                                                                      1,400
04 Jan              Sold goods to Jai Chand & Sons                                                                        1,440
                        Carriage paid                                                                                             35
                        Sold goods to Gainda & Co., for cash                                                   3,120
05 Jan              Brought goods from Ram & Sons                                                          4,000
                        Paid Marathi & Co., by cheque in full settlement                                              3,800
06 Jan              Bought goods from Chatterjee & Mukherjee                                         6,300
07 Jan              Dass & Co. return goods, not being up to standard                                   100
                        Travelling expenses paid to salesman                                                       147
                        Goods sold for cash to Vijay                                                                    800
10 Jan              Paid for stationery                                                                                      66
                        Postage stamps                                                                                            15
13 Jan              Returned goods to Chatterjee & Mukherjee (not being up to
                        Specifications)                                                                                         300
                        Chatterjee & Mukherjee (also admit claim for breakage of goods)          100
15 Jan              Paid for furniture by cheque                                                                    700
16 Jan              Goods used personally by proprietor                                                         50
17 Jan              Sold goods to Mohan Datta & Co.                                                       5,000
19 Jan              Dass & Co. pay by cheque                                                                  1,300
20 Jan              Cheque received from Jai Chand & Sons                                                        1,440
22 Jan              Bank advises Jai Chand & Sons, cheque returned unpaid                  
23 Jan              Sold goods to Ajay for cash                                                                     800
24 Jan              Cash deposited with bank                                                                    2,000
27 Jan              Cheque sent to Chatterjee & Mukherjee
                        (Discount allowed Rs. 50)                                                                   5,850
29 Jan              Paid telephone charges                                                                                          23
31 Jan              Paid Salaries                                                                                            600
                        Paid Rent                                                                                                 300
                        Bank Charges                                                                                            10
                        Drew for personal use out of bank                                                          500
                        Received claim from Mohan Datta & Co., for defects on goods
                        Supplied to them; claim admitted                                                             150

Trial Balance                                     :           70,090

Gross Profit                                       :             2,510

Net Profit                                           :             1,294

Balance Sheet                                                :           57,744




Accounting Voucher

Gateway of Tally → F12 → Voucher Entry → Allow Cash Account In Journals Voucher (Yes) → Use Cr/Dr instead of To/By during Entry (Yes) → Accept


Journal Voucher

Receipt Voucher


Sales Voucher



Sales Voucher


Payment Voucher


Receipt (Cash Sale)



Purchase Voucher


Payment Voucher



Purchase Voucher


Debit / Credit Notes

Gateway of Tally → F11 → Accounting Feature → Invoicing → Use Debit/Credit Notes (Yes)

Credit Note (Sale Return)


Payment Voucher



Receipt Voucher (Cash Sale)

Payment Voucher



Payment Voucher



Debit Note (Purchase Return)



Journal Voucher


Payment Voucher



Journal Voucher


Sale Voucher



Receipt Voucher


Receipt Voucher



Journal Voucher


Receipt Voucher (Cash Sale)



Contra Voucher


Payment Voucher



Payment Voucher


Payment Voucher



Payment Voucher


Journal Voucher



Journal Voucher

Down Ribbon: Session - 9

Trial Balance

Meaning:-
       
        Trial balance is a statement which shows either the balance or total amounts of debit items and credit items of all accounts in the ledger and the Cash and bank balances. It may be noted that a trial balance is a statement and not an account and is prepared on a particular date and not for a particulars period.

Objective of a Trial Balance:-
       
The main objectives of preparing the trial balance are as follows:-
Ø  To ascertain the arithmetical accuracy of ledger accounts. A tallied trial balance indicates that equal debits and credits have been recorded in the ledger accounts.
Ø  To help in locating errors. A tallied trial balance indicates that some error(s) has (have) been committed.
Ø  To facilitate the preparation of financial statements and need not refer to the ledger.

Gateway of Tally → Display → Trial Balance


Detail Trial Balance

Click F1: Detail to get Detail Trial Balance Showing next level Groups / Ledgers
Click F1: Condensed toggle button to get back to Primary Group Trial Balance

Gateway of Tally → Display → Trial Balance → F1


Trial Balance Configuration

Gateway of Tally → Display → Trial Balance → F12

3 comments