Entering starting balances for an existing company Follow

Starting balances are only relevant for existing businesses. If your plan is for a new venture, you don't need to set starting balances in the forecast. If you are the owner of an up-and-running business, however, you'll need to provide your total asset, liability, and equity balances as of the start of the LivePlan forecast.

Entering starting balances in your forecast creates an accurate starting point for your forecast, and ensures that the forecast accurately reflects your performance going forward. For example, any outstanding Accounts Receivable you have need to be applied as revenue in the initial months of your forecast.

Note that starting balances are how LivePlan represents past performance. If you'd like to include more past performance detail than this in your plan, we offer some options in Representing past performance in LivePlan.

 

Setting starting balances

Once you enter your starting balances, a new column will appear in the balance sheet, before the first month of the forecast. So, your starting balances effectively becomes the “month 0” column in the balance sheet.

 

To begin entering your starting balances:

  1. Click the Forecast tab, and then click Balance Sheet:
    balance-sheet-menu.png
  2. Next, click the Set Starting Balances button:
    starting-balances-button-min.png
  3. At the top of the Starting Balances overlay, you'll see an equation expressing that the sum of your liabilities and equity must equal your assets. As you enter or edit starting balances in the overlay, this equation will update to show the current totals:
    startingbalancesequation-min.png
Note: You can click on Total Assets, Total Liabilities, or Total Equity in the equation to switch to that step of the starting balances process.

 

Step 1: Total assets

In this section, you'll enter any cash on hand, accounts receivable, and long-term assets your business owned prior to the start of the forecast. 

 

To enter assets:

  1. Enter the amount of cash you have in the bank:cashstarting.png
  2. Enter the amount your customers owe you for past sales on credit (i.e., outstanding invoices):
    accounts-receivable-min.png

  3. From the list, choose how long it will take you to collect on the outstanding past sales on credit:
    daystogetpaid_160816_214747-min.png

  4. Indicate how much your unsold inventory is worth (if you have inventory):
    inventory_starting.png
  5. Enter the full value of your fixed (long-term) assets:
    Note: Fixed assets include things that will have a long standing value, such as land or equipment.
    long-termassets.png
  6. Indicate how much depreciation you've claimed on these assets:
    depreciation_starting.png

    Note: Depreciation is an accounting and tax concept used to estimate the loss in value of an asset over time. Assets depreciate due to wear and tear or by being replaced by newer models/technology. The older an asset gets, the more it depreciates in value. 

  7. Enter the number of years over which you'd like to depreciate the remaining value of your fixed assets:
    starting-bal-nondepr-asset.png

    Note: If you don't want to show depreciation on your starting assets, choose Forever (do not depreciate). This setting applies to all starting assets; this entry can't set depreciation on some assets and not on others.

  8. Click Next to move onto the Total Liabilities step.

 

Step 2: Total liabilities

Liabilities are debts; money that must be paid back. Usually a liability that you pay back in less than 12 months is called a short-term debt, and a liability that will take longer than 12 months to pay back is a long-term debt.

  1. Enter the amount you owe your vendors for past purchases on credit:
    acctspayable_starting-min.png

    Note: Accounts payable are bills to be paid as part of the normal course of business. When your business receives goods or services from a vendor, you receive an invoice, and until that invoice is paid, the amount is recorded as part of your Accounts Payable.

  2. From the list, choose how long it will take you to pay off your past purchases on credit:
    days_to_pay_starting-min.png
  3. Enter the amount you have saved up to pay your next corporate tax bill:
    corporate_taxes_payable.png
  4. Enter the amount you have saved up to pay your next sales tax bill:
    sales_taxes_payable-min.png
  5. If you have any loans that exist before the start of your forecast, you'll enter those in the Financing page. With those entries in place, LivePlan will automatically calculate your short-term and long-term debt for starting balances:short_and_long_term_debt-min.png
  6. Click Next to move on to the Total Equity step.

 

Step 3: Total equity

  1. Enter the amount of money that you or others have invested in the business in exchange for equity:
    paid-in_capital.png
    Note: Paid-in capital is actual money paid into the company as equity investments by owners.. This is not to be confused with par value of stock, or market value of stock, which are not represented in the starting balances.
  2. LivePlan calculates your retained earnings automatically, and they are displayed here:
    retained_earnings.jpg

    Note: Retained earnings are those that have been reinvested into the company, not paid out as dividends to the owners. When retained earnings are negative, the company has accumulated losses. 

  3. Click Save & Close. The Projected Balance Sheet will be updated to display the information you entered.

 

Editing starting balances

To edit your starting balances, click the Balance Sheet link in the Forecast tab, and then click the Set Starting Balances button to access your original entries:

balance-sheet-menu.png

set_starting_balances_button.jpg

Remember, you can go directly to any of the steps in the overlay by clicking on the equation at the top:

edit-starting-balances.gif#asset:1909

Update any entries you need to change in the three sections, and then click Save & Close.

Was this article helpful?
40 out of 50 found this helpful
Have more questions? Submit a request

Comments

0 comments