Making the Most of Your QuickBooks Investment “UNDER THE COVERS” LISTS DRIVE REPORTS e.g.: Chart of Accounts
Note the sub-accounts,… Totals appear on reports after each set. COGS account type should be used for production costs.
e.g.: Items List Each item links to an account, e.g. -Labor -Subcontractors -Materials -Other Costs (Sub-Items create sub-totals as well.) Items are required for: -Estimates -Purchase Orders -Invoices Items are optional for: -Checks, Bills, Credit Cards But create great job cost reports
Screenshots from QuickBooks® Premier Accountants Edition sample files. Explanatory notations added by Diane Gilson © Info Plus Accounting, www.InfoPlusAcct.com, 866-244-2228
1
Making the Most of Your QuickBooks Investment “UNDER THE COVERS” LISTS DRIVE REPORTS e.g.: Customer:Job List
e.g.: A variety of other Lists provide structure and analytical results
Screenshots from QuickBooks® Premier Accountants Edition sample files. Explanatory notations added by Diane Gilson © Info Plus Accounting, www.InfoPlusAcct.com, 866-244-2228
2
Making the Most of Your QuickBooks Investment 2010 Report Center “Carousel” view:
SAMPLE PROFIT & LOSS BY JOB REPORT (ACCOUNT BASED)
Screenshots from QuickBooks® Premier Accountants Edition sample files. Explanatory notations added by Diane Gilson © Info Plus Accounting, www.InfoPlusAcct.com, 866-244-2228
3
The Mini-Audit: Self-Defense for Your Assets By Diane Gilson, CQBPA – President, Info Plus Accounting As more and more companies bring their accounting systems in house, the opportunities for errors and/or fraud increase correspondingly. Here are some fairly simple steps you can take in the comfort of your office to help protect your company from both of these unpleasant and regrettable circumstances,…
The Nature of Accounting Reports There are many company owners who never take the time to really look at their accounting reports. Besides missing out on the opportunity to improve operations by taking action on the data, they could be losing money to an unscrupulous employee. Fortunately, by a careful perusal of reports and underlying data, you can help to prevent that from happening in your company. Good business practice dictates staying in touch with your daily and monthly financial activity. If one of your employees handles your financial transactions and has access to your assets, it becomes even more critical to receive and carefully review accounting reports every month. Become familiar with the following report formats and the information they contain:
•
Summary reports. Standard balance sheets and income statements are good examples of summary-style reports. They consolidate the results of a number of transactions for a given period of time into specific, detailed accounts (e.g., workers’ compensation insurance) or more generalized account groups (e.g., compensation and fringe benefits). Summary reports can be prepared at the account level. Even if you’re primarily interested in the most summarized version of the document, ask for the “account-level” report. You can quickly see what accounts make up the total. Summary reports can be very useful for “big picture” purposes and trend spotting. However, if you only look at the most summarized versions, you may miss or overlook vital information.
•
Detailed transaction reports. These documents list the individual entries that compose specific accounts’ (e.g., bills, credit card charges, journal entries, invoices, etc.) total balances. Transaction reports are useful when resolving questions about what makes up the balance in a particular account. In addition to the transaction date and the vendor, you may find it helpful to include a column that shows who made each entry and the date and time they did so.
•
Supporting schedules. A supporting schedule is simply a list of what makes up an account balance. These are generally prepared for balance sheet accounts. Typical supporting schedules show a detailed listing of accounts payable or accounts receivable (both of these should be shown in an “aging” format; i.e., analyzed by the length of time they have been unpaid). You should also periodically ask to see supporting schedules to show what is included in accounts such as “employee loans receivable,” “work in progress,” “suspense” (let’s hope you don’t have one of those!) and other accounts that contain entries that “come and go.”
•
“Change” reports. What’s changed since last month? Last quarter? Last year? These reports typically show the most recent month’s balances, another column showing the prior month’s (or prior quarter’s or prior year’s) balances and remaining column(s) that show the dollar and/or percentage change since the previous report period. Change reports are especially useful for balance sheet reports. As you review the report, confirm that the account balances listed for the previous month, quarter or year agree with prior change reports you’ve reviewed. (Note: Accountants usually ask if the balances “roll forward”; i.e., if you start with the prior beginning balance and account for the increases and decreases, the result must agree with the ending balance.)
4
Many accounting systems allow users to change balances for prior reporting periods. That is why it’s especially crucial to reconcile the current change report’s prior balances with historic balances that you have reviewed for a given period. If you are focused on current balances and activity, but the prior balance has been altered, you won’t see accurate results.
•
Variance reports. These documents show how actual results differ from expected or estimated results. One column shows planned results, another column the actual results and the remaining columns show the difference (variance) in dollars and/or percentages. Examples of variance reports include budget vs. actual reports (generally account-based reports) and estimated vs. actual job cost reports (usually structured to show estimated and actual costs by job stage for individual jobs). Variance reports are especially useful for fraud prevention; it’s hard to conceal large dollar variances when a business owner continually monitors actual vs. planned results. Remember, however, that you may be seeing only a portion of the financial activity entered into the books. For example, materials costs may be on target for jobs A, B and C, yet other costs may be included on the books that have not been assigned to any of those jobs.
Crosscheck Your Data It is important to periodically crosscheck variance reports with backup data to make sure the sum of the parts equals the total. I typically suggest to clients that they prepare an account-based “profit & loss by job” report and check the account totals against a “company account totals” report. A clever embezzler could also alter the budget or estimate to cover up unusual activity, but an astute owner who is in touch with the numbers would likely spot that subterfuge. Filtered and Modified Reports Accounting systems such as QuickBooks® allow the report preparer to filter reports to show only certain transactions or to export reports into a spreadsheet that can be modified before being printed. Both of these features can be very helpful when analyzing or extracting information for legitimate purposes, but it’s easy to see the downside. If you don’t adopt a “hands on” approach to your accounting system and regularly confirm the accuracy of your reports, it can be fairly easy for someone to carefully select, or modify, the information that you see. Recommendations
•
Ask and expect to see accounting reports in a variety of formats: summary, detailed, supporting schedules, change and variance. You must draw on the different information each format provides to get a complete picture of your financials.
•
Take the time to review your reports for reasonableness and accuracy. For example: o Does the total equal the sum of the parts? o Do the planned amounts agree with your recall? o Do beginning balances agree with prior-period closing balances?
•
Satisfy yourself that the reports you are reviewing have not been altered or modified between what is currently in the accounting system.
•
If you find that, in spite of your best efforts, you just don’t have the time to do the review yourself, try to find another trusted and reliable “set of eyes” to periodically take an objective look at your data (e.g., your CPA).
Your internal financial statements have a story to share. If you consistently review them and take just a little extra time to confirm the accuracy of the data they contain, you’ll be in a good position to discover any significant unusual financial activity. That goes a long way toward preventing inside jobs.
5
Diane C.O. Gilson
President, Info Plus(+) Accounting®, Inc. ®
Certified QuickBooks Advanced Pro Advisor ® Certified QuickBooks Enterprise ProAdvisor
Info Plus(+) Accounting®, Inc. 2370 E. Stadium Blvd., #1020 Ann Arbor, MI 48104 E-mail:
[email protected] Website: www.InfoPlusAcct.com Phone: 734-544-7620 Toll-free: 866-244-2228
BIOGRAPHY: Diane Gilson created the accounting firm of Info Plus(+) Accounting® in 1994 with the intent of providing current and future-oriented job cost and management accounting services to small and medium-sized businesses. Since the ® firm’s inception, Diane has worked exclusively in QuickBooks – a powerful, flexible, multi-functional software accounting system currently used by 70-85% of small to medium-sized businesses in the United States. She is a ® Certified QuickBooks Advanced Professional Advisor and Certified QuickBooks Enterprise ProAdvisor (through Intuit), and a Certified QuickBooks® consultant (through the Sleeter Group Consultants Network). Although the firm has a number of clients in the service, technology, retail and other industries, 80-90% of Info Plus Accounting’s clients are in the construction and manufacturing industries. Diane, and her accounting staff have chosen to provide enhanced services for these industries because QuickBooks® is especially suited to their needs for understandable, useful job costing and profitability reports. Background and credentials In addition to her various QuickBooks® certifications, Diane initially earned her CPA licensure in 1981, and practiced as a licensed CPA for 15 years. Although not currently performing public accountancy services, she is registered as a CPA in Michigan. She has also achieved the Certified Internal Auditor designation and brings more than thirty years of varied job-cost, auditing, tax, computer accounting systems, budgeting, training, and management accounting experience to her accounting and consulting practice. Before founding Info Plus(+) Accounting®, she worked for a national Honor Society, and as a licensed CPA for a regional CPA firm. She then spent fourteen years in banking as Internal Audit Manager, and as Manager of Management Accounting Systems, where she established corporate planning and budgeting processes, accountability reporting, and activity-based-cost (ABC) profitability measurement systems. She is the creator of various Excel-based accounting support calculators & checklists, developer of a robust QuickBooks Pro template (file) and support system created especially for builders developers, and remodelers (AccountingPRO™), and is the author of Accounting with QuickBooks for Home Builders & Remodelers (originally published by NAHB’s BuilderBooks). Her techniques and products have also been featured in other industry publications as well as in Intuit’s newsletters. In addition to her firm’s daily, one-to-one QuickBooks support work with clients throughout the U.S., the company currently offers Internet-based “QuickBooks for Construction” webinars. Diane is also an NAHB University of Housing Instructor for their “Business Accounting and Job Cost” and “Financial Management” courses and has authored a series of articles for various NAHB publications (including Nations’ Building News Online) relating to small-business anti-fraud protection techniques as well as another series, “The QuickBooks® Challenge”. Her expertise and industry experience has earned her a variety of speaking engagements for various organizations including the Michigan Association of CPAs, the (NARI) Remodel America (National) Show, the Dwyer Group, the Midwest Builders’ Shows, the Custom Builders Symposium, the National Remodelers’ Shows (six shows), the International Builders’ Show (eight shows) and various other national, regional, and local construction shows and training seminars. Diane served as Treasurer for 10 years in her local Home Builder’s Association, is a lifetime member of the Board of Directors, a member of the State Audit Committee, and a national NAHB Board member. She was also honored to receive both the Associate of the Year, and Distinguished Service to the Building Industry, awards.