Skip to main content
A
aa1745
December 27, 2018
Solved

How can i reconcile business transactions with a personal account?

  • December 27, 2018
  • 1 reply
  • 0 views

Hi, I have a very small business with few transactions so I am using only my personal bank account and credit card. I have input my expenses over the last year and would like to reconcile my accounts. I have linked my bank account and downloaded the last 90 days transactions now i am stuck!

1. My bank account opening balance is zero which is incorrect, so this needs changing - am I right in thinking I make a journal entry to opening balance equity?

2. I believe I can exclude personal transactions that have been imported from my bank account from the last 90 days allowing me to reconcile only business transactions - is this correct?

3. How do I reconcile the previous months which cannot be imported from my bank feed and manually exclude personal transactions??

 

Many thanks in advance!

    Best answer by Rose-A

    Glad to have you here in the Community, aa1745.

    I'd be glad to help you reconcile your business transactions with a personal account.

     

    When setting up a bank account, QuickBooks lets you enter the bank's opening balance. If you already set up your bank without an opening balance, below is an article with detailed steps on how to enter an opening balance.

    For your second question, reconciliation would not be going to work on this because you use your personal account in some business expenses. Reconciliation will be based on your bank statement. You will not get the right ending balance if you exclude personal transactions and just reconcile the business transactions. And or the previous months that cannot be imported through bank feed, you can manually bring the transaction into QuickBooks using a WebConnect feature.


    Here's an article with detailed steps on how to upload a WebConnect file: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/How-to-upload-more-than-90-days-of-bank-transactions/td-p/187501.

     

    If you'd like to go through this over the phone, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours.

     

    The Community is always here to help you out. You can always leave a reply, I'll help you the best I can. Happy Holidays!

    1 reply

    Rose-A
    Rose-AAnswer
    December 28, 2018

    Glad to have you here in the Community, aa1745.

    I'd be glad to help you reconcile your business transactions with a personal account.

     

    When setting up a bank account, QuickBooks lets you enter the bank's opening balance. If you already set up your bank without an opening balance, below is an article with detailed steps on how to enter an opening balance.

    For your second question, reconciliation would not be going to work on this because you use your personal account in some business expenses. Reconciliation will be based on your bank statement. You will not get the right ending balance if you exclude personal transactions and just reconcile the business transactions. And or the previous months that cannot be imported through bank feed, you can manually bring the transaction into QuickBooks using a WebConnect feature.


    Here's an article with detailed steps on how to upload a WebConnect file: https://quickbooks.intuit.com/community/Banking-and-bank-feeds/How-to-upload-more-than-90-days-of-bank-transactions/td-p/187501.

     

    If you'd like to go through this over the phone, you can call our dedicated team who will be happy to assist you. Our contact details can be found here along with our opening hours.

     

    The Community is always here to help you out. You can always leave a reply, I'll help you the best I can. Happy Holidays!

      T
      Taniaw22
      August 3, 2020

      I have a client who has an LLC but for the past 2 years have been using their personal bank accounts for the business.  I am now working with them to get their books sorted out.  The problem is they have imported the bank statements into quickbooks.  do i need to reconcile these bank accounts and my second question is do i allocate all personal expenses against equity or do i delete these transactions?

      M
      MGDLA
      April 13, 2021

      Hey there,

       

      Did you ever get an answer on this? I’m in a similar situation. 

      Terms & ConditionsAccessibility statement