How to display a balance sheet with total assets and total liabilities ? Currently it is showing total net assets (liabilities) and total capital and reserves.

Hi @marine-berthier , how about Go to Report thenSelect Balance Sheet (not balance sheet summary). Cheers.

Welcome aboard to the Community, @marine-berthier.

I can provide some clarification about running the Balance Sheet report.

The report calculates how much your business is worth (your business's equity) by subtracting all the money your company owes (liabilities) from everything it owns (assets). If you're trying to separate liabilities and equity directly from the report, the option to do so is unavailable.

However, you can minimize the report to only view the totals and subtotals for the liability and equity (see screenshot below). You can do it by utilizing the arrow symbols within the report.

If you want to get rid of other information and only show the total for assets and liabilities, I suggest you try exporting the report to Excel. From there, you can customize the output base on what you need.

Please see the additional screenshot on how to export the report:

Additionally, here are some helpful references that you can check out about customizing reports and running the Balance Sheet report:

• Customize reports in QuickBooks Online
• What is a Balance Sheet report?
• FAQ: Basic troubleshooting for balance sheets

If you have additional questions or concerns while working in QBO, leave a comment below. I’ll be happy to help you out.

Thanks for your reply, but this is not exactly answering my question.

Let me explain a little bit more.

I have several QuickBooks accounts for all the entities I work for. The balance sheet report is not formatted the same way on all my QuickBooks accounts. Indeed for some entities, it is mixing the current assets and the current liabilities, the non-current assets and the non-currents liabilities and finally presenting a total balance of netted assets and liabilities. For other entities, the balance sheet report presents separately the assets and separately the liabilities. It is not netting them.

Therefore I would like to change the format of the balance sheet report so that the information is displayed the same way for all my entities. Is there any way we can modify the format of the balance sheet report ? Thanks

Hi, thanks for your reply.

The issue that I am facing is that I am working on several QuickBooks accounts where the balance sheet report format differs.

For some entities, the balance sheet is presented like this:

- Assets current then non-current,

- Liabilities current then non-current, and Equity.

For other entities, the balance sheet is presented using a net asset presentation (assets minus liabilities).

Is there a way to change the format of the balance sheet so that all my balance sheet reports have the same format ?

Thank you

Let me help you sort this out, Marine-berthier.

A Balance Sheet is a financial statement that shows your company's assets, liabilities, and equity. It's the core statement to evaluate a business. We're unable to change its format, though. The presentation of figures can vary by these reasons:

• Date
• Accounting method

Let's also ensure the transactions created is linked to the right accounts. Then, the dates and the account method should be correct. The report can show a different picture depending on the method you pick. For more information, you can refer to this article: Choose between cash and accrual accounting methods in reports.

If you have additional questions, please keep in touch with us. We're just around to help you.

I am using the accrual accounting method for all my entities. Yet the balance sheet reports are not displayed the same way in all my quickbooks accounts.

For some entities, the balance sheet report is showing separately the total assets position and the total liabilities position. For other entities, the balance sheet report is showing a netted position of assets and liabilities.

Good day, marine-berthier.

It's best to reach out to our Customer Support Team so they can take a look at it and see what's causing this behavior. Simply click the Help icon and enter Talk to a human.

For other concerns, you may leave a comment again or visit our QuickBooks Help page.

I'm looking forward to hearing from you again. Have a great day!

Hi, I know this post was a long time ago but I'm wondering whether you ever got your issue resolved.  I'm having the same problem in that I've folllowed a Quickbooks tutorial on Youtube which shows their balance sheet how you describe it with total assets and liabilities but mine is how yours displays with capital and reserves. I've no idea how to change it.  It looks nothing like the Youtube video

That sounds very strange.  Can you share a copy to show us how it looks?

I appreciate you joining the thread, @DebbieStell. Running your Balance Sheet report with total assets and liabilities is my top priority today. I'll help you with pulling up your report that way.

The report has compact accounts that display your company's assets, liabilities and equity. You can always modify it to customize the information you need. I'd love to give you the right amount of information to deliver your needs as quickly as possible. For me to do that, may I know what specific report are you using? Do you run the regular Balance Sheet report or the detailed one (Balance Sheet Detail)?

You may also provide screenshots for more reference.

Your reply is much appreciated. Just leave a comment below. Have a great day!

I've attached a screenshot from the video tutorial.  I'm attempting to record personal expenses and owner draws which led me to this tutorial. My balance sheet shows capital and reserves which is different to the balance sheet in the tutorial.

This is how my balance sheet looks...

Hello DebbieStell,

Thanks for sharing those details. So I could assist you better, could you share what region of QuickBooks you are using? I will be looking out for your response. 

I'm in the UK