cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get unlimited expert tax help and powerful accounting in one place. Check out QuickBooks Online + Live Expert Tax.
ks510
Level 1

Balancing

For a non-profit that doesn't want to connect our bank account yet, how do we get our reports to balance?

We have triple checked and everything is exact to our bank account statement, including the correct opening balance. But yet it is not matching up. We have nothing that is owed and all revenues are recorded as receipts. and everything looks beautiful there but our problem is the expenditures. Everything matches perfect with expenditures but yet the ending balances are not matching... any tips?

4 Comments 4
Adrian_A
Moderator

Balancing

Thanks for the details, ks510.

 

There are different factors why the ending balance isn't a match. I'm here to help you resolve your concerns.

 

It might be that:

 

  • Someone entered an incorrect ending balance at the start of the reconciliation.
  • There are missing or duplicate transactions in QuickBooks.
  • Someone entered transactions into QuickBooks that haven't cleared your bank yet.

 

Since the transactions match your bank statement and the opening balance is correct, let's review the ending balance. You'll have to ensure that the figure you enter here is the same as your bank statement. Let me guide you with these steps:

 

  1. On the reconciliation window, click Edit info.
  2. Review the Ending balance and Ending date.
  3. Check your bank statement. Make edits as needed.
  4. Select Save.

 

If the ending balance is correct, let's review the recording of the transactions. If your bank combined several payments as a single record, you should do the same in QuickBooks. Sometimes, we enter payments individually, which makes us think there's an error.

 

I've added this reference for the detailed steps of the process: Combine multiple transactions into a single transaction.

 

Afterward, you may start reconciling the accounts:  Reconcile accounts in QuickBooks Online.

 

You can also check this link if you want to print the reconciliation report:  How do I view, print, or export a reconciliation report.

 

Keep me posted when you need help with reconciliation. I'll be around to guide you.

ks510
Level 1

Balancing

See that would work if our bank account was connected but it is not so the reconcile features are not available to us. So what would be a solution for us?

Adrian_A
Moderator

Balancing

Thanks for getting back to us, ks510.

 

You can still reconcile your accounts, though it's not connected. 

 

You can do that by adding the transactions manually. Here's an article as your guide: Manually add transactions.

 

Afterward, you're good to review the ending balance. 

 

Feel free to open the links I've shared above.

 

You can always get back to this thread if you have other concerns. I'm here to guide you.

Rainflurry
Level 14

Balancing

@ks510 

 

You can reconcile your bank account by going to Settings > Reconcile.  There's no need to connect your bank account.  After you have cleared all of the bank transactions from your bank statement, you can see if the discrepancy is with the beginnning balance, ending balance, deposits or payments.  It has to be in one of those. 

Get answers fast!
Log in and ask our experts your toughest QuickBooks questions today.

Need to get in touch?

Contact us