Troubleshooting
Solutions for common XO Report errors and issues. Can't find what you need? Contact support.
How XO Report errors work
XO Report uses two distinct error modes depending on the type of problem:
Guidance messages
Plain text strings shown directly in the cell. Used for auth, subscription, and setup issues. These are not caught by IFERROR() — they are intentionally always visible.
Excel errors (#VALUE! / #N/A)
Standard Excel error icons shown when data is invalid or not found. Hover over the cell to see the specific message. These are caught by IFERROR().
Guidance Messages
These messages appear as plain text in the cell. They indicate auth, subscription, or setup issues. IFERROR() will not hide them — this is intentional.
Connect to Xero first. Go to Settings and Connect.Not connected to Xero
Open the XO Report task pane → Settings → Connect to Xero. Sign in when prompted.
Session expired. Go to Settings and Reconnect.Xero session expired
Open Settings → Disconnect All → Connect to Xero to start a fresh session.
No organization selected. Choose one from the dropdown.No organization selected in the task pane
Open the task pane and select an organization from the dropdown at the top.
Subscription required. Open the XO Report task pane to subscribe.No active subscription
Open the XO Report task pane and subscribe to a plan to continue using functions.
Start your free trial in the XO Report task pane.Free trial not yet started
Open the task pane and click Start Free Trial to activate your trial.
Trial ended. Subscribe in the task pane to continue.Free trial has expired
Open the task pane and subscribe to a plan to continue using XO Report.
Excel Errors
Standard Excel error icons appear when data is invalid or not found. Hover over the cell to read the specific message. IFERROR() can handle these.
#VALUE!Organization not found
Hover message: "Organization 'ABC' not found. Check XO.ORG() or Settings."
Verify the Org ID using =XO.ORG(). Check that the organization is still connected in Settings → Organizations.
#VALUE!Account, contact, or item not found
Hover message: "Account '9999' not found in Xero."
Check that the account code, contact name, or item code exists in Xero. Verify spelling matches exactly.
#VALUE!Invalid date format
Hover message: "Invalid date. Use a cell reference containing a date."
Use cell references or the DATE() function. String dates like "2025-01-01" are rejected.
#VALUE!Tracking option not found
Hover message: "Tracking option not found."
Verify the tracking category and option names match exactly as shown in Xero — check spelling and capitalization.
#N/AGeneral or unexpected error
Hover message: Error message from Xero API
Hover over the cell to read the specific error message. Try refreshing data or reconnecting. Check the Xero status page for outages.
Common Issues
Table won't refresh
Make sure your cursor is inside the table. The Refresh button is context-aware.
Missing data in table
Verify the date range covers the period you need. Check status filters are not too restrictive.
Slow loading
Use narrower date ranges. Large date ranges fetch more data and take longer.
Duplicate rows
Check if multiple organizations are selected. Each org's data is combined into one table.
Custom column formulas lost
Make sure the formula is in the first row of the custom column. This formula is used as the template for all rows on refresh.
Report looks different from Xero
XO Report uses Xero's standard layout format for consistency. Account groupings may differ from customized Xero reports.
Add-in not appearing
Go to Insert → Add-ins → My Add-ins and check if XO Report is installed. Try removing and reinstalling from AppSource.
Connection keeps disconnecting
Try disconnecting all organizations and reconnecting. Open Settings → Disconnect All → Connect to Xero.
#NAME? error in formula
Check spelling of the function name — it must start with "XO." Try clicking Refresh All in the task pane. Make sure the add-in is installed and loaded.
Date Handling Best Practices
For the most reliable results, always use cell references containing dates rather than typed date strings.
=XO.BALANCE(A2, "4000", B1, C1)where B1, C1 contain dates=XO.BALANCE(A2, "4000", DATE(2025,1,1), DATE(2025,12,31))DATE() function works=XO.BALANCE(A2, "4000", "2025-01-01", ...)String dates are rejectedStale Data
XO Report caches reference data locally for 5 minutes to reduce API calls and improve performance. If data appears stale or missing recent changes from Xero:
Open the task pane → Settings → Data → Refresh Data to clear the cache and fetch the latest data from Xero.
Getting Help
XO Report includes built-in diagnostic tools to help support investigate issues quickly.
Enable Debug Mode
Open the task pane → Settings → Advanced → Enable Debug Mode. Captures detailed logs including API requests, cache events, errors, and system info. Resets to OFF each time you restart Excel.
Download Diagnostics
Settings → Advanced → Download Diagnostics. Downloads a .txt file with system info, connected organizations, error log, and debug log. Email the file to support@xo-report.com. No passwords or tokens are included.
Report Issue
Settings → Advanced → Report Issue. Sends an error report directly to support with recent debug logs, system info, and your user ID. No passwords, tokens, or financial data are included.
Auto-Send Error Reports
Enabled by default. Toggle in Settings → Advanced. Automatically sends error reports when problems occur. The same privacy protections apply — no passwords, tokens, or financial data.
Still Need Help?
If you can't find a solution here, please contact our support team. Include a diagnostics file (Settings → Advanced → Download Diagnostics) to speed up resolution.
Contact Support