QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.

Share tech news, updates, or what's on your mind.

Sign up to Post


I am unable to get the Database Manager to run properly.  The error message is:

Network diagnostics failed, resolve errors and retry.

The only error listed is:  Windows firewall disabled exceptions not defined.  I disabled the built in firewall for now.  

If I open a user on this machine (the server) in multi-user mode (with or without the database manager running) then it will work fine in multi-user on all other machines.  But, if I don't, then multi-user cannot be used.

This is on a Windows Server 2016 Standard.  

I need to find a way to make this work properly.

Thanks. :)
Free Tool: IP Lookup
LVL 11
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.


I have an Employee that is unable to open a QuickBooks file. They get a "Missing name list problem", Quickbooks suggests to resort the list but how is that possible when we can't get into the file?
Hello experts,

Whenever I try to export reports to excel , it automatically change (duplicate) value of all entry. And most of the time it won’t even export. I am using multi user and we have 2 users and both are having same issue. I tried rebuilding data file but still having issue. I did quick book doctor scan and 0 issue found. Please help!
I am trying to do three part sync with my Synology Nas system.  I am using a windows 10 and 8.1 operating system.  Doing this so two people can share one file and update it as they both work on the same file to keep files up to date with both of there work.
I have tried everything i know and i can not get quicken 2017 home and business to install.  When it comes to the installing netframe 4.6.1 page (also on that page is install quicken 2017 and update quicken 2017) it hangs up.  hard to know what it is hung up on because the check boxes do not visually get advanced or checked.   I have manually gone to microsoft and installed 4.6.1 and 4.6.2 and on the progess bar it always hangs at the same spot.  I have tried runing as adminstrator and i have looked to delete what has already been installed but do not find where that has landed.  I do not see it in the x86 folder. i am running the latest version of Windows 10 64bit.
Any suggestions.  Thanks
As of Quickbooks 2017 R5 and Quickbooks 2018 I am getting a licensing issue in XenDesktop

Citrix says its a 3rd party application issue
Quickbooks says they don't support Citrix

We have been using Quickbooks in XenDesktop for years just recently having issues.

what i have figured out so far
installing all additional packageds with the quickbooks 2018 installation doesn't affect the licensing service.

once quickbooks is installed

A netstat will show the following missing

picaSvc2.exe  1494
picaSvc2.exe 2598

Event viewer doesn't show any errors

citrix event viewer shows license not available when users attempt to login
if you use rdp instead of citrix your able to function fine.
I am able to download transactions from our bank into a Quickbook file or a Quicken file (not CSV nor Excel).  I do not have either of the Quickbooks or Quicken software.  Is there any good way to import either type of file into Excel?

About 18 months ago I researched the difference between the online version and the desktop versions of QuickBooks.

It became apparent that the online version is a very scaled down subset of the desktop product,

I am wonder has there been any chance since?

I have a customer who has a really old version of QB , I think 2006, he is buying a new Laptop, latest version of MS Office, etc,  I thought that the online version might suit him as he spends a lot of time out off the office as he is a small builder. He spends a day in the office per week, the rest of the time he is on site managing small construction jobs, it might be useful for him to be able to access his QB quotes, ices, etc. Or to generate invoices while off site.

Nore, he is based in Ireland, and ideally the Onlive version would work for local taxes (Revenue, VAT, etc.)

When creating a "Summarize Payroll Data" report from Quickbooks to Excel, the "State Wage Listing" tab defaults to the wrong "Tax Tracking" filter.

It used to default to "SUI Company", but now defaults to "Medicare Additional Tax", and the desired outcome is that it defaults to "SUI Company" again. Office 2016 is used.

Intuit support provided varying feedback. One technician we spoke to seemed to know the issue and indicated a Microsoft Update might be responsible, other technicians weren't sure, or suggested we submit a feature request to the development team.

Has anyone come across this before, and found a solution?
Hello Experts,

I service a company that uses Quickbooks Enterprise 17 Wholesale & Manufacturing for everything. Starting in April they started having issues with their standard balance sheet report being out of balance. The detailed shows in balance when you run it though. I can repair and rebuild the file and it finds the same issues every night and fixes them in the rebuild. The balance sheet starts out fine in the morning but when they start doing invoices and inventory and such, it goes out of balance. It is never out of balance with the same amount. One day it could be $2000 and another day it could be $10k. I have ran the QuickBooks file doctor and it finds no issues with the file. I even force the data sync fix and it says the file is fine. All machines are new and running SSD's. There is no network latency from the workstations to the QuickBooks server. I even dedicated a windows 2012 server to being the QuickBooks server and it still did the same thing. The QuickBooks files are on a separate SSD drive and that's the only thing it has on it. They are running the latest version of QuickBooks Enterprise 17. I am at a loss.

Thanks in advance for the advice.
Concerto Cloud for Software Providers & ISVs
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

I have a user that occasionally uses Quickbooks hosted on another PC. When trying to open the company file it wants to do an update but gets stuck between 10 & 15%. I have performed a manual update, but am having the same problem when trying to open the file.

Thanks in advance for any assistance.
I need to customize a report that shows which Invoices paid which Purchase Orders in QB's 2017. I can't get one to show both Invoice Number and PO Number at the same time.
I cannot figure out how to get my invoices to display the employee for each time sheet it imports into an invoice and list that as a data column
I am able to import a bill successfully, the issue I am having is the RefNo which is the invoice number does not show up. I used different variations for the heading such as TRNSrefno, RefNo, RefNu so far its still showing blank. another issue is that the vendor address doesnt show up, its not a new vendor. Do I have to have the address in the iif file?
I am new to QODBC but not SQL.  I am trying to eliminate manual data entry for a special project for my company.

On every invoice in our system, or each "Item" on each invoice, there is text field called "Description".  I need to replace the text that is currently in the "Description" field with the text "service".  See attachment for an example.

I want to update every invoice in our quickbooks database like this.  We need todo this, because we have private information in that text field, and I need to provide a copy of my quickbooks database to a 3rd party.

What would be the QODBC code to accomplish this?  I am open to another method (besides QODBC).  I just need to get this done ASAP.  I have also posted a freelance job post on upwork to see if I can pay someone to code this for me.

Thank you ahead of time for your help.
We have approximately 105 employees we send pay stubs to bi-weekly.  When sending the pay stubs to everyone the application times out on a random person.  The report is started again from where we left off, sometimes it will finish and sometimes it times out again on another random person.  The person that it times out on never receives their pay stub.  Is there a setting or something we are missing that will eliminate the timeout.
In a retirement enclave we want to provide service for tenants to pay one invoice per month that contains rent and then all utilities as line items.  we're kinda using Customers section in a non-stand way entering properties as customers.   I am thinking a work-around would be to enter all phone#s as line item with number in comments.
Looking for a solution (cheap) to count inventory the fastest way possible.  Currently we have no scan guns or wifi in the warehouse.  We house at least 100,000 items.  What I would like is a scan gun that I can load an excel worksheet that has columns for our Item# (Barcode data), Description, Qty and fill ins for bin locations so pickers can scan what's there and it will save to the spreadsheet in the gun.  Added feature would be a fill in line for bin location so future picking would be easier for our pickers.

I can then download the spreadsheet and reconcile with our QB inventory.

Any advice Experts?
I have a customer on Quickbooks Enterprise16 and their company file is just over 1GB. They have some performance issues and there is only so much tweaking I can do on their network to increase the speed. Wondering what options I have. I looked at the 'Condense data' option, but they didn't like some entries going from detailed to a single entry. Figured the next step would be to have a new company file. Is there a way to create a new company file with say all data from the last 2 years?

Or maybe there is another approach? I'm a networking person by trade who knows enough to get Quickbooks networked and functional!

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Our office has QuickBooks 2011. We have recently started testing with the Thunderbird email client. The email configuration for QB give choices of Web Mail and QuickBooks E-mail. Our mail server is a self-hosted IMAP server, so I've picked Web Mail (even though it's not really webmail). I've selected "Others" as email provider (choices are Gmail, Yahoo, etc.) and put in the correct server name and port. See image, "Edit Email Info".

When I try to send a form, it prompts me for the password, repeatedly, but fails to send the message  (see image dialog marked "Email or Password is Incorrect"). On the mail server side I eventually (several seconds) get the message:

Feb  5 12:45:22 mail sm-mta[1982]: u15HhrrI001982: COMMON.hprs.local [] did not issue MAIL/EXPN/VRFY/ETRN during connection to MTA

Does anyone have any idea how to fix this?
I'm trying to build a spreadsheet to import customers from another application. I have QB2011. When editing addresses, the screen shows City, state,zip. Bbut when constructing the import using column specifications found here: http://support.quickbooks.intuit.com/support/pages/inproducthelp/core/qb2k12/contentpackage/thirdparty/excel/info_customer_required_fields.html?family=pro it doesn't list those as defined fields. It shows BILLING ADDRESS 1 - BILLING ADDRESS 5, and likewise for SHIPPING. Do ADDRESS 3, 4 and 5 correspond to city, state ZIP? Am I looking at the wrong web page for definitions? How to I set up a spreadsheet to import these fields?
Question: Whenever any of the Accounting employees (total of 3 including me) has worked with QuickBooks during the day, they are not able to log off of our computers at the end of the day because QuickBooks files are in use.

Now there is some tips online on the subject including using the QuickBooks as Muti-user, but the problem is it was working before as it was.

Sure we update to a newer version?

Any idea guys or shortcut?

All  the best
Set number of previous companies to increase to 8 or 10
I just upgraded to windows 10 and now I can not email PDF files with QuickBooks 2012 Pro.  Is there a solution for this?
we sell items and service in the QBPOS 2013. and charge on a customers account.
at the end of the day we do a financial exchange.
and all the account charges are issued as invoices to that customer. the invoices look neat with proper item names and item descriptions.

but when we create a statement. the Item column is empty and the description have the POS receipt # and the invoice # and the item names.

Item: Empty
Description: INV#6102
                  POS Receipt# 6151
                     ---910-87632876 #1371

is there a way when i create a statement to the customer, it lists all the items that they bought, and the description of them.

thank you


QuickBooks is an accounting software package geared mainly toward small and medium-sized businesses and offers on-premises accounting applications as well as cloud based versions that accept business payments, manage and pay bills, and payroll functions. QuickBooks includes remote access capabilities, remote payroll assistance and outsourcing, electronic payment functions, online banking and reconciliation, mapping features through integration, improved e-mail functionality, import from Excel spreadsheets, employee time tracking options, pre-authorization of electronic funds and new Help functions.