Thursday, December 14, 2006

Office Accounting Professional 2007: New features?

Microsoft has released previews of their latest small business accounting software, called Office Accounting 2007. Some of the new features in Office Accounting Express 2007:
> Online sales integration gives you the ability to sell inventory, track activity, and download orders in online marketplaces such as eBay directly from Office Accounting Express 2007.


> Equifax credit service enables you to monitor credit for your business, customers, or prospects.
> PayPal integration enables you to get paid faster by offering the PayPal payment option to customers.
> Microsoft Office Live integration enables businesses to more securely exchange financial information with accounting Professionals and other contacts.
> Accountant Transfer Wizard helps you share data with an accounting Express and synchronizes data easily after the accountant is done updating the books.
> Accountant View page provides a central location from which accountants can manage Office Accounting Express 2007 data for multiple clients independently.
> Data import enables users to import accounting and financial data from additional programs and versions, including Microsoft Money, Excel, and QuickBooks.
> Account and Customer Integration Wizard enables synchronized data sharing so that you can make updates to a customer’s record in one program and quickly see the results in the other program.
> Journal entry is now expanded so you can be more productive by creating numerous journal entries posting on different dates and with different accounts.
> Forms customization has been improved so you can tailor any form by adding, moving, creating, or renaming fields, and hiding unnecessary data element fields.
> Customizable security roles have been improved and now you can add and remove employee permissions to control access to sensitive financial information.

Read More..

Tuesday, December 05, 2006

MYOB V15

+ The Company Data Auditor

In the new versions of MYOB (Accounting/Plus v15 and Premier v9) you can now check the integrity of your data on a more regular basis by using the new Company Data Auditor. With just a click of the mouse you'll have instant answers to your accountant's questions!

+ File information


The opening screen of the Company Data Auditor provides information such as the file name, the version of MYOB you're using, the size of the file, the last time it was backed up and verified, whether it has been locked for a previous period. It also specifies the version of payroll tax tables you're using. From this first screen you can also perform tasks like locking the periods or doing a backup.

+ Account Reconciliation

Within the Company Data Auditor is an 'Account Reconciliation Review' which shows you and your accountant the bank and credit card accounts that have been reconciled and when. You can also reconcile these accounts and view transactions.

+ Data Exception Review

Your accountant will love this new feature of MYOB, and so will you. It will save them time, and save you money on accounting fees. The Data Exception Review provides your accountant (and you if you choose to review this before sending them the file) with all the necessary reconciliation reports. It also identifies any problems within your file. By clicking the Run Review button, the Company Data Auditor will:
advise whether the control accounts balance, such as Debtors, Creditors and Inventory
identify transactions with a future date
list changes made to transactions, tax codes or system preferences by each user so you can identify who entered data or made changes and when (through the audit trail)
compare the GST codes used on a transaction against the default GST codes assigned to that account.

After you've run the Data Exception Review, reports are available through this area which detail the problem transactions. This enables you to fix any problems before sending the file to your accountant.

Read More..

Monday, November 27, 2006

EDP Audit

Komputerisasi telah merambah ke segala bidang, tak terkecuali bidang auditing.
Seorang auditor dituntut tidak hanya mahir dalam audit konvensional tetapi juga harus dituntut untuk dapat melakukan EDP Audit. Untuk itu diperlukan keahlian tentang seluk belum komputer dari hardware hingga software.
Salah satu soft tool audit adalah ACL for Windows. Aplikasi ini memiliki fasilias untuk mengaudit data yang berbentuk soft copy. Namun aplikasi ini hanya mengaudit secara umum mengenai kevalidan data, verifikasi, ringkasan statistik maupun manipulasi data (through the computer). Selain ACL sebenarnya ada beberapa software yang sudah sering kita kenal seperti Excel maupun SPSS dapat dimanfaatkan untuk audit model ini.


Untuk lebih sempurnya audit sebaiknya juga ikut 'mencicipi' ke dalam sistem yang sedang di audit (within the computer). Seorang auditor akan mencoba bagaimana menginput data ke dalam aplikasi yang digunakan hingga mencoba melakukan audit trails dari sistem tersebut.

Read More..

Friday, August 18, 2006

MYOB for BMT SIMPAN PINJAM

Aku baru aja selesaiin materi MYOB untuk BMT Simpan Pinjam, pesanan dari Sangkala (Edumedia), sebuah pengembang aplikasi multimedia,Insyaallah bisa diterbitkan, mungkin dalam waktu dekat ini akan dipasarkan.


Tutorial ini berbentuk cd interaktif, aku coba implementasikan MYOB untuk jenis usaha BMT / Simpan Pinjam. Penasaran? tunggu aja ya ...

Read More..

Thursday, July 27, 2006

BELAJAR MYOB (BAGIAN 2)

Setelah anda masuk command centre, langkah selanjutnya adalah mendesain daftar akun.
Namun sebelumnya kita kenalan dulu dengan feature2 di MYOB :

"MYOB is a global provider of solutions that liberate business owners and accountants from the burden of day to day administration, empowering them to achieve business success"
  1. Menubar, berada di bagian atas berisi menu konvensional seperti File, Edit, List dst.
  2. Modul, berada di bagian jendela command centre berupa ikon2 / tombol bergambar seperti Account, Banking, Sales s/d Card File. Jika kita klik modul ini maka akan diikuti perubahan skema alur dibawahnya. Misal kita pilih modul Account, akan tampil pilihan dalam skema Account List, Record Journal Entry dst.
  3. Panel, berada di bagian bawah dan terdapat pilihan dengan meng-klik drop down di samping kanannya. Panel2 tsb antara lain, To do list, Find Transaction, Report & Analyse
Setelah mengenal feature-nya kita akan mendalami dulu tentang struktur penomoran akun di MYOB. MYOB mempunyai struktur akun 5 digit : X - XXXX. Digit pertama menunjukkan kelompok akun :

1 : kelompok akun AKTIVA
2 : kelompok akun KEWAJIBAN
3 : kelompok akun MODAL
4 : kelompok akun PENDAPATAN
5 : kelompok akun HPP
6 : kelompok akun BIAYA
------ (MYOB tidak menyediakan akun berkepala 7)
8 : kelompok akun PENDAPATAN LAIN-LAIN
9 : kelompok akun BIAYA LAIN-LAIN

Sedangkan 4 digit berikutnya bisa dibuat sebagai struktur akun di bawahnya.
Tiap kelompok akun dimulai dengan no X - 0000. Berikutnya anda bisa buat pecahannya, misal :

1-0000 Aktiva
1-1000 Aktiva lancar
1-1100 Kas & Bank
1-1101 Kas
1-1102 Bank Muamalat ...... dst

Related Posts:

Read More..

Friday, July 21, 2006

Changing MYOB default currency

Windows 98 :
Close MYOB and go to Start > Settings > Control Panel > Regional Settings, and select an item to match its preferences..
Windows XP :
Close MYOB and go to Start > Control Panel > Regional & Language > select an item to match its preferences.

Read More..

Thursday, June 29, 2006

BELAJAR SPSS (pemula)

SPSS merupakan software statistik paling populer, fasilitas & penggunaannya pun cukup familier.
Langsung aja ya ...
Masuk program SPSS (cari aja short cutnya ato lewat tombol start).
Tampilannya kaya' excel, perhatikan ada 2 sheet di bawah, yaitu Data View & Variable View. Untuk memasukkan data terlebih dulu ditentukan variabelnya (misal nama, berat badan, tinggi badan etc)yang bisa ada rinci di sheet variabel view.
name : diisi nama variabel misal nama
type : diisi tipe data misal numeric (untuk data angka) & string (untuk data text)
width : diisi jumlah karakter maksimal yang akan diinput dalam data view
decimal: diisi jumlah digit desimal
label : disii keterangan untuk variabel (boleh dikosongi)
value : untuk memberi kodifikasi value, misal Pria = 1 & wanita = 2
missing: untuk perlakuan data terhadap missing value (abaikan sesuai default)
align : untuk pengaturan tampilan perataan dalam data view, left-centre-right
measure: secara default akan terpilih Nominal jika variabel bertype string, dan akan terpilih Scale jika data bertype Numeric.


Setelah ditentukan variabelnya, sekarang tinggal mengisi data di sheet Data View.
Tinggal kita proses dulu lewat menu Data & Transform jika diperlukan.
Jika data sudah siap bisa kita analisa lewat menu Analyze, tinggal pilih aja alatnya apa misal Descrptive Statistic, Compare Means, Correlate, Regression dll.

Jika anda ingin request kasus penyelesaian dengan SPSS bisa masukkan request di PESAN SINGKAT di sisi kanan blog ini.

Related Posts:
Mudahnya Uji Validitas & Reliabilitas Data (SPSS)
Tips Interpretasi Output SPSS

Read More..

Monday, June 26, 2006

LANGKAH MYOB (untuk pemula)

Bagi para pemula yang akan menggunakan program MYOB, khususnya MYOB Accounting V 12 ke atas saya punya tips untuk memulai memasukkan data :
> Masuk Program MYOB (klik shortcutnya aja ato lewat start > all program > MYOB Accountin V12
> Pilih CREATE untuk membuat data baru
> Next
> Isikan data perusahaan mulai nama perusahaan (company name) sd e-mail addrees kalo ada
> Next


> Tentukan Accounting Year, current financial year dipilih tahun akhir periode akuntansi, last month dipilih bulan akhir periode akuntansi, conversion month dipilih bulan konversi/bulan data awal di MYOB, & number of accounting period biarkan pada pilihan twelve
> Next
> Next
> Pilih pilihan Build your account list, kalo mau buat akun dalam bahasa indonesia sebaiknya pilih i would like to import ... (supaya lebih mudah menambah akun)
> Klik change untuk menempatkan data mau disimpin dimana (bebas, misal di MY Document)
> Tunggu proses penyimpanan, kemudian pilih Command Centre


Related Posts:

Read More..

Tuesday, June 20, 2006

KOMPUTERISASI AKUNTANSI sebuah peluang

Saat ini hampir semua bidang telah terambah komputerisasi, tak terkecuali bidang akuntansi, hal ini tentu saja juga menumbuhkan peluang usaha, misalnya penjualan software akuntansi, konsultan IT, tenaga edukasi, implementator software, dll. Kebetulan saya juga bersinggungan dengan komputerisasi akuntansi ini, dalam hal ini saya menjadi tenaga edukasi khususnya komputerisasi akuntansi pada sebuah lembaga pendidikan di jogja, disamping itu saya juga beberapa kali menjadi implementator beberapa software akuntansi di beberapa perusahaan.

Kadang kita tidak mesti harus menguasainya, mungkin kita juga bisa memanfaatkan peluang ini, misal dengan menjadi distributor produk IT berbasis akuntansi, atau sebagai referensi dengan bekerja sama dengan para praktisi yang bergerak di bidang ini (tentu saja kita bisa mendapatkan fee dari sini). Jika di tempat anda, anda bisa menemukan peluang di bidang ini, mungkin kita bisa saling bekerja sama :). Marilah kita ciptakan peluang usaha, tetap semangat wahai pecinta akuntansi!!

Read More..

Monday, June 12, 2006

Copying & Pasting SPSS Tables & Graphs to MS Word

You can copy SPSS output (tables and graphs) easily to MS Word.

In the SPSS Output Viewer:

1. Select an output item (table or graph) by clicking on it once. (Double click will open the item for editing). A red arrow to the left of the object indicates that the item is active.
2. From the pull-down menus, choose Edit>Copy or Edit>Copy object.
Alternatively, right click the mouse button to get a drop down menu with the same options.
Copy objects” treats the SPSS item as a pixels (i.e, a picture). It will look exactly as in the SPSS output, but you will not be able to edit the item in MS Word. It is best for graphs.
The “Copy” option will transfer the information in a table, which you can then edit uses the Tables menu in MS Word. It is best for tables so that they can be edited into APA format in MS Word.


3. Go to a document in MS Word and choose Edit>Paste or Ctrl+V.
4. If you have problems with the size or positioning of a picture (such as an SPSS object or graph) in MS Word, right click on the object and choose “Format Picture”.
5. You can prevent a picture from floating with the text under the “Layout” tab. Choose “In line with text” as the wrapping style. The picture will now be fixed, and you can choose the exact point in the text where you want it to appear.

Related Posts:
Opening/Importing Database Into SPSS Using Database Wizard

Read More..

Wednesday, June 07, 2006

How to ....

How to add lines,headers/subtotals to invoices/quotes


With MYOB BusinessBasics, MYOB Accounting, MYOB Accounting Plus, MYOB Premier and MYOB AccountEdge you can add lines, headers or subtotals to invoices or quotes. This makes it easy to separate and subtotal different categories of a sale or purchase. For example, a purchase might have a materials component and a time component. This feature lets you add a subtotal line for each component, giving your customers a quick breakdown of costs. Here are ways to use this feature.

To insert a blank line
1. Position the mouse pointer anywhere on the invoice/purchase line above which you want the blank line to appear.
2. Go to "Edit" menu and choose "Insert Line".

To insert a header and group several invoice/purchase lines
1. Position the cursor on the invoice/purchase line above which you want the header to appear.
2. Go to the "Edit" menu and choose "Insert Header". A blank line will appear in the scrolling list with the cursor positioned in the "Description" column.
3. Type the text for the header. (The text will appear in grey.)


To insert a subtotal
1. Position the mouse pointer on the first line below the invoice/purchase lines to be subtotalled.
2. Go to the "Edit" menu and choose "Insert Subtotal". A line will appear, displaying the subtotal of all the invoice/purchase lines above it.

To delete a blank line, line item, header or subtotal
1. Position the mouse pointer anywhere on the blank line, line item, header or subtotal you want to delete.
2. Go to the "Edit" menu and choose "Delete Line".

Read More..

Friday, May 26, 2006

Backup Your Data (MYOB)

File > Backup > Continue
Save in : ........
Fill File name if you want to change.
Then - Save.

To open your backup file :
File > Restore
Find your back up file has placed.
Save.

Read More..

Monday, May 22, 2006

Mudahnya Uji Validitas & Reliabilitas Data (SPSS)

Jika saat ini anda sedang menyusun skpipsi dengan sedikit usaha anda nggak perlu repot-repot datang ke tempat konsultan skripsi (pasti mahal bo’) untuk menguji validitas & reliabilitas kuesioner anda.

"SPSS Inc. is a leading worldwide provider of predictive analytics software and solutions. Founded in 1968, today SPSS has more than 250,000 customers worldwide, served by more than 1,200 employees in 60 countries."

Sumber data sebuah penelitian ada kalanya menggunakan data dari hasil kuesioner. Tentunya dalam penyusunan sebuah kuesioner harus benar-benar bisa menggambarkan tujuan dari penelitian tersebut (valid) dan juga dapat konsisten bila pertanyaan tersebut dijawab dalam waktu yang berbeda (reliabel).
Secara mudah kuesioner diuji cobakan dulu kepada responden sample (misal 30 responden).
Dalam spss langkah menentukan butir pertanyaan yang valid dapat dilakukan dengan mudah.
Langkahnya adalah sebagai berikut :


Analyse > Scale > Reliability Analysis
Pada bagian Statistic aktifkan kotak cek Item, Scale, Scale if item deleted.
Abaikan pilihan yang lain, klik Continue – OK.
Cara baca output:
Lihat pada bagian Item-total statistic pada kolom Corrected Item Total Correlation, nilai-nilai tersebut menunjukkan nilai korelasi butir-butir pertanyaan terhadap skor totalnya. Nilai hitung tersebut dibandingkan dengan r tabel (lihat ditabel dengan terlebih dulu mencari df-nya (derajat kebebasan) sesuai dengan datanya dan asumsi spss akan menggunakan tingkat signifikansi 5%).
Pengambilan kesimpulannya jika nilai hitung > dari nilai r-tabel maka butir tersebut dinyatakan valid. Perlu diperhatikan karena data adalah 1 arah (ke arah positif) maka nilai hitung yang bernilai negatif otomatis tidak valid. Jika masih ada butir yang tidak valid maka dikeluarkan (klik kanan pada nama variabelnya – Clear) kemudian diproses ulang (ulangi langkah Analyse > Scale > Reliability Analysis, dst) sampai mendapatkan semua butir valid.
Kemudian untuk menentukan reliabilitas bisa dilihat dari nilai Alpha jika nilai alpha lebih besar dari nilai r tabel maka bisa dikatakan reliabel. Ada juga yang berpendapat reliabel jika nilai r > 0,60.
Sekarang kuesioner telah siap untuk disebar ke responden yang ditargetkan.
Sebagai catatan untuk mencari nilai korelasi data juga bisa dilakukan lewat menu Analyse > Correlation > Bivariate.
Selamat mencoba.

Jika masih belum jelas bisa disampaikan lewat comment atau pada pesan singkat di sisi blogs ini.

Related Posts:
Belajar SPSS (pemula)
Tips Interpretasi Output SPSS(pemula)

Read More..

Saturday, May 20, 2006

How can I make Peachtree Accounting run faster?

1. Make sure your computer meets the minimum specifications for your version of Peachtree.
2. Delete unneeded data from closed financial years.
3. Turn off Smart Data Entry options (under Options > Global)
4. Turn off Recalculate Cash Balance Automatically (under Options > Global)
5. Close other programs that are running.
6. Make sure you have at least 100 MB of free hard drive space.

Read More..

What's new in Peachtree 2006?

1. Peachtree will now warn you when a duplicate reference number is being used on a quote, invoice, credit memo or purchase order.
2. Peachtree will automatically fill in key fields based on past entries and store info in drop down menus for future use.
3. The new Internal Accounting Review looks for suspicious transactions and common accounting mistakes such as duplicate transactions and cash receipts that do not debit the correct General Ledger cash account.

Read More..

Akuntansi perpajakan

Saat ini dibutuhkan seorang staff akuntansi yang tidak hanya bisa menyusun laporan keuangan komersial namun juga dituntut untuk bisa menyajikan laporan keuangan fiskal, tentunya jika kita terjun ke dunia akuntansi harus menyiapkan jurus2nya. Apa saja yang mesti kita kuasai? berikut poin-poin yang bisa anda selami lebih dalam :
1. Akuntansi Perpajakan atas Persediaan
2. Akuntansi Perpajakan Penyusutan
3. Akuntansi Leasing
4. Revaluasi Aktiva Tetap


5. Selisih Kurs
6. Akuntansi Penghasilan Final
7. Akuntansi Investasi
8. Akuntansi atas Penggabungan, Peleburan, dan Pemekaran Perusahaan
9. Menyusun Laporan Keuangan Fiskal
10. Rekonsiliasi Lap. Keuangan Komersial dan LK Fiskal

Read More..

Monday, May 15, 2006

Change the date format (MYOB Accounting)

A very common question, and very annoying if you can't get the date around the right way! As you have hinted at, MYOB reads the date format directly from the computer's Control Panel. Open up the Regional Settings control panel and be sure that the language is set to English (New Zealand). Then click on the Date tab at the top of the window and ensure that the Short Date Format is set to dd/mm/yyyy. The double 'd' at the beginning is very important; if it is set to d/mm/yyyy, some computers will still show the date as m/d/yyyy! Click Apply, and then OK. Restart the computer to ensure the new settings are taking full effect. Then restart MYOB and the date should be around the correct way.

Read More..

Friday, May 12, 2006

VERIFYING & OPTIMISATION (MYOB Accounting)

There are two other functions within the program that will ensure your company file:

VERIFYING

Generally speaking, the MYOB data verification feature scans everything inside your company file - from the transaction entries you've made into the MYOB system to the computer code that makes up the basic foundation of any MYOB company file. The data verification can catch minor inconsistencies in your company's file before they cause serious problems.

To verify your company file:
> Select File from the menu
> Click on Verify Company File.

OPTIMISATION



You may want to use the MYOB Optimisation Assistant on a regular basis to keep your company file operating at its peak. The Optimisation Assistant can ensure that the file is operating efficiently, and it may resolve minor problems with the company file, as well.

To optimise your company file:

> Select File from the menu
> Click on Optimise Company File.

Read More..

Monday, May 08, 2006

welcome to my bloggy

site ini sebenarnya aku buat untuk interaksi dengan siswa2 ku karena saat ini aku masih menjadi intruktur komputer khususnya komputerisasi akuntansi, baik yang masih aktiv maupun yang dah kelar, moga silaturahmi masih bisa terjaga, disamping itu aku juga 'nyambi' jadi implementator di beberapa perusahaan. Namun demikian silahkan aja siapa aja yang berminat dengan komputerisasi akuntansi untuk bergabung di sini. monggo ...

Read More..

Privacy Policy

My Bloggy Privacy Statement



What follows is the Privacy Statement for My Bloggy and other blogs belows:
  • freeexceltemplate.blogspot.com
  • freeinventorysoftware.blogspot.com
Please read this statement regarding our blogs. If you have questions please ask us to butzajogja at yahoo dot com.

Email Addresses

You may choose to add your email address to our contact list (butzajogja at yahoo dot com). We agree that we will never share you email with any third party and that we will remove your email at your request. We don’t currently send advertising via email, but in the future our email may contain advertisements and we may send dedicated email messages from our advertisers without revealing your email addresses to them. If you have any problem removing your email address please contact us.


Comments/Message Boards

Most My Bloggy blogs contain comment sections (a.k.a. message boards). We do not actively monitor these comments and the information on them is for entertainment purposes only. If we are alerted to something we deem inappropriate in any way, we may delete it at our discretion. We use email validation on most of our message boards in order to reduce “comment spam.”

Cookies

Currently we assign cookies to our readers in order to save their preferences. This data is not shared with any third party. Accessing our blogs is not dependent on accepting cookies and all major browsers allow you to disable cookies if you wish.

Third Party Cookies

Many of our advertisers use cookies in order to determine the number of times you have seen an advertisement. This is done to limit the number times you are shown the same advertisement. My Bloggy does not have access to this data.

Traffic Reports

Our industry-standard traffic reporting records IP addresses, Internet service provider information, referrer strings, browser types and the date and time pages are loaded. We use this information in the aggregate only to provide traffic statistics to advertisers and to figure out which features and editorials are most popular.

Links

My Bloggy blogs frequently link to other blogs/websites. We are not responsible for the content or business practices of these blogs. When you leave our blogs we encourage you to read the destination site’s privacy policy. This privacy statement applies solely to information collected by My Bloggy.

Notification of Changes

When My Bloggy makes changes to this privacy policy we will post those changes here.

Contact Information
If you have any questions regarding our privacy policy, please contact us.

Read More..

Categories