Start from one date and one currency.
A balance sheet is a snapshot, rather than a measure of cash moving through a period. Use consistent records at the same date. Selecting CAD or USD changes the currency label only; there is no foreign-exchange conversion. Business name and other identifying details are optional.
The generator retains the original 46 amount fields. Enter each item once. Classification, recognition, measurement, current versus non-current presentation and appropriate accounting policies depend on your circumstances and chosen framework.
The equation stays honest.
Total assets − (total liabilities + entered equity) is the displayed difference. The worksheet does not insert retained earnings or another balancing amount. A zero difference establishes that this equation matches to the cent; it does not establish completeness, correct classification, valuation, tax treatment or compliance.
Current assets plus non-current assets equal total assets. Current plus non-current liabilities equal total liabilities. Equity is the sum of entered share capital, additional paid-in capital, retained earnings, accumulated other comprehensive income less entered treasury shares. Retained earnings and accumulated other comprehensive income may be negative.
Working capital = current assets − current liabilities. It describes those entered balances, not cash available to spend or a cash-flow forecast.
Deductions are entered as positive amounts.
Allowance for doubtful accounts reduces gross trade receivables. Accumulated depreciation reduces property, plant and equipment. Accumulated amortization reduces finite-lived intangible assets. Treasury shares reduce equity. Enter the positive deduction in its own field; do not also subtract it elsewhere.
| Field | Treatment |
|---|---|
| Allowance for doubtful accounts | Enter this deduction as a positive amount. It is subtracted from gross receivables. |
| Accumulated depreciation | Enter this deduction as a positive amount. It reduces the depreciable property entered above, not land. |
| Accumulated amortization | Enter this deduction as positive. It reduces the finite-lived intangibles and patents above; do not use it to reduce goodwill. |
| Treasury shares / equity deduction | Enter the deduction as positive. The appropriate treatment and terminology depend on the entity and reporting framework. |
A deduction that exceeds its associated gross amount remains visible and produces a warning. It is not silently clamped to zero.
Seven ratios. Their actual conventions.
All entered current liabilities are included in the liquidity denominators. Quick assets here mean cash + current marketable securities + net trade receivables. This excludes inventory, prepaid expenses and other current assets. Cash ratio includes cash and current marketable securities. A lender or source may use a different definition; match the definition before comparing.
| Measure | Formula | Interpretation limit |
|---|---|---|
| Current ratio | Current assets ÷ current liabilities | A point-in-time amount comparison, not proof that bills can be paid on time. |
| Quick ratio | (Cash + marketable securities + net trade receivables) ÷ current liabilities | This narrower convention excludes inventory, prepaids, supplies, current notes and other current assets. Other agreements may define quick assets differently. |
| Cash ratio | (Cash + marketable securities) ÷ current liabilities | This worksheet includes the entered current marketable securities; confirm their liquidity and any agreement-specific definition. |
| Liabilities-to-equity | Total liabilities ÷ total entered equity | The original debt-to-equity measure uses all liabilities, not only interest-bearing borrowing. Negative equity needs careful interpretation. |
| Liabilities-to-assets | Total liabilities ÷ total assets | The original debt ratio is presented as a percentage; it is not a lender eligibility test. |
| Equity-to-assets | Total entered equity ÷ total assets | Entered equity is not the company’s market valuation. |
| Assets-to-equity | Total assets ÷ total entered equity | The original financial-leverage measure. No automatic healthy/unhealthy threshold is applied. |
A zero denominator produces “not defined”, not zero or infinity. Negative equity and negative net assets remain signed. These outcomes do not establish insolvency, creditworthiness, eligibility or a healthy/unhealthy score.
Two chosen snapshots.
The comparison tool accepts independently chosen subtotals for A and B. It does not connect to an industry feed, infer equity, reconcile a statement of cash flows or promise a benchmark. Money difference = B − A. Percentage change = (B − A) ÷ |A| × 100, and is undefined when A is zero. For negative A, this is a comparison against the magnitude of A, not a growth claim. Ratio changes are reported as multiples or percentage points.
Use the same currency, date conventions and accounting definitions. Check whether a change reflects operations, borrowing, distributions, valuation, a correction or a reclassification before drawing a conclusion.
Exact cents, visible rounding.
Valid amounts have up to two decimal places. The model converts them to integer cents before summing. Unsupported formats, excess decimals, non-finite values and out-of-range amounts pause results and exports. Displayed ratio rounding does not feed back into the underlying amounts. Templates include formulas and a worked example for inspection; they are educational worksheets, not a filing form.
Local plans and deliberate sharing.
The public worksheet starts in page memory. Save, restore and remove buttons act only when chosen, using unencrypted browser storage on this browser profile. Downloads include optional business details and all entered amounts. Existing authenticated account records remain a separate provider workflow. A chat conversation does not read them.
AI questions go to the server only when you send them. Creating an enquiry requires its own consent. Sharing a calculator summary or conversation is a separate unchecked option with an exact preview; the summary excludes the optional business name. Read the privacy policy.
Sources and review.
Primary references provide context for accounting concepts, tax records and comparable industry data. This site does not reproduce the complete ASPE or IFRS standards or claim certification.
- BDC: what a balance sheet shows
- BDC: the elements of financial statements
- BDC: four types of financial ratios
- BDC: how a bank looks at your business
- CRA: General Index of Financial Information (GIFI)
- CRA: basic information about capital cost allowance
- IFRS Foundation: accounting frameworks in Canada
- ISED: Financial Performance Data questions and methodology
- ISED: how to create a Financial Performance Data report
- Statistics Canada: NAICS Canada 2022 classification
Suggest a correction · Open the generator · Compare snapshots
