Toll-Free : 1.800.761.1787

QuickBooks desktop has proven to be an marvelous accounting program that has facilitated in managing payroll effectively. But some QuickBooks desktop users are encountering different types of technical issues whenever performing specific payroll operations. One such common error is related to the payroll service key and show up ‘Enter a Payroll Service key when running payroll‘. The error is not specific to particular QuickBooks desktop version. It can be experienced in different QuickBooks versions. In order to get this error fixed, go through this segment till the end.

Important points to consider:

  • If you are using QuickBooks desktop 2022 or older versions, then it is important to download and install the QuickBooks 2023 version to continue using your payroll service.
  • If you are using QuickBooks desktop 2023 the follow the below steps:
    • You need to select the Cancel button to close the window.
    • Then restart your QuickBooks desktop. (This step should fix the issue.)

You may also see: How to Host your QuickBooks Company Data in Multi-user Mode?

How to Resolve QuickBooks Error ‘Enter Payroll Service Key’?

You need to follow the below given technical methods to root out “Enter Payroll Service Key” error message in QuickBooks desktop.

Method 1: Restart your system

At times, a simple restart can fix the error. This works especially when the issue is caused due to some temporary glitch.

  • At first, make sure that you double check your Service key.
  • After typing the Service key, if the error appears, click on Cancel and then again restart QuickBooks desktop as admin.
  • Now, enter the Payroll Service key once more time.

Method 2: Upgrade to QuickBooks desktop 2023

  • Open Internet Explorer.
  • After that open the Incognito tab mode.
  • Now enter the correct URL for Intuit website. Then, you need to press the Enter key.
  • Download a compatible version of QuickBooks 2023.
  • Run the program and test if the issue is fixed.

Check Also: What is QuickBooks Script Error and How to Rectify it?

Method 3: Sync license data

If you are facing this issue in QuickBooks Desktop 2023 then you need to manually synchronizing the license data. It can be an effective fix for the enter payroll service key. Follow the below given guidelines for this:

  • At first, open QuickBooks and navigate to the Help menu.
  • After that, click on Manage My License option.
Sync License Data Online option - Image
  • Then select Manage My License option and tap on Sync License Data Online… option.
  • In the next window you will get the license synchronization, and the process begins. The process should only take a few seconds to complete.
  • Once done with that select OK button.
  • At last, close and restart QuickBooks desktop. This should resolve the issue when running payroll.

Method 4: Repair QuickBooks desktop

If the above methods didn’t fix the issue for you then try to repair the QuickBooks program.

  • Under this method, you need to press the Start button and select Control Panel.
  • After that, select Programs and Features option.
  • Then search for QuickBooks Desktop from the list of installed programs and tap on it.
  • Now select Uninstall/change option.
Uninstall your QuickBooks desktop - Screenshot Image
  • In the last step click on Repair to repair the program.
Repair QuickBooks Desktop - Image

Related Article: How to Fix QuickBooks Crash Com Error?

Wrap Up

As you reach the end of this segment, we expect you to be able to fix QuickBooks Payroll Service key error. However, this issue is not that much annoyed in nature and the methods provided in this article should be sufficient to fix it. If the error is still bothering you or you need any technical assistance then feel free to reach us at i.e., 1-800-761-1787. Our QuickBooks payroll support team will be more than happy to assist you.

 

Related Articles:

How to convert an Accountant’s copy to a Regular Company File?

How to Fix Webmail Password Issues in QuickBooks Desktop?

Fix QuickBooks Error 6147, 0 When Opening Company Files

In this article, we will be talking about the process to create a credit note or refund check in QuickBooks desktop for Windows. Thus, if you are seeking for the same process, then your search ends over here. QuickBooks accounting software makes it easy to give money back or credit to the customers. Read ahead to find out the process to giving your customer a credit or refund in QuickBooks desktop for Windows. Another option is to contact our team professionals at 1-800-761-1787, and let them perform the steps for you.

You may like also: How to Fix “No Printer installed” Error in QuickBooks?

Steps to give the customer a credit or refund in QuickBooks desktop for Windows

The user can perform the below steps to give the customer a credit or refund in QuickBooks desktop for Windows.

Step 1: The very first step is to create a credit note

  • Herein, the users need to select Create credit notes/ refunds from the Customers menu.
  • And then, select the Customer from the customer: job drop down.
Customer Information tab - Screenshot Image
  • And also, enter the items that you are giving a credit for and also select Save and Close.

Step 2: Select how you wish to handle the credit

In the available credit window, select one of the following and also hit ok tab.

  • Retain as an available credit: QuickBooks enters a negative amount in the accounts receivable register for the credit note. The user can use this credit as payment for another transaction. In case the users chose to retain as available credit, then they will be able to see the available credits in the customer payment window.
  • Give a refund: The user can issue the refund in cash or a check. In case the customer used a credit card, then the steps for refunding a credit card payment can be different.
Give a refund - Image
  • Apply to an invoice: QuickBooks accounting software opens the apply credit to invoices window. Choose an invoice you wish to apply this credit to.

Option 1: Retaining as an available credit

The user will see the receive payments window. And then would have to perform the steps below:

  • At first, the users should go for the Customers tab and then select Receive payments.
  • The next step is to select the Customer under the received from drop down.
  • After that, select the Discounts and credits icon.
Discounts and credits - Image
  • Also, check the credit you wish to apply and then done on the Credits tab.
  • The users should now select Yes tab, after they sees a prompt to confirm transfer. The amount will be applied automatically to the invoice.
  • The last step is to select Save and close.

Option 2: Apply a credit to an invoice

  • The very first step is to ensure that you select Customer:job when creating the credit note. This will open the apply credit to invoice window.
  • The next step is to choose the Credit they wish to apply automatically and also select Done.

Option 3: Give a refund

  • The first step is to choose OK after the check is filled out automatically.
  • And then, link the check to the overpayment. And also move to the customers menu and select Receive payments.
Receive payments - Image
  • The next step is to select Customer from the received from drop down.
  • And select the Discounts and credits icon.
Discounts and credits - Image 1
  • Now, in the available credit section, select the check you created and then done.
  • Now, the users will see a prompt to confirm transfer.
  • In case you do, then choose Yes tab.
  • The amount will be applied automatically to the invoice.
  • And also choose Save and close.

Check Also: How to Set up QuickBooks Workforce for QuickBooks Desktop?

Summing Up!

By the end of this article, we believe that the information stated above might be of some help in giving the customer a credit or refund in QuickBooks desktop for Windows. However, if you are still unable to perform the required steps, then in that case contact our team professionals at 1-800-761-1787, and let our QuickBooks desktop support experts handle the situation for you.

 

Other technical posts:

How to Merge List Entries in QuickBooks Desktop?

What are the Methods to Troubleshoot QuickBooks Error 6106, 1069?

How to Rectify QuickBooks Payroll Error 30102?

Want to explore and analyze reports out of QuickBooks in Microsoft Excel? Well, this is possible, by exporting reports as excel workbooks in QuickBooks. You can save the reports as excel workbooks, CSV spreadsheets, or PDF’s. In case you are planning to export report in QuickBooks, then make sure to scroll down carefully. The process involves certain steps, which we will be discussing later in this article. However, if you are a newbie and don’t want to invest your time in performing the steps manually, then in that case you can speak to our team professionals using our support number i.e., 1-800-761-1787.

You may check also: How to Create and Open Portable Company Files in QuickBooks Desktop?

Steps for Exporting a Report in QuickBooks Desktop for Windows

The steps involved in the process to export a report in QuickBooks desktop for window are shared below:

  • The first step is to move to the Reports menu in QuickBooks and select Reports center.
Combine Reports from Multiple Companies - Image 1
  • The next step is to look and open any of the report.
  • Further, select the Excel on the toolbar and select Print to save the report as a PDF.
  • The user is then required to create a new excel workbook and select Create new worksheet. If you wish to update an existing workbook with the data in the open report and select Update existing worksheet. Also, select browse and look for the workbook on the system. Keep in mind that this overwrites workbook.
  • In case the user wishes to format the data a specific way, then select Advanced.
Select advanced option - Featured Image

Note that the reports must have less than 256 columns. In case you saw report has too many columns, and then select advanced tab. Choose and uncheck the space between columns checkbox and hit ok tab. You can save the report as a CSV instead of an excel workbook and have more columns.

  • The users are required to choose OK tab when they are read to export.
  • To open the report in excel, select Export tab.

Steps for Exporting a Report in QuickBooks Desktop for Mac

Note that one can open the excel workbooks with apple number or Microsoft excel 2016 or later, which includes Mac office 365:

  • Move to the Reports menu and look for the reports to be exported.
  • Select the Export.
  • Select file, when the file opens and select Save as to save the file.

QuickBooks software will open up excel workbooks with the default set by the user. This can be changed as:

  • You need to right click the file and select Get info.
  • After that from open with menu, choose Microsoft excel or Apple number.
  • Select Change all.

Check Also: How to Manually Fix Microsoft .NET Framework Errors when using QuickBooks?

Steps for Getting Updated Reports while Working in Excel

After performing the steps above, the user can get the latest version of the report from QuickBooks being in excel. It is essential to note that the first time a report is updated from excel, you need to ensure that QuickBooks is open. This will set the preferences and permissions. The user update reports from excel even if QuickBooks is closed.

  • The user should first move to QuickBooks tab in Microsoft excel. It will automatically add this the first-time report is exported.
  • Select Update report to get the latest version of the report from QuickBooks.

Generate Excel-based payroll reports

Excel-based payroll reports contain data that is only available in Excel. Following are the Excel-based payroll reports available in QuickBooks Desktop for Windows.

  • Summarize Payroll Data in Excel
  • Payroll by Department/Class
  • Certified Payroll Report
  • Deferred Compensation Report for 401(k) (& more)
  • Payroll Summary by Tax Tracking Type
  • Employee Time & Costs
  • Local Tax Summary
  • Employee Sick & Vacation History
  • Employee Direct Deposit Listing
  • Payroll Liability Accruals & Payments
  • Tax Form Worksheets

Create a Summarize Payroll Data report in Excel

The Summarize Payroll Data report has info about:

  • Employee Journal by Check
  • Deferred Compensation
  • YTD reports
  • Rates & Hours by Job
  • State Wage Listing
  • Effective Dates by Item & Employee
  • Quarterly Employee Summary
  • 8846 Worksheet

Sum Up!

Exporting reports as excel workbooks in QuickBooks desktop might be possible using the steps that we have discussed earlier in this article. However, if you are still unable to export reports as excel workbooks in QuickBooks, then make sure to speak with our technical team and let them resolve your queries with utmost care. Our QuickBooks desktop support experts and professionals will ensure to come up with the most relevant steps to export reports as excel workbooks for you successfully.

 

Related Posts:

How to Fix Error in reload.sql in QuickBooks for Windows?

Steps to Move your QuickBooks Desktop File to QuickBooks Online

How to Transfer QuickBooks Desktop from Old Computer to New Computer?

Do you want to import your credit card transactions into QuickBooks? Well, we have got you covered, this article will brief you with the entire process to import credit card transactions in QuickBooks. QuickBooks offers a great feature which helps in saving a lot of time as well as efforts. One can easily download the business credit card transactions into QuickBooks. And after downloading the transactions successfully, one can also manage the transactions. To know more about importing credit card transactions into QuickBooks, make sure to read this article till the end, or you can also contact us using our customer support number i.e. 1-800-761-1787. Our team of experts will ensure to provide you with immediate technical assistance.

You may also like: How to Troubleshoot QuickBooks Update Error 15101?

Important point to remember

One can take into consideration the following points before performing the steps for importing credit card transactions into QuickBooks.

  • The most important point is the user might see a column to add QuickBooks account number while downloading a file from credit card company. In case the user has an account number, then it is suggested to provide the lowest sub account number.
  • Also, in case the users downloads transaction of more than 90 days, then they needs to import the transaction in excel format.
  • Another important thing is that to import credit card transactions into QuickBooks online, the user will have to enter credit manually.
  • Or if there is a pay column in the file which gets downloaded from the credit card company containing extra details like merchant id, then one can change the column to match it with the vendor name.
  • Along with that there is no compulsion to add a new value to import file. There is an option to give a default value when importing credit card transactions into QuickBooks desktop.

How beneficial it is to connect credit card account to QuickBooks?

Credit card accounts should be connected to QuickBooks, due to the following perks namely:

  • When one downloads the transactions in QuickBooks, then it saves a lot of time.
  • Moreover, it is also possible to categorize the transactions when adding them to QuickBooks.
  • In case you do not have any business bank account, then you can get a separate bank account for your business to join QuickBooks. This helps in segregating business and personal activities.

Check it also: How to Fix QuickBooks Error PS077 or PS032?

Steps to import credit card transactions into QuickBooks online with CSV file

In order to import credit card transactions into QuickBooks online using CSV file, the below steps can be performed:

  • The very first step is to select Transaction and Banking.
  • After that, upload the file or transactions by clicking on Upload a file option.
  • The next step is to select the QuickBooks account you wish to link with the credit card account.
  • Now, Add account from the drop down menu, in case you don’t have an account in QuickBooks.
  • Followed by filling up the required fields to set up the account.
  • Moving ahead, the user is required to Map QuickBooks online fields to the bank account.
  • And perform the steps to map QuickBooks online.
  • Choose the Date column and also the Date format.
  • After that, move to the description and click on the File.
  • In the next step, the user will Positive and negative number in a single column.
    • Where, the user is supposed to select column with Negative number.
    • Followed by ticking the Transactions that are to be imported into QuickBooks and choose Next.
    • Once done with that the software will confirm the transaction.
    • Where, the user should click on yes to Confirm.
    • End the process after the transactions gets downloaded.

Steps to import credit card transactions into QuickBooks online

Herein, the user will have to carry out the following steps:

  • First of all, select the Banking center.
  • And then, login the Business and credit card account.
  • The next step is to select the Credit card account.
    • The user will see all the accounts you have at the bank. The users are supposed to place a checkmark for each account that they wants to connect to QuickBooks.
    • Followed by entering the Bank account name.
    • The user is then required to select QuickBooks account where the bank account is linked. In case the user isn’t having any setup in QuickBooks, then it is suggested to select Add account from the drop down.
  • Followed by selecting the right Date range.
  • Now, click on Connect.
  • And the transactions would now get downloaded.
  • After that review the downloaded transactions.
    • Herein, the user should see the Credit card account balance in the blinking center.
    • In case the user wants to track other credit card account in QuickBooks, then it is suggested to click on the add account tab and move back to step 1.

See Also: How to Tackle Crash Com Error in QuickBooks Desktop?

Summing Up!

With this we come to the end of this post, where we expect that the above discussed steps would be more than enough to import credit card transactions into QuickBooks. However, if you have any query or if you get stuck at any point of time, then in that case get in touch with our team professionals and ask them to perform the necessary steps on your behalf.

 

More helpful topics:

QuickBooks Payroll Is Not Taking Out Taxes – How to Correct It?

How to Install QuickBooks Enterprise for the First Time?

How to Resolve QuickBooks Error Code Skipped 111?

Call Now +1-800-761-1787