Changes effective August 1, 2017

Changes Effective August 1, 2017

Effective August 1, 2017, Lincoln Savings Bank will no longer support file exports from our Online Banking system in the Quicken or Quickbooks file formats. Additionally, the “Webconnect” function offered by Intuit which allows the importation of banking data from within the respective applications will no longer be supported. 

Quicken

This will not affect any data that you have previously imported into your systems, and you may continue to use your Intuit software, however, after August 1st, you will need to manually enter your transactions due to limitations for import as outlined by Intuit for their Quicken solution.

Quickbooks

This will not affect any data that you have previously imported into your systems, and you may continue to use your Intuit software, however, after August 1st, you will need to manually enter your transactions, or import a .csv or excel file. Both of these file types are available to export via our online banking platform in the following manner:

  • Log into Online Banking
  • From the dashboard, open the account you desire to export
  • From the account detail screen, use the search functionality to query the transactional range you desire
  • Once the results are returned, select the “Export” drop down located on the right hand side of the secondary header bar.
    Export Transactions from Online Banking
  • Once the file type is selected, your file will begin downloading immediately.   

To Import your data into Quickbooks:

Import bank transactions from Excel CSV file to QuickBooks Online (QBO)
QuickBooks Online now allows users to import their bank transactions via Excel CSV (comma-separated values) files.
To import a .CSV file:

  1. From the left navigation bar, select Transactions > Banking.
  2. Click the Update drop-down.
  3. Select File upload.
  4. Click Browse and select your saved .CSV file. 
  5. Click Next.
  6. From the QuickBooks Account drop-down, select the account to which to import. 
  7. Click Next.
  8. Map your fields according to your .CSV file's format.
  9. Click Next.
  10. Select the transactions to import.
  11. Click Next.
  12. Note: You will receive a notification, stating the number of transactions that will be imported.
  13. Click Yes.
  14. When you get confirmation of the import, click Finish.  You will now be directed to the Downloaded Transactions window, where the imported transactions will appear under the New Transactions tab.

Accepted .CSV template formats:

3 Columns

A B C
Date Description Amount
1/1/2018 Example of a payment -100.00
1/1/2018 Example of a deposit 200.00

4 Columns  

A B C D
Date Description Credit Debit
1/1/2018 Example of a payment 100.00
1/1/2018 Example of a deposit 200.00

Why are we making this change?

Intuit requires that Financial Institutions pay a fee in order to provide the file types available for Quicken or Quickbooks users to import. Unfortunately, as their business model has changed to a online preferred environment, this has meant reduced functionality to bank users and increased fees to the banks. We have made the decision that, as a community bank, we are able to better serve our customer base by investing these dollars into higher quality banking solutions. 

A Better Solution

As we discontinue our support of Intuit’s file types, we are pleased to announce that we will be rolling out our own Personal Financial Management platform in late Q3 2017. Ultimately, we will be delivering a solution that is integrated directly in our online banking system and offers quicker and cleaner categorization of transactions with budgeting functionally. The system will allow tagging and budgeting of transactions in your Lincoln Savings Bank accounts, as well any external accounts that you choose to link.  All at no cost to our customers. Look for additional information in the coming months on our new “PFM” experience. 

Blog and News