Pinterest

QuickBooks Check Register: How to Use, Print, Import and Export?

Here you can learn about What is Check Register in QuickBooks and How to Use, Print, Import and Export QuickBooks Check Register. Change the Default Check Register in QuickBooks.

Voiced by Amazon Polly

QuickBooks check register works like a journal. It is helpful for recording your company’s cash transactions as well as checks. The QuickBooks check register also gives you the option to edit the transactions and find out the dates of the payments, among other things. In addition to the QuickBooks program, QuickBooks Online and QuickBooks Desktop both let you create and access this journal.

Save Time, Reduce Errors, and Improve Accuracy

Dancing Numbers helps small businesses, entrepreneurs, and CPAs to do smart transferring of data to and from QuickBooks Desktop. Utilize import, export, and delete services of Dancing Numbers software.

For keeping a personal record, the check register and the splitting details can be printed. You might occasionally want to make another register as the default register before printing it. It’s interesting to note that you may export the check register in QuickBooks, QuickBooks Online, and other versions to Excel using the same file that you save for printing. You can also print the check register reports in the software to meet specific company needs. You can read the complete blog to learn more about how to use QuickBooks to print the check register and other things.

The use, printing, running, exporting, and importing of the QuickBooks check register are topics covered in several on this blog. These parts have been changed to modify you with different methods. These techniques are briefly illustrated here:

What is a Check Register in QuickBooks?

QuickBooks has a check register that can be used for a number of functions. The check register may also be viewed as a journal for cash disbursement. This journal will record the cash and check transactions for a specific accounting period. Transactions may be quickly tracked with the QuickBooks check register. Knowing the history of transactions on your account is also helpful. Overall, this is a part of the accounting software through which many important functions and tasks related to checks and transactions can be executed.

Benefits of Using QuickBooks Desktop Check Register Report

A check register plays a significant role in the accounting process. The check register lists every type of transaction that the company makes. You can make changes to the spending if necessary. Additionally, Check Registers deliver a real-time bank balance report that includes the remaining amount for spending. You should be aware of the several benefits that the QuickBooks Desktop check register report offers. For example:

  • It is beneficial to spot mistakes like missing checks.
  • The report makes it easier to keep track of transactions and stay organized.
  • The bank statement reconciliation gets simpler.
  • You can keep track of the amount of your spending.
  • The QuickBooks check register report helps to avoid overspending.
  • You begin to see how to create better budgets.
  • You can find an accurate balance using the report.

How to Use the Check Register in QuickBooks?

The following tasks or functions can be used using the QuickBooks check register:

  • You may view and trace your transactions using this tool like simple checks.
  • The register makes it possible for you to identify where the payments come from.
  • It is used to check the account’s current balance, account transaction history, and other information.
  • You can use filters in QuickBooks check register for locating different types of transactions.
  • This software function can be used to edit, void, and delete any transaction.
  • Through this feature of the software, the reconciliation of the transactions, individual payments, etc., can be prepared and examined.

How to Print Check Register in QuickBooks?

Check registers can be printed using QuickBooks Edit menu. The Accounting or Lists menu may be used in some accounting software systems to assist in printing the register. The dates for which the register needs to be printed must be provided by the users. There will now be a printing option for the Splits Details during the process. Depending on the choices of the users, this option may be selected.

There are three methods to print a check register in QuickBooks Desktop and Online. These methods have been properly discussed below in the following ways:

Method 1: Print a Check Register in QuickBooks

By launching the Edit menu in QuickBooks, you can print a check register. Go to Use Register and select the Account dropdown menu. You can input the dates for printing the register after choosing the account. You have the option to print the Splits Details if you need them as well. Finally, all you have to do is click the Print button.

  • To access this menu you will see the Edit menu at the top
  • Select Use Register.
  • Select an account from the Account dropdown menu.
  • Choose Ok.
  • The date that the register should be printed should be written down.
  • When necessary, only choose “Print Splits Details”.
  • Click on OK and then tap on Print.

Method 2: Printing a Check Register in QuickBooks Online

If someone wants to maintain a personal record, then certain users of QuickBooks Online may need to print a check register. For printing it you will be advised to use the Accounting option. You can move to COA from accounting. The Chart of Accounts will allow you in picking your bank’s name. Before printing it you can tap on View Register to look at it. You can determine the Date Range based on the dates for which the register is required.

Let us now walk you through the process step-by-step of printing a check register in QuickBooks Online.

  • Choose Accounting from the menu on the left.
  • Click or tap Chart of Accounts.
  • The third step is picking the name of your bank.
  • Select the View Register option.
  • Choose the Funnel icon.
  • Choose a Date Range from the dropdown menu. The range ought to depend on the period for which the records are needed.
  • Click Apply.
  • From the menu, You have to click on the Print List.

Method 3: Printing the QuickBooks Desktop Check Register

It’s possible that you’re running the QuickBooks Desktop Version of the software. It has a Lists option where you can print the check register. Choose Chart of Accounts from Lists. Next, select QuickReport [Bank Account] from the menu. Dates can be added, and the report can be customized to your choice. You’ll be able to begin printing the register soon.

You can print check registers in QuickBooks Desktop by following these steps:

  • Choose Lists from QuickBooks Desktop.
  • Open the Chart of Accounts.
  • Right-click on your bank account and select QuickReport [Bank Account].
  • Make the changes to the date.
  • Press Customize Report once and then select Filters.
  • From the list of Search Filters, pick Transaction Type.
  • Use Check from the dropdown menu.
  • Click on OK. Printing on the check register will begin.
  • Decide on your bank’s name.
  • Select View Register from the menu.
  • The drop-down menu will then appear when you click the Funnel icon.
  • For the time period that you want to print, select a Date range.
  • Press the Apply button.
  • To print the check register, click the Print List icon now.

This is how QuickBooks Online allows you to print the check register. Simply choose a time period for results display and get your prints.

How to Change the Default Check Register in QuickBooks?

Certain selections must be made in the QuickBooks program in order to modify the default check register. First, the user must select a default account for both making and wiring checks. A default account will work as a requirement for the Paychecks. After that, you can choose a different default account for deposits and checks. Both the Settings icon and the Edit menu can be used to make these selections.

The default accounts for the check register may not be clear to readers who are unfamiliar with QuickBooks. You can choose them by following the set of instructions described below:

  • A default account will be required in order to create and write the checks. Click Edit to choose it.
  • You have to choose preferences
  • Search for Checking and then select it to continue.
  • Choose the following default account:
  • The default account needs to be selected for the paychecks. Open the Edit menu to do this.
  • Check out Preferences.
  • Checking must be clicked after being made available on the left.
  • The Company Preferences tab should be selected.
  • Go to the Select Default Account to Use section.
  • Select Open the Create Paychecks Form with Account from the drop-down menu.
  • Make sure the right account is selected
  • The default account can be used for both checks and deposits. You choose it using the QuickBooks Gear icon. Press it once.
  • Then select Account and Settings and then click on Advanced
  • Place Pre-fill Forms with Previously Entered Content with a checkmark.
  • Then head to the section that is named Automation and then hit on save.
  • Lastly, after completing click on done.

You might have changed QuickBooks default check register using this method. It is a lengthy process. However, this method will give you all the procedures necessary to change the default check register in the QuickBooks program for various purposes. Don’t miss any steps as all are important.

How to Export a Check Register from QuickBooks?

In QuickBooks, you must visit the software’s dashboard in order to export check registers. You have the option to print a specific register. You will be able to save a file for printing the register by doing this. You can export the data from the QuickBooks check register using this file.

We have provided more information on exporting the check registers from QuickBooks in the subsections that follow. Additionally, you will be taught how to export the check register from QuickBooks and QuickBooks Desktop to Excel.

Method 1: Export the Check Register in QuickBooks

You may already be aware of the options available on the QuickBooks program’s dashboard. Banking will also be displayed. With this choice, you can export the check register. You may access Edit by clicking Banking. This will take you to a dropdown menu from which you must choose the Use Registers option. Then you have to choose which check register has to be exported. Continue administering the remaining steps after this.

By scrolling down, you can find out more about the remaining steps of this method.

  • Log in to the QuickBooks Dashboard.
  • Select the Banking-related tab by tapping it.
  • Click the option of Edit.
  • Go to Use Registers in the dropdown menu.
  • You’ll find a list. Multiple check registers will be mentioned in the list. To continue exporting the list, select a check register after reading it.
  • Click on Ok.
  • The Date Range button can be found under the Print tab. The range for which the register is required must be entered.
  • Tap Ok in the dialogue box.
  • Select File. The Settings menu will contain this option.
  • Certain options will be listed. Choose from one of them.
    • Comma Delimited File
    • ASCII Text File
    • Tab Delimited File
  • Choose the location. For this purpose, the browse option can be of help.
  • You can press save after visiting the selected location.

Note: There will be a dropdown menu available. It can be applied to selecting a suitable file format. The chosen format will be applied when the check register is exported from this accounting software to Excel. It would also be helpful to know that QuickBooks Desktop offers the choice of applying specific filters. You can choose the date range using these criteria. Your data will be exported to Excel from QuickBooks Desktop based on the set range.

How to Import Excel into QuickBooks Check Register?

You might want to import the check transactions into your QuickBooks Desktop in several instances. CSV or an Excel file can be used for this. You can do the following to import Excel into the QuickBooks check register:

  • Select Accountant from the menu.
  • Then select Batch Enter Transactions from the menu.
  • Using the Transaction Type drop-down, choose the Checks button.
  • Choose a bank or credit card.
  • Open the spreadsheet now, and in QuickBooks papers, customize the columns. As an alternative, you can rearrange the columns to match your file by using the Customize button.
  • You can paste your transaction here directly from an excel spreadsheet or file into QuickBooks.
  • Click Save Transaction to finish.
  • Select Yes from the menu.
  • Press OK to confirm.

You may quickly import transactions using an Excel file into your QuickBooks account by following these steps.

How to Get the Check Register in QuickBooks?

Unlike many QuickBooks options, the check register cannot be viewed as soon as the software is opened. You’ll need to look for it. The View Register option will be quite useful for finding it. You can know how to find the check register in QuickBooks Online by using the same option.

Let’s now go through the details of how to obtain the check register using the mentioned option. These have been provided using the methods given below.

Method 1: Finding the QuickBooks Check Register

The View Register option can be used to view the QuickBooks check register. The Chart of Accounts contains this option. You should think about selecting Accounting from the QuickBooks menu to access COA. You may examine the check register, check your transactions, import it, and do a lot more after it has been found.

  • Look at the accounting software’s left-hand panel.
  • Make your way to Accounting from the panel.
  • At this point, you must choose the COA tab.
  • Access your account by using the Chart of Accounts.
  • It will appear as a dropdown. Click the arrow there.
  • The next step is to select View Register from the menu.

You can view the check register with the help of this option. If you’ve prepared multiple registers in QuickBooks, you can view them one by one.

Method 2: Locating the Check Register in QuickBooks Online

The check register can be accessed using QuickBooks Online in this section. The process of locating the register in this accounting version is comparable to that in QuickBooks.

To get started, you must click the Accounting button. After that, you must view QBO’s Gear icon. The Chart of Accounts can be available by pressing this icon. It will have a feature that allows you to view the registration. The check register will appear as soon as you click on it. You might want to sort the register. You might decide to sort it according to the Reference Number. Additionally, the Date and Amount can be used to sort it.

  • To begin, you have to press the Accounting button.
  • To access the COA or Chart of Accounts, click the Gear symbol.
  • Once you’ve located your account, click View Register.
  • Sort the check register according to “Reference Number, Date, or Amount”.

How to Run a Check Register Report in QuickBooks?

The check register report could be required for business-related purposes. After locating the register, you can run this report. You can easily locate the QuickBooks check register using the Chart of Accounts in QuickBooks Desktop, after which you can run the report for it. You also have the choice to run the check register report if you’re using QuickBooks Desktop.

You can run the check register report in QuickBooks and QuickBooks Desktop when you are equipped with the complete method. The following paragraphs will introduce two methods. With the help of these methods, it will provide you with the necessary steps to access the register and run the report.

Method 1: Run a QuickBooks Check Register Report

Companies keep important data in check registers within the QuickBooks software. These registers’ reports are equally important. They are accessible and viewable from the COA (Chart of Accounts). This feature will enable you to find a dropdown. Then choose View Register from the dropdown menu by pressing it. Now you can run the report. You can use the Customize option to add any change.

All the steps for running the check registers reports in QuickBooks are mentioned below:

  • On the left, you will see Accounting. Pick this option.
  • Click on a checking account in the COA or Chart of Accounts.
  • By pressing the dropdown, select View Register.
  • Now you have to select Run Report.
  • Only select Customize to make certain changes to the report. If not required, you can skip this option.

Note: With the help of Customize feature you can make different types of changes to the QuickBooks check register report. In this, you can edit and make changes too.

Method 2: Running a QuickBooks Desktop Check Register Report

The Accounting option in QuickBooks Desktop can be used to access the check register. Immediately upon the software’s launch, this option can be found. To access the tab for the Chart of Accounts, choose this option (COA). The checking account can be found via the tab. You must now find action and select from the dropdown menu that is available below it. The View Register option will be available in the dropdown. Select it, then choose Run Report.

  • Running “QuickBooks Desktop” is the first step.
  • Open the Accounting tab.
  • To access the Chart of Accounts tab, click it.
  • Start looking for the checking account from this tab.
  • Below look for Action below. There will be a dropdown. Press it.
  • Then choose View Register.
  • Click the Run Report button.

The check register serves as an important journal in QuickBooks, allowing for the recording of several transactions. Users of the accounting software have reported that this register has been quite helpful for keeping track of checks and cash transactions as well. In this, you will learn in detail about the check registers in QuickBooks. Additionally, you received instructions on printing, exporting, and running the check register reports. Using this feature will be simple now that you are well-versed in it.

In case you face any issue related to QuickBooks Check Register: How to Print, Export, and Import then you can connect with Dancing Numbers expert via LIVE CHAT any time as experts are available at round the clock for their users.

Accounting Professionals, CPA, Enterprises, Owners
Accounting Professionals

Looking for a professional expert to get the right assistance for your problems? Here, we have a team of professional and experienced team members to fix your technical, functional, data transfer, installation, update, upgrade, or data migrations errors. We are here at Dancing Numbers available to assist you with all your queries. To fix these queries you can get in touch with us via a toll-free number
+1-347-428-6831 or chat with experts.


Frequently Asked Questions (Faqs)

Is it Possible to Import Checks into QuickBooks Desktop?

Yes, It is possible to import transactions using the QuickBooks 2021 Accountant Batch Entry feature. If you want to import then you can choose from the Transaction Type selection, you have the option to import Checks, Credit Card Charges, Deposits, and Credits Bills Bill Credits, Invoices and, Credit Memos.

How to Import Expenses from a CSV File?

• Choose Banking from the Transactions tab.
• Select Upload from file from the Drop-down menu for Link Account.
• Then select files by dragging them onto the button.
• Choose the CSV file, then click Open.
• Now, choose the account you wish to upload the transactions into from the QuickBooks account dropdown.
• To match the columns on the file with the appropriate fields in QuickBooks, follow the steps that are visible on the screen.
• Now you have to select the transactions and then click on Yes.
• Lastly, click on Let’s go

How to Create a New Register in QuickBooks?

• Firstly you have to the Intuit accounts page.
• Then you have to select the Create an account link.
• Please provide your phone number and email address. You may already have an account if you see the message this user ID is already taken.
• Now you will have to create a password
• Select Create Account when you are ready.

How to Format a Check in QuickBooks?

• First, you have to start by selecting +New.
• Now you have to select Print checks and then select Print setup.
• After that select your check type, voucher, or standard.
• Then select View preview and then print sample and then select Print.
• Now you have to follow the steps that are visible on the screen to finish printing your sample check.
• Under a blank check, you have to put the sample print.

Features of Dancing Numbers for QuickBooks Desktop

Imports

Imports

Exports

Exports

Deletes

Deletes

Customization

Customization

Supported Entities/Lists

Dancing Numbers supports all QuickBooks entities that are mentioned below:-

Customer Transactions

Invoice
Receive Payment
Estimate
Credit Memo/Return Receipt
Sales Receipt
Sales Order
Statement Charge

Vendor Transactions

Bill
Bill Payment
Purchase Order
Item Receipt
Vendor Credit

Banking Transactions

Check
Journal Entry
Deposit
Transfer Funds
Bank Statement
Credit Card Statement
Credit Card Charge
Credit Card Credit

Employee Transaction / List

Time Tracking
Employee Payroll
Wage Items

Others

Inventory Adjustment
Inventory Transfer
Vehicle Mileage

Technical Details

Easy Process

Easy Process

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Error Free

Error Free

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

On-time Support

On-time Support

We provide round the clock technical assistance with an assurance of resolving any issues within minimum turnaround time.

Pricing

img

Importer, Exporter & Deleter

*See our Pricing for up to 3 Company Files

$199/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Unlimited Export
  • Unlimited Import
  • Unlimited Delete

img

Accountant Basic

*See our Pricing for up to 10 Company Files.

$499/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer,Exporter,Deleter
  • Unlimited Users
  • Unlimited Records
  • Upto 10 companies

img

Accountant Pro

*See our Pricing for up to 20 Company Files.

$899/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 20 companies

img

Accountant Premium

*See our Pricing for up to 50 Company Files.

$1999/- Per Year

Pricing includes coverage for users
  • Services Include:
  • Importer, Exporter, Deleter
  • Unlimited Users
  • Unlimited Records
  • Up to 50 companies

Dancing Numbers: Case Study

Frequently Asked Questions

 
How and What all can I Export in Dancing Numbers?

You need to click "Start" to Export data From QuickBooks Desktop using Dancing Numbers, and In the export process, you need to select the type you want to export, like lists, transactions, etc. After that, apply the filters, select the fields, and then do the export.

You can export a Chart of Accounts, Customers, Items, and all the available transactions from QuickBooks Desktop.


How can I Import in Dancing Numbers?

To use the service, you have to open both the software QuickBooks and Dancing Numbers on your system. To import the data, you have to update the Dancing Numbers file and then map the fields and import it.


How can I Delete in Dancing Numbers?

In the Delete process, select the file, lists, or transactions you want to delete, then apply the filters on the file and then click on the Delete option.


How can I import Credit Card charges into QuickBooks Desktop?

First of all, Click the Import (Start) available on the Home Screen. For selecting the file, click on "select your file," Alternatively, you can also click "Browse file" to browse and choose the desired file. You can also click on the "View sample file" to go to the Dancing Numbers sample file. Then, set up the mapping of the file column related to QuickBooks fields. To review your file data on the preview screen, just click on "next," which shows your file data.


Which file types are supported by Dancing Numbers?

XLS, XLXS, etc., are supported file formats by Dancing Numbers.


What is the pricing range of the Dancing Numbers subscription Plan?

Dancing Numbers offers four varieties of plans. The most popular one is the basic plan and the Accountant basic, the Accountant pro, and Accountant Premium.


How can I contact the customer service of Dancing Numbers if any issue arises after purchasing?

We provide you support through different channels (Email/Chat/Phone) for your issues, doubts, and queries. We are always available to resolve your issues related to Sales, Technical Queries/Issues, and ON boarding questions in real-time. You can even get the benefits of anytime availability of Premium support for all your issues.


How can I Import Price Level List into QuickBooks Desktop through Dancing Numbers?

First, click the import button on the Home Screen. Then click "Select your file" from your system. Next, set up the mapping of the file column related to the QuickBooks field. Dancing Numbers template file does this automatically; you just need to download the Dancing Number Template file.

To review your file data on the preview screen, just click on "next," which shows your file data.


What are some of the features of Dancing Numbers to be used for QuickBooks Desktop?

Dancing Numbers is SaaS-based software that is easy to integrate with any QuickBooks account. With the help of this software, you can import, export, as well as erase lists and transactions from the Company files. Also, you can simplify and automate the process using Dancing Numbers which will help in saving time and increasing efficiency and productivity. Just fill in the data in the relevant fields and apply the appropriate features and it’s done.

Furthermore, using Dancing Numbers saves a lot of your time and money which you can otherwise invest in the growth and expansion of your business. It is free from any human errors, works automatically, and has a brilliant user-friendly interface and a lot more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


Is it possible to use the Direct Connect option to sync bank transactions and other such details between Bank of America and QuickBooks?

Yes, absolutely. You can use the Direct Connect Option by enrolling for the Direct Connect service which will allow you access to the small business online banking option at bankofamerica.com. This feature allows you to share bills, payments, information, and much more.


Why should do you change the Employee status instead of deleting them on QuickBooks?

If you are unable to see the option to terminate an employee on your list of active employees on the company payroll, this mostly implies that they have some history. Thus, if you change the employee status instead of deleting it on QuickBooks, the profile and pay records remain in your accounting database without any data loss in your tax payments.


What are the various kinds of accounts you could access in QuickBooks?

QuickBooks allows you to access almost all types of accounts, including but not limited to savings account, checking account, credit card accounts, and money market accounts.

Get Support

Bulk import, export, and deletion can be performed with simply one-click. A simplified process ensures that you will be able to focus on the core work.

Worried about losing time with an error prone software? Our error free add-on enables you to focus on your work and boost productivity.

Book your consultation Book Free Consultation
Close X
Call Now+1-800-596-0806
Dancing Number

We value your privacy and are strongly against any kind of phishing, spam, and malware. We collect your information for our legitimate business purpose only. This information is safe with our in-built security.

X



    Top