Balance Sheet Report

The Balance Sheet report gives you a snapshot of the assets, liabilities and equity of your business at a specific date. It shows what the business owns, what it owes and the money invested by its owners or shareholders.

Use it to check your financial position at a date and to see depreciation on fixed assets. You find the report in the Reports menu.

Prefer to watch?

Watch QuickFile Balance Sheet Report Explained on YouTube

Prefer a video walkthrough? Watch our QuickFile Balance Sheet Report Explained tutorial on the QuickFile Help Guides YouTube channel.

Before you start

  • Transactions, invoices and journals entered in QuickFile. The report shows the balances they create.

How do I open the balance sheet?

  1. Click Reports in the top menu, then click Balance Sheet.

  2. Check the Date to field. It opens with your account’s year end date. To see the position on another date, enter that date (day/month/year) and click update.

  3. Click Report to see the figures as a table, or click Visualise to see them as a chart.

    Report and Visualise tabs, with Report selected

Which accounts appear on the balance sheet?

Accounts 0001-3999 appear on the Balance Sheet. Accounts 4000-9999 appear on the Profit and Loss report. The Chart of Accounts groups them into these sections:

What are Fixed Assets?

These include the value of items that are not easily turned into cash. They can be things like property, land, machinery, motor vehicles, furniture, office equipment, patents and other capital purchases.

Each asset’s depreciation is shown underneath it (see How is depreciation shown?).

What are Current Assets?

These include the value of items that are more easily turned into cash. A current asset can usually be turned into cash within 12 months.

Current assets include bank accounts, debtor control accounts (the value of sales invoices not yet paid), prepayments, inventory and other items that can be turned into cash.

What are Current Liabilities?

These are the business’s short-term debts, due within 12 months. They include credit card balances, bank overdrafts and creditor control accounts (the value of supplier invoices not yet paid).

What are Long Term Liabilities?

These are debts that are settled over more than 12 months, such as bank mortgages, pension obligations or deferred tax liabilities.

Long Term Liabilities section of the Balance Sheet report, showing a Loans line and Total Long Term Liabilities

What are Capital and Reserves?

This section shows the capital introduced into the business by its owners, retained profit from earlier periods and the profit or loss for the current period.

The Total Capital and Reserves line equals NET Assets at the top of the report. In the example above, both show 110,026.47.

The P&L Account line

The P&L Account line shows the profit or loss for all time, not only for the current accounting period. Click the grey help icon beside the line to read this. The figure matches Profit Before Tax on the Profit and Loss report when you set From to a date before your first transaction and To to the balance sheet date.

Important: If you have entered transactions in earlier accounting periods and have not yet closed them with a year-end, complete the year-end for those periods first.

The other lines in this section are 3101 Retained Profit & Undistributed Reserves, 3200 Profit and Loss Account and 3300 Capital Introduced for Sole Traders.

How is depreciation shown?

QuickFile groups depreciation together with its asset account. The balance sheet shows the asset, its accumulated depreciation and the Net Book Value, which is the cost of the asset less its accumulated depreciation.

These are the default pairs:

Asset code Depreciation code Asset type
0020 0021 Plant and machinery
0030 0031 Office equipment
0040 0041 Furniture and fixtures
0050 0051 Motor vehicles

For example, Office Equipment (0030) of 9,600.00 less Accumulated Depreciation (0031) of 2,400.00 gives a Net Book Value of 7,200.00.

To add or change accounts, see The Chart of Accounts.

How do I check a balance?

  1. Click the magnifier icon at the end of the line you want to check, for example the 0030 Office Equipment line.
  2. Check the ledger that opens. It shows the entries for that account, up to the report date.

Clicking the name of a line does nothing. Use the magnifier icon.

Can I see the report in another currency?

  1. Open the currency selector on the report page and choose EUR Euro, GBP British Pound or USD Dollar.
  2. Read the Ex. Rate and the date beside it. The whole report is converted at that rate.

For example, at an Ex. Rate of 1.341, the Freehold Property figure of 19,500.00 shows as 26,149.50 in USD. To go back to your default currency, choose GBP British Pound.

Notes and warnings

The report has one Date to field. It has no start date and no preset periods, such as the previous year. It shows the balances up to the date you choose.

The report has no comparative column for a previous year. To compare two dates, run the report for each date.

Accounts with a zero balance are not shown on the report. The Chart of accounts lists them unless Hide accounts with no balance is ticked.

The Export Data and Print Report buttons are on the report page.

Troubleshooting

The P&L Account figure does not match an earlier period

The P&L Account line is for all time. Complete the year-end for any earlier periods that have transactions and are not closed, then check the figure again.

The figures are in a different currency

Open the currency selector and choose GBP British Pound. When another currency is selected, every figure on the report is converted.

I need a start date, a preset period or a comparison

The report does not have these options. Run it for each date you need, then compare the figures yourself.

Related topics

These articles cover the accounts behind the report and the profit figure in Capital and Reserves.