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

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.

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 Check Register in QuickBooks

The check register in QuickBooks is a handy tool for keeping track of your financial transactions. It allows you to easily record and monitor all outgoing payments, including checks, in one central location. You can use it to manage and reconcile bank transactions by comparing them to the entries in the check register.

It helps you maintain accurate financial records and ensures proper documentation of payments made. With the check register, you can identify any discrepancies or errors and make necessary adjustments. It also enables you to generate reports and statements for auditing and financial analysis.

In short, the check register simplifies the bookkeeping process and improves overall financial management. It’s a great productivity tool within QuickBooks that helps you stay organized and in control of your finances.

Use Cases for Check Register in QuickBooks:

• Tracking and recording all outgoing payments, including checks, in one central location.
• Managing and reconciling bank transactions by comparing them to the entries in the check register.
• Monitoring cash flow and ensuring accurate financial records by keeping track of expenses.
• Identifying discrepancies or errors in payments made and ensuring proper documentation.
• Generating reports and statements for auditing and financial analysis.
• Facilitating the process of bank reconciliation by providing a clear record of all transactions.
• Streamlining the bookkeeping process and improving overall financial management.

Benefits of Check Register

• Streamlining the bookkeeping process and improving overall financial management.
• Tracking and recording all outgoing payments in one central location.
• Monitoring cash flow and ensuring accurate financial records.
• Facilitating the process of bank reconciliation.
• Managing and reconciling bank transactions.
• Generating reports and statements for auditing and financial analysis.
• Identifying discrepancies or errors in payments made.

QuickBooks Desktop Check Register

Check register in QuickBooks Desktop gives access to all the transactions in a particular account. You can use the check register to view the transactions, make quick edits, mark entries as cleared or reconciled. The ability to quickly make changes to transactions and add new ones makes check registers the best productivity tool inside this accounting software.

How to Find, Use and Print Check Register in QuickBooks Desktop?

Each account has its own check or bank register that you can access easily. The check register displays the transaction in that account.

To access the Check Register for an account in QuickBooks Desktop, follow these steps:

• Open QuickBooks Desktop and log in to your account.
• From the main menu, click on the “Banking” tab.
• In the drop-down menu, Select “Use Register“.
• A window will appear showing a list of accounts. Choose the account for which you want to access the Check Register and click on it.
• The Check Register for the selected account will now be displayed on your screen. Here, you can view and manage all the transactions related to that account.

Remember to save your change and close the Check Register window when you are done.

Please note that the exact steps may vary slightly depending on the version of QuickBooks Desktop you are using.

Print: You can save a hardcopy or softcopy of the check register by selecting the print option.

It is possible that you are using the QuickBooks Desktop Version of the software. This version includes a Lists option that enables you to print the check register.

To do this, follow these steps:

• Go to the Lists section in QuickBooks Desktop.
• Open the Chart of Accounts.
• Right-click on your bank account and select Quick Report [Bank Account].
• Adjust the date as needed.
• Click on Customize Report and then select Filters.
• From the list of Search Filters, choose Transaction Type.
• Select Check from the dropdown menu.
• Click on OK to apply the filter. The check register will now be ready for printing.
• Choose your bank’s name.
• Select View Register from the menu.
• Click on the Funnel icon to access the drop-down menu.
• Set a specific Date range for the register you want to print.
• Press the Apply button to confirm the date range.
• Finally, click on the Print List icon to print the check register.

These are the steps to print the check register in QuickBooks Online. Simply select a period to display the results and proceed with printing.

How to Change Default Check Register in QuickBooks Desktop

To change the default check register in QuickBooks Desktop, all you have to do is make a few choices within the program. First, pick a default account for writing checks and making wire transfers, which is super important for paychecks.

Also, you can choose a different default account for deposits and checks. How cool is that?

• Open QuickBooks Desktop and log in to your account.
• From the main menu, go to “Edit” and select “Preferences“.
• In the Preferences window, choose “Checking” from the left-hand side.
• Click on the “Company Preferences” tab.
• In the “Select Default Account to Use” section, choose “Open the Create Paychecks Form with Account” from the drop-down menu.
• Select the desired default account for paychecks.
• Click on “OK” to save the changes.
• To select the default account for checks and deposits, click on the Gear icon and choose “Account and Settings“.
• In the Account and Settings window, select the “Advanced” tab.
• Enable “Pre-fill Forms with Previously Entered Content“.
• In the Automation section, click on “Save” and then click on “Done” to exit.

So, go ahead and use either the Settings icon or the Edit menu to make these choices. Just make sure you select the right default accounts for paychecks and other transactions. Don’t worry, it’s not too complicated. Once you’ve done these steps, just click save and you’re good to go. It’s as easy as pie!

How to Export Check Register from QuickBooks

You can use the transaction list by account report to export the check register for that account. By default, you don’t have an option to directly export the check register as is.

But since the check register contains only the transactions for an account, you won’t be settling when exporting a list of transactions by account.

To export the check register from QuickBooks, you can follow these steps:

• Open QuickBooks and log in to your account.
• From the main menu, click on the “Reports” tab.
• In the search bar, type “Transaction List by Account” and select it from the results.
• In the “Report period” section, select the desired date range for the check register.
• Under the “Display” section, choose the appropriate options for the report layout and formatting.
• Click on the “Run Report” button to generate the Transaction List by Account report.
• Once the report is displayed on the screen, click on the “Export” button.
• Choose the file format you want to export the report to, such as Excel or PDF.
• Select the destination folder where you want to save the exported file.
• Click on the “Save” button to export the check register from QuickBooks.

Please note that the exact steps may vary slightly depending on the version of QuickBooks you are using. If you export to Excel format, you’ll be able to further analyze the data using the formula in spreadsheet. And if you’ve the advanced plan of QuickBooks online, you can use the spreadsheet sync option to take your data into Excel, make changes, and then sync those changes to QuickBooks Online.

How to Import Excel into QuickBooks Check Register

Instead of importing check register into QuickBooks, you can import transactions for a particular account.

To import transactions from Excel into QuickBooks Desktop, you can follow these steps:

1. Prepare your Excel file: Make sure your Excel file contains the necessary transaction data, such as date, amount, account, and other relevant information. Ensure that the column headers in your Excel file match the corresponding fields in QuickBooks Desktop.
2. Open QuickBooks Desktop: Launch QuickBooks Desktop and log in to your company file.
3. Access the Import Data utility: From the main menu, go to “File” and select “Utilities“. Then, choose “Import” and click on “Excel Files“.
4. Select the Excel file: Click on “Browse” or “Select File” to locate and select your Excel file containing the transactions you want to import.
5. Map the fields: QuickBooks Desktop will prompt you to map the fields in your Excel file to the corresponding fields in QuickBooks Desktop. Follow the instructions provided and map each field accordingly.
6. Review and Adjust Mappings: After mapping the fields, QuickBooks Desktop will display a preview of the data to be imported. Review the mappings to ensure accuracy. If needed, make any adjustments or corrections.
7. Import the Transactions: Once you are satisfied with the mappings, click on the “Import” button to initiate the import process. QuickBooks Desktop will import the transactions from your Excel file into the appropriate accounts.
8. Review Imported Data: After the import is complete, review the imported transactions in QuickBooks Desktop to ensure everything is accurate and reflects the information from your Excel file.

Note: the steps may differ based on the version of QuickBooks Desktop that you’re using. If you’re using an old version of QuickBooks, you can upgrade to the new one for the latest features and tools.

How to Run Check Register Report in QuickBooks Desktop

Running a check register report in QuickBooks Desktop is a straightforward process. To get started, go to the Chart of Accounts and select the account you want to generate the report for. Then, click on the “Run Report” button.

This will display a comprehensive list of all the transactions in that account. You can easily review and analyze the data, making it a useful tool for tracking your financial activities. The report allows you to identify any discrepancies or errors, ensuring the accuracy of your records.

It’s a valuable feature that helps you stay organized and in control of your finances, making financial management a breeze in QuickBooks Desktop.

Steps to Run Check Register Report in QuickBooks Desktop:

• Go to the Chart of Accounts in QuickBooks Desktop.
• Select the drop-down against the account for which you want to run the report.
• Select Run Report.

A check register in QuickBooks Desktop contains a comprehensive record of all financial transactions related to a specific account. It includes details such as the date, payee, amount, and memo for each transaction.

The check register allows users to easily track and monitor outgoing payments, including checks, and reconcile them with bank statements.

It provides a centralized view of all transactions, helping users maintain accurate financial records and identify any discrepancies or errors. And the check register enables users to generate reports and statements for auditing and financial analysis, providing valuable insights into their financial activities and improving overall financial management.

QuickBooks Online Check Register

The QuickBooks Online check register is a useful tool for managing your financial transactions. With the check register, you can easily keep track of all your incoming and outgoing payments in one convenient location. It allows you to view and edit transactions, ensuring accurate record-keeping.

You can also reconcile your bank statements by comparing them to the entries in the check register. This helps you identify any discrepancies or errors and make necessary adjustments.

The check register in QuickBooks Online simplifies the process of managing your finances and gives you greater control over your financial activities.

Locating the Bank Register in QuickBooks Online

To access the check register in QuickBooks Online, head over to this section. The process of finding the register in this accounting version is pretty much the same as in QuickBooks.

To get started, just click on the Accounting button. After that, you’ll need to locate QBO’s Gear icon. You can find the Chart of Accounts by clicking on this icon. It has a feature that lets you view the register. Simply click on it and the check register will pop up. If you want, you can sort the register. You can choose to sort it by Reference Number. Alternatively, you can use the Date and Amount to sort it.

A detailed explanation on how to access the check register in QuickBooks Online:

• Start by clicking on the Accounting button, which you can find in the navigation menu of QuickBooks Online.
• Once you click on the Accounting button, look for the Gear icon located in the upper-right corner of the page. Click on it to access additional options.
• In the menu that appears after clicking on the Gear icon, you will see various sections. Look for the Chart of Accounts option and select it.
• The Chart of Accounts will display a list of all your accounts. Locate the account for which you want to access the check register and click on it.
• After selecting the account, you will be directed to the check register page. Here, you can view all the transactions associated with that particular account.
• To sort the check register, you have a few options. You can choose to sort it by Reference Number, Date, or Amount. Simply click on the desired sorting option to arrange the register accordingly.

By following these steps, you can easily access and navigate the check register in QuickBooks Online. It’s a convenient way to keep track of your transactions and manage your finances effectively.

How to Find, Use and Print Check Register in QuickBooks Online

To find, use, and print the check register in QuickBooks Online, you can easily follow these steps. First, click on the “Accounting” tab from the left menu. Then, select “Chart of Accounts” and pick your bank’s name. Next, choose the “View Register” option to access the check register. Here, you can see all your transactions and make any necessary edits.

If you want to print the check register for your personal records, simply click on the “Funnel” icon and select a date range that corresponds to the desired register period. Finally, click on the “Print List” option, and you’re all set. It’s a straightforward process that allows you to easily manage and keep track of your financial transactions.

If someone wants to maintain a personal record, QuickBooks Online users may need to print a check register. To do this, follow these steps:

• Choose Accounting from the menu on the left.
• Click or tap Chart of Accounts.
• Select your bank’s name.
• Choose the View Register option.
• Click the Funnel icon.
• Select a Date Range from the dropdown menu that corresponds to the desired register period.
• Click Apply.
• From the menu, click on Print List.

By following these steps, you will be able to print a check register in QuickBooks Online. The check register in QuickBooks Online is a useful tool for managing your financial transactions. It allows you to easily keep track of both incoming and outgoing payments in one convenient location.

How to Change Default Check Register

Certain selections need to be made in the QuickBooks program to modify the default check register. First, the user should select a default account for making and wiring checks. This default account is required for Paychecks. Additionally, a different default account can be chosen for deposits and checks. Use the Settings icon or the Edit menu to make these selections.

The default accounts for the check register may not be clear to readers unfamiliar with QuickBooks. Follow the instructions below to choose them:

• To create and write checks, a default account is required. Click Edit to choose it.
• Choose preferences.
• Search for Checking and select it.
• Select the following default accounts:
  • Make Deposits
  • Write Checks
  • Pay Your Bills
• Select the default account for paychecks in the Edit menu.
• Check out Preferences.
• Click on Checking from the left-hand side.
• Select the Company Preferences tab.
• Go to the Select Default Account to Use section.
• Choose Open the Create Paychecks Form with Account from the drop-down menu.
• Ensure the correct account is selected.
• Use the QuickBooks Gear icon to select the default account for checks and deposits.
• Click on Account and Settings, then select Advanced.
• Enable Pre-fill Forms with Previously Entered Content.
• Go to the Automation section and click on save.
• Finally, click on done after completing the process.

By following this method, you can change the default check register in QuickBooks for various purposes. Although it may seem lengthy, it covers all the necessary steps. Make sure not to skip any steps as they are all important.

How to Export Check Register from QuickBooks Online

You can export the check register directly from the view register menu or by creating a report first. Whenever you are exporting the check register from QuickBooks online the file will be exported as a spreadsheet file that you can access through Google sheets or Microsoft Excel.

Steps to export check register from QuickBooks Online:

• Go to Chart of Accounts.
• For the account that you want to export, select the drop down icon against view register option.
• Choose Run Report.
• Select the Export option and save the excel file.

The file that you’ll be exporting from QuickBooks Online will contain all of the transactions within that account, and you’ll be able to view the status of each transaction, whether they have been reconciled, consolidated, or are still in review. If you have access to the spreadsheet sync feature as part of QuickBooks Online Advanced, then you can use that feature to send data after you have made changes to the data in the exported file.

How to Import Excel into QuickBooks Online Check Register

You cannot directly compute an Excel file into the QuickBooks online check register but you can definitely import a list of transactions related to one single account and all of those imported transactions will appear in the check register for that account.

Steps to Import Excel into QuickBooks Online Check Register:

• Log into the QuickBooks company file as an admin user.
• Go to the gear icon and select “Import Data“.
• Click on the “Browse” option for Excel if the file is saved locally. If you have saved the file in Google Sheets, then connect your Google Workspace account with your QuickBooks account.
• Match the columns in the spreadsheet with the fields in QuickBooks.
• Review and edit all of the data that you’ll be importing into QuickBooks. You can edit the data at this point in time.
• Click on “Import Data” to begin the import process. Then, verify the data accuracy by reconciling all of the transactions that you have imported into the Check Register.

When you input data into QuickBooks Online, the transactions appear as unreconciled by default. You need to reconcile each of the transactions by matching them with the transactions in the bank statement. This ensures that you are not recording increases multiple times or importing incorrect transactions that may later cause the balance sheet to be unbalanced.

How to Run Check Register Report in QuickBooks Online

The Check Register report is available for each of the accounts in QuickBooks Online. To access the report, go to the chart of accounts menu and select the “View Register” option. This will allow you to view all of the transactions for that account. If you need a report specifically for the check register of that account, you can select the “Report” option from the drop-down menu in the action column. From there, you can save the report or export it as a PDF document or Excel spreadsheet.

Steps to Run Check Register Report in QuickBooks Online:

• Log in to your QuickBooks Online account.
• Click on the “Accounting” tab in the left menu.
• Select “Chart of Accounts“.
• Choose the bank account for which you want to run the check register report.
• Click on the drop-down icon next to the account and select “Run Report“.
• The check register report will now be displayed on your screen, showing all the transactions related to that account.
• Review and analyze the report as needed.
• To print the check register report, click on the “Print List” option.
• Choose the desired print settings and click on “Print” to generate a physical copy of the report.

These steps will guide you on how to run a check register report in QuickBooks Online. It allows you to view and analyze all the transactions associated with a specific bank account, providing valuable insights into your financial activities.

With the check register, you can view and edit transactions, ensuring accurate record-keeping. You can also reconcile your bank statements by comparing them to the entries in the check register, helping you identify any discrepancies or errors. It simplifies the process of managing your finances and gives you greater control over your financial activities. So, if you want to effectively manage your financial transactions and stay organized, the check register in QuickBooks Online and QuickBooks Desktop is a must-have tool.

---

---

Frequently Asked Questions