Category Archives: Apps for Excel

Analyzing Bank File Conversions XML Data Files using Power Query and PowerPivot

In a previous post, I showed how to use the Bank File Conversions App for Excel 2013 (BFC) to: convert BAI Version 2 and BTRS files, set the data in tables in Excel 2013, add them to the Excel Data Model … Continue reading

Posted in Bank File Conversion, Working With the XML Data | Tagged , , , , | Comments Off on Analyzing Bank File Conversions XML Data Files using Power Query and PowerPivot

Storing Bank File Conversion XML Output in SQL Server

The purpose of this post is to give users (or prospective users) an idea of the benefits of storing their bank data in SQL Server (2005 or greater) as an XML data type. In particular converting BAI and BTRS files … Continue reading

Posted in Apps for Excel, Bank File Conversion, Working With the XML Data | Tagged , , | Comments Off on Storing Bank File Conversion XML Output in SQL Server

Using Bank File Conversion App for Excel with PowerPivot

Bank File Conversion App for Excel 2013 (BFC) is designed with PowerPivot in mind. In fact, the three outputs provided by the conversion (Excel Tables, XML and CSV) are readily imported into PowerPivot for further analysis. This post uses a sample workbook … Continue reading

Posted in Apps for Excel, Bank File Conversion | Tagged , , | Leave a comment

Bank File Conversion App for Excel 2013 Overview Video

A quick overview of the Bank File Conversion App for Excel 2013 allowing BAI V2 and BTRS bank files to be securely converted to Excel tables, CSV text blocks and validated XML.

Posted in Apps for Excel, Bank File Conversion | Tagged , , , , | Leave a comment

New Bank File Conversion App for Excel – Securely Analyze Bank Transaction Data

Automotive Systems Training (AST) has some exciting news to share with all of you who interact with bank data. AST released an App for Excel to the Microsoft Store which was approved last week. You can purchase this app here at an introductory price. … Continue reading

Posted in Apps for Excel, Bank File Conversion | Leave a comment

Bank File Conversion Overview

BAI and BTRS File Conversion – Overview A division of Automotive Systems Training – A Microsoft Partner Application: The Bank File Conversion App for Excel 2013 has been approved as of September 30, 2014. You can get your copy here. … Continue reading

Posted in Apps for Excel, Bank File Conversion | Tagged | Leave a comment