What Is the Beginning Balance Sheet in QuickBooks Business Planner?
Learn what the beginning balance sheet reports in QuickBooks Business Planner, including its components from assets to liabilities for accurate projections.
QuickBooks users who build financial projections using the Business Planner module often encounter the beginning balance sheet. It’s the first snapshot of a company’s financial position for the forecast period. Community forums show that many users are unsure what each line represents and how the numbers are calculated. Here’s a clear breakdown of the report’s structure based on the accepted community explanation.
What the Beginning Balance Sheet Shows
The beginning balance sheet lists the opening balances of all asset, liability, and equity accounts imported from your QuickBooks company file. These values serve as the foundation for the projected income statement and cash‑flow numbers that Business Planner generates. Without a solid understanding of this report, the rest of the projection can be misleading.
Assets
Assets are items of value the business owns. The report splits them into current, fixed, and other categories.
Current assets are cash or assets that will be converted to cash or used up within one year. This includes:
- Cash – the amount of cash on hand in the business, often pulled from the bank and checking accounts in QuickBooks.
- Accounts Receivable – the total of all A/R accounts imported. This amount flows into the projection based on the credit terms set in the Company section.
- Inventory – items the business owns and intends to sell.
- Other Current Assets – the sum of other current asset accounts (excluding inventory). This figure stays constant throughout the projection.
The total of all current assets is shown as Total Current Assets.
Fixed assets (net) includes property, plant, and equipment, less depreciation. Existing fixed assets from QuickBooks are depreciated according to the amounts entered for Years 1, 2, and 3. New fixed assets entered in the Interview section are depreciated straight‑line based on their category and useful life.
Other assets (net) covers deposits and start‑up costs, less amortization. Existing other‑asset balances from QuickBooks are amortized per the amounts you enter for each year. New start‑up costs are amortized evenly over 60 months. Deposits are not amortized.
Finally, Total Assets is the sum of all asset categories.
Liabilities
Liabilities represent debts the business owes. They are divided into current and long‑term.
Current liabilities are due within one year:
- Accounts Payable (inventory) – amount owed for inventory purchased on credit. This appears only if the business uses inventory and has terms of Net 30 or longer.
- Line of Credit – short‑term borrowing available to the business.
- Notes Payable – formal loans due in less than one year.
- Current Maturities of Long‑Term Liabilities – the principal portion of long‑term debt due within one year (interest is not included).
- Accrued Liabilities – the sum of all A/P accounts from QuickBooks, minus inventory payable and other current liabilities not classified as line‑of‑credit. This value stays constant across the projection.
Total Current Liabilities is the sum of those items.
Long‑term liabilities (net) are debt principal payments due beyond one year, net of interest expense. The beginning balance sheet also includes a note that long‑term liabilities are shown after removing interest.
Equity
Equity is the owner’s claim on the business after liabilities. It includes owner’s capital, retained earnings, and any other equity accounts imported from QuickBooks. The beginning balance sheet ensures the accounting equation (Assets = Liabilities + Equity) is balanced.
Important Note on Rounding
Business Planner rounds numbers on its reports to the nearest dollar or cent, depending on space constraints. As a result, totals and subtotals may not exactly equal the sum of the displayed figures. This is a known behavior and not a data error – the underlying calculations use full precision.
For QuickBooks users, the beginning balance sheet is the first checkpoint in a Business Planner projection. Reviewing each component ensures that asset, liability, and equity balances are correctly imported and set the stage for realistic financial forecasts. If any line seems off, double‑check the corresponding account balances in your QuickBooks company file before proceeding with the full projection.