Tag Archives: calculator

FullSpeed Provides Spreadsheet-like Macros in Cloud-based Accounting Apps: QuickBooks Online, Xero, and Others

Madison, Missouri, September 26, 2014 , Most people who have used word processing software know what a macro is: a group of commands you can put together quickly to do a repetitive job, like adding blank spaces at the beginnings of several lines, or changing underlined words to italics on an entire page. Wouldn’t it be great if someday macros could apply calculations to multiple lines of data in applications like QuickBooks Online, Xero, or other cloud-based accounting software?

That day is here! FullSpeed lets you set up simple formulas in its own internal spreadsheet and applies them to data in other programs at the press of hotkey. In fact you can have multiple macros defined, each with its own unique hotkey.

What kinds of things can FullSpeed do? …calculations involving multiple columns of an invoice, column subtotals and totals, calculate discounts or freight surcharges or special taxes, autonumber lines, provide customized messages like “A discount of $123.45 is available if paid by October 15, 2014”, and a lot more. FullSpeed supports a wide range of Excel-compatible spreadsheet features such as numeric and statistical functions, IF logic, date/time functions, text manipulation, and plenty of ways to format results: currency, numeric, date/time, etc.; even the ability to display decimal amounts as fractions.

FullSpeed works in invoices, estimates, purchase orders, sales orders, bills, checks, sales receipts, grids, etc.–almost anywhere you can enter accounting data. It is compatible with any Windows-based Web browser which supports Microsoft’s UI Automation technology, such as Google Chrome, Mozilla Firefox, or Microsoft Internet Explorer. FullSpeed is not limited to browser-based apps though: it also works in some native Windows applications like QuickBooks desktop editions. (Though FullSpeed can work with a variety of application types, it has mostly been certified to work with accounting applications in this first release of the product.)

Many cloud-based accounting applications have limited space available for data or calculated results. For example, neither QuickBooks Online nor Xero currently supports custom fields in the line items area of invoices. But FullSpeed overcomes this problem in two ways:

(1) It supports storing data in the Description field of sale or purchase items, and can extract it to use in calculations. For instance, users can store a per-unit shipping weight in each item’s Description, and FullSpeed can use it to calculate the total shipping weight for an invoice.

(2) FullSpeed’s Scratchpad feature allows macros to temporarily store results of intermediate calculations, so they don’t have to be written to the target application where no space may be available to hold them.

Maybe the most unique feature of FullSpeed is that it works directly on data in the target application. Users get to see the results of calculations immediately while working in an invoice, purchase order, or other form. There’s no need to export the form’s data to do calculations in Microsoft Excel or some other program, and no need to re-import or Copy and Paste results that were calculated elsewhere.

FullSpeed is priced at $119 for a single-user license, less for multi-user licensing. FullSpeed is compatible with Microsoft Windows XP (SP3) and all later versions including Windows 7 and Windows 8.

A downloadable 30-day free trial and step-by-step examplesare are available from FullSpeed’s main Web page: http://www.goflagship.com/products/fullspeed.htm

— End —

Contact Details:

Mark Wilsdorf
Flagship Technologies, Inc.
14976 Monroe Road 1039
Madison, MO, USA

info@goflagship.com
660-291-3000

FullSpeed home page: http://www.goflagship.com/products/fullspeed.htm

Via EPR Network
More Accounting press releases

FormCalc Does Spreadsheet-like Calculations on QuickBooks Invoices, Estimates, Purchase Orders and More

For almost as long as QuickBooks has been on the market, QuickBooks users have wanted for the ability to have across-column calculations and column totals on Invoices, Estimates, Purchase Orders and other forms. FormCalc for QuickBooks, from Flagship Technologies, Inc. (www.goflagship.com), is now available to fill that need.

FormCalc lets users set up calculations which add, subtract, multiply, or divide numbers in two columns and put the result in a third column; or do math on two columns and multiply the result by another numeric value before writing it to a third column; or display a count of unique items in a column, in the Description field of any line; or provide column subtotals or totals.

The user controls where column subtotals and totals appear by identifying certain QuickBooks Items as “trigger items”. When FormCalc encounters a line containing a trigger item, it puts the column subtotal or total on that line.

Users can define any number of calculations to apply to various columns on a form, and apply all of them at once by pressing a hotkey. Also, users can define as many as ten sets of calculations. So if different calculations are needed on Invoices and on Purchase Orders, a separate set of calculations can be defined for each.

Maybe the most unique thing about FormCalc is that it works directly on the QuickBooks form, in real time, so users immediately get to see the results of calculations before saving or printing the form. There’s no need for a separate step of exporting the form’s data to do calculations outside of QuickBooks, then re-importing the data again.

What kinds of things are FormCalc users doing with it? They are calculating per-item and total shipping weights for Invoices, totaling estimated labor requirements on job Estimates, calculating board feet for lumber pricing on Invoices, showing prices in two different currencies, totaling invoiced alcohol sales quantities to meet requirements for liquor taxation record keeping, totaling the number of shirts of each size (S, M, L, XL) on an Invoice, and much more.

FormCalc for QuickBooks is priced at $99 for a single-user license, with lower per-license pricing for multi-user licenses. FormCalc is compatible with Microsoft Windows versions of all QuickBooks editions (Simple Start, Basic, Pro, Premier, Enterprise, etc.), and also with all international editions (U.S., UK, Canadian, and Australian).

Via EPR Network
More Accounting press releases