Column math. Basically any spreadsheet calculation you can think of can be done between columns in the detail (Item rows) area of a QuickBooks form.
Chain calculations. Calculations are not limited to two columns. As in any spreadsheet, formulas can refer to any number of columns on the QuickBooks form, as well as any number of fields in the form's header and footer.
Text manipulation. Want special comments, customer messages, or descriptions to be automatically created based on other data on a QuickBooks form? FormCalc SST can do that!
FormCalc SST can access most header and footer fields. You can enter data in a header field, say, as a factor to use in calculations on each row of the form.
Write results to header and footer fields. Not only can FormCalc SST access header and footer field data, it can also write results to them.
Lets you use of custom field data in calculations. QuickBooks can automatically include custom field data from the Item, Customer, or Vendor lists on QuickBooks forms. Because it can access this data, FormCalc SST allows your calculations to be individualized for specific items, customers, or vendors.
Lots of formatting options: decimal places, commas, currency symbols, date and time formats, and more.
Mixed fractions. Send calculated results to QuickBooks as mixed fractions if you want.
Example: A lumber yard operator or HVAC contractor might use FormCalc SST to calculate a result of 1.75, but they'd like it displayed on QuickBooks invoices as 1-3/4 (one and three-quarters). FormCalc SST can do that!
This unique feature lets formulas access data from several different rows of a QuickBooks form, to do complicated calculations.
Here's a QuickBooks invoice from one of the Problem Solved™ examples. The area highlighted in red at the bottom shows sales-taxable and non-taxable freight and fuel surcharges. These four rows were calculated by FormCalc SST with formulas which access data from prior rows on the invoice.
Click to view larger / resizeable
Another point: The two fields highlighted in the header area are examples of how FormCalc SST can read/write data and results in the header and footer of QuickBooks forms. In this case, FormCalc SST has written totals for freight and fuel surcharges into header fields.
❖Provides calculation abilities not available in QuickBooks, greatly expanding the use and value of your QuickBooks forms and the data you have entered on them.
❖Reduces errors. Doing calculations outside of QuickBooks--in an Excel spreadsheet or on a calculator--is an open invitation for typing and number transposition errors. FormCalc SST directly uses the data you've entered on a form, without the need to retype it or copy it somewhere else.
❖Quick to use—invoked from within QuickBooks by pressing a hotkey. You don't have to leave QuickBooks and load your Invoice, Estimate, Sales Receipt, etc., into some other program to do calculations.
❖Familiar layout and organization, if you have ever used a spreadsheet such as Microsoft Excel.
❖A detailed Help system with plenty of how-to examples and a reference to spreadsheet functions provides the information you need to start using FormCalc SST right away.
❖Free access to our Web-based support resources: tutorials, how-to examples, and discussion forums.
FormCalc SST works with all Microsoft Windows desktop editions of QuickBooks, including:
❖The full QuickBooks product line. Not just Pro, Premier, Accountant, and Enterprise Solutions, but also Standard, Basic, and Simple Start (editions which are no longer available).
❖Hosted QuickBooks. QuickBooks editions installed on remote hosting services like Right Networks or Cloud9.
❖Most non-U.S. versions. UK, Canadian, and Australian.
❖Non-current versions. ...even versions as old as QuickBooks 5 or QuickBooks 99!
FormCalc SST has been tested with many QuickBooks editions but not every possible combination. The best way to know if it will work with your edition, is to try it: if you install FormCalc SST on your computer it will work for free for 30 days. The only cost of trying it is your time.