A Step-by-Step Million Million Accounting Workbook Workbook
This workbook is designed according to the latest version of MILLION Accounting Software. It is catered mainly for companies which would like to computerise their account departments. The simple “step-by-step” guide aids beginner understanding. It is in every confidence that this workbook will beneficial to all.
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means; electronic, mechanical, photocopying, recording and or otherwise, without the prior written permission of Million Software Sdn Bhd No patent liability is assumed with respect to the use of the information contained herein. Every precaution has been made to supply complete and accurate information. However, Million Software .neither resumes responsibility for its use, nor for any infringement of patents or other rights of third parties which would result. COPYRIGHT 2011. Million SOFTWARE Sdn Bhd (Last Modified on June 2014)
Published By: MILLION SOFTWARE SDN BHD Head Office: 35A, Jalan Kebudayaan 4, Taman University, 81300 Skudai, Johor Bahru, Johor. Tel :+6(07)520 3434 Fax :+6(07)520 1949 Branch Office: 72-2,Persiaran Bayan Indah, Bayan Bay, 11900 Bayan Lepas Penang. Tel: +6(04)638 4911 Website: www.million.my E-mail:
[email protected] /
[email protected]
Copyright of Million Software Sdn Bhd
Page
1
A Step-by-Step Million Million Accounting Workbook Workbook
1. System Requirements Before we continue, please ensure that your computer has the minimum specifications mentioned below.
Processor Type
Pentium 4 or higher
Processor Speed
1GHz or higher
Operating System
Microsoft Windows XP or later
Memory (RAM)
1GB or more
Hard Disk
Approximately 1GB of available hard-disk space
Display
Super VGA (1024 X 768) or higher-resolution video adapter or monitor
Other Devices
Mouse or compatible pointing devices
Copyright of Million Software Sdn Bhd
Page
2
A Step-by-Step Million Million Accounting Workbook Workbook
1. System Requirements Before we continue, please ensure that your computer has the minimum specifications mentioned below.
Processor Type
Pentium 4 or higher
Processor Speed
1GHz or higher
Operating System
Microsoft Windows XP or later
Memory (RAM)
1GB or more
Hard Disk
Approximately 1GB of available hard-disk space
Display
Super VGA (1024 X 768) or higher-resolution video adapter or monitor
Other Devices
Mouse or compatible pointing devices
Copyright of Million Software Sdn Bhd
Page
2
A Step-by-Step Million Million Accounting Workbook Workbook
CONTENTS Page
1.
Preface
1
2.
System Requirement
2
3.
Content
3
4.
Lesson 1
- Setting Company Profile - Create chart of accounts - Create Debtor & Creditor account - Organise batches - Add / Edit / Delete Transaction - Print Reports - Assignment 1
4-8
5.
Lesson 2
- Open Item Debtor & Creditor - Foreign Currency Transaction - Enter opening balance - Maintain Stock Value - Post Dated Cheques - Bank Reconciliation Statement - Transaction involving period 13 - Year End Processing - Assignment 2
8 – 15
6.
Lesson 3
- Departmental Account - Assignment 3
16 - 19
7.
Lesson 4
- Manufacturing Account - Maintain Multiple Stock Value - Assignment 4
20 - 23
8.
Lesson 5
- Non Profit Organization Account -Assignment 5
24 - 27
9.
Lesson 6
GST Assignment
28 - 32
10. Answers for Assignments
33 - 45
11. Appendix I
46 - 51
- Sample Chart of accounts - Trading Company - Manufacturing Company - Non-Profit Organisation Account
Copyright of Million Software Sdn Bhd
Page
3
A Step-by-Step Million Million Accounting Workbook Workbook
Lesson 1
Objectives: Learn how to: (1)
Set up Company Profile
(2)
Create Chart of Accounts
(3)
Debtor and Creditor File Maintenance
(4)
Maintain Batches
(5)
Be able to differentiate between Single and Fast Fast Entry at GL Transaction
(6)
Print the Chart of Accounts, Accounts, General Ledger and Trading and Profit & Loss Loss Account Account
(7)
Learn the correct way to backup your directory
(8)
Edit Chart of Accounts
(9)
Learn how to Search for a Transaction Edit a Transaction Delete a Transaction
• • •
Copyright of Million Software Sdn Bhd
Page
4
A Step-by-Step Million Million Accounting Workbook Workbook
ASSIGNMENT 1 G Company , to add the following Go to System fo llowing company profile General eneral Setup Company
Company Name Registration No. Accounting Period Actual Start Date
: Sunrise Trading Sdn Bhd : 168958-A : 01/01/2012 – 31/12/2012 : 01/01/2012
Set the format type for the accounts a ccounts codes: Account Format: XXXX/XXXX XXXX/XXXX ( System General General Setup Options Options ) )
1. Create the following Chart Chart of Account Numbers: (Go to General GL GL Accounts Add Add the below general chart of accounts.)
Account Number
A/C Description Descripti on
A/C Group
Classified As
1000/0000 1050/0000
Capital Retained Earning
Capital & Reserves Capital & Reserves
Retained Earning
1051/0000
Current Profit & Loss
Capital & Reserves
Current Year Profit / (Loss)
3000/0000
Trade Debtors
Current Assets
Debtor
3010/0000 3020/0000
Bank Cash In Hand
Current Assets Current Assets
Bank Cash
4000/0000 5000/0000
Trade Creditors Sales
Current Liabilities Revenue
Creditor Sales
6010/0000 9001/0000
Purchases Discount Allowed
Cost Of Goods Sold Expenditure
Purchases -
9005/0000 9010/0000
Salaries Telephone
Expenditure Expenditure
-
9015/0000
Water & Electricity
Expenditure
-
2. Add the following Debtors: (Go to Debtors Debtor Debtor Maintenance Add )
Billing Address
Phone Numbers
Debtor No.
Name
3000/M001 3000/M002 3000/S001
Maya Plastic Trading 112, Jalan Payu, Tampoi, JB 07-3340707 Microsoft Sdn Bhd No. 5, Jalan Harimau, KL 03-9543262 Sakura Communication Co 333, Jalan Bintang, Penang 04-3322556
3. Add the following Creditors: (Go to Creditors Creditor Creditor Maintenance Add )
Creditor No. 4000/A001 4000/T001
Name Aloha Corporation Time Dotcom Sdn Bhd
Copyright of Million Software Sdn Bhd
Address No. 10, Jalan Suria 19, JB No. 56, Jalan Merah, KL
Phone Numbers 07-3328378 03-5432626 Page
5
A Step-by-Step Million Accounting Workbook
4.
Create the following batches: (General Batch ) Add
Code 10 20
30 40 50
Description CREDIT SALES CREDIT PURCHASES
Batch Type Sales Purchases
BANK CASH CN / DN
Bank Cash Journal
( Select From Month = January To January Year = 2012 Generate Yes)
5.
Add the following Credit Sales Transactions (Go to Debtors Invoice Add )
02/01/2012 05/01/2012 06/01/2012
6.
Ref. No. Inv2001 Inv2002 Inv2003
RM 13,600.00 3,500.00 18,000.00
Ref. No. Purchased from Aloha Corporation Inv 2100 Purchased from Time Dotcom Sdn Bhd I 88556
RM 17,600.00 8,800.00
Sales to Maya Plastic Trading Sales to Microsoft Sdn Bhd Sales to Sakura Communication Co
Add the following Credit Purchases Transactions ( Go to Creditors Purchases Invoice
01/01/2012 05/01/2012
7.
Add
)
Add the following Bank Transactions (Go to General Cash Book Payment Add)
Ref. No.
31/01/2012 31/01/2012 31/01/2012
8.
Salaries Telephone Water & Electricity
PV0101 PV0102 PV0103
RM
1,800.00 500.00 300.00
Add the following Cash Transactions (Go to General Cash Book Receipt Add)
21/01/2012 31/01/2012
Cash Sales Cash Sales
Copyright of Million Software Sdn Bhd
Ref. No. CS 0001
RM 70.00
CS 0002
100.00
Page
6
A Step-by-Step Million Accounting Workbook
9.
Add the following Receive Transactions. (Go to Debtors Receive Payment Add)
21/01/2012
Received Payment from Maya Plastic
Ref. No. OR0001
RM 13,000.00
10. Add the following Payment Transactions. (Go to Creditors Pay Bills Add)
31/01/2012
Paid to Time Dotcom Sdn Bhd
Ref. No. PV0104
RM 5,000.00
Ref. No. CN 0001
RM 600.00
11. Add the following Credit Note to Journal (Go to Debtors Credit Note Add )
31/01/2012
Being discount allowed to Maya Plastic Trading for Invoice No.: Inv2001
12. View the following Reports: (i) Print Batch of Transactions (General More Report Print Batch Of Transaction) (ii) Bank Ledger (General View Ledgers) (iii) Trial Balance (General Trial Balance) (iv) Trading And Profit & Loss Account (General Profit & Loss Account) 13. Save a copy of data into hard disk (C drive), or others drive. (i) Go to System B ackup Database (ii) Enter the directory path as C:\BACKUP\ SUNRISE\ (iii) Click on the Backup button to backup.
Experiments 1. Change the Account Description from “Telephone” to “Telephone Charges”. (Go to General GL Accounts Filter Edit)
2. Change the Sales amount for Maya Plastic Trading from RM13, 600.00 to RM13, 600.50 . (Go to Debtors Invoice Filter Edit Reverse)
3. Delete the entire transaction for Cash Sales No. CS 0001 of RM70.00 . (Go to General Cash Book Receipt Delete)
4. Change the Bank Account Number from 3010/000 to 3050/0000. (Go to System Administrative Tools Change Data User ID & Password: Admin Accounts) Copyright of Million Software Sdn Bhd
Page
7
A Step-by-Step Million Accounting Workbook
Lesson 2 Objectives: (1)
Maintain Company Profile - Set the Accounting Year
(2)
Generate Sample Chart of Accounts -Trading Company
(3)
Debtor / Creditor - Maintain Debtor / Creditor accounts - B/F Transactions - Sales Invoice / Purchase Invoice - Receive Payment / Pay Bills - Knock off Bills
(4)
Enter Foreign Currency transaction
(5)
Cash Book entry - Payment - Receipt
(6)
Maintain Closing Stock Value
(7)
Post Dated Cheque
(8)
View Reports - Debtor Statement - Aging Reports - Payment Due
(9)
Year End Processing - Backup
Copyright of Million Software Sdn Bhd
Page
8
A Step-by-Step Million Accounting Workbook
ASSIGNMENT 2 Company Profile (System General Setup Company)
Company Name
: Wong Long Sdn Bhd
R.O.C. No.
: 123456-A
Address
: 123 Jalan Seroja 39, Taman Johor Jaya, 81100 Johor Bahru
Accounting Year
: 01/01/2012 – 31/12/2012
Actual Starting Date
: 01/11/2012
Set the format type for the accounts codes: Account Format: XXXX/XXXX ( System General Setup Options )
1.
Create a Sample Chart Of Account (General GL Accounts Sample Trading Account Generate enter ‘admin’ user name & password Login Yes OK)
2. Maintain Debtors Accounts (Debtors Debtor Maintenance Add)
Debtor A/C 3000/S001 3000/S002 3000/U001 3000/V001
Name Sakura Trading Sdn Bhd Seng Tech Sdn. Bhd. United Co. Sdn Bhd Victor Pte. Ltd
Currency: SGD
Currency Rate: 2.30 *
(Go to General dd M iscellaneous Currency SGD Exchange Rate A Date from 01/11/2012 To 30/11/2012 Save)
3.
Creditors Accounts (Creditors
Creditor
Creditor A/C 4000/L001
Maintenance Add)
Name Lee C.S. Sdn Bhd
Copyright of Million Software Sdn Bhd
Page
9
A Step-by-Step Million Accounting Workbook
4. Enter the following opening as at 31/10/2012 (General A/C Opening Balance)
Description
Debit (RM)
Capital Retained Earning Sakura Trading United Co. S/B Bank –PBB A/C Cash Stock Lee C. S. Sdn Bhd
Credit (RM) 18,000.00 1,150.00
9,500.00 3,500.00 9,000.00 150.00 8,000.00 30,150.00
11,000.00 30,150.00
Note : Lock the opening balance.
5. The Company has two debtors and their Unpaid Bills till 31/10/2012 are shown below (Debtors B/F Transaction Add)
Date 01/09/2012 03/09/2012 18/10/2012 24/10/2012 05/08/2012 29/08/2012
Account No. 3000/S001 3000/S001 3000/S001 3000/S001 3000/U001 3000/U001
Bill No. I 9801 I 9802 I 9803 I 9804 I 9805 I 9806
Description Sales Sales Sales Sales Sales Sales
Amount (RM) 2,500.00 1,800.00 3,500.00 1,700.00 1,950.00 1,550.00
Note : Use the ‘ List ’ button to check whether there is difference between debtor opening balance and total B/F transaction.
6. Generate Lee C. S. Sdn Bhd Outstanding Bills from opening balance (Creditors
B/F
Transaction List Generate
) Yes
7. Generate a set of Batches for November 2012 (General Batch Add Sample
Code
Yes OK
)
Description
Batch Type
10
Sales
Sales
20 30
Purchases Bank
Purchase Bank
40 50
Cash Journal
Cash Journal
(Select From Month = November to December Year = 2012 Generate Yes)
Copyright of Million Software Sdn Bhd
Page
10
A Step-by-Step Million Accounting Workbook
8. Enter the following transactions for the month of November 2012 Batch: Sales (Debtors Invoice Add)
Date 01/11/2012 02/11/2012
Description Sakura Trading United Co.
Ref No. I 9820 I 9821
26/11/2012 28/11/2012 30/11/2012
United Co. Seng Tech Sdn Bhd Victor Pte. Ltd
I 9822 I 9823 I 9824
Amount 1,230.00 1,010.00
250.00 500.00 $500.00
(Currency Rate : 2.30)
9. Batch: Purchases (Creditors
Purchase
Invoice Add)
Date
Description
Ref No.
Amount
07/11/2012 21/11/2012
Lee C. S. S/B Lee C. S. S/B
8208 8220
2,300.00 1,100.00
10. Batch: Bank (Debtors Receive Payment
Date 02/11/2012
Add)
Description Sakura Trading
Chq No. PBB155661
Ref No. OR0001
Amount 2,500.00
RHB224455
OR0002
1,000.00
RHB221158
OR0003
550.00
PBB155770
OR0005
4,500.00
TLB551144
OR0006
500.00
SBB553222
OR0007
$500.00
PBB155800
OR0009
1,230.00
RHB233100
OR0010
250.00
Chq No. BOC776601 PBB144333 BOC776602
Ref No. OR0004 OR0008 OR0011
Amount 1,000.00 500.00 1,000.00 Page 11
Pay For:I 9801
02/11/2012
United Co. Pay For:I 9806
07/11/2012
United Co. Pay For:I 9821
24/11/2012
Sakura Trading Pay For:I 9803 & I 9804
28/11/2012
Seng Tech Sdn Bhd Pay For:I 9823
30/11/2012
Victor Pte.Ltd Pay For:I 9824
(Currency Rate : 2.20)
01/12/2012
Sakura Trading Pay For:I 9820
28/12/2012
United Co. Pay For:I 9822
11. (General Cash Book Receipt Add) Date Description 08/11/2012 Rental Income 01/12/2012 Sundry Income 05/12/2012 Rental Income Copyright of Million Software Sdn Bhd
A Step-by-Step Million Accounting Workbook
12.
(General Cash Book
Date 05/11/2012 28/11/2012 28/12/2012
13.
Description Water & Electricity Salary Salary
Chq No. PBB886601 PBB886602 PBB886605
Ref No. PV0001 PV0002 PV0003
Amount 180.00 1,800.00 2,000.00
Ref No. CV0001 CV0002
Amount 15.00 20.00
Ref No. CS 0001 CS 0002
Amount 300.00 100.00
Ref No. CN0001
Amount 700.00
Batch: Cash (General Cash Book
Date 20/11/2012 25/11/2012
14.
Payment Add)
Description Stationery Stamps
(General Cash Book
Date 05/11/2012 17/11/2012
15.
Payment Add)
Receipt Add)
Description Cash Sales Cash Sales
Batch: Journal (Debtors Credit Note Add)
Date 28/11/2012
Description Goods Return from Sakura
For Invoice no.: I 9804 16.
Enter Closing Stock Value for Year 2012 (General Maintain Stock Value Add Save Enter Closing Stock Add )
Opening Stock Value as at 01/11/2012 = RM 8,000.00 Closing Stock Value as at 31/12/2012 = RM2,200.00 17.
Received a Post Dated Cheques (PDC) from a Debtor (i) Enter the following PDC transaction Batch: Bank – Dec 2011 (Debtors Receive Payment
Date 25/12/2012
Add)
Description Sakura Trading
(Pay For) (I 9802)
Chq No. PBB155886
Ref No. PDC12/01
Amount 1,800.00
(ii) View Debtor Statement for 30 Nov 2012 (Debtors Debtor Reports Debtor Statement Print Preview)
Copyright of Million Software Sdn Bhd
Page
12
A Step-by-Step Million Accounting Workbook
18.
The following is the Bank Statement as at 31/10/2012 (General Bank Reconciliation Select ‘Bank – PBB A/C’ Edit Maintain B/F Trans Add)
Bank Reconciliation Statement as at 31/10/2012 Balance as per Bank Statement
7,500.00
Add: Deposits Not Credited By Bank 01/10/2012 OR 2145 Sakura Trading Sdn Bhd PBB 149875
2,000.00
20/10/2012 OR 2166 Rental Received MBB 154477
1,800.00
3,800.00 11,300.00
Less: Unpresented Cheque 28/10/2012 PV 1897 Water & Electricity PBB234891 30/10/2012 PV1854 Rental PBB146321 Balance as per Bank Account
Copyright of Million Software Sdn Bhd
500.00 1,800.00
2,300.00 9,000.00
Page
13
A Step-by-Step Million Accounting Workbook
The following is the Bank Statement as at 30/11/2012
19.
(General Bank Reconciliation Select ‘Bank – PBB A/C’ Edit Select the Statement Date = November 2012 Refresh)
PUBLIC BANK BERHAD (Johor Bahru)
Statement
Wong Long Sdn Bhd 123, Jalan Seroja 39, Taman Johor Jaya,
(Customer Copy)
81100 Johor Bahru, Johor. Date
Transaction Description
Transaction Amount (RM)
05/11/2012 09/11/2012 20/11/2012 28/11/2012 30/11/2012
Balance B/F Local Cheque Deposit Debit Cheque Deposit Debit Cheque Deposit Debit Cheque Deposit Debit Cheque
155661 224455 776601 155770 886602
Total of debit items : Total of credit items :
2,500.00 1,000.00 1,000.00 4,500.00 1,800.009,000.00 1,800.00
Balance (RM) 7,500.00 10,000.00 11,000.00 12,000.00 16,500.00
14,700.00 4 1
Note: 1. All items and balances shown above will be considered correct unless the Bank is notified of any discrepancy within 14 days. 2. Please notify us of any change of address in writing.
20.
View the Bank Reconciliation Statement as at November 2012 Result: Balance as per Bank Statement = RM 14,700.00 Balance as per Bank Account = RM 18,170.00 Experiment (i) The bill for United Co. OR 0003 is wrongly knocked off and should be knocked off against Invoice no.: I 9806 instead. Reverse Bills (Debtors Knock Off Bill Edit Reverse) Knock Off again the correct Invoice with the payment. • •
(Debtors Knock Off Bill Edit Edit)
21. View the following debtors reports for Nov 2012 (i) Preview Debtor Statement (Debtors Debtor Reports Debtors Statement OK Statement Date: 30/11/2012 ) Copyright of Million Software Sdn Bhd
Page
14
A Step-by-Step Million Accounting Workbook
(ii) Preview Debtor Aging (Debtors Debtor Reports Debtors Aging OK To Date: 30/11/2012) Aging
by ‘Month’)
(iii) Preview Debtor Payment Due (Debtors Debtor Reports Debtors Payment Due OK
To
Date: 30/11/2012 )
22. Enter the following Sales invoice for January 2013 (General Batch Add From/To Month: January Year: 2013 Generate Yes) (General GL Transaction Quick Entry Sales Invoice OK)
Batch: Sales Date 02/01/2013 05/01/2013 17/01/2013
Description Sakura Trading Sdn Bhd United Co. Sdn Bhd Seng Tech Sdn Bhd
Ref No. Inv 2093 Inv 2094 Inv 2095
Amount 1,600.00 5,000.00 1,530.00
23. Year end processing for Year 2012 (System Backup Database
Backup
To: C:\Backup\Wonglong\ Backup)
(System Administrative Tools Year End Closing OK enter admin user & password
Copyright of Million Software Sdn Bhd
Page
15
A Step-by-Step Million Accounting Workbook
Lesson 3
Objectives: (1)
Learn how to use Project Code to handle Departmental Account
(2)
Learn how to maintain Department Stock Value
(3)
Learn how to use the Consolidated Account to print out columnised Profit & Loss Account for all the departments.
(4)
At the end of this assignment, the student should be able to apply the concept to other type of accounts such as contract accounts with many proj ects, branch accounts, organization with many cost centers, etc.
Copyright of Million Software Sdn Bhd
Page
16
A Step-by-Step Million Accounting Workbook
ASSIGNMENT 3 Departmental Account 1.
Seng Long Supermarket has 3 departments’ accounts. The 3 departments are: Ladies, Gents & Children. Their accounting year starts from 01/01/2012 to 31/12/2012. Account Format: XXXX/XXXX ( System General Setup Options )
2.
Using the following codes to maintain the department codes respectively:(Go to General Miscellaneous Project Add)
Project LD GT CD
Description Ladies Gents Children
Date Start 01/01/2012 01/01/2012 01/01/2012
Date Complete 31/12/2012 31/12/2012 31/12/2012
3. Maintain General accounts. (General GL Accounts Add)
A/C No. 1000/0000 1050/0000 1051/0000 3010/0000 3020/0000 3100/0000 4000/0000 5000/0000 6000/0000 6010/0000 6100/0000 9010/0000 9020/0000 9030/0000
A/C Description Capital Retained Earning Current Profit / Loss Cash In Hand Bank Stock Trade Creditor Cash Sales Opening Stock Purchases Closing Stock Salary Insurance Rental
Account Group Capital & Reserves Capital & Reserves Capital & Reserves Current Assets Current Assets Current Assets Current Liabilities Revenue Cost Of Goods Sold Cost Of Goods Sold Cost Of Goods Sold Expenditure Expenditure Expenditure
Classified As Retained Earning Current Year Profit/(Loss) Cash Bank Closing Stock Creditor Sales Opening Stock Purchases Closing Stock -
4. Maintain Creditor’s accounts (Creditors
Creditor
Creditor No. 4000/L001 4000/R001 4000/J001
Maintenance Add)
Company Name Lee Corporation R & D Fashion JJ Fashion
Copyright of Million Software Sdn Bhd
Page
17
A Step-by-Step Million Accounting Workbook
5. Organise January’s batches (General Batch Add Sample
Yes OK )
(Select From Month = January To January Year = 2012 Generate Yes)
6. Enter the following transactions for the respective department: Purchases (Go to Creditors Purchase Invoice Add)
Date 01/01/2012 02/01/2012 09/01/2012
Description Lee Corporation R & D Fashion JJ Fashion
Departments
Ref. No. Auto (PI001) Auto Auto
Ladies 6,000.00 3,000.00 9,000.00
Gents 5,000.00 1,000.00 4,800.00
Children 4,500.00 1,500.00 3,500.00
Cash (Go to General Cash Book Receipt Add)
Date 11/01/2012 12/01/2012 13/01/2012
Description Cash Sales Cash Sales Cash Sales
Ref. No. Auto (CS001) Auto Auto
Departments Ladies 10,000.00 5,000.00 12,000.00
Gents 8,000.00 3,000.00 6,800.00
Children 7,500.00 2,500.00 5,500.00
Bank (Go to General Cash Book Payment Add)
Departments
Date 21/01/2012
Description Salary
Ref. No. Ladies Auto (PV001) 1,600.00
21/01/2012 25/01/2012
Insurance Rental
Auto Auto
300.00 900.00
Gents 1,500.00
Children 1,450.00
100.00 480.00
150.00 350.00
7. The stock value for each department ( Go to General Maintain Stock Value Add )
Stock as at 01/01/2012 (Opening) Stock as at 31/01/2012 (Closing)
Copyright of Million Software Sdn Bhd
Ladies 6,000.00 5,000.00
Gents 5,000.00 3,000.00
Children 4,500.00 1,500.00
Total 15,500.00 9,500.00
Page
18
A Step-by-Step Million Accounting Workbook
Go to General
Maintain
Stock Values to enter the above “Closing stock” values.
Project LD
Bal. Sheet Closing Stock 3100/0000
GT CD
3100/0000 3100/0000
Description Stock Stock Stock
P&L Opening Stock 6000/0000
P&L Closing Stock 6100/0000
6000/0000 6000/0000
6100/0000 6100/0000
8. View reports for each department: (i) View the respective departments’ Profit and Loss Account ; (Go to General Profit and Loss Account
Select
Project Code)
(ii) Print a consolidated Profit and Loss Account that includes all departments; (Go to General More Report Consolidated Account Maintain Generate Generate Project OK)
Copyright of Million Software Sdn Bhd
Page
19
A Step-by-Step Million Accounting Workbook
Lesson 4 Objectives: Learn how to: (1)
Create a Chart of Account for Manufacturing Account
(2)
Use the function of Special Account function
(3)
Maintain Multiple Opening & Closing Stock account
(4)
Print Manufacturing Account
Copyright of Million Software Sdn Bhd
Page
20
A Step-by-Step Million Accounting Workbook
ASSIGNMENT 4 Manufacturing Account CREATIVE INDUSTRIES SDN BHD wishes to control their using Million Accounting System. Their accounting year is from 01/01/2012 to 31/12/2012.
Account Format: XXXX/XXXX ( System General Setup Options )
1.
Create the following chart for the Manufacturing Account :
A/C No
A/C Description
A/C Group
Classified As
Group To
7000/0000
Manufacturing Account
Cost Of Goods Sold
Cost Of Goods Manufactured
7000/0000
7000/1000
Raw Material
Cost Of Goods Manufactured
-
7000/1000
7000/1010
Opening Stock – Raw
Cost Of Goods Manufactured
Opening Stock
7000/1000
Cost Of Goods Manufactured
Purchases
7000/1000
Material 7000/1020
Purchases Of Raw Material
7000/1030
Carriage Inwards
Cost Of Goods Manufactured
-
7000/1000
7000/1040
Closing Stock – Raw
Cost Of Goods Manufactured
Closing Stock
7000/1000
Material 7000/2000
Direct Labour
Cost Of Goods Manufactured
-
7000/2000
7000/2010
Product Wages
Cost Of Goods Manufactured
-
7000/2000
7000/2020
E.P.F. Contribution
Cost Of Goods Manufactured
-
7000/2000
Cost Of Goods Manufactured
-
7000/2000
(Production) 7000/2030
SOCSO Contribution (Production )
7000/3000
Factory Overhead
Cost Of Goods Manufactured
-
7000/3000
7000/3010
Factory Rental
Cost Of Goods Manufactured
-
7000/3000
7000/3020
Factory Expenses
Cost Of Goods Manufactured
-
7000/3000
7000/3030
Water & Electricity
Cost Of Goods Manufactured
-
7000/3000
Cost Of Goods Manufactured
-
7000/3000
(Factory) 7000/3040
Depreciation of Plant & Machinery
7000/4000
Packing Material
Cost Of Goods Manufactured
-
7000/4000
7000/4010
Opening Stock –
Cost Of Goods Manufactured
Opening Stock
7000/4000
Cost Of Goods Manufactured
Purchases
7000/4000
Cost Of Goods Manufactured
Closing Stock
7000/4000
Cost Of Goods Manufactured
-
7000/5000
Packing Material 7000/4020
Purchases of Packing Material
7000/4030
Closing Stock – Packing Material
7000/5000
Work – In – Progress
Copyright of Million Software Sdn Bhd
Page
21
A Step-by-Step Million Accounting Workbook
7000/5010
Opening – Work – In –
Cost Of Goods Manufactured
Opening Stock
7000/5000
Cost Of Goods Manufactured
Closing Stock
7000/5000
Progress 7000/5020
Closing – Work – In – Progress
1000/0000
Capital
Capital & Reserves
-
1000/0000
1050/0000
Retained Earning
Capital & Reserves
Retained Earning
1050/0000
1051/0000
Current Profit & Loss
Capital & Reserves
Current Year Profit / (Loss)
1051/0000
2001/0000
Plant & Machinery
Fixed Assets
Fixed Assets
2001/0000
2001/0050
Accum. Deprn. – Plant
Fixed Assets
Accumulated Depreciation
2001/0000
& Machinery 3010/0000
Cash At Bank
Current Assets
Bank
3010/0000
3020/0000
Stock
Current Assets
Closing Stock
3020/0000
3020/1000
Stock – Raw Material
Current Assets
Closing Stock
3020/1000
3020/4000
Stock – Packing
Current Assets
Closing Stock
3020/4000
Current Assets
Closing Stock
3020/5000
Material 3020/5000
Stock – Work – In – Progress
2. Organise January’s batches (General Batch
) Add Sample Yes OK
(Select From Month = January To January Year = 2012 Generate Yes)
3. Add the following transactions for Jan’2012 : (Go to General Cash Book Payment Add)
Bank Book – Jan’2012 Date Description 01/01/2012 Purchase of Raw Material 01/01/2012 Carriage Inward
Ref. No. PV2001 PV2002
Amount 38,000.00 120.00
07/01/2012 07/01/2012 07/01/2012 07/01/2012 15/01/2012 15/01/2012 18/01/2012 20/01/2012
PV2003 PV2004 PV2005 PV2006 PV2007 PV2008 PV2009 PV2010
5,000.00 600.00 50.00 3,000.00 30.00 1,000.00 800.00 1,200.00
Ref. No. JV2001
Amount 5,600.00
Production Wages E.P.F. Contribution (Production) SOCSO Contribution (Production) Factory Rental Factory Expense Water & Electricity (Factory) Upkeep of Machinery (7000/3050) Purchase of Packing Material
Journal – Jan’2012 (General GL Transaction
Date 31/01/2012
Add)
Description Depreciation of Plant & Machinery
Copyright of Million Software Sdn Bhd
Page
22
A Step-by-Step Million Accounting Workbook
4. The figures for Opening & Closing Stock as at 31/01/2012 are as follows: ( Go to General Maintain Stock Value Add )
Raw Material Packing Material Work-in-progress
Opening Stock 60,000.00 3,000.00
10,000.00
Closing Stock 58,000.00 1,600.00
11,000.00
Go to General Maintain Stock Values to enter the above stock values. Project
Bal. Sheet Closing Stock 3020/1000
Description Stock
3020/4000 3020/5000
Stock Stock
P&L Opening Stock 7000/1010
P&L Closing Stock 7000/1040
7000/4010 7000/5010
7000/4030 7000/5020
5. Print the following Financial Reports: Manufacturing Account (General More Reports Manufacturing Account) ii) Profit and Loss Account (General Profit & Loss Account) iii) Balance Sheet (General Balance Sheet) i)
Copyright of Million Software Sdn Bhd
Page
23
A Step-by-Step Million Accounting Workbook
Lesson 5 Objectives: Learn how to: (1)
Set up Company Profile
(2)
Create Chart of Accounts
(3)
Enter Opening Balance for The first month of financial year
(4)
Organise Batches
(5)
Add / Edit Transactions
(6)
Edit Account Type Description
(7)
View Report
Copyright of Million Software Sdn Bhd
Page
24
A Step-by-Step Million Accounting Workbook
ASSIGNMENT 5 1. Company Profile (System General Setup Company)
Company Name
: XYZ Social Club
Address
: 123 Jalan Seroja 47, Taman Johor Jaya, 81100 Johor Bahru
Accounting Year
: 01/01/2012 – 31/12/2012
Actual Starting Date
: 01/01/2012
Set the format type for the accounts codes: Account Format: XXXX/XXXX ( System General Setup Options )
General Accounts Account Number
A/C Description
A/C Group
Classified As
1000/0000
Accumulated Fund B/F
Capital & Reserved
Retained Earning
1001/0000 2010/0000
Accumulated Fund Furniture & Fitting
Capital & Reserved Fixed Assets
Current Year Profit / Loss Fixed Assets
2020/0000 3010/0000
Premises Bank
Fixed Assets Current Assets
Fixed Assets Bank
3020/0000 3030/0000
Cash In Hand Subscription in Arrears
Current Assets Current Assets
Cash -
4000/0000 4005/0000
Subscription in Advance Other Creditors
Current Liabilities Current Liabilities
-
8010/0000 8020/0000
Member Subscription Entrance Fees
Other Revenue Other Revenue
-
8030/0000 8040/0000
Donation Ground Rent
Other Revenue Other Revenue
-
8050/0000 8060/0000
Locker Rent Social Activities
Other Revenue Other Revenue
-
9001/0000 9005/0000
Rent and Rates Salaries & Wages
Expenditure Expenditure
-
9010/0000 9015/0000
Telephone Charges Water & Electricity
Expenditure Expenditure
-
9020/0000 9025/0000
Printing & Stationery Sundry Expense
Expenditure Expenditure
-
9030/0000
Upkeep of Furniture & Fitting
Expenditure
-
9040/0000
Expenses of Social Activities
Expenditure
-
Copyright of Million Software Sdn Bhd
Page
25
A Step-by-Step Million Accounting Workbook
2. Following are the opening balances as at 01/01/2012: (Go to General Account Opening Balance)
Description
Debit (RM)
Accumulated Fund B/F Furniture & Fitting Premises Bank Cash In Hand Subscription in Advance
Credit (RM)
60,000.00 15,000.00 20,000.00 25,000.00 500.00 60,500.00
500.00 60,500.00
3. Organise the batches as follows: (General Batch
) Add Sample Yes OK
(Select From Month = January To January Year = 2012 Generate Yes)
Code 10
20 30 40 50
Description Bank Receipts
Batch Type Bank
Bank Payments Cash Receipts Cash Payments Journal
Bank Cash Cash Journal
4. Following are the transactions for January 2012 Bank Receipts – Jan’12 (Go to General Cash Book Receipt Add)
Date 01/01/2012 10/01/2012
Description Ground Rent Members Subscription
Bill No. OR 2001 OR 2002
Cheque No. SBB420000 PBB123410
Amount 2,800.00 3,500.00
11/01/2012 31/01/2012 31/01/2012 31/01/2012
Donation Entrance Fees Members Subscription Social Activities
OR 2003 OR 2004 OR 2005 OR 2006
RHB433210 PBB420003 PBB441152 CBB545541
1,000.00 1,200.00 4,500.00 6,000.00
Bill No.
Cheque No.
Amount
PBB355001 PBB355002 PBB355003 PBB355004
1,000.00 3,000.00 2,500.00 500.00
Bank Payments – Jan’12 (Go to General Cash Book Payment Add)
Date
Description
15/01/2012 15/01/2012 15/01/2012 15/01/2012
Desks and Chairs (F&F) BPV 1001 Rental BPV 1002 Salaries BPV 1003 Upkeep of Furniture & Fitting BPV 1004
Copyright of Million Software Sdn Bhd
Page
26
A Step-by-Step Million Accounting Workbook
15/01/2012 30/01/2012
Water & Electricity BPV 1005 Expenses of Social Activities BPV 1006
PBB355005 PBB355006
800.00 2,100.00
Cash Receipts – Jan’12 (Go to General Cash Book Receipt Add)
Date 01/01/2012
Description Members Subscription
Bill No. OR 8200
Amount 800.00
05/01/2012 31/01/2012
Entrance Fees Locker Rent
OR 8201 OR 8202
200.00 450.00
Cash Payments – Jan’12 (Go to General Cash Book Payment Add)
Date 31/01/2012 31/01/2012 31/01/2012
Description Cleaning Fee Upkeep of Furniture & Fitting Sundry Expenses
Bill No. CPV 001 CPV 002 CPV 003
Amount 1,000.00 40.00 1,000.00
31/01/2012
Stationery
CPV 004
60.00
5. Experiments i)
Change the Bank Received from Members Subscription on 31/01/2012 from RM4,500.00 to RM4,800.00 .
ii) Change the Word “Other Revenue” to “ Income ” ( Go to System Administrative Tools Account Group )
iii) Change the “Trading And Profit And Loss Account ” to “Income And Expenditure Account ” “NET PROFIT/(LOSS) “ to “ Accumulated Fund ” and “RETAINED PROFIT/(LOSS)” to “Accumulated Fund B/F ” ( Go to General Profit and Loss Account Print Edit Report Wording )
6. View the following information: (i) Chart of Accounts; (ii) Trial Balance as at 31/01/2012; (iii) Trading And Profit & Loss for the month ended 31/01/2012; (iv) Balance Sheet as at 31/01/2012;
Copyright of Million Software Sdn Bhd
Page
27
A Step-by-Step Million Accounting Workbook
Lesson 6 Objectives: Learn how to: (1)
Set up GST code
(2)
Transaction with GST Debtor Invoice Creditor Invoice
(3)
View GST report GST Transaction Listing GST FORM 3 Generate GAF GST Accrual report
Copyright of Million Software Sdn Bhd
Page
28
A Step-by-Step Million Accounting Workbook
ASSIGNMENT 6 Company Profile (System General Setup Company)
Company Name
: Wonderful Sdn Bhd
R.O.C. No.
: 234567-H
TAX No.
: 345678
Address
: 12 Jalan Permas Jaya 2/10, Taman Permas Jaya, 81100 Johor Bahru
Accounting Year
: 01/01/201x – 31/12/201x
Actual Starting Date
: 01/11/201x
Set the format type for the accounts codes: Ensure Account Format: XXXX/XXXX and GST entry is set up (System General Setup Options s elect GST Format M Y)
1. Create a Sample Chart Of Account (General GL Accounts Sample user name & password ��
Trading
Account Generate enter ‘admin’
Login Yes OK)
Set up GST code (General Miscellaneous GST Sample Select GST Output tax/Input tax A/C No.
Generate �
3. Maintain Debtors Accounts (Debtors
Debtor
Maintenance Add)
Debtor A/C
Name
3000/A001 3000/T002 3000/U001
Apple Trading Sdn Bhd Tomato Design Sdn. Bhd. United Co. Sdn Bhd
Default GST
SR ZR SRI
4. Creditors Accounts (Creditors Creditor Maintenance Add) Creditor A/C 4000/C001
Name Lee C.S. Sdn Bhd
Default GST TX6
5. Add the following Nominal Accounts: Some account codes may have already been set up. Check and set up new accounts as required. (General GL Accounts Add) Copyright of Million Software Sdn Bhd
Page
29
A Step-by-Step Million Accounting Workbook
GL Number
Account Name
9050/0000
Vehicle Repairs &Maintenance
Account Type P&L
Account Group
Expenditure
Classified as -
GST Code TXI
6. Enter the following opening as at 31/10/201x (General
A/C
Opening Balance)
Description
Capital Retained Earning Apple Trading United Co. S/B Bank –PBB A/C Cash Stock Lee C. S. Sdn Bhd
Debit
Credit
(RM)
(RM) 23,000.00 2,250.00
8,300.00 3,300.00 5,000.00 1,150.00 5,000.00 2,500.00 25,250.00
25,250.00
Note : Lock the opening balance.
7. The Company has two debtors and their Unpaid Bills till 31/10/201x are shown below (Debtors B/F Transaction Add) Date 01/09/201x
Account No. 3000/A001
03/09/201x 18/10/201x 05/08/201x 29/08/201x
3000/A001 3000/A001 3000/U001 3000/U001
Bill No. Description INV 7801 Sales
INV 7802 INV 7803 INV 7804 INV 7805
Sales Sales Sales Sales
Amount (RM) 2,800.00
1,900.00 3,600.00 1,850.00 1,450.00
Note : Use the ‘ List ’ button to check whether there is difference between debtor opening balance and total B/F transaction.
8.
Generate Lee C. S. Sdn Bhd Outstanding Bills from opening balance (Creditors B/F Transaction List Generate ) Yes
9. Generate a set of Batches for November 201x (General Batch Add Sample Code
Yes OK
)
Description
Batch Type
10
Sales
Sales
20
Purchases
Purchase
30
Bank
Bank
40
Cash
Cash
50
Journal
Journal
Copyright of Million Software Sdn Bhd
Page
30
A Step-by-Step Million Accounting Workbook
(Select From Month = November to December Year = 201X Generate Yes)
10.
Enter the following transactions for the month of November 201x (Debtors Invoice Add) Date Description 01/11/201x Sales to Apple Trading 02/11/201x Sales to Tomato Design 26/11/201x Sales to United Co. Pte Ltd 28/11/201x Sales to Seng Tech
Ref.No. INV 8920 INV 8921 INV 8922 INV 8923
Amount 1,230.00 250.00 1,000.00 USD 200.00
GST type SR ZR SRI ZR
* Exchange Rate: 3.78
11. Enter the following transaction of Purchase (Creditors
Purchase
Invoice Add)
Date
Description
Ref No.
Amount
07/11/201x 21/11/201x
Lee C. S. S/B Lee C. S. S/B
8308 8320
1,300.00 2,200.00
GST type
TX6 TX6
12. Enter the following transaction of Receive Payment (Debtors Receive Payment Add) Date
Description
Cheque No.
Ref.No.
Amount
28/12/201x
Apple Trading
PBB155661
OR0001
2,800.00
RHB224455
OR0002
1,850.00
RHB221158
OR0004
250.00
Pay For:INV7801
29/12/201x
United Co. Pay For:INV7804
30/12/201x
Tomato Design. Pay For:INV8921
13. Create the following customer credit note: On 23 Nov 201x, Issue a Credit Note No 100 to United Co. due to overcharges RM100 for the Invoice No. INV7805 (Debtors Credit Note Add )
14.
Enter the following Petty Cash Transactions: (General
Cash
Book
Payment Add)
Copyright of Million Software Sdn Bhd
Page
31
A Step-by-Step Million Accounting Workbook
Petty Cash Voucher No.
15.
Date
Details
Amount RM
Tax
PCV 100
18-11-1x
Office Stationery
58.50
Including tax
PCV 101
18-11-1x
DHL Courier
148.40
Including tax
PCV 102
18-11-1x
Coffee & Sugar
45.00
Zero-rated
Enter the following Bank Transactions: (General Cash Book Payment Add)
Reference No
Date
Details
Amount RM
Tax
RH100004
10-12-1x
Fire Insurance No. 8899
212.00
Including GST 6%
RH100005
12-12-1x
No. 1234 Van repairs
550.00
Excluding GST 6%
RH100006
14-12-1x
Forward Telecom Telephone bill
358.00
Including GST 6%
RH100007
16-12-1x
Advertising No. 3344
215.00
Including GST 6%
RH100008
18-12-1x
Paid Mr Chin Dec 201x Commission
400.00
Out of Scope (N-T)
RH100009
22-12-1x
Shop Rent Dec 201x No 12933
1,200.00
Excluding GST 6%
RH100012
27-12-1x
Accounting Fees No 4455 Dec 201x
600.00
Excluding GST 6%
RH100015
30-12-1x
Sosco Dec 201x
25.90
Out of Scope (N-T)
RH100016
30-12-1x
EPF Dec 201x
288.00
Out of Scope (N-T)
Copyright of Million Software Sdn Bhd
Page
32
A Step-by-Step Million Accounting Workbook
ANSWERS FOR LESSON * All the provided answers are for reports printed after the experiments / adjustments.
LESSON 1
Copyright of Million Software Sdn Bhd
Page
33
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
34
A Step-by-Step Million Accounting Workbook
LESSON 2
Copyright of Million Software Sdn Bhd
Page
35
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
36
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
37
A Step-by-Step Million Accounting Workbook
LESSON 3
Copyright of Million Software Sdn Bhd
Page
38
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
39
A Step-by-Step Million Accounting Workbook
LESSON 4
Copyright of Million Software Sdn Bhd
Page
40
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
41
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
42
A Step-by-Step Million Accounting Workbook
LESSON 5
Copyright of Million Software Sdn Bhd
Page
43
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
44
A Step-by-Step Million Accounting Workbook
Copyright of Million Software Sdn Bhd
Page
45
A Step-by-Step Million Accounting Workbook
APPENDIX I: SAMPLE CHART OF ACCOUNT TRADING COMPANY Account
Description
Account Type Account Group
1000/0000
Capital
Balance Sheet
Capital & Reserves
-
1020/0000
Drawing
Balance Sheet
Capital & Reserves
-
1050/0001
Retained Profit / (Loss)
Balance Sheet
Capital & Reserves Retained Earning
1050/0002
Current Year Profit / (Loss)
Balance Sheet
Capital & Reserves Current Year Profit / (Loss)
2010/0000
Furniture & Fitting
Balance Sheet
Fixed Assets
Fixed Assets
2010/0005
Accum. Depn. – Furniture & Fitting
Balance Sheet
Fixed Assets
Accumulated Depreciation
2020/0000
Office Equipment
Balance Sheet
Fixed Assets
Fixed Assets
2020/0005
Accum. Depn. – Office Equipment
Balance Sheet
Fixed Assets
Accumulated Depreciation
2030/0000
Motor Vehicle
Balance Sheet
Fixed Assets
Fixed Assets
2030/1000
Motor Vehicle – JEL 5368
Balance Sheet
Fixed Assets
Fixed Assets
2030/1050
Accum. Depn. – M/V JEL5368
Balance Sheet
Fixed Assets
Accumulated Depreciation
2030/2000
Motor Vehicle – JFL 613
Balance Sheet
Fixed Assets
Fixed Assets
2030/2050
Accum. Depn. – M/V JFL 613
Balance Sheet
Fixed Assets
Accumulated Depreciation
3000/0000
Trade Debtors
Balance Sheet
Current Assets
Debtor
3005/0000
Other Debtors
Balance Sheet
Current Assets
3010/0000
Bank – PBB
Balance Sheet
Current Assets
Bank
3020/0000
Cash In Hand
Balance Sheet
Current Assets
Cash
3030/0000
Stock
Balance Sheet
Current Assets
Closing Stock
3040/0000
Deposit & Prepayment
Balance Sheet
Current Assets
-
3040/1000
Deposit – Water & Electricity
Balance Sheet
Current Assets
-
3040/2000
Prepayment – Insurance
Balance Sheet
Current Assets
-
4000/0000
Trade Creditors
Balance Sheet
Current Liabilities
Creditor
4005/0000
Other Creditors
Balance Sheet
Current Liabilities
-
4010/0000
Accruals
Balance Sheet
Current Liabilities
-
4020/0000
H. P. Creditors -PBB FINANCE (JFL 613) Balance Sheet
Current Liabilities
-
4030/0000
Term Loan – MBB BANK
Balance Sheet
Current Liabilities
-
5000/0000
Sales
P&L
Revenue
Sales
5010/0000
Return Inwards
P&L
Revenue
Sales Adjustment
5020/0000
Discount Allowed
P&L
Revenue
Sales Adjustment
6000/0000
Opening Stock
P&L
Cost Of Goods Sold Opening Stock
6010/0000
Purchases
P&L
Cost Of Goods Sold Purchases
Copyright of Million Software Sdn Bhd
Classified As
-
Page
46
A Step-by-Step Million Accounting Workbook
6020/0000
Carriage Inwards
P&L
Cost Of Goods Sold Purchases Adjustment
6030/0000
Closing Stock
P&L
Cost Of Goods Sold Purchases Adjustment
9010/0000
Advertisement
P&L
Expenditure
-
9020/0000
Bank Charges
P&L
Expenditure
-
9030/0000
Depreciation of Fixed Assets
P&L
Expenditure
-
9040/0000
Salaries
P&L
Expenditure
-
9050/0000
Travelling
P&L
Expenditure
-
9060/0000
Upkeep of Motor Vehicle
P&L
Expenditure
-
9070/0000
Printing & Stationery
P&L
Expenditure
-
9080/0000
Rental
P&L
Expenditure
-
9090/0000
Water & Electricity
P&L
Expenditure
-
9100/0000
Telephone Charges
P&L
Expenditure
-
9110/0000
EPF Contribution
P&L
Expenditure
-
9120/0000
SOCSO Contribution
P&L
Expenditure
-
9900/0000
Taxation
P&L
Expenditure
-
Copyright of Million Software Sdn Bhd
Page
47
A Step-by-Step Million Accounting Workbook
MANUFACTURING COMPANY
Account
Description
1000/0000
Capital
Balance Sheet
Capital & Reserves
-
1050/0001
Retained Profit / (Loss)
Balance Sheet
Capital & Reserves
Retained Earning
1050/0002
Current Year Profit / (Loss)
Balance Sheet Capital & Reserves
Current Year Profit / (Loss)
2000/0000
Fixed Assets
Balance Sheet
Fixed Assets
Fixed Assets
2000/1000
Furniture & Fitting
Balance Sheet
Fixed Assets
Fixed Assets
2000/1050
Accum. Depn. – Furniture & Fitting
Balance Sheet
Fixed Assets
Accumulated Depreciation
2000/2000
Office Equipment
Balance Sheet
Fixed Assets
Fixed Assets
2000/2050
Accum. Depn. –Office Equipment
Balance Sheet
Fixed Assets
Accumulated Depreciation
2000/3000
Motor Vehicle – JEL 5368
Balance sheet
Fixed Assets
Fixed Assets
2000/3050
Accum. Depn. – M/V JEL5368
Balance Sheet
Fixed Assets
Accumulated Depreciation
2000/4000
Plant & Machinery
Balance Sheet
Fixed Assets
Fixed Assets
2000/4050
Accum. Depn. – Plant & Machinery
Balance Sheet
Fixed Assets
Accumulated Depreciation
2000/5000
Factory Equipment
Balance Sheet
Fixed Assets
Fixed Assets
2000/5050
Accum. Depn. – Factory Equipment
Balance Sheet
Fixed Assets
Accumulated Depreciation
2010/0000
Goodwill
Balance Sheet
Fixed Assets
3000/0000
Trade Debtors
Balance Sheet
Current Assets
3005/0000
Other Debtors
Balance Sheet
Current Assets
3010/0000
Bank – PBB
Balance Sheet
Current Assets
Bank
3020/0000
Cash In Hand
Balance Sheet
Current Assets
Cash
3030/0000
Stock
Balance Sheet
Current Assets
Closing Stock
3030/1000
Stock – Raw Material
Balance Sheet
Current Assets
Closing Stock
3030/4000
Stock – Packing Material
Balance Sheet
Current Assets
Closing Stock
3030/5000
Stock – Work In Progress
Balance Sheet
Current Assets
Closing Stock
3030/6000
Stock – Finished Goods
Balance Sheet
Current Assets
Closing Stock
3040/0000
Deposit & Prepayment
Balance Sheet
Current Assets
-
3040/1000
Deposit – Water & Electricity
Balance Sheet
Current Assets
-
3040/2000
Deposit – Telephone
Balance Sheet
Current Assets
-
3040/3000
Prepayment – Insurance
Balance Sheet
Current Assets
-
3050/0000
Fixed Deposit – PBB (1-458722-23)
Balance Sheet
Current Assets
-
4000/0000
Trade Creditors
Balance Sheet
Current Liabilities
Creditor
4005/0000
Other Creditors
Balance Sheet
Current Liabilities
-
4010/0000
Accruals
Balance Sheet
Current Liabilities
-
4020/0000
H. P. Creditor - PBB FINANCE (JFL 613)Balance Sheet Current Liabilities
-
4030/0000
Term Loan – MBB BANK
-
Copyright of Million Software Sdn Bhd
Account Type Account Group
Balance Sheet
Current Liabilities
Classified As
-
Debtor -
Page
48
A Step-by-Step Million Accounting Workbook
5000/0000
Sales
P&L
Revenue
Sales
5010/0000
Return Inwards
P&L
Revenue
Sales Adjustment
5020/0000
Discount Allowed
P&L
Revenue
Sales Adjustment
6000/0000
Opening Stock – Finished Goods
P&L
Cost Of Goods Sold
Opening Stock
6010/0000
Closing Stock – Finished Goods
P&L
Cost Of Goods Sold
Closing Stock
7000/0000
Manufacturing Account
P&L
Cost Of Goods Sold
Cost Of Goods
Manufactured 7000/1000
Raw Material
P&L
Cost Of Goods Manufactured
7000/1010
Opening Stock – Raw Material
P&L
Cost Of Goods Manufactured
Opening Stock
7000/1020
Purchase Of Raw Material
P&L
Cost Of Goods Manufactured
Purchases
7000/1030
Carriage Inwards
P&L
Cost Of Goods Manufactured
-
7000/1040
Customs Duties
P&L
Cost Of Goods Manufactured
-
7000/1050
Closing Stock – Raw Material
P&L
Cost Of Goods Manufactured
7000/2000
Direct Labour
P&L
Cost Of Goods Manufactured
-
7000/2010
Production Wages
P&L
Cost Of Goods Manufactured
-
7000/2020
E. P. F. Contribution
P&L
Cost Of Goods Manufactured
-
7000/2030
Socso Contribution
P&L
Cost Of Goods Manufactured
-
7000/3000
Factory Overhead
P&L
Cost Of Goods Manufactured
-
7000/3010
Factory Rental
P&L
Cost Of Goods Manufactured
-
7000/3020
Factory Expenses
P&L
Cost Of Goods Manufactured
-
7000/3030
Water & Electricity (Factory)
P&L
Cost Of Goods Manufactured
-
7000/3040
Depn. Plant & Machinery
P&L
Cost Of Goods Manufactured
-
7000/3050
Upkeep of Factory Machinery
P&L
Cost Of Goods Manufactured
-
7000/3060
Upkeep of Factory Equipment
P&L
Cost Of Goods Manufactured
-
7000/3070
Security Charges
P&L
Cost Of Goods Manufactured
-
7000/4000
Packing Material
P&L
Cost Of Goods Manufactured
-
7000/4010
Opening Stock–Packing Material
P&L
Cost Of Goods Manufactured
Opening Stock
7000/4020
Purchase of Packing Material
P&L
Cost Of Goods Manufactured
Purchases
7000/4030
Closing Stock–Packing Material
P&L
Cost Of Goods Manufactured
Closing Stock
7000/5000
Work-In-Progress
P&L
Cost Of Goods Manufactured
7000/5010
Opening – Work-In-Progress
P&L
Cost Of Goods Manufactured
Opening Stock
7000/5020
Closing – Work-In-Progress
P&L
Cost Of Goofs Manufactured
Closing Stock
8000/0000
Fixed Deposit Interest Received
P&L
Other Revenue
-
8010/0000
Gain on Disposal Of Fixed Assets
P&L
Other Revenue
-
9000/0000
Admin. Selling & General Exp.
P&L
Expenditure
-
9000/0005
Advertisement
P&L
Expenditure
-
9000/0100
Audit Fee
P&L
Expenditure
-
9000/0150
Bonus
P&L
Expenditure
-
9000/0200
Bank Interest & Charges
P&L
Expenditure
-
Copyright of Million Software Sdn Bhd
-
Closing Stock
-
Page
49
A Step-by-Step Million Accounting Workbook
9000/0250
Director’s Remuneration
P&L
Expenditure
-
9000/0300
Depreciation Of Fixed Assets
P&L
Expenditure
-
9000/0350
Entertainment
P&L
Expenditure
-
9000/0400
E.P.F. Contributions
P&L
Expenditure
-
9000/0450
General Expenses
P&L
Expenditure
-
9000/0500
Hire Purchase Interest
P&L
Expenditure
-
9000/0550
License Fee
P&L
Expenditure
-
9000/0600
Medical Fee
P&L
Expenditure
-
9000/0650
Office Rental
P&L
Expenditure
-
9000/0700
Office Refreshment
P&L
Expenditure
-
9000/0750
Postages & Stamps
P&L
Expenditure
-
9000/0800
Printing & Stationery
P&L
Expenditure
-
9000/0850
Road Tax & Insurance
P&L
Expenditure
-
9000/0900
Socso Contributions
P&L
Expenditure
-
9000/0950
Secretarial Fee
P&L
Expenditure
-
9000/1000
Staff Salaries & Allowances
P&L
Expenditure
-
9000/1050
Travelling Expenses
P&L
Expenditure
-
9000/1100
Telephone
P&L
Expenditure
-
9000/1150
Upkeep of Motor Vehicle
P&L
Expenditure
-
9000/1200
Water & Electricity
P&L
Expenditure
-
Copyright of Million Software Sdn Bhd
Page
50