RhondaRhonda Rosand, CPA received her designation as an Advanced QuickBooks® ProAdvisor from Intuit, the makers of QuickBooks®, in June of 2012.

In order to be eligible for Advanced Certification, she was required to complete the three (3) most recent, consecutive QuickBooks ProAdvisor certification exams and to pass a rigorous examination testing both accounting and technical expertise.

The QuickBooks Advanced Certification Course is designed to deepen the expertise of ProAdvisors who are already knowledgeable in QuickBooks and distinguish these “QuickBooks experts” as highly proficient in this field.

The Advanced Certification is the highest designation that Intuit offers QuickBooks® experts. Only 11% of Certified QuickBooks® ProAdvisors within a 500 mile radius of the Mount Washington Valley are Advanced Certified.

Advanced Certification entitles her and her clients to increased discounts on QuickBooks software and supplies as well as access to unlimited U.S. – based Diamond level VIP technical support.

Rhonda Rosand, CPA is the owner of New Business Directions. She specializes in QuickBooks consulting and training services, coaching small business owners and providing innovative business solutions.

For more information or to sign up for our Free monthly QuickBooks® Tips and Tricks newsletter, please visit www.newbusinessdirections.com.

I was telling a friend of mine about the topic of this months’ newsletter and he said “you’re the expert in QuickBooks® and you make a living from setting it up and cleaning it up and teaching people how to use it – why in the world would you tell people NOT to use it?”

The answer is simple – QuickBooks® is a really great program, it’s relatively low cost and it works well for most small businesses. However, one size does not fit all. It’s like that suit in the back of your closet. If QuickBooks® doesn’t fit, it won’t work and it won’t get used.

Fortunately, QuickBooks® has many solutions in their product line-up and with our expertise and knowledge we can customize and tailor a program specifically for you and your small business.

Data File Sizes and Transaction Limits

What impacts whether you should use QuickBooks® Pro or Premier or the more powerful version, Enterprise Solutions, is the size of your data file today and how that data is expected to grow over the time period for which you want to keep all transaction data in one (1) company data file.

The rate of growth of QuickBooks® company data files varies significantly from company to company. There is no “average” or “typical” data file size, since businesses track different information. How quickly a file grows depends on the number of transactions, the amount of information entered in each transaction and the number of “links” per transaction.

If your business generates more transactions than QuickBooks® can handle, performance may be affected. Technically, QuickBooks® Pro and Premier can handle two billion transactions in a single company file. In practice, however, tasks like running reports and finding transactions can take longer if the file grows too large.

We recommend that QuickBooks Pro and Premier data files should not exceed 200MB and that Enterprise Solutions files should not exceed 300 MB. These are general guidelines, based on several factors. There are no specific maximum file sizes and your system will not come to a crashing halt if you exceed these recommended sizes, however, as the data file grows, the overall performance of the software declines and the risk of data corruption increases.

To see how large your data file is currently, open your QuickBooks® file and press the F2 key. A Product Information box will appear and your data file size will be listed on the left hand side of the screen under File Information.

Item or List Limitations

QuickBooks® also has item limitations – counts that cannot be exceeded. Companies with list requirements that exceed those in the following table are not a good fit for QuickBooks®. This list highlights some of the more important physical limits and it is not an all-inclusive list. These counts are “combined” counts. For example, in Premier, you can have 14,500 customers, vendors AND items combined, not 14,500 per list.

List NamePro and PremierEnterprise Solutions
Chart of Accounts10,00010,000
Names (customers, vendors, employees and other names)14,500>100,000
Items (including inventory)14,500>100,000
Classes10,00010,000
Price Levels100750

*For an all inclusive list click here

For companies that require a more robust inventory, we recommend using Enterprise Solutions, QuickBooks® Point of Sale or an add-on software such as  Fishbowl.
To find out how many items your data file is currently using, open your QuickBooks® file and press the F2 key. A Product Information box will appear and your List Information will be shown on the right hand side of the screen – be sure to scroll down to see all of the lists.

User Access Limitations

QuickBooks® limits the number of users who can access the company data file simultaneously. Companies that require more users simultaneously accessing the company data file than QuickBooks® supports are not suited for QuickBooks®.

Inventory Method Limitations

Companies that require an inventory method other than average cost (such as FIFO or LIFO) may want to use QuickBooks® with an add-on software for the inventory feature. Note that an exception is QuickBooks® Online Plus – as of mid-2010 it offers Inventory using the FIFO cost method. Another exception is QuickBooks® Enterprise Solutions for 2012 with Advanced Inventory which has a FIFO option as well.

QuickBooks® Product# simultaneous users
Pro3
Premier5
Online Plus5
Enterprise Solutions30
Online25

Summary

Although QuickBooks® works quite well for companies of various sizes and across many industries, there are a few situations in which QuickBooks® may not be the best solution.
If you are interested in finding out more about any of the QuickBooks® line of products or if you would like to discuss what solution is best for your small business, please call us.

This article of QuickBooks Tips and Tricks was based on the 2012 version of QuickBooks.

Rhonda Rosand, CPA completed her certification in QuickBooks® Point of Sale Version 10.0 in May of 2012. This is her second official recognition in Point of Sale as she was previously accredited in Version 8.0.

In order to become a Certified QuickBooks® Point of Sale ProAdvisor, Rhonda was required to be certified in QuickBooks® financial software.

QuickBooks® Point of Sale certification provides training and tools to accounting and technical professionals in order to offer a higher level of expertise and to help retailers set up their software, ensure a smooth transition and run a more successful retail business.

Rhonda Rosand, CPA is the owner of New Business Directions. She specializes in serving small business clients and provides personal service and innovative business solutions.

For more information please visit our website.

If your company has a policy that allows you to give your employees advances on upcoming payroll, you can use QuickBooks® and QuickBooks® Payroll to record the advance, which can then be reimbursed to the company through payroll deductions. We recommend that you document any loans to employees with terms for repayment clearly spelled out and signed by both parties.

Note: This QuickBooks® tip assumes that you have an active QuickBooks® payroll subscription.

First, create an Asset Account to Track the Employee Loan and Repayment

This is a one-time setup task

  • Go to the Lists menu and click Chart of Accounts
  • Click Account at the bottom of the list and then click New
  • Under Other Account Types choose Other Current Asset and then click Continue
  • If you are using account numbers, enter the number in the Numbers field
  • In the Account Name field, enter Employee Advances
  • Click Save & Close

Next, you can either write a regular check (non-payroll) to the Employee for the Advance and post it to the Other Current Asset account Employee Advances or you can pay the Advance through Payroll in which case you will need to create a Payroll Item of the type “addition”.

This is a one-time setup task.

  • Go to the Lists menu and click Payroll Item List
  • Click Payroll Item at the bottom of the list and then click New
  • Select the Custom Setup method and click Next
  • Choose Addition and click Next
  • Enter the name for this addition as Employee Loan
  • Click Next
  • On the Expense Account screen, choose the Other Current Asset account, Employee Advances, that you created in Step 1 for tracking this expense and click Next
  • Select None as the tax tracking type
  • Leave the taxes unchecked and click Next
  • Select Neither in the calculate based on quantity screen and click Next
  • Select Net Pay and click Next
  • Leave the default rate and limit blank and click Finish

Use this addition on the Employee’s paycheck under Other Payroll Items. Enter this amount as a positive number. 

Then, create another Payroll Item of the type “deduction”Again, this is a one-time setup task.

  • Go to the Lists menu and click Payroll Item List
  • Click Payroll Item at the bottom of the list and then click New
  • Select the Custom Setup method and click Next
  • Choose Deduction and click Next
  • Enter the name for this deduction as Loan Repayment and click Next
  • Leave the first two fields blank, then under the Liability account field, choose the Other Current Asset account, Employee Advances, that you created in Step 1 for tracking this expense and click Next
  • Select None as the tax tracking type and click Next
  • Leave the taxes unchecked and click Next
  • Select Neither in the calculate based on quantity screen and click Next
  • Select Net Pay and click Next
  • Enter a default rate and limit if desired and then click Finish

Note: You should only enter a default rate and limit if the rate and limit will apply to everyone using the Payroll Item. The limit may be marked as an annual limit and if so, you will need to manually adjust or remove the amount at the beginning of the calendar year or it will start recalculating.

Use this deduction on the Employee’s paycheck under Other Payroll Items. Enter this amount as a negative number. 

Create a Custom Summary Payroll Report to Track Employee Loan Balances

  • Go to Reports
  • Select Employees & Payroll
  • Select Payroll Summary
  • Click on Customize Report in the upper left corner
  • On the Display tab, choose All Dates
  • Select Payee in the Display Columns by drop-down menu
  • Check % of Row and uncheck Hours and Rate
  • Click on the Filters tab, select Accounts and choose the Other Current Asset account used for the Employee Advances on the drop-down menu
  • Click OK

Manage Employee Loans that will be Repaid over Time on Multiple Paychecks

  • Edit the Employee
  • Change tabs to Payroll and Compensation Info
  • Under Additions, Deductions and Company Contributions select the Loan Repayment Payroll Item
  • Enter the amount to be paid by paycheck in the Amount column as a negative amount.
  • Enter the balance remaining to be paid at this point into the Limit column as a negative amount.
  • Click OK

Note: QuickBooks® will automatically deduct this repayment on each paycheck and will stop the deduction once the limit has been reached.

This article of QuickBooks Tips and Tricks was based on the 2012 version of QuickBooks.

When you run financial statements on a Cash Basis in QuickBooks®, the results may not be what you expect. For example, you may find balances for Accounts Receivable and/or Accounts Payable on Balance Sheets run on a Cash Basis. This often means that the client has assigned a Payable or a Receivable to a Balance Sheet account, rather than to an Expense or Income account. There are other reasons this happens too.

Reasons for Accounts Receivable on a Cash Basis Balance Sheet

  • There may be open balances on Invoices that use Items linked to Balance Sheet accounts. An example would be a Customer Deposit linked to a Liability account.
  • There may be a prorata cost of Inventory Items listed on open Invoices. For example, if an Invoice that includes Inventory Part Items is half paid, half the cost of the Inventory Part Items will remain in Accounts Receivable.
  • There may be unapplied credits from Credit Memos or Payments. You can find these entries easily because they appear as negative numbers on the Open Invoices report.
  • There may be Sales Tax due listed on an accrual basis. You can change the Sales Tax Preference to Cash Basis to eliminate this problem. CAUTION: Check with your State taxing agencies for rules regarding payment of Sales Tax – some States require the basis for Sales Tax accruals to match the basis for Income Tax filing.

Reasons for Accounts Payable on a Cash Basis Balance Sheet

  • There may be Bills using Items linked to Balance Sheet accounts.
  • There may be Bills entered for a Note Payable or to buy a Fixed Asset.
  • You may find the cost of Inventory Part Items on open Bills.
  • There may be unapplied Vendor Credits or Prepayments.

To review balances in Accounts Receivable and/or Accounts Payable: 

Filter a transaction report with a paid status of Open transactions and date range of All to get a report showing the transactions that QuickBooks® did not reverse as part of the internal Cash Basis conversion.

  1. From the Reports menu, choose Company & Financial
  2. Choose Balance Sheet Standard from the submenu
  3. Click Customize Report
  4. Select Cash as the Report Basis
  5. Click OK
  6. Double-click the balance in the Accounts Receivable and/or Accounts Payable account
  7. Click Customize Report, and then click the Filters tab
  8. In the Filters list, select Paid Status and then select Open
  9. Click OK

Complete the Cash Basis Conversion

To complete the Cash Basis conversion, use a Journal Entry to adjust away the Accounts Receivable and/or Accounts Payable balances. For the Journal Entry, create a Customer called ***A/R CPA Use Only*** and an Accounts Payable Vendor called ***A/P CPA Use Only***. Use these names to transfer the balances to whatever accounts you choose for the adjustments.

These Journal Entries are Reversing Entries as of the first day in the next fiscal period and you must apply the Journal Entry and the Reversing Entry against each other to offset them or you will have Unapplied Credits going forward.

Do not use Accounts Receivable and/or Accounts Payable as the first line of a journal entry in QuickBooks®. To find out why, see our next Accounting Professionals Only newsletter.

Please contact me if you have any questions or need further details regarding this information. This article was based on the 2012 version of QuickBooks®.

Rhonda Rosand, CPA
Certified QuickBooks® ProAdvisor
New Business Directions