cancel
Showing results for 
Search instead for 
Did you mean: 
DDCO
Level 2

CSV Report import from bank scanner

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?

2 Comments 2
Fiat Lux - ASIA
Level 15

CSV Report import from bank scanner

Prepare the Checks data with the following template

Bank AccountPayeeTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerUnit of MeasureItems BillableCurrencyExchange Rate
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel25John's Car             
CheckingSunoco01/10/2020100Monthly GasSunoco1 Main Street  NewtownNJ12345USA Fuel50Karen's Car             
CheckingMichael's Fine Cabinetry30/09/2020101 Unitel12 Smith Ave  AnywhereNH22222USA       Cabinets10Cabinets150 Baker, Chris:Family Room Y  

 

then use one of these importer tools

https://transactionpro.grsm.io/qbd

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

 

 

DDCO
Level 2

CSV Report import from bank scanner

The only option is a 3rd party software?

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us