STEP 1 OF 4
Set the scene.
These details are optional and stay in this worksheet. Choose one currency; changing the label does not convert amounts.
Included in files you explicitly download. Excluded from the optional chat summary.
No exchange rate or currency conversion.
Enter each item once. Keep supporting notes separately. This tool does not inspect your accounts, classify an instrument or decide whether an asset should be recognized.
STEP 2 OF 4
What the business holds.
Keep gross amounts and their deductions separate. Tip buttons explain every field.
STEP 3 OF 4
What it owes. What is entered as equity.
Keep current and non-current portions separate. Retained earnings and accumulated other comprehensive income may be negative.
STEP 4 OF 4
Review every line.
The tool preserves your entries. A difference remains visible until you correct the underlying records.
| Section and line | Entered | Signed contribution |
|---|---|---|
| Current assetsCash and cash equivalents | $0.00 | $0.00 |
| Current assetsMarketable securities | $0.00 | $0.00 |
| Current assetsAccounts receivable, gross | $0.00 | $0.00 |
| Current assetsAllowance for doubtful accounts (deduction) | $0.00 | $0.00 |
| Current assetsNotes receivable, current | $0.00 | $0.00 |
| Current assetsInventory | $0.00 | $0.00 |
| Current assetsSupplies | $0.00 | $0.00 |
| Current assetsPrepaid expenses | $0.00 | $0.00 |
| Current assetsOther current assets | $0.00 | $0.00 |
| Property, plant and equipmentLand | $0.00 | $0.00 |
| Property, plant and equipmentBuildings, gross | $0.00 | $0.00 |
| Property, plant and equipmentLeasehold improvements, gross | $0.00 | $0.00 |
| Property, plant and equipmentEquipment, gross | $0.00 | $0.00 |
| Property, plant and equipmentVehicles, gross | $0.00 | $0.00 |
| Property, plant and equipmentFurniture and fixtures, gross | $0.00 | $0.00 |
| Property, plant and equipmentAccumulated depreciation (deduction) | $0.00 | $0.00 |
| Investments and intangible assetsLong-term investments | $0.00 | $0.00 |
| Investments and intangible assetsOther finite-lived intangibles, gross | $0.00 | $0.00 |
| Investments and intangible assetsGoodwill, carrying amount | $0.00 | $0.00 |
| Investments and intangible assetsPatents, gross | $0.00 | $0.00 |
| Investments and intangible assetsAccumulated amortization (deduction) | $0.00 | $0.00 |
| Other non-current assetsDeferred tax assets | $0.00 | $0.00 |
| Other non-current assetsOther non-current assets | $0.00 | $0.00 |
| Current liabilitiesAccounts payable | $0.00 | $0.00 |
| Current liabilitiesAccrued expenses | $0.00 | $0.00 |
| Current liabilitiesUnearned revenue | $0.00 | $0.00 |
| Current liabilitiesBusiness credit cards | $0.00 | $0.00 |
| Current liabilitiesShort-term loans | $0.00 | $0.00 |
| Current liabilitiesCurrent portion of long-term debt | $0.00 | $0.00 |
| Current liabilitiesNotes payable, current | $0.00 | $0.00 |
| Current liabilitiesTaxes payable | $0.00 | $0.00 |
| Current liabilitiesDividends payable | $0.00 | $0.00 |
| Current liabilitiesOther current liabilities | $0.00 | $0.00 |
| Non-current liabilitiesTerm loans, non-current | $0.00 | $0.00 |
| Non-current liabilitiesLines of credit, non-current | $0.00 | $0.00 |
| Non-current liabilitiesMortgages, non-current | $0.00 | $0.00 |
| Non-current liabilitiesBonds payable, non-current | $0.00 | $0.00 |
| Non-current liabilitiesDeferred tax liabilities | $0.00 | $0.00 |
| Non-current liabilitiesPension obligations, non-current | $0.00 | $0.00 |
| Non-current liabilitiesOther non-current liabilities | $0.00 | $0.00 |
| EquityCommon shares / owner capital | $0.00 | $0.00 |
| EquityPreferred shares | $0.00 | $0.00 |
| EquityContributed and other paid-in surplus | $0.00 | $0.00 |
| EquityRetained earnings / accumulated deficit | $0.00 | $0.00 |
| EquityTreasury shares / equity deduction (deduction) | $0.00 | $0.00 |
| EquityAccumulated other comprehensive income | $0.00 | $0.00 |
| Current Assets | $0.00 | |
| Net Receivables | $0.00 | |
| Ppe | $0.00 | |
| Finite Intangibles | $0.00 | |
| Intangibles | $0.00 | |
| Non Current Assets | $0.00 | |
| Assets | $0.00 | |
| Current Liabilities | $0.00 | |
| Non Current Liabilities | $0.00 | |
| Liabilities | $0.00 | |
| Equity | $0.00 | |
| Working Capital | $0.00 | |
| Quick Assets | $0.00 | |
| Cash Assets | $0.00 | |
| Liabilities And Equity | $0.00 | |
| Difference | $0.00 | |
| Measure | Result | Calculation and context |
|---|---|---|
| Current ratio | Not defined | Current assets ÷ current liabilities $0.00 ÷ $0.00 Not defined because the entered denominator is zero. A point-in-time amount comparison, not proof that bills can be paid on time. |
| Quick ratio | Not defined | (Cash + marketable securities + net trade receivables) ÷ current liabilities $0.00 ÷ $0.00 Not defined because the entered denominator is zero. This narrower convention excludes inventory, prepaids, supplies, current notes and other current assets. Other agreements may define quick assets differently. |
| Cash ratio | Not defined | (Cash + marketable securities) ÷ current liabilities $0.00 ÷ $0.00 Not defined because the entered denominator is zero. This worksheet includes the entered current marketable securities; confirm their liquidity and any agreement-specific definition. |
| Liabilities-to-equity | Not defined | Total liabilities ÷ total entered equity $0.00 ÷ $0.00 Not defined because the entered denominator is zero. The original debt-to-equity measure uses all liabilities, not only interest-bearing borrowing. Negative equity needs careful interpretation. |
| Liabilities-to-assets | Not defined | Total liabilities ÷ total assets $0.00 ÷ $0.00 Not defined because the entered denominator is zero. The original debt ratio is presented as a percentage; it is not a lender eligibility test. |
| Equity-to-assets | Not defined | Total entered equity ÷ total assets $0.00 ÷ $0.00 Not defined because the entered denominator is zero. Entered equity is not the company’s market valuation. |
| Assets-to-equity | Not defined | Total assets ÷ total entered equity $0.00 ÷ $0.00 Not defined because the entered denominator is zero. The original financial-leverage measure. No automatic healthy/unhealthy threshold is applied. |
TAKE THE WHOLE WORKSHEET
Your records. Your choice.
CSV and JSON include the optional business details, all 46 amounts, signed deductions, totals, formulas, ratio inputs and limitations. Keep downloaded files private.
No automatic saving or restoration. Browser storage is local, unencrypted and shared with anyone using this browser profile. It is separate from existing account records. A downloaded file is a more portable copy.
The method stays visible.
Amounts are validated to two decimals, converted to integer cents, and added or subtracted without intermediate dollar rounding. Allowances, accumulated depreciation, amortization and treasury shares are positive deductions. The tool never makes equity balance automatically.
Quick assets = cash + current marketable securities + net trade receivables. All current liabilities are included. Ratios with zero denominators are not defined. Negative equity remains signed and needs careful interpretation. These conventions can differ from a lender’s agreement.
Read the full methodology · Compare two chosen snapshots · Download blank and worked Excel templates
Complete balance-sheet worksheet
Currency: CAD. Period end: not specified. Industry: not specified. Employees: not specified. Established: not specified.
| Section and line | Entered | Signed contribution |
|---|---|---|
| Current assetsCash and cash equivalents | $0.00 | $0.00 |
| Current assetsMarketable securities | $0.00 | $0.00 |
| Current assetsAccounts receivable, gross | $0.00 | $0.00 |
| Current assetsAllowance for doubtful accounts (deduction) | $0.00 | $0.00 |
| Current assetsNotes receivable, current | $0.00 | $0.00 |
| Current assetsInventory | $0.00 | $0.00 |
| Current assetsSupplies | $0.00 | $0.00 |
| Current assetsPrepaid expenses | $0.00 | $0.00 |
| Current assetsOther current assets | $0.00 | $0.00 |
| Property, plant and equipmentLand | $0.00 | $0.00 |
| Property, plant and equipmentBuildings, gross | $0.00 | $0.00 |
| Property, plant and equipmentLeasehold improvements, gross | $0.00 | $0.00 |
| Property, plant and equipmentEquipment, gross | $0.00 | $0.00 |
| Property, plant and equipmentVehicles, gross | $0.00 | $0.00 |
| Property, plant and equipmentFurniture and fixtures, gross | $0.00 | $0.00 |
| Property, plant and equipmentAccumulated depreciation (deduction) | $0.00 | $0.00 |
| Investments and intangible assetsLong-term investments | $0.00 | $0.00 |
| Investments and intangible assetsOther finite-lived intangibles, gross | $0.00 | $0.00 |
| Investments and intangible assetsGoodwill, carrying amount | $0.00 | $0.00 |
| Investments and intangible assetsPatents, gross | $0.00 | $0.00 |
| Investments and intangible assetsAccumulated amortization (deduction) | $0.00 | $0.00 |
| Other non-current assetsDeferred tax assets | $0.00 | $0.00 |
| Other non-current assetsOther non-current assets | $0.00 | $0.00 |
| Current liabilitiesAccounts payable | $0.00 | $0.00 |
| Current liabilitiesAccrued expenses | $0.00 | $0.00 |
| Current liabilitiesUnearned revenue | $0.00 | $0.00 |
| Current liabilitiesBusiness credit cards | $0.00 | $0.00 |
| Current liabilitiesShort-term loans | $0.00 | $0.00 |
| Current liabilitiesCurrent portion of long-term debt | $0.00 | $0.00 |
| Current liabilitiesNotes payable, current | $0.00 | $0.00 |
| Current liabilitiesTaxes payable | $0.00 | $0.00 |
| Current liabilitiesDividends payable | $0.00 | $0.00 |
| Current liabilitiesOther current liabilities | $0.00 | $0.00 |
| Non-current liabilitiesTerm loans, non-current | $0.00 | $0.00 |
| Non-current liabilitiesLines of credit, non-current | $0.00 | $0.00 |
| Non-current liabilitiesMortgages, non-current | $0.00 | $0.00 |
| Non-current liabilitiesBonds payable, non-current | $0.00 | $0.00 |
| Non-current liabilitiesDeferred tax liabilities | $0.00 | $0.00 |
| Non-current liabilitiesPension obligations, non-current | $0.00 | $0.00 |
| Non-current liabilitiesOther non-current liabilities | $0.00 | $0.00 |
| EquityCommon shares / owner capital | $0.00 | $0.00 |
| EquityPreferred shares | $0.00 | $0.00 |
| EquityContributed and other paid-in surplus | $0.00 | $0.00 |
| EquityRetained earnings / accumulated deficit | $0.00 | $0.00 |
| EquityTreasury shares / equity deduction (deduction) | $0.00 | $0.00 |
| EquityAccumulated other comprehensive income | $0.00 | $0.00 |
| Current Assets | $0.00 | |
| Net Receivables | $0.00 | |
| Ppe | $0.00 | |
| Finite Intangibles | $0.00 | |
| Intangibles | $0.00 | |
| Non Current Assets | $0.00 | |
| Assets | $0.00 | |
| Current Liabilities | $0.00 | |
| Non Current Liabilities | $0.00 | |
| Liabilities | $0.00 | |
| Equity | $0.00 | |
| Working Capital | $0.00 | |
| Quick Assets | $0.00 | |
| Cash Assets | $0.00 | |
| Liabilities And Equity | $0.00 | |
| Difference | $0.00 | |
| Measure | Result | Calculation and context |
|---|---|---|
| Current ratio | Not defined | Current assets ÷ current liabilities $0.00 ÷ $0.00 Not defined because the entered denominator is zero. A point-in-time amount comparison, not proof that bills can be paid on time. |
| Quick ratio | Not defined | (Cash + marketable securities + net trade receivables) ÷ current liabilities $0.00 ÷ $0.00 Not defined because the entered denominator is zero. This narrower convention excludes inventory, prepaids, supplies, current notes and other current assets. Other agreements may define quick assets differently. |
| Cash ratio | Not defined | (Cash + marketable securities) ÷ current liabilities $0.00 ÷ $0.00 Not defined because the entered denominator is zero. This worksheet includes the entered current marketable securities; confirm their liquidity and any agreement-specific definition. |
| Liabilities-to-equity | Not defined | Total liabilities ÷ total entered equity $0.00 ÷ $0.00 Not defined because the entered denominator is zero. The original debt-to-equity measure uses all liabilities, not only interest-bearing borrowing. Negative equity needs careful interpretation. |
| Liabilities-to-assets | Not defined | Total liabilities ÷ total assets $0.00 ÷ $0.00 Not defined because the entered denominator is zero. The original debt ratio is presented as a percentage; it is not a lender eligibility test. |
| Equity-to-assets | Not defined | Total entered equity ÷ total assets $0.00 ÷ $0.00 Not defined because the entered denominator is zero. Entered equity is not the company’s market valuation. |
| Assets-to-equity | Not defined | Total assets ÷ total entered equity $0.00 ÷ $0.00 Not defined because the entered denominator is zero. The original financial-leverage measure. No automatic healthy/unhealthy threshold is applied. |
All monetary entries are zero. A zero balance check does not establish that the records are complete.
Classification, recognition, measurement, notes, taxes and reporting-framework compliance require separate review. This is an educational worksheet, not an audit, filing or valuation.
Choose recorded amounts for one date and one currency. A matching equation does not establish completeness, valuation, ASPE or IFRS compliance. Read the method and limits.
