Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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?
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:
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:
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.
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?
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.
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here