Welcome to FormCalc SST for QuickBooks

Top  Next

 

 

 

FormCalc SST Is...

FormCalc SST is a spreadsheet-based calculator for QuickBooks forms—Invoices, Purchase Orders, Sales Order, or any form where QuickBooks Items are used. FormCalc SST lets you set up spreadsheet formulas to do calculations involving various fields on the form, then applies those calculations "on the fly" as it processes the entire form. It can do math involving several columns at once, produce column subtotals and totals columns, access the form's header and footer fields, and much more.

"Big deal", you might say, "doesn't QuickBooks already have a calculator?" Well, it does, but the simple calculator in QuickBooks forms only works within a single field on the form, not between fields. And it only supports addition, subtraction, multiplication, and division. FormCalc SST lets you do calculations involving multiple fields, and gives you date math, if-then logic, advanced built-in spreadsheet functions like COUNT and AVERAGE, and many other sophisticated calculation and formatting options—just like a full-fledged spreadsheet.

How is FormCalc SST Different from FormCalc (the old / original version)?

FormCalc SST is a completely redesigned product. It is based on the general concept of the old FormCalc for QuickBooks product, but it has the added benefits and greater flexibility offered by spreadsheet calculation capabilities, a wide range of results formatting possibilities, better file handling, data file sharing on networks, and more.

Is the old FormCalc still available? Yes! It is still a good choice if your needs are simple—you only want to add, subtract, multiply, or divide numbers in two columns on an invoice, say, or total a column or two.

How Does FormCalc SST Work?

Setting up and using FormCalc SST is fairly simple:

1.You may customize your QuickBooks form if desired, adding fields and/or columns to hold results calculated by FormCalc SST. (Optional; not always necessary.)

2.FormCalc SST takes a "snapshot" of the form. It gathers information about the form's layout and builds a spreadsheet representation of it.

3.You enter spreadsheet formulas on the snapshot worksheet to define the calculations you want done, then save the FormCalc SST file.

4.In QuickBooks you fill out forms as usual, then press a hotkey to invoke FormCalc SST to do the calculations you have defined. FormCalc SST builds a spreadsheet from the form's data "on the fly", applies your formulas to it, and writes the results back to the form in QuickBooks, where you may save it, print it, etc., just as you have always done.

Results calculated by FormCalc SST are saved as part of the form's normal data. Your accountant or others do not need to have FormCalc SST to see those results when they view or edit the form.

Specifications & Requirements

FormCalc SST has these computer hardware and software requirements:

Works with all Microsoft Windows editions of QuickBooks—Simple Start, Pro, Premier, Enterprise Solutions, etc.— including all international versions:  U.S., Canadian, UK, and Australian.

Works with old QuickBooks versions for Microsoft Windows too, including many which are not compatible with most QuickBooks add-ons.

Microsoft Windows XP or a later version of Microsoft Windows.

10 mb hard drive space.

Memory:  any computer with enough memory to run QuickBooks has enough memory for running FormCalc SST.

This list may change as new FormCalc SST versions are released. An up-to-date list of specifications and requirements can be found on the FormCalc SST Downloads page of our Web site.

Copyright and Trademarks

This publication is: Copyright © 1996-2013 Flagship Technologies, Inc. All rights reserved.

FormCalc SST is a trademark of Flagship Technologies, Inc.

QuickBooks is a trademark of Intuit.

Revised: 11/15/2017