Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowBalance Sheet amount for bank accounts shows bank register amount in both cash basis and accrual basis. All settings are for cash basis, as that is what the business uses. Accounts have been reconciled but balance sheet still shows register amount.
Hello there, Don1950.
I appreciate you reaching out to us with your query regarding the Balance Sheet report in QuickBooks Online.
In QBO, the balance sheet shows the bank balances based on the Report period rather than the Accounting method used. You can check this article that gives you a financial snapshot of your company: Run a Balance Sheet report in QuickBooks Online.
I'm also including a link for further information on the variances between cash and accrual methods in QuickBooks Online, as well as instructions on how to switch between them: Choose between cash and accrual accounting methods in QuickBooks Online.
I'm always here if you have further questions regarding the balance sheet report or other relevant issues. I'll be sure to assist.
I understand the difference between a Profit & Loss which reflects the period selected for the report and the Balance Sheet which reflects a snapshot for a particular date. Cash basis recognizes income and expenses when they are received or paid as of the date of the report so to show no difference between cash basis or accrual basis for bank accounts seems odd to me. The company is set up for cash basis so the accounts receivable aging method has no bearing as in cash basis the accounts receivable do not show on the balance sheet.
I appreciate you for your response and for providing additional clarification, Don1950. I'm here to offer information regarding this issue.
Yes, that seems unusual. Just to clarify, are you utilizing the Balance Sheet Transaction Detail report? If so, please know that we are currently conducting an investigation into missing transactions in the Cash basis when using the Balance Sheet Transaction Detail report.
This behavior is closely linked to the current investigation. Thus, I recommend contacting our Support Team to include your name on the list of affected users. Here's how to contact them:
To find out more about customizing the Balance Sheet report and how to personalize it, you can refer to the articles linked below:
Please utilize the Reply button if you need help with QuickBooks reporting. We're all right here to help.
"Cash basis recognizes income and expenses when they are received or paid as of the date of the report so to show no difference between cash basis or accrual basis for bank accounts seems odd to me."
Balance sheet cash balances should be the same on accrual or cash basis. A/R and A/P offset the income and expense timing differences between cash and accrual basis but cash is the same.
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