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

Importing transaction data from CSV including accounts

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

6 Comments 6
Fiat Lux - ASIA
Level 15

Importing transaction data from CSV including accounts

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

Matt_Moore
Level 2

Importing transaction data from CSV including accounts

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 15

Importing transaction data from CSV including accounts

Like this one?

TxnDatePrivateNoteCurrencyExchangeRateDepositToAccountEntityLineDescLineAmountAccount
28/07/2020Manual Feed  CheckingJane SmithMonthly Dues25Account1
29/07/2020Manual Feed  CheckingBank of the WestJuly Fees-15Office Expenses
30/07/2020Manual Feed  CheckingStaplesPaper for Copier-50Office Expenses
01/08/2020Manual Feed  CheckingTeddy JonesCharitable Contribution500Account1

 

GlinetteC
Moderator

Importing transaction data from CSV including accounts

I can see how convenient to your business to have a column in Excel for the desired accounts, Matt_Moore.

 

The option to have this in QuickBooks is unavailable. I recommend sending this idea to our product developers. They look through submitted feedback for future updates and use those suggestions to develop changes for the product. 

 

Here's how to do it:

 

  1. Go to the Help menu at the top.
  2. Select Send Feedback Online.
  3. Click Product Suggestion
  4. Click on the drop-down for Type of Feedback and select Product Suggestion.
  5. Select the Product Area.
  6. Enter your thoughts and suggestions.
  7. Click Send Feedback.

 

To be updated with our latest news and updates, including product improvements, I encourage you to visit the What's New section on your QBDT account or open this link to view our product update blogs.

 

You can also check this link: Import and export data in QuickBooks Desktop. This will show you more info on what other data you can export and import into QuickBooks Desktop. 

 

Just drop me a comment below if you have any other questions. I'll be here to help.

Matt_Moore
Level 2

Importing transaction data from CSV including accounts

Thank You,  This is what mine looks like.  I would like to set it up so I could import it into Quickbooks and it would go to the correct account.  That is these would all go to the account 1120 Property (sub account Farm) (sub sub account Maintenance and Materials)   

 

1000 Property

     1100 Farm

          1120 Maintenance and Materials

 

DateDownloaded PayeeAmountAccount Name
9/16/2015Vendor One($66.51)1120 Property:Farm:Maintenance and Materials
9/21/2015Vendor Two($21.90)1120 Property:Farm:Maintenance and Materials
12/14/2015Vendor Three($33.25)1120 Property:Farm:Maintenance and Materials
Fiat Lux - ASIA
Level 15

Importing transaction data from CSV including accounts

You should import the data as Bills

VendorTransaction DateRefNumberBill DueTermsMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableUnit of MeasureAP AccountCurrencyExchange Rate
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone1000Sales Line              
Bell Telephone01/09/2020123#########Net 30Office TelephoneBell Telephone1 Main Street  NewtonNY12345USA Telephone500Service Line              
Ajax Lumber01/09/2020400#########Net 30RepairsAjax Lumber200 Smith Street  AnytownNY11111USA Repairs750Front Door              

Vendor and Ref Number are mandatory

 

and Bill Payments

PayeeTransaction DateApply to Bill RefNumberPayment methodBank AccountCredit Card AccountRefNumberAmountMemoDiscount AmountDiscount AccountDiscount ClassTo Be PrintedExchange Rate
Bell Telephone01/10/2020123CheckChecking 1011500    Y 
Ajax Lumber01/10/2020400CheckChecking 1021500    Y 
Parts R Us01/10/20201200  QuickBooks Credit CardCC185    N 

Payee, Payment Method, Reff Number and Amount are mandatory

 

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

Need to get in touch?

Contact us