Direct Connect online banking for Capital One will be discontinued
Capital One Bank will discontinue Direct Connect service shortly, after some delay from the date initially communicated. You need to have the latest QuickBooks patch and updated Bank Feeds settings to ensure smooth transition of your data from Direct Connect to Express Web Connect. We will update this article, and send an alerting email, when this change becomes active.
Note: You do not need to perform any of these steps until this article is updated, after the Express Web Connect is made available.
Inventory feature in QuickBooks Desktop can track the current number in stock and the value of your inventory after every purchase and sell the items to your customers. With QuickBooks Desktop Premier or QuickBooks Enterprise versions, you can even keep track of products you assemble and resell (finished goods), adding assembled units to inventory and deducting component units from inventory when you build assembly items.
To start with, you may want to be familiar with these basic steps related to questions about Tracking Inventory in QuickBooks:
1) To turn on Inventory: Go to Edit menu at the top > select Preferences > choose Inventory & Items > Company Preferences > checkbox “Inventory & Purchase Orders are active” > click OK.
2) Create Inventory Items: Go to Lists menu at the top > Items List > Select Item tab at the bottom > click Item (or drop-down arrow) and select New > Type = Inventory Part and create a new item.
These three fields are important to set up inventory items. See screenshot sample.
For COGS Account field = Cost of Goods Sold account type from the Chart of accounts
For Income Account field = Income account type from the Chart of Accounts
For Asset Account field = Inventory Asset account which is part of the Other Current Asset on the Chart of Accounts
You do not want to put in On Hand/Total Value info here.
3) For adding purchased Inventory items: Use Enter Bills under Vendor menu at the top or Write Checks menu under Banking at the top. Always use ITEMS tab, never Expenses tab.
4) For selling Inventory items: Create Invoice (or Sales Receipt). Use ITEM Code in the sales form. This will also automatically post COGS to P&L by reducing inventory counts.
If you need more info, you can always click HELP menu at the top and select QuickBooks Desktop Help and type INVENTORY HELP in the search field. If interested, you can also watch my famous how to inventory video tutorials on YouTube.
QuickBooks Desktop Part 10: Inventory – All you need to know about QuickBooks Inventory
Set up multi-user or network for QuickBooks Desktop
The following articles can help you get started if this is your first time to install and use QuickBooks Desktop in a multi-user or network environment. Follow the steps in the order shown below.
Installation and setup
Install QuickBooks Desktop
Add Windows admin rights to allow configuration of multi user access
Map a network drive (optional)
Configure Firewall and Internet security settings for QuickBooks Desktop
Set up the QuickBooks Database Server Manager and scan your file
Open a company file that is located on a remote computer
Note: If you are a new QuickBooks user, after installing Create a QuickBooks Desktop company file first before doing step 2.
Also, see helpful article:
How to Install QuickBooks Desktop
Export limitations when moving from QuickBooks Online to QuickBooks Desktop
If you’re considering exporting list and transaction data from QuickBooks Online to another version of QuickBooks, we’d like to provide you with some detailed information, just so you understand the capabilities and limitations of the process.
For export steps, use this article: Visual guide to export.
Important: Please take careful note of the limitations listed below for the various list names. Most export errors are due to list names that are too long. If you have any list names that are longer than the limits described here, you must edit the items and shorten the names before exporting.
Size Limitations: There isn’t a known limitation of File Size (MB) for any file generated through the export process. As long as your system has enough disk space, is setup to where it will not sleep, or turn-off while idle, you should be able to export all data. The only size limitations would be the limitations of the Desktop program that you are trying to convert to. For list and item limitations for Desktop products see INF12412.
Visual Guide to Export from QuickBooks Online to QuickBooks Desktop for Windows (Pro Premier)
If you’re looking to export your data from QuickBooks Online, here’s a quick visual guide for you to use.
If you’re having trouble installing the ActiveX control or getting error messages, or for more information on export, see article Exporting data with Internet Explorer 11.
Exporting is only supported from Windows computers running a 32-bit version of Internet Explorer 10 or higher.
Exporting data is only available for the US product at this time.
Mac Users: Exporting from QuickBooks Online to Quickbooks for Mac
You must be logged in as an admin user on both QuickBooks Online and Desktop for this process to work. Below is the image a non-Admin user will see when trying to export.
The maximum number of list entries (list limits and custom fields) for QuickBooks Desktop for Windows:
Max number of Items including inventory items is 14,500 for QuickBooks Pro and Premier. And it’s over 100,000 for Enterprise.
Here is each list in your company data file can contain up to a maximum number of list entries from QuickBooks.
List limit for QuickBooks Mac Desktop (applies to US only)
Looking for a QuickBooks Desktop trial to export or import into QuickBooks Online? See download link below.
Once you’ve downloaded the trial version for your region below, ensure it’s updated to the latest release for a smooth migration.
Note: You won’t be able to restore a company file with a QuickBooks Desktop version from a different region.
IMPORTANT: These download links are trials only and cannot be registered. If you try to register these products, the validation will fail and you’ll be locked out.
QuickBooks Desktop trials for the US
QuickBooks Desktop trials for Canada
QuickBooks Desktop trials for the UK
Download QuickBooks Pro 2012 trial link, click here.
Use the following license number and product number:
License number: 7482 – 8847 – 2621 – 492
Product number: 204 – 992
If you’ve prior versions (example 2008), you will first need to convert to 2010 and then migrate to the latest version.
Install the QuickBooks Accountant 2010 trial, and then restore your QuickBooks 2008 file from here. Just click on one of these direct links (according to your region) to start the download automatically:
QuickBooks Accountant 2010 Trial
QuickBooks 2012 Canada
Once you’ve restored your file in the QuickBooks 2010 version, proceed with opening it in the QuickBooks 2017 version or the latest version.