Question

Where is QB Supplied Template for Importing Excel Bank Account Transactions?

Forum|Forum|6 years ago
May 28, 2020
5 replies
0 views

PLEASE HELP - I desperately need a QB Supplied Spreadsheet Template for Importing Bank Transactions in EXCEL format. I CANNOT FIND THIS TYPE OF QB TEMPLATE. My small bank does not provide QBO files to easily import bank transactions into QB. I have several hundred Checking Account Transactions to Import and 300+ more Credit Card transactions in EXCEL format to Import. I don't want to manually load all of those transactions into QB any more. I have attached a PDF file which includes Page 1-the QB Check Register layout and my EXCEL spreadsheet with the Bank transactions rearranged into the same Column Names and Data (TO MATCH QB). BUT IT WON'T IMPORT! So I Desperately NEED THE QB SUPPLIED TEMPLATE FOR BANK ACCOUNTS. OR In an older version 2007 QB there used to be a method of Matching Up the Excel Spreadsheet Columns with the QB Columns that made Importing possible. IS THAT MATCHING TOOL STILL AVAILABLE? Thanks for all of your Help on this!!! - GK07

QuickBooks Desktop

C

CharleneMaeF

Hello there, @GK07.

I understand the need for you to have a template in importing your bank transactions. However, QuickBooks Desktop is unable to support any. Though, to get your transactions imported, you can check out for a third-party tool.

Also, you may want to consider reconciling your account in QuickBooks Desktop so they'll match your bank and credit card statements.

Please be sure to let me know if there's anything else I can do to help you succeed.

Fiat Lux - ASIA

@GK07

Utilize a 3rd party importer tool.

https:// transactionpro.grsm.io/qbd

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

The templates should be like these

Check

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

NJ

12345

USA

Fuel

25

John's Car

Checking

Sunoco

01/10/2020

100

Monthly Gas

Sunoco

1 Main Street

Newtown

NJ

12345

USA

Fuel

50

Karen's Car

Checking

Michael's Fine Cabinetry

30/09/2020

101

Unitel

12 Smith Ave

Anywhere

NH

22222

USA

Cabinets

10

Cabinets

150

Baker, Chris:Family Room

Y

CC Charge

Credit Card 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

Items Billable

Currency

Exchange Rate

QuickBooks Credit Card

Barnes and Noble

01/09/2020

1

1 Main Street

Anytown

NY

12345

USA

Misc Supplies

100

QuickBooks Credit Card

McDonald's

03/09/2020

2

1 Jones Street

Anytown

NY

12345

USA

Meals

25

ABC Company

Y

QuickBooks Credit Card

Joe's Taxi

05/09/2020

3

1 Felt Ave

Anytown

NY

12345

USA

Transportation

200

BigRedConsulting

To import bank transactions into QB from an Excel worksheet downloaded from your bank, use our BRC IIF Transaction Creator , which will create an IIF file you can import to add transactions, usually checks and deposits, directly to your bank account register.

X

xqnuser

I am in exact same situation, cursing QB and of course there is no help on the weekends.

A

Azoulay Solutions

Hi, I know this reply is late but hopefully it helps others on QBDT:

1. Run a backup

2. Go to: Lists -> Add/Edit Multiple Entries

3. Chose the type of list you'd like to update (Vendors, Customers etc.)

4. Customize the QB columns to match those of the Excel spreadsheet you are copying from

5. Copy from Excel and paste in QBDT.

6. Save