cancel
Showing results for 
Search instead for 
Did you mean: 
dej-207-
Level 1

Importing Bank Transactions

I am a QB beginner--Is there a way to include the payee of checks in the data that is imported into my QB Pro Desktop?  I can download the QB file from my bank but when I import the file it only shows check number, amount, and date.  I have to manually go in and input the payee and category.  It would be so much easier if I didn't have to go in and manually do this for 1000 checks. Thoughts?

2 Comments 2
Adrian_A
Moderator

Importing Bank Transactions

Hi there, dej-207-.

 

The data that can be imported into QuickBooks Desktop depends on your financial institution. There are some banks that the Payee will be included as long as the name does not exceeds to 32 characters.

 

I recommend reaching out to your bank so you'll be guided on how you can import the transactions together with the name.

 

Once everything's fine, you can check this reference on how to categorize the items: Add and match Bank Feed transactions in QuickBooks Desktop.

 

I'll be around if there's anything that I can help. Keep safe!

Fiat Lux - ASIA
Level 15

Importing Bank Transactions

@dej-207- 

Prepare your 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  
CheckingBell Telephone30/09/2020102 Bell Telephone1 North StreetSuite 100 BostonMA22334USA Telephone18John's Cell             
CheckingBell Telephone30/09/2020102 Bell Telephone1 North StreetSuite 100 BostonMA22334USA Telephone30Karen's Cell             

 

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

 

 

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us