How to Create Product Records in QuickBooks Online

Whether your company sells product or services, QuickBooks Online can help you track them.

If you sell one-of-a-kind products and can see all of them at a glance, tracking your inventory isn’t such a big issue. But not many people run businesses like that. Even if you do, you’d want to keep track of what you have and what you’ve sold for accounting purposes.

Most businesses sell multiple types of products and stock numerous units of them. These companies need to be able to easily add them to invoices and sales receipts. They need to know what’s selling and what’s not, and they need to know when it’s time to reorder.

QuickBooks Online’s recording and tracking tools meet all of these requirements by allowing you to create records for services. Here’s how it works.

Getting Ready

Before you can start working with QuickBooks Online’s product records, you should make sure that the site is set up for this purpose. Click the gear icon in the upper right, then Your Company | Account and settings. Click the Sales tab to get to the Products and services section, as pictured below.

QuickBooks tipsQuickBooks Online’s Account and Settings has a section devoted to Products and services.

Click on Products and services to open your options here. To turn any entry from On to Off, or vice versa, click in the box at the beginning of the line to check or uncheck it. To see an explanation of each, click on the small circled question mark. When you’re done here, click Save. Then click the X in the upper right to close this window.

Creating Records

To start entering product and service data in records, click the gear icon in the upper right, then select Products and services. Since you haven’t entered anything yet, the table will be blank. Eventually, it will contain data for each record you’ve created. You’ll also notice two colored circles at the top of the screen, one marked Low Stock and the other, Out of Stock. When there is a number next to either of them, you’ll be able to click on either circle to see a list of what’s low or what’s out.

Click New in the upper right. A vertical panel will slide out asking what kind of record you want to create. You can choose from:

  • Inventory – Physical items you sell whose quantity you want to track
  • Non-inventory – Products you buy or sell but whose quantities you don’t need to track
  • Service – Services you sell, like legal representation or landscaping
  • Bundle – A group of products and/or services that are sold together, like computer training and accompanying software

We’re going to create an inventory item, so click on Inventory. Type its Name in that field and add a photo if you’d like. If the product has been assigned a SKU, enter that in its field. You may want to divide your products into primary categories and sub-products or services (like Writing Instruments and PensPencilsMarkers, etc.). You can skip this option if you don’t.

QuickBooks tipsQuickBooks Online helps prevent product shortages.

In the next section, you’ll enter the Initial quantity on hand. How many do you have as of (current) date? And where do you want to set your Reorder point? What number of items remaining should trigger the Low Stock alert so you can replenish your supply?

Inventory asset account should already be set at Inventory Asset. Enter a brief Description and then the product’s Sales price/rate (the price you’ll charge customers) and leave Income account set at Sales of Product Income. Then select a Sales tax category. If you haven’t set up sales taxes in QuickBooks Online and believe you’re required to pay them on at least some sales, please let us help.

In the Purchasing information field, enter the description that should appear on purchase forms, then Cost (the price you paid to buy the product, if any). The Expense account should be Cost of Goods Sold. Select a Preferred Vendor if you’d like and Save the record.

Not all fields are required in your product and service records, but we strongly recommend you complete each record as thoroughly as is possible.

Next month, we’ll look at how product and service records are used in QuickBooks Online. In the meantime, please let us know if there’s any way we can help with your accounting or your use of QuickBooks Online. We know these are challenging times for you, and we hope you’ll use us as one of your resources.

SOCIAL MEDIA POSTS

Before you can start recording sales in QuickBooks Online, you’ll need to create product and/or service records. We can help with this and show you how.

Did you know QuickBooks Online’s settings need to be tweaked before you can use the site properly? Product records is one of these areas, and we show you here.

Did you know QuickBooks Online can warn you when it’s time to reorder products? Let us help you set up this important function.

If you haven’t explored your company’s sales tax requirements, we can show you how QuickBooks Online tracks this necessary information. Read more here to get started.

What To Know About Getting a Tax Refund

All taxpayers are no doubt hoping for a refund this year. Unfortunately, there are a lot of myths about when and how you’ll get your refund.

In a recent statement, the IRS noted that most taxpayers are issued refunds by the IRS in fewer than 21 days. If yours takes a bit longer, here are six things that may be affecting the timing of your refund:

  • Security reviews – The IRS and its partners continue to strengthen security reviews to help protect against identity theft and refund fraud. Your tax return may be receiving additional review, which makes processing your refund take a bit longer.
  • Errors – It can take longer for the IRS to process a tax return that has errors. Fortunately, electronic filing has reduced the number of errors, which are more common in paper returns.
  • Incomplete returns – Here again, electronic returns make the most sense. It takes longer to process an incomplete return. The IRS contacts a taxpayer by mail when more info is needed to process the return.
  • Earned income tax credit or additional child tax credit – If you claim the earned income tax credit (EITC) or additional child tax credit (ACTC) before mid-February, the IRS cannot issue refunds as quickly as others. The law requires the IRS to hold the entire refund. This includes the portion of the refund not associated with EITC or ACTC.
  • Your bank or other financial institutions may not post your refund immediately – can take time for banks or other financial institutions to post a refund to a taxpayer’s account.
  • Refund checks by mail – It can take even longer for a taxpayer to receive a refund check by mail. Direct deposit is a better bet.

In an unusually poetic statement, the IRS explains that “tax returns, like snowflakes and thumbprints, are unique and individual. So too, is each taxpayer’s refund.” So keep this in mind. Fortunately, you can track your refund status online by entering your Social Security number and other key information.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Are Opportunity Zones an Opportunity for You?

Created by the TCJA in 2017, opportunity zones are designed to help economically distressed areas by encouraging investments. This article contains an introduction to the complex details of how these zones work.

The IRS describes an opportunity zone as “an economically-distressed community where new investments, under certain conditions, may be eligible for preferential tax treatment.” How does a community become an opportunity zone? Localities qualify as opportunity zones when they’ve been nominated by their states. Then, the Secretary of the U.S. Treasury certifies the nomination. The Treasury Secretary delegates authority to the IRS.

The Tax Cuts and Jobs Act added opportunity zones to the tax code. The IRS says opportunity zones are new, although there have been other provisions in the past to help communities in need with tax incentives to spur business.

The new wrinkle is how opportunity zones are designed to stimulate economic development via tax benefits for investors.

  • A Qualified Opportunity Fund is an investment vehicle set up as a partnership or corporation for investing in eligible property located in a qualified opportunity zone. A limited liability company that chooses to be treated either as a partnership or corporation for federal tax purposes can organize as a QOF.
  • Investors can defer taxes on any prior gains invested in a QOF until whichever is earlier: the date the QOF investment is sold or exchanged or Dec. 31, 2026.
  • If the QOF investment is held longer than five years, there is a 10 percent exclusion of the deferred gain.
  • If the QOF investment is held for more thhttps://docs.google.com/spreadsheets/d/1oZBP2cixeXawW6ec7xh_Z6xpZEi2ZXpBUjaHV7_uT68/edit#gid=737633902an seven years, there is a 15 percent exclusion of the deferred gain.
  • If the QOF investment is held for at least 10 years, the investor is eligible for an increase in basis on the investment equal to its fair market value on the date that the QOF investment is sold or exchanged.
  • You don’t have to live, work or have a business in an opportunity zone to get the tax benefits. But you do need to invest a recognized gain in a QOF and elect to defer the tax on that gain.
  • To become a QOF, an eligible corporation or partnership self-certifies by filing Form 8996, Qualified Opportunity Fund, with its federal income tax return.

The first set of opportunity zones covers parts of 18 states and was designated on April 9, 2018. Since then, there have been opportunity zones added to parts of all 50 states, the District of Columbia and five U.S. territories. More details are available on the U.S. Treasury website. Or see the IRS website for more information

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

The Ongoing Problem: Abusive Tax Shelters

As long as there have been taxes, shady promoters have tried to sell taxpayers on schemes to get out of paying their fair share. Learn about abusive tax shelters, and how to recognize and avoid them.

Tax avoidance? Accelerating tax deductions, deferring income, changing one’s tax status through incorporation, and setting up a charitable trust or foundation. All of these are legal tax shelters.

Tax evasion – that’s a different story. In tax evasion, you plan to reduce tax payable through illegal means. Abusive tax shelters reduce taxes, promoting the promise of tax benefits with no meaningful change in your income or net worth.

Turns out that in the 1990s, because penalties were too small to have a deterrent effect, tax shelters became quite popular to cushion one-time large capital gains. But these days, the tide has turned against promoting abusive tax shelters. Today, Treasury regulations and IRS rules dealing with tax shelters note that certain types of transactions will no longer pass muster.

The bottom line? Talk to a professional about legitimate ways to reduce your tax burden. Don’t go to some shady guy your brother-in-law knows, or follow advice in a book written by someone with no distinguished credentials such as “CFP,” “CPA” or “JD” after their names. Various trusts can help with long-term tax planning. And even modest families can legally game the tax system with such vehicles as IRAs, 401(k) plans and 529 plans.

Just in case you’re already considering something not too kosher, note that the IRS has its Dirty Dozen list of tax scams – schemes that encourage the use of phony tax shelters designed to avoid paying what is owed. The IRS warns that you could end up paying a lot more in penalties, back taxes and interest than the phony tax shelter saved you in the first place.

Don’t Try This at Home

One such tax scam on the IRS radar is abusive micro-captive structures: crooked promoters persuade owners of closely-held entities to participate in poorly structured or illegal insurance arrangements. For example, coverages may insure implausible risks, fail to match genuine business needs, or duplicate the taxpayer’s commercial coverages. Premium amounts may be unsupported by underwriting or actuarial analysis may be geared to a desired deduction amount or may be significantly higher than premiums for comparable commercial coverage, according to the IRS. It’s all in the name of illusory tax savings. So only work with qualified professionals.

There is a fine line between legitimate tax avoidance and illegal tax evasion. The IRS says it won’t hesitate to impose penalties on both participants and promoters of abusive tax shelters. Tax fraud convictions can mean fines or even prison. In brief, if something sounds too good to be true, it probably is.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Steps for Reconciling IRS Form 941 to Payroll

Form 941 is a crucial tool for ensuring your payroll data is accurately reported to the government and for balancing payroll in general. Get insight into reconciling Form 941 with your payroll on a quarterly and a year-end basis.

Most employers must report employees’ wages paid and taxes withheld plus their own share of certain payroll taxes quarterly to the IRS. Additionally, employers must report each employee’s wages and taxes annually, on Form W-2, to the Social Security Administration. Employers use Form 941, Employer’s Quarterly Federal Tax Return, to report income taxes, Social Security tax or Medicare tax withheld from employees’ paychecks and to pay their portion of Social Security or Medicare tax.

In the end, the information on your quarterly 941s must match your submitted Form W-2s. By reconciling your 941 forms with your payroll, you can verify the accuracy of these filings. For best results, reconciliation should be done on a quarterly and a year-end basis.

Quarterly 941 Reconciliation

Step 1: Run a payroll register for the quarter. The register should show wages and deductions for each employee during that quarter.

Step 2: Compare the data on the payroll register with your 941 for the quarterly period.

Areas to check are:

  • Number of employees who received wages, tips or other compensation.
  • Total compensation paid to employees.
  • Federal income tax withheld from employees’ wages.
  • Taxable Social Security wages and tips.
  • Taxable Medicare wages and tips.
  • Total tax payments made for the quarter, including federal income tax, Social Security tax and Medicare tax withheld from employees’ wages plus your own share of Social Security and Medicare taxes.

Step 3: Fix discrepancies as soon as you find them. For example, you might need to correct the employee’s wages and taxes in your payroll system and file an amended Form 941 for the quarter with the IRS.

Year-End 941 Reconciliation

Step 1: Run a report that shows annual payroll amounts. Compare those figures with the totals reported on all four 941s for the year.

Step 2: Make sure the amounts reported on all the 941s for the year match the respective data fields for your W-2 forms.

For example:

  • For compensation, compare Line 2 of all your 941s with Box 1 of your W-2s.
  • For federal income tax withheld, compare Line 3 of all your 941s with Box 2 of your W-2s.
  • For Social Security wages, compare Line 5a Column 1 of all your 941s with Box 3 of your W-2s.
  • For Social Security tips, compare Line 5b Column 1 of your 941s with Box 7 of your W-2s.
  • For Medicare wages, compare Line 5c Column 1 of your 941s with Box 5 of your W-2s. Also, make sure your total Social Security and Medicare taxes for the year are correct.

Step 3: Perform the necessary adjustments. For example, you may need to file a corrected W-2 form with the SSA and/or an amended 941 with the IRS.

As you can see, this form can get complicated, so it’s a good idea to get professional help with it.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Social Security: Note the Key Changes for 2020

The Social Security Administration has released new numbers for those paying Social Security and those collecting it. Check out the new maximum taxable earnings amount as well as COLA and other key adjustments.

Every year, the Social Security Administration takes a fresh look at its numbers and typically makes adjustments. Here are the basics for 2020 — what has changed, and what hasn’t.

First, the basic percentages have not changed:

  • Employees and employers continue to pay 7.65% each, with the self-employed paying both halves.
  • The Medicare portion remains 1.45% on all earnings, with high earners continuing to pay an additional 0.9% in Medicare taxes.
  • The Social Security portion (OASDI) remains 6.20% on earnings up to the applicable taxable maximum amount — and that’s what’s changing:

Starting in 2020, the maximum taxable amount is $137,700, up from the 2019 maximum of $132,900. This actually affects relatively few workers; the Society for Human Resource Management notes in an article that only about 6% of employees earn more than the current taxable maximum.

Also changing is the retirement earnings test exempt amount. Those who have not yet reached normal retirement age but are collecting benefits will find the SSA withholds $1 in benefits for every $2 in earnings above a certain limit. That limit is $17,640 per year for 2019 and will be $18,240 for 2020. (See the SSA for additional information on how this works.)

Cost-of-living adjustments

Those collecting Social Security will see a slight increase in their checks: Social Security and Supplemental Security Income beneficiaries will receive a 1.6% COLA for 2020. This is based on the increase in the consumer price index from the third quarter of 2018 through the third quarter of 2019, according to the SSA.

detailed fact sheet about the changes is available on the SSA site.

Payroll Taxes: Who’s Responsible?

Any business with employees must withhold money from its employees’ paychecks for income and employment taxes, including Social Security and Medicare taxes (known as Federal Insurance Contributions Act taxes, or FICA), and forward that money to the government. A business that knowingly or unknowingly fails to remit these withheld taxes in a timely manner will find itself in trouble with the IRS.

The IRS may levy a penalty, known as the trust fund recovery penalty, on individuals classified as “responsible persons.” The penalty is equal to 100% of the unpaid federal income and FICA taxes withheld from employees’ pay.

Who’s a Responsible Person?

Any person who is responsible for collecting, accounting for, and paying over withheld taxes and who willfully fails to remit those taxes to the IRS is a responsible person who can be liable for the trust fund recovery penalty. A company’s officers and employees in charge of accounting functions could fall into this category. However, the IRS will take the facts and circumstances of each individual case into consideration.

The IRS states that a responsible person may be:

  • An officer or an employee of a corporation
  • A member or employee of a partnership
  • A corporate director or shareholder
  • Another person with authority and control over funds to direct their disbursement
  • Another corporation or third-party payer
  • Payroll service providers

The IRS will target any person who has significant influence over whether certain bills or creditors should be paid or is responsible for day-to-day financial management.

Working With the IRS

If your responsibilities make you a “responsible person,” then you must make certain that all payroll taxes are being correctly withheld and remitted in a timely manner. Talk to a tax advisor if you need to know more about the requirements.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

Family Loans — Tax Considerations

Obtaining financing to start or expand small businesses and buy homes can sometimes be difficult. If your child or grandchild is having a hard time getting a loan from a commercial lender, you may be willing to help out by lending the money yourself. Another thing you might need to consider is a debt consolidation for payday loans in case you have more than one loan.

Have a Written Agreement

Start by putting the loan agreement in writing. This may seem like an unnecessary formality, but without a written loan document, the IRS could argue that the transaction was a gift instead of a loan, potentially creating gift tax issues.

Having written documentation is also important in case the borrower fails to repay all or part of the loan. In that situation, you’d want to be able to show you’re entitled to write off the unpaid amount as a nonbusiness bad debt.

Charge Adequate Interest

The second step is setting an interest rate. While there’s no rule against interest-free loans or loans that have below-market interest rates, in a family context they can lead to tax complications. If you don’t charge sufficient interest, the difference between the amount of interest you actually receive (if any) and the amount you should have received — referred to as “imputed” interest — is taxable to you.

You can avoid the imputed interest rules by charging interest at the appropriate “applicable federal rate” (AFR). The IRS publishes AFRs monthly for loans of different maturities. These rates have been relatively low recently, reflecting the current market interest rate environment. For example, in November 2019, the annual AFR (using a monthly compounding assumption) was:

  • 1.68% for a short-term loan (three or fewer years)
  • 1.59% for a mid-term loan (more than three but no more than nine years)
  • 1.94% for a long-term loan (more than nine years)

These are the minimum rates for intra-family loans initiated in November 2019. For a term loan, the rate can remain fixed for the life of the loan. For a demand loan (one that gives you the right to demand full repayment at any time), you have to charge a floating AFR to avoid imputed interest issues.

Exceptions

When you lend your child or grandchild no more than $100,000, the amount that can be added to your taxable interest income under the below-market interest rate rules generally can’t exceed the borrower’s net investment income. Even better, you won’t have to report any imputed interest if the borrower’s net investment income amounts to $1,000 or less. You can also sidestep imputed interest on small loans of no more than $10,000 (all outstanding principal) provided the borrowed funds aren’t used to buy or carry income-producing assets.

 

Worker Classification: Pay Attention

It isn’t easy deciding whether a worker should be treated as an employee or an independent contractor. But the IRS auditors will look at the distinction closely.

Tax Obligations

For an employee, a business generally must withhold income and FICA (Social Security and Medicare) taxes from the employee’s pay and remit those taxes to the government. Additionally, the employer must pay FICA taxes for the employee (currently 7.65% of earnings up to $137,700).*

The business must also pay unemployment taxes for the worker. In contrast, for an independent contractor, a business is not required to withhold income or FICA taxes. The contractor is fully liable for his or her own self-employment taxes, and FICA and federal unemployment taxes do not apply.

Employees Versus Independent Contractors

To determine whether a worker is an independent contractor or employee, the IRS examines factors in three categories:

  • Behavioral control — the extent to which the business controls how the work is done, whether through instructions, training, or otherwise.
  • Financial control — the extent to which the worker has the ability to control the economic aspects of the job. Factors considered include the worker’s investment and whether he or she may realize a profit or loss.
  • Type of relationship — whether the worker’s services are essential to the business, the expected length of the relationship, and whether the business provides the worker with employee-type benefits, such as insurance, vacation pay, or sick pay, etc.

In certain cases where a taxpayer has a reasonable basis for treating an individual as a non-employee (such as a prior IRS ruling), non-employee treatment may be allowed regardless of the three-prong test.

If the proper classification is unclear, the business or the worker may obtain an official IRS determination by filing Form SS-8, Determination of Worker Status for Purposes of Federal Employment Taxes and Income Tax Withholding.

Year-End Statements

Generally, if a business has made payments of $600 or more to an independent contractor, it must file an information return (Form 1099-MISC) with the IRS and send a corresponding statement to the independent contractor.

Consequences of Misclassification

Where the employer misclassifies the employee as an independent contractor, the IRS may impose penalties for failure to deduct and withhold the employee’s income and/or FICA taxes. Penalties may be doubled if the employer also failed to file a Form 1099-MISC, though the lower penalty will apply if the failure was due to reasonable cause and not willful neglect.

Correcting Mistakes

Employers with misclassified workers may be able to correct their mistakes through the IRS’s Voluntary Classification Settlement Program (VCSP). For employers that meet the program’s eligibility requirements, the VCSP provides the following benefits:

  • Workers improperly classified as independent contractors are treated as employees going forward.
  • The employer pays 10% of the most recent tax year’s employment tax liability for the identified workers, determined under reduced rates (but no interest or penalties).
  • The government agrees not to raise the issue of the workers’ classification for prior years in an employment-tax audit.

Your tax advisor can help you sort through the IRS rules and fulfill your tax reporting obligations. *Internal Revenue Service. For 2020, the Social Security tax rate is 6.2% and is applied to earnings up to $137,700. The Medicare tax rate is 1.45% on the first $200,000 and 2.35% above $200,000.

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).

What’s Taxable to an S Corporation Shareholder?

S corporation shareholders have an added reason to worry about their company’s annual performance: It has a direct impact on their own income taxes.

How It Works

Unlike a regular C corporation, an S corporation usually doesn’t pay federal income taxes itself. Instead, each shareholder is allocated a portion of the corporate income, loss, deductions, and credits on a special “K-1” tax form. The shareholder then must report the items listed on the K-1 on his or her personal tax return.

The K-1 allocations are based on stock ownership percentages. So, for example, if an S corporation has $100,000 of taxable business income for the year, a person who owns 75% of the stock in the corporation would be allocated 75% of that income, or $75,000.

This scheme can get complicated thats why we recommend the accountant Sydney services to help you in the process. Case in point: The K-1 may show more income than the shareholder actually received from the company during the year. That’s because the K-1 figure is based on the corporation’s actual taxable income — not on the distributions made to the shareholder.

Here’s an example: Tom starts a new corporation, electing S status. In the first year, Tom draws a $30,000 salary and receives no other distributions from the company. The company’s ordinary business income (after deducting his salary) is $10,000. Since Tom is the only shareholder, all the company’s $10,000 of income is allocated to him on his K-1. Tom must include both the $30,000 of salary and the $10,000 on his personal income tax return, even though all he actually received from the corporation was his salary.

This result seems harsh, but it’s not the end of the story. Special rules in the tax law prevent the same income from being taxed again. Essentially, Tom will be credited with already having paid taxes on the $10,000 so that any future distribution of the funds will not be taxable.

Tracking Basis

To determine whether non-dividend distributions are tax free, S corporation shareholders must keep track of their stock basis.* The computation generally starts with a shareholder’s initial capital contribution (or the stock’s cost if it was purchased) and changes from year to year as the shareholder is allocated corporate income, loss, etc. Non-dividend distributions that don’t exceed a shareholder’s stock basis are tax free.

Note that S corporation shareholders may be eligible to deduct up to 20% of their S corporation pass-through income. Eligibility depends on taxable income and other factors. S shareholders will want to consult their tax advisor to see if they can take advantage of the deduction to lower the taxes on their business income.

*Most distributions made from an S corporation are non-dividend distributions. Dividend distributions can occur if the company was previously a regular C corporation (or in other limited situations).

 

…from the Team of Professional at RE-MMAP We are just a click or call away. www.re-mmap.com and phone # (561-623-0241).