Toll-Free: +1-844-499-6700 [email protected]
How to Record a Refund in QuickBooks?

How to Record a Refund in QuickBooks?

Want to record and classify refunds easily in QuickBooks? If yes, then this segment is surely something you need to go through. Refunds usually happen when a client has to refund you for an overcharge, returns an item, or cancels a service. The QuickBooks accounting software helps in managing refunds in many ways. You need to record a refund depending on various scenarios. This ensures that your books are up-to-date. To help you out in recording customer refunds in QuickBooks, here we are with this segment sharing the complete set of steps that can be implemented. To learn more, stick around this segment carefully. Or you can also consult our technical support team for any sort of technical guidance and to find out how to record refund in QuickBooks. Dial +1-844-499-6700, for any sort of technical guidance.

Also Read: How to Merge Customers in QuickBooks Desktop?

Record and Categorize Refunds in QuickBooks Desktop

You can perform the below set of steps to record and categorize refunds in QuickBooks. Let us have a look:

Step 1: Launch QuickBooks

Initially, you need to launch QuickBooks software and then sign into the account.

Step 2: Make a new customer

Before you issue a refund, you must have a customer refund. If the customer is not present in your database, then you need to add them using the steps below:

  • Head to the customer menu.
  • After that, choose Customer center
QuickBooks customer center - record customer refund in QuickBooks
  • You need to then press new customer and job option.
  • Also, select a new customer.
Record customer refund in Quickbooks
  • Complete all the customer details like the address, name, contact details, etc.
QuickBooks Add new Customer Details
  • You need to now click on ok tab.

Step 3: Create a refund receipt

Here, you need to record the money that you are giving back to the customer. The steps involved in here are:

  • The very first step is to head to customers menu and select create credit memos/refunds.
Create credit memos
  • You now need to select the customer you are refunding.
QuickBooks Customer Job
  • In the section for item, select the items that are refunded.
  • After that, type the amount of the refund in the particular account column.
  • And then, click on save and close.
QuickBooks Credit Memo

You might find this helpful: How to Create, Edit, or Delete QuickBooks Memorized Transaction?

Step 4: Issue a refund check or implement the refund to the customer’s balance

After preparing the credit memo, you can either apply it to the balance of the customer for future purchases or can refund the amount immediately with the help of the steps below:

  • After the credit memo is saved, a screen will ask you how you wish to handle the refund. Now, select apply to an invoice to use the refund for future purchases.
  • Now, select the option, and give a refund to refund the amount now.
Record a customer refund in QuickBooks
  • Just in case you select the option give a refund, you will get notified to select the payment method for the particular refund along with the account the money will be taken from.
  • Now, click on ok tab.

Step 5: Review the Refund

The last step here is to review the refund to ensure that it has been categorized in the right way.

  • Head to the reports menu.
  • Select the customers and receivables and then opt for customer balance details.
  • Now, find the customer to check the refund

Here is how to: Record a vendor refund in QuickBooks

Steps to issue a refund in QuickBooks

You need to reimburse a client or vendor for an overpayment or returned items, which includes precise paperwork and prompt processing while issuing a refund in QuickBooks.

Partial Refunds

You can reimburse a partial of the initial payment using partial refunds in QuickBooks online. This gives you options when handling refund requests from customers or vendors. This includes determining the refund amount based on the percentages of the original payment being repaid. In order to ascertain transparency in financial transactions and properly represent the partial reimbursement, adjustment entries can be made in QuickBooks online.

Refunding to a Customer

When you receive a refund in QuickBooks, the overcharged amount must be returned or a return request must be processed. Proper documentation and on time compensation are guaranteed. The process involves customer filing a refund request which the authorized staff then examines and approves. Once you get the approval, the payment must be reconciled in QuickBooks to ensure that the amount reimbursed is the same as the initial transaction. After the reimbursement is processed on time, the consumer is informed in full via email. This maintains transparency and confidence. QuickBooks lets a smooth refund management process that lets businesses to maintain both financial accuracy and customer happiness.

Refunding a payment

When refunding a payment in QuickBooks, reversing the associated transaction, updating financial records, and guaranteeing an exact reconciliation of the refunded amount are essential. Initially, you need to find the original payment transactions in QuickBooks and select the suitable refund processing option. Accounting changes must be made when the refund is started, so that the financial records reflect the refund properly. You further need to check that the updated transaction information matches the financial statements. Businesses can guarantee accuracy in the financial records and transparency in their refunding processes by following the protocols.

In order to get the accuracy of the financial reporting and maintain clean financial records, one needs to accurately record and categorize refund in QuickBooks.

Also Read: Resolve the Balance Sheet Out Of Balance In Accrual Basis

How to record a refund in QuickBooks Online?

The above-discussed steps were related to recording a refund in QuickBooks Desktop. Let us now check out the steps that discuss how to refund a customer in quickbooks online.

Customer refund if invoice has been paid

Here is how to issue a refund in QuickBooks. Let us have a look:

Step 1: Enter a credit memo

  • Begin with by simply selecting +New tab and choose Credit memo
  • Once done with that, select the right customer in the customer field
  • You now have to enter the credit memo date, amount, tax, and product/service.
  • It should be noted that in case you choose an inventory item, then QuickBooks will put it back into inventory. In case the item is defective or if you do not wait it added back to inventory, then make an inventory adjustment.
  • The last step is to choose save and close tabs.

In case the customer has overpaid, then you d not need the credit memo as you will already have an unapplied credit that acts as your credit memo.

Step 2: Make a refund

  • Here you simply need to choose + New and then go for expense
  • After that, in the payee field, choose or enter the desired customer.
  • Furthermore, in the payment account field, choose the bank the money is being refunded from.
  • Also, in the category field, choose the debtors account.
  • And in the amount field, enter the amount of the refund.
  • The next step is to choose the appropriate tax in the tax field.
  • Choose save.
  • And also, head to + new and select receive payment.
  • After that add the customer and choose payment method and deposit to.
  • The balance should be 0 as they will cancel each other out.
  • You now need to choose save and close
  • In case you have online banking, head to transactions and then bank transactions.
  • Also, match the record you found.

Refund for goods or services that didn’t satisfy the customer

You can make use of refund receipts, in case a customer asks for a refund for an item or service. In case they used a credit card, then you can perform the steps related to refunding a credit card payment. It should be noted that, in order to avoid a double refund, ensure that you haven’t already entered a credit memo yet.

  • At first, choose new
  • And also, go for refund receipt or give refund.
  • The next step is to choose customer dropdown and then opt for customer you wish to refund.
  • Now, go for refund from drop-down and then choose the bank you deposited the payment for the invoice to.
  • After that, add all products or services the customer returned in the product/service column.
  • And then, ensure to fill the date, quantity, rate, amount, sales tax, and other fields.
  • Once done with that, choose save and close

Refund a customer’s overpayment or credit

One can record a refund to the customer using check or expense, in case:

  • They want to redeem their open credits
  • They made a prepayment for an older but canceled it before receiving the goods or services.
  • They wish to reimburse an accidental overpayment

Making use of a check or expense to record the refund reduces the bank’s balance and offsets the customer’s open credit, overpayment, or prepayment.

Step 1: Record the refund for your customer

  • You need to first choose +new
  • After that, opt for expense, add expense or check.
  • In case you are in a business view, follow the steps to switch to accountant view first.
  • Now, choose the customer you wish to refund from the payee dropdown
  • And then, from the payment account dropdown, select the bank account where you deposited the overpayment to.
  • On the first line of category column, select accounts receivable.
  • After which, you need to enter how much you want to refund in the amount field
  • The next step is to enter in other field as you see fit, and choose save and close.

Step 2: Link the refund to the customer’s credit or overpayment

  • The very first step is to choose +New tab
  • And then, select receive payment
  • Also, choose the same customer you used for the check or expense when recording the refund
  • Enter in the details
  • And in the outstanding transaction section, go for the checkbox for the expense or check you created when recording the refund.
  • It should be noted that in case you have automation to apply bill payments turned on, then this step is done for you.
  • Ensure that the payment is equal to the open balance, and choose save and close.

Learn: How to Create a Proforma Invoice in QuickBooks? 

Conclusion!

Recording a customer refund in QuickBooks isn’t a tough nut to crack. We hope that the information shared in above might be of some help in recording refund in QuickBooks successfully. However, in case of any queries, or if you are unable to record refund even after performing the steps above, then in that case, consult our technical support professionals right away by dialing our technical support number i.e., +1-844-499-6700. Our support professionals will provide you with instant guidance.

Other Related Articles:

QuickBooks Checking Account – Everything You Need to Know!

How to Delete a Journal Entry in QuickBooks? 

How to merge accounts in QuickBooks? 

Complete Guide to Write Off Bad Debts in QuickBooks Desktop and Online

How to print voucher checks in QuickBooks Online? 

How to print voucher checks in QuickBooks Online? 

Voucher checks are basically kept to keep a record of payroll deductions. QuickBooks voucher checks automatically capture payroll deductions and invoice payment details, which saves a lot of time and reduces data entry errors. You can print voucher checks easily in QuickBooks online using basic steps. To help you with the process to print voucher checks, here we are with this piece of writing sharing the complete steps to print voucher checks in QuickBooks online

print Voucher checks in QuickBooks

However, if you need any sort of technical assistance at any point in time, then feel free to give us a call at +1-844-499-6700, and we will provide you with immediate support and assistance.

Also Read: How to Activate View My Paycheck and QuickBooks Workforce?

Different types of voucher checks in QuickBooks Online 

QuickBooks offers three different ranges of voucher checks. Let us evaluate each one of them one by one: 

Voucher check in QuickBooks
  • Secure plus voucher checks – The price range of secure plus voucher checks is $71.68 for 5. You get a built-in alarm system for your checks and by far it is one of the most preferred voucher checks that provide exclusive tamper-resistant security coating. If the addressee or payment amount is tampered with, then it produces a visible stain on the secure plus check. These checks are advanced protection against fraud with 23 security features. 
  • Secure premier voucher checks – The starting range for secure premier voucher checks is $78.10 for 50. These maximize your protection against fraud and counterfeit activity with QuickBooks. These checks have a security hologram embedded in the check that makes verification fast and simple. 
  • Basic voucher checks – The basic voucher checks start at $46.24 for 50. It saves time and maintains accuracy. They are designed to work specifically with QuickBooks on laser printers. The payroll stubs present on a voucher check track deductions and payment details that further help in easy recording keeping. 

Reasons for printing voucher checks in QuickBooks

The need to print a voucher check might occur for a type of payment. This form of payment is official and aids in creating audit trails from the data entered. One can print this check to keep it on file and it has the following dimensions: 8.5 x 11.5. Other than this, you might need to print a voucher check in the following cases: 

  • For keeping a record of the deductions that you made on the payroll, printing voucher checks is a quick solution. 
  • Furthermore, you can get the invoice payment data using the printer voucher checks. 
  • Also, to save time and minimize data input errors you can automatically print these checks 

You might find this helpful: Fix Intuit Printer Library Error – QuickBooks Won’t Print

Steps to print voucher check in QuickBooks Online 

You might find printing check vouchers in QuickBooks online helpful for accounting tasks or any record in QBO. With the help of this software, you can head to the banking tab before opting for the write checks option. Later on, you need to head to the write checks page and also click on the print tab. In case you want to print just one check, select the check option. On the other hand, if you are printing several checks, then choose batch. 

Voucher checks

Let us check out the steps to print voucher check in detail:

  • You need to first log in to QuickBooks online 
  • Once done with that, click on the banking option from the menu. 
  • Then, choose write checks from the menu. 
  • And enter in necessary data. 
  • After that, head to the write checks window. 
  • Click on the print icon. 
  • In case you have to print a single check, then click on check. 
  • Now, enter the printed check number 
  • If more than one check is to be printed, you need to click on batch. 
  • This will redirect you to the select checks to print page. 
  • After that, opt for the checks you want to print. 
  • Opt for the printer’s name and type from the print checks window. 
  • Now, from the list of available check styles, choose a voucher. 
  • Also, check your company’s name and address printed on the pre-printed checks. 
  • After verifying all the information, you simply need to uncheck the print company name and address. Review the decisions you made and proceed further. 
  • Make sure that the details on the check have been precisely aligned, and the check stock paper must be oriented properly. 
  • The next step is to click on print. 
  • And furthermore, your voucher checks will print in QBO. 

Also Read: How to print W-3 form in QuickBooks Online and Desktop? 

Conclusion! 

Towards the end of this segment, we believe that the information shared above might be of some help in printing voucher checks successfully. However, if you have any queries or if you need any sort of technical assistance at any point in time, then in that case give us a call at +1-844-499-6700, and we will provide you with instant support and assistance. 

FAQs related to Print voucher checks in QuickBooks Online 

Is a voucher check a payroll check? 

Even though one can use voucher checks for any type of payment, voucher checks that come with one check and two pay stubs on a single sheet of perforated paper, make an ideal solution for paychecks and vendor payments. 

Do I need secure checks if banks cover check fraud? 

Well, banks don’t treat losses for business check fraud the same way they treat personal checking account fraud. 

Will voucher checks work with QuickBooks payroll? 

QuickBooks voucher checks are designed in a way to work with QuickBooks software and services, including payroll. 

Which voucher check is right for my business? 

You can choose the voucher check that provides the level of security that you require to help protect your business from counterfeiting and fraud. 

Can I add my company logo to voucher checks? 

Along with other customizations, one can add the company’s logo to voucher checks for a more professional look. 

Other Related Articles:

How to Create a Proforma Invoice in QuickBooks? 

QuickBooks Migration Tool – Download and Set up 

QuickBooks PDF Converter – Download, Fix, and Troubleshoot

QuickBooks Payroll Not Taking Out Taxes [Fixed]

QuickBooks Import Excel and CSV Toolkit

QuickBooks Import Excel and CSV Toolkit

When you use online banking, the transactions are recorded. And to download these transactions, a CSV file is required. A CSV file is basically used to import online banking transactions into QuickBooks. You can import CSV files that include bank transactions, general journal entries, accountant’s changes, and batch transactions in QuickBooks. In order to import CSV files, you need to start installing QuickBooks Import Excel and CSV toolkit. To make the import process easier for you, here we are with this segment sharing the complete details as to how to install QuickBooks import Excel and CSV toolkit and how to import CSV files.

Thus, to learn further, stick around till segment till the end. You can also connect with our technical support team at  +1-844-499-6700, and we will provide you with immediate support and assistance.

Also Read: How to Export or Import IIF Files in QuickBooks?

What is a CSV File?

CSV files are basically simple text files that contain tabular data. A comma separates each field in the file from the next in a CSV file. The majority of spreadsheets support this format including Microsoft Excel and Google Spreadsheets. Also, you can create and edit CSV files with any text editor like Notepad. You can also import files related to some of your vendors and customers. CSV files are also termed as Comma Separated Values.

Why import CSV into QuickBooks?

In order to track finances, it is essential to maintain records of all the data. The CSV file is already in a tabular format and is further supported by spreadsheets. In the case of online banking, there are so many QuickBooks transactions and manually Creating transactions in QuickBooks desktop involves a lot of effort and takes time. Moreover, recording manually can lead to inaccuracy. The concept of importing CSV files eliminates the chances of errors due to inaccuracy and saves a lot of time.

Import CSV files

In order to import a list in the CSV format, you simply have to install QuickBooks import Excel and CSV toolkit. This toolkit includes:

  • Import from Excel and CSV manual – A PDF document with instructions, best practices, and notes.
  • CSV Example Folder – 4 Sample CSV files, one for each type of list
  • XLS Example Folder – A sample Excel file that contains 4 worksheets, one for each type of list.
  • Allowed fields – A reference guide explaining what fields are available for Excel and CSV import.

Steps to install QuickBooks Import Excel and CSV ToolKit

You can try to install QuickBooks Import Excel and CSV toolkit using the set of steps enumerated below. 

  1. Initially, open the file download window for the toolkit and then choose the save tab. 
  2. The next step is to head to the Windows desktop and choose Save. 
  3. Double-click the QuickBooks_Import_Excel_and_CSV.exe on the Windows desktop. This will open the WinZip Self-Extractor window.
  4. After that, choose browse and select the folder where you want to install the toolkit. 
  5. Also click on the ok tab. 
  6. The next step is to choose Unzip to extract the contents and choose Close to close the WinZip self-extractor window.
  7. You now have to open QuickBooks Import Excel and CSV folder from the location you opted for. 

Here is: How to Delete Duplicate Transactions in QuickBooks? 

Export CSV files 

One can try to export a list as a CSV file, in case you do not have MS Excel installed on the system or if you want to view and edit the data using a different format. 

Customer and Vendors 

  1. The very first step is to open a Customer/vendor Center 
  2. After that, choose the Excel drop-down and select
    • Export customer/vendor list, in case you want to export customer/vendor data such as name, balances, and contact information. 
    • Export transactions, if you wish to export transactions (either by name or transaction type)
  3. Now, in the export window, you are supposed to create a comma separated values file i.e., .csv file. 
  4. Furthermore, choose export. 
  5. After that, assign a file name, and select the location where you wish to save the file. 
  6. Open and edit the file as needed. 

Also Read: How to Resolve QuickBooks Unable To Export To Excel Error?

Items 

  1. Here, you need to lists menu and further opt for the Item list 
  2. The user needs to then opt for the Excel drop-down and select Export all items. 
  3. And furthermore, select Create a comma separated values file in the export window. 
  4. Now, choose the export tab. 
  5. You need to then assign a file name and select the location where you want to save the file. 
  6. And lastly, locate, open, and edit the file as required. 

Reports 

  1. At first, open the report 
  2. Furthermore, choose the Excel dropdown at the top of the report 
  3. The next step is to choose create a new worksheet 
  4. Now, on the send reports to Excel window, choose Create a comma-separated values file. 
  5. Now, go for the export tab. 
  6. After that, assign a file name and select the location where you want to save the file. 
  7. The last step is to locate, open, and edit the file as needed. 

Also Read: How to Resolve QuickBooks Unable To Export To Excel Error?

Conclusion! 

The process of setting up QuickBooks Import Excel and CSV toolkit is easy and involves a few basic steps. Hopefully, performing the above steps carefully might be of some help to you in successfully importing QuickBooks Excel and CSV toolkit. However, if you have any queries even after performing the steps above, or if you need any sort of technical assistance, then, in that case, feel free to consult our technical support team at  +1-844-499-6700, and our certified QuickBooks ProAdvisors will answer all your queries immediately. 

Reconcile an account in QuickBooks

Reconcile an account in QuickBooks

Reconciling an account in QuickBooks is essential so that they match the bank and credit card statements. The way to balance your checkbook, you are supposed to review your accounts in QuickBooks and ascertain that they tally with your real-life bank and credit card statements. The entire process of reviewing is what it means when you say as reconcile an account in QuickBooks. When you get your bank statement, you will have to compare each of the transactions with the ones that you entered into QuickBooks. If everything tallies, then this means that your accounts are balanced and accurate. It is recommended to reconcile QuickBooks including checking, savings, and credit card accounts every month.

To help you with the process to reconcile an account in QuickBooks, here we are with this segment sharing the complete set of steps that can be performed. Note that, the procedure for QuickBooks online and QuickBooks desktop might vary. Thus, we have tried to cover both procedures in detail. For better understanding, read this segment carefully, or you can further get on a call with our QuickBooks technical support team, for any sort of professionals guidance. Dial our toll-free customer support number i.e., +1-844-499-6700, and all your queries will be answered immediately.

Also Read: How to Reconcile Payroll Liabilities in QuickBooks? 

Steps to Reconcile an Account in QuickBooks Online

Here are the steps that can be performed by QuickBooks Online users to successfully reconcile an account in QBO.

Step 1: Review your Opening Balance

When you are reconciling an account for the very first time, it is crucial that you review the opening balance. It is important that it matches to the balance of your real-life bank account for the day you started tracking transactions in QuickBooks.

A quick tip- You can save your effort by connecting your bank and credit cards to online banking, as it automatically downloads transactions and further records the opening balance in QuickBooks for you. In case you forgot to enter an opening balance in QuickBooks previously, then need not to worry, you can perform the steps to enter an opening balance later on.

Also note that, entering a service charge and interest earned options are only available when the bank account is not connected to online banking.

Step 2: Start a Reconciliation

After you have your monthly bank or credit card statement, it is time to start with the QuickBooks reconciliation. Keep in mind that if you are reconciling multiple months, do them one statement at a time, starting with your oldest statement. The steps involved here are:

  1. Just in case your accounts are connected to online banking, ensure you match and categorize all the downloaded bank feed transactions.
  2. Now, head to the Settings tab ⚙ and further click on Reconcile. In case you are reconciling for the very first time, then click on Get Started.
  3. After that, from the Account ▼ drop-down, choose the account you wish to reconcile. Ensure it is the same one on your statement.

It should be noted that, if you witness a message regarding a previous reconciliation, then you need to opt for We can help you fix it. This needs to be fixed before you continue with the steps.

  1. Furthermore, review the Beginning Balance. Ensure that the beginning balance in QuickBooks matches the one on the statement.
  2. Now, enter the Ending balance and Ending date on the statement. Note that, certain banks might call the ending balance a new balance or a closing balance.
  3. In case you see it, review the last statement ending date.
  4. This is basically the end date of the last reconciliation. Your current bank statement should begin the day after.
  5. Once you are ready to begin, click on Start Reconciliation.

This might be helpful: How to Fix Reconcile Discrepancies in QuickBooks Desktop?

Step 3: Compare your Statement with QuickBooks

It is now time to simply compare the transactions on the statement with what’s in QuickBooks. Review them one by one. As this can be a tricky part, you need to ensure that you have the right dates and transactions in QuickBooks. Continue with the steps below for the type of account that you are reconciling.

Reconcile accounts connected to online banking

As all of the transaction info is obtained directly from the bank, reconciling becomes easy. In certain cases, the accounts are already balanced.

  1. You need to start with the first transaction on the statement.
  2. Now, look for the same transactions in the Reconciliation window in QuickBooks.
  3. After that, compare the two transactions. In case they tally, put a Checkmark next to the amount in QuickBooks. This usually marks it as reconciled.
  4. To speed up things a little bit, the transactions that you added or tallied from online banking are already selected.
Check transactions marked - Reconcile QuickBooks
  1. In case a transaction doesn’t show up on the statement, but it is present in QuickBooks, then do not put a checkmark.
  2. You need to compare each transaction on the statement with what’s in QuickBooks.

A quick tip: In case you are sure that you have found a match but something small isn’t right, like the payee, then you can choose the transaction in QuickBooks to expand the view. Further, click on edit and make the edits so the details tally.

  1. After you reach the end, the difference between the statement and QuickBooks should be $0.00. If it is, then make sure to click on Finish Now.
Finish Reconciling in QuickBooks

Reconcile accounts that aren’t connected to online banking

If your accounts are not connected to online banking, then here is what you can do:

  1. Begin with the first transaction on the statement.
  2. Find the transaction in the Reconciliation window in QuickBooks.
  3. You now have to compare the two transactions. In case they tally, you need to put a checkmark next to the amount in QuickBooks. This will mark it as reconciled.
  4. In case a transaction doesn’t show up on the statement, but you see it in QuickBooks, skip putting a checkmark.
  5. Furthermore, compare each of the transactions on the statement with QuickBooks.

Quick Tip- In case you are sure that you found a match but there is some small issue, then you can simply Edit the transaction.

  1. Now, toward the end, you will see the difference between the statement and QuickBooks as $0.00. If that is the case, then click on Finish Now.

Steps to Review Past Reconciliations

You will have to run a QuickBooks reconciliation report to review your work. The steps involved in here are:

  1. Initially, head to Settings tab and also click on Reconcile.
  2. Furthermore, choose History by Account.
  3. Now, make use of the dropdown menus to choose the account and date range.
  4. Or you can further print or export your reconciliation reports, in case you need to share them.

Steps to edit completed reconciliations

You can perform necessary changes to past reconciliations, but keep in mind that changes can unbalance the accounts and other reconciliations. It further affects the beginning balance of the next reconciliation. You need to start by reviewing a previous reconciliation report. In case you reconciled a transaction mistakenly, then you need to start over again or connect with an accountant. Note that, these changes can get a bit complicated for you to handle.

Also Read: Resolving QuickBooks Accountant Copy Failed Error

Steps to Reconcile an Account in QuickBooks Desktop

If you are a QuickBooks Desktop user, then here are the steps that you need to perform to reconcile accounts in QuickBooks Desktop.

Step 1: Review Your Opening Balance

Before you begin with reconciliation, ensure that you back up the company file. In case you are reconciling an account for the first time, then simply review the opening balance.

Step 2: Prepare for Reconciliation

Ensure that you enter all the transactions for the bank statement period you plan to reconcile. In case there are transactions that haven’t cleared the bank yet and aren’t on the statement, you need to wait to enter them.

Step 3: Start Reconciliation

After you get your bank statement, you can start reconciling. In case you are reconciling multiple months, start with your oldest bank statement. You can reconcile each month separately, one statement at a time. It should be noted that, in case you are reconciling a merchant or payments account and QuickBooks desktop sees that you aren’t signed in, then you will see a sign-in window. This further ensures that your account is successfully linked to a valid company ID.

  1. Head to the Banking menu and further choose Reconcile.
  2. Once done with that, in the Account field, choose the bank or credit card account you want to reconcile.
  3. The statement date is entered on its own. Usually, it is 30 or 31 days after the statement date of the previous reconciliation. You need to change it as needed, in order to match the bank statement.
  4. QuickBooks further enters the beginning balance. It uses the ending balance from the last reconciliation to get this number.
  5. Further, enter the ending balance based on the bank statement.
  6. You now have to enter the service charge and interest earned based on the bank statement.
  7. Do not enter charges that you have already entered in QuickBooks.
  8. Also, review the fields. In case the info is correct, choose the continue or ok tab.

In case you beginning balance doesn’t match your statement, then need not to worry. There are a few tools that can help you.

  • Just in case the number doesn’t match, choose Locate Discrepancies. This gives you reports that can be used to find discrepancies and other reconciliation issues.
  • In case you have issues, then try fixing the opening balance and beginning balance.
  • To start over from scratch, select undo the last reconciliation.

It should be noted that, when you undo a previous reconciliation, your beginning balance reverts to the beginning balance of the previous reconciliation. Moreover, all cleared transactions on the reconciliation become uncleared.

Also Check This Out: How to Use Undeposited Funds Account to Receive Payments in QuickBooks Online?

Step 4: Compare Bank Statement and QuickBooks

In order to reconcile, simply compare the list of transactions on the bank statement with what’s in QuickBooks. Ensure that you have the right dates and transactions. After you are done reviewing the statement, you will know everything made it into QuickBooks.

Here are a few things that you can do to make reconciliation is little easier.

  • In case you only want to see the transactions for the statement period you are working on, simply choose Hide transactions after the statement’s end date.
  • Or if you are reconciling a credit card account, then the sections are Charges and Cash Advances and Payments and Credits. Focus on one section at a time.
  • In case you are reconciling an account for online banking, then choose Matched.
  • You now have to enter the Statement Ending Date from your bank statement. This automatically selects transactions QuickBooks downloaded and matched.

Note that, a matched transaction in the register has a lightning bolt next to ti. Once you reconcile it, a checkmark replaces the lightning bolt.

  • In case you want to sort the list, choose the header or title of a column.
  • Or if there are more transactions in QuickBooks than there are on your bank statement, resort the list.

Match Your Transactions

  • Once you are ready, start with the first transaction on the statement.
  • Now, find the same one in the reconciliation window in QuickBooks.
  • You now have to compare the two transactions. In case the transactions match, choose and put a checkmark in the checkmark column.
  • This reconciles the transaction.
  • You need to compare each transaction on your statement with what’s in QuickBooks.
  • As you clear or add transactions to the reconciliation, the Cleared Balance amount decreases.
  • The amount increases, in case you clear or add deposits and other credit amounts.
  • In case a transaction doesn’t appear on the statement, do not mark it as reconciled. Here are the ways to check if things tally or not:
    • In case you wish to see the total number and amount of transactions you have added to the reconciliation, you need to look for the items you have marked in the cleared section. The majority of banks provide the same summary of transactions on bank statements. You need to compare the total number of transactions to see if anything is missing.
    • Just in case you want to edit or get more info about a specific transaction, then select the transaction and then click on Go To or double click.
    • If you want to take a step back and make a change to the info you entered in Step 3: Start your reconciliation, then choose Modify. The service charges, interest, and ending balance info are available in the section next to it.
  • After you reach the end, the difference between the bank statement and QuickBooks should be $0.00. If that is the case, then choose Reconcile Now.

What to do if balances don’t match after you Reconcile QuickBooks?

In case the difference isn’t zero, then you can fix it using a bunch of steps. For bank accounts, QuickBooks opens the Reconcile Adjustment window. You have the following options:

  • Return to Reconcile: Head to the reconciliation to review everything again.
  • Leave Reconcile: You need to save the reconciliation so you can review or edit any existing transactions causing issues. You can come back and finish the reconciliation process later on.
  • Enter Adjustment: In case you wish to complete the reconciliation, you can force QuickBooks to create an adjustment to balance everything. This should only be done if you know all of the correct transactions are in QuickBooks and what you entered is right. QuickBooks will automatically enter the adjustment as a journal entry.

The journal entry goes into a special expense account termed as reconciliation discrepancies.

Steps to review the reconciliation Adjustment

In order to find all your adjustments on your list, you can simply review a previous reconciliation report for the reconciliation you adjusted. This will show the cleared transactions and any changes that are made after the transaction that may not show in the discrepancies.

  • Begin with the edit menu, and choose the find tab.
  • Now, in the find window, choose the Advanced tab and then head to Memo.
  • The next step in the memo field, type Balance Adjustment, and choose Find.

Also Read: How to Manage Your Account, Products, and Subscriptions in QuickBooks?

Review Cleared Transactions

You can try to review all the cleared transactions using the set of steps enumerated below. Let us have a look:

  1. At first, navigate to the Reports Menu and choose Reports Center.
  2. After that, search and open the Previous Reconciliation Report
  3. Now, choose the account you reconciled, then either detail, summary or both.
  4. Go for transactions cleared, plus any changes that are made to those transactions since the reconciliation.
  5. You now have to choose Display.

Note that, for other types of accounts, QuickBooks opens the Make Payment Window. This will let you write a check or enter a bill to pay to cover the outstanding balance. In case you do not want to record a payment, then choose the Cancel tab.

In case you run into issues or discrepancies, which simply means that the transactions in QuickBooks do not tally to the bank statement, then need not to worry. You can fix the mismatches by performing some simple steps.

Review Reconcile QuickBooks

Once you reconcile, you can choose the Display tab to view the Reconciliation report or Print to print it. In case you want to review a reconciliation report later on, then simply carry out the below steps:

  1. Head to the Report menu, and choose Reports Center.
  2. Now, search and open a previous reconciliation report.
  3. Choose the account you reconciled, then either Detail, Summary, or Both.

Conclusion!

Now that you know the correct ways to reconcile an account in QuickBooks desktop and QuickBooks online, it is time to implement these steps. Hopefully, this segment might be helpful in successfully reconciling in QuickBooks. However, if you have any queries, or if you need our support and assistance at any point in time, then give us a call at +1-844-499-6700, and all your queries will answered immediately.

Other Related Articles:

How to Setup QuickBooks Online Bank Reconciliation: Process & Overview? [Guide]

How to Fix Banking Error 9995 in QuickBooks Online?

Compile Error in Hidden Module – QuickBooks [FIX]

How to Change Email Template in QuickBooks?

Buy QuickBooks Today!


contact our male customer

Buy the all-new QuickBooks today!

Connect With QuickBooks Experts

Dial our toll-free number

1-844-405-0907

This contact form is available only for logged in users.

This will close in 0 seconds

Looking for QuickBooks Help?


This will close in 0 seconds