Should I Start a New QuickBooks Company File?

Quite often prospective clients call and say that there are so many errors in their QuickBooks Data file that they are thinking about starting the New Year with a new company file.  I discourage creating a new company file for the following reasons:

Using the Accountant Toolbox, company files can be quickly cleaned up or the general ledger balances can be corrected as of a given date.

If you create a new file you will need to maintain two files to access historical data and you may lose all your settings, memorized reports, templates, bank feed rules, etc.

Re-creating a company file with all the lists (Chart of Accounts, Customers, Vendors, Items, Terms, Unit of Measure, etc.) and open items (Estimates, Sales Orders, Open Invoices, Purchase Orders, Bills, etc.) can be daunting and prone to errors.

Please think twice before starting a new company file for an existing business that is currently using QuickBooks!

QuickBooks Webinar Schedule

Ilene Eisen has scheduled webinars to be broadcast from May 2015 – December 2015.

Each webinar is two hours and will qualify for Continuing Professional Education (CPE).  All webinars will be scheduled at either 1 PM Eastern or 4 PM Eastern

The webinars will include

  • QB15 – QuickBooks 2015:New Features that Improve Reports & Save Time
  • QBBK – QuickBooks: Saving Time with Bank Feeds
  • QBBS – QuickBooks: Systematic Approach to Reconcile Balance Sheet Accounts
  • QBCR – QuickBooks: Customized Reports – Getting Information You Need Quickly
  • QBDR – QuickBooks: Client Data Review- Tools to Easily Correct Errors
  • QBES – QuickBooks: Getting the Most Out of Enterprise Solutions
  • QBIC – QuickBooks: Improving Security and Internal Controls
  • QBTK – QuickBooks: Tips & Tricks for Accountants
  • QBIN – QuickBooks: Inventory Fundamentals to Improve Efficiency and Reporting

Dates are listed on the ie-Solutions website https://ie-solutions.biz/seminars-and-webinars/

Ilene Eisen to Speak at Inuit Virtual Conference

Ilene will be speaking that the Intuit Virtual Conference , Wednesday December 10, 2014  she will be presenting:

QuickBooks Desktop Accountant: Your Friend at Year End (Part 1 of 2)

This course has been designed to introduce the accounting professional to strategies for working with your clients’ QuickBooks company files at month‐end or year‐end. It provides an overview of  the tools and features that streamline the process of evaluating and correcting your client’s QuickBooks data as well as those tools and features that enable you to work efficiently and directly with your client on month‐end and year‐end accounting processes & financial reporting. These tools are available with your QuickBooks Accountant Desktop Plus 2015 subscription or QuickBooks Accountant Desktop 2015 software, and QuickBooks Enterprise Accountant 15.0 software

QuickBooks Desktop Accountant: Your Friend at Year End (Part 2 of 2)

Your clients’ QuickBooks data is seldom clean enough or complete enough for you to use when preparing their year‐end financial statements and / or income tax returns. In this session, we will “walk through the Balance Sheet” using the tools and features covered in the previous session (QuickBooks Desktop Accountant: Your Friend at Year End ‐ Part 1) to quickly find AND correct mistakes, allowing you to confidently use the QuickBooks trial balance to prepare your clients’ returns. You will also learn proactive steps you can take with your clients to keep their data accurate throughout the year – to streamline both income tax return preparation and periodic financial statement preparation.

 

My Virtual Office

This month I moved out of the office space I had rented for the last 8 years!  In the last year I have worked from the office, hotel rooms, airport lounges, my kitchen table, and anywhere else with an internet connection when I had to get work done.  I found that the only advantage to being in my office was multiple monitors!  For efficiency over the years I have moved more services and data to the “cloud” and this has significantly reduced my costs and increased flexibility!

Remote Access Software – This service allows me to log in with clients to work remotely on their desktop for training and problem resolution.

Webinar Software – This software gives me the ability to present webinars to large groups of people regardless of location.

Voicemail – This online service sends me an e-mail with my messages included in a sound file and a transcribed conversation that I can read easily.

QuickBooks – This software lets me e-mail invoices and estimates and the merchant services link allows customers to pay their invoices online.

Office 365 – This subscription gives me full Microsoft functionality anywhere any place. I also store my files using the SharePoint which is included in the service and synchronize the files with my desktop and laptop so I have all my files with or without an internet connection.

Internet Fax Service – This service accepts my faxes and sends me an e-mail with an attached PDF of the fax.

These services and software also allow me to more responsive and flexible to client needs.  They have also made my business more convenient for my clients.

 

 

Tax Time Resolutions

Once again we’ve seen another tax deadline come and go!  Each year preparing the books and records for the tax preparer is a task that takes time and energy from things that we would prefer to do.  For many it’s also a learning experience to see what your annual profits actually were.  Wouldn’t it be nice to know how you are doing during the year so you could make adjustments and increase your revenue?

Now is the time to talk to your tax preparer and accounting staff about your recordkeeping practices.  I have found that additional training and/or upgrading bookkeeping practices usually saves considerable time and increases the accuracy and timeliness of your records.

Accounting Software Formats

Many firms are looking to upgrade or replace their accounting software.  They look forward to a more efficient system but are concerned about making such a large change and the consequences of making the wrong decision.  In the past we looked at fairly similar features and the higher the price the better the software we found.  Today all bets are off and it’s hard to even compare prices of possible solutions. 

The accounting software ecosystem has changed and there are terms that we may not be familiar with or we may not completely understand.  In this article, I’d like to discuss the options:  cloud applications, hosted software, client-server software, and desktop software.  All of these options are very different and the option you choose will significantly affect your access, functionality, workflow, and costs.

Cloud Applications are programs that reside on the software provider’s servers and they are installed and updated by the provider.  You will not need to maintain servers or take daily backups, examples of such applications are QuickBooks Online, NetSuite,and  Xero. 

Hosted Applications are not really a program but a hybrid solution where you select an accounting solution that meets your needs and it is installed on a server provided by a “hosting” company.  This option allows you to choose a software package that meets all your needs without having to maintain a server and the necessary IT staff. 

Client Server Applications are programs that reside on your server and are accessed from various workstations.  The computing is performed at the server and therefore is faster and does not require as robust workstations.  

Desktop Applications are programs that vary from very basic to advanced software that reside on your workstation/computer,  These applications can be single user or accessed by other users on your network. The computing is performed at your computer and will be dependent upon the speed of your computer (and network if shared with other users) Examples of such applications are QuickBooks, and Peachtree. 

I hope this summary has helped you understand the Accounting Software options and will help you narrow down an appropriate software for your business.  

 

What is the best QuickBooks Program for Managing MY Inventory?

Many clients have inventory and struggle with how to manage the inventory effectively and easily.  Although QuickBooks does have inventory functionality in QuickBooks Pro/Premier and Enterprise, there are various add-on solutions that are also be helpful for your specific needs.  To determine the correct version and add-ons I’ve created the summary below. Retail businesses should also review the Point of Sale section. 

Quick Books Pro

Inventory functionality is very basic.

  1.  Inventory features are designed for businesses that buys and sells the same items over and over again (ie Antique Shops buy and sell different items).
  2. These businesses do not assemble items or repackage them and only have one location.

QuickBooks Premier

Inventory functionality of QuickBooks Pro and

  1. Ability to assemble items (remove raw materials from inventory and replace with finished goods or repackage in smaller quantities.)
  2. Create Sales Orders to manage partial shipments of goods and manage unfulfilled orders

QuickBooks Enterprise Solutions

Inventory functionality of QuickBooks Premier and

  1. Ability to use custom fields in transaction to configure orders
  2. Ability to add-on Advanced Inventory (annual fee)
    1. Use Multiple Inventory Locations
    2. Track Lot and Serial Numbers
    3. Bar Code Tracking

QuickBooks Point of Sale (POS)

This is a separate program that integrates with the other QuickBooks programs mentioned but is designed to work in a retail environment and function as a cash register.   

  1. Ability to run daily cash register reports.
  2. Ability to track individual cashiers
  3. Bar Code Tracking
  4. Multi-Store ability
  5. Styles view to see inventory availably by 2 designated features (i.e. size, color)

Printing 1099 Forms from QuickBooks Company Files

One of the tasks that many businesses struggle with in January is issuing 1099s and completing the reports.  I advise my clients to use the QuickBooks procedure for creating 1099’s rather than the timely and costly option of sending the information to an outside service to prepare the reports.   Many clients actually work with a tax preparer the first time to set-up the company file for 1099s, which is a great idea and allows you to learn the process for the next year. Here’s a short summary of the process you’ll need to follow to process your 1099’s and 1096:

Select Vendors from the top menu – Select Print /E-File 1099 – Select 1099 Wizard

You will see a listing of the activities that you will be guided thru in order to complete the task – Select the Get Started button.

Step 1 Select your 1099 Vendors – Vendors are subject to receiving a 1099 if they meet the income and statutory requirements based on business entity.  In this step we will only consider the statutory requirements based on business entity. 

Select all vendors that qualify for 1099s. Do not consider the vendor income requirements at this point, just select individuals, sole proprietors, partnerships, and anyone else who qualifies for a 1099 reporting. If you are not familiar with the requirements, check with your Tax Preparer for more information.  When you are done select Continue.

Step 2 Verify your 1099 Vendor’s Information –You will need the address and tax ID number for each 1099 vendor who will receive a 1099.  To save time, skip this step for now and we’ll complete the process in Step 4. Select continue and we will go back to complete this process later.

Step 3 Map Vendor Payment Accounts –Not all payments to vendors will qualify for 1099s, usually accounts that qualify are Cost of Goods Sold, Expense, and Other Expense accounts and most payments will be entered on Box 7. You should consult your tax preparer if you are not sure about reporting requirements.

 Step 4 Review Payments for Exclusions – This step gives you the opportunity to review both payments included and payments excluded based on the criteria defined in the previous steps.  Also QuickBooks will exclude all payments made by credit/debit cards, gift cards or PayPal in accordance with the IRS requirements. View both reports to verify that you have completed the set-up properly. When done select Continue.

Step 5 Confirm Entries – This step gives you the opportunity to confirm entries and on this screen you will see who needs additional information such as a Social Security number or Federal ID.  I usually wait until I get to this screen to research tax ID and addresses.  Any Vendors with incomplete information, can be edited in the vendor record.  If after calling a vendor you are informed that they do not meet the requirement for a 1099. Uncheck the 1099 vendor box in their vendor record or on Screen 1 of the wizard. You can now print the 1099 and 1096 forms, if you are not confident in the process ask your tax preparer to review your work.  When done, select Continue

Step 6 Choose Filing gives you the opportunity to print forms or e-file.  Please note that if you print forms you can reprint specific vendors or all forms at any time without changing your settings in Step 2.

Making the Most of Next Year!

Grow your business next year by making wise choices based on timely and accurate information!  This information is often at your fingertips and many clients don’t take advantage of this valuable resource. 

Each year I get many calls asking me to help companies gather their data and correct their records so they can submit them to their tax preparer for use in processing their tax return.  These clients tend to view their accounting system a recordkeeping device for tax preparation and forget the advantages of using their records to help make intelligent management decisions on a timely basis.  When you wait until after year end to enter transactions you’ve lost the ability to use the information timely for management purposes and you are more likely to have errors and omissions in your records.

My advice to you is to record transactions timely and use the reports and dashboards that your accounting system provides to you!

If your accounting system does not meet your information needs you may need more training or you may need to upgrade your software.  Now is the time to determine if you have a training issue or you need to upgrade.  If you need to Upgrade, I suggest contacting your tax preparer for advice, referrals, and/or assistance so you can start the New Year getting information that will help you manage your business.

Have a prosperous and healthy New Year and if there is anything I can do to help you please contact me at Ilene.eisen@ie-solutions.biz

Should I Process My Own Payroll or Use a Payroll Service?

The best time to change payroll processing is at the beginning of the year.  Therefore it’s time to look at your payroll processing and determine if it meets your needs.

The first question is, to determine if you want to be responsible for preparing your payroll returns and paying tax payments…

  • I would suggest that only organizations with a full time Payroll or Hunan Resource specialist take on this responsibility since the fines and penalties can be substantial, if errors are made or deadlines missed.

The second question is, if you outsource your payroll, how do you choose a payroll processor or service?

  • If you are a small business and do not use accounting software, check with your Tax Preparer to see who they recommend or if they provide this service.
  • If your accounting software processes payroll ask if the accounting software company also offers full service payroll that will integrate with your software and post the payroll to your records saving you time and increasing efficiently, while handling the regulatory duties of filing payroll returns and making tax deposits.
    • Many large software vendors now provide full service options such as Intuit and Sage.
  • If you need job costing and/or you are billing customers for time it’s important to get a processor who will integrate with your accounting software.  Keep in mind that the best integration will be provided by the publisher of your accounting software as mentioned above.
  • If you need advanced Human Resources features you will probably be happier with a national payroll processor that has these options.

When making payroll decisions it’s always a good idea to check with your CPA and software consultant for additional information and insight on the issue.