Skip to main content
D
dholley328
January 2, 2019
Solved

New Company created from Export/Import - Beginning Bank Balance

  • January 2, 2019
  • 1 reply
  • 0 views

Just did a export/import for our database of about 10 years.  Wanted to start new and simpler.  It worked out well however I'm unable to figure out how to get the beginning bank register balance entered.   The bank name and info came over.  Now just need to add the beginning balance.

 

Ideas?

 

And much thanks!

Darryl

Best answer by AlcaeusF

Hi, Darryl @dholley328.

 

Welcome back to the Community. I'm here to help add the beginning balance on your bank register in QuickBooks Desktop (QBDT).

 

First off, I want to congratulate you for successfully performing the export/import. To add the beginning balance to your newly created company file, follow the steps below:

 

1. Go to List menu at the top, then pick Chart of Accounts on the drop-down (or press Ctrl + A on your keyboard for the shortcut).
2. Right-click the bank account, then choose Edit Account.
3. Select the Enter Opening Balance button, then enter the Ending Balance and Ending Date from the last bank statement you received before your QuickBooks Start Date.
4. Click Ok, then Save & Close.

 

I also added some sample screenshots for your guide.

 

 

 

That should help you enter your beginning/opening balance. You can visit this article for more information on how to record opening balance in QBDT. Just in case you need it, you may also check out this article for future reference: Zero or incorrect Beginning Balance in the Begin Reconciliation Window.

 

Please let me know how it goes by leaving a comment below. I'm only a post away should you have any follow-up questions about the process. Take care and have a great rest of the day!

1 reply

AlcaeusF
AlcaeusFAnswer
January 2, 2019

Hi, Darryl @dholley328.

 

Welcome back to the Community. I'm here to help add the beginning balance on your bank register in QuickBooks Desktop (QBDT).

 

First off, I want to congratulate you for successfully performing the export/import. To add the beginning balance to your newly created company file, follow the steps below:

 

1. Go to List menu at the top, then pick Chart of Accounts on the drop-down (or press Ctrl + A on your keyboard for the shortcut).
2. Right-click the bank account, then choose Edit Account.
3. Select the Enter Opening Balance button, then enter the Ending Balance and Ending Date from the last bank statement you received before your QuickBooks Start Date.
4. Click Ok, then Save & Close.

 

I also added some sample screenshots for your guide.

 

 

 

That should help you enter your beginning/opening balance. You can visit this article for more information on how to record opening balance in QBDT. Just in case you need it, you may also check out this article for future reference: Zero or incorrect Beginning Balance in the Begin Reconciliation Window.

 

Please let me know how it goes by leaving a comment below. I'm only a post away should you have any follow-up questions about the process. Take care and have a great rest of the day!

    D
    dholley328Author
    January 2, 2019

    Thank you!   Perfect!

     

    Next question if I may:

    I just created the Bank Feeds; it downloaded over 200 transactions.  I don't want any of them for 2018.   It would let me 'ignore' one at a time.   Is there a batch way to get rid of all those transactions?  I only want 1-Jan-2019 forward in the new file.

     

    Thanks.

    A
    AldrinS
    January 3, 2019

    I've got you covered, Darryl @dholley328.

     

    I have just the steps you'll need to remove these transactions by batch

     

    This can be accomplished by following these steps:

     

    To ignore transactions by batch in the Bank Feeds Center

    1. Click the Banking menu at the top.
    2. Select Bank Feeds, then Bank Feeds Center.
    3. Choose the bank account, then click Transaction List.
    4. On the Transaction List page, put a check mark on the checkbox column to select all the transactions you need to ignore.
    5. From the Batch Actions drop-down menu, choose Ignore.
    6. Click Yes.

    All of this information and more is available in our guide on how to handle bank transactions. Just go to the last section, Do you need to delete unmatched transactions from your Bank Feeds, and click Yes.

     

    That should do it. With these steps, you'll be able to get rid of those transactions like a pro in no time!

     

     Keep in touch with me here should you have any additional questions or concerns. I'm always available here for all questions and concerns. Thanks for coming to the Community, cheers to continued success.

    Terms & ConditionsAccessibility statement