Toll-Free: +1-888-510-9198 [email protected]
Setting Up and Inventory Tracking in QuickBooks Online

Setting Up and Inventory Tracking in QuickBooks Online

Do you know the process to set up and track inventory in QuickBooks Online plus and advanced? Well, we can help you with that. QuickBooks Online has everything that you need in order to manage your inventory. You can track what’s on hand, and further get alerts when it is time to restock and check insights on what you buy and sell. Not just that, but you can also enter non-inventory products and services so that you can add them to the sales forms quickly. Well, this segment is curated to help you in successfully setting up and tracking inventory in QBO. Thus, make sure to stick around this segment or connect with our technical team at +1-888-510-9198, and our certified ProAdvisors will help you with your queries.

Note: The inventory features are available only for QuickBooks Online Plus and Advanced. Thus, if you have not upgraded to plus or advanced, then upgrade QuickBooks plan to start tracking your inventory.

Also Read: How to Change Service or Inventory Item Types in QuickBooks?

Steps to set up and track your inventory in QuickBooks Online

Step 1: Turn on Inventory tracking in QuickBooks

In case you haven’t yet, simply turn the settings so that you can add your inventory using the steps below:

  • The very first step is to head to the settings tab and choose account and settings
  • After that, choose sales tab
  • Now, select edit in the products and services section
  • The next step is to turn on show product/service column on sales forms
  • You can also turn on price rules in case you wish to set up flexible pricing for the things you sell
  • After that, turn on both track quantity and price/rate and further track inventory quantity on hand
  • The user will then have to select save and done

How QuickBooks handles inventory account?

QuickBooks considers the first items you purchase as the first items you sell. Accountants consider this method as first in, first out i.e., FIFO. In case you are not moving from average costing or a product that uses it, then let the IRS know you are switching to FIFO.

Step 2: Add your inventory products

You can simply add your inventory items along with other products and services you sell into QuickBooks. This further lets you quickly add them as line items to sales forms. The steps to add inventory, service items, and non-inventory are different.

Also Read: How to Turn off Sales Tax in QuickBooks Online 

Add products you want to track as part of inventory

You need to follow the steps to add inventory items. These are products you sell that let you set and track the product quantities.

Add products and services you buy or sell, but don’t track as part of your inventory

QuickBooks will not track quantities for these items:

  • Perform the steps to add service items. These are the services that you sell to the customers
  • Perform the steps to add non inventory items. These are the things that you buy or sell but don’t track as inventory
  • Carry out the steps to create bundles. These bundles let you group multiple products or services together.

Step 3: Keep a track of what sells

After you set up all inventory products, track them when they sell. This can be done:

  • Create an invoice in QuickBooks, if you will get paid later
  • Now, add a sales receipt if your customer paid on the spot
  • Learn how to apply for QuickBooks payments

QuickBooks further decreases what’s on hand by the amount on the invoice or sales receipt.

Check what’s on hand and what’s on order as you work

You need to check what’s on hand and what’s still on order, as you work on an invoice, sales receipt, or another type of transaction. You simply need to hover your pointer over the quantity you entered for an item to check for more info.

In case you set reorder points, QuickBooks will also let you know when something’s running low. Also, in case you set a low stock alert, the software will let you know when something’s running low.

Set up and track your inventory in QuickBooks Online

Step 4: Restock your inventory

QuickBooks will tell you when it is the time to restock. You can order inventory right in QuickBooks. And further track what you get from vendors and what’s still on order. After you are done, the quantity on hand automatically increases by the number of items you get.

Step 5: Use Reports to Check Status of the Inventory

You need to access the reports to instantly see the best sellers.

Also Read: Fix Damaged Transactions in QuickBooks Desktop 

Conclusion!

Towards the end of this segment, we believe that the information discussed above might be of great help in setting up and inventory tracking in QuickBooks Online. However, if you have any queries, then connecting with our technical support team is suggested. We are a team of certified QB ProAdvisors who work round the clock to provide the best assistance. For more queries dial +1-888-510-9198.

Other Related Articles:

QuickBooks Credit Card Processing

Is QuickBooks Desktop Being Phased Out? 

Undeposited Funds in QuickBooks

Close Your Books in QuickBooks Desktop

Close Your Books in QuickBooks Desktop

Want to close your books in QuickBooks desktop? Well, this is now possible, as we have curated this segment sharing the complete steps that you can implement to close your books in QuickBooks successfully. You can close your accounting periods to ascertain that old invoices from invoice don’t accidentally update the old accounting periods in QuickBooks. It is possible to close your books at the end of every fiscal year. Also, QuickBooks creates automatic adjustments in preparing for the coming year. To find out the entire procedure to close books in QuickBooks successfully, make sure to read this segment. Or you can further get in touch with our technical support team at  +1-888-510-9198.

Read Also: How to Resolve QuickBooks Reporting Problems?

Year-end adjustments QuickBooks desktop makes automatically

QuickBooks Desktop carries out year-end adjustments based on the fiscal year start month. Let us understand that:

  • QuickBooks adjusts the income and expense accounts at the end of the year to nullify them and let the user start the new fiscal year with zero net income
  • QuickBooks further makes an adjustment entry to net income. Like, if the profit for the year was $12000, the equity section of the balance sheet shows a line for a net income of $12000 on the last day of the fiscal year
  • On the first day of the fiscal year, the QuickBooks increases the retained earning equity account by the previous year’s net income and decreases the net income by the same amount. This will start new fiscal year with a net income of zero.

Important Points to close books in QuickBooks Desktop

Before you close the books, keep a check on the following points:

Advantages to closing the books

Restricted access: The user can create a closing date password in order to restrict access to data from the prior accounting period, that includes the details of every transaction. The user needs to find out the closing date password and have the right permissions to modify or delete transaction in a closed period.

Reporting: Note that the changes made after the closing date to the transactions dated on or before the closing date show in the closing date exception report.

  • To run the report and move to the report’s menu
  • Furthermore, select the accountant and taxes and further select the closing data exception report
  • The closing date history shows the current and past closing dates and the user who set the closing date.

Also Read: Find QuickBooks License Number – Quick Steps

More about closing books in QuickBooks Desktop

  • Note that the closing entries are made after recording all the adjusting entries. And when the books are closed, the user isn’t supposed to enter any entry for the fiscal year.
  • There are certain programs that restrict the user from making any entry even if that entry corrects or makes the books accurate
  • QuickBooks lets the user to enter transaction that affect the balance of the closed fiscal year. But it either tells the user that it isn’t something we recommend or it will ask for the closing date password if you set up one.
  • QuickBooks doesn’t have an actual transaction for closing entries that it creates. After you run a report, the program computes the adjustments. However, the user can’t QuickZoom on these transactions. The adjustments are termed as closing entry.
Close books in QuickBooks Desktop
  • Note that closing entries are the entries made at the end of the fiscal year to transfer the balance from the income and expense account to retained earnings. The user aims at zero out the income and expense accounts, and then add the fiscal year’s net income to retained earnings.
Close your books in QuickBooks Desktop

Steps to close the books in QuickBooks Desktop

You can try performing the below steps to close books in QuickBooks easily:

  • Initiate the process by heading to QuickBooks and further click on edit and preferences tab
  • Choose accounting tab and select the company preferences tab
  • The user will then have to click on the set date/password tab.
Close books in QuickBooks desktop -set date
  • You need to enter the date you wish the books to be closed and set the password and click on ok tab
  • After that, the closing date will be set
  • No invoices edited prior to the particular date will sync into QuickBooks
  • If an invoice from the closing date or earlier syncs, you will get a notice to let you know that the period is closed
  • Lastly, the sync process is successful, though the invoice did not get updated in QuickBooks

You might find this helpful: Sign In to QuickBooks Online Account

Conclusion!

Now that you know what is the process to close books in QuickBooks desktop, it is time to implement the steps right away. However, if you fail to do so for some reason, then contacting our QuickBooks support professionals might help. You can dial our tech-support number i.e.,  +1-888-510-9198, and our certified QuickBooks ProAdvisors will help you with your queries.

Other Related Articles:

Fix Damaged Transactions in QuickBooks Desktop 

Connect Bank and Credit Card Accounts to QuickBooks Online

Deposit Payments into Undeposited Funds Account in QuickBooks 

Undeposited Funds in QuickBooks

Correct Cost of Goods Sold (COGS) in QuickBooks

Correct Cost of Goods Sold (COGS) in QuickBooks

Did you find incorrect COGS in QuickBooks Desktop when trying to make certain adjustments to profit and loss reports? Well, this error is not a common error, but lately has been reported by a few QuickBooks users. This error basically indicates a particular change in the cost of sold goods. Incorrect COGS can be a bit confusing error for QuickBooks users. Thus, to help you out, we have come up with this segment right here, sharing the complete procedure that can be performed to correct COGS in QuickBooks Desktop and also the reason behind incorrect COGS. 

Correct COGS in QuickBooks

Thus, to learn more about this issue in QuickBooks, make sure to read this segment carefully, or you can also consult our technical support team at +1-888-510-9198, for any sort of further technical guidance. 

You might find it helpful: Set up Landed Cost in QuickBooks Enterprise 

What leads to Incorrect COGS error in QuickBooks Desktop?

A bunch of reasons can cause incorrect COGS errors when working on profit and loss reports in QuickBooks. This includes: 

  • Incorrect cost of items being received can be a major cause behind incorrect COGS in QuickBooks Desktop 
  • Another reason can be if the COGS account employed by QuickBooks POS is wrong 
  • Or if the user buys large quantities and sells products one at a time.
  • If you removed the transactions mistakenly, then such an error might show up. 

Methods to correct COGS in QuickBooks 

Now that you know what can lead to incorrect COGS in QuickBooks, here are a few solutions that you can implement to fix it. Let us have a look: 

Method 1: Look for any deleted transactions 

You need to examine and locate missing transactions in QuickBooks desktop to simply verify if they cause incorrect COGS error. For this, you need to perform the below-discussed steps: 

  • Initially, move to the sales history section in QuickBooks POS 
  • Followed by, clicking on the I wish option 
  • The next step is to go for the financial details to display option 
  • Then, in case the financial information is sent to QuickBooks successfully, the status will show up, but if there is no option to access the file in QuickBooks, then the entry has likely been erased. 
  • You now have to resend the document available under the next financial exchange option if QuickBooks doesn’t contain the receipt. 
  • Once done with that, deselect the sent checkbox if any receipts show a not sent status and if the option to mark this document as successfully sent is opted. 
  • The last step is to click on ok and end the process. 

Also Read: Intuit Customer File Exchange – Upload and download files

Method 2: Delete any changes causing the incorrect cogs in QuickBooks error

You need to observe if there are any faulty changes. If there are any, you can try performing the below steps to delete any changes made. 

  • The very first step is to right-click any column header and select Customize columns 
  • Once done with that, you need to select inventory and go for quantity adjustment history 
  • The next step is to enter the incorrect amount in the diff cost column and also make necessary quantity adjustments after adding the diff cost to the choose column list
  • After that, you need to click on the save tab 
  • Also, double-click the edited entry and go for I want to, along with clicking on check it. 
  • You now have to follow the same steps to check the cost adjustments by opting to view the financial history
  • Open it in QuickBooks and then go for the inventory and finally click on the cost adjustment history
  • Any wrong alteration can be undone by the user, by simply clicking on I wish to and also opting for a reverse memo from Qty adjustment or cost adjustment history

Related Read: QuickBooks Update Unable to Add Item to List: Solutions

Method 3: Set up COGS account correctly 

In order to avoid the COGS error in QuickBooks, it is essential to correctly set up the cost of items and preferences sold in QuickBooks. If the account is set incorrectly, then one might have to choose the item list. And also select the correct COGS account corresponding to each item. 

Method 4: Fix the cost input of items to correct cogs in QuickBooks

You need to perform the below steps to double-check the input cost of items. The major cause of the error can be the incorrect entry of the cost items. This can be fixed by checking and configuring the input cost of the items. 

  • To begin with, you need to go for the column heading for the ext cost column. Also, match it to the item name
  • Also, note that the names of the items with a value of 0.00 or an inaccurate quantity, before moving on to the next stage. 
  • The next step is to click on the inventory and further click on the item list 
Profit and loss statement
  • After that, select each item and click on edit
  • You now have to take the number of items sold from the history report and multiply it by the item’s cost
  • Create a journal entry in QuickBooks and this would debit the inventory asset and credit the cost of goods sold for this amount. 

Also Read: How to Change Service or Inventory Item Types in QuickBooks?

Conclusion!

Coming to the end of this segment, we believe that the reader might be able to understand the reasons why the correct COGS in QuickBooks error shows up. Along with that, the measures can be taken to successfully culminate the issue. Just in case you come across the same issue again and again, then connecting with our QuickBooks technical support team at +1-888-510-9198 is suggested. Our certified ProAdvisors will ensure to answer all your queries immediately and make sure that you do not face the same error again. 

Other Related Articles:

Connect Bank and Credit Card Accounts to QuickBooks Online

How to Create, Edit, or Delete QuickBooks Memorized Transaction?

Resolve the Balance Sheet Out Of Balance In Accrual Basis

QuickBooks error 539 – Quick Fixes 

QuickBooks error 539 – Quick Fixes 

Trying to work on QuickBooks and suddenly bumped into QuickBooks error code 539? QuickBooks error code 539 is a common error that shows up on the screen stating: Error 539 – QuickBooks encountered a problem and needs to close. This is basically a runtime error that occurs in case you experience QuickBooks crashing. Other than that, QuickBooks error 539 can also be witnessed when printing tax forms and so it is termed as QuickBooks tax form printing error 539. This error not only interrupts the smooth workflow but also requires immediate fixes to ensure smooth workflow continuity. 

QuickBooks error 539

To help you tackle QuickBooks error 539, here we are with this segment sharing the complete set of steps to get rid of this issue in QuickBooks, along with the causes and signs of the error. Thus, make sure to stick around this segment carefully, or you can also consult our technical support team at +1-888-510-9198, and we will provide you with instant support and guidance. 

Also Read:

Signs and symptoms of QuickBooks error 539

Identifying the error code 539 becomes easy with the help of below signs and symptoms: 

  • The system becomes slow and gives delayed responses to user inputs 
  • An error message shows up on the screen 
  • QuickBooks and PC crash at the same time indicating the error 

What can trigger QuickBooks error 539? 

However, every error in QuickBooks is triggered due to some or other reason. But when it comes to QuickBooks runtime errors the reason isn’t definite. Usually, runtime errors in QuickBooks occur due to conflicting programs operating at the same time. It can further be experienced due to memory problems, a bad graphics driver, or a virus infection. Regardless of the reason, it is essential to fix the QuickBooks error 539 and other runtime errors immediately. 

Solutions to fix QuickBooks Error 539

Now that you know what can lead you to QuickBooks error 539, it is time to perform the necessary fix to this issue. Here are the solutions that can be performed to get rid of the error permanently. 

Solution 1: Graphics driver should be reinstalled 

Reinstall Graphics Driver

In case the graphics driver is not set up properly, then you might end up in QuickBooks error 539. In such a scenario, it is suggested to uninstall the graphics driver and get the correct version installed on the system to simply fix the error. 

  • Start by simply pressing the start tab 
  • Then, head to the device manager 
  • Now, search for the graphics driver option 
  • Click on Uninstall it 

Solution 2: Uninstall any suspicious conflict app 

In certain cases, any suspicious app running in the background can also trigger such an error in QuickBooks. Thus, uninstalling the conflicting apps might work in such cases. The steps involved here are: 

  • You need to first click on the start menu and then open the control panel 
  • After that, head to the programs and features tab within the control panel and then click on uninstall the program 
Uninstall conflicting app - QuickBooks error 539
  • The next step is to find any conflicting programs and uninstall it 
  • The last step is to restart your system and check if the issue exists. 

Solution 3: Download the latest tax table 

You need to perform the following steps to download the latest tax table.

  • The very first step is to head to the employees tab 
  • Once done with that, choose get payroll updates
Get payroll updates - QuickBooks error 539
  • The next step is to checkmark download the entire update and choose Download latest update option 
  • Then, after the tax table is set up, get QuickBooks restarted and examine whether the running problems shows up. 

You might find this helpful: QuickBooks Runtime Redistributable in QuickBooks Desktop 

Solution 4: Getting runtime libraries reinstalled 

It is recommended to get the Microsoft Visual C++ package reinstalled on the system. The steps involved in that case are listed below: 

  • You need to first open the control panel via the Windows start menu 
  • After that, choose the Programs and Features tab 
  • The next step is to look for the Microsoft Visual C++ redistributable package and then click on it. 
Uninstall Microsoft Visual C
  • Once done with that, click on the uninstall tab 
  • And after the uninstallation process ends, restart your system. 

Solution 5: Running the Disk Cleanup 

After the system gets over occupied cache and junk files, then such an error is probable to occur. In such a scenario, the solution to this issue is a disk cleanup tool, to simply free up space on the hard drive. The steps to be performed here are: 

Cleaning system junk with Disk Cleanup - QuickBooks error 539
Cleaning system junk with Disk Cleanup – Screenshot
  • The very first step is to head to the Windows start menu and then enter disk cleanup in the search bar 
  • Now, double-click the disk cleanup icon 
  • Within the cleanup window, go for C: disk and this will begin the scan and the cleanup process. 

Also Read: Fix Damaged Transactions in QuickBooks Desktop 

Conclusion! 

Toward the end of this segment, we believe that the reader might be able to successfully get rid of the QuickBooks error 539. Just in case the user is unable to fix the issue, or if there is any query remaining unanswered, then contacting our technical support team at +1-888-510-9198 might work. Give us a call and our technical sound certified ProAdvisors will address your queries immediately. 

Other Related Articles:

How to Fix Not Enough Space on Drive C: QuickBooks?

How to Rebuild and Verify Data Files in QuickBooks Desktop?

Configure Firewall Ports and Security Settings for QuickBooks

How to Fix QuickBooks Freezing Problem in Desktop?