Spotted Duplicate transactions in QuickBooks and can’t figure out how to delete them? Well, eliminating duplicate transactions from the bank feeds in QuickBooks is quite possible. You can easily remove the duplicate transactions directly from the bank feed. The process of deleting transactions depends upon the mode you are using. To help you out in deleting duplicate transactions in QuickBooks, here we are with this piece of writing sharing the complete set of steps involved in deleting duplicate transactions in QuickBooks.
However, if you have any doubts or queries, you can get in touch with our technical support professionals at +1-866-453-7060 and they will provide you with immediate support and guidance.
What leads to duplicate transactions in QuickBooks?
Here are a few reasons why you can experience duplicate transactions in QuickBooks.
At times when importing lists and transactions into the company file, duplicate transactions can be seen.
Also, QuickBooks rebuild data utility can also trigger double entry. Especially when the user tries to recover the unrecoverable transactions.
If you have missed out on some of the details, then duplicate entries can be seen.
Another possible reason could be if you added a few of the transactions manually, and the automatic feature is also turned on, then a double entry issue can be experienced.
How to check duplicate transactions in QuickBooks Desktop?
Even though there isn’t a specific method to look for duplicate transactions, using filters and sorting can help in identifying duplicate transactions. Here is how you can do this:
Delete Duplicate transactions in QuickBooks in side by side mode
If you are using side-by-side mode, then the downloaded transactions are available on the left of the screen.
At first, visit the banking menu.
After that, choose the bank feeds and then select the bank feeds center.
Select the account with the transactions you wish to remove in the items reviewed section.
The next step is to select the items to delete.
The last step here is to choose the deleted transaction and click on yes to confirm.
Just in case you have already matched the statement, then you can choose the select all downloaded transactions older than option and then set the date to the last statement’s end date. Now, opt for delete selected. You might be required to switch to the register mode, in order to delete everything.
Delete duplicate transactions in QuickBooks in register mode
In register mode, you will see the register on the top part of the screen and the downloaded transactions will be seen at the bottom. If you have confirmed the fact that QuickBooks is correct and you want to delete the transactions that do not tally, then the entire statement will have to be deleted. The steps involved here are:
You need to initially visit the banking menu.
After that, select the bank feeds and the bank feeds center.
You now have to choose the statement from the items received from the financial institution. Select the view option.
Now, match the appropriate transactions and select Done to match them.
Once done with that, select Yes tab in the not finished matching screen. This will return you to the online banking center.
After that, spot and choose the same statement from the items received from the financial institutions section.
The last step is to choose delete.
Removing the statement will prevent any unwanted transactions from displaying the next time the statement will be downloaded. In case you do not remove the matched statement then the transactions that weren’t matched will continue to appear on the screen.
Delete duplicate transactions or personal expenses from bank feeds
If you want to keep a personal expense out of the business finances or if you have duplicate bank transactions, then the below steps are involved in excluding transactions:
Initially, you are supposed to choose the transactions from the left menu.
Furthermore, you need to put a checkmark on the transactions you want to exclude.
The last step is to visit the batch actions drop-down and then choose the exclude selected option.
If you want to see the ones that are excluded, then you simply need to opt for the excluded tab.
Just in case you want to see the ones that are excluded, then select the excluded tab. However, it should be noted that the transactions won’t appear in any associated account registers or reports, as they are not tracked or reported as part of the business finances. In case you have accidentally excluded the transaction, then you can simply include it by performing the steps below:
Here, you will have to choose the transactions tab from the left menu.
Once done with that, move to the excluded tab.
After that, checkmark the transactions to be included.
And later on, move to the batch actions drop-down and choose undo.
Here are a few points that you need to keep a check on:
If personal expenses are excluded:
Just in case the user excludes a transaction, the bank register won’t reconcile due to the bank balance, and the QuickBooks balance will show a difference. If you do not reconcile the bank statements with QuickBooks online, then there is not an issue.
Alternatively, when the user reconciles the bank registers, he/she needs to track the personal expenses by adding the user himself as a supplier and assigning the transactions to an owner’s equity account.
If duplicate transactions are excluded:
In case you excluded a downloaded transaction, then in that case the balance will tally, and the user will be able to reconcile.
To Conclude!
While you reach the end of this article, it is believed that you might be successfully able to delete duplicate transactions in QuickBooks. However, if you have any queries or if you require any sort of technical assistance for carrying any task in QuickBooks, then in that case, give us a call at +1-866-453-7060, and we will provide you with immediate support and guidance. For any further guidance, feel free to connect with our technical support team.
FAQs Related to Delete Duplicate Transactions in QuickBooks
What causes duplicate transactions in QuickBooks?
Duplicate transactions usually show up when you try to import transactions from some external 3rd party program to the company file.
What are ways to find duplicate transactions in QuickBooks?
To find out any duplicate transactions, you need to follow the steps below:
Head to the bookkeeping menu and navigate to the transactions option.
Once done with that, click on the expenses tab and choose the number of columns to sort out transactions.
Trying to sign in Gmail through QuickBooks Desktop, but came across an unexpected error stating: QuickBooks Gmail not working? Well, if that is the case, then here is what you need to do. Often when there is an update from QuickBooks for added security, such sort of errors are experienced. You can further come across such errors when the credentials are incorrect or the Gmail settings are misconfigured. You can try reconnecting your account to eliminate any sort of email errors. The message that appears on the screen mentions that the security of the mail is under threat. However, it simply reflects that the app had tried to sign in to the Gmail account.
To learn further about QuickBooks Gmail not working issue, you simply need to go through this piece of writing carefully or can further connect with our technical support team at +1-866-453-7060 and we will provide you with answers to all your queries immediately.
Solution 3: Change the enhanced security setting in QuickBooks
If in case you have configured Gmail to use enhanced security, then you will be simply asked to Authorize QuickBooks when sending a transaction or report.
At first, click on the allow tab to use Gmail in QuickBooks.
After that, from any active report or transaction, choose email.
Now, hit the send tab.
You might receive a pop-up requesting that you check in to your account using your credentials.
In the window of webmail authorization, you need to enter the credentials and click on the Continue tab.
Towards the end, choose allow to complete the process.
In case you are unable to authorize QuickBooks, then simply reconnect the Gmail account to QuickBooks and clear the option to use enhanced security.
You can set up webmail in QuickBooks to connect to your Gmail account.
Later on, just head to the menu and click on the preferences tab.
After that, select send forms.
Move to the menu and select webmail.
Once done with that, add the webmail by clicking on the add tab.
From the drop-down list, you need to head to the provider to connect your Gmail address.
Go for the option Utilize enhanced security.
And then, hit the ok tab.
After you are prompted, sign in to your Intuit account by entering the credentials.
At times, your Gmail account might not be set up properly which can further trigger QuickBooks Gmail not working issue. You can carry out the steps below to set up your Gmail.
Navigate to the menu and choose the edit tab,
Head to the preferences option and select forms.
Now, click on the My Preferences tab.
Followed by heading to the webmail and clicking on the add button.
You will now see a dialog box, where you need to enter your Gmail id and select Gmail.
After that, the SMTP server information will be filled in automatically by QuickBooks.
Toward the end, click on ok tab and your email address will be added to your email ID.
Emailing QuickBooks invoices using Gmail is possible after connecting QuickBooks to the Google Account. You can manage all of your Customer emails in one place.
Steps to Integrate your Gmail Account with QuickBooks
Note that you can only connect one Gmail account at a time for the time being. In case you need to change your Gmail address, then you will simply have to unlink the one you are connected to at the current time. Further, you can link the one you want to use. The steps to integrate Gmail account with QuickBooks are as follows:
You need to simply create a new invoice or open one that is already open.
Further, once you have entered all the required fields, click on save and send to bring up the preview window.
You will then have to select the customer’s email from the drop-down menu.
Followed by, selecting Connect Google Account after adding Gmail address.
Now, head to the sign-in window enter the email address, and hit next.
After that enter the credentials.
Make sure to tick mark the should be chosen box.
This will let you send invoices successfully.
Steps to Unlink your Gmail Account
When you remove your current email address, QuickBooks will send invoices using the default email.
Performing the set of steps enumerated above might help in eliminating the QuickBooks Gmail not working issue or Gmail Couldn’t Sign you in From QuickBooks. However, if for some reason you land into the same error even after performing the set of steps discussed above, all you need is to reach out to our technical support team at +1-866-453-7060, and let them help you with your QuickBooks queries. Our QuickBooks support professionals have sound knowledge to deal with any sort of error experienced when working on QuickBooks. For more details, give us a call right away!
QuickBooks loan manager reflects the loans in QuickBooks depending upon the information provided on the long-term liability and current liability accounts. This feature in QuickBooks lets the users track both principal and interest without looking over the amortization tables to evaluate the accounts. QuickBooks loan manager usually establishes loans in QuickBooks based on the info given. However, at times for certain reasons, one might come across QuickBooks loan manager not work issue. To help you tackle such an error, here we are with this piece of writing, sharing the complete details about how you can fix the QuickBooks loan manager not working error.
Thus, to learn further about the issue, stick around this piece of writing, or you can also consult our technical support team at +1-866-453-7060, and we will provide you with immediate assistance for all your QuickBooks-related queries.
Loan manager in QuickBooks is one of the most helpful features. Thus, getting rid of the error immediately is essential. Reading this piece of writing might help you in getting rid of the QuickBooks loan manager not working error successfully. On the contrary, if you need our assistance at any point in time, then in that case, feel free to reach out to our technical support professionals at +1-866-453-7060, and let them clear all your clouds of confusion.
While carrying out daily accounting activities, one might have to print certain documents or pdf. However, at times due to certain factors like improper Windows print components, missing PDF components, or QuickBooks desktop setup, one might face issues with printing payroll tax forms, statements, and other documents. QuickBooks unable to locate PDF viewer is one such error that can be experienced by QuickBooks users. PDF viewer in QuickBooks is an essential component for the software to access the documents and the absence of this component can create issues in opening the essential files.
QuickBooks unable to locate the PDF viewer error can be seen when the Windows print components are damaged or outdated. To further learn about this issue in QuickBooks, sticking around this piece of writing can surely help. However, if you do not want to eliminate the error on your own, then you can simply get in touch with our technical support team at +1-866-453-7060, and they will help you tackle all sorts of QuickBooks-related issues.
What causes QuickBooks unable to locate PDF file error?
There are a bunch of factors causing such an error in QuickBooks desktop, which include:
The Adobe Reader version installed on Windows is outdated.
Another possible reason can be if the QuickBooks doesn’t have Adobe Reader set up as the default PDF viewer app.
You can also come across a similar issue if the QuickBooks desktop software is missing the latest updates.
Also, if the qbprint.qbp file is either damaged or missing from the installation directory.
Effective solutions to fix unable to locate pdf viewer error in QuickBooks
Errors related to pdf like ABS PDF driver install error, PDF and print errors, or unable to locate pdf viewer errors are pretty common in QuickBooks. You can try out the below set of steps and solutions to rectify the error unable to locate the pdf viewer in QuickBooks. Let us explore the solutions one by one:
Solution 1: Repair, update, and reinstall Adobe Reader
Just in case you are unable to open a PDF document after selecting Adobe as the default program, then you might face an issue with the PDF reader software. Here is how you can update, repair, and reinstall Adobe Reader.
Further, note the version shown on the page and also open the Adobe Reader App
Once done with that, you need to navigate to the help tab and also choose About Adobe Reader.
Heading forward, check if the Adobe version shown on the page and Adobe’s website is the same.
Moreover, if the versions don’t match, then you need to click on the help tab.
Further, choose the check for updates tab.
Carry out the onscreen prompts to update the PDF viewer.
Repair Adobe Reader
Close all running programs and open Adobe Acrobat Reader.
Followed by, heading to the help tab and also click on repair acrobat installation.
Permit the application to repair itself and further, when the repair is complete, reboot the system and check if the users can print the document using QuickBooks.
One can use the program and features option in the control panel to uninstall Adobe PDF viewer. The same can be reinstalled later on using the steps below:
First, you need to open the run command and type the command appwiz.cpl to open the program and features window.
Once done with that, choose the option to view installed updates further right-click on Adobe, and choose the option to uninstall.
Also, move to the web page for Adobe Acrobat reader download.
And then, click on the option to install now and choose the correct Windows version from the drop-down list.
Once the update file is downloaded, click on the option to run and hit the finish tab.
Rename Qbprint.qbp file
You can try to rename the Qbprint.qbp file to fix QuickBooks unable to locate the PDF viewer issue. The steps involved in renaming the file are as follows:
Start by opening the Windows file manager
Further, click on the organize option.
You now have to choose the folder and search option.
Under the view tab, you need to uncheck show hidden files, folders, and drivers.
Head to the Program Data folder in the C drive and then open the Intuit Folder.
You will then have to double-click the QuickBooks folder and also right-click the Qbprint.qbp to open it.
After that, choose the option to rename and add old instead of .qbp (qbprint.old)
The last step is to save the file and check if the Unable to locate PDF viewer error continues.
Solution 2: Set Adobe Reader as the default PDF viewer
For Windows 7, 8, & 8.1
If you are a Windows 7, 8, or 8.1 user, then you need to carry out the below steps to set Adobe Reader as the default PDF viewer. The steps involved are:
At first, click on the Windows start menu and choose the control panel from there.
You now have to select programs and click on set default programs
The next step is to find and choose Adobe Reader
Choose set this program as default.
For Windows 10
You need to first click on the Windows start menu
After that, click on the settings tab and choose apps.
Further, click on default apps.
Scroll down to pdf and choose its default program.
Also, choose Adobe Acrobat Reader and click on Switch anyway
Solution 3: Run QuickBooks PDF and Print Repair Tool from the Tool Hub Program
QuickBooks tool hub consists of a bunch of tools that can help you eliminate issues that you come across when working on QuickBooks. You can access the pdf and print repair tool from QB tool hub to eliminate this error successfully. The steps involved in here are:
Initially, close QuickBooks and download the latest version of QuickBooks Tool hub.
After that, open the program and navigate to the program problems tab.
You now have to opt for QuickBooks pdf and print repair tool also note this might take a minute or so to complete.
After the scan process ends, you need to check that the issue with the pdf viewer is fixed.
The last step is to try viewing, printing, emailing, or saving as a PDF from QuickBooks again to check if the issue continues.
QuickBooks PDF viewer not found error can hinder the smooth working of the software, especially when printing pdf and documents. Thus, it becomes essential to rectify the issue as soon as possible. However, if for some reason, you are unable to tackle with the issue, or if you need any sort of technical assistance in dealing with such an error, then in that case, do not hesitate in contacting our technical support team at +1-866-453-7060, and we will provide you with immediate support and guidance.
Certain errors in QuickBooks aren’t common and can seem a bit daunting to handle. One such error that you might have heard about is QuickBooks Delivery Server Down Error. This error is often linked with the attachments in the sales or invoice when forwarding it to a customer in QuickBooks. This issue usually prevents users from sending transactions along with the attachments. As this error is a bit unique and uncommon, here we are to help you with its rectification procedures. In this article, we are going to spill the beans on how you can rectify the QuickBooks delivery server down error.
Thus, make sure to stick around till the end, or you can further get in touch with our technical support team at +1-866-453-7060 and they will provide you with answers to all your QuickBooks-related queries.
Procedures to rectify QuickBooks Delivery Server Down error
You can try to eliminate QuickBooks delivery server down error using the set of steps below:
Procedure 1: Configure the print and pdf settings
At times, incorrect printer or PDF configuration can trigger the delivery server down issue in QuickBooks. Thus, to eliminate this issue you need to configure the print and pdf settings. The steps involved here are:
Step 1: Configure Adobe Acrobat settings
You need to select the actual size.
Further, the orientation should be set to automatic
The option to choose paper source by pdf size should be on.
Step 2: Configure the pdf settings of the browser
For Google Chrome users:
Here, you will have to run Google Chrome
Further, make a move to settings
Once done opt for the advanced drop-down and then click on the content settings option.
Click on the PDF documents option.
Disable the option to download PDF files rather than automatically opening them in Chrome.
For Mozilla Firefox users:
You need to run the Mozilla Firefox browser and then move to the options.
Once done with that, click on applications and proceed to the content type option.
You now have to proceed by searching for the portable document format.
Also, click on the option to use Adobe Reader.
Exit from the options tab and move to QuickBooks Online to retry sending the invoice to make sure that the QuickBooks delivery error no longer exists.
This might rectify the issue up to a certain extent.
Under this process, you need to initially move to settings.
Further, make a move to account and settings and move to sales.
Followed by clicking on the online delivery option.
After that, select or clear the checkbox beside the PDF attached option.
Click on save and then end by clicking on done.
Procedure 3: Rectify the invoice format
You need to access or create invoice and get any special characters from the invoice info removed. The special characters include ! @ # $ % ^ & * ( ) _ – = + : ”. Make sure that the characters are not included in the information like description, message, email id, attachment name, or custom form templates.
Procedure 4: Correct the email address of the location
It is important to double-check the email address format used when sending the sales form. The steps involved here are:
Choose the settings tab.
Further, pick all lists and then locations.
You now have to search for the location used in the invoice.
And then, click on edit.
Check the email address in the section: This location has a different email address for communicating with customers.
And further, make the required changes if needed and click on save.
Procedure 5: Resolve issues with the email address formatting
If none of the above steps didn’t work, then you can try fixing the email address formatting issue. Let us have a look at the steps involved:
You need to first choose the settings⚙.
After that, you need to click on accounts and settings in the settings window and click on account and settings.
The next step is to click on the company option.
Also, click on the company info tab and check the emails for their formatting.
Getting rid of the delivery server error becomes easy using the set of steps enumerated above in this piece of writing. However, if there is any query or if the user needs any sort of QuickBooks support services, feel free to reach out to our technical support team at +1-866-453-7060, and we will provide you with answers to all your queries immediately.