ValteraTools CFO services
  1. Valtera
  2. Tools
  3. Excel templates
  4. Balance sheet
Excel template · Balance sheet

Balance sheet template

Compare assets, liabilities and equity at two dates. The template checks that the balance sheet balances and calculates the key liquidity ratios.

Updated:
Valtera_Balance_sheet_EN.xlsx · 10 KB · Sheets: Guide, Balance sheet
Format: .xlsx · Excel, Google Sheets, LibreOffice · No sign-up required
Other languages: Azerbaijani · Russian
Valtera_Balance_sheet_EN.xlsx — Balance sheet · Preview with sample data
Line item31.12.202530.09.2026Change
ASSETS
Cash and cash equivalents32,00041,0009,000
Accounts receivable95,000118,00023,000
Inventory60,00066,0006,000
Other current assets8,0009,5001,500
Total current assets195,000234,50039,500
Fixed assets (cost)140,000170,00030,000
Accumulated depreciation38,00052,00014,000
Fixed assets (net)102,000118,00016,000
Intangible assets6,0005,000(1,000)
Total non-current assets108,000123,00015,000
TOTAL ASSETS303,000357,50054,500
LIABILITIES AND EQUITY
Accounts payable54,00061,0007,000
Taxes and contributions payable9,00011,0002,000
Short-term loans20,00025,0005,000

What the template includes

  • Assets: cash, receivables, inventory, fixed assets (cost and accumulated depreciation), intangible assets.
  • Liabilities: payables, tax liabilities, short- and long-term loans.
  • Equity: charter capital and retained earnings.
  • Check row: turns red if assets do not equal liabilities plus equity.
  • Ratios: current ratio, quick ratio, debt to equity, working capital.

How to read the ratios

  • If the current ratio is below 1, current liabilities exceed current assets: payment difficulties are likely. Between 1.5 and 2 is usually a comfortable level.
  • The quick ratio excludes inventory, because it is hard to turn into cash quickly.
  • Debt to equity shows how much the company is financed with debt. Banks look at this ratio.

For a forecast balance sheet: financial model template. Terms: finance glossary.

Let us run the numbers

Valtera keeps the books and tax records of small and mid-sized companies and, as an outsourced CFO, takes responsibility for revenue growth and cash flow.