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 your LivePlan forecast.

These starting balances create a starting point for the calculations of your forecast, and they ensure that the forecast accurately reflects your performance in the future. 

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

 

There are two ways you can enter starting balances in LivePlan:

  • If you're currently using QuickBooks Online or Xero for your day-to-day accounting, you can connect your accounting tool to the LivePlan Dashboard. This will automatically build a starting point for your forecast and enter your starting balances. 
  • If you're not using one of the above tools, you can enter your starting balances manually.

Both options are covered below.

 

Setting starting balances automatically from your accounting actuals

The first step in this process is to sync LivePlan with either QuickBooks Online or Xero. For details, see Connecting LivePlan to your accounting solution.

Note: You'll need a clean, untouched Forecast tab in your LivePlan company to use this option. If you've already started entering data in the Forecast tab, you can create a new company to work in.

When the sync is complete, you'll see that LivePlan has automatically used your accounting actuals data to add starting balances to your forecast. The software will insert a month at the start of your forecast for these initial amounts.

balance_sheet_sb_highlighted.png

Please have a look at the Editing starting balances section further below if you'd like to make changes to the starting balances.

If you'd like to know more about the starting balances, please see the section immediately below on Setting starting balances manually.

 

Setting starting balances manually

You can use this option in any existing company.

  1. From the Forecast tab, select Balance Sheet and click Set Starting Balances:
    set_starting_balances_highlighted.png
  2. 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:
    starting_balance_totals.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 and current assets your business owned before the start of the forecast.

 

To enter assets:

  1. Enter the amount of cash you have in the bank as of the start date of your forecast:
    cash.png
  2. Enter the amount your customers owe you for past sales on credit (i.e., outstanding invoices):
    accounts_receivable.png

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

  4. Indicate how much your unsold inventory is worth (if you have inventory):
    inventory.png
  5. Enter the total 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_term_assets.png
  6. Indicate how much depreciation you've claimed on these assets:
    accumulated_depreciation.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. 

  7. Enter the number of years over which you'd like to depreciate the remaining value of your fixed assets:
    depreciation_period.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 long-term assets; this entry can't set depreciation on some assets and not on others.

  8. Enter the value (without amortization) of any other current assets you have at the start of the forecast. Then select the amortization period for these assets:
    other_current_assets_starting_balances.png
  9. Click Next to move on to the Total Liabilities step.

 

Step 2: Total liabilities

Liabilities are debts, money that must be paid back. Usually, a liability 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:
    accounts_payable_starting_balances.png

    Note: Accounts payable are bills to be paid as part of the ordinary 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.png
  3. Enter the amount you currently owe for income and sales taxes:
    2022-12-16_15-07-13.png
  4. If you have any recurring charges revenue streams that have existing subscribers, and charge those subscribers every 2-12 months, then LivePlan will automatically calculate the prepaid revenue from those subscriptions and enter it in starting balances:
    prepaid.png

    Note: The prepaid revenue is calculated based on the recurring charge amounts you’ve entered in your recurring charges revenue streams.

  5. If you have any loans that exist before the start of your forecast, you'll enter those on the Financing page. With those entries in place, LivePlan will automatically calculate your short-term and long-term debt for starting balances:
    balance_sheet_debt.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 or outside investors. This is not to be confused with par value of the stock or the market value of the stock, which are not represented in the starting balances.
  2. LivePlan calculates your retained earnings automatically, and they are displayed here:
    retained_earnings.png

    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

From the Forecast tab, select Balance Sheet and click Set Starting Balances to edit your starting balances:

set_starting_balances_highlighted.png

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

set_starting_balances.gif

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

Was this article helpful?
75 out of 103 found this helpful
Have more questions? Submit a request

Comments

0 comments

Article is closed for comments.