Hours

Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST

Question

CSV Report import from bank scanner

Forum|Forum|4 years ago
January 28, 2022
1 reply
1 view

We got a bank check deposit scanner and it has an option to export a csv file of the checks. Is there a way to import this information into Quickbooks Enterprise to be used in a useful way?

QuickBooks Enterprise Suite

Fiat Lux - ASIA

Level 14

Prepare the Checks data with the following template

Bank Account

Payee

Transaction Date

RefNumber

Memo

Address Line1

Address Line2

Address Line3

Address Line4

Address City

Address State

Address PostalCode

Address Country

Vendor Acct No

Expenses Account

Expenses Amount

Expenses Memo

Expenses Class

Expenses Customer

Expenses Billable

Items Item

Items Qty

Items Description

Items Cost

Items Class

Items Customer

Unit of Measure

Items Billable

Currency

Exchange Rate

Checking

Sunoco

01/10/2020

100

Monthly Gas

Sunoco

1 Main Street

Newtown

12345

USA

Fuel

John's Car

Checking

Sunoco

01/10/2020

100

Monthly Gas

Sunoco

1 Main Street

Newtown

12345

USA

Fuel

Karen's Car

Checking

Michael's Fine Cabinetry

30/09/2020

101

Unitel

12 Smith Ave

Anywhere

22222

USA

Cabinets

150

Baker, Chris:Family Room

then use one of these importer tools

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

DDCOAuthor

The only option is a 3rd party software?

Sign up

Login with SSO

Let's get you signed in

Login with SSO

Scanning file for viruses.

This file cannot be downloaded