cancel
Showing results for 
Search instead for 
Did you mean: 
tiztriickz
Level 1

Looking for help entering past transactions

I have just recently started to do all my book keeping with QuickBooks rather than an excel sheet.... And I am trying to find a way to enter in all my previous sales/purchases from the last 1-2 years. Many of those purchases/sales were linked to a different bank account so I am worried if I try and add it, it will make my records look very off. 
- Would I just create a "dummy bank account" and then assign all the purchases/sales there? 

1 Comment 1
JenoP
Moderator

Looking for help entering past transactions

You can create multiple bank accounts in QBO to mirror where the actual transactions are posted, tiztriickz.

 

Then, import a CSV file of your banking transactions into the respective accounts. Here's how:

 

  1. Go to your bank or credit card’s website and log in to your account.
  2. Every financial institution has different steps. Follow their instructions on how to download the transactions to your computer. Some banks call this WebConnect. Here are steps for Bank of AmericaChase, and Wells Fargo.
  3. Save the file somewhere you can easily find it, like your desktop.

One you have the file saved in your computer, follow these steps on how to import it:

 

  1. Go to the Banking or Transactions menu and select Banking.
  2. Click Upload transactions manually. You can also begin your upload from the Import Data page (Go to Settings ⚙, look for Import Data, and then select Bank Data).
  3. Select Browse and choose the file you downloaded from your bank.
  4. Click Open, then select Next.
  5. From the QuickBooks Account drop-down list, select the bank account, and then click Next.
  6. Select a Datedate formatDescription, and AmountNote: You can choose 1 column or 2 columns.
  7. Click Next, then select the check boxes of the transactions that you want to import, and then select Next.
  8. Select Yes
  9. Select Let's go! when the Import completed notification appears.

After importing them successfully, you can follow the steps in this article on how you can categorize them: Categorize And Match Online Bank Transactions In QuickBooks Online

 

Let me know if you need anything else. 

 

upload.PNG

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

Need to get in touch?

Contact us