New plan10 templates a month$14.95/month, cancel anytime

Start your plan
Balance Sheet Format in Excel with Income Statement (P&L) and Cash Flow Statement preview 1 of 3
Accounting & Bookkeeping · Financial Statements

Balance Sheet Format in Excel with Income Statement (P&L) and Cash Flow Statement

A balance sheet format in Excel linked to an income statement and a cash flow statement: enter one trial balance and get all three statements by month, with prior year comparatives, 16 financial ratios, a dashboard and checks that show at once if anything does not balance.

Get this template

.xlsx · 9 sheets · includes charts

This template

$7.95single payment

  • Nothing renews
  • Download it again whenever you need
  • Yours to keep and edit
Buy this template
Cheaper than buying 2 separately

Monthly plan

$14.95/month

  • This template plus 9 more every month
  • About $1.50 a template if you use all 10
  • Thousands of templates to choose from
  • Cancel anytime
Start your plan
  • Secure checkout via Creem
  • Instant download after payment
  • 14-day refund policy

Financial Statements Pack builds a complete set of financial statements in Excel from a single trial balance. List your accounts on the Trial Balance tab, map each one to a statement line, then enter the opening balances and each month. Paste closing balances exported from your accounting software, or enter each month's movements if you prefer. Debits are positive and credits negative, as in most trial balance exports.

The Income Statement is a monthly profit and loss statement for the fiscal year with revenue, cost of sales, gross profit, other income, eight operating expense lines, EBITDA, depreciation and amortisation, operating profit, finance costs, tax and net profit. Each margin is shown, along with the year to date, the prior year and each line as a share of revenue.

The Balance Sheet shows assets, liabilities and equity at the prior year end and at every month end, in a familiar format with current and non-current sections. Profit for the year to date flows into equity automatically, and a check row confirms that net assets equal equity. The Cash Flow Statement uses the indirect method: net profit, depreciation added back and working capital changes, then investing and financing activities, reconciled to the cash on the balance sheet every month.

The Financial Statements tab puts all three statements on one printable page for the report month, with the year to date against the prior year and the balance sheet against the prior year end. The Ratios tab tracks 16 ratios by month: gross, EBITDA, operating and net margin, return on equity and assets, current, quick and cash ratios, working capital, debt to equity, liabilities to assets, interest cover, receivable, inventory and payable days and the cash conversion cycle. The Dashboard shows revenue, net profit, cash and the current ratio, monthly charts, a balance sheet summary, key ratios and five data checks.

Statement line labels can be renamed to suit your business, the fiscal year can start in any month, and each balance sheet line is classed as operating, investing or financing for the cash flow. Capacity covers 300 accounts. Calculated cells are locked and sheet protection has no password. Sample data from a fictional coffee roaster is included. Built for Microsoft Excel 2016 or later (desktop or Excel for the web) and contains no macros.

What's inside

  • 9 tabs, from a quick-start guide to Settings
  • Trial balance with account mapping to statement lines
  • Closing balance or monthly movement entry
  • Monthly income statement (P&L) with margins
  • Balance sheet at every month end with balance check
  • Indirect cash flow statement reconciled to cash
  • One-page printable financial statements
  • Prior year comparatives
  • 16 financial ratios by month
  • Dashboard with revenue, profit and cash charts
  • Five data checks, including trial balance totals
  • Renamable statement lines, any fiscal year start
  • Locked formulas, no macros
#balance sheet format in excel#balance sheet template excel#income statement template excel#income statement format excel#free p&l template#profit and loss statement template excel#financial statement template excel#cash flow statement#balance sheet format in excel with formulas#trial balance#financial ratios#small business#accounting#excel

More in Accounting & Bookkeeping

Supplier Statement Reconciliation Template for QuickBooks Desktop (Vendor Reconciliation in Excel) previewAccounting & Bookkeeping

Supplier Statement Reconciliation Template for QuickBooks Desktop (Vendor Reconciliation in Excel)

A supplier statement reconciliation template in Excel for QuickBooks Desktop users: paste a vendor report exported from QuickBooks Desktop, enter the supplier's statement, and every line is matched on invoice number or amount, with a reconciliation statement and a list of what to fix.

  • 7 tabs, from a quick-start guide to Settings
  • Paste a QuickBooks Desktop vendor report as exported
  • Header and columns detected, with manual override
intermediate.xlsx
Statement of Account Template Excel with Accounts Receivable Aging Report previewAccounting & Bookkeeping

Statement of Account Template Excel with Accounts Receivable Aging Report

A statement of account template in Excel with an accounts receivable aging report: log invoices and payments once, print a customer statement with a running balance and remittance slip, age every balance into current, 30, 60, 90 and 90+ days, and follow a collection priority list with DSO.

  • 8 tabs, from a quick-start guide to Settings
  • Invoice, payment, credit note and write-off log
  • Payments and credits applied to specific invoices
beginner.xlsx
Cash Flow Forecast Template Excel: 13-Week Cash Flow with 12-Month Projection previewAccounting & Bookkeeping

Cash Flow Forecast Template Excel: 13-Week Cash Flow with 12-Month Projection

A cash flow forecast template in Excel for the next 13 weeks: receipts and payments by category, receivables collections and payables timing, recurring and one-off items, opening balance roll-forward, minimum cash alerts, actual vs forecast variance and a 12-month cash flow projection.

  • 12 tabs, from a quick-start guide to the forecast engine
  • 13 weeks of receipts and payments by category
  • Opening balance roll-forward to closing balance
intermediate.xlsx
Fixed Assets Register Template Excel with Depreciation Schedule previewAccounting & Bookkeeping

Fixed Assets Register Template Excel with Depreciation Schedule

A fixed assets register template in Excel with a depreciation schedule: track each asset's location and custodian, depreciate monthly by straight-line, declining balance or sum-of-years' digits, record disposals with gain or loss, and produce the year-end roll-forward and net book value report.

  • 10 tabs, from a quick-start guide to the depreciation engine
  • Asset register with location, custodian, supplier and serial or tag
  • Straight-line, declining balance and sum-of-years' digits
intermediate.xlsx