cancel
Showing results for 
Search instead for 
Did you mean: 
hulmez
Level 2

Reconciling

Hi I have a business that hasn't filed in a few years, nothing is reconciled. They have just been entering sales and payments. I've started to go over first year and I've noticed that the bank account entered in quickbooks didn't start till two weeks after business started running. It's been years now any idea how to handle this as already pretty much know it's not gonna balance.

4 Comments 4
JenoP
Moderator

Reconciling

I'd be glad to help with your reconcilation, hulmez.

 

You can actually create a journal entry if an opening balance was not recorded when the bank account was set up in QuickBooks. This will correct the amount in the account to help you mirror the balance in your actual bank. 

 

You also need to decide how far back you want to go. You may want to pick a date that's older than the oldest transaction you want to track in your company file. However, I'd also recommend reaching out to your account for further advice to make sure you're using the right accounts when recording the corrections. 

 

Here's how to create a journal entry:

 

  1. Go to the Company menu and select Make General Journal Entries.
  2. Set the date for the journal entry. It should be the date you pick for the opening balance.
  3. Go to the Account column, then select the account you're entering the opening balance for.
  4. Enter the balance for your real-life accounts for the day you picked. Depending on the type of account:
    1. Asset: Enter the opening balance in the Debit column.
    2. Liability and Equity: Enter the opening balance in the Credit column.
  5. On the next line, select the Account drop-down and then the Opening Balance Equity account.
  6. Enter the same opening balance amount in the opposite column as the first line. So, if you entered the first amount in the Credit column, enter the next one in the Debit column.
  7. Click Save & Close.

 

Here's an article about this process for more details: Enter Opening Balances for Accounts in QuickBooks Desktop.

 

Let me also share these additional articles for future guidance and reference:

 

 

Don't hesitate to ask more questions if ever you need more help with QuickBooks. We'll make sure everything is sorted out. 

JenoP
Moderator

Reconciling

Hi hulmez,

 

Hope you’re doing great. I wanted to see how everything is going about your reconcilation. Was it resolved? Do you need any additional help or clarification? If you do, just let me know. I’d be happy to help you at anytime.

 

Looking forward to your reply. Have a pleasant day ahead!

hulmez
Level 2

Reconciling

Hi there sorry it's taking so long to reply. So this a mess but he's a friend and I said I would help fix it. Problem is I don't know where to start were going back to 2016. I can honestly say nothing has been done except sales and payments. I look at the account for his bank in QB andvits in the minus nothingvhas been reconciled or deposits recorded. Feeling very overwhelmed  and don't know where to start 😪

hulmez
Level 2

Reconciling

Hi sorry it's taking this long to reply. Sitting here looking at everything  I haven't a clue where to start. It's a friend and I've promised to help so can't run away from this. But we're going back to 2016 nothings reconciled no deposits recorded, feeling very overwhelmed. 

Need to get in touch?

Contact us