An application to put bank transactions into a Google Spreadsheets budget. The application is designed to be used in correlation with the norwegian bank Sbanken, who offer an API, and the this budget created in Google Spreadsheets, along with their API.
The snippet of the budget shown above is where the transactions are placed. The column immediately to the left of each date column is used to hold a unique identifier for the transaction. This will either be a unique id, if made present by the API, or a base64 encoded string of the content of the transaction. In the case of the latter, a count will be done, ensuring that multiple similar transactions will be inserted multiple times.