Microsoft Excel for Perhitungan PPh Pasal 21 with Gross Up

Micrsoft Excel dapat digunakan untuk membantu melakukan perhitungan PPh Pasal 21 termasuk metode Gross up untuk tunjangan pajak karyawan. Perhitungannya pun cukup sederhana, dan dapat digunakan sebagai calculator PPh Pasal 21.
Sebelumnya pastikan setingan regional pada control panel di windows anda berada pada pilihan Indonesian.
Berikut langkah-langkah pembuatan sheet 'Calculator PPh Pasal 21':
1. Siapkan sheet untuk tabel PTKP

Beri nama tabel (seleksi sel B5:B12, kemudian Insert>Name>Define) dengan nama PTKP.
Asumsi nilai PTKP sesuai yang berlaku saat postingan ini saya buat.

2. Siapkan sheet untuk Perhitungan PPh Pasal 21

Kasus berikut misal Budi karyawan tetap dengan data sbb:


Contoh di atas untuk asumsi PKP s/d Rp. 25.000.000,-
Untuk yang PKP > 25juta silahkan memodifikasi sel C18 (PPh Pasal 21 Setahun) dengan fungsi logika bertingkat.

Untuk metode gross up, anda dapat memanfaatkan fasilitas Tools > Gool Seek.

Read More..

Quickbooks Tips and Tricks Are Recommended

This url address for Quickbooks Tips and Trick are Recommended:

www.quickbooksgroup.com/webx/qblibrary/Tips/
www.cpa911.com/qbtips.asp
www.quickbooksadvisor.info/sub/15_tips.htm
www.qbalance.com/QuickBooks_Tips_and_advice.htm
www.acctsite.com/quickbooks/qbtips.html
www.jonescpa.com/quickbooks_tips.htm
www.icavts.tec.ok.us/Quick Tips for QuickBooks.pdf
www.acctadv.com/quickbookstips.php
www.jonescpa.com/quickbooks_tips.htm
www.quickbooks-help.com/quickbooks-tips-and-tricks.asp


Wikipedia Definition of Quickbooks:
QuickBooks is an accounting software product developed by Intuit, Inc.

There are several different "flavors" of the software tailored to specific industries; however, the underlying program remains largely the same, the chief differences being industry customized pre-built reports, industry appropriate language (clients vs. customers, etc), and industry appropriate templates for invoices, P.O.'s, and estimates.

First launched in early 1992, QuickBooks quickly took hold as the market leader in small business accounting software. The software was popular amongst small business owners who had no formal accounting training. At the time, software packages were designed for use by accountants and cost $400 or more.

Today QuickBooks still has the largest market share of accounting products for small businesses in the United States. Small businesses use it to track expenses, prepare and send invoices, prepare financial statements, track inventory levels, and many other tasks. It is available in a range of versions, from those suitable to startup businesses up to larger businesses with up to 20 simultaneous users. It also comes in customized versions for different industries such as contracting, professional services, manufacturing, and wholesale. It is available as desktop software or a hosted online edition.

For most tasks, QuickBooks doesn't require its users to understand double-entry book-keeping or standard accounting procedures. Most transactions are recorded using on-line screens that closely resemble paper based forms such as invoices or checks. The system is readily adaptable to many different industries where there is no significant need for something industry specific.

Sage Software's Simply Accounting and Peachtree Accounting are competitors to QuickBooks. Microsoft's Small Business Accounting has also recently entered the market with limited success in its first year.

QuickBooks is also available as software as a service, which Intuit calls QuickBooks Online Edition. The user pays a monthly subscription fee rather than an upfront fee and accesses the software exclusively through secure logon via a web browser. QuickBooks Online requires an ActiveX control that operates only with the Windows operating system. Intuit hosts all of the user's data, and provides patches and regularly upgrades the software automatically.

On June 2007 Intuit announced that Quickbooks Enterprise Solutions would run on Linux servers, whereas previously it required a Windows server to run.

Tags: quickbooks, quickbooks tips, quickbooks tricks, quickbooks tips and tricks

Read More..

What's New (Latest Features) In MYOB 17

• Receive items without a supplier's bill using the Receive Items feature
  

receive items feature

• Synchronise your Accounting cards with Outlook
• Combine duplicate or similar accounts into a single account record
• Combine duplicate or similar cards into a single card record
• If you want to undo your last bank reconciliation
• Improvements in creating budgets
• Additions and improvements to the Company Data Auditor
• You can now save changes to a recurring transaction when you record it

All the latest features of MYOB Accounting:

Accounts:
Combine duplicate or similar accounts into a single account record
Improvements in creating budgets.
Banking:
If you want to undo your last bank reconciliation
Budgets:
Improvements in creating budgets
Cards:
Synchronise your Accounting cards with Outlook
Combine duplicate or similar cards into a single card record
Company Data Auditor:
Additions and improvements to the Company Data Auditor
New report: Deposit Transaction
New report: Tax Code Reconciliation Exception
You can now preview reports before printing them from the Company Data Auditor
Company File:
When you start a new financial year, keep or purge transactions
Importing and exporting:
Identify which records you want to import
Import and export inventory adjustments
Inventory:
Receive items without a supplier's bill using the Receive Items feature
Automatically enter the Last Purchase Price for an item or the Standard Cost of an item when entering purchases
The Item Information windows store additional information about your items
Import and export inventory adjustments
Jobs:
Allocation Memo field is displayed for more transactions on two job reports
Linked Accounts:
New report: Linked Accounts
OfficeLink:
A Credit Application Form is available for sending personalised letters
Preferences:
Automatically enter the Last Purchase Price for an item or the Standard Cost of an item when entering purchases
Purchases:
Receive items without a supplier's bill using the Receive Items feature
Automatically enter the Last Purchase Price for an item or the Standard Cost of an item when entering purchases
Automatically enter sales order or sales quote line items on a purchase order
New report: Deposit Transaction
New report: Payables with Tax
View only sales or only purchases in the Prepaid Transactions report
Combine duplicate or similar cards into a single card record
Reconciliation:
If you want to undo your last bank reconciliation
Recurring transactions
Create a copy of a recurring transaction for more than one card
You can now save changes to a recurring transaction when you record it
Record pre-dated transactions when you create a recurring transaction
Search the Recurring Transactions List by transaction name, transaction amount or due date
Reports:
New report: Deposit Transaction
New report: Linked Accounts
New report: Payables with Tax
New report: Receivables with Tax
New report: Tax Code Reconciliation Exception
Select the default code used in the Tax Code Exceptions [Invoice Transactions] report
View only sales or only purchases in the Prepaid Transactions report
Allocation Memo field is displayed for more transactions on two job reports
Sales:
Identify which records you want to import
Automatically enter sales order or sales quote line items on a purchase order
View only sales or only purchases in the Prepaid Transactions report
Select a posting date for To Do List transactions
New report: Deposit Transaction
New report: Receivables with Tax
Start a New Financial Year:
When you start a new financial year, keep or purge transactions
To Do Lists:
Select a posting date for To Do List transactions

Read More..

Peachtree Accounting: Cara Praktis dan Lengkap

Bagi yang sedang mencari referensi buku Peachtree Accounting terbaru anda bisa pilih alternatif buku berikut:
"Cara Praktis dan Lengkap Peachtree Accounting", karangan Wiratna Sujarweni.
Buku ini cukup mudah dipahami dan langsung dapat dipraktikan karena disertai kasus-kasus baik perusahaan jasa, dagang maupun manufaktur. Pembaca akan dituntun secara rinci untuk menghasilan laporan keuangan di berbagai jenis perusahaan tersebut.
Kebetulan saya juga ikut memberikan masukan dalam pembuatan buku ini.

Buku ini cukup menjadi pelepas dahaga peminat Peachtree Accounting, karena sangat jarang buku-buku serupa yang berbahasa Indonesia.
Walaupun cukup lengkap buku ini harganya cukup terjangkau, hanya Rp. 34.000
So .. jangan sampai ketinggalan.

note: bagi yang kesulitan mendapatkan buku ini dapat pesan melalui saya via e-mail.
(butzajogja[at]yahoo.com)

Read More..

WANTED! Indonesian free accounting software : Cari Software Akuntansi Murah Berbahasa Indonesia, Kalau Bisa Gratis :) Tapi Berkualitas

Cari Software Akuntansi Murah Berbahasa Indonesia, Kalau Bisa Gratis :) Tapi Berkualitas! Ada nggak ya?
Judul saya tadi mungkin mewakili para pencari software akuntansi di Indonesia atau paling tidak saya sendiri. Murah dalam asumsi saya dibawah Rp. 100.000. Berkualitas artinya feature-nya cukup lengkap tidak hanya 'general ledger', tapi mencakup purchase, ,sales, payment hingga export data ke excel.

Saya coba ubek-ubek di Internet dengan google dan yahoo. Susah juga ternyata. Kalau yang berbahasa Inggris sih banyak, gimana yang berbahasa Indonesia?
Ada yang bisa membantu?


tags: free accounting software

Related Post:
Choose Your Real Free Accounting Software

Read More..

Exercise (tutorial) MYOB Accounting: Receive Money, Spend Money

Let's assume you want to record the deposit of $10,000 cash in the business bank account to fund the initial activities of the company.

• Go to the Banking command centre and click Receive Money window appears.
• Click the Deposit to Account radio button. Cheque Account appears automatically in the adjacent field.
• Type date (x/x/xx) in the Date field and pres Tab.
• The Payor field is where you can record the writer of the cheque. However, leave it blank in this example.
• Tab to the Amount Received field and enter $10,000 (simply enter 10000 and the amount will be formatte correctly).
• Tab to the Payment Method field and type Cash.
• Tab to the Memo field and type Initial funding of the company
• Tab to the Account Name column. Here you specify an account that can explain the increase in the bank account selected at the top of the window. In accounting terms, you are increasing equity or your share of the business; therefore, the appropriate account to use would be the capital account.
• Click the seach icon. The select from list window appears.
• Double-click the equity account.
• Tab to the Amount column. the ammount of $10,000 appears automatically.
  
• Click Recod. The entry is saved and the windows cleared.
• Click Cancel to return to the Banking command centre.

Congratulations! You have just completed the first entry in this tutorial.

Related Posts:

• how to reconcile your bank account in MYOB
• spending and receive money in myob

Read More..

Spending and Receive Money In MYOB Accounting

It's simple to track money you spend and receive in your MYOB Accounting software. The Spend Money and Receive Money functions can be found in the Banking command centre. You can use the Spend Money window to record payments for purchase or expenses you won't be entering purchase orders for (using the Purchase command centre), such as postage, rent and owner drawings.

You can use the Receive Money window to record interest or record the miscellaneous cash receipts you receive. To ensure you have accurately entered your transactions, you can reconcile MYOB's accounts with your bank statement using the Recouncile Accounts function also found in the Banking command centre.

Related Posts:

• exercise tutorial myob accounting
• how to reconcile your bank account in MYOB

Read More..

Accounting Best Practices: Book Reviews

Book Description:
Praise for Accounting Best Practices, Fifth Edition

"For a comprehensive, yet easy-to-read guide to fixing those all-too-common shortcomings in your accounting department, look no further than this excellent book. Steve Bragg provides hundreds of fixes, many of them requiring surprisingly little time or cost while providing a handy guide to common implementation pitfalls . . . I would recommend this invaluable book to anyone who is looking to enhance their existing processes, whether due to growth in their business, compliance with Sarbanes-Oxley, or just as part of their ongoing improvement process."
—Martyn Webster, CPA, Director of FinanceXenoPort, Inc.

"This book is critical to running an efficient and accurate accounting department. The use of RFID technology to track documents is one of many valuable tools in this latest edition. A required read for the demanding accounting manager's role."
—Jason Charet, CPA

"I've used Steve Bragg's Accounting Best Practices books for years as a source of ideas for improvement. Like the previous editions, the Fifth Edition has a number of new, actionable best practices as well as refinements of those ideas reported in previous editions. The books are broad enough in their perspective so that nearly any organization could find ideas that could pay back the cost of the book many times over."
—John Temmerman, Controller Evangelical Lutheran Church in America

"What a great resource! I have been in the accounting field for over twenty years, and I was still able to gain insight into improving processes within my office. Thanks for putting it all in one book!"
—Tina M. Thomas, CPA, CTP, Controller Goodman & Company, LLP

Book Info
Provides the most advanced techniques and strategies available today to help your business cut costs and improve accounting operations-regardless of your company's size or holdings. DLC: Accounting. --This text refers to an out of print or unavailable edition of this title.


Praise for Accounting Best Practices
Price: $75.00
Buy

Read More..

Easy-to-use Bookkeeping Software for Small Businesses with Microsoft Excel

When it comes to choosing accounting software, this aspect is often overlooked, but it's one that's extremely important to take into account. No matter how great the software or how inexpensive, if it’s too cumbersome or hard to learn, you won’t use it. So don’t go overboard by purchasing a package that offers extra things your company doesn’t really need. Keep it simple, stay focused on your business's needs, and look for those programs that have easy interfaces.

Big E-Z Monthly Bookkeeping for Microsoft Excel

Product Features:

• Easy-to-use bookkeeping software for small businesses
• Tracks and categorizes monthly income and expenses
• Reconciles checkbook; determines profits; ideal for non-bookkeepers
• Customizable Excel spreadsheet templates with built-in formulas
• Printable forms and instruction manual (PDF) with helpful tips

Price: $29.95
Buy

Read More..