Blink Reports for Xero Accounting now supports retrieving Bank Statements

We've made viewing your Xero Accounting bank statement details inside Google Spreadsheets simple to do:

=XeroBankStatement(ReCalc,Company ID,Account Code,From Date,To Date)

With access to your bank statements you can better forecast your cash flow.

Test it out now by opening the Blink Reports Template and make a copy to take advantage of the new functionality with your own data.

Blink Reports for Xero Accounting now supports listing the Chart of Accounts

We've made listing your Chart of Accounts inside Google Spreadsheets simple to do:

=XeroAccounts(ReCalc,CompanyID)

With the Chart of Accounts formula, you can use Index and Match formulas to add the account codes to any of your reports.

For any report you want the account codes listed beside the account name, you can paste the following example formula to the left of each account name:

=if(isna(index(XeroAccounts!$A$4:$A$995,match(Account Name,XeroAccounts!$B$4:$B$995,0))),"",index(XeroAccounts!$A$4:$A$995,match(Account Name,XeroAccounts!$B$4:$B$995,0)))

Replace "Account Name" in the formula with the reference to the cell directly beside it, or the location of the account name (example: “Sales”). You can view a live example of this in the "XeroPL" sheet on the template.

Test it out now by opening the Blink Reports Template and make a copy to take advantage of the new functionality with your own data.

Blink Reports for Xero Accounting highlighted in Ben Walker's podcast

Ben Walker has been using Blink Reports for building custom dashboards since 2016. He highlighted the solution on his podcast in October 2016 along with discussing how he's saved his clients over 1 million dollars in taxes.

Check out the full podcast here: http://www.keypersonofinfluence.com/ep-27-disrupting-industry-saw-ben-walker-become-award-winning-entrepreneur/