Admin

Getting Started with Reports in QuickBooks Online

March 20, 2022 by Admin

accountant talking with clients You should be running reports in QuickBooks Online on a weekly—if not daily—basis. Here’s what you need to know.

You can do a lot of your accounting work in QuickBooks Online by generating reports. You can maintain your customer and vendor profiles. Create and send transactions like invoices and sales receipts, and record payments. Enter and pay bills. Create time records and coordinate projects. Track your mileage and, if you have employees, process payroll.

These activities help you document your daily financial workflow. But if you’re not using QuickBooks Online’s reports, you can’t know how individual elements of your business like sales and purchases are doing. And you don’t know how all of those individual pieces fit together to create a comprehensive picture of how your business is performing.

QuickBooks Online’s reports are plentiful. They’re customizable. They’re easy to create. And they’re critical to your understanding of your company’s financial state. They answer the small questions, like, How many widgets do I need to order?, and the larger, all-encompassing questions like, Will my business make a profit this year?

Getting the Lay of the Land

Let’s look at how reports are organized in QuickBooks Online. Click Reports in the toolbar. You’ll see they are divided into three areas that you can access by clicking the labeled tabs. Standard refers to the comprehensive list of reports that QuickBooks Online offers, displayed in related groups. Custom reports are reports that you’ve customized and saved so you can use the same format later. And Management reports are very flexible, specialized reports that can be used by company owners and managers.

Standard Reports

The Standard Reports area is where you’ll do most—if not all—of your reporting work. The list of available reports is divided into 10 categories. You’re most likely to spend most of your time in just a few of them, including:

Favorites. You’ll be able to designate reports that you run often as Favorites and access them here, at the top of the list.
Who owes you. These are your receivables reports. You’ll come here when you need to know, for example, who is behind on making payments to you, how much individual customers owe you, and what billable charges and time haven’t been billed.
Sales and customers. What’s selling and what’s not? What have individual customers been buying? Which customers have accumulated billable time?
What you owe. These are your payables reports. They tell you, for example, which bills you haven’t paid, the total amount of your unpaid bills (grouped by days past due), and your balances with individual vendors.
Expenses and vendors. What have I purchased (grouped by vendor, product, or class)? What expenses have individual vendors incurred? Do I have any open purchase orders?

The Business Overview contains advanced financial reports that we can run and analyze for you. The same goes for the For my accountant reports. Sales tax, Employees, and Payroll will be important to you if they’re applicable for your company.

Working with Individual Reports

To open any report, you just click its title. If you want more information before you do that, just hover your cursor over the label. Click the question mark to see a brief description of the report. If you want to make the report a Favorite, click the star so it turns green. And clicking the three vertical dots opens the Customize link.

When you click the Customize link, a vertical panel slides out from the right, and the actual report is behind it, grayed out. Customization options vary from report to report. Some are quite complex, and others offer fewer options. The Sales by Customer Detail report, for example, provides a number of ways for you to modify the content of your report so it represents exactly the “slice” of data you want. So you can indicate your preferences in areas like:

Report period
Accounting method (cash or accrual)
Rows/columns (you can select which columns should appear and in what order, and group them by Account, Customer, Day, etc.)
Filter (choose the data group you want represented from several options, including Transaction Type, Product/Service, Payment Method, and Sales Rep)

Once you’ve run the report, you can click Save customization in the upper right corner and complete the fields in the window that opens. Your modification options will then be available when you click Custom reports, so you can run it again anytime with fresh data.

We’ll go into more depth about report customization in a future issue. For now, we encourage you to explore QuickBooks Online’s reports and their modification options so that you’re familiar with them and can put them to use anytime. Let us know if you have any questions about the site’s reports, or if you need help making your use of QuickBooks Online more effective and productive.

Small Businesses Facing Labor Shortages

February 17, 2022 by Admin

Two Businesswomen Meeting In Office Small business owners cite the unavailability of workers as one of their biggest challenges1. The labor shortage means that employers cannot, in some circumstances, operate at full capacity and must forgo some revenue opportunities. Businesses may have to delay planned expansions or the addition of new products or services because of the scarcity of workers.

Employers understand that having a skilled, trained, and committed workforce is key to growth and profitability. In the competition for a decreasing pool of skilled employees, employers have to assess their current hiring practices, identify any deficiencies, and develop and implement policies that help ensure that they can hire the employees they need when they need them.

Here are some issues employers need to consider when developing a strategy to attract and retain key employees.

Sharpen Your Hiring Process

Use every available tool. If you are not using social media to reach out and contact potential hires, you are not taking advantage of a very helpful medium. Social networks like LinkedIn and Facebook can be productive resources. They can be particularly effective if you ask family members, friends, and current employees to reach out and talk up job opportunities with your company on the sites they frequent.

Posting available positions prominently on your company website can also be effective in reaching out to a pool of potential hires. Traditional avenues, such as headhunters and employment agencies as well as radio and television ads, remain helpful.

Revisit Your Compensation

Some industries, such as information technology, pay more in wages and benefits than other traditionally low-paying industries, such as food services and retail. Still, if the job opening you want to fill is critical to the future growth of your business, you may want to consider paying above market salary if you can afford to do so. You may even have to get into a bidding war with other employers.

The reality is that employees with in-demand skills typically command a premium salary. Before you make a prospective employee an offer, find out how much other employers in your area pay for similar jobs. One place you can find useful employment and wage statistics is the Bureau of Labor Statistics website (bls.gov). The BLS information covers most geographical areas in the United States and is broken into type of occupation as well as various levels within that occupation.

Rethink Benefits

Most employees look for health care coverage, paid vacation days, and an employer-provided retirement plan. If you can’t be competitive with these benefits, you may have to step it up with others. Think of offering employees the chance to work remotely for a few days a week if it is feasible with your business’s operations. Consider summer hours, employer-provided snacks and drinks, and casual dress days.

Coping With a Labor Shortage

Not every incentive has to have a price tag attached. Non-monetary awards — from recognizing an “employee of the month” to a heartfelt face-to-face expression of gratitude for a job well done — can be remarkably constructive and can leave a lasting impact on employees. Inexpensive incentives can include gift certificates, cash spot awards, and even extra paid vacation days.

Offer Training

While costly, offering courses and educational opportunities that can help employees advance in their area of expertise is a potent way to attract ambitious, committed employees. Courses that develop well-rounded team players who can take on other roles within your business are especially cost-effective in the long run.

Consider Incentive Plans

Incentive plans reward employees for their achievements and create a sense of accomplishment. Plans can be used on a one-time basis or as an ongoing program. Some incentive plans include:

Annual incentive plan: Rewards for this type of plan are tied to expected results that are identified at the beginning of the performance cycle.
Discretionary bonus plan: The owners/managers determine the size of the bonus pool and the amounts that will be given to individuals after a performance period. Typically, payouts from this type of plan are not guaranteed, nor is there a predetermined formula.
Profit sharing plan: A profit sharing plan allows employees to share in their employer’s profits. Such plans typically include a predetermined formula for allocating profit shares among participating employees and for distributing funds accumulated under the plan. Some plans are tied in with the employer-provided retirement plan and some plans are discretionary.

Work With Your Financial Professional

Structuring an effective compensation and incentive package can be a complex and time-consuming task. The help of an experienced financial professional can be invaluable during every stage of this undertaking.

1″The America Works Report: Quantifying the Nation’s Workforce Crisis,” U.S. Chamber of Commerce, June 1, 2021.

Small Business Taxes: Who Pays What?

January 18, 2022 by Admin

Group of people having meeting and disscusing There are various federal taxes that may apply to your small business. The type and form of business you operate determines what taxes you must pay and how you pay them. At the federal level, several different taxes may apply.

Excise Taxes

The IRS defines an excise tax as a tax imposed on the sale of specific goods or services, or on certain uses. Federal excise tax is typically imposed on the sale of items such as tobacco, fuel, alcohol, tires, heavy trucks and highway tractors, and airline tickets. Many excise taxes are placed in trust funds for projects related to the taxed product or service, such as highway or airport improvements.

An excise tax may be imposed at the time of import, sale by the manufacturer, sale by the retailer, or use by the manufacturer or consumer. Some excise taxes are collected by a third party, which then must remit the taxes to the IRS in a timely manner. An example of a third-party collector of an excise tax is a commercial airline, which collects the excise taxes on airline tickets that are paid by airline passengers. Businesses that are subject to federal excise taxes must generally file Form 720, Quarterly Federal Excise Tax Return. Certain excise taxes, such as those owed to the Alcohol and Tobacco Tax and Trade Bureau, are reported on different forms.

Income Taxes

Income taxes must be paid on business profits. How that tax is paid depends on how the business is structured. Most small businesses are pass-through entities, which means that the business’s profits or losses are passed through to the owners and reported on their personal income tax returns.

Partnerships and multi-member limited liability companies (LLCs) generally file a partnership business tax return for informational purposes only. The individual partners and LLC members pay income taxes for their share of the income of the business. Note, however, that some LLCs elect to be treated as a corporation for tax purposes.

An S corporation files an S corporation income tax return for the business. Like a partnership, an S corporation’s net income is divided among the owners, who pay tax on their share of that income individually.

A sole proprietor reports business profit or loss on a separate schedule filed with the sole proprietor’s individual income tax return. Unless an election to be treated as a corporation has been made, the owner of a single-member LLC also reports the company’s profit or loss directly on the owner’s return.

Social Security and Medicare Taxes

Employers must generally withhold Social Security and Medicare taxes from their employees’ wages and must pay a matching amount. Employers must also withhold the 0.9% additional Medicare tax on employee wages and compensation that exceeds a threshold amount.

Self-Employment Taxes

Self-employment tax is a Social Security and Medicare tax primarily for individuals who work for themselves. It is similar to the Social Security and Medicare taxes paid for other workers.

Federal Unemployment Tax

Employers are required to report and pay the Federal Unemployment Tax Act (FUTA) tax separately from federal income taxes and Social Security and Medicare taxes. FUTA tax is not withheld from wages; employers are responsible for paying the tax.

Business owners should exercise extreme care when it comes to paying taxes since any mistakes on their part could result in significant penalties. For assistance, consult a tax professional.

8 Accounting Tips Every Small Business Owner Should Know

December 3, 2021 by Admin

As a small business owner, you probably think about tracking expenses and keeping up with tax deductions, but these aren’t the only critical accounting tips you should know. Whether you’ve been in business for a while or you’re a new start-up entrepreneur, read on for our 8 best accounting tips.

1. Outsource your bookkeeping.

For every business, bookkeeping is critical. This essential task is keeping organized records of your business’s income and expenses. If you’re like most small business owners, bookkeeping isn’t in your primary skillset. And even if it is, you probably don’t have time to crunch numbers and keep records. By outsourcing this critical task, you will free up your time; put this vital function in a professional’s capable hands and check one business owner-related stressor off the list.

2. Keep accurate records.

In addition to having someone overseeing your bookkeeping, it is up to you as the business owner to make sure you keep accurate records for your business. For example, you’ll need to account for:

Gross receipts are sales, deposits, credits, recipes, invoices, etc.
Expenses include all receipts, canceled checks, or anything else that shows the cost of doing business.
Fixed assets should be recorded so that annual depreciation can be calculated.

Pro tip: For tracking receipts, you may want to use a receipt scanning app on your smartphone. It makes it easy to scan and store receipts electronically instead of maintaining a large paper file.

3. Keep an accurate inventory.

Keeping accurate inventory records provides you with current data that reveals whether you can take on client requests or additional projects with inventory on hand and when you need to order stock. It also helps you identify trends over time and make basic predictions about your business operations. All of these factors allow you to plan and strategize about your business. This ability is critical to developing and maintaining a small business over time.

4. Separate personal and business accounts.

The most important reason to keep your personal and business accounts separate is taxes. As a business owner, you can deduct expenses like travel and office supplies; however, you must provide supporting documentation for these expenditures to claim them. Lumping personal expenses in with business expenses makes a tedious mess of separating expenses and could knock you out of some deductions. It is best to have a separate line of business credit, separate credit cards, and a separate bookkeeping system to be safe.

5. Have (and maintain) a budget.

You should have developed a budget when you created your business plan to make projections about revenue and expenditures. But beyond that, you must maintain a working budget at all times. This approach helps you stay on track with what you spend versus what you take in, and it provides accountability so that if you do get off track with your spending, it is readily apparent and can be corrected quickly.

6. Work with a tax professional.

When the average business owner attempts to complete their taxes, it costs them about 40 hours in valuable time. And even then, chances are, a professional’s help will be needed to ensure the business is getting all the deductions to which it is entitled. So why not start with a pro? After all, tax preparation fees are a tax-deductible business expense.

7. Plan ahead.

When a small business implements the accounting tips on this list, it allows for planning with accuracy. Accuracy is the key term. Anyone can guess what might happen, but only with accurate records and observations about business patterns can you confidently make targeted predictions. For example, a small business that tracks income and expenses can detect patterns that reveal the best time for large investments and expenses.

8. Monitor business performance with financial statements.

Again, we cannot emphasize the importance of logging income and expenses. It helps in the day-to-day operation of your small business and provides information about overall business performance. For example, income statements help your business determine profit or loss, a balance sheet shows assets and liabilities, and a cash flow statement shows how much money goes in and out of your business in a given time, as well as how much cash remains. These types of financial statements are also imperative when asking banks and investors to secure financing or funding.

With these eight tips, you can keep your small business on track, establish valuable patterns of business behavior, and make sound financial decisions for your business’s future.

If you would like help with some of these accounting tasks, contact us now.

Why Business Structure Matters

November 20, 2021 by Admin

When you start a business, there are endless decisions to make. Among the most important is how to structure your business. Why is it so significant? Because the structure you choose will affect how your business is taxed and the degree to which you (and other owners) can be held personally liable. Here’s an overview of the various structures.

Sole Proprietorship

This is a popular structure for single-owner businesses. No separate business entity is formed, although the business may have a name (often referred to as a DBA, short for “doing business as”). A sole proprietorship does not limit liability, but insurance may be purchased.

You report your business income and expenses on Schedule C, an attachment to your personal income tax return (Form 1040). Net earnings the business generates are subject to both self-employment taxes and income taxes. Sole proprietors may have employees but don’t take paychecks themselves.

Limited Liability Company

If you want protection for your personal assets in the event your business is sued, you might prefer a limited liability company (LLC). An LLC is a separate legal entity that can have one or more owners (called “members”). Usually, income is taxed to the owners individually, and earnings are subject to self-employment taxes.

Note: It’s not unusual for lenders to require a small LLC’s owners to personally guarantee any business loans.

Corporation

A corporation is a separate legal entity that can transact business in its own name and files corporate income tax returns. Like an LLC, a corporation can have one or more owners (shareholders). Shareholders generally are protected from personal liability but can be held responsible for repaying any business debts they’ve personally guaranteed.

If you make a “Subchapter S” election, shareholders will be taxed individually on their share of corporate income. This structure generally avoids federal income taxes at the corporate level.

Partnership

In certain respects, a partnership is similar to an LLC or an S corporation. However, partnerships must have at least one general partner who is personally liable for the partnership’s debts and obligations. Profits and losses are divided among the partners and taxed to them individually.

5 QuickBooks Online Reports You Should Run Regularly

October 20, 2021 by Admin

There 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.

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.