PerpetualBudget    

     


Contact Us
 

 

       

 

Existing Spreadsheets

If you currently use Excel for budgeting or planning you undoubtedly have made a big investment in templates used for these functions. PerpetualBudget can easily integrate your specialized templates into the system processing. You can see examples of some fixed structure templates used in the program as "drill-down" templates from the detailed P & L. We can do the same or similar technique with your templates. Contact Support at SBA for more information on how this works. If the template is of a general nature and might be useful to other customers, there is no charge to integrate it into PerpetualBudget.

Calculation Spreadsheets

Recently we added a feature to PerpetualBudget that allows you to integrate one calculation type spreadsheet per profit center (or cost center). This technique requires adding two or three new columns to the left margin of your existing worksheet. By encoding a line item account ID, organization ID and line item name on lines you wish to associate with your P & L, the program inserts formulas into the P & L worksheet at the correct cells to indirectly link the two worksheets. This technique is described in more detail here. The benefit to you is being able to customize how certain line items are calculated without the program having to "know" how it is being done. Contact Support at SBA for assistance.

 

 

 

 

 

 

[Back]    [Home]


PerpetualBudget and Spicer-Baer Associates are registered trademarks of Spicer-Baer Associates, Inc.  Excel, Access and Microsoft Windows are registered trademarks of the Microsoft Corporation.  QuickBooks Pro is a registered trademark of Intuit Inc.

Questions or problems regarding this web site should be directed to Webmaster@spicer-baer.com.
Copyright © 1999-2007 Spicer-Baer Associates, Inc.  All rights reserved.
Last modified: Sunday April 22, 2007.