Peachtree Accounting NATOGYI) ကီးကီး …api.ning.com/.../PeachtreeAccounting Accounting...

Post on 08-Apr-2018

234 views 6 download

Transcript of Peachtree Accounting NATOGYI) ကီးကီး …api.ning.com/.../PeachtreeAccounting Accounting...

Peachtree Accounting

NATOGYI)

keekee
Typewritten Text
keekee
Typewritten Text
ကီးကီး
keekee
Typewritten Text
ပုိ႔ေပးေသာ အကုိတစ္ေယာက္ကုိ အထူးေက်းဇူးတင္လ်က္

1.

2.

3.

1.

2.

3.

4.

1.

2.

3.

4.

1.

2.

3.

4.

1.

2.

3.

4.

AIT Computer

၊ - ၅၀၀

၂၀၁၁ ၊

( )

Ranger Offset

AIT Computer

− ၀၉ ၄၀၂၅၃၀၆၈၄

၂၅၀၀

CIP - ၀၀၆

Peachtree Accounting 2010 / ။

၊ ၊ ၊ ၂၀၁၁။

၁၄၈ ၊ ၁၈ × ၂၄ ။

(၁) Peachtree Accounting 2010

၁။ Computer Basic & DTP Course

Microsof Office 2010, Adobe PageMaker

၂။ Graphic Design Course

Photoshop, Illustrator, Indesign, Corel Draw

၃။ Video Editing Course

Power Director, Pinnacle, Premiere

၄။ A+ Course

Window XP, Vista, 7၊ Driver၊ Software၊ Utility

၅။ Network+ Course

၆။ Security+ Course

၇။ Programming Course

၈။ Web Design Course

Dreamweaver

၉။ Computerized Accounting Course

LCCI, MYOB, Peachtree

Accoun

Peachtree

Peachtree

NATOGYI)

1 Introduction to Peachtree Accounting ........................................................... 1

1.1 Peachtree Accounting 2010 Version ......................................... 1

1.2 Feature ......................................................................... 2

2 Installing Peachtree Quantum 2010 ............................................................... 3

2.1 Peachtree Software ............................................ 3

2.2 Full Version Peachtree Software Registration ...... 11

3 Create a New Company File ....................................................................... 14

3.1 ............................................................. 14

4 Peachtree Procedure .................................................................................... 20

4.1 ................................................................................................. 20

4.2 Purchase Orders Process ...................................................................... 21

4.3 .............................................................................................. 22

4.4 Billing your customer ........................................................................... 22

4.5 Receiving Money ................................................................................. 23

5 ........................................................................ 24

5.1 Accounts .............................................................................. 27

5.2 Account Type ....................................................................................... 29

5.3 Numbering Account ............................................................................. 30

6 Creating an Account ....................................................... 32

6.1 Charts of Account ................................................................................ 35

7 .................................................................... 37

7.1 Event 1 ................................................................................................. 37

7.2 Customer ................................................... 40

8 ................................................................................ 45

8.1 Event 2 ................................................................................................. 45

9 ..................................................................................... 48

9.1 Event 3 ................................................................................................. 48

10 ............................................................................................. 54

10.1 Event 4 ................................................................................................. 54

11 .......................................................................... 62

11.1 Event 5 ................................................................................................. 62

12 ........................................................................................... 64

12.1 Event 6 ................................................................................................. 64

13 ........................................................................................ 66

13.1 Event 7 ................................................................................................. 66

14 .......................................................................................... 68

14.1 Event 8 ................................................................................................. 68

14.2 Event 9 ................................................................................................. 70

14.3 Event 10 ............................................................................................... 72

15 ............................................................................................. 75

15.1 Event 11 ............................................................................................... 75

16 .................................................................................. 77

16.1 Event 12 ............................................................................................... 77

17 ................................................................................... 79

17.1 Event 13 ............................................................................................... 79

17.2 Event 14 ............................................................................................... 81

17.3 Event 15 ............................................................................................... 82

18 ....................................................................................... 85

18.1 Event 16 ............................................................................................... 85

19 ......................................................................................... 87

19.1 Event 17 ............................................................................................... 87

20 Adjustment ........................................................................ 90

20.1 ........................................................... 91

20.2 (Office Equipment) ........................ 92

20.3 (Adjusting Closing Stock) ........................ 93

21 Trial Balance ........................................................................ 95

22 Income Statement ............................................................... 98

23 Balance Sheet .................................................................100

24 ...........................105

24.1 (Account) ..................................................................................105

24.2 (Ledger) ..................................................................................105

24.3 ..............................................................................................106

24.4 (Double Entry) ..................................................106

24.5 (Debit Side) ..............107

24.6 (Credit Side) .............107

24.7 Debit & Credit ....................................................................................108

24.8 ..............................................108

24.9 ....................................109

24.10 (Trial Balance) ..........................................................112

24.11 ERRORS .........................................................................................113

25 (Classification of Accounts) ........................117

25.1 .............................117

25.2 Ledger Accounts ............................120

26 .........................................................................124

26.1 Book Keeping Procedure ....................................................................124

27 ......................................................................................................128

27.1 (Cash Book) ...............................................................128

27.2 (Petty Cash Book) .........................................129

28 (Adjusting Entries) .................................................................134

28.1 (Provisions & Adjustings) ............134

29 (Final Account) ........................................................140

29.1 ...................................................................140

29.2 (Trading Account) ...............................................140

29.3 (Cost of Sales) .........................................................141

29.4 (Profit & Loss Account) ...........................................141

29.5 (Balance Sheet) ........................................................142

29.6 (Assets) ..............................................................................142

29.7 (Liabilities) ................................................................143

29.8 (Capital) .............................................................................143

30

(This Page is blank.)

P a g e | 1

NATOGYI) AIT Computer Centre

Chatpter 1

1 Introduction to Peachtree Accounting

LCCI

MYOB Accounting,

Peachtree Accounting, ACCPAC Accounting,

1.1 Peachtree Accounting 2010 Version

1. Peachtree First Accounting

2. Peachtree Pro Accunting

3. Peachtree Complete Accounting

P e a c h t r e e A c c o u n t i n g P a g e | 2

NATOGYI) AIT Computer Centre

4. Peachtree Premium Accounting

5. Peachtree Quantum

1.2 Feature

P a g e | 3

NATOGYI) AIT Computer Centre

Chapter 2

2 Installing Peachtree Quantum 2010

2.1 Peachtree Software

P e a c h t r e e A c c o u n t i n g P a g e | 4

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 5

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 6

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 7

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 8

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 9

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 10

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 11

NATOGYI) AIT Computer Centre

2.2 Full Version Peachtree Software Registration

Help

P e a c h t r e e A c c o u n t i n g P a g e | 12

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 13

NATOGYI) AIT Computer Centre

P a g e | 14

NATOGYI) AIT Computer Centre

Chapter 3

3 Create a New Company File

3.1

File

Next

P e a c h t r e e A c c o u n t i n g P a g e | 15

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 16

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 17

NATOGYI) AIT Computer Centre

atch

P e a c h t r e e A c c o u n t i n g P a g e | 18

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 19

NATOGYI) AIT Computer Centre

P a g e | 20

NATOGYI) AIT Computer Centre

Chapter 4

4 Peachtree Procedure

4.1

Tasks Purchase Orders

Purchase Invoice)

P e a c h t r e e A c c o u n t i n g P a g e | 21

NATOGYI) AIT Computer Centre

4.2 Purchase Orders Process

The process of entering and paying bill

P e a c h t r e e A c c o u n t i n g P a g e | 22

NATOGYI) AIT Computer Centre

4.3

Selling Goods and Services

Tasks Quotes/Sales Orders/Proposals

Sales Order

4.4 Billing your customer

Tasks Sales Invoicing

P e a c h t r e e A c c o u n t i n g P a g e | 23

NATOGYI) AIT Computer Centre

4.5 Receiving Money

Tasks Receipts

P a g e | 24

NATOGYI) AIT Computer Centre

Chapter 5

5

Golden Tiger Company

2004 Financial Year

1 January Golden Tiger Co., started in business with capital 500,000

Kyat by U Wai Phyo Aung.

2 January Golden Tiger Co., borrowed 300,000 from AWB Bank

3 March Purchased of Furniture worth 50,000 Kyat.

1 April Credit Purchase of 80,000 Kyat from Star Company.

1 April Carriage Inwords – 3,500 Kyat.

15 April Cash Purchase – 70,000 Kyat.

1 May Cash Sale – 75,000 Kyat.

6 June

18 June Cash Purchase 40,000.

1 July Purchased of office equipment 20,000.

3 July Cash Payment to Star Company – 80,000.

5 July Cash Receipt from Thitsar Store 15,000.

6 August Golden Tiger Co., drawed cash – 10.000.

P e a c h t r e e A c c o u n t i n g P a g e | 25

NATOGYI) AIT Computer Centre

1 October Payment to Advertising Co., 5,000.

3 October Cash Sale 60,000.

1 November Payment to Shop Rental 24,000.

31 December Payment to Salary 50,000.

P e a c h t r e e A c c o u n t i n g P a g e | 26

NATOGYI) AIT Computer Centre

Golden Tiger Co.,Ltd

Stock Ledger

1/1/04 to 31/12/04

No Date Description Stock Price Amount

Unit Kyat Kyat

1 1/Jan Capital 500,000

2 2/Jan Borrow AWB Bank 300,000

3 3/Mar Purchased of Furniture 50,000

4 1/Apr Credit Purchase of Book 400 200 80,000

5 Carriage Inword 3,500

6 15/Apr Cash Purchase 350 200 70,000

7 1/May Cash Sale 250 300 75,000

8 6/June Credit sale of Book to Thitsar 25,000

9 18/June Cash Purchase 40,000

10 1/Jul Purchased of Office Equipment 20,000

11 3/Jul Cash Payment to Star Co., 80,000

12 5/Jul Cash Receipt from Thitsar Store 15,000

13 6/Aug Golden Tiger Co., drawed cash 10,000

14 1/Oct Payment to Advertising Co., 5,000

P e a c h t r e e A c c o u n t i n g P a g e | 27

NATOGYI) AIT Computer Centre

15 3/Oct Cash Sale 60,000

16 1/Nov Payment to Shop Rental 24,000

17 31/Dec Payment to Salary 50,000

5.1 Accounts

Account You are

setting up

Account Type you

should select

Creditors Account Payable

Debtors Account Receivable

Provision for Depreciation of Car,

Building, Furniture Accumulated Depreciation

Cost of Goods Sold of Items, Freight

Charges Cost of Sales

Cash, Bank Cash

Capital Equity- ’

Drawing Equity-Gets Closed

Retained Earning Equity-Retained Earning

Telephone Charges, Salary, Wages,

Travelling Exp Expenses

P e a c h t r e e A c c o u n t i n g P a g e | 28

NATOGYI) AIT Computer Centre

Land, Building, Furniture, Motor

Vehicle Fixed Assets

Sales, Other Income Income

Inventory Items

Eg.Inventory Book Inventory

Long-Term Loan Long-term Liabilities

Investment, Deposit Other Assets

Prepaid Expenses, Accrued Income Other Current Assets

Accurued Expenses, Prepaid Income Other Current Liabilities

P e a c h t r e e A c c o u n t i n g P a g e | 29

NATOGYI) AIT Computer Centre

5.2 Account Type

1. Accounts Payable

2. Accounts Receivable

3. Accumulated Depreciation

4. Cash

5. Cost of Sales

6. Equity- ’

7. Equity gets closed

8. Equity Retained Earnings

9. Expense

10. Fixed Assets

11. Income

12. Inventory

13. Long Term Liabilities

14. Other Assets

15. Other Current Assets

16. Other Current Liabilities

P e a c h t r e e A c c o u n t i n g P a g e | 30

NATOGYI) AIT Computer Centre

5.3 Numbering Account

Numbering Account Type

1

Accounts Receivable

Accumulated Depreciation

Cash

Fixed Assets

Inventory

Other Assets

Other Current Assets

2

Accounts Payable

Long Term Liabilities

Other Current Liabilities

3

Equity- ’

Equity gets closed

Equity Retained Earnings

4 Income

5 Cost of Sales

6 Expense

P e a c h t r e e A c c o u n t i n g P a g e | 31

NATOGYI) AIT Computer Centre

No Account Type Number Examples

1 Assets

1000

2 Liabilities

2000

3 Equity

3000

4 Incomes

4000

5 Cost of Sales

5000

6 Expenses

6000

P a g e | 32

NATOGYI) AIT Computer Centre

Chapter 6

6 Creating an Account

Banking Chart

of Accounts

Se

P e a c h t r e e A c c o u n t i n g P a g e | 33

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 34

NATOGYI) AIT Computer Centre

1000 Cash Cash

P e a c h t r e e A c c o u n t i n g P a g e | 35

NATOGYI) AIT Computer Centre

6.1 Charts of Account

Account ID Description Account Type

1000 Cash Cash

1100 Bank Cash

1200 Advance Payment Other Current Assets

1300 Inventory Inventory

1400 Debtor Account Receivable

P e a c h t r e e A c c o u n t i n g P a g e | 36

NATOGYI) AIT Computer Centre

1500 Account Receivable Other Current Assets

1600 Fixed Assets Fixed Assets

1900 Accum: Depreciation Accumulated

Depraciation

2000 Creditor Account Payable

2400 Long Term Liabilities Long Term Liabilities

2500 Capital Eq ’

2600 Retained Earning Equity Retain Earning

2700 Drawing Equity Gets Closed

3000 Sales Income

4000 Cost of Goods Sold Cost of Sale

5000 Administrative Expenses Expenses

6000 Selling & Distribution Expenses

7000 Other Expenses Expenses

P a g e | 37

NATOGYI) AIT Computer Centre

Chapter 7

7

7.1 Event 1

1 January 2004 Golden Tiger Co., started in business with capital 500,000

Kyat.

Cash - Debit

Capital - Credit

Paid up Capital

Customer & Sale Receive Money Receive Money From Customer

Banking Receive Money Receive Money From Customer

P e a c h t r e e A c c o u n t i n g P a g e | 38

NATOGYI) AIT Computer Centre

-

P e a c h t r e e A c c o u n t i n g P a g e | 39

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 40

NATOGYI) AIT Computer Centre

7.2 Customer

Customer ID = 1

Name = Boss

GL sales Account = 2500

P e a c h t r e e A c c o u n t i n g P a g e | 41

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 42

NATOGYI) AIT Computer Centre

Print the General Ladger Report

Company Report

P e a c h t r e e A c c o u n t i n g P a g e | 43

NATOGYI) AIT Computer Centre

General Ledger General Ledger

P e a c h t r e e A c c o u n t i n g P a g e | 44

NATOGYI) AIT Computer Centre

P a g e | 45

NATOGYI) AIT Computer Centre

Chapter 8

8

8.1 Event 2

2 January 2004 Golden Tiger Co., borrowed 300,000 from AWB Bank

Cash - Debit

AWB Bank Loan - Credit

P e a c h t r e e A c c o u n t i n g P a g e | 46

NATOGYI) AIT Computer Centre

Customer ID = 2

Name = AWB Bank

GL Sales Account = 2401

P e a c h t r e e A c c o u n t i n g P a g e | 47

NATOGYI) AIT Computer Centre

P a g e | 48

NATOGYI) AIT Computer Centre

Chapter 9

9

9.1 Event 3

3 March 2004 Purchased of Furniture worth 50,000.

Furniture A/C - Debit

Cash - Credit

Venders & Purchases

Pay Bills Pay Bill

P e a c h t r e e A c c o u n t i n g P a g e | 49

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 50

NATOGYI) AIT Computer Centre

Vendor ID = 1

Name = Furniture

Expense Account = 1601

P e a c h t r e e A c c o u n t i n g P a g e | 51

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 52

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 53

NATOGYI) AIT Computer Centre

Print the Cash Payment Transaction

P a g e | 54

NATOGYI) AIT Computer Centre

Chapter 10

10

10.1 Event 4

1 April 2004 Credit Purchase of 80,000 from Star Company.

Inventory - Debit

Star Company - Credit

Set Up Inventory

Inventory & Services Inventory

Maintain Inventory It

P e a c h t r e e A c c o u n t i n g P a g e | 55

NATOGYI) AIT Computer Centre

Information

Item ID = 001

Description = Book

Item Class = Stock Item

GL Sales Account = 3000

GL Inventory Account = 1300

GL Cost of Sales Account = 4000

P e a c h t r e e A c c o u n t i n g P a g e | 56

NATOGYI) AIT Computer Centre

Set Up Vendors

Vendors & Purchases Vendors New Vendor

P e a c h t r e e A c c o u n t i n g P a g e | 57

NATOGYI) AIT Computer Centre

Vendor ID = 001

Name = Star Company

Expense Account = 4000

P e a c h t r e e A c c o u n t i n g P a g e | 58

NATOGYI) AIT Computer Centre

Inventory & Services Receive Inventory Receive

Inventory

P e a c h t r e e A c c o u n t i n g P a g e | 59

NATOGYI) AIT Computer Centre

Print the General Ladger

P e a c h t r e e A c c o u n t i n g P a g e | 60

NATOGYI) AIT Computer Centre

Print the Vendor Ladger

P e a c h t r e e A c c o u n t i n g P a g e | 61

NATOGYI) AIT Computer Centre

P a g e | 62

NATOGYI) AIT Computer Centre

Chapter 11

11

11.1 Event 5

1 April 2004 Carriage Inwords – 3,500.

Carriage Inword - Debit

Cash - Credit

Vendor ID = 2

Name = Carriage Inwords

Carriage Inword, Cost of Sales

P e a c h t r e e A c c o u n t i n g P a g e | 63

NATOGYI) AIT Computer Centre

P a g e | 64

NATOGYI) AIT Computer Centre

Chapter 12

12

12.1 Event 6

15 April 2004 Cash Purchase – 70,000.

Purchase - Debit

Cash - Credit

Cash Purchase, Cost of Sales

P e a c h t r e e A c c o u n t i n g P a g e | 65

NATOGYI) AIT Computer Centre

P a g e | 66

NATOGYI) AIT Computer Centre

Chapter 13

13

13.1 Event 7

1 May 2004 Cash Sale 75,000.

Cash - Debit

Sale - Credit

Customers & Sales Receive Money

P e a c h t r e e A c c o u n t i n g P a g e | 67

NATOGYI) AIT Computer Centre

P a g e | 68

NATOGYI) AIT Computer Centre

Chapter 14

14

14.1 Event 8

6 June 2004 Credit Sale of 25,000 to Thitsar Store.

Thitsar Store - Debit

Sale - Credit

Customers & Sales Customers New Customer

Customer ID = 001

Name = Thitsar Store

GL sales account = 3000

P e a c h t r e e A c c o u n t i n g P a g e | 69

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 70

NATOGYI) AIT Computer Centre

14.2 Event 9

18 June 2004 Cash Purchase 40,000.

Purchase - Debit

Cash - Credit

Vendor ID = 4

Name = Cash Purchase

Expense Account = 4000

P e a c h t r e e A c c o u n t i n g P a g e | 71

NATOGYI) AIT Computer Centre

Vendor ID = 4

Check number =004

Date = 18 Jun 2004

Amount = 40000

P e a c h t r e e A c c o u n t i n g P a g e | 72

NATOGYI) AIT Computer Centre

14.3 Event 10

1 July 2004 Purchased of office equipment 20,000.

Office Equipment - Debit

Cash - Credit

P e a c h t r e e A c c o u n t i n g P a g e | 73

NATOGYI) AIT Computer Centre

5, Office Equipment, 1602

Vendor ID = 5

Check number =006

Date = 1 Jul 2004

GL Account = 1602

Amount = 20000

P e a c h t r e e A c c o u n t i n g P a g e | 74

NATOGYI) AIT Computer Centre

P a g e | 75

NATOGYI) AIT Computer Centre

Chatper 15

15

15.1 Event 11

3 July 2004 Cash Payment to Star Company – 80,000.

Star Company - Debit

Cash - Credit

E

Pay Bill

Vendor ID = 001

Check number = 005

Date = 3 Jul 2004

Amount = 80000

P e a c h t r e e A c c o u n t i n g P a g e | 76

NATOGYI) AIT Computer Centre

P a g e | 77

NATOGYI) AIT Computer Centre

Chapter 16

16

16.1 Event 12

5 July 2004 Cash Receipt from Thitsar Store 15,000.

Cash - Debit

Thitsar Store - Credit

E

Customers & Sales Receive Money Receive Money from Customer

Customer ID

Amount Paid

Payment

P e a c h t r e e A c c o u n t i n g P a g e | 78

NATOGYI) AIT Computer Centre

P a g e | 79

NATOGYI) AIT Computer Centre

Chapter 17

17

17.1 Event 13

6 August 2004 Golden Tiger Co., drawed Cash 10,000.

Drawing - Debit

Cash - Credit

6, Boss, 2700

Vendor ID = 6

Check number = 007

Date = 6 August 2004

Amount = 10000

P e a c h t r e e A c c o u n t i n g P a g e | 80

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 81

NATOGYI) AIT Computer Centre

17.2 Event 14

1 October 2004 Payment to Advertising Co., 5,000.

Advertising - Debit

Cash - Credit

E

Ven

7, Advertising, 5001

Vendor ID = 7

P e a c h t r e e A c c o u n t i n g P a g e | 82

NATOGYI) AIT Computer Centre

Check number = 008

Date = 1 Oct 2004

Amount = 5000

17.3 Event 15

3 October 2005 Cash Sale 60,000.

Cah - Debit

Sale - Credit

P e a c h t r e e A c c o u n t i n g P a g e | 83

NATOGYI) AIT Computer Centre

Customer ID = 3

Reference = 009

Date = 3 Oct 2004

Amount = 60000

P e a c h t r e e A c c o u n t i n g P a g e | 84

NATOGYI) AIT Computer Centre

P a g e | 85

NATOGYI) AIT Computer Centre

Chapter 18

18

18.1 Event 16

1 November 2004 Payment to Shop Rental 24,000.

Shop Rental - Debit

Cash - Credit

E ါ

P e a c h t r e e A c c o u n t i n g P a g e | 86

NATOGYI) AIT Computer Centre

Customer ID = 8

Check Number = 010

Date = 1 Nov 2004

GL Account = 5002

Amount = 24000

P a g e | 87

NATOGYI) AIT Computer Centre

Chapter 19

19

19.1 Event 17

31 December 2004 Payment to Salary 50,000.

Salary - Debit

Cash - Credit

E ါ

9, Salary, 5003

P e a c h t r e e A c c o u n t i n g P a g e | 88

NATOGYI) AIT Computer Centre

Customer ID = 9

Check Number = 012

Date = 31 Dec 2004

GL Account = 5003

Amount = 50000

P e a c h t r e e A c c o u n t i n g P a g e | 89

NATOGYI) AIT Computer Centre

P a g e | 90

NATOGYI) AIT Computer Centre

Chapter 20

20 Adjustment

E

Co

E

P e a c h t r e e A c c o u n t i n g P a g e | 91

NATOGYI) AIT Computer Centre

20.1

Furniture Depreciation 10 %

Dep of Furniture - Debit

Account of Dep Furniture - Credit

P e a c h t r e e A c c o u n t i n g P a g e | 92

NATOGYI) AIT Computer Centre

20.2 (Office Equipment)

Office Equipment Depreciation 10 %

Dep of Office Equipment - Debit

P e a c h t r e e A c c o u n t i n g P a g e | 93

NATOGYI) AIT Computer Centre

Account of Dep Office Equipment - Credit

20.3 (Adjusting Closing Stock)

Closing Stock Inventory - Debit

Closing Stock COS - Credit

P e a c h t r e e A c c o u n t i n g P a g e | 94

NATOGYI) AIT Computer Centre

P a g e | 95

NATOGYI) AIT Computer Centre

Chapter 21

21 Trial Balance

Company

General Ledger

P e a c h t r e e A c c o u n t i n g P a g e | 96

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 97

NATOGYI) AIT Computer Centre

P a g e | 98

NATOGYI) AIT Computer Centre

Chapter 22

22 Income Statement

Financial Statements

P e a c h t r e e A c c o u n t i n g P a g e | 99

NATOGYI) AIT Computer Centre

P a g e | 100

NATOGYI) AIT Computer Centre

Chapter 23

23 Balance Sheet

Balance Sheet, 31 December 2004

Financial Statements Balance Sheet

P e a c h t r e e A c c o u n t i n g P a g e | 101

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 102

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 103

NATOGYI) AIT Computer Centre

P e a c h t r e e A c c o u n t i n g P a g e | 104

NATOGYI) AIT Computer Centre

Manual Accounting

P a g e | 105

NATOGYI) AIT Computer Centre

၂ ၄

24

24.1 (Account)

The form of record kept with each item is known as an account.

(Transactions)

24.2 (Ledger)

A group of accounts is known as a ledger.

P e a c h t r e e A c c o u n t i n g P a g e | 106

NATOGYI) AIT Computer Centre

24.3

Debit( ) Credit( )

………………Account

Debit Size Credit Size

Date Particular Fo Amount Date Particular Fo Amount

24.4 (Double Entry)

For every transaction, there must be a debit in one account and a credit in

another account.

Transaction Account

(Double Entry) Account

Debit Side Account Credit Side

Dr Cr Dr Cr

xxxxx xxxxxx

P e a c h t r e e A c c o u n t i n g P a g e | 107

NATOGYI) AIT Computer Centre

Debit -

Credit -

24.5 (Debit Side)

24.6 (Credit Side)

P e a c h t r e e A c c o u n t i n g P a g e | 108

NATOGYI) AIT Computer Centre

24.7 Debit & Credit

24.8

P e a c h t r e e A c c o u n t i n g P a g e | 109

NATOGYI) AIT Computer Centre

24.9

P e a c h t r e e A c c o u n t i n g P a g e | 110

NATOGYI) AIT Computer Centre

(Cash Acco

(Creditor Accoun

(Purchase Returned Acco

P e a c h t r e e A c c o u n t i n g P a g e | 111

NATOGYI) AIT Computer Centre

(Debtor)

(Creditor)

(Balance Carried Down) (Balance C/D)

P e a c h t r e e A c c o u n t i n g P a g e | 112

NATOGYI) AIT Computer Centre

24.10 (Trial Balance)

The balance of each account is listed on the trial balance. If the total of

two columns agree, we can say that the book-keeping is arithmetically accurate.

(Trial Balance)

Debit Credit

…………… Account xxxxx

…………… Account xxxxx

…………… Account xxxxx

…………… Account xxxxx

100000 100000

P e a c h t r e e A c c o u n t i n g P a g e | 113

NATOGYI) AIT Computer Centre

24.11 ERRORS

Errors not affecting trial balance agreement

1.Errors of Omission

Eg: Office furmiture has been purchased for E 215 on credit form Deelers

Ltd and has not been recorded.

P e a c h t r e e A c c o u n t i n g P a g e | 114

NATOGYI) AIT Computer Centre

2.Errors of Commission

Eg:A sale of goods E 190 on credit to T. Winter had been entered in the

account of D. Winter.

3.Reversal of entries

Eg: Purchase of goods for cash E 360 has been entered as debit to cash

account and a credit to purchase account.

4.Error of principle

Eg: A payment of 315 for repairs to the motor vehicle has been wrongly

debited to motro vehicle account.

P e a c h t r e e A c c o u n t i n g P a g e | 115

NATOGYI) AIT Computer Centre

5.Error of original entry

Eg: A sale of goods E 87 on credit to F. Sharp has been entered in the

books as E 78.

6.Compensating error

Eg: Telephone account is over-stated by E 10 and sales account is also

over-stated by E 10 .

(Errors of Compensating)

P e a c h t r e e A c c o u n t i n g P a g e | 116

NATOGYI) AIT Computer Centre

7.Error of Duplication

Eg: A transaction is entered correctly in the book and then, in error, is

entered again.

P a g e | 117

NATOGYI) AIT Computer Centre

၂ ၅

25 (Classification of Accounts)

25.1

Ledger Account

Personal Accounts Impersonal Accounts

Real Accounts Nominal Accounts

Expenses Income

P e a c h t r e e A c c o u n t i n g P a g e | 118

NATOGYI) AIT Computer Centre

Cash

E

E

Real Account = Cash A/C, Bank A/C, Stock A/C, Car A/C, Furniture

A/C, Building A/C

Expense Account = Rent Paid A/C, Salary A/C, Wages A/C, Telephone

Charges A/C, Interest Paid A/C, Discount Allowed A/C

P e a c h t r e e A c c o u n t i n g P a g e | 119

NATOGYI) AIT Computer Centre

Income Account = Rent Received A/C, Interest Received A/C, Other

Income A/C, Discount Received A/C

1. Land & Building Account

2. Electircity Bill Account

3. Thomas Account

4. Plant & Machinery Account

5. Furniture Account

6. Discount Allowed Account

7. Discount Received Account

8. Interest Payable Account

9. Interest Receivable Account

10. Insurance Account

11. Insurance Receivable Account

12. Light & Heat Account

13. Motor Vehicles Account

14. Frederick Williams Account

15. Stationary Account

16. Wages & Salaries Account

17. Rent & Rates Account

18. Commission Receivble Account

19. Cash & Bank Account

1. Real Accounts

2. Expense Accounts

3. Personal Account

P e a c h t r e e A c c o u n t i n g P a g e | 120

NATOGYI) AIT Computer Centre

4. Real Account

5. Real Account

6. Expense Account

7. Income Account

8. Expense Account

9. Income Account

10. Expense Account

11. Income Account

12. Expense Account

13. Real Account

14. Personal Account

15. Expense Account

16. Expense Account

17. Expense Account

18. Expense Account

19. Income Account

20. Real Account

25.2 Ledger Accounts

Real Account

Debit - what comes in

Credit - what goes out

P e a c h t r e e A c c o u n t i n g P a g e | 121

NATOGYI) AIT Computer Centre

Personal Account

Debit - Receiver

Credit - Giver

Creditors

Nominal Account

Debit - Expenses

P e a c h t r e e A c c o u n t i n g P a g e | 122

NATOGYI) AIT Computer Centre

Credit - Income

E

E

Capital Account

Drawing Account

Purchases Account

(Goods,Stocks,Merchandise

P e a c h t r e e A c c o u n t i n g P a g e | 123

NATOGYI) AIT Computer Centre

Sales Account

Purchases Return Account

Sales Return Account

Sales Return A

Balance c/d

− Balance c/d or balance c/f

i.e Balance carried down or Balance carried forward.

Balance b/d

− Balance b/d or Balance b/f

i.e Balance brought down or Balance brought forward.

P a g e | 124

NATOGYI) AIT Computer Centre

၂ ၆

26

26.1 Book Keeping Procedure

1.

2.

3. T

4. E

5. E

6.

P e a c h t r e e A c c o u n t i n g P a g e | 125

NATOGYI) AIT Computer Centre

Writing in the relevant Day Books

Journal

Cash Book

Sale Day Book

Sale Returned Day Book

Purchase Day Book

Purchase Returned Day Book

Petty Cash Book

Vourcher

General Ledger

Sale Ledger

P e a c h t r e e A c c o u n t i n g P a g e | 126

NATOGYI) AIT Computer Centre

Purchase Ledger

Debit Credit

xxxxx xxxxx

E

Depreciation of fixed Assets

Bad Debts & Provision for Bad Debts

Accrued Income or Account Receivable

Accrued Expenses or Account Payable

P e a c h t r e e A c c o u n t i n g P a g e | 127

NATOGYI) AIT Computer Centre

Prepaid Expenses or Advance Payment

Pre-received Income or Advnace Receipt

Adjusting the Closing Stock

E

Trading, Profit & Loss Account

Balance Sheet

P a g e | 128

NATOGYI) AIT Computer Centre

၂ ၇

27

27.1 (Cash Book)

Cash Book

Date Particular Fo Cash Date Particular Fo Cash

Balance b/d xxxxx

Balance c/d xxxxx

Balance b/d xxxxx xxxxx

P e a c h t r e e A c c o u n t i n g P a g e | 129

NATOGYI) AIT Computer Centre

27.2 (Petty Cash Book)

− Credit

− Debit

P e a c h t r e e A c c o u n t i n g P a g e | 130

NATOGYI) AIT Computer Centre

(Petty Cash Book) R

ecei

pt

Fo

Dat

e

Par

ticu

lar

Vo

uche

r N

o

To

tal

Car

Exp

Po

stag

e

Tra

vel

ling

Ex

pen

se

Wag

es

20 Feb

1

Balanc

e b/d

80 Feb

1

Cash

Restore

d

75

Feb

28

Balanc

e c/d

25

100 100

25 Mar

1

Balanc

e b/d

75 Mar

1

Cash

Restore

d

P e a c h t r e e A c c o u n t i n g P a g e | 131

NATOGYI) AIT Computer Centre

Journal Day Book

Date Particular Folio Debit Credit

April 1 Cash A/C 300,000

Capital A/C 300,000

P e a c h t r e e A c c o u n t i n g P a g e | 132

NATOGYI) AIT Computer Centre

Sale Day Book

Date Invoice No Debtors Name Fo Amount

Total

Purchase Day Book

Date Invoice No Creditors Name Fo Amount

Total

P e a c h t r e e A c c o u n t i n g P a g e | 133

NATOGYI) AIT Computer Centre

Sale Returned Book

Date Invoice No Debtors Name Fo Amount

Total

Purchase Returned Book

Date Invoice No Creditors Name Fo Amount

Total

P a g e | 134

NATOGYI) AIT Computer Centre

28 (Adjusting Entries)

28.1 (Provisions & Adjustings)

(Depreciation of Fixed Assets)

(Bad Debts & Provision for Bad Debts)

(Accrued Income or Account Receivable)

(Accrued Expense or Account Payable)

(Prepaid Expense or Advance Payment)

(Pre-recicvede Income or Advance Receipt)

(Adjusting the Closing Stock)

(Depreciations of Fixed Asset)

P e a c h t r e e A c c o u n t i n g P a g e | 135

NATOGYI) AIT Computer Centre

(Depreciation Methods)

(Straight Line Methods)

(Reducing Methods)

(Bad Debts & Provision for Bad Debts)

(Bad Debts)

Debit

P e a c h t r e e A c c o u n t i n g P a g e | 136

NATOGYI) AIT Computer Centre

= Credit

(Provision for Bad Debts)

(Accrued Income or Account Receivable)

− Debit

− Credit

P e a c h t r e e A c c o u n t i n g P a g e | 137

NATOGYI) AIT Computer Centre

(Accrued Expense or Account Payable)

− Debit

− Credit

(Prepaide Expense or Advance Payment)

P e a c h t r e e A c c o u n t i n g P a g e | 138

NATOGYI) AIT Computer Centre

− Debit

− Credit

(Pre-receivede Income or Advance Receipt)

− Debit

P e a c h t r e e A c c o u n t i n g P a g e | 139

NATOGYI) AIT Computer Centre

− Credit

(Adjusting the Closing Stock)

− Debit

− Credit

P a g e | 140

NATOGYI) AIT Computer Centre

၂ ၉

29 (Final Account)

29.1

29.2 (Trading Account)

= -

Gross Profit = Sales − Cost of Sales

= -

Gross Loss = Cost of Sales − Sales

P e a c h t r e e A c c o u n t i n g P a g e | 141

NATOGYI) AIT Computer Centre

29.3 (Cost of Sales)

(Opening Stock) xxx

(Purchase) xxx

(−) (Purchase Returned) (xx)

(Carriage Inwords) xxx xxx

(−) (Closing Stock) (xxx)

(Cost of Sales) xxxx

29.4 (Profit & Loss Account)

+ − =

Gross Profit + Income - Expenses = Net Profit

P e a c h t r e e A c c o u n t i n g P a g e | 142

NATOGYI) AIT Computer Centre

29.5 (Balance Sheet)

= +

Assets = Capital + Liabilities

29.6 (Assets)

(Fixed Assets)

(Current Assets)

P e a c h t r e e A c c o u n t i n g P a g e | 143

NATOGYI) AIT Computer Centre

29.7 (Liabilities)

(Current Liabilities)

(Long term Liabilities)

29.8 (Capital)

P e a c h t r e e A c c o u n t i n g P a g e | 144

NATOGYI) AIT Computer Centre

Trading, Profit & Loss Account

Sales xxxxxx

(-) Sales Returned (xxx)

(-) Carriage Outward (xxx) xxxxx

(-) Cost of Sales

Opening Stock xxxx

Purchases xxxx

(-) Purchase Returned (xxx)

(+) Carriage Inward xxx xxxx

(-) Closing Stock (xxxx) (xxxxx)

Gross Profit xxxxx

Income xxxx

Dis: Received xxxx

Interest Received xxxx xxxx

(-) Expenses

Dis: Allowed xxx

Depreciations xxx

P e a c h t r e e A c c o u n t i n g P a g e | 145

NATOGYI) AIT Computer Centre

Bad Debts xxx

Telephone xxx

Travelling xxx

Wages xxx

Salary xxx (xxxx)

Net Profit xxxx

P e a c h t r e e A c c o u n t i n g P a g e | 146

NATOGYI) AIT Computer Centre

Balance Sheet

Assets

Fixed Assets

Motor Vehicle xxxx

(-) Provisions for Depreciation (xxx) xxxx

Furniture xxxx

(-) Provisions for Depreciation (xxx) xxxx xxxxx

Current Assets

Closing Stock xxxx

Debtors xxxx

(-)Provisions for Bad Debts (xxx) xxxx

Prepaid Expenses xxxx

Accrued Income xxxx

Cash xxxx

Bank xxxx xxxxx

xxxxxx

Capital & Liabilities

Capital xxxx

P e a c h t r e e A c c o u n t i n g P a g e | 147

NATOGYI) AIT Computer Centre

(+)Net Profit or xxx

(-)Net Loss (xxx)

(-) Drawing (xxx) xxxxx

Liabilities

Current Liabilities

Creditors xxxx

Bank Overdraft xxxx

Accured Expenses xxx

Pre-received Income xxx xxxxx

Long Term Liabilities

Loan xxxx

Bank Loan xxxx xxxxx xxxxx

xxxxxx

P e a c h t r e e A c c o u n t i n g P a g e | 148

NATOGYI) AIT Computer Centre

Accounting Formula

Profit = Income – Expense

Income

Expense

Profit

Loss = Expense - Income

Income

Expense

Loss

Assets = Capital + Liabilities

Assets

Capital

Liabilities

၁။ ။

၂။

၃။ ။

၄။ Peachtree

၅။ Peachtree A

၆။ Excel , Peachtree MYOB

၇။

Computer Basic Course & D.T.P

၊ ၊ Myanmar

Unicode 3 ၊ ၊ ၊

၊ ၊

၊ ၊

(1) Introduction to Window System

(2) English & Myanmar Typing

Win Innwa

Myanmar Unicode 3

(3) Microsoft Office Word 2010

(4) Microsoft Office Excel 2010

(5) Microsoft Office PowerPoint 2010

(6) Adobe PageMaker 7.0

(7) Adobe InDesign CS5

(8) Microsoft Paint

(9) Window Explorer

(10) MultiMedia

(11) Using E-mail & Internet

Internet Explorer

Mozilla Firefox

Gtalk & Gmail

Internet Download Manager

Facebook

(12) MP3,MP4 Converting

Format Factory, Xilisoft Converter

(13) Nero Burning

Graphic Design Course

၊ ၊ ၊

၊ ၊ ၊ ၊

၊ ။

(1) Introduction to Window System

(2) English & Myanmar Typing

Myanmar Unicode 3

(3) Adobe PhotoShop CS3

(4) Adobe Illustrator CS3

(5) Corel Draw 15

(6) Window Explorer

(7) Software Security & Maintenance

(8) Multimedia

Jet Audio 7

Power DVD 11

GOM Player

VLC Player

iTune

(9) Nero Burning

Close Disk

Multi Session Disk

(10) Antivirus Software

Kaspersky Antivirus 2012 & Update

(11) Manual-killing Virus

Virus in Memory Stick

Video Editing Course

၊ ၊ ၊

၊ , ၊

(1) ShowBiz DVD 2

(2) Pinnacle Studio v 15

(3) Ulead Video Studio v14

(4) Power Director v 9

(5) Premiere Pro 1.5

(6) Creating DVD(Procoder, Movie Factory 7,TMPEG Encoder)

(7) Special Title & Karaoke Title(Ulead Cool 3 D, Other)

(8) Plug-Ins Linking

ProDAD Adorage

Pinnalce Hollywood FX

Canopus Video FX

Boris FX 9

Procoder

(9) Other Editing Software

Edius 6

Sony Vegas Pro 9

Sony DVD Architect Pro 5.0

Adobe Encore

After Effect

Cinema 4D

3D MAX

A+ Hardware Course

System Unit CPU,

Memory, Motherboard, Hard Disk, Power Supply, UPS ....

O.S ၊ Hardware Drivers

၊ Fonts ၊ Virus

Antivirus Software Install ၊ Update ၊

Application Software ( ၊ ၊

၊ )

+

Pratical Skills Experience

(1) Understanding Hardware in detail

(2) Installing Operating System

Window XP,Window Vista,Window 7,Window 8

(3) Installing Driver

(4) Installing Application Software

(5) Installing System Utility & Using them

(6) Linking Plug-in File for Video Editing and 3D MAX

(7) Installing Game & How to crack them

(8) Installing Internet Software & How to use them

(9) Installing Antivirus & How to update them

(10) Killing Virus using Registry, Group Policy, Security Policy

(11) Networking Basic (LAN, Internet, WiFi)

Networking Course

၊ ၊

၊ ၊ ၊

၊ ၊

၊ ၊ ၊

Networking Cour

၊ ၊

Ro

၊ ၊

၊ ၊

Advanced Information Technology for All

။ ။

။ ၊

။ -

1 English Typing (Mavis Beacon v 20,..)

2 Myanmar Typing (Win Innwa, Myanmar Unicode, Zawgyi Unicode,…)

3 Microsoft Office Suite 2010 (Word, Excel, PowerPoint, Visio, ..) and Paint

4 Adobe PageMaker 7

။ ။

၊ ၊ ၊ ။

1 Adobe Photoshop CS5

2 Nero Burning or Other Burning (Alcohol, etc..)

။ ။

1 ArcSoft ShowBiz DVD v 2

2 Pinnacle v 15

3 Power Director v 9

4 Ulead Video Studio v 13

5 Adobe Premiere Pro CS 5

။ ။

။ - ၊ -

။ -

Networking ။ ။ ၊

။ ။ ၊ ၊

Softw

။ ။

။ ။

AIT Computer Centre

AIT -၁ (NATOGYI)

AIT -၂ Window Registry (NATOGYI)

AIT -၃ A+ (NATOGYI)

AIT -၄ Microsoft Window (NATOGYI)

AIT -၅ Local Area Netwrok (NATOGYI)

AIT -၆ ShowBiZ DVD v 2 (NATOGYI)

AIT -၇ Ulead Video Studio v 13 (NATOGYI)

AIT -၈ Power Director v 9 (NATOGYI)

AIT -၉ Pinnacle Studio v 15 (NATOGYI)

AIT -၁၀ Adobe Premiere Pro v 1.5 (NATOGYI)

AIT -၁၁ MS Office Word 2010 (NATOGYI)

AIT -၁၂ Software Installation Guide (NATOGYI)

AIT -၁၃ Cafe Suite (NATOGYI)

AIT -၁၄ MYOB Accounting (NATOGYI)

AIT -၁၅ Wireless Network (NATOGYI)

AIT -၁၆ Modem & Internet (NATOGYI)

AIT -၁၇ Internet Gateway Server (NATOGYI)

AIT -၁၈ Web Server (NATOGYI)

AIT -၁၉ File Server (NATOGYI)

AIT -၂၀ Active Directory (NATOGYI)

AIT -၂၁ DHCP Server (NATOGYI)

AIT -၂၂ Computer Basic (NATOGYI)

AIT -၂၃ Peachtree Accounting 2010 (NATOGYI)

AIT -၂ ၄ VPN Server (NATOGYI)

AIT -၂ ၅ PageMaker 7 (NATOGYI)

AIT -၂ ၆ Group Policy (NATOGYI)

AIT -၂ ၇ Network Security (NATOGYI)

AIT -၂၈ DNS Server (NATOGYI)

AIT -၂၉ Office Excel 2010 (NATOGYI)

AIT -၃၀ Office PowerPoint 2010 (NATOGYI)

AIT -၃၁ Net Station (NATOGYI)

AIT -၃၂ Cafezee (NATOGYI)

၁။ ၊ ၊ ၃ ။

၂ ။ ၊ ၊

၊ ၊

၊ ၊ ၊

၊ ။

၃။

၄။ ၁၉၉၉ ၁၀ ၂ ၊

၊ ၊ ၊

၊ ၊

၅။ ၊

၊ ၊

၆။ ၊ ။

၇။ ၊

၈။

IDCS, IADCS, B. ။

၉။

(Syscon Computer Centre ။

၁ ။

၁၁။

၊ ၊ ၊

(Systemer)