What is a Check Register? Definition, Purpose, and How It Works in QuickBooks

A QuickBooks register is a transaction-level view of activity for a bank, checking, savings, credit card, or other supported balance-sheet account. It also records payments, deposits, checks, and other transactions that impact the account, including dates, payees, amounts, balances, and whether it has been reconciled. The check register in QuickBooks lets you view and edit account transactions without opening each one.

What Do You Want to Do with the QuickBooks Register?

Use these links to jump directly to the QuickBooks register task you need:

• Open the register
• Find a transaction
• Edit a transaction
• Print the register
• Export the register
• Import checks or expenses
• Understand C/R reconciliation statuses
• Fix a missing transaction

QuickBooks Check Register at a Glance

The QuickBooks check register lets you see activity at the transaction level in supported accounts, but the features available differ between QuickBooks Desktop and QuickBooks Online. The table below describes the status of the register, supported tasks, filtering, printing, exporting, importing, and reconciliation in each version.

Feature	QuickBooks Desktop	QuickBooks Online
Where to find it	Open the Chart of Accounts, select the applicable account, and open its register.	Open the Chart of Accounts, locate the account, and open its account history/register view.
Supported account types	Registers are available for supported balance sheet accounts like bank and credit card accounts.	Transaction views are available for supported accounts, such as credit card and bank accounts.
Edit transactions	Open the transaction from the register and edit the available fields.	Select the transaction to open its details, then edit fields that QuickBooks allows you to change.
Filter/search	Use available register filters and transaction search tools to locate activity.	Use available search and filtering options to narrow account activity.
Print	Printing options depend on the register or report workflow available in the current Desktop version.	The appropriate account or transaction report may be required when a direct register-print option is unavailable.
Export	Use the applicable report or export workflow when you need to register data in Excel.	Use a supported transaction or account report and export it to Excel or CSV when the register itself does not provide the required export.
Import	Import capabilities depend on the transaction type and QuickBooks Desktop version.	Native import options depend on the transaction type and QuickBooks Online subscription/features.
Reconciliation status	The register displays reconciliation information for applicable transactions, including C, R, or blank status indicators.	Reconciliation information appears with the transaction/account history according to the current QuickBooks Online interface.

What Information is Shown in the QuickBooks Register?

The QuickBooks register provides transaction-level detail to review activity in a bank, checking, savings, credit card, or other supported account. The fields and layout will differ between QuickBooks Desktop and QuickBooks Online, but the register will usually show the transaction, amount, the account, the running balance, and whether an item is reconciled.

Field	What it shows
Date	Shows when QuickBooks records the transaction. Use the date to locate activity within a specific period.
Transaction type	Identifies the type of activity, such as a check, payment, deposit, transfer, or other supported transaction.
Check/reference number	Shows the check number or another reference number associated with the transaction when applicable.
Payee	Identifies the person, vendor, customer, or other name associated with the transaction.
Memo	Contains additional notes or transaction-specific details entered by the user.
Payment/decrease	Shows an amount that reduces the account balance, such as a check or payment.
Deposit/increase	Shows an amount that increases the account balance, such as a deposit or other incoming transaction.
Account/category	Identifies the account or category assigned to the transaction’s other side. This helps determine how QuickBooks classifies the activity.
Balance	Shows the account’s running balance after the transaction is recorded.
Reconciliation status	Indicates whether the transaction has been cleared or reconciled, using the applicable status or symbol in the QuickBooks interface.

Structure of a Check Register: Columns and Entries

Whether maintained manually on paper or digitally in QuickBooks, a check register follows a standard structure designed to capture all essential transaction details for future reconciliation.

A standard check register typically includes the following columns:

Column	Purpose	Example Entry
Date	When the transaction occurred (not necessarily when it cleared the bank).	10/25/2025
Number	The check number, or a code for the type of transaction (e.g., ATM, Debit, EFT).	1055 or EFT
Payee/Description	Who the money was paid to or the source of the deposit.	Office Supplies Inc.
Payment/Withdrawal	Amount leaving the account.	$150.00
Deposit/Credit	Amount entering the account.	$5,000.00
$\checkmark$ (Cleared)	A mark indicating the transaction has been processed by the bank.	(Ticked after reconciliation)
Balance	The running balance of the account according to your records.	$8,500.00

What Do C, R and Blank Mean in the QuickBooks Register?

QuickBooks employs reconciliation statuses to indicate whether a transaction has cleared or been reconciled to a bank or credit card statement. In QuickBooks Online, a blank means uncleared, C means cleared, and R means reconciled.

● Blank

The transaction has not been cleared or reconciled.

● C

The transaction has cleared the bank or credit card but not reconciled.

● R

The transaction has been included in a completed reconciliation.

QuickBooks Online

QuickBooks Online displays these statuses in the register’s reconciliation column. You can use them to identify transactions that are still uncleared, cleared but unreconciled, or already reconciled.

QuickBooks Desktop

In QuickBooks Desktop, cleared and reconciled items are marked in the reconciliation column in the register. The reconciliation process flags transactions against the statement and posts them when you finish reconciling.

Important Note: Unless you understand the repercussions, do not attempt to set the reconciliation status of past transactions manually. Modifying a reconciled transaction can cause variances in reconciliations down the line.

How to Open the Check Register in QuickBooks Desktop

To open the QuickBooks check register in Desktop, go to Lists > Chart of Accounts > click to highlight the bank account > open the register for that account. Alternatively, you can hit Ctrl + R to go directly to the register and choose an account to view.

• Go to Lists > Chart of Accounts in QuickBooks Desktop.
• Locate the relevant bank or checking account whose register you want to open.
• Double-click the account to open its register and view the transactions recorded for that account.
• Alternatively, press Ctrl + R, select the account from the available list, and open its register.
• Look in the transaction list for the check, payment, deposit, transfer, or other transaction you want.
• Use the search or filtering options provided when you want to narrow down transaction lists. To search more broadly, use the transaction search features in QuickBooks Desktop.
• To modify or view a transaction, click on it to view the details.

How to Use the Register in QuickBooks Desktop?

In the QuickBooks Desktop register, you can add or edit transactions for an account, find checks and deposits, display a running balance, and see whether the transaction has been reconciled. You can use these steps to deal with account activities from the register.

Recording a transaction

In a new register position, enter the transaction, select the right type of transaction, fill in the details, and save it. Use the check writing or deposit workflow when you want to complete the transaction process.

Change a transaction

Highlight the transaction in the register, open it, change what is needed, and save the transaction.

Find a check

Use the check number, date, payee, or amount to find a particular check in the register.

Locate a deposit

To find a specific deposit, look for the date, amount, payee, or other transaction details.

Check the running balance

To know what the balance was following each transaction, look at the Balance column.

Check numbers

Verify each check against its recorded reference or check number. When making a change to a number, look for missed or repeated digits.

Look for reconciliation status

Check the reconciliation column for cleared/reconciled transactions. In QuickBooks Desktop, the reconciled transactions may have a checkmark in the reconciliation column. Do not alter transactions that were previously reconciled unless you have considered the impact on past reconciliations.

How to Print a QuickBooks Desktop Register?

You can print a QuickBooks check register directly from the register window. Select the account, set the date range, choose whether to include split details, and send the register to a printer or save it as a PDF.

• Open the register for the bank account you want to print.
• Select the Print icon at the top of the register.
• Enter the From and to dates for the transactions you want to include.
• Select Print splits detail if you want QuickBooks to include the split details for transactions.
• Select OK to open the printing options.
• Review the available printer settings and select Print to print the register.
• To create a PDF copy, select the PDF option and choose Save as PDF when the option is available in your QuickBooks Desktop print window.

If you need to narrow the transactions before printing, apply only the register options supported by your QuickBooks Desktop version. The documented register-print workflow specifically confirms the account and date range, so do not assume that every register filter changes the printed output.

How to Export a QuickBooks Desktop Register to Excel

There is no export to Excel option for the register window in QuickBooks Desktop. Instead, you may export a good transaction report to Excel after customizing it for the account, date range, and transaction details you need.

• Go to Reports > Reports Center in QuickBooks Desktop and open a transaction report that provides the account activity you need.
• Select Customize Report and apply the available filters for the relevant bank or checking account, date range, transaction type, or other details.
• Review the report and confirm that it includes the transactions and columns you want to export.
• Select Excel at the top of the report and choose Create New Worksheet or Update Existing Worksheet.
• Select Export to create the Excel file.
• Open the exported file and verify the account, date range, transactions, amounts, and other required details.
• Keep in mind that QuickBooks exports the data displayed in the selected report, along with applicable row labels, formulas, headers, and footers. The available fields therefore depend on the report and columns you selected.

If you need specific transaction data rather than a report, QuickBooks Desktop also provides separate export options for certain supported transaction types. These exports are different from exporting the bank register itself.

How to Open the Register in QuickBooks Online

You can open a QuickBooks Online check register from the Chart of accounts to review an account’s transaction history, search or filter transactions, and edit supported transaction details. In the current QuickBooks Online interface, the register is accessed through the View register in the account’s Action column.

• Go to All apps > Accounting > Chart of accounts.
• Find the bank, checking, or other account whose transaction history you want to review.
• In the account’s Action column, select View register to open the account register.
• Review the account register to see the past and current transactions associated with that account.
• Click the Filter icon to filter the transaction list by the available filters.
• Enter an amount, reference number, or memo in the Find field to search for a transaction, and then select Apply.
• To sort transactions by a sortable field, such as date, reference number, payment type, or reconciliation status, hover over a column header and select the Sort icon. The default shows the latest at the top.
• Highlight a transaction to have it open in the register so you can see what you do have available.
• Make changes to the available fields directly in the expanded transaction. If a field is grayed out, select Edit to open the full transaction form and make additional changes.
• Select Save or Save and close after making the required changes.
• If the account does not have a register, select Run report from the Chart of accounts to view the transactions for that account instead.

How to Use the Register in QuickBooks Online

Use the QuickBooks Online register to review deposits, payments, checks, balances, and reconciliation status. You can also filter, sort, find, open, and edit supported transactions from the register.

• Go to All apps > Accounting > Chart of Accounts, find the account, and select View register in the Action column.
• Confirm and check transactions such as deposits, payments, checks, transfers, and other account activity.
• To find a check, search by the date, reference number, payee, amount, or other transaction detail.
• Select Filter to narrow the transaction list using the available filter options, including date and other supported criteria.
• Enter an amount, reference number, or memo in the Find field, then select Apply to locate a specific transaction.
• Use the available Sort options to reorder transactions by date, reference number, payment type, or reconciliation status. QuickBooks Online displays the most recent transactions first by default.
• Select a transaction to expand its details and review the recorded information.
• Edit the fields available in the expanded transaction. Select Edit when you need to change information that QuickBooks does not allow you to edit directly in the register.
• Select Save or Save and close after making changes.
• Under the Balance column, observe the available balance per account. If the register is sorted by any column except Date or Reconciliation Status, QuickBooks Online shows N/A in the Balance column.
• Review the reconciliation status column to see the reconciliation state of the transaction. QuickBooks Online utilizes the reconciliation status to indicate cleared, uncleared, and reconciled transactions.

Do not modify the reconciliation status or any other important properties of an already reconciled transaction without knowing how it will impact prior or subsequent reconciliations.

How to Print a QuickBooks Online Register

To print transactions from a QuickBooks Online check register, run an account report from the Chart of Accounts, set the required date range and details, and then print or save the report as a PDF. QuickBooks Online does not document a direct Print command for the account register itself.

• Go to Settings > Chart of accounts.
• Find the bank, checking, or other account whose transactions you want to print.
• Select Run report in the Action column. You can also access the Runreport from the dropdown next to the View register.
• Set the Report period to the date range you want to include.
• Customize the report if you need to adjust the displayed columns, filters, or other available report settings.
• Review the report to confirm that it includes the account activity and transaction details you need.
• Select Export/Print > Print/Save as PDF.
• Choose the required Orientation, such as Portrait or Landscape, and adjust other available print settings.
• Select Print to send the report to your printer or complete the PDF-saving process.

How to Export the QuickBooks Online Register to Excel

To export QuickBooks Online register transactions to Excel or CSV, run the Transaction List by Date report, filter it to the relevant account and date range, and then export the report. QuickBooks Online does not provide a separate Export Register command from the account register itself.

• Go to Reports > Standard reports.
• Search for and select Transaction List by Date.
• Set the Report period to the date range you want to export.
• Select Customize and open the Filter section.
• Select Account and choose the bank, checking, or other account whose transactions you want to export.
• Apply any other available filters you need, then select Run report.
• Review the report to confirm that it shows the correct account, date range, and transaction details.
• Select Export/Print and choose Export to Excel to create an Excel file.
• If you need a CSV file instead, select Export/Print > Export as CSV when that option is available. QuickBooks Online currently supports both Excel and CSV export for reports.
• Open the exported file and verify the transactions, dates, amounts, and other required details before using the data outside QuickBooks.

Can You Import Checks into QuickBooks?

Yes, you can import checks into QuickBooks Online. QuickBooks Online supports importing checks through its native import feature using supported file formats such as CSV and XLS/XLSX. Dancing Numbers provides a separate third-party option for importing checks from Excel or CSV files, with its own field-mapping and bulk-import workflow. These methods are separate, so Dancing Numbers’ product-specific capabilities should not be presented as native QuickBooks features.

Native QuickBooks Import vs Dancing Numbers Import

QuickBooks Online and Dancing Numbers both provide ways to import transaction data, but they are separate solutions. The following comparison keeps native QuickBooks capabilities separate from Dancing Numbers’ third-party features.

Feature	Native QuickBooks	Dancing Numbers
Method	Built-in QuickBooks Online import workflow	Third-party import application
Checks	Supported	Supported
Expenses	Supported	Supported
CSV/Excel	CSV and XLS/XLSX are supported, along with Google Sheets for applicable imports	Excel/XLSX and CSV are supported.
Mapping control	QuickBooks provides field mapping within applicable import workflows	Provides its own field-mapping workflow for supported transactions
Bulk import	Supports transaction imports through the native import workflow, subject to the applicable QuickBooks import process	Supports bulk imports for supported transaction types
Notes	Native feature provided by Intuit	Third-party solution with its own import, mapping, and validation workflow

What Data is Required When Importing Checks?

To import checks, prepare the fields required by the import method you use. QuickBooks Online supports check imports, but Intuit does not provide one universal check-import CSV template. Dancing Numbers documents specific check fields for its own import workflow.

CSV/Excel field	Purpose
Check number	Identifies the check number recorded for the transaction.
Payee	Identifies the person or vendor receiving the payment.
Date	Records the check’s payment date.
Bank account	Identifies the QuickBooks bank account from which the check is paid.
Amount	Record the check amount.
Memo	Stores additional transaction notes when supported by the selected import workflow.
Expense/account category	Identifies the account used for the expense portion of the check when supported by the import workflow.
Class	Adds class information when the selected QuickBooks import workflow supports class tracking.
Location	Adds location information when supported by the selected import workflow.

Important: Do not use the above table as a universal QuickBooks check-import template. The exact required and optional fields can vary by import method, transaction structure, and QuickBooks product or feature. Validate the available fields during the import-mapping step before uploading the file.

Can You Import Reconciled Transactions?

Yes, you can import historical transactions, but you should not treat imported transactions as already reconciled without validating them against the original bank or credit card statements. Importing historical transactions can create duplicates, incorrect opening balances, reconciliation discrepancies, duplicate check numbers, or transactions assigned to the wrong payee or account. Before importing previously reconciled activity, compare the file with transactions already recorded in QuickBooks, verify the opening balance and transaction dates, check for duplicate check numbers, confirm payees and accounts, and reconcile the affected period again after the import.

Reconciliation Cautions Before Editing the Register

Do not edit a previously reconciled transaction without first checking its effect on the account reconciliation. Changes to a reconciled transaction can affect:

Beginning Balance

A change can affect the balance carried into a reconciliation period.

Ending Balance

Changes to transaction amounts or dates can alter the account balance for the period.

Reconciliation Discrepancy

An edited transaction can create a difference between QuickBooks and the bank statement.

Prior-period Reporting

Changes to dates, amounts, or accounts can alter previously recorded financial activity.

Outstanding Checks or Deposits

Changes can affect whether transactions appear as cleared, reconciled, or outstanding.

What Should You Check Before Editing a Reconciled Transaction?

Before editing a reconciled transaction in QuickBooks, verify that the change is necessary and check how it could affect the completed reconciliation. Use this checklist before making any correction:

• Confirm the transaction is genuinely incorrect.
• Check the original bank statement to verify the transaction details.
• Note the previous transaction details before making changes.
• Confirm whether the reconciliation period is closed.
•  Check with your accountant or bookkeeper when the correction could affect prior-period records.
• Reconcile the account again after making the necessary correction.

Why is a Transaction Missing from the QuickBooks Register?

A transaction may be missing from the QuickBooks register because it is assigned to a different account, hidden by a filter, deleted or voided, not yet added from the bank feed, or recorded in another company file. Check these common causes before assuming that QuickBooks has lost the transaction:

• Review the Account You’re Viewing
• Expand the Transaction Date Range
• Clear Active Search and Filter Settings
• Check Other Accounts for the Transaction
• Verify Whether the Transaction Was Deleted or Voided
• Review the Import Destination Account
• Check Pending Bank-Feed Transactions
• Confirm You’re Using the Correct Company File
• Verify Your QuickBooks User Access

Why Does the QuickBooks Register Balance Not Match the Bank Balance?

The QuickBooks register balance may differ from the bank balance because QuickBooks tracks recorded, cleared, and reconciled transactions separately from the balance reported by your bank.

Register balance

Shows the balance based on transactions recorded in the QuickBooks account.

Cleared balance

Reflects transactions you have marked as cleared in QuickBooks.

Reconciled balance

Reflects transactions included in a completed account reconciliation.

Online banking or bank-feed balance

Shows the balance or transaction information received from your financial institution through the bank connection.

Why is the Same Check Showing Twice?

The same check can appear twice when you enter, download, or import the transaction more than once.

Duplicate manual entry

You entered the same check twice in QuickBooks.

Bank-feed duplicate

QuickBooks downloaded a check that you already entered manually.

Imported duplicate

An import added a check that already exists in the register.

Re-entered historical check

You entered an old check again during a correction or historical-data import.

Duplicate check number vs. duplicate transaction

The same check number does not always mean a duplicate. Compare the date, payee, amount, bank account, and transaction details.

How to Find Uncleared Transactions in the Register

You can find uncleared transactions by reviewing the register’s reconciliation status and identifying entries without a cleared or reconciled status. Here are the steps to find transactions in QuickBooks register.

• Open the relevant bank or credit card account register.
• Review the reconciliation status column for each transaction.
• In QuickBooks Online, look for transactions with a blank status, which indicates they have not been cleared or reconciled.
• In QuickBooks Desktop, review the reconciliation column for transactions that do not show the reconciled checkmark.
• Check the transaction date, amount, payee, and reference number against the latest bank or credit card statement.
• Review older uncleared transactions to determine whether they are still outstanding or require correction.
• Do not mark a transaction as cleared or reconciled simply to make the register balance match the bank statement. Verify the transaction against the statement first.

Can You Delete a Transaction from the Register?

Yes, you can delete certain transactions from the QuickBooks register, but deleting a historical or reconciled transaction can affect your reconciliation and accounting records.

Deleting vs. voiding

Deleting removes the transaction. Voiding keeps the transaction record but removes its financial effect.

Reconciliation impact

Deleting or changing a reconciled transaction can create a reconciliation discrepancy.

Audit implications

Deleting a transaction removes it from the register, so retain supporting records and review the transaction history before deleting it.

Historical transactions

Verify old transactions against the original bank statement before deleting them. Check with your accountant or bookkeeper if the transaction belongs to a closed or reconciled period.

Can You Change a Check Number from the Register?

Yes, you can change a check number when the transaction allows the reference number field to be edited. Open the transaction, change the Check No. or Reference No. field, and save it.

Avoid duplicate numbers

Check that another transaction does not already use the new check number.

Match printed checks

If you already printed the check, make sure the QuickBooks number matches the number on the physical check.

Review reconciliation history

Check the reconciliation history before changing a number on a previously reconciled transaction.

---

Frequently Asked Questions