Overview
This PowerShell script is used to enable a user to compare bank account transactions with Xero transactions with the aim of correcting any differences in the Xero account balance (usually as a result of an incorrect reconciliation). The aim is to get the two balances to agree on all dates.
See How To Compare Bank and Xero Account Balances for more information on how to use the script.
Where to Find It
Name of script: ExportBankTransactionsToSQL.ps1
The script is under source control and can be accessed from the following repository:
See the following article which provides an overview, including how to make changes to scripts using git:
How It Works
The script reads the current or reserve Xero account transactions which have been exported to a CSV file, then writes the data to a second SQL table (the name corresponds to the CSV file name) in a SpeakeasyBankTransactions database, which is installed to Azure.
The script then reads the current or reserve RBS bank account transactions which have been exported to an Excel spreadsheet. It then writes the data to an SQL table (the name corresponds to the Excel file name), again to the SpeakeasyBankTransactions database.
The script then executes a SQL stored procedure generate a series of results. These are then presented to the user in a multi-sheet Excel spreadsheet. More information on the data returned in this spreadsheet can be found here:
How To Compare Bank and Xero Account Balances
See Speakeasy SQL Databases for more information on SQL database configurations