QuickBooks

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 want to import an invoice into Quickbooks Online, however I have a few specifications that are not working.
1. I want to separate the time and expenses. So the time will be under the normal category and then under the reimbursable will be all the expenses.
2. We have a contract amount column, which would be set at the beginning of each customer, then should carry out to all the invoices for that customer.
3. Prior Billed which would detect the totals that have been previously invoiced.
4. Total billed column that would tally all the that has been billed for that category thus far as well as the current billed.

Attached is a sample of our invoice. Is there anyway to make this invoice as a template in QBO?
Sample-Invoice.docx
0
On Demand Webinar: Networking for the Cloud Era
LVL 9
On Demand Webinar: Networking for the Cloud Era

Did you know SD-WANs can improve network connectivity? Check out this webinar to learn how an SD-WAN simplified, one-click tool can help you migrate and manage data in the cloud.

there's a couple 'items' (really comments / information) that I put on each invoice.  I have them set as items in the items list  and choose them each time I make an invoice.  Tedious!  (things like 'don't forget - we offer this service or that service....'  It's a few lines of text.

Is there a way to have an item already in an invoice when making a new one (control N or similar).  Yeah, there's a comment box at the bottom of the default invoice templates, but the verbiage for these items I want to add is just too much - that box would be  bigger than the items area : )   and that text is on each page. I just need to have the info show 1x on the invoice.
0
I have a very odd situation for which I'm looking for assistance.

I have a client with a server running Server 2012 R2 Essentials.  They use WSE RemoteApp to allow remote users to access QuickBooks Enterprise 16.  This works fine for several users, except for one who just recently started having problems.  He can connect to the server and log into QuickBooks, but QB will abort moments later with an Unrecoverable Error.  The Code is 19758  66888.  I'm not finding anything online about that error.

What is particularly odd about this is that it only occurs with this one computer.  I try the same thing on another computer running the same version 1703 (and build) of Windows 10 Home, from the same location (have tried 2 different locations), using the same login and QuickBooks credentials with no problems.

I have installed a new hard drive in the laptop and reinstalled Windows 10 from scratch and the same symptom occurs.  The BIOS and drivers are up to date with no errors.

When I reinstalled Windows, I did copy user data (Documents, etc.) from the old drive.  I thought that might somehow be the issue, so I created a new user on the computer.  It shows the same error.  Both users are local admins.

The only common element with the failures is this specific computer.  The error is coming from QuickBooks.  I'm not seeing how something in this computer can cause the application error in the host computer.

I added a new Windows user on the server as well as a new QB …
0
A customer of mine has two computers - both running windows 7 pro, service pack one and with quickbooks point of sale installed.  
yesterday, the server and the client suddenly stopped working.  The server is working fine now, but I cannot get the client to work.  When I attempt to open point of sale, it starts to open and then stops with everything grayed out.
Since everything is grayed out. I un-installed and re-installed the the program, but that didn't help.
I also set the two computers as a home group and set up a map-drive, but since everything is grayed out when POS is opened up, I can't point it to the file on the server.  Can someone help me with this issue?
I have attached a capture of what it looks like when it stops loading.
It appears that it cannot find the server, but I did a ping both ways and that checks out fine
The computer gave no issue when I set up a map-network drive-that worked fine also.
Capture.PNG
0
Have lot of quickbooks files and have no issue opening but 1 file. the same file can be opened by other users. what can be the issue. this screen pops up
SnipImage.JPGwindows 10, quickbooks 2016, the files are on server 2008
0
Hello, we have a client that has single user QB 2016 running on their PCs.  Their company files are stored on a Dell server.  If their company files are stored on the server, does that mean, the QB Management console and SQL database engine are running on the server too?  Thanks.
0
What are the tax implications for being paid on a 1099 (All Inclusive) basis?

Does this mean that I as the employee will have to pay both my share as well as the employer's share of the social security tax?

Are there any other additional or higher taxes that have to be paid by me while being paid on a 1099 basis as opposed to a W2 basis?
0
Hello all,
This one baffles me and I have no idea what to do.
Have a client that is having a problem in the item list in Quickbooks.  When she goes to search for an item(like MUGS) when she types in an M it goes to the M.  When she types in a U instead of going to MU it goes to the U's.  When she types in a G instead of going to MUG it goes to the G's .
I have removed all unnecessary columns on that view.  Didn't help.
I changed the screen size from 1920x1280 down to 1024x768 but that didn't help.
Did a re-sort of the item list (and all other lists).  That didn't help.
Did the latest QB update but that didn't help.
Did the latest Windows updates but that didn't help.
I am not sure what else to do to fix this.
Any help would be greatly appreciated.
Thanks,
Kelly W.
0
Hi,

We use multiple user QB in my office. All pc and QB are up to date. But the same username and password for the same company file only works for a particular pc. If we are trying to use the same password on the admin pc (the pc hosts the files), we keep getting password error.

Any ideas?  thanks
0
Hello everyone, pleas help me in setting up quick books server and database. What are the requirements? Currently its installed on one of standard workstation. I recently join this company and admin i IT. Please help and advise me. I have to transfer all this data to server. Please give me all requirements list so that can setup quick books database efficiently. Thanks.
0
On Demand Webinar - Networking for the Cloud Era
LVL 9
On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Network 1gb the main computer is wired with 1gb , a couple of wired computers and some wireless tablets that has AC Access Point.

What can I do to make it faster?

Just move to SSD hard drive? or there are other ways?

The main computer has windows 10 with a regular hdd.
0
Tomorrow I will be replacing two computers (easy), and replacing their server that runs quickbooks pro 2010 and is their DC for about 5 computers.
Their server is server 2003, the new server is 2012 essentials.

What is the best way attack to this?

I was thinking replace the two computers first and don't join to domain just yet.
Upgrade quickbooks to 2017 desktop pro on the old server.
Then start to set up the new server. Transfer the quickbooks files over after it is set up.

Is there a best way to do this?

Any help appreciated.
0
I am coordinating the build of a MS Access DB with some SQL and VBA on the backend that uses data from the Quickbooks (v17) SalesOrderLine Data to manage a production workflow system for a small parts manufacturing company.  All data comes from the SalesOrderLine table exclusively. I am looking for a Unique identifier in that table to use as a filter for various sorting and prioritizing purposes.  I have not been able to locate such a field in the SalesOrderLine Table.  

The application is functioning well with one component dependent on this unique field value.  I hope to deploy in production fairly quickly.  We are in UAT testing now and learned that this one piece needs resolution.

QB has two fields labeled FQPrimaryKey and another FQTxnLinkKey but neither are unique. Is there a possible line count within the sales order that I can add to a record TXNID that would make it Unique? Some other avenue to pursue?

Does anyone have any experience or suggestion relevant to this area of QB specifically?   If so, would you please share your thoughts and/or solutions?
0
I am repairing a part of an MS Access database where I need only the first part of a field from data pulled from QODBC Quickbooks.
QB Table SalesOrderLine.  QB Field ItemSalesOrderLineItemRefFullName].  Our data syntax is nnnnn-xx.  I want returned only the five digits and assign a Column name.  I am a novice attempting to repair someone elses work.  Suggestions please?

My select query works fine until I needed to parse out the first 5 characters in that field. The results will be placed into a form in the same MS Access DB.
0
QuickBooks is not letting me to register on Windows 10- just installed the 2011 version on Windows 10 and keeps crashing
0
Hi Experts,

I need to access a previous Sales Tax report, but when I do, I get the attached.

I don't understand why, because I have Adobe Acrobat Reader DC, File Version 17.009.20044.25828 installed on my Win 7 and use it daily.  Whats wrong?

Any help is  appreciated.
QB-PDF.png
0
I have Quick books 2014 and need to have it on 2 computers. It opens find on the first computer but on the second computer it wants to change the password every time we login. How do I get around this problem? I have it set to multiple users. Both computer are windows 10.
Thank you.
0
I have a client for whom QuickBooks 2017 (Local copy NOT network version) is failing to load under Windows 10 Pro. It previously worked just fine. Recently AVG anti-virus was installed which corrupted the networking connections. AVG was uninstalled and networking resumed as normal.

An uninstall and reinstall of QuickBooks has not resolved the problem. QuickBooks support has essentially given up on the issue. Have tried it under safe mode ... same problem ... fails immediately upon starting to load up.

Any ideas? Seems only option is a complete reformat and install of Windows 10 pro and all software including QuickBooks. Not looking forward to that!

Regards, Dave Melnyk
0
I know, Quickbooks might be easier, but the wait will kill you.

Just updated a customer from Qbooks 2013 to 2014.  Everything went great.  One problem.  Their checkbook register has defaulted back to a starting entry of 03/01/15.  I backed up everything (and made spares of those).  I captured the .QBW and the .QBB's going back a year (most current today).  I did the restore of the company file and that works fine, but the checkbook register is as I mentioned earlier.

What am I missing?
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE
LVL 4
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

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

We have a system that was upgraded to Office 2016 from 2010.  We thought this issue may have been PC related so we built a new PC with Windows 10 and Office 2016 fresh installed.   The problem duplicated itself.  Here is the info:

Anytime an invoice is sent from Quickbooks 2017 using Outlook 2016, the email gets an Undeliverable message moments later with the following:

Your message did not reach some or all of the intended recipients

530 5.7.0 Authentication required


We are using MDaemon Outlook connector 4.0

I have checked the connector settings and SMTP Server requires authentication is checked and use same authentication as incoming server is checked.  

All other emails work fine.  Only emails sent through Quickbooks are an issue.
0
Hello everyone,
I was asked to set up email sending on Quickbooks 12.0 Contractor.  The user is using Office 365.  I tried to follow the steps as noted in this article https://community.intuit.com/articles/1501520-set-up-your-email-service-in-quickbooks-desktop, however there is no option to select Outlook and when I try webmail, I put in smtp.office365.com and ports 25 and I have also tried 587.  There is no where to put in a user name or password in the box either which confuses me more.  I think that this user may need to upgrade, but I am wondering if anyone has any sort of workaround or suggestions.  Thanks
0
Installed Quickbooks 2017 and installed the DB Manager on the 2016 Server.

It keeps kicking users out of multi-user mode and only allows Single User.

I keep having to stop the DNS Servcie and re-run the Scan and when everyone can get in

Kick the DNS Server back on again...

this is getting old.....

What is a Fix for the 2017 DB Manager using the Same Ports as the DNS Server.

I Wish to have Quickbooks change Not Microsoft Please.

Thanks

Cjoego
0
We have recently upgraded our Quickbooks multi-user  software from 2014 to 2017.  Since the upgrade, I have not been able to bet the multi-user function to work.  Nothing has changed with network (single server operating under Windows 2012 R2).  When starting up the database monitor, get an error message, "+Windows firewall: Connection sharing  not allowed".  I have verified that all firewall ports and  all qb programs have been adddwd to rhe exception rules,  I have even tried turning off the firewall, but still got error message.  Dies anyone have any suggestions?
1
Hi, I have a computer hosting the database server manager.

Quickbooks database server manager

I have my first client enabled for host mult-user access.   I mapped to the database server manager's share and I selected the following QBW file

Open a Company

However, I ran into this connectivity isssue with the QBW file on the client when contacting the server.

Problem with multi-user hosting setup
0
Hi,

I have been using Excel (Google Sheets) to manage my accounts / balance sheet for the last number of years.

- income with Tax breakdown on the left
- expenses with Tax breakdown on the right
- totals at the bottom

It works well for me, however I'm slightly concerned over how easy it is to update a cell in error with '10' vs '10000' without recognising it.

Can anyone recommend any software that provides the following:

- easy interface
- export for backup
- ability to duplicate line items (recurring expenses and income) so that when a recurring payment lands in my bank account, i can duplicate a previous record and update the date
- add note to each line item

Additional Benefits
- app
- receipt management

Thanks in advance for your help.
0

QuickBooks

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.

Top Experts In
QuickBooks