myob premier v.13 intermediate - official site of lana...
TRANSCRIPT
MYOB PREMIER V.13 INTERMEDIATE
CASE : PT BRIGHT
1. CREATE A NEW COMPANY FILE 2. SETUP THE COMPANY DATA FILE
Accounting Information
Last Month: DECEMBER
Conversion Month :
JANUARY
Current Financial Year : 2011
Number of Accounting period:
THIRTEEN
In case : “The Company starts using one of the account list provided by MYOB Premier V13. So you don’t need to set up the account list completely”. Choose first option.
“Bright, PT”. The business is Boat Dealer, buying and selling boats, parts and accessories to end users.
Accounts List
Change the location disk and save your Myob file on “Your Folder Name”
New Company File Asistant
SETUP PREFERENCES -Tick the option for “I Deal Multiple Currencies (System-Wide)”
Preferences - System
Untick the option for “Automatically Check Spelling in Text Field Before Recording Transaction [System- Wide]”
Preferences - Windows
Tick the option for: “Warn for Duplicate Invoices Numbers on Recorded Sales”
Preferences – Sales
LIST - CURRENCY Delete all currencies list, except LOCAL currency
(Singapore Dollars) then edit
Currency
Code
Currency Name Exchange Currency
Symbol
IDR Rupiah 1.000000 Rp
SGD Sin Dollar 7000.000000 S$
LIST - CURRENCY
click NEW
LIST - ACCOUNT Hapus akun-akun berikut:
•1-2120 Payroll Cheque Account
•1-2130 Cash Drawer
•1-2210 Less Prov’n for Doubtful Debts
klik dua kali pada akun tsb. Kemudian pilih edit, delete account.
1-2110 Cheque Account, menjadi Bank (IDR) 1-2140 Petty Cash, menjadi Cash (IDR) 1-2120 1-2160 Undeposited Funds menjadi 1-2130 Undeposited Cash 1-2200 Trade Debtors, menjadi Trade Debtors (IDR) 2-2200 Trade Creditors, menjadi Trade Creditors (IDR)
pilih akun yang akan dirubah. Kemudian edit dengan cara klik dua kali akun tersebut.
Ubah akun-akun berikut:
Membuat akun baru
1-2140 Cash (SGD) type bank dan detail, level 4 1-2141 Cash (SGD) Exchange type bank dan detail, level 4 1-2150 Bank (SGD) type bank dan detail, level 4 1-2151 Bank (SGD) Exchange type bank dan detail, level 4 1-2210 Trade Debtors (SGD) type Accounts Receivable dan detail, level 3 1-2211 Trade Debtors (SGD) Exchange type Accounts Receivable dan detail, level 3 2-2220 Trade Creditors (SGD) type Accounts Payable dan detail, level 3 2-2221 Trade Creditors (SGD) Exchange type Accounts Payable dan detail, level 3 2-2340 GST Clearing type Other Liability dan detail , level 4 8-2000 Forex Gain (Loss) type Other Income dan header , level 2 8-2100 Realised Gain (Loss) Forex type Other Income dan detail , level 3 8-2200 Unrealised Gain (Los) Forex type Other Income dan detail , level 3
Klik new, pilih type akunnya, isi account number dan account name. Ok.
Klik new, pilih type akunnya, isi account number dan account name. Ok.
*Untuk akun yang berakhiran exchange tidak perlu dibuat karena akan muncul otomatis setelah kita membuat akun awalnya. Contoh: New, account type ‘bank”, account number “1-2140”, account name “Cash (SGD)” setelah itu ubah pada menu profile di atas menjadi details. Kemudian ubah currency menjadi “SGD”, lalu ok maka akan muncul 2 akun yaitu Cash (SGD) dan Cash (SGD) Exchange.
SETUP – LINK ACCOUNT
Ubah “Account for currency Gain/Losses” 4-9999 menjadi 8-2100
kembali ke list account lalu pilih account 4-9999, pilih combine account.
Pada primary account ubah menjadi 8-2100, lalu pada secondary account ubah menjadi 4-9999. Klik combine account, ok.
1
2
LIST – TAX CODE hapus semua kode pajak kecuali N-T. Caranya klik kanan pada kode pajak
lalu delete tax code.
Setup the tax code as GST (Goods and Services Tax), Tax Type: Goods and Services Tax, Rate: 10%.
Membuat Kode Pajak baru
To remove SR dan TX7 tax code Preferences – Sales/Purchase – Terms
Change: Tax Code : GST Freight Tax Code : N-T
So, now you can delete SR and TX7
LIST – JOB
Klik new, masukkan job number= R, job name= retail, ok. Klik new, masukkan job number=S, job name=services, ok.
LIST – CATEGORIES
Category ID= AM, Category name= “Alexandria
Mall”
category ID= KS, Category name= “Koniya
Store”
KLIK NEW
LIST – CURRENCIES
payable accounts. Pada “ Liability account for tracking payables in this currency” pilih 2-2220, pada “bank account for paying bill in this currency” pilih 1-2150, ok.
Receivable accounts, pada “asset account for tracking receivable in this currency” pilih 1-2210, pada “bank account for customer receipts in this currency’ pilih 1-2150, ok.
Pilih Sin dollar kemudian klik dua kali
LIST -> COSTUM LIST & FIELD NAMES -> PRICE LEVELS.
Ubah level A menjadi IDR dan ubah level B menjadi SGD, ok.
LIST – ITEMS
Klik NEW untuk input item
BMX-Boats Item no.BMX; selling price IDR: Rp 3.200.000; SGD: S$450: N-T)
Linked Account for I Buy as: Boat Purchases, I Sell as: Boat Sales, I Inventory as: Boats.
LIST - CARDS Customer name= “MAXIMA, PT” dengan currency IDR. name= “NUGRAHA, PT” dengan currency SGD. Supplier name= “CINAMON, PT” dengan currency IDR. name= “DELTA, PT” dengan currency SGD.
SETUP – BALANCES – ACCOUNT OPENING BALANCES
Masukan saldo awal dari tiap akun
*amount left to be allocated harus Rp 0.00
SETUP – BALANCES – CUSTOMER BALANCE
Pilih customer MAXIMA kemudian Use Customer
Isi sesuai data di modul untuk customer PT MAXIMA
SETUP - BALANCES – SUPPLIER BALANCES.
Isi sesuai data di modul untuk supplier PT CINAMON
ISI COUNTED
INVENTORY – COUNT
INVENTORY
ADJUST INVENTORY
Isi Unit Cost, Account
otomatis terisi. Record
Tanggal 2 Jan 2011 A purchase was raised to purchase the following inventory itme from main supplier, DELTA, PT on Net 15th
days credit terms. Not all the goods and bill was received. (PO#: P-118001, Supplier inv#: DLS-110001) •Received 3 units of BMX-Boats for S$400 (Exclude 10% GST) each, with backorder 5 units of BMX-Boats. •Received 5 units of GTN-Trailers for S$500 (Exclude 10% GST) each, with backorder 3 units of GTN-Trailers. •Received 50 units of PA for S$7 (Exclude 10% GST) each, with backorder 20 units of PA. [Category: AM] [Rate: 1S$= Rp 7.200].
Purchase
Enter Purchase
Bill
Tanggal 3 Jan 2011 Raised purchase to CINAMON, PT for Freight Paid Rp 1.100.000 inc 10% GST on Cash term. (PO#: P-118002, Supplier Inv#: CS-110001) [Category: KS].
Purchase
Enter Purchase
Bill
LAYOUT : SERVICES
Tanggal 3 Jan 2011
Bill was received n paid fully Rp 1.100.000 using Cash (IDR) to Mr. Ryan [Cheque No: D-118001]. Cinamon, PT
Purchase
Pay Bills
Tanggal 4 Jan 2011 Return 5 units of Parts & Accessories (PA) @S$7 (Exclude 10% GST) to DELTA, PT (PO#: P-118003, Supplier Inv#: DLS-110001) [Category: AM] [Rate 1S$: Rp 7.000]. Edit the Journal Memo “Purchase Return; DELTA, PT”.
Purchase
Enter Purchase
Purchase
Purchase Register
Return and Debits
4 Januari 2011 Immediately applied the Debit Note to Trade Creditor balance for DELTA, PT [ID#: P-118003] for bill on 2 Jan 2011 transaction. [Category: AM] [Rate 1S$: Rp 7.000].
Status OPEN
Tanggal 5 Jan 2011 Sold 2 Units of Repair-Service (item No. RS) Rp 560.000 (Exclude 10% GST) to MAXIMA, PT, on Net 10 days term (Inv#: S-118001) (Cust PO#; MXP-110001). [Job: S] [Category: AM] [Salesperson: Dewi].
Sales
Enter Sales
Invoice
Tanggal 6 Jan 2011 Sold the following items to NUGRAHA, PT on Net 30 days terms (Inv#: S-118001, Cust PO#: NGP-110001). All the goods and invoice was delivered: •Ship 5 units of BMX-Boats (BMX) for S$495 (Include 10% GST) each [Job: R] •Ship 5 units of GTN-Trailers (GTN) for S$522,5 (Include 10% GST) each [Job: R] •Ship 45 units of Parts & Accessories (PA) for S$9,9 (Include 10% GST) each [Job: R] [Salesperson: Ashley], [Category: AM], [Rate: 1S$= Rp 7.500].
Sales
Enter Sales
Invoice
Tanggal 7 Jan 2011 Issued S$10 Rebate Credit Notes to NUGRAHA, PT [Inv#: S-118003, Cust PO#: NGP-110001] as Discount Given rebate and edit Journal Memo with “Sale Discount: NUGRAHA, PT”. [Salesperson: Ashley], [Category: AM], [Rate: 1S$= Rp 7.200].
Sales
Enter Sales
Layout ubah jadi
SERVICES
7 Januari 2011 Immediately Pay Refund [Cheque No: D-118002] for the S$10 Sales Rebate to NUGRAHA, PT from the Cash (SGD). [Rate: 1S$= Rp7.200].
Sales
Sales Register
Return and Credits
Tanggal 8 Jan 2011 Partially payment of Rp 100.000 from MAXIMA, PT was received for Inv#: S-118001 and deposit to Cash (IDR), [ID#: R-118001].
Sales
Receive payments
Tanggal 10 Jan 2011 Use Spend Money [Cheque No: D-118003] to record expenses from Cash (IDR) Rp 4.000.000 for Office Supplies [Category: AM].
Banking
Spend Money
Tanggal 10 Jan 2011 Use Receive Money [ID#: R-118002] to record: Deposit Rp 500.000 to Bank (IDR), for Rp 525.000 Bank Interest Income and Rp 25.000 Bank Charges [Category: AM]
Banking
Receive Money
Perform Bank Reconciliation for the month of January 2011 for Bank (IDR) account. The bank statement shows a balance of Rp 100.500.000 on 31 Jan 2011.
Banking Reconcile accounts
In addition to the transaction above, prepare a journal entry to record the depreciation for Jan 2011, for the following asset categories [GJ#: G-118001][Category: AM]: Repair Equipment Rp 350.000 Save as Monthly Recurring Transaction for those journal then Use the Recurring and record depreciation journal for Feb 2011 [GJ#: G-118003] [Category: AM].
Accounts
Record journal entry
monthly, starting
date on = 1/31/2011
Prepare a journal entry to record the GST Clearing [GJ#: G-118002] for Jul 2011. [Category: AM]
Setelah muncul laporannya, lalu kita lihat GST collected dan GST paid nya, kita lihat jumlah balance nya. Kemudian input dalam jurnal
Adjust Inventory to record Inventory Found for Unit Cost Unknown [IJ#: I-118002] for 3 Units of Parts & Accessories (PA) [Job: R] [Category: AM].
Inventory Adjust Inventory
Update the Exchange Rate on end of Jan 2011 [1S$= Rp 7.800] and then prepare a journal entry to record Realised Gains (Losses) [GJ#: G-118003] and Unrealised Gains (Losses) [GJ#: G-118004] on 31 Jan 2011 and reverse journal for Unrealised Gains (Losses) [GJ#: G-118005] on begining of Sep 2011 [Category: AM].
Report -> Accounts -> Currency klik Unrealised Gain/Loss, Ubah As of menjadi 1/31/2011, klik
Display maka akan muncul Report Display
List -> currencies ubah Exchange Rate SGD menjadi 7800
NEXT
Accounts Record Journal Entry
Jurnal Realised
Jurnal UnRealised
Accounts Record Journal Entry
beri tanda check list pada Transaction CAN’T be Change
Preferences Setup Security
Accounts Transaction Journal
Pilih transaksi Unrealised Gain (Loss)
Edit, Reverse General Journal Transaction
Ubah GJ# = G-118005, Date = 9/1/2011
Record
Generate the following financial reports:
Reports
Send to PDF
Display
Pilih laporan
1. Profit & Loss statement for the month ending 31st for of Janust 2011.
2. Balance Sheet as at 31st Janust 2011 3. The following reports from 1 to Janust
2011 •General Journal •Bank Reconciliation Report •Sales & Receivables Journal •Purchases & Payable Journal •Item Register (detail) •Cash Receipts Journal •Cash Disbursement Journal
From Security Preference, activate the option for “Use Audit Trail Tracking “, then Lock the Accounting period for 31 Jan 2011
Setup Preferences Security
NEXT
File
Back Up
BACKUP your MYOB company data file (ONLY), Check Company File for Error and Save the MYOB company data backup file name as Your name in Backup Folder.
From Company Data Auditor – Transaction Review for 1 Jan 2011 to 31 Jan 2011, there is a “?” mark for Scan for Future Dated Transaction. Display it & Sent to PDF the reports. And then delete those Future Dated Transaction journal.
Transaction Review
Set start date and End date and Run Review
Klik ‘Display’ on ‘Scan for future dated transactions’
Delete all transaction on 4 Jan 2011
Setup Preferences Untick ‘Lock Period’
Accounts Transaction Journal
Delete all transactions on 4 Jan 2011
Standard Balance Sheet
Modify to Microsoft Excel the Standard Balance Sheet reports in T Format
Send to Excel
Edit
Reports