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

Starting a new year with QuickBook 2018

My accountant uses QuickBooks and provided me the 2017 QB file  used to file my taxes. So, I need to create a new empty file for 2018 where I can start to log my expenses.

I need to maintain all the accounts and configurations she may have done, but want 2018 to be a blank slate.

Is there an option for this in QB?

Thanks
0
Learn Ruby Fundamentals
LVL 12
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

My client has Quickbooks 2018 Enterprise installed and recently switched email provider service to Office 365. I set them up to use the new email host in the QB settings but now it won't let them send email reports outside their domain. They can email them to themselves, but when it's being sent externally it gives a network connection error.
0
Greetings!

We want to start a new QB's file in Enterprise 2018 given the instability of our current database file.

Currently, the customer is using 2017 Enterprise Edition.  I have created a new file in 2018 and have imported all the lists.  Inventory is a major concern, there are over 3000 items and it looks like the price and cost have transferred, but not quantity on hand.  Is there a way to migrate that data outside of contracting a third party?  How about from Excel?

Thanks.
0
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
Site to Site VPN using Quickbooks Desktop and Quickbooks POS.  
I do not see why multiple Quickbooks POS desktops at different locations over a Site to Site OpenVPN would not work.  Quickbooks sales is stating so but it feels like they just want to sell larger more expensive multi-store licenses.

Does anyone have any experience with trying Site to Site VPN setups with Quickbooks POS talking to other Quickbooks POS systems as well as Quickbooks Desktop?
0
We are currently running Quickbooks Pro 2018.  We import invoices from a CSV on a given day.  However our accounting person then goes through customer by customer to send an invoice.  

What we are looking to do is two parts.  First we would like to generate a list of invoices for just the customers with invoices that were imported that day.  Lets call it 20 invoices, once we have that list, we would like to click to email them, but also attach that customer's aging report with that invoice(without having to bounce between a million screens).  Currently she is doing this all manually and its a nightmare.   Any help here would be absolutely amazing.
0
I use QuickBook 2016 and store data on server, i always backup my company file with QuickBook backup utility and it work just fine. And my concern is want to know that is it also work 100% if i manually copy or zip whole company folder to external HDD and copy back to anywhere and connect QuickBook to that company folder? (If you can detail me also about PeachTree would be very appreciated).

Thanks in advance.
0
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've moved quickbooks files to a new computer everything works, but when I try to get into an old invoice it doesn't find the bill attached it to.

Can I specify a new location for those invoices ?
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
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.

My QuickBooks Pro 2018 shows my Maryland Unemployment account for 1st Qtr 2018 as being due/late in the “Pay Liabilities” page. It was paid end of April and cleared May 2nd. In QuickBooks it shows as being paid May 2nd in the “Pay Liabilities Payment History” section; so why would it show as still being due in the “Pay Liabilities” section? The payment also shows up in the register as cleared.
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
I need some help in estimating the time it would take to build a QuickBooks server.

Currently  8 Users who need access to QB. 3 other users in the main office who don't need QB access.  10 users on remote jobsites with variable hotspot access that I was thinking of leaving in their own Workgroup if possible. Current environment is a standalone QB server in a Workgroup - no DC/AD as the OS is Multipoint Server. All users on O365.  

So, I'm scoping out the project but need help in estimating the time.  Proposed server to have 8-10 Cores, with 4 Hyper-V VMs.  8 HDDs RAID 6

VM0: 2 Cores, 4GB RAM: ADDS Server - File & Print, DNS, DHCP
VM1: 4 Cores, 16GB Ram: RDSH, QuickBooks
VM2: 2 Cores, 4GB Ram: RDBroker/GW/Web
VM3: 2 Cores,  8GB RAM: SQL


In addition to the server build time, I have to factor in the time to add 15 Office PCs (11 LT/DT & 4 Surface Pros ) to the domain and transfer profiles.   What are reasonable times to factor in to this build?


Thanks
Tom
0
Hey, we have been having a strange problem with our Quickbooks POS ver 13 multi user installation in a club setup (4 machines). Customers have to recharge their accounts before ordering and the big problem we have is discrepancies between current and available balances. However,the sale transactions are posted in real time but the balances take seem time to synchronize(happens  to a random member account irregularly ) and we have changed the LAN routers and cabling and the problem is still persisting. The charge to account is posted after some delays of a few hours. We have integrated the solution to Quickbooks premier for financial exchange. Our company file is 500MB big and the connectivity tool doesn't post any errors. The environment is available for remote access any time. Any pointers?
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
I am getting the following error message with Quickbooks when using RDS 2016.

I have this setup with other servers and this error does not appear.

Things I have already checked:
  • Verified that IE Enhanced Security Configuration is disabled for both users and administrators
  • I have even enabled a GPO to set the Internet zone to medium

Neither of these settings have helped, on this particular server.

Once you click cancel on the error, everything works but it's an annoyance.

Anyone else have any ideas on a fix?

Quickbooks error
0
Python 3 Fundamentals
LVL 12
Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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
I had this question after viewing Importing an iif BILL into the Expenses tab???.  I still cannot figure out how to create an iif bill that will import with ITEMS rather then EXPENSES.  I cannot find a sample iif anywhere that will import into QB2016 with bill items.  Any advice would be greatly appreciated.

EDIT: just a very simple example of a minimal iif that creates a bill with items.  I have found some example IIF's that are very complex and when I import them as a test they always create bills as "expenses".  The items tab is always empty.  Is it a problem with accounts not matching (between the iif and my QB company file)?
0
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 been using QuickBooks for more than 2 years and now I am facing problems like login issue and different errors. I don't know where to seek help. Please suggest me anything you can?
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

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
>