Importing/Transaction/CSV


F

Fernando Sanchez

Hi,
I need some help importing transaction data from my checking account.
I recent upgraded to 2004 and I having difficulties. I used to be
able to import a csv file that consisted of all my transactional data
for checks into quickbook.

However, with the new version, quickbooks wants you to create and/or
map the fields, which I don't know exactly how to do.

Here is the header and one transaction in the file...

!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM MEMO CLEAR TOPRINT
ADDR1 ADDR3
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM MEMO CLEAR QNTY INVITEM
!ENDTRNS
TRNS CHECK 10/1/2003 KEYBANK CUSTOMER NAME -750 1040 N N
SPL CHECK 10/1/2003 Professional Fees:Accounting 750 N
ENDTRNS

I would appreciate it if someone can guide me in mapping the columns
to the fields in quickbooks.

Regards,
Fsanchez
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Importing transaction/quickbooks/csv 0
Import CSV 3
Import CSV 1
cannot import csv 3
Importing .csv files 3
Importing Transaction/QuickBooks 2004/CSV File 0
Import CSV file 1
Import CSV file 1

Top