Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceFinancial Statements & ReportingBalance Sheet & Financial PositionBalance Sheet

SpreadsheetBalance Sheet & Financial PositionFree

Balance Sheet

Assets, liabilities and equity for this year and last, with the balance check and key ratios.

Shown with sample data

Colour

Balance Sheet

Assets, liabilities and equity for this year and last, with the balance check and key ratios.

Total assets
$240,700
Difference
$0
Must be zero
Working capital
$80,700
Current ratio
2.5
Above 1.5 is comfortable for most
This year by section
  • Equity$139,700
  • Current assets$133,700
  • Non-current assets$107,000
  • Current liabilities$53,000
  • Non-current liabilities$48,000

How to use it

  1. 1Replace the lines with those from your trial balance.
  2. 2Enter balances for this year and last year as positive numbers.
  3. 3Check the Difference figure is zero.
  4. 4Read the ratios with your accountant or lender.

In this workbook

  • About
  • What’s included
  • How to use

About this template

A balance sheet shows what the business owns and owes on one date. Enter each line for this year and last; the sheet totals current and non-current sections, proves that assets equal liabilities plus equity and calculates working capital, the current ratio and debt-to-equity.

Who it’s for

  • Year-end accounts
  • Loan applications
  • Comparing two year ends

What’s included

  • Balance sheet sheet: Each balance sheet line.
  • By section sheet: This year and Last year and the number of entries for each section.

How to use it

  1. 1Replace the lines with those from your trial balance.
  2. 2Enter balances for this year and last year as positive numbers.
  3. 3Check the Difference figure is zero.
  4. 4Read the ratios with your accountant or lender.
Related searchesbalance sheetstatement of financial positionassets and liabilitiesworking capitalfinancial statements

Details

Format
Spreadsheet
Category
Balance Sheet & Financial Position
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetBalance Sheet & Financial PositionFree

Balance Sheet

Assets, liabilities and equity for this year and last, with the balance check and key ratios.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Balance Sheet & Financial Position
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ