Once you've created your budget structure, entering your preliminary budget amounts in Sage Intacct Planning (SIP) is easy. Built-in dynamic templates are among the main tools in the SIP application that provide a majority of what you need for building your budget. Templates provide you with a guide for inputting the necessary relevant data per budget line, as well as a preview of how this budget line impacts your cash and P&L data over the budgeted time period. The data you enter in the budget line appears in the reports displayed in the Sheets tab.
Enter your budget line data
To enter data into your budget, you have a choice of multiple built-in templates. Some examples include:
subscription revenue or perpetual licenses for Revenues
per employee expenses, salary & wages, or past balances for Expenses, and
loan and equity financing for Other income and expenses
💡 For easy navigation, the budget line templates contain the budget line name and the breadcrumb navigation (where the budget line is located in your budget tree), so you always know where you are in your budget.
💡 In general, you enter the preliminary budget amounts into the template manually, or you can copy and paste data from a spreadsheet. But, you can also create your own calculations, and use business assumptions to create budget lines. To learn more about working with models, see Getting started with models.
To enter your preliminary budget amounts:
1. From the Inputs > Main tab, select a budget line from your budget structure.
📝 In your budget tree, a label appears with No data next to budget lines that don't have budget data.
2. Choose a budget line type from the Type dropdown list and enter the details of your budget line accordingly.
3. For instance, if you assign the type Perpetual Licenses, the fields for this template are displayed. From the Bookings section of the template, you can choose how often you can expect the perpetual license to be paid: Once, Monthly, Quarterly, or Yearly. Enter the booking amounts (the total contract value), cash receipt dates, occurrence, when to invoice, and when to pay.
4. If you select a booking other than a one-time payment, like Monthly, you can decide how you'd like to spread the payment over the billing period and the amount you expect to receive each month, the currency, as well as Payment after for cash receipt in delay.
As you enter data, calculations are applied to your cash, P&L, and balance sheet budgets. The preview pane is automatically updated and you can toggle between Preview of Cash and Preview of P&L to get a detailed view of how this budget line affects your budget and how it will look in your cash and P&L plans.
For more information on working with cash, P&L, and balance sheet reports, and how to add opening balances, watch How to work with Cash, P&L, and Balance sheet.