Friday, May 28, 2010

It's been awhile.....

Sorry I have been doing so many other things I have not had time to sit down and write a post.  I have been publishing though, but on the work website. 

I was part of a collaboration that wrote about Credit Card Security.  It seems that Peachtree is beefing up to meet the Payment Card Industry Digital Security rules,  this turned me on to the subject which lead to the article.

Here is a link Komisar Brady & Co.

If you need a review of your systems or just want to get more out of your accounting programs, give me a try, you may be suprised at the results.  dchermak@komisarbrady.com.

Wednesday, March 3, 2010

QuickBooks vs Peachtree

Wow!  I have not posted in about two months.  Sorry about that, tax season makes it hard to write.

One of the hottest questions out there, and believe me I am asked it all of the time, is what is better; QuickBooks or Peachtree?




The answer is; it depends.



On your business.

On your time.

Who is going to do the bookkeeping.

What your accountant may work with.



There is a lot that goes into selecting the right product for you. I help business owners on a daily basis with this selection. I do this by asking questions and determining what product fits best with how and why they are doing business. Still the question remains, which is better. Let’s take a look at what each offers and you can decide for yourself.



QuickBooks



By far QuickBooks is the more widely used of the two programs. This is just my opinion, but I feel that Intuit has done a better job of getting the message out to the small business owner. At one time Intuit the makers of QuickBooks advertised that QuickBooks is as “simple as balancing a checkbook” , or something along those lines. The message got through and many small businesses now use QuickBooks.



QuickBooks is good in that it provides the user lots of help. Help setting up the company, help selecting a chart of accounts, help getting transactions in place. The menus are fairly easy to understand and the user has the option of selecting picture icons of what they want to do. The pictures generally depict what you may have in mind such as making a deposit, writing a check, etc. All of this is available on the main screen for easy access.



The centers, such as the Customer Center or Vendor Center give the user a central location for adding and transacting with the customer or vendor. There is also an employee center for your employees, but some of the features in the employee’s center requires a subscription. This grouping of functions helps with directing the user to all that is available with their QuickBooks.



Where QuickBooks excels is with its use of forms. The forms are fairly easy to understand, a check looks like a check and so on. Where many get confused is assigning things to accounts. For example, if you are paying a utility bill, obviously you write a check but then you must assign the cost to your utilities account in the form below the check form. You can also add notes explaining the charge for later use. Once the item is entered the first time, QuickBooks memorizes what you did, so the next time the information is there, except the notes and amounts, that you will need to add, but it makes the process easy as you go along.



QuickBooks also has a lot of add ons so you can get more out of your program. QuickBooks has add ons of its own such as the Point of Sale and quite a bit of third party add ons like the inventory control program Fishbowl.



For the small business owner who is going to do their own books, QuickBooks gives the ease and flexibility you may be looking for.



What is not so good about QuickBooks



QuickBooks is a bit open with how you can add transactions. For example, if voiding a check the void reverts back to the original date the check was written. This can create havoc with monthly reporting, especially when you have reported information to your lender and now the information is different when you report again.



The database is a bit difficult to work with. In order to affect changes to the database you need a series of templates to direct QuickBooks as to what you want to do. This can be time consuming especially when you are trying to fix a portion of the data. This would affect only a small portion of users, so as a problem it is a minor one. QuickBooks 2010 did improve on interaction with Excel by allowing for the use of bulk lists for adding customers and vendors.



Although you don’t need to, QuickBooks upgrades every year. This seems to be a push to continually glean cash from the customer. I personally recommend only upgrading when your version is no longer supported by Intuit. In some cases, a new feature comes out in QuickBooks which makes it worthwhile to upgrade sooner. Again, you need to weigh cost against need.



Peachtree



Peachtree comes in a close second to small business use. Peachtree like QuickBooks has a wonderful user interface. Peachtree does, however, use more of an accounting function such as period segmentation which takes a bit of getting used to.



The period segmentation is one of the better features that Peachtree has. The need to change accounting periods (months) forces the user to stop and evaluate what needs to be done for the month end. Activities such as reconciliations need to be done in the period that the reconciliation represents. Peachtree does allow the user to make transactions in periods other than the current one, but the user is warned that the transaction is in another period. This can be valuable for preventing mistakes.



Peachtree works in centers, just like QuickBooks which allows the user to do everything they need to do for customers, vendors, and employees. The reporting function in Peachtree is also very nice; however, it does take time to learn how to modify reports to your needs as the reporting is more structured.



Peachtree’s user forms are easy to use, and the way they are set up allows the user to easily follow along when making entries. Peachtree will also memorize what you have done with a customer or vendor and pull that information the next time you make an entry. This is a time saver.



What is not so good about Peachtree



The one thing that I find perplexing with Peachtree is its bill pay function. When you enter bills in QuickBooks, the bill pay will pull up a list of bills and when they are due. All you need to do is select the bills you want to pay and set up to print the checks. Peachtree requires you to select the vendor first and then see what is due. 5/28/2010 thanks to a diligent reader and some training I was doing on Peachtree, you can select multiple bills to pay.  Just use the Select Bills function to be directed to pay multiple bills. You can always print a report of items due and then drill into the report to pay the items, but sometimes it would be easier to just be able to see a list of items due. This falls into Peachtree’s roots. It used to be that accounts payable would keep the paper copies of bills due sorted by the date they should be paid. On that day, the accountant would take the bills and work through them to pay them. Peachtree is set up to work using that method. As we work towards a paperless office, the need for a list of items due has become more important.



Peachtree also has upgrades every year, but you don’t need to upgrade until Sage, the maker of Peachtree, stops supporting your version.



Peachtree’s database



By far the best feature of Peachtree is its database. It is easy to work with and can be easily exported to Excel, adjusted and then imported. Because of its ease of use an accountant can send adjusting entries to their client via an e-mail with the Excel export ready to import into the clients Peachtree. This ability gives Peachtree the edge when working with files.



On a final note, Peachtree also has third-party add ons for various needs. The add-ons help to enhance your use of Peachtree. Peachtree however seems to be a more complete package than QuickBooks. Peachtree offers a bit more power to your bookkeeping and handles a lot more within the program. This reduces the need for add ons and allows the user to get more out of an out of the box accounting program.



I really have not discussed costs in my comparison. The main reason is the costs are similar for what you get. It is really a matter of looking at your needs and how you need to utilize your accounting software.



Versions



Both Peachtree and QuickBooks offer various versions for various industries. QuickBooks however also offers an online version of their program. This gives the ability to sign in wherever you have web access and work on your books. Recently QuickBooks has made some nice modifications to the online program and the user interface is almost like that as the desktop version. One limitation is the QuickBooks online does not handle inventory very well and it does not have the ability to make Purchase Orders. As Intuit is adding new features to the online version all of the time I am sure that these limitations will be addressed soon.



Peachtree at this time does not have an online version.



If you want a taste of what each program can do, both companies offer a free version of their programs. Peachtree offers a great free version that is essentially a basic version of its regular program but it does not allow for inventory. QuickBooks free version is desktop only. The desktop version is limited by the number of customers you can have and does not allow for inventory.



With the free versions you can compare for yourself. Ultimately the choice is up to you.



If you need help with choosing a product or would like help setting up your business’s accounting software, I can help! Contact David Chermak at dchermak@komisarbrady.com.

Sunday, January 3, 2010

Peachtree Toolbox: The Year End Wizard


As you approach the end of your fiscal year, you may receive a prompt asking if you would like to use the Year-End Wizard. This is because Peachtree only allows for two years to remain “open” at any given time. If you are in period 24, you will have to close the accounting year in order to enter transactions next year. Generally, that means you are closing 2008. You should not be closing the current year or that will permanently prevent access to certain data.


Before starting the Year-End Wizard

Before you launch the wizard, there are a number of tasks you should perform. These include printing out any unprinted items such as invoices and payroll checks. You will also need to clear the Waiting on Bill from Vendor check box in the Purchases/Receive Inventory window for any outstanding vendor purchases. If you start the wizard before performing this task, the wizard will not be able to proceed. You will have to exit the wizard and clear the check box before you can complete year-end close.

Note: Since the close process may take quite a while to complete, we recommend that you start the process at the end of your business day, making sure you leave the computer running. Also, make sure that all other applications are closed before you begin.

The Year-End Wizard

The Year-End Wizard guides you through the process. It requires that you make a backup, and we recommend that you uniquely name the backup and consider putting it on removable media (CD, memory stick, external memory, etc.) for future reference. You are also prompted to run year-end reports, which you can do on paper or save/export to Excel or to a readable file if you wish. We maintain copies of all reports needed to prepare your financial statements and income tax returns; however, we recommend you retain a backup file of your Peachtree data for 7 years. Additionally, we recommend you save a PDF copy of the following reports for 7 years:

• General Ledger for the year you are closing

• Under general ledger, General Journal for the year you are closing

• Under accounts payable, Check Register for the year you are closing

• Under accounts receivable, Cash Receipts Journal for the year you are closing

• Under payroll, Payroll Journal for the year you are closing



You only need to save these reports if you have data in the specific areas.



The procedure of closing a year also allows you to purge inactive accounts or customers/vendors. This will decrease the size of your data file, and remove some of the clutter that may be in your records. We recommend purging certain old data, but you are not required to do so during the year-end close process.



To begin the process, go to TASKS / SYSTEM / YEAR END WIZARD to walk through the closing process. If you would like to purge inactive accounts prior to the closing, go to TASKS / SYSTEM / PURGE WIZARD and follow the prompts.



If you have any questions concerning the Year End Closing or your Peachtree data file, feel free to e-mail David Chermak at dchermak@komisarbrady.com.

Top 50 Accounting Blog Second Year in a Row!!

Nothing is more thrilling than having your work recognized. Especially when it is unsolicited and unexpected.




For the second year in a row, my blog has been recognized by the Online Accounting Colleges review of the Top 50 Blogs for Accountants.



This year was a bit different as Accounting World News Headlines picked up the information and provided it to their readers.



I guess I better get cracking on some great articles.



I am currently working on sharing my insights with converting data back and forth between Peachtree versions. This may come in handy for many of you who work with Peachtree on an ongoing basis.



Thanks for using my site for information and education.





Happy New Year!

Thursday, December 24, 2009

Peachtree Toolbox: A preview of backwards compatiblity and converting

Once in awhile I get asked if Peachtree is backwards compatible or convertible to a smaller version. Generally this comes up when we at the office have converted a file for our use and the Accountant later realizes that they need to update the clients file and we were not instructed to keep the same version as the clients to assure that we can add our changes to the file.




I have a lot of experiences of working with a variety of databases, I have even created a few. Now I am not going to sit around and toot my own horn, I just wanted to give a bit of background on how I arrived at being able to move data back to older versions of Peachtree and even smaller versions as well.



The key to being able to move data back and forth is Peachtree’s Import and Export feature. I have stated in earlier posts that Peachtree's database is by far the best of the small business accounting software. The import and export function allows you to work with the data in Excel and make adjustments as needed.



What you would need to do to accomplish this task is both copies of Peachtree, Excel, and the knowledge of how to do this.



The import and export function is found under file and Select Import/Export. You also need to know what you want to import and export.  The reason you need both copies of Peachtree is so you may map what fields that are involved and make sure that you only transfer the fields that are needed. Once you have established the fields needed you can set your export with the fields you need and import the same.



This is just an overview and a hint of things to come. I will cover this feature in more detail in a future post. In the meantime,



Happy Holiday’s and Merry Christmas.

Tuesday, December 15, 2009

QuickBooks ToolBox: Important information about QuickBooks 2009

I received the following information from Intuit this morning and wanted to ensure you were aware of it.


A couple of notes as you read the information below:

1. To determine if you have R9 installed on your 2009 QuickBooks, tap the F2 key on your keyboard and look at the very first line - it will show you what "release" or "R" you have installed.

2. QuickBooks has set up a special web page to deal with these issues.

Dear QuickBooks 2009 User:

Sales Tax Report Issue for QuickBooks 2009 Release 9 (R9) Users

We are writing to let you know about a Sales Tax Report issue related to the December 1, 2009 Release 9 (R9) of QuickBooks 2009. If you downloaded R9 earlier this month, the Sales Tax Liability and Sales Tax Revenue reports are not displaying the correct data in some cases. Only customers who have already downloaded and installed R9 may be affected. The issue affects QuickBooks Simple Start, Pro, Premier, and Enterprise Solutions.

If you are using Release 8 or earlier, this issue will not affect you, and you may continue to rely on the Sales Tax Liability and Sales Tax Revenue reports for any sales tax filings with tax authorities. (Not sure which release version you have? Open QuickBooks, hit F2, and look at the information in the upper left of the screen entitled, "Product.") Click here for more detailed instructions.

What You Should Do if You Are on R9

If you are currently using R9, and have not filled out your tax information with tax authorities, you should update your QuickBooks software before you file. The new update (Release 10) is scheduled to be available on Wednesday, December 16. Only after updating to R10 should you rely on the Sales Tax Liability and Sales Tax Revenue reports for your upcoming sales tax filings with tax authorities.

If you are currently using R9 have have used the Sales Tax Liability and Sales Tax Revenue reports to submit information to the tax authorities this month, your submission may be incorrect. As a result, you may need to resubmit your sales tax information after downloading R10 if you meet certain criteria. Specifically, this issue applies to you only if you meet the following conditions: within QuickBooks, the sum total of items in your Items List multiplied by the number of vendors in your Vendor List equals more than 10,000. For more information on whether you need to resubmit your sales tax information, click here. If you think you have already submitted inaccurate information to to tax authorities and need help with how to resubmit, you can contact Intuit at QuickbooksEmail@intuit.com.

How to Update to R10

Updating QuickBooks with R10 will correct your sales tax information in the Sales Tax Liability and Sales Tax Revenue reports. You can apply this R10 update in two ways:

• You can download this update here, Wednesday, December 16, 2009.

- or -

• QuickBooks will prompt you to apply this update automatically on Thursday, December 17, 2009.

Thank you very much, and we apologize for any inconvenience you may have experienced.

If you need help with your QuickBooks, Peachtree, or Accounting Software contact dchermak@komisarbrady.com.

Sunday, December 6, 2009

QuickBooks ToolBox: CRITICAL information about QuickBooks 2009 Update R9 -- Please read

Several people are having problems -- especially in a multi-user setting. The link below should help. If you are on a network you will need to update your network QuickBooks as well.


From the Intuit Community:

QuickBooks 2009 Release 9 differs from most releases. Because of the changes it makes, R9 is not backwards compatible with earlier releases of QuickBooks 2009.

Therefore you need to treat it the same way you treat an upgrade to a new year version. That is, both your program and data files will need to be updated.

Read more about the R9 update here.

http://support.quickbooks.intuit.com/support/pages/knowledgebasearticle/898625

David Chermak provides support for QuickBooks and Peachtree to the staff and clients of Komisar Brady & Co. He has expertise in both products and can help you with getting the most out of your accounting software. David can be reached at dchermak@komisarbrady.com.