Overview

This guide will help you extract data from Bank Statements using Butler's OCR APIs in Node.js. In 15 minutes you'll be ready to add Node.js Bank Statement OCR into your product or workflow!

Before getting started, you'll want to make sure to do the following:

Signup for a free Butler account at https://app.butlerlabs.ai
Write down your Butler API key from the Settings menu. Follow the Getting Started guide for more details about how to do that.

Get your API ID

Sign into the Butler product, go to the Library and search for the Bank Statement model:

Click on the Bank Statements card, then press the Create button to create a new Bank Statement model:

Once on the model details page, go to the APIs tab:

Copy the API ID (also known as the Queue ID) and write it down. We'll use it in our code below.

Sample Node.js Bank Statement OCR Code

You can copy and paste the following Node.js sample code to process documents with OCR using the API.

// Import necessary libraries
const axios = require('axios');
const fs = require('fs');
const FormData = require('form-data');

// Specify variables for use in script below
const apiBaseUrl = 'https://app.butlerlabs.ai/api';

// Make sure to add the API Key you wrote down above to the auth headers
const apiKey = 'MY_API_KEY';
const authHeaders = {
  'Authorization': 'Bearer ' + apiKey
};

// Use the Queue API Id you grabbed earlier
const queueId = 'MY_QUEUE_ID';

// Specify the path to the file you would like to process
const localFilePaths = ['/path/to/file'];

// Specify the API URL
const uploadUrl = apiBaseUrl + '/queues/' + queueId + '/uploads';

// This async function uploads the files passed to it and returns the id
// needed for fetching results.
// It is used in our main execution function below
const uploadFiles = async (filePaths) => {
  // Prepare file for upload
  const formData = new FormData();
  filePaths.forEach((filePath) => {
    formData.append('files', fs.createReadStream(filePath));
  });

  // Upload files to the upload API
  console.log('Uploding files to Butler for processing');
  const uploadResponse = await axios.post(
    uploadUrl,
    formData,
    {
      headers: {
        ...authHeaders,
        ...formData.getHeaders(),
      }
    })
    .catch((err) => console.log(err));

  // Return the Upload ID
  return uploadResponse.data.uploadId;
}

// This async function polls every 5 seconds for the extraction results using the
// upload id provided and returns the results once ready
const getExtractionResults = async (uploadId) => {
  // URL to fetch the result
  const extractionResultsUrl = apiBaseUrl + '/queues/' + queueId + '/extraction_results';
  const params = { uploadId };

  // Simple helper function for use while polling on results
  const sleep = (waitTimeInMs) => new Promise(resolve => setTimeout(resolve, waitTimeInMs));

  // Make sure to poll every few seconds for results.
  // For smaller documents this will typically take only a few seconds
  let extractionResults = null;
  while (!extractionResults) {
    console.log('Fetching extraction results');
    const resultApiResponse = await axios.get(
      extractionResultsUrl,
      { headers: { ...authHeaders }, params, }
    );

    const firstDocument = resultApiResponse.data.items[0];
    const extractionStatus = firstDocument.documentStatus;
    // If extraction has not yet completed, sleep for 5 seconds
    if (extractionStatus !== 'Completed') {
      console.log('Extraction still in progress. Sleeping for 5 seconds...');
      await sleep(5 * 1000);
    } else {
      console.log('Extraction results ready');
      return resultApiResponse.data;
    }
  }
}

// Use the main function to run our entire script
const main = async () => {
  // Upload Files
  const uploadId = await uploadFiles(localFilePaths);
  // Get the extraction results
  const extractionResults = await getExtractionResults(uploadId);

  // Print out the extraction results for each document
  extractionResults.items.forEach(documentResult => {
    const fileName = documentResult.fileName;
    console.log('Extraction results from ' + fileName);

    // Print out each field name and extracted value
    console.log('Fields')
    documentResult.formFields.forEach(field => {
      const fieldName = field.fieldName;
      const extractedValue = field.value;

      console.log(fieldName + ' : ' + extractedValue);
    });

    // Print out the results of each table
    console.log('\n\nTables');
    documentResult.tables.forEach(table => {
      console.log('Table name: ' + table.tableName);
      table.rows.forEach((row, idx) => {
        let rowResults = 'Row ' + idx + ': \n';
        row.cells.forEach(cell => {
          // Add each cells name and extracted value to the row results
          rowResults += cell.columnName + ': ' + cell.value + ' \n';
        });

        console.log(rowResults);
      });
    });
  });
}

main();

Make sure to do the following before running the code:

Replace the queueId variable with your API ID
Replace the apiKey variable with your API Key
Replace the localFilePaths variable with your local file location

📘
In-Product Sample Code
You can also copy the sample code directly from the product. This code will have your API ID and API Key already pre-populated for you!

Extracted Bank Statement Fields

Here is an example of what a Bank Statement JSON response looks like:

{
  "documentId": "ab85bc3a-f298-4f6a-931b-3e0396376d93",
  "documentStatus": "Completed",
  "fileName": "BS_2.jpeg",
  "mimeType": "image/jpeg",
  "documentType": "Bank Statements",
  "confidenceScore": "High",
  "formFields": [
    {
      "fieldName": "Account Number",
      "value": "00-123456",
      "confidenceScore": "High"
    },
    {
      "fieldName": "Client Address",
      "value": "100 Pine Street\nMetro, AA 09371",
      "confidenceScore": "High"
    },
    {
      "fieldName": "Client Name",
      "value": "Mary Jane",
      "confidenceScore": "High"
    },
    {
      "fieldName": "Ending Balance",
      "value": "$5,710.87",
      "confidenceScore": "High"
    },
    {
      "fieldName": "Starting Balance",
      "value": "$5,234.09",
      "confidenceScore": "High"
    },
    {
      "fieldName": "Statement End Date",
      "value": "Apr 18, 2010",
      "confidenceScore": "High"
    },
    {
      "fieldName": "Statement Start Date",
      "value": "Mar 15, 2010",
      "confidenceScore": "High"
    }
  ],
  "tables": [
    {
      "tableName": "Transactions",
      "confidenceScore": "Low",
      "rows": [
        {
          "cells": [
            {
              "columnName": "Deposit Amount",
              "value": "272.45",
              "confidenceScore": "High"
            },
            {
              "columnName": "Deposit Date",
              "value": "Apr 8",
              "confidenceScore": "High"
            },
            {
              "columnName": "Deposit Description",
              "value": "",
              "confidenceScore": "Low"
            },
            {
              "columnName": "Withdrawal Amount",
              "value": "",
              "confidenceScore": "Low"
            },
            {
              "columnName": "Withdrawal Date",
              "value": "Apr 8",
              "confidenceScore": "High"
            },
            {
              "columnName": "Withdrawal Description",
              "value": "",
              "confidenceScore": "Low"
            }
          ]
        }
      ]
    }
  ]
}

📘
Full Bank Statement API Response
For more details on each of the fields returned from the Bank Statement API, see the Bank Statement page.