A. Yes! Scott’s Add-Ins subscriptions are per organisation. Just be sure to purchase a subscription for each QuickBooks or Xero™ organisation you wish to attach to Excel™. Multiple organisations can be accessed from within the same Excel workbook.
Q. How can I see the transactions that comprise the balance I am seeing in a cell?
Transaction detail may be accessed by clicking on the drill icon, found in the add-in task pane.
Q. I am seeing a #VALUE error in one or more cells in my spreadsheet.
A. #VALUE errors result when Excel cannot interpret the data in your formula. Be sure that you are using cell references (ex. B1,C3) for your formula, NOT actual values (ex. 4000, 01/10/2020).
Another common reason for #VALUE errors is from misspelled Tracking Categories / Options that are referenced by =SCOTT functions.
Q. I am seeing a #NAME or _xlduf in one or more of my cells.
A. A #NAME or _xlduf results when the add-in is not loaded. This can be a bit confusing, in that the add-in may still show in Excel.
There are a couple of solutions to resolve this:
Go to My Add-ins in the Insert tab, and double click on Scott’s Add-ins to refresh it. This step usually corrects most problems. You may need to restart Excel for the functions to correct themselves. If this does not solve the problem, we recommend un-installing the add-in, then re-installing.
Q. I am seeing a #BUSY error in one or more of my cells.
A. #BUSY tells the user that Excel is currently recalculating the spreadsheet. Recalculation times are a function of spreadsheet complexity, the amount of =SCOTT functions used in the sheet, and Internet bandwidth. The functions that work the hardest, and take the most time to process, are RANGE functions. Please use these judiciously.
Q. Does the add-in work with Xero ledger accounts affected by multi-currency transactions?
A. The add-in works well with Income Statement accounts affected by multi-currency, but has some limitations for Balance Sheet accounts. A full discussion here.
Q. How do I pull in balances for my Bank accounts?
A. First, be sure that you have assigned an account code to your Bank account. Then be sure to use a Start Date equal to or earlier than the date of your first transaction in your accounting system. Bank accounts are Balance Sheet accounts which calculate their balances by summing transactions from the beginning of time. You can read more here.