Skip to content

NEWQBO.COM

  • Home
  • Our Services
  • Video Tutorials
  • Ask Question
  • Test Drive
  • Advertise With Us
  • Help Questions
  • Donate Few Bucks for QuickBooks Help

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 a few bucks to support this forum. Thank you!





Thank you!





Sign up QuickBooks USA

Share this:

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)

Like this:

Like Loading...

Related

Published February 1, 2016By admin
Categorized as Chart of Accounts, Reconcile Tagged bank account, Print Check Register, reconcile, undeposited funds

Post navigation

Previous post

How do I fix unapplied cash payment income and unapplied cash bill payment expense

Next post

I have already received payments in QBO from multiple customers. How to make them match with a single deposit I see in my bank feed.




Our Top Posts

  • Chart of Accounts - Listing of available Account Types and their associated Detail Types
  • QBO Educational and Instructional blog
  • How to record forgiveness of debt loan by vendor and bank in Quickbooks Online
  • Add Match Transfer in QuickBooks Online Banking
  • QuickBooks Online Projects for Used Car Auto Dealership - Used Car Inventory
  • How to handle trade-in inventory accounting in QuickBooks Online Plus?
  • Test Drive
  • How do I view or print previous bank reconciliation reports in QuickBooks Online QBO
  • Recording Daily Sales - Restaurants, Retail Stores, POS Cash Register, Sales Template
  • How to record Prepaid Unearned Income? How to convert this Prepaid Unearned Income to Revenue Income when it becomes Earned Income?

Our Recent Posts

  • We have 3rd party app Revel sync with QBO. We have experienced an anomaly with the deposits duplicating — one in the revenue income account and the other in the Undeposited Funds account. How to resolve this?
  • How to Record Consignment Sales on Consignee’s Books in QuickBooks Online
  • Cash Flow Dashboard Widget in QuickBooks Online
  • I have already set up a class in QBO. How do I assign Payroll to that Class?
  • How do I record fully-owned fixed asset equipment that has been sold for cash?
  • QuickBooks Online: Employees and Payroll Helpful Articles
  • How to cancel the QuickBooks Online QBO subscription
  • How to record forgiveness of debt loan by vendor and bank in Quickbooks Online
  • Intuit Aid Assist Website – Paycheck Protection Program (PPP) and Economic Injury Disaster Loan (EIDL)
  • Tags in QuickBooks Online QBO – Tracking County Sales, Out of State Sales, Sales to Pay Rep Commissions
  • How can I make batch changes to categorized transactions without having to go through and click every single one of them in my register
  • How do I match a batch deposit for payment of an invoice and vendor refund deposit?

Search our website

Popular Questions

  • How do I view sent emails for Invoices in Quickbooks Online asked by Carl
  • How do you record a loan payment for a fixed asset? asked by Anonymous
  • How to run customer sales report by City / State in QBO asked by Anonymous
  • How do I add a new "Detail Type" category to the chart of accounts? asked by Rebecca
  • In QBO, how to you delete a recurring Journal Entry? asked by Anonymous
  • how to change sale receipt number asked by Anonymous
  • How do you delete a Project in QuickBooks Online asked by Fred L.
  • Credit Card with mutiple Sub-Accounts asked by Cynthia Russomanno
  • Missing bank transactions in QuickBooks. asked by Maggie
  • Missing beginning balance data on Statement for Cash Flow by Month or Quarter report asked by Anonymous
  • Home
  • Our Services
  • Video Tutorials
  • Ask Question
  • Test Drive
  • Advertise With Us
  • Help Questions
  • Donate Few Bucks for QuickBooks Help
NEWQBO.COM
Proudly powered by WordPress.
%d bloggers like this: