Overview – How to Use Blink Reports Add-On
Blink Reports frees you from manually exporting financial reports from Xero to Excel or Google Spreadsheets. Now you can chart your revenues and expenses and refresh them instantly.
Leverage the flexibility of Google Spreadsheets to securely publish and share dashboards to anyone that update in real time. Only a web browser is required. Embedding a live Google Spreadsheet or Chart into an Intranet web page is a breeze.
The Benefits of Using Google Sheets Add-on
Blink Reports combined with Google Spreadsheets is the ultimate solution for creating reports and dashboards that work on any web browser and any mobile device. iPads, iPhones, plus Android devices can securely open and comment directly on your Google Spreadsheet reports from anywhere at anytime.
Give the boot to static spreadsheet and PDF report file attachments that quickly become out of date. Everyone always sees the same latest figures because only one live version of the report exists on Google Spreadsheets in the cloud!
Blink Reports makes creating a consolidated financial statement supremely easy. You can connect as many or as few Xero organizations as you like and they'll all show up on a single sheet, like this:
View your monthly sales/income figures over the course of the past year:
View a monthly profit and loss report with January to December columns flowing left to right instead of the opposite Xero default:
Generate a profit and loss report with a column for each Xero category:
View a YTD profit/loss report:
View your balance sheet:
See your trial balance:
View your bank account summary:
View your Bank Statements:
Generate financial statement ratios:
Pull your invoice or repeating invoice data directly from Xero and filter by almost anything. Plus generate pivot table reports with ease!
View budget forecasts with the XeroBudget sheet.
View your chart of accounts, which gives you the ability to add account codes to reports for further customization and filtering:
How Does it Work?
Simply enter the formulas below into any cell on a Google sheet copied from one of our template Google sheets:
Balance sheet:
=XeroBAL(ReCalc,CompanyID,From Date,Tracking Category Option 1,Tracking Category Option 2)
Profit and loss:
=XeroPL(ReCalc,CompanyID,From Date,To Date)
Profit and loss, with category tracking:
=XeroPL(ReCalc,CompanyID,FromDate,ToDate,Periods,Timeframe,Category 1,Category Option 1, Category 2, Category Option 2, Standard Layout, Cash Only)
Bank summary:
=XeroBS(ReCalc,CompanyID,From Date,To Date)
Bank statement:
=XeroBankStatement(ReCalc,CompanyID,Account Code,From Date,To Date)
Trial balance:
=XeroTB(ReCalc,CompanyID,From Date,Cash Only)
Budget:
=XeroBudget(ReCalc,CompanyID,From Date,Periods To Compare,Period Size)
Sales or Purchase Invoices:
=XeroInv(ReCalc,CompanyID,Invoice Type,Invoice Status,From Date,To Date,Tracking Category 1,Tracking Option 1,Tracking Category 2,Tracking Option 2,Include Line Items)
Sales or Purchase Repeating Invoices:
=XeroRepeatingInv(ReCalc,CompanyID,Invoice Type,Invoice Status,From Date,To Date,Tracking Category 1,Tracking Option 1,Tracking Category 2,Tracking Option 2,Include Line Items)
Chart of Accounts:
=XeroAccounts(ReCalc,CompanyID)
Index and Match formula(to add account codes to reports):
=if(isna(index(XeroAccounts!$A$4:$A$995,match("AccountName",XeroAccounts!$B$4:$B$995,0))),"",index(XeroAccounts!$A$4:$A$995,match("AccountName",XeroAccounts!$B$4:$B$995,0)))
For example:
=XeroBAL(0,abc0ZdYXW1VefgUhi!jT2S,Date(2013,1,31),"Asia","ProductXYZ")
=XeroPL(0,abc0ZdYXW1VefgUhi!jT2S,Date(2013,1,1),Date(2013,1,31),"Region","Asia")