Budgets are a planned estimate of costs or revenues over a specified period which are used to compare against actual results. Budgets are stored in the Financial Cube object and can be used in native Salesforce reports as well as the Accounting Seed Financial Reporter.

Creating a budget Ledger

Ledgers in Accounting Seed are used to denote actual results from budgeted results. All organizations are required to have a transactional ledger. Only one transactional ledger can exist in a single Salesforce instance. Users can setup as many budget ledgers as they desire. Budget records are stored as Financial Cubes and associated with a Budget ledger. Financial Cubes are also used to store your actual transactional data, these Financial Cubes are associated with your Transactional Ledger and are not editable, in anyway other than by altering the source transactions.

To create a budget ledger:

  1. Navigate to the Ledgers tab and click the New button
  2. Enter the name of the Ledger e.g. 2014 Budget
  3. Select Budget from the Type field
  4. Click Save

Creating A Budget Record

Summary of Steps:

We suggest the following when managing your budget Financial Cubes:

  1. Build list views on the Financial Cubes tab to view only budget Financial Cubes and by Accounting Period or GL Account if further breakdown is required
  2. Use a .csv file to upload your initial budget (template is below)
  3. Use the UI to adjust particular records if the need arises
  4. A Debit balance is uploaded as a positive value
  5. A Credit balance is uploaded as a negative value
  6. The Cube Type will always be Period
  7. The Opening Balance filed represents the prior month closing balance
  8. The Amount filed represents your budgeted amount for that particular Financial Cube
  9. The Year to date field is a calculation of Opening Balance + Amount
  10. The variables that define any given cube are as follows:
    • Accounting Period
    • GL Account
    • GL Accounting Variable 1
    • GL Accounting Variable 2
    • GL Accounting Variable 3
    • GL Accounting Variable 4
    • Ledger
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.