Computerised Accounting with MYOB 1

118 Pages·2010·34.87 MB·English

Co n taC t i n f o r mat i o n
PT. Net21Plus
Web : www.net21plus.com
E-mail : [email protected]
Office:
menara KaDin indonesia, Lt. 30
Jl. H.r.rasuna Said, X-5, Kav.2-3, Jakarta Selatan. indonesia 12950
tel. (+62) (21) 5289 1988 fax. (+62) (21) 5299 4599
Technical Supports:
tel. /Sms. (+62) (21) 6888 6962
E-mail: [email protected]
Yahoo messenger: [email protected]
Googletalk / Windows Live messenger: [email protected]
Company Overview
Pt. net21Plus is mYoB Professional Partner.
mYoB Professional Partners are independent consultants who have demonstrated
a high level of knowledge, skill and experience with mYoB software.
Pt. net21Plus provides:
mYoB software demonstration, supplies, installation, setup, implementation,
training, technical supports, upgrade, add-users, data conversion, forms design,
secure remote access and mYoB oDBC add-on solutions.
Computerised Accounting with MYOB - Basic (Book 1)
2nd edition, published by net21Plus Pte Ltd
150 orchard road, #07-02 orchard Plaza, Singapore 238841
www.net21plus.com
Author : Sidik Jaya
ISBN : 978-981-08-5990-9
v2-001
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
contents
Case Study & Flowchart 02 17
Purchases: Returns & Debits 56
1
Setup: Currency Symbol & Date Format 12 18
Pay Bills 60
2
Setup: Company File 14 19
Sales: Items 62
3
Setup: Company Information & Preferences 16 20
Sales: Services 64
4
Setup: Accounts List (Delete, Edit, & Create) 22 21 Sales: Returns & Credits 66
5
Setup: Linked Accounts (Sales & Purchases) 28 22 Receive Payments 70
6
Setup: Tax Codes 30 23
Spend Money 72
7
Setup: Jobs & Categories 32 24
Receive Money 74
8
Setup: Cards List (Customer, Supplier & Employee) 34 25 Reconcile Accounts 76
9
Setup: Items List 36 26
Journal Entry 78
10
Setup: Account Opening Balances 40 27
Build Items 80
11
Setup: Customer Opening Balances 42 28
Adjust Inventory 82
12
Setup: Supplier Opening Balances 44 29
Company Data Auditor & Lock Period 84
13
Setup: Inventory Opening Balances 46 30
Analysis 86
14
Exit, Back up, Open & Verify: Company File 48 31
Find Transactions 90
15
Purchases: Items 52 32
To Do List 92
16
Purchases: Services 54 33
Reports 94
PT. Net21Plus
Menara KADIN Indonesia, Lt.30,
Jl. H.R.Rasuna Said, X-5, Kav.2-3,
Jakarta Selatan. Indonesia 12950
Tel. (+62) (21) 5289 1988
Fax. (+62) (21) 5299 4599
E-mail : [email protected]
Also Available!
Web : www.net21plus.com
Computerised Accounting with MYOB - Basic
Copyright © 2010 by PT. Net21Plus. All rights reserved.
No part of this publication may be reproduced, stored in a retrieval system, or transmitted
in any form by any means, electronic, mechanical, photocopying, or otherwise without
permission of PT. Net21Plus. This book may not be lent, resold, hired out or otherwise
disposed of by way of trade in any form of binding or cover, other than in which it is
published, without the prior consent of PT. Net21Plus.
MYOB® is registered trademark of MYOB Technology Pty Ltd.
CCoommpputerised Accounting with MYOB - Basic (Book 1) 2nd Edition 1
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
Case Study Computerised Accounting
NET21PLUS buys and sells products and services since c. Create the following New Account Codes.
2009.
Header/
A/c # Account Name Detail Account Type Level
NET21PLUS uses MYOB to prepare the Financial Year Account
Reports for period of 1 Jan 2010 to 31 Dec 2010.
1-0010 Current Assets Header Asset 2
1-0130 Bank Detail Bank 3
Setup and enter the following transactions:
Other Current
1-0300 Inventory Detail 3
Asset
1. Setup the computer system Currency Symbol to
1-2000 Fixed Assets Header Asset 2
“Rp” and Date format to “DD-MM-YYYY” before
Offi ce
start using MYOB. 1-2100 Header Asset 3
Equipments
Offi ce Equip at
2. Setup the Company File with the following details. 1-2110 Detail Fixed Asset 4
Cost
Company Name NET21PLUS Offi ce Equip
1-2111 Detail Fixed Asset 4
Current Financial Year 2010 Accum Depn
2-0010 Current Liabilities Header Liability 2
Last Month of Financial Year December
2-0100 Credit Card Detail Credit Card 3
Conversion Month January
2-1000 VAT Liabilities Header Liability 3
Number of Accounting Periods Thirteen (13)
Other Current
2-1100 VAT Collected Detail 4
Liability
The Accounts List will be provided. Other Current
2-1200 VAT Paid Detail 4
Liability
3. Add Address: INDONESIA into Company Other Current
2-1300 VAT Clearing Detail 4
Information and Setup the MYOB Preferences. Liability
3-0100 Share Capital Detail Equity 2
4. Setup the Accounts list by: 4-1000 Sales (Products) Detail Income 2
a. Delete the following account codes. 4-2000 Sales (Services) Detail Income 2
2-0300 Payroll Liabilities,
5-1000 COGS (Products) Detail Cost of Sales 2
6-0100 Wages & Salaries,
5-2000 COGS (Services) Detail Cost of Sales 2
6-0200 Other Employer Expenses
6-1000 Rent Detail Expense 2
b. Edit the following account name.
1-0100 Cheque Account 6-2000 Bank Charges Detail Expense 2
Change to: 1-0100 Cash 6-3000 Depreciation Detail Expense 2
8-1000 Interest Income Detail Other Income 2
9-1000 Income Tax Detail Other Expense 2
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 2
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
5. Setup the following Linked Accounts.
Tax Code N-T
Description Non-Taxable
a. Accounts & Banking Linked Accounts
Tax Type Sales Tax
Equity Account for 3-0900 Current Year
Current Earnings Earnings Rate 0%
Equity Account for 3-0800 Retained Earnings Linked Account:
Retained Earnings
Tax Collected 2-1100 VAT Collected
Equity Account for 3-0999 Historical
Historical Balancing Balancing Tax Paid -
Bank Account for 1-0150 Undeposited
Undeposited Funds Funds 7. Setup the following Jobs and Categories.
Job No. Job Name
b. Sales Linked Accounts
P PRODUCTS
Asset Account for
1-0200 Trade Debtors
Tracking Receivables S SERVICES
Bank Account for
1-0100 Cash Category No. Category Name
Customer Receipts
L LOCAL
c. Purchases Linked Accounts O OVERSEAS
Liability Account for
2-0200 Trade Creditors
Tracking Payables 8. Setup the following Cards List.
Bank Account for
1-0100 Cash Card Type Name Country
Paying Bills
Customer B-SOLUTION INDONESIA
6. Delete all other tax codes, except "N-T" tax code. Customer C-WORKSHOP SINGAPORE
Add and edit the following Tax Codes details. Supplier D-SUPER INDONESIA
Tax Code V00 V10 Supplier E-OFFICE SINGAPORE
Description VAT 0% VAT 10% Employee JOY INDONESIA
Goods & Goods &
Tax Type Employee KEN SINGAPORE
Services Tax Services Tax
Rate 0% 10%
Linked Account:
2-1100 2-1100
Tax Collected
VAT Collected VAT Collected
2-1200 2-1200
Tax Paid
VAT Paid VAT Paid
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 3
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
9. Setup the following Items List. 10. Setup the following Account Opening Balances.
Item# P1 P2 Account# Name Balance
1-0100 Cash Rp500,000
Name PRODUCT 1 PRODUCT 2
1-0130 Bank Rp2,000,000
5-1000 5-1000
I Buy
COGS (Products) COGS (Products) 1-0150 Undeposited Funds Rp0
4-1000 4-1000 1-0200 Trade Debtors Rp1,100,000
I Sell
Sales (Products) Sales (Products)
1-0300 Inventory Rp500,000
1-0300 1-0300
I Inventory 1-2110 Offi ce Equip at Cost Rp1,200,000
Inventory Inventory
1-2111 Offi ce Equip Accum Depn (Rp100,000)
Buying Tax N-T N-T
2-0100 Credit Card Rp0
Min. Level 1 1
2-0200 Trade Creditors Rp2,200,000
Selling Price Rp100,000 Rp200,000 2-1100 VAT Collected Rp100,000
Selling Tax N-T N-T 2-1200 VAT Paid (Rp200,000)
2-1300 VAT Clearing Rp0
Unit UNIT UNIT
3-0100 Share Capital Rp3,000,000
3-0800 Retained Earnings Rp100,000
Item# P3 S1
11. Setup the following Customer A/R Opening
Name PRODUCT 3 SERVICE 1
Balances (Historical Sale).
5-1000 5-2000
I Buy
COGS (Products) COGS (Services) Customer Name B-SOLUTION
I Sell 4-1000 4-2000 Terms Net 30
Sales (Products) Sales (Services)
Invoice# S-090001
1-0300
I Inventory -
Inventory Date 31-12-2009
Buying Tax N-T N-T Customer PO# BSP-090001
Min. Level 1 - Memo Pre-conversion sale
Selling Price Rp300,000 Rp400,000 Total Including Tax Rp1,100,000
Selling Tax N-T N-T Tax Code V10 (VAT 10%)
Unit UNIT UNIT Category L (LOCAL)
Create the following Auto-Build Item for P3
(PRODUCT 3) with the following formula:
P3 = P1 + P2
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 4
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
12. Setup the following Supplier A/P Opening Balances 15. Enter the following Purchase: Items transaction.
(Historical Purchase).
Supplier Name D-SUPER
Supplier Name D-SUPER Terms Net 30
Terms Net 30 Purchase# P-100001
PO# P-090001 Date 15-01-2010
Date 31-12-2009 Supplier Inv# DSS-100001
Supplier Inv# DSS-090001 Bill / Received 3 3
Memo Pre-conversion purchase Item# P1 P2
Total Including Tax Rp2,200,000 Description PRODUCT 1 PRODUCT 2
Unit Price
Tax Code V10 (VAT 10%) Rp50,000 Rp100,000
(excl. tax)
Category L (LOCAL)
Tax Code V10 (VAT 10%) V10 (VAT 10%)
Category L (LOCAL)
13. Setup the following Inventory Opening Balances.
Use Count Inventory or Adjust Inventory in
16. Enter the following Purchase: Services transaction.
Inventory Command Centre.
Inventory Supplier Name E-OFFICE
I-100001
Journal#
Terms C.O.D.
Date 01-01-2010
Purchase# P-100002
Memo INVENTORY OPENING BALANCE
Date 16-01-2010
Item# P1 P2
Supplier Inv# EOS-100001
Name PRODUCT 1 PRODUCT 2
Description OFFICE RENT FOR WORKSHOP
Quantity 6 2
Account # 6-1000 Rent
Unit Cost Rp50,000 Rp100,000
Amount
Account 1-0300 Inventory 1-0300 Inventory Rp1,000,000
(excl. tax)
Category L (LOCAL) Job S
Tax Code V00 (VAT 0%)
14. Exit, Back up, Open and Verify the Company File. Category O (OVERSEAS)
NOTE:
Back up the Company File (Only),
Check Company File for Errors and
Save the Company File Back up in Backup Sub-
Folder.
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 5
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
17. Enter the following Purchase: Returns & Debits 19. Enter the following Sale: Items transaction.
transaction, and Apply the Debit Amount to
Customer Name B-SOLUTION
Purchase.
Terms Net 30
Supplier Name D-SUPER
Invoice# S-100001
Terms C.O.D.
Date 19-01-2010
Purchase# P-100003
Customer PO# BSP-100001
Date 17-01-2010
Ship 1 1
Supplier Inv# DSS-100001
Item# P1 S1
Bill/Received -1 (RETURN 1 UNIT)
Description PRODUCT 1 SERVICE 1
Item# P1
Unit Price
Rp100,000 Rp400,000
Description PRODUCT 1 (excl. tax)
Unit Price Job P S
Rp50,000
(excl. tax)
Tax Code V10 (VAT 10%) V10 (VAT 10%)
Tax Code V10 (VAT 10%)
Salesperson JOY
Journal Memo Purchase RETURN; D-SUPER
Category L (LOCAL)
Category L (LOCAL)
20. Enter the following Sale: Services transaction.
Apply to Purchase:
Customer Name C-WORKSHOP
ID # P-100003
Terms C.O.D.
Date 17-01-2010
Invoice# S-100002
Debit Amount Rp55,000
Date 20-01-2010
Supplier's # DSS-100001
Date 15-01-2010 Customer PO# CWP-100001
Amount Applied Rp55,000 Description WORKSHOP
Account# 4-2000 Sales (Services)
18. Enter the following Pay Bills transaction.
Amount
Rp2,000,000
Supplier Name E-OFFICE (excl. tax)
Account 2-0100 Credit Card Job S
Cheque No. D-100001 Tax Code V00 (VAT 0%)
Date 18-01-2010 Salesperson KEN
Amount Paid Rp1,000,000 Category O (OVERSEAS)
Supplier's # EOS-100001
Date 16-01-2010
Amount Applied Rp.1,000,000
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 6
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
21. Enter the following Sale: Returns & Credits 22. Enter the following Receive Payments transaction.
transaction, and Apply the Credit Amount to Sales.
Customer Name C-WORKSHOP
Customer Name C-WORKSHOP Deposit to Account 1-0100 Cash
Terms C.O.D. ID # R-100001
Invoice# S-100003 Date 21-01-2010
Date 21-01-2010 Amount Received Rp1,800,000
Customer PO# CWP-100001 Invoice # S-100002
Date 20-01-2010
WORKSHOP - CASH PAYMENT
Description DISCOUNT 10% Amount Applied Rp1,800,000
Account# 4-2000 Sales (Services)
23. Enter the following Spend Money transaction.
Amount
(excl. tax) -Rp200,000 Account 1-0100 Cash
Job S Cheque No. D-100002
Date 22-01-2010
Tax Code V00 (VAT 0%)
Amount Rp1,100,000
Salesperson KEN
CREDIT CARD PAYMENT &
Sales DISCOUNT; Memo
Journal Memo BANK CHARGES
C-WORKSHOP
Category O (OVERSEAS) Acct# Name Amount Job Tax
2-0100 Credit Card Rp1,000,000 - N-T
Apply to Sale :
6-2000 Bank Charges Rp100,000 - N-T
ID # S-100003
Category O (OVERSEAS)
Date 21-01-2010
Credit Amount Rp200,000 24. Enter the following Receive Money transaction.
Invoice # S-100002 Account 1-0130 Bank
Date 20-01-2010
ID# R-100002
Amount Applied Rp200,000
Date 23-01-2010
Amount Rp50,000
Memo INTEREST INCOME
Acct# Name Amount Job Tax
Interest
8-1000 Rp50,000 - N-T
Income
Category L (LOCAL)
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 7
PT. Net21Plus
MYOB Professional Partner | MYOB Certifi ed Trainer
25. Perform Bank Reconciliation for Account: "1-0130 27. Enter the following Inventory Journal. Use Auto-
Bank". Build Items and Build Items in Inventory Command
On 31-01-2010, the Statement Balance is Centre.
Rp2,050,000. a. Auto-Build Items.
I. Journal # I-100002
26. Enter the following Journal. Use Record Journal
Entry in Accounts Command Centre. Date 31-01-2010
a. Depreciation.
Memo INVENTORY AUTO-BUILD P3 = 2 UNIT
G. Journal # G-100001
Item# Qty Unit Cost Amount Job
Date 31-01-2010
P3 2 Rp150,000 Rp300,000 -
Memo DEPRECIATION (JAN 2010)
P1 -2 Rp50,000 (Rp100,000) -
Acct# Name Debit Credit Job Tax
P2 -2 Rp100,000 (Rp200,000) -
6-3000 Depreciation Rp50,000 - N-T
Category L (LOCAL)
Offi ce Equip
1-2111 Rp50,000 - N-T
Accum Depn
b. Build Items (e.g. Exchange).
Category L (LOCAL)
I. Journal # I-100003
Date 31-01-2010
ADDITIONAL TASKS : Memo INVENTORY (EXCHANGE)
Save above Depreciation Journal as Monthly
Recurring Transaction starting on 31-01-2010, and
Item# Qty Unit Cost Amount Job
use "Use Recurring" to record the transaction.
P1 -2 Rp50,000 (Rp100,000) -
P2 1 Rp100,000 Rp100,000 -
b. VAT Clearing.
G. Journal # G-100002 Category L (LOCAL)
Date 31-01-2010
Memo VAT CLEARING (DEC 2009)
Acct# Name Debit Credit Job Tax
2-1100 VAT Collected Rp100,000 - N-T
2-1200 VAT Paid Rp200,000 - N-T
2-1300 VAT Clearing Rp100,000 - N-T
Category L (LOCAL)
Computerised Accounting with MYOB - Basic (Book 1) 2nd Edition 8