RECALC - Our Blog

Writings, news, and opinions from your friends at Scott’s Add-ins.

How to Automatically Import Quickbooks Data Into Excel

How to Automatically Import Quickbooks Data Into Excel

Need to import Quickbooks into Excel to create bespoke client reports? This article is for you.  For countless accountants and financial analysts, there’s often a familiar roadblock when creating bespoke client reports: the limitations and inefficiencies of traditional financial reporting tools. Picture the all-too-common scenario: hours lost in manual data entry, the frustration of rigid …

How to Automatically Import Quickbooks Data Into Excel Read More »

image with the Xero and Excel platform icons with a question around what's the best app that connects Xero to Excel

Finding The Best App That Connects Xero With Excel

As an accountant, your days are already a juggle between numbers, client meetings, and reviewing Xero data to ensure your clients’ financial records are up to date.  In the midst of all this, you’ve got to send insightful financial reports to your clients–often using Excel to pull accounting data from various sources into one place.  …

Finding The Best App That Connects Xero With Excel Read More »

image showing a quickbooks export to excel via Scott's Add-ins

How to Automate a QuickBooks Export to Excel

Accountants managing multiple clients need to migrate information seamlessly between platforms, and exporting QuickBooks data to Excel is no different.  Yet, the journey from a QuickBooks report to an insightful Excel workbook is often fraught with inefficiencies. The Conventional Approach  Traditionally, exporting reports from QuickBooks involves a manual and often tedious process. You select export …

How to Automate a QuickBooks Export to Excel Read More »

image of showing how to connect Excel to Xero using an add-in

How to Connect Excel to Xero and Enhance Your Accounting Data Workflow

As an accountant, your days are filled with numbers, client meetings, and, let’s face it, significant data management tasks.  Your ability to deliver precise and timely financial reports is not just a service but the core value you offer.  This makes the connection between Microsoft Excel and Xero more than just a convenience–it’s a crucial …

How to Connect Excel to Xero and Enhance Your Accounting Data Workflow Read More »

Xero Multi-currency accounts

The add-in now supports Xero multi-currency accounts. If you use the add-in with a Xero organisation that is setup in Xero as a multi-currency organisation, please read the following to understand some of the nuances of using the add-in to calculate balances for these accounts. We “cache” the transactions for these accounts for an hour. …

Xero Multi-currency accounts Read More »

GLMULTI Power Tips

The following Power Tip comes to us from Scott’s Add-in user and Excel guru, David Clements. David provides insights on how to leverage the =SCOTT.GLMULTI function and Excel.  Thank you, David! The new =SCOTT.GLMULTI function allows multiple account inputs. While this method of selecting individual cells or ranges may be appealing to some, it is …

GLMULTI Power Tips Read More »

New Function GLMULTI

We have added a new function =SCOTT.GLMULTI . This powerful new function allows the user to specify non-consecutive GL accounts. The user can also specify a range in the formula. The syntax is: =SCOTT.GLMULTI (OrgID, StartDate, EndDate, [Accounts], [Accounts],…..) Here is an example: =SCOTT.GLMULTI (A1, A2, A3, B5, B8, B10:B15, B20) Where: A1 = Scotts …

New Function GLMULTI Read More »

Using Wildcards for function =SCOTT.QALL

We have added a new feature to function =SCOTT.QALL . Wildcards are now supported as values for parameters Class, Customer, Department, and Vendor. Wildcards open up all sorts of possibilities for building powerful dashboards to analyze financial results. A wildcard allows you to include ALL transactions for a parameter, regardless of the value of the …

Using Wildcards for function =SCOTT.QALL Read More »