How to Give your Customer a Credit or Refund in QuickBooks Desktop for Windows?

by | Last updated On : Jun 3, 2024 | QuickBooks

Learn how to create a credit memo or refund check in QuickBooks Desktop for Windows - Featured Image

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 user needs 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 user chose to retain as available credit, then he/she 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 user 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 user should now select Yes tab, after he/she 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 user 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?

How to Export Reports as Excel workbooks in QuickBooks Desktop?

by | Last updated On : May 24, 2024 | QuickBooks

How to Export Reports as Excel workbooks in QuickBooks Desktop - Featured Image

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 user is required to choose OK tab when he/she is 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?

How to Import Credit Card Transactions into QuickBooks?

by | Last updated On : Apr 25, 2024 | QuickBooks

Learn how to Import Credit Card Transactions into QuickBooks - Featured Image

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 user downloads transaction of more than 90 days, then he/she 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 user is supposed to place a checkmark for each account that he/she 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?

Fix errors when converting from QuickBooks Desktop to online

by | Last updated On : Apr 17, 2024 | Errors

Learn how to fix errors when you move from QuickBooks Desktop to QuickBooks Online - Featured Image

Converting from QuickBooks desktop to QuickBooks online and stumbled upon any type of error? Well, need not to worry anymore, as here we are with this article to provide you with detailed information related to fixing errors when converting from QuickBooks desktop to online. QuickBooks online software comes with way more features and functionalities, which makes it compelling for the users to switch to QuickBooks online. Any kind of error in converting can lead to further inconvenience.

To know more about fixing errors when converting from QuickBooks desktop, make sure to read this article carefully till the end. Or you can also consult our team professionals, in case you don’t want to tackle these errors on your own. Reach out to us at 1-800-761-1787, and we will be more than happy to help you.

Important points to remember

Before proceeding further, the user is required to keep in mind the following pointers:

  • The user needs to first update the QuickBooks desktop completely if it remains incomplete, then it is dangerous to import data as there are chances to a permanent data loss.
  • The user can also import QuickBooks desktop data within the first 60 days of the QuickBooks online company start date.
  • Also, it is important to store the data file in QuickBooks desktop and maintain the transactions on both sets of books until you decide QBO is right for the business.
  • Also, it is important to ensure that you know the limitations of importing and then go for the right option.
  • The user should also login as the admin in both QuickBooks desktop file and the online account.

You may read also: How to Fix QuickBooks Won’t Accept Product Number During Installation Error?

Methods to implement to fix the issues when converting from QuickBooks desktop to online

The user can perform the required to steps for the respected errors that can be seen when trying to resolve the errors that can appear when converting from QuickBooks desktop to online:

Error 1: Couldn’t connect to the database or could not load the database

Solution 1: Logging with admin credentials

These types of errors can be resolved by logging in with admin credentials:

  • The very first step is to visit the run window.
  • And then open control panel and select view tab from the drop down lost and select the small icons.
  • After that, select the user accounts tab.
Manage another account - Screenshot1
  • And also select manage another account option.
  • The last step is to ensure that you have logged in as admin.

Solution 2: Checking out possible data issue

  • The user needs to first move to the file menu and then choose company operations.
  • After that the user needs to choose the create a new company and move to the next tab. Give this file a unique and different name.
Create a new company - Image
  • In case the error doesn’t return in the test company file, and also open the original companies file directly:
    • The user is then required to select file menu and company operations.
    • After that select restore from backup and click on next tab.
    • And also select browse to an alternate backup file and select browse.
    • Now, move to the company name.
    • And also select the file qbpos.db and open it.
    • The last step is to register a new, unique name for the company file and then go for ok tab.

Error 2: We can’t export the data. It may be on a network drive

The user will see this issue if QuickBooks desktop company is located on a drive other than their local c-drive or it’s open in multi-user mode.

  • This can be resolved by pressing F2 or Ctrl + 1, to open the product information window and then check the file size.
Product Information - Screenshot Image
  • The user is then required to close the QuickBooks desktop, and then copy the company file to C:\drive.
  • The next step is to open the company file in QuickBooks desktop.
  • Also, select the switch to single user mode, from the file menu.
Switch company file to single-user mode - Screenshot
  • End the process by exporting again and then from the file menu, the user has to pick the utilities tab, and also select the copy company file for QuickBooks online.
copy company file for QuickBooks online - Screenshot Image

See Also: How to Sync Outlook Contacts with QuickBooks Desktop?

Error 3: Error in processing data for Mac desktop file

The user can try resolving this error successfully by updating QuickBooks desktop for Mac to the latest release. The steps that would work in here are as follows:

  • The very first step is to select the check for QuickBooks updates option from the QuickBooks menu.
  • Further, go for install updates.
Check for Updates _ Image
  • And by the end, reboot the software.

Error 4: Problem in checking the company for import eligibility

This sort of error could be seen if the user is not the master admin, company admin or accountant user in QuickBooks online company file. Or if there is any issue with QuickBooks online payroll account services. The user can perform the below steps to fix this issue:

  • The user is recommended to ask the master admin to grant admin permissions, or have a company admin to perform the export process.
  • The next step is to ensure to login the online company before importing.
  • If the error continues, it is suggested to create a new online account.

Error 5: Exporting QBDT data to QBO

At times when the path of the company file is more than 4 folders deep, then this type of error could be witnessed. Just as in case of the file path C:\My Stuff\QuickBooks files\My Company\2016\Work Files\data.qbw. This can be resolved by performing the steps below:

  • The very first step is to press F2 or Ctrl + 1 keys in order to open the product information window and then verify the company file location.
  • The next step is to close the QuickBooks desktop.
  • Furthermore, the user should copy the company file to any folder in the C:\drive.
  • Also, open the QuickBooks desktop, and move to the file menu and choose the open or restore company.
Open or Restore a company file - Image
  • End the process by opening the saved file from the new location, and then try to import the file once again.

Check it Also: How to Fix QuickBooks Payroll Update Error Code 15221?

Error 6: Please delete all employees already entered in QuickBooks Online

While transitioning data, QuickBooks Online can’t replace employees as they’re intricately tied to payroll items, year-to-date history, and other aspects of the payroll setup.

Solution:

QBO prohibits the deletion of employees with paychecks or pay history. In order to transfer your data, you’ll have to create a new QuickBooks online company without a payroll setup to move your complete data.

Error 7: Your file is too big to export

Your QuickBooks Desktop file cannot have more targets than the following limits:

  • QuickBooks Desktop Enterprise 2020 latest release and newer (US) – 750,000 targets
  • QuickBooks Desktop Pro/Premier 2018 latest release and newer (US) – 750,000 targets
  • QuickBooks Desktop Pro/Premier 2020 latest release and newer (CA) – 750,000 targets
  • QuickBooks Desktop UK – 350,000 targets
  • QuickBooks Desktop Mac – 350,000 targets
  • QuickBooks Desktop Enterprise (CA) – 350,000 targets

Solution

  • In order to access the Product Information in QuickBooks Desktop, simply hit the F2 key or Ctrl+1 key if you’re on a Mac on your keyboard.
  • From there, you can check the number of targets. If you exceed the limits, consider condensing your QuickBooks Desktop file.

See it Also: How to Fix QuickBooks Error Code 1310?

Summing Up!

Once you have performed the above stated procedures, it is most probable to fix the issues successfully and convert from QuickBooks to online without any sort of further technical glitch. However, if you are still facing any sort of error, or if you want our technical geeks to work on your behalf, then feel free to consult our technical QuickBooks error support team at 1-800-761-1787, and we will ensure to provide you with immediate technical assistance.

 

More helpful topics:

How to Backup your QuickBooks Desktop Company File?

Method to Change a QuickBooks Desktop License Number or Product Code

How I can Fix QuickBooks Checks Printing in Reverse Order Issue?

Call Now +1-800-761-1787