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

How do you import previous purchases and deposits that were made from my personal checking and credit card?

I just started a small construction company and before setting up a business bank account and credit card I was using my personal banking account and credit card. I have a few months worth of purchases and customer payments I would like to add into Quickbooks so they can be accurate and cover all of my business. How do I add these purchases into Quickbooks as well as the customer payments?

 

I would also like to add past estimates, customer deposits, invoices and payments into Quickbooks. Is this possible and how would I go about doing it properly?

 

 

3 Comments 3
MJoy_D
Moderator

How do you import previous purchases and deposits that were made from my personal checking and credit card?

I can help you with adding those transactions to your account, @JWade2.

 

You can add those bank transactions through the WebConnect process. You’ll have to manually download the transactions from the bank. Then, upload the file to your account.

 

Download bank transactions:

 

  1. Go to your online banking account to get your file.
  2. Check or follow your bank’s instructions to get a copy of the data and then save it on your computer.
  3. Ensure that the data range is at least one day before your oldest transaction to avoid duplicates.
  4. Please take note of the supported file format and size. It should be either a Comma-Separated Values (CSV) or a QuickBooks Online (QBO) file. 
  5. Download your transactions and save the file to your desktop.

 

To upload the file to your QuickBooks account: 

 

  1. Go to the Banking menu and select the bank where you’re uploading the transactions from the Banking tab.
  2. Click the Link account drop-down and select Upload from file
  3. On the window that appears, click the Browse button and choose the file that you’ll be downloading. 
  4. Click on Open, then Next.
  5. Follow the onscreen instructions. Match the columns on the file with the banking fields in QuickBooks, then select Next.
  6. Click on Let's go. QuickBooks will now add the transactions to your account.

 

You can also add those past estimates, customer deposits, invoices and payments into QuickBooks. Just check these articles for detailed guidance:

 

Here are some video tutorials that can help you achieve basic tasks in QuickBooks Online: Video tutorials for QuickBooks Online

 

Stay in touch if you have other concerns about adding your past transactions by leaving a reply below. I'm always glad to help in any way I can.​ Have a great rest of the day. 

Fiat Lux - ASIA
Level 15

How do you import previous purchases and deposits that were made from my personal checking and credit card?

@JWade2 

Utilize an importer tool to import many transaction types (e.g Estimate, Invoice + Invoice Payments, Deposit) into your QBO account.

https://transactionpro.grsm.io/qbo

 

JWade2
Level 1

How do you import previous purchases and deposits that were made from my personal checking and credit card?

Would I make a "dummy" bank account and upload deposits in there and another "dummy" credit card account to upload the expense transactions? If this is the case I will always have one account that is negative and one account that is positive?

 

I know how to upload these items, just don't know where to put them, or how to organize it in my chart of accounts since I am not connecting my personal accounts.

 

When I make invoices for the estimates of past transactions, how do I accept payment without duplicating income. Instead of making deposits into a dummy bank account would I just accept the payment of the invoices into the dummy bank account?

 

 

 

Need to get in touch?

Contact us