• Home
  • About Us
  • Add-Ins
  • Templates
  • Pricing
  • Contact
  • FAQ
  • Author Archives: Scott Miller

    5 Tips to Decrease Recalc Time

    You may have just a few hundred cells in your Excel sheet that contain =SCOTT functions.  Or you may have 400,000. Yes, we do have a user who has that many!  As your use of the add-in grows, and your sheets become larger, you may experience longer recalculation times.   Here a 5 tips to […]

    Using the add-in with multiple QuickBooks users

    To allow multiple QuickBooks users to be connected via the add-in to the same QuickBooks company (organization), simultaneously, you will need to deploy this workaround.  Please create a new QuickBooks user ID with QuickBooks admin privileges.  Your add-in users will use this ID to connect to QuickBooks from within the add-in. For example, create a […]

    Partner Profile – PennyBooks

    What to do, when off-the-shelf forecasting software doesn’t deliver what your client’s need?  This is the situation U.K based, PennyBooks found themselves in.  Existing Xero marketplace forecasting solutions, either didn’t provide the level of accuracy client’s needed, or required way too much data entry on the client’s part. Enter Scott’s Add-in for Xero.  PennyBooks used […]

    New function: =SCOTT.XTRACKM

    We are pleased to announce the release of a new function:=SCOTT.XTRACKM For those of you that are new to these pages, Scott’s Add-in for Excel and Xero, is a series of new, custom Excel functions that enable users to dynamically sum up Xero general ledger transactions into a single Excel cell. This new function builds […]

    What am I missing

    How to find a missing account code in your spreadsheet. When using our add-in to create financial art, sometimes we may inadvertently omit an account. Here’s a quick tip video on how to find that missing account using the =SCOTT.XRANGE function.

    The P&L is Dead

    Traditional financial reports have lost their appeal (if there ever was any) to entrepreneurs. The P&L and Balance Sheet are artifacts created by the accounting profession, designed to be the main outputs of a double entry accounting system. While well intended, these financial statements don’t satisfy the entrepreneur’s desire for financial information. The business owner, […]