Cybooks

Run a balance sheet report

This guide covers how to view your balance sheet report to see assets, liabilities, and equity at a point in time.

The balance sheet shows a snapshot of your financial position as at a specific date. It groups your accounts into Assets (what you own), Liabilities & Equities (what you owe and your equity), and calculates totals for each category. You can compare the current period with previous periods to spot trends.

View the balance sheet

  1. In the sidebar, go to Reports > Balance Sheet.

  2. Select a Date. This is the "as at" date for the report -- all account balances are calculated up to and including this date. It defaults to today.

  3. Choose a Compare with option to add comparison columns. The dropdown has two sections:

    • Compare with -- select how many periods to compare (1 to 4), or choose None to show a single date column.
    • Period -- select the period type for comparison: Day, Month, Quarter, or Year. For example, selecting "2 years" adds two additional year columns alongside the current date.

  4. Click Update to refresh the report with your selected date and comparison settings.

The report displays a grid with the following structure:

  • Assets -- grouped into:

    • Accounts Receivable -- outstanding customer invoices
    • Cash and cash equivalents -- bank and cash accounts
    • Current Assets -- other short-term assets and credit cards
    • Long Term Asset -- non-current assets and fixed assets

  • Liabilities & Equities -- grouped into:

    • Accounts Payable -- outstanding vendor bills
    • Current Liabilities -- short-term obligations
    • Non-current Liabilities -- long-term obligations
    • Shareholder's Equity -- owner's equity, net income, and retained earnings

Each row shows the account name, account code, and balance for each date column. Group rows display subtotals in bold.

When comparing periods, the report also shows:

  • Variance -- the difference between the first and last period. Positive values appear in green; negative values appear in red with parentheses.
  • Percentage -- the percentage change between the first and last period.
  • Metric -- a sparkline chart showing the trend across all compared periods.

Export the balance sheet

  1. On the Balance Sheet page, click More (the three-dot icon next to the Update button).

  2. Under Export As, select a format:

    • PDF
    • XLSX
    • CSV

  3. The report downloads to your device with the filename balance-sheet_YYYY-MM-DD and the selected file extension.

You can also click Print from the same menu to print the report directly.

Schedule the balance sheet

You can schedule the balance sheet to be generated and emailed automatically.

  1. On the Balance Sheet page, click More > Schedule Report.

  2. Configure the schedule:

    • Frequency -- choose Daily, Weekly, Monthly, or Quarterly.
    • Start Date & Time -- select the date and time for the first report.
    • Compare with -- choose a comparison period and period type for the scheduled report.
    • Email Recipients -- enter one or more email addresses.
    • Attach Report as -- choose the file format: PDF, CSV, XLSX (Microsoft Excel), or XLS (Microsoft Excel 1997-2004 Compatible).
    • Status -- toggle the schedule on or off.

  3. Click Save.

Frequently asked questions

What date does the balance sheet use? The balance sheet is a point-in-time report. It shows the cumulative balance of each account from the beginning of your records up to and including the selected date. Unlike the profit and loss report, it does not use a date range.

What is "Net Income" under Shareholder's Equity? Net Income represents the profit or loss for the period calculated from your income and expense accounts. It is automatically included in the equity section so that Assets = Liabilities + Equity.

What is "Retained Earnings"? Retained Earnings represents the accumulated profits and losses from prior financial periods. It is automatically calculated and displayed under Shareholder's Equity.

Why do the comparison columns show different months? The comparison periods are calculated by stepping back from your selected date. For example, if your date is February 2026 and you compare with 2 years, the report shows columns for Feb 2026, Feb 2025, and Feb 2024.

All amounts are in my base currency -- can I change this? The balance sheet displays all amounts in your base currency. Foreign currency transactions are converted at their recorded exchange rates.

What's next