What does a balance sheet look like in QuickBooks

With accounting software like QuickBooks, detailed financial information about your business is always at your fingertips. Financial statements such as a profit and loss statement

What does a balance sheet look like in QuickBooks

With accounting software like QuickBooks, detailed financial information about your business is always at your fingertips. Financial statements  such as a profit and loss statement, balance sheet or statement of cash flows  are a window into the health of your business and help you spot problems and opportunities.


You can use QuickBooks financial statements when opening a business bank account, applying for a business credit card or loan or when planning for the following year. If you cant quite figure out how to make something work in QuickBooks, or what reports you should be looking at, read on. Well tell you what types of financial statements are available on QuickBooks, what theyll tell you about your business and the instructions you need to follow to access them.

How to prepare QuickBooks financial statements

The beauty of QuickBooks is that you can create dozens of custom reports to help you better run your business. Beyond the basic three financial statements  profit and loss, balance sheet and cash flow statement  you can also customize reports by product, vendor, employee, bank or customer.

QuickBooks gives you flexibility as to how the statements are used and shared. You can view them in QuickBooks, email them to yourself or another member of the business or export them for later viewing. QuickBooks even lets you schedule financial reporting, so you can automatically receive and share updated financial statements on a periodic basis.

Here are the three main types of QuickBooks financial statements you can create:

1. QuickBooks profit and loss statement

Your profit and loss statement, also called an income statement, summarizes your businesss financial performance over a period of time  daily, weekly, monthly, quarterly or annually. It is an important document because it tells you the companys biggest areas of expenditures and revenues.

The profit and loss statement lets you take advantage of opportunities that increase sales and trim back on expenses. Youll want to review this statement more than once a year, and definitely before filing your small business taxes. You can run a standard profit and loss statement in QuickBooks or a profit and loss detail which shows year-to-date transactions for each income and expense account.

Heres how to prepare your QuickBooks profit and loss statement:

From the home dashboard, select Reports on the left navigation bar:

QuickBooks reports

From the Report Center, you can either go to theRecommendedtab or toAll Reports > Business Overview,then chooseProfit and Loss.(The Recommended tab is faster, but youll need to go toAll Reportsto get theProfit and Loss Detail). Just click on the report name or the link that says Run to open it.

Profit and loss

Once its open, you can edit the date range or clickCustomizeto make other changes to the report. For example, this where you can see the amount and percentage of profits coming from a specific product or customer. You can also customize the reporting time period here.If you just change the date directly without clicking the customize button, make sure you click theRun Reportbutton to view the report for the new dates. Keep in mind that you can view the report in QuickBooks, email the report to yourself or someone else or export it as a new file.

Run report

2. QuickBooks balance sheet

Abalance sheetis astatement of theassets, liabilities and equityof a business  essentially a snapshot of your business value at a specific point in time. Balance sheet items are calculated by subtracting your liabilities  what you owe  from your assets, cash or property  what youre own or is owed to you. The result is equity, or what your company is worth.

Balance sheets are useful for accountants to see your financial health and for banks when you are applying for loans. Its also essential for the small business owner to get a true sense of how their business is doing.

Just as with a profit and loss, the standard balance sheet is fine, but I recommend pulling the balance sheet detail in QuickBooks to send to your tax preparer. As you can guess, this is a more detailed version of the standard balance sheet, showing the starting balances at the beginning of last month, transactions entered in for the month and ending balances.

To create your QuickBooks balance sheet, follow these instructions:

1. In the left navigation bar, clickReports:

QuickBooks reports

2. From the Report Center, you can either go to theRecommendedtab or toAll Reports > Business Overview, then chooseBalance Sheet.Recommended is faster for a standard Balance Sheet, but youll need to to All Reports to get the Balance Sheet Detail. Just click on the report name or the link that says Run to open it. If you hover over it, youll get a preview  this works for the P&L and other reports, too:

Balance sheet

3. You can customize it before you view it, too. When you click the Customize button, QuickBooks Online will take you directly to the customization screen. This lets you choose your date range, along with some other options, like adding a column to compare to a prior period. When youre done, click Run Report.

run report

3. QuickBooks cash flow statement

A cash flow statement, or statement of cash flows, shows the amount of cash that flows into your business from a variety of sources and flows out of your business in a given period of time. Statement of cash flows is important because it shows your companys actual cash position to fund operating expenses and debt obligations. The liquidity of your company will be illustrated in a statement of cash flows.

Depending on your accounting method, you might record revenue at the time of a sale or when your customer actually pays. You can specify your accounting method in QuickBooks, making it easy to get a handle on your cash flow.

Heres how to access your QuickBooks cash flow statement:

In the left navigation bar, click Reports:

Type Statement of Cash Flows in the search field and select it to open the report.

Choose Customize to change any report settings. For instance, you can change the reporting time period or filter by customer, employee, vendor or product. Once youre finished with customizations, click Run Report.

Cash flow

Summary of QuickBooks financial statements

For most small businesses, the three basic financial statements are all youll need to get a good understanding of your businesss financial performance. However, these just scratch the surface of whats possible with QuickBooks.

Heres a summary of available QuickBooks financial statements:

Profit and loss statement: View income and expense summaries for your company or detailed numbers for each account.

Balance sheet: Understand your companys debts, liabilities and assets.

Cash flow statement: Learn how well your businesss cash flow can support its debts and obligations.

General ledger report: Shows you the beginning balance, transactions and totals for each account in your chart of accounts.

Customer, job and sales reports: Keep track of whats impacting your accounts receivable.

Item reports: Manage your inventory with insightful merchandise and product reports.

Vendor reports: Get a handle on your business expenses and accounts payable.

Banking reports: Reconcile all your bank accounts and credit card statements and analyze where all your money lives.

List reports: These help you quickly pull up lists of information, such as customer lists or product lists.

Payroll and employee reports: Understand how personnel costs are impacting your business (most insightful if you have QuickBooks payroll)

Accountant and tax reports: These reports are only for accountants and tax preparers for use with their clients.

Budgeting and forecasting reports: Use these to plan ahead for your company and ensure that youre staying within organizational budgets.

Along with periodically running each of these reports, you can also use them for other evaluations, like a common size analysis, as well as get nice visual representations and graphs in QuickBooks of how your company is performing. These are useful for general financial analysis and for planning with your bookkeeper, tax preparer or business consultant.

QuickBooks Online resources

Read more about how QuickBooks Online works.

Bookkeeping and accounting software


GoDaddy Bookkeeping $4.99 per month and up.


Sage 50cloud $47.25 per month (when paid annually) and up.


Wave Financial Free (add-ons available).


Xero $12 per month and up.


Zoho Books $0 per month and up.

A version of this article was first published on Fundera, a subsidiary of NerdWallet.

Video liên quan