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

Hi Experts,

I need some help in balancing out my HST Account. In particular, for one period, I spent more than I made, and CRA posted a CR of $5.05 to my account, towards my HST Balance

The issue is when I filed this particular return within QB, it posted the $5.05 to my Receiver General - A/R, opposed to reducing my A/P, in order to balance out with CRA. For this transaction, I located the following Journal Entry under Receiver General (vendor), not A/R.

Journal Entry
When I try changing the second line to A/P with the Receiver General (Vendor) as Name, I get

QB Warning
Based on this error, I also assume that I cannot DR A/R and CR A/P.

How can I fix this, and bring the $5.05 into my A/P? I'm using QB 2012

Thank you.
0
Become a Microsoft Certified Solutions Expert
LVL 12
Become a Microsoft Certified Solutions Expert

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

Hello using quickbooks pro 2012 version I clicked on something that has made my blank checks half the width of my screen.  The font is fine it is the blank check form itself.  It was the full width of the quickbooks screen but now is only the left half of the screen.  Any ideas on what I clicked or how to get it back to full width?
0
I'm upgrading to a new server at an accounting firm and had a question about multiple years of QuickBooks.

In the past, I've always set up the server with each year of QuickBooks configured as the database server only.  There's no need to actually run the application on the server.  Because it is an accounting firm and some clients have older versions of QB, they need to be able to access the different years.  With my old approach, there are multiple instances (different years) of the QB service.  While this doesn't appear to cause problems, I generally like to simplify when practical.  I'm thinking that a simpler approach may work.

They don't need multi-user access for any of the files except for some current (QB 2018) ones.  My thought is that I don't have to install the database server for the older years.  If someone opens the file, their local copy of QB can manage it as a single user with no issues.  If this is the case, I can just install the QB 2018 database server and leave the other years alone.

Am I on the right track or do I really need to install the older ones?
0
I currently implemented a technology from cdata software (cdata.com)  that replicates tables from QuickBooks (contractor version 18) to SQL (screenshot attached) and, I'm now in the process of trying to create an accounts receivable report based off of the newly replicated data.

Do any of you experts know which tables (presumably credit memos and invoices) and data in those tables I will need to get proper AR data? I'd like to be able to see the current AR, 1-30, 31-60, 61-90, 91+ days past due, if possible.

Thank you all, in advance!!

CDATA_REPLICATION.png
QuickBooks_Tables.png
0
QuickBooks Enterprise data file issues--when we run Verify and Rebuild data we are getting errors; errors range anywhere from 4 or 5 (may 20018) to 1000's (June/Jule/2018). The last time I was able to run a Verify and a Rebuild without any errors was on 5/29/2018. I saved that file and put it in a backup folder with other backup files that also passed both rebuild and verify. Since that date all files that I try to run Verify and Rebuild error out at some point in the process, some in the verify and other in the Rebuild. Each time these have failed I have sent a the requested report to QuickBooks yet they have never responded to those reports nor acknowledged receiving them when we have called to try to get these errors resolved.  We are now to the point where their support is telling us we have to start a new file because the fixes they have been trying to make over the past 2 months are not working. So before I agree to this I wanted to check with EE to see if I have other options because they are also saying our corrupted file with all our history cannot be saved even though they say that all the unlinked transaction causing these problems are from data created in 1998/99 and 2000 and 2001 and 2002. So my question is this this--can the file be saved by exporting/saving all data from the last 10 years only? Can the last 10 years be removed from the existing "corrupted file" and then see if removing 10 years of data can then allow for repairs to what is left? Ideally we …
0
I have a customer that is running Quickbooks Desktop 2011.  (I think it is time to Upgrade!)  Just one user.  The QB file lives on the server.  She is getting an error that says: "Company File Error.   The disk or drive containing x:\sduncan\qbdata\qbfile.qbw is full.  In order to create more space, you need to remove some files.  After you remove the files, retry your operation."  
The network drive has plenty of space.
Any ideas why this error?  I searched Intuit and didn't really find anything.
0
QuickBooks - all versions - DB Mgr issues and MultiUser mode plus simple access to a company file on a Server.

I've read article after article and  they all give the same solutions over and over - which of course are valid.  Open ports on firewall, exclude AV from scanning QB folders, share permissions, etc.
Although QB is a fantastic accounting program for the small business, its data structure and sharing is something else.  We have QB database mgr installed on servers ranging from Microsoft 2008/2012/2016 domain controllers with Microsoft DNS, dedicated QB member servers (No DNS), Windows 7/10 PCs with DB mgr, etc.  All experience the same issues over and over.
The problem:  Either cannot switch to MultiUser mode or cannot access a specific company file.

Our solutions, depending on which platform QB DB Mgr is installed on is basically to perform a "Scan" from the DB Mgr and once its complete, all is good.  Of course on DC's we have to stop DNS (or modify QB to look at other ports that don't conflict) or restart the QB service or just do the scan.  We do find that if we open the QB program on the DB Mgr server and open a company file, there is never an issue but that is not something you can leave because certain functions require QB to be in single user mode to perform.  Even if we disable any firewalls on the DB servers we still get issues.  Many times, on standalone servers, running the Scan to search for company files give a network error.  Most of the time we …
0
Hey Guys,

I am trying to public Quickbooks 2018 APP on RDS hosted on 2012 R2 Standard server.
Currently there is Outlook 2013 and Remote desktop connection which are successfully published.
There was Quickbooks 2017 that was published earlier but I removed it as I installed the latest version of quickbooks 2018
which I now want to publish.

Under my current collections, under RemoteAPP program I tried publishing it but it gives me an error saying the app cannot be published.

Status: Failed: Could not create a published application instanced on the server  server.domain.local.

It still for some reason adds to the list of Remote APP Program box. Screen shot:

Capture.JPG

Just to test I tried publishing calculator but same error. I could not find any errors entries in event log on this server.

When user logs on to the web portal for RDS, they only see Outlook 2013 and RDP shortcuts. I did tried rebooting server
but still the same.

What am I missing ? Are there additional steps those I need to take ?  This is the first time I am attempting publishing the app.

Thanks
0
Hi Experts,

My QuickBooks company file is damaged and not opening. Please help me to fix the problem. I have tried QuickBooks file doctor but didn't work.
0
After being hit with Ransomware, restoring from backup, and reinstalling applications as needed, I can't get the Quickbooks Database Server services started or the Quickbooks Database Server Manager to run. When I browse for files and 'Start Scan", it attempts to start the services after browsing the files, finding Quickbooks files. It claims the folder in which the company files live isn't shared. I guess that's technically true, but the directory one level up IS shared, so it's possible to browse to it from a network share. Then it tells me it is attempting to resolve Networking issues, and tells me after that to resolve network issues and try again later (not the exact syntax, obviously).

I have tried installing just the bare server (what we had done in the past), installing the full version of Quickbooks (2016 for the moment), uninstalling, rebooting the server (2008 R2), reinstalling just the database server, using the Quickbooks clean boot utility, disabling ALL firewalls (Kaspersky and WIndows Firewall), I can't get the QBDbMgrN to start and stay started. I can't get the QuickbooksDB26 started. For some reason it claims to be a service that should be started manually. I don't recall that having been the case in the past.  Also,  I don't think the QuickbooksDB26 ever disappeared, even after a clean install (using the Clean Install tool), an uninstall, and/or a reboot.

Previous to the ransomware, the server had Quickbooks 2015 and 2017 database servers installed. …
0
Fundamentals of JavaScript
LVL 12
Fundamentals of JavaScript

Learn the fundamentals of the popular programming language JavaScript so that you can explore the realm of web development.

I have two flash that I am using to back up Quick books.  Each night I use "1" drive and the next night I use "2" drive.  The problem is, Quickbooks always uses the same drive letter to do it's backup.  However, Windows assigns a different drive letter each time I insert the different drive.
This problem also exists with sync back software.  If the backup drive is assigned "E" and I take the backup drive out, then the next time I plug it in, Windows might assign it a different drive letter and so Sync back can't back up until I manually assign it the same as before.  
 Is there a way to force windows 10 to keep the same drive letter to both drives?
0
I have a customer with Quickbooks 2016 and is needing to print out all the invoice clear back to January 1 of 2015.  Is there a way to do this in a batch form instead of manually printing off invoice by invoice?
0
.  This computer needs to host quickbooks, standard basic office apps will be installed and used on it; and other computers will sometimes remote desktop into it.   This computer is obviously overkill but we want Dell RAID 1 controller redundancy.  Is there a more reasonable Dell spec with real significant saving to be had.  I'm not just saying let's reduce quantity in these items to save a couple hundred bucks.  I'm thinking RAID redundancy but more like a $1000 dell tower.  PS - We do need the dual display port video card included.  Anyway, your thoughts?

Dell Precision Specs
0
I am trying to start using the Quickbooks Web Connect Import. The problem is it isn't reading the entire line description. It will only read the first initial of the name. I believe it stops after so many characters.

About 75% of our transactions are through Chase Quickpay. The transactions look like this "QuickPay with Zelle Payment to Richard Smith" when we use the import, all quickbooks read is "QuickPay with Zelle Payment to R"

Then they create a rule for this... which then assigns any quickpay to a vendor with first initial "R" to Robert Smith.

Is there a way for it to read more characters? I do see the rest of the link in the "Bank Memo" but it doesnt' seem to read those with rules.
0
I'm looking for alternatives for accessing QuickBooks Enterprise remotely.  I'm looking to upgrade a server that is currently in a workgroup environment. It's a Multipoint Server, so does not require Active Directory for RDS functionality.   The users need full functionality of QuickBooks, so QB Online not really an option.  

Since Multipoint is long gone, Windows Server Standard is the only option, necessitating AD for RDS functionality.  The user base really isn't large enough to justify a Domain Controller and AD, but there is a need to access QuickBooks out of the office.  Currently 7 QuickBooks users, with the possible addition of 1-2 more in the  near future.  So, I was wondering if something like Cisco Webex or something similar is a viable alternative?

The other issue is installing QB Desktop on the 7 users PC's and accessing the Company File via mapped drive.  What's the performance hit likely to be?

Thank-you for your input.

T
0
Need some help with remote users and QuickBooks database manager. I am running QB database manager on a Dell PowerEdge and using a TZ300 SonicWall for the vpn. remote users are connecting to the network via NetExtender. They are connecting great, they see all the network files and folders. They even see the QB database files fine. The problem is when opening QB it freezes after entering the password. QB opens you can select the company to open but after password, nothing. Anyone have any ideas? I'm sure its a setting on the SonicWall that needs set. A firewall access rule or something. Any ideas would be greatly appreciated.
0
Quickbooks 2018 runs in Safe Mode but crashes on startup in Normal Mode.  

We have a client with three Dells that will crash Quickbooks 2018 on startup in Normal Mode, but will run it fine in Safe Mode.  They are all running Windows 7 Pro 64-bit, and have AMD video cards.  (I mention this because I found an article suggesting that these issues might be due to AMD video card drivers.)  Two are Optiplex 7010s; one is a Precision M6700.  There is also Nobilis / Equus workstation with an i3, using Intel onboard video, and it runs QB 2018 without issue.  

All of these computers have earlier versions of QB installed, all of which run fine.  The problem exists whether running under the local user account (which is an administrator) or the local administrator account.  (There is no domain.)

If I run Windows in selective startup (or if I run Windows in Normal Mode with just the services that were enabled in Safe Mode), QB 2018 still crashes.  

I have done repair installs of QB 2018.  I've uninstalled and reinstalled it.  I recall reading that something with the Dot Nets could cause this issue, so I completely removed all Dot Nets, then reinstalled them by running the offline installer or by running the QB installer.  No change.

The error in the event log states:

Faulting application name: qbw32.exe, version: 28.0.4001.2806, time stamp: 0x598ca36d
Faulting module name: ucrtbase.DLL, version: 10.0.10586.212, time stamp: 0x56fa10f1
Exception code: 0xc0000417
Fault …
0
how can we out to this problem if you are facing corrupt or damaged quickbooks error?
0
A potential small accounting client called and asked about setting up the following scenario:

They want to have their clients remote into a server, then log into Quickbooks to work on their own data. There might/would be multiple clients remoted into the server at any given time working on their own individual QB files. There are currently 10 clients, but that list would be fluid.

The potential client currently has no server, so the whole thing would need to be set up from scratch. Are we talking about a Terminal Server running under hyper-v on a Server 2016 host? VPN or SSL VPN connections using a business class router? Licensing?

Have never worked with Terminal Server/Remote Desktop Services, so am not familiar with all the bits and pieces needed to set this up..if it's possible.

Once I identify all the necessary pieces, I can put together a quote for them.

Would appreciate any and all pointers!

Thank you!
Mark
0
Exploring SharePoint 2016
LVL 12
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Client is a busy Coffee Shop that uses QuickBooks Desktop Enterprise 2017 in the back office.  They used to use Quickbooks Payments, and they’ve changed to another, from Vantiv.  Now they’re struggling with getting their credit card transactions from Vantiv into Quickbooks, with the same level of detail they enjoyed with syncing Quickbooks Payments.  

How do we link Quickbooks and Vantiv, to make “importing” credit card transaction detail into the Undeposited Funds possible?
0
I have a customer that has a shop laptop and an office desktop.  He has quickbooks on both computers.  The Office computer is where quickbooks files are kept (ie Public>public documents>intuit)
we had both computers set up as a homegroup and then the shop computer was map-networked to the public folder on the shop comptuter.   Everything was working fine until last night when the customer took the laptop home.  This morning, when he tried to re-connect, quickbooks could not find the quickbook files on the office computer.  When I came there, the home group somehow had been removed on the shop computer and after getting home group going on that computer, I still could not see the public folder from the shop laptop.  I can only see documents, pictures, music, & video files.  What am i missing or doing wrong?
0
We use Quickbooks on a Remote server that our employees use Remote Desktop to access.  The setup works great for the most part, but we run into periodic printing issues that are fixed by rebooting the server.

I am thinking this is somehow related to the Quickbooks QBPRINT.QBP file, and the fact in our peak times we have 10-12 people on the server using Quickbooks.

The issue we run into happens periodically but I am unable to find a specific process that starts it.  Generally, when 1 person tries to print, they'll get an error saying the "File is already in use... " (and I think that's the QBPRINT.QBP file.  Once that error shows, no one will be able to print moving forward and we need to reboot to fix.

Any known issues or limitations that may be causing our issues?   Any setup or work-arounds that we need to implement to fix?

I'm not an expert in this area but is there some way to setup that file for multi-access or setup some type of spooling?  It seems perhaps the timing may be an issue with everyone using the system at the same time.
0
I am using Quickbooks Enterprise in multi mode on my network. The Database manager and files are all stored on a local server. When I am on my LAN everything works great. I am trying to use my Sonicwall/ Netextender vpn connection into my LAN. I connect fine and open files and folders on the server no issue. I launch Quickbooks, select the company to open and sign in with username and password. Thats when Quickbooks locks up and stops responding. Anyone have any ideas on this one? The only thing I cant get to work on the vpn is Quickbooks.
0
One of our companies uses QuickBooks 2011 accounting software.

An employee accidently closed the year by choosing the "Year End Copy" option when backing up the database. Is there a way to re-open the year?
0
We are trying to clone a client's machine that has Quickbooks and Quickbooks Point of Sale 2013. We are cloning from a old 80GB Seagate SATA drive to a NEW Crucial 250GB SSD using Acronis True image. The clone "successfully" finishes and we can boot the system with the SSD. The issue arises when we open MS Office or Quickbooks and it asks for a re-activation. Normally not a problem but  it alarms the customer who would like to do this to another machine that has had the HDD replaced many times (long story). In addition the original 100GB drive also ask for activation and can not find the POS files after the clone is done. This also happens on the SSD, but we believe that it is linked to what is causing the activation issue. Again, this aggravates the customer as we assured that the original drive will be untouched ( and it was ) but can not find any reason for this. we have resolved the POS issue.

My question is: Is there any absolute way that this can be done that not cause re-activation, or makes sure that the drive is a 100% true copy of the original?
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
<
Monthly
>