Categories
Chart of Accounts Reconcile

How to reconcile the Undeposited Funds account the same way like bank accounts

Currently, there is no option to reconcile undeposited funds account. The undeposited funds account is not on the listing of accounts that can be reconciled like for bank, credit card and other assets and liabilities accounts.

Interestingly, it’s sort of automatically reconciled when existing payments from the undeposited funds transferred to the bank account. What’s left in the account is treated as unreconciled status. To get the unreconciled status data, you can get the information directly from the undeposited funds register, you will need to follow these steps:

From the home page screen > left navigation bar > transactions > chart of accounts > select undeposited funds account and click view register under action column > once you’re on the asset register, click little funnel icon arrow down > select ” Not Reconciled” under reconcile status > select all dates > apply
All the items remaining on top without “R” sign (payment and sales receipt) represents “Not Reconciled” status. The total amount should match with the shown “Ending Balance” on top of the register. You can print or download to excel this report.

reconcile undeposited funds
reconcile undeposited funds

The only problem with this report is, there is no way to get the running balance that they took it out on their last update. When sort, you will see “n/a” only with no balance or grand total. If you think you need running balance or grand total instead of “n/a” only, send them your feedback request here:

http://feedback.qbo.intuit.com/forums/168199-quickbooks-online-feature-requests/suggestions/10331052-running-balance-in-check-register


 

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!





Sign up QuickBooks USA

Categories
Bank Register Order Checks Print Checks

Can I print check directly from the bank register?

No, you cannot print check directly from the bank register. You can enter as Check type in bank register and then, print the Check from the QBO designated Check form.

To do that:

Enter transaction as Check type in Bank Register and Save. Highlight or click on the entered transaction, you will see a bar with four button. Select “Edit” will open Check form. Select Print Check at the bottom.

Or

(Create + sign > Vendors > Check > Recent Checks icon (small clock, upper left corner) > Locate check transaction > Print Check button is located at the bottom middle.

Or better yet, use Check form as designated by QBO. Enter and print check.


Categories
Bank Register

How can I print a Check Register or Check Listing only in new QuickBooks Online (QBO)?

I Only want it to show Date, Check Number, Vendor Name and the Amount of the check. For a certain date range say for example day, week, month, etc.

From the home screen page
Go the blue navigation bar

  • Select Reports
  • Go to report (magnifying glass) and type Balance Sheet
  • Select Balance Sheet Report
  • Balance Sheet report will open.
  • Find the bank account you want the check register for, then click on the amount next to the account name.
  • Change transaction dates to reflect the range you’d like to see.
  • Click “Customize” button (upper left corner)
  • Go to Lists
  • Select Transaction Type
  • Choose “Select Multiple” from the dropdown
  • Add “Check” from the list
  • Add “Bill Payment (Check)” from the list
  • Click OK button
  • Go to Rows/Columns and select Change Columns
  • Remove “Memo/Description”
  • Remove “Account”
  • Remove “Split”
  • Remove “Balance”
  • Click OK button
  • Go to Header/Footer
  • Change Report Title from “Transaction Report” to Bank Name Check Register”
  • Click blue “Run Report” button

Select “Print” or “Excel” button as your choice.

How can I print a Check Register or Check Listing only in new QuickBooks Online

How to change in a number of rows in a check register?

You change a number of rows to be displayed on one page from the middle gear icon from 50 to 300 rows. See attached screenshot below for reference.

check register rows
check register rows

If you found our answers useful then please contribute few bucks to support this forum. Thank you!





Thank you!





Categories
Check Print Checks

How do I toggle between Voucher Checks and Standard (3 part) Checks in new QuickBooks Online?

From the Home page screen

  • Go to Transactions (left blue navigation bar)
  • Select Print checks
  • Click on Alignment and Setup to change the check type
  • You can do this as often as you need to

Print Checks Choose Voucher or Standard Checks
Print Checks Choose Voucher or Standard Checks