Articles
Browse through our articles to see comprehensive coverage of QuickBooks, Software Consulting, Small Business Management, and much more.
Sign up for our newsletter, The Desktop Accountant, to receive monthly digests of these articles.
Subscribe to our Articles RSS feed!
Search Articles
August Note from your Community Manager
Hi, everyone! We’d David Horwitzlike to take a minute to thank some local Sleeter Group and QuickBooks user groups that have invited us to come to their local meetings and chat with their members. This is a real pleasure for us, as it gives us the opportunity to meet face-to-face with folks in the accounting software consulting world.
Mid-Year Setup
This classic excerpt for The Sleeter Group’s QuickBooks Consultant Reference Guide – Version 2009 covers setting up a QuickBooks file mid-year.
Understanding Business Intelligence and Related Terminology
The purpose of this month's article by Chuck Vigeant is to create a glossary of terms and clarify the subtle - but distinct - differences among the various nomenclature used to describe data extraction and reporting.
A Note from our Community Manager - June
It would be really easy for us to tell you why you should come to The Sleeter Group’s Next Generation Accounting Solutions Conference, but it gets tiring spending days and nights coming up with positive marketing language. So instead, we’re listing for you the top five reasons not to join us in Orlando in November … but why those reasons don’t hold water! These thoughts might just give you a whole new way of looking at the investment in time and money it takes to come to a valuable event such as this! Read on…
Two Party Checks
In the construction industry, the bookkeeper will occasionally have to handle receiving a "two-party check." A two-party check is payable to two companies, usually the prime contractor and a materials supplier, or other subcontractor. The reason is most often to ensure that the supplier is paid in a timely manner and that there is a direct link between the payment from the job and the payment to the supplier. It is also intended to prevent suppliers from attaching liens to the property by making it impossible for the prime contractor to fail to pay the supplier. Here is our suggestion for how to handle two-party checks.
S Corp Case Study Part II –Tax Problems Resulting from Deficit Equity
In Part I, we discussed that owners of small companies live and breathe their businesses. Cash to fund operations often comes from the owner, and most owners also take cash out of the company as distributions. It is common to see both cash inflows and outflows on a frequent basis throughout the year. Part I focused on various methods of tracking this activity as it relates to an S Corp in a QuickBooks file. In Part II we promised to discuss some of the “bad news” that comes with the flexibility of S Corporations. In particular, we will be discussing one of the most common tax problems for an S Corporation: “Distributions in excess of basis”. This is a fancy phrase that means there are distributions paid to the owner during the year, and there is an ending deficit in the total equity balance.
Owner Distributions, Contributions, and Loans Part I – An S Corp Case Study
Owners of small companies live and breathe their businesses. This is particularly true when it comes to the relationship between owners and the cash flow of the company. Cash to fund operations often comes from the owner, and most owners also take cash out of the company as distributions. It is common to see both cash inflows and outflows on a frequent basis throughout the year. In this first part of a two part series, we look at methods of tracking this activity as it relates to S Corps in a QuickBooks file.
Chuck's Reporting Corner March 2009
We gave you glimpse into the inner workings of the QODBC driver - without having to use a database, fancy report writers - or even Excel. If you want to have a better idea of what the driver has - or does - this is the simplest way of finding out. If you are experienced, use this tool to extract which columns you need for your report, or learn more about the data it retrieves. Even grandpa Chuck still uses this tool.
Fishbowl Inventory for QuickBooks offers 100% customer satisfaction guarantee
Fishbowl launches customer satisfaction guarantee for #1 requested inventory solution for QuickBooks. Fishbowl Inventory Gives Small to Mid-size Companies Same Competitive Advantage Large Organizations with Elaborate Inventory Solutions Enjoy
Chuck's Reporting Corner February 2009
This month Chuck Vigeant reveals a glimpse of the brand new Sales Performance Analyzer tool released last week to QuickBooks Enterprise Customers, and current non-Enterprise beta testers. Last year, Chuck was independently contracted by Intuit as a data architect, an expert in Business Objects technology, and a QuickBooks/Sybase data analyst; he worked with a team of Product and Production Managers, database engineers, asset design engineers, and Quality Assurance personnel that delivered the Business Analysis Offering. Here is his bird's eye view of this brand new tool.
Chuck's Reporting Corner January 2009
Every year about this time, we get requests to see if we can create a report that lists and - conditionally - collapses the detail for vendor purchases to review both posting accounts, transaction posting behavior, and then group it according to 1099 categories. The SDK does not give us a table that allows us to retrieve the accounts earmarked for each 1099 category/box, as well as the threshold limits. We CAN create a simple query in Excel that lists the vendors, 1099 eligibility status, Tax ID number, and address pieces.
New Features for QuickBooks 2009
QuickBooks 2009 and QuickBooks Enterprise Solutions 9.0 have features that will extend the usability of QuickBooks, including Multi-Currency and improved Multi-User capability. There are also several features that will help accounting professionals, such as Client Data Review and Intuit Statement Writer 2009. This extensive article covers what's new and how you can use these features in your practice. It is an excerpt from The Sleeter Group's QuickBooks Consultants Reference Guide 2009.
Chuck's Reporting Corner December 2008
On November 19th, QuickBooks Enterprise released a suite of online applications, one of which is a tool called Business Analysis ES. This is a web based application powered by Web Intelligence tools licensed from Business Objects, the leader in Business Intelligence and now, an SAP company. You can use these tools via an Internet Explorer or Foxfire browser, with confidence about the security and anonymity of this data.
Awesome QuickBooks Add-ons for 2009
At The Sleeter Group, our whole year is spent studying the marketplace of add-on solutions and consulting with developers who seek to provide better solutions for our clients. And for several years now, we’ve spotlighted several special products we call "awesome add-ons."
Awards Announced for QuickBooks Add-ons
The Sleeter Group recognized seven software technologies with its "2009 Awesome Add-ons for QuickBooks" Award. The nation's premier network of QuickBooks consultants, The Sleeter Group presents the awards annually to recognize technologies that help enhance the functionality of the world’s most popular business management software.




