Header Right

5 QuickBooks Online Reports You Should Run Regularly

by

Dorsey CPA - QuickBooksThere are numerous QuickBooks Online reports that you should be consulting at regular intervals. But you need these five at least every week.

QuickBooks Online’s Dashboard, the first screen you see when you log in, provides an effective overview of your company’s finances. It contains at-a-glance information about your recent expenses, your sales, and the status of your invoices. It displays a simple Profit and Loss graph and a list of your account balances. Scroll down and click the See all activity button in the lower right and your Audit Log opens, a list of everything that’s been done on the site and by whom.

You can actually get a lot of work done from this page. Click the bar on the Invoices graph, for example, and a list view opens, allowing you access to individual transactions. Click Expenses to see the related Transaction Report. Below the list of account balances, you can Go to registers and connect new accounts.

Other Pressing Questions

The Dashboard supplies enough information that you can spot potential problems with expenses and sales, accounts, and overdue invoices. But you’re likely to have other tasks that require attention. How’s your inventory holding up? Are you staying within your budget? How about your accounts payable – will you owe money to anyone soon?

QuickBooks Online offers dozens of report templates that answer these questions and many more. If you’ve never explored the list, we suggest that you do so. It’s impossible to make plans for your company’s future without understanding its financial history and current state.

QuickBooks Online has many reports that can provide real-time, in-depth insight into your company’s financial health.

Comprehensive and Customizable

When you click Reports in your QuickBooks Online toolbar, the view defaults to All. The site divides its report content into 10 different sections, including Business Overview, Sales and Customers, Expenses and Vendors, and Payroll. Each has two buttons to the right of its name.

Click the star, and that report’s title will appear in your Favorites list at the top of the page. This will save time since you’ll be able to quickly find your most often-used reports. Click the three vertical dots and then Customize to view your customization options for that report (you’ll have access to this tool from the reports themselves).

Necessary Knowledge

You can, of course, run any report you’d like as often as you’d like. Most small businesses, though, don’t require this frequent intense scrutiny. But there are five reports that you do want to consult on a regular basis. They are:

1. Accounts Receivable Aging Detail. Displays a list of invoices that haven’t yet been paid, divided into groups like 1-30 days past due, 31-60 days past due, etc.

2. Budget vs. Actuals. Just what it sounds like: a comparison of your monthly budgeted amounts and your actual income and expenses.

Warning: Some reports let you choose between cash and accrual basis. Do you know the difference and which you should choose? Ask us.

You can customize QuickBooks Online reports in several ways.

3. Unpaid Bills. Helps you avoid missing accounts payable due dates by displaying what’s due and when.

4. Sales by Product/Service Detail. Tells you what’s selling and what’s not by displaying date, transaction type, quantity, rate, amount, and total. 5. Product/Service List. An accounting of the products and/or services you sell, with columns for price, cost, and quantity on hand.

Customization, Complex Reports

Note that there’s a category of reports in QuickBooks Online named For My Accountant. That’s where we come in. The site includes templates for reports that you can run yourself, but that you’d have difficulty customizing and analyzing. These standard financial reports—which, by the way, you’ll need if you create a business plan or try to get funding for your business—include Balance Sheet, Statement of Cash Flows, and Trial Balance.

You don’t need to have these reports generated frequently, but you should be learning from the insight they provide monthly or quarterly. We can handle this part of your accounting tasks for you, as well as any other aspect of financial management where you need assistance. Contact us, and we’ll see where we might help provide the feedback and bookkeeping expertise that can help you make better decisions for the future of your business.

Social media posts

QuickBooks Online reports pick up where the Dashboard leaves off, providing dozens of templates ready for your company data. Do you know how to best use them?

You can create some QuickBooks Online reports using either cash or accrual basis. Do you know the difference? Ask us if you don’t.

Overwhelmed by the number of reports QuickBooks Online offers? Click the star next to the ones you run most often, and they’ll appear in Favorites.

QuickBooks Online contains several reports in a section titled For My Accountant. These are complex financial reports that we can run and analyze for you.

We offer a FREE initial consultation for business owners. Please call us at 404-459-4174 and ask for Dorsey CPA to discuss your specific needs.

Growing Pains: Structural Considerations for Growing Your Business

by

watering can pouring molten goldAsk any small-business owner what he sees as the major challenges to growing his business, and chances are he’ll say: winning more sales. Ask any medium- or large-business owner what her major challenges have been, however, and she’ll probably say: structural growing pains — putting into place the necessary processes and structure to accommodate a higher volume of business. In fact, one of the most common reasons businesses plateau at a certain level is their inability — or unwillingness — to develop the structure needed for growth.

But aligning structural changes with sales growth is not simple. It is often more of an art than a science. The systems, processes, staff, and organization changes needed to grow are ongoing and dictated by myriad factors such as the nature of the business, its capital requirements and, ultimately, customer demands. Nonetheless, certain structural growth concerns — excluding financing and office/production space issues — are shared among all growing companies and fall into three overall areas: organizational structure, policies and procedures, and systems/technology.

Staffing/Organizational Structure

Among the most common growing pains small companies experience are those related to organizational structure. Organizational structure and reporting hierarchy for a 25-person company is quite different than it is for a five-person organization. Typically, an entrepreneur can manage fine until there are about a dozen people in the organization. At this point, the initial structure — where everyone usually reports to the owner — breaks down. In effect, nothing can be done without involving the owner, creating a communications log jam and a barrier to growth. A telltale sign of such a situation is the line of staff outside the boss’s office — waiting patiently for a decision before work can recommence. The best way to overcome or prevent this from happening is simple: Trust your key employees and learn to delegate. A good place to start is to look at where you are spending your time. You can still have final say on any important decisions, but you need not be involved with the time-consuming, day-to-day issues that can prevent you from focusing on larger, more strategic matters. It’s also important to formalize delegated authority with an organizational chart and job descriptions. These will help you better define functional expertise for a given job and for various departments across the organization, and provide the foundation for the growth of future personnel and key management staff.

Lack of functional expertise is another common growing pain of small companies. Too often, businesses fail to recognize that specific expertise is needed as they grow. Typically, small businesses are organized around the manager’s area of expertise, such as marketing, accounting, or production. This specialized expertise often prevents the business owner from recognizing problems that may arise in other parts of the business. It’s a good idea to periodically get an outsider’s opinion of where expertise may be lacking. These need not be paid consultants, but are often trusted business acquaintances. Tapping into this same group, you can also form an advisory board to give you periodic feedback on strategic direction.

Policies and Procedures

For most smaller businesses, written policies and procedures are often nonexistent and sometimes cursed. Typically, they are associated with the bureaucracy and inefficiency of big companies and the enemy of customer responsiveness and quick time to market. Not surprisingly, most smaller businesses have few documented operational policies or procedural guidelines. But it is precisely this lack of documentation — and the thought that goes into it — that can put a stranglehold on rapid growth. If your business is growing fast enough to require frequent additions to staff, formalized policies are a must for training purposes. Even if you are expanding at a moderate pace, documented policies will likely be necessary once you reach 20 or more employees.

What warrants a formal policy and what should be documented? This will depend on the nature of your business and average skill level of your employees. In general, however, it’s a good idea to document all HR policies in detail, expense approval authorization levels, inventory control policies, billing and collection procedures, and any operational policies that could materially affect your business if they went amiss. An annual budget and sales projection, updated monthly, are also a necessity if you are ever to obtain outside funding or sell your company. Later on, consider putting together a comprehensive policy manual where employees can get answers to questions when decision makers are unavailable.

As you grow bigger, you will also need to put into place more formalized communications channels for employees and customers. An informed and involved staff is usually a more productive and enthusiastic one; whereas a staff that is left in the dark often feels alienated and unappreciated. Regularly scheduled employee meetings, periodic e-mail updates, and a cascade communications policy are several ways to make sure your internal communications channels facilitate, not constrict, growth.

Is your business suffering from growing pains?

Here are some sure signs that structural changes may be in order.

  • Sales continue to grow but profits do not.
  • Everyone is working increasingly long hours.
  • People spend too much time putting out fires.
  • There are constant lines outside the boss’s door.
  • There are no regularly scheduled meetings or employee communications.
  • The “system” is constantly down.
  • Aging equipment is not replaced.

Systems/Equipment

Perhaps more obvious than organizational or procedural growing pains are those associated with systems and equipment. Smaller businesses are often the last to upgrade to new technology, usually due to cost. Yet the costs of not upgrading are usually much higher. Low productivity, frequent downtime, and incompatibility with newer client systems can cripple a business that’s poised for growth. There’s also the matter of keeping up with your competitors both operationally and across product and service offerings.

The average computer is virtually obsolete in just three years, and most of the widely used software applications come out with new versions every two years, so keeping on top of technological advances must be an ongoing endeavor. Start out by working regular capital upgrade costs into your budget. Consider dedicating a full-time person to information technology (IT), if you don’t already have one, and make sure he or she is current on the latest technological developments in your field. Even though you may not be able to afford all the latest equipment, at least you’ll be on top of technology trends in the industry and know what your competitors are up to — or are capable of.

Dorsey CPA offers a FREE initial consultation to individuals and businesses in Roswell, Sandy Springs, GA and surrounding areas. Call us today at 214-361-1400 to discuss your specific needs.

Business Auto Deductions: Two Ways to Calculate

by

accountant working on a calculatorDo you drive your car for business purposes? The costs of operating and maintaining your vehicle are potentially deductible. Here are some guidelines.

Two Methods

The IRS provides two basic methods for computing deductions for the business use of an automobile.

Actual expense method. With the actual expense method, you deduct the actual costs of operation, including licenses, registration fees, garage rent, repairs, gas, oil, tolls, and insurance. Additionally, you may claim depreciation deductions (and/or elect expensing under Section 179). If the car is leased, you deduct your lease payments rather than depreciation. (Certain limits apply.)

Standard mileage rate. Alternatively, you may choose to use an IRS-provided standard mileage rate. With this method, you multiply the number of business miles you drive during the year by the applicable rate (58¢ per mile for 2019). When you use the standard mileage rate, you don’t separately deduct expenses such as gasoline, oil, insurance, repairs and maintenance, depreciation, or lease payments. However, business-related parking fees and tolls are separately deductible.

Which Should You Use?

Generally, you will want to use the method that produces the largest deduction. If your vehicle is costly to own and operate, the actual expense method may be more advantageous. Conversely, if your vehicle is fuel efficient and/or inexpensive, the simpler standard mileage rate method may be a better choice.

With either method, the IRS requires that you keep records that substantiate your business use of the car: the date, place, business purpose, and number of miles you travel. When you use the actual expense method, you’ll also need records substantiating the amount and date of car-related expenditures. You can avoid having to retain receipts by using the standard mileage rate.

If you decide to use the standard mileage rate for a car you own, you may switch to the actual expense method in a later year. However, you won’t be able to claim accelerated depreciation deductions for the car. With a leased car, you have less flexibility. If you choose the standard mileage rate the first year, you must use it for the entire lease period.

Personal and Business Use

If you use your car for both personal and business purposes, you must keep track of your mileage for each purpose. To figure the percentage of qualified business use, you divide the business mileage by the total mileage driven. Then multiply that percentage by your total expenses.

Dorsey CPA offers a variety of tax planning services to both businesses and individuals. Conscientious tax planning throughout the year can save you money and make tax time easier. Call us at 404-459-4174 and request a free initial consultation to learn more.

ACA Affordability Threshold to Rise in 2019

by

meeting with business personOne of the main requirements of the Affordable Care Act’s employer mandate is that health coverage must be affordable, based on annual standards set by the IRS. Click through for the details on the 2019 increase for one of those standards.

The ACA requires that employers with 50 or more full-time-equivalent employees provide minimum essential coverage that is affordable — or face a penalty for not complying. The affordability requirement is satisfied if an employee’s premium for self-only coverage does not exceed a specific percentage of their household income or a certain safe harbor amount.

Percentage increase for 2019

Each year, the affordability percentage for health coverage is adjusted for inflation. For 2018, the rate is 9.56 percent of the employee’s household income, down from 9.69 percent in 2017.

On May 21, 2018, the IRS released Revenue Procedure 2018-34, which states that for plan years starting in 2019, the affordability percentage will increase to 9.86 percent — the highest amount since the ACA’s passage. This means that employees’ premiums for the lowest-cost self-only coverage cannot be more than 9.86 percent of their household income.

Three safe harbor options

As noted, the affordability percentage threshold applies to employees’ household income. But since it’s difficult for employers to know their employees’ household income, the ACA provides three safe harbor alternatives, which can be used instead of household income. You do not have to meet all three requirements; just one will do.

1. The employee’s W-2 wages, as shown in Box 1 of the form. For plan years starting in 2019, coverage is affordable if the employee’s premium does not exceed 9.86 percent of the amount in Box 1 of the W-2. Although this method is relatively simple to apply, keep in mind that it uses current-year wages. Therefore, you won’t know whether the affordability requirement for an employee has been met until the end of the year.

2. The employee’s rate of pay. Coverage is affordable if the employee’s premium does not exceed 9.86 percent of their monthly salary or wages. To determine the monthly rate of pay for an hourly worker, multiply the hourly pay rate by 130 hours.

For instance, an employee makes $15 per hour at the start of 2019. Multiply $15 by 130, which equals $1,950. Then multiply $1,950 by 9.86 percent, which comes to $192.27. Coverage is affordable as long as the employee’s premium does not exceed $192.27. For salaried employees, affordability is based on monthly salary.

The rate-of-pay method cannot be used for employees who are paid solely by commission, nor can it be used for tip wages.

3. The federal poverty level. The employee’s premium for the lowest-cost self-only coverage cannot be more than 9.86 percent of the most recently published FPL for a single person.

Applicable large employers should take the affordability standard into account when designing their 2019 health care plans — since pricing below the threshold could trigger penalties, as mandated by Section 4980H(b) of the ACA.

Dorsey CPA offers a variety of tax planning services to both businesses and individuals. Conscientious tax planning throughout the year can save you money and make tax time easier. Call us at 404-459-4174 and request a free initial consultation to learn more.

Do a Financial Review Mid-Year

by

Dorsey CPA Accounting and Tax ServicesBefore you get involved with other things this summer, schedule a mid-year checkup. No, we’re not talking about the height/weight/blood pressure kind of checkup, we’re talking about the income statement/balance sheet/cash flow kind of checkup — a review of your business’s financial operating fundamentals.

If you review your vital financial information only when year-end rolls around, you may not know there’s a problem until it’s too late. The more often you take your company’s “pulse,” the sooner you’ll be able to notice — and react to — changes in your business situation.

Check Your Vital Signs

What should you be looking at? Start with the operating fundamentals. For example, what’s the status of accounts payable? When’s the last time you ran an aging report for accounts receivable? How quickly is your inventory turning? What is your profit margin?

These numbers are critical to running your business. You can’t make accurate decisions if your figures are old. And, by keeping track of key financial ratios, you can more readily spot trends that should be addressed sooner rather than later.

Monitor Your Budget

Next, check your spending. If overspending is a problem, creating a comprehensive budget that establishes realistic guidelines is an effective remedy. Make sure you have a budgeted amount for every line item expense on your operating statement. Then track and compare actual spending to budgeted amounts on a regular basis.

Reduce Your Debt

Avoid the temptation to take out all your profits in good years. Instead, consider reinvesting some of those earnings in the business. Using retained earnings instead of debt to capitalize your business saves money — and provides a safety net that will be there to help you through periods of lackluster sales or unexpected expenses. A healthy debt-to-equity ratio will also look great when it’s time to borrow money or sell your business.

See a Specialist

Helping owners build and maintain healthy businesses is our specialty. Let’s schedule that mid-year review of your company’s finances soon.

To learn more about financial reviews give us a call today. Our trained staff of professionals are always available to answer any questions you may have.

We offer a FREE initial consultation to individuals and businesses in Roswell and Sandy Springs, GA and surrounding areas. Call us today at 214-361-1400 to discuss your needs.

Are You Giving Your Taxes Year-round Attention?

by

Dorsey CPA Tax ServicesGiving your taxes your full attention just once a year isn’t the best business strategy. Experts suggest that a year-round approach is better for your finances. Click through to learn the best ways to evaluate the impact of taxes throughout the year.

Numerous tax experts agree that addressing your tax liability effectively requires planning throughout the year. Those business owners who reap the most benefits consider their taxes year-round, rather than waiting to focus on tax payments just a few weeks before the filing date.

A typical small business qualifies for roughly a dozen tax deductions. For example, you may be able to claim deductions on the following:

  • Cars operated for business purposes
  • Business-related travel and entertainment expenses
  • Purchases of office supplies, furniture, equipment, and software programs
  • Telephone expenses
  • Contributions toward insurance policies, retirement plans, and pension funds

It’s surprising how many small businesses never take advantage of these deductions, mainly because they suffer from the “tax-planning-happens-but-once-a-year” syndrome. To fully benefit from these deductions, it’s important to maintain your expense records throughout the year.

Your goal should be to reduce your tax liabilities by retaining records of your purchases and determining the proportion of business costs in combined expenses. By monitoring your expenses closely all year, you can analyze each expense for its tax impact as it’s made. Additionally, smart business owners should contemplate three key steps to tax planning:

1. Invest in the most effective tax record tools for your business. Whether it’s spending roughly $30 on journals and tax books with a set of refill sheets costing less than $10 to do manual bookkeeping or investing up to $2,000 on the latest online software tax-filing applications, you will benefit from more rigorous and accurate recordkeeping. Sure, the initial investment could be significant, but regular monitoring should facilitate tracking expenses and making advance payments, which will save you money in the long run.

2. Determine when you need professional tax tips and planning advice. At times you will be able to justify paying for professional tax services, particularly if you need advice on unclear requirements in tax laws that could be in your favor. To prevent unnecessary complications and aggravations, you must avoid violating tax laws that may be applicable to your small business. If you are unsure of these laws, using the tools at your disposal, such as current software and online recordkeeping, and complementing those capabilities with professional advice when needed, can help you keep your taxes under control.

3. Establish year-round tax planning goals. A good tax-planning strategy will help you accomplish some of these goals:

  • Reduce the amount of taxable income
  • Claim any available tax credits
  • Lower your tax rate
  • Control the time when taxes must be paid
  • Avoid the most common tax-planning mistakes

Plus, a year-end review at the end of your fiscal year or “busy season” can be most effective if you’ve maintained clear records and an understanding of your financial position throughout the year.

Of course, this is just a general list. Not all deductions are available in all situations, and rules change frequently. Give us a call to discuss which deductions apply to your company.

We offer a FREE initial consultation to individuals and businesses in Sandy Springs, GA and surrounding areas. Call us today at 214-361-1400 to learn more about our tax preparation services.