Importing transaction data from CSV including accounts

Forum|Forum|3 years ago
October 11, 2022
1 reply
10 views

Good Morning,

I am going back and importing historical data into a new (to be created) quickbooks file.

I am organizing all of this data in Excel and have just over 5,000 rows. I would like to get all this organized, including Payee, Date, Amount and Account. I have figured out how to go from PDF to CSV to QBO using 2qbo convert software. This will require me to make very many "rules" in Quickbooks.

Does anyone have recommendations for a way to have a column in Excel of the desired accounts and then just do a simple import rather than having to create so many individual rules? Or any other ways to solve this problem?

Thanks so much.

Matt

QuickBooks Desktop

Fiat Lux - ASIA

Level 14

What type of transaction do you need to import? Credit card charge, credit card credit or else?

Matt_MooreAuthor

The transactions are from my Chase bank account which has the fields Date, Payee and Amount.

I am going through and organizing this data and would like to assign an account to each transaction the import it. That is I would like to map account in Excel to account in Quickbooks and them import the data and be done. Going though and setting up a couple of hundred import "rules" is something I would have to do if I convert to a QBO file then import that.

Thanks,

Matt

Fiat Lux - ASIA

Level 14

Like this one?

TxnDate	PrivateNote	Currency	ExchangeRate	DepositToAccount	Entity	LineDesc	LineAmount	Account
28/07/2020	Manual Feed			Checking	Jane Smith	Monthly Dues	25	Account1
29/07/2020	Manual Feed			Checking	Bank of the West	July Fees	-15	Office Expenses
30/07/2020	Manual Feed			Checking	Staples	Paper for Copier	-50	Office Expenses
01/08/2020	Manual Feed			Checking	Teddy Jones	Charitable Contribution	500	Account1

Sign up

Login with SSO

Let's get you signed in

Login with SSO