Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
F
Finaco
October 30, 2023
Question

old deposits

  • October 30, 2023
  • 1 reply
  • 3 views

We started using Quickbooks in 2016 with Quickbooks Desktop.  Earlier this year we migrated from Quickbooks Desktop 2020 to Quickbooks Online and then in September of this year we migrated again to Quickbooks Desktop Enterprise.  76 (apparently) random deposits that in Quickbooks Desktop 2020 AND in Quickbooks online had been properly recorded and reconciled have now shown up again in the "Record Deposits" list.  These deposits range in date from December 2016 to November 2021.  I can see no unifying theme to them.  Deposits both before and after them went through the data migration without being "un-recorded".  I can't reconcile my bank statement until I get the old (randomly unrecorded) deposits addressed.  Any suggestions?  Thank you!  (if it helps, the data migration also randomly marked two bills that had been paid in 2017 as "unpaid", and they aren't part of the "un-recorded" deposits.)

    1 reply

    C
    continea
    Level 5
    October 30, 2023

    Good Afternoon Finaco,

     

    Thanks for connecting with the QuickBooks Community! With migrating from Quickbooks Online to Desktop, items may tend to migrate differently and can cause issues. What I recommend is going through and reapplying these deposits to their received payments. Here is how to create a bank deposit:

     

    1. On the Homepage, select Record Deposits / Make Deposits.
    2. In the Payments to Deposit window, select the payments you want to combine. Then select OK.
    3. In the Make Deposits window, choose the account you want to put the deposit into from the Deposit to dropdown.
    4. Check the deposit total. Make sure the account and selected payments match the deposit slip from your bank. Use your deposit slip as a reference.
    5. Enter the date you made the deposit at your bank.
    6. Add a memo as needed.
    7. Hit Save & Close.

     

    From there, you would need to manage the bank deposit, which the article linked goes into further. Another area to look at would be to review prior reconciliation to see what has been affected and re-reconcile the transactions. I encourage you to speak with your accountant as well. 

     

     

    Please feel welcome to post a reply here if there are any questions. Talk to you soon! 

     

    F
    FinacoAuthor
    November 2, 2023

    Another piece of information that may help…it looks like none of our bank account reconciliations migrated over…when I attempt to reconcile recent statements, transactions back to 2016 show up in the reconciliation screen.  Can I somehow "close" all of the years prior to 2023?  That way I only have to redo reconciliations for 2023.  Then all of those unrecorded deposits (which are all 2016 - 2021) would just go away.  When I need to access them I can do so through QBDT 2020 which we still have and has no data issues.

    K
    Kevin_CModerator
    Moderator
    November 2, 2023

    Thanks for getting back in this thread, Finaco. We greatly appreciate your continued engagement in the Community space. It's our pleasure to assist you in handling your unrecorded deposits in QuickBooks Desktop (QBDT).

     

    You're correct that your previous reconciliation reports were not transferred to QuickBooks Online (QBO) during the migration process. As a result, you may still see your previous bank statements when reconciling your recent transactions. Similarly, when you migrated from QBO to QBDT 2023, the reconciliation data and reports were not transferred to QBDT as well.

     

    To sort this out, you can close your statements before 2023 by either manually comparing your bank statements to QuickBooks and recording those missing deposits or generating a journal entry for those unrecorded deposits to resolve the balances. Once done, you can proceed to mini-reconcile them so you can close them and focus on reconciling your 2023 bank statements.

     

    Regarding your QBDT 2020 data, it's a great practice to secure a backup copy of your company file after each of your reconciliation processes to make sure you can access your data anytime and if you ever encounter such issues. Check out this article for more details: Back up your QuickBooks Desktop company file.

     

    You may check out these articles to learn more about the limitations and differences during the migration process of each program:

     

     

    Furthermore, you can keep these resources that you can use in fixing bank reconciliation issues in QBDT moving forward: 

     

     

    Feel free to get back to us by clicking the Reply button below or posting a new query. We are committed to supporting your business endeavors and hope you have a productive day, Finaco!

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement