Solved

Enter older bank transactions

Forum|Forum|3 years ago
May 24, 2023
2 replies
0 views

I connected my checking account to QB Online and transactions from 3/1/23 to present imported. I cannot get a .csv file from the bank for transactions older than 60 days. How do I enter the transactions from the Bank Statements manually into QB Online Plus?

QuickBooks Online

Best answer by Kevin_C

Explore MT Online as a workaround.

https://www.moneythumb.com/?ref=110

There's another way, @kathypOCFH. I'd be delighted to lay down the steps to enter your bank transactions into the QuickBooks Online (QBO) program.

Since you cannot upload your bank transactions using a CSV file to QBO, I suggest manually entering your bank transactions one at a time directly into account registers in QBO.

Follow these steps to proceed:

Go to Settings ⚙ and select Chart of accounts.
Find the account register you want to review.
Select View register from the Actions column.
Click the Add check ▼ dropdown menu at the top of the list.
Select the type of transaction you want to add.
Fill out the fields to complete the transaction.
Once done, select Save.

Once everything's good with your transactions, you can visit these resources that will help you to speed up the review process of your online bank transactions:

I'm always around and ready to help if you have more questions about recording your bank transactions in QBO. Click the Reply button to add your comment so I can further assist you. Have a great day!

M

Mich_S

Greetings, @kathypOCFH. I know how you can manually enter transactions from your bank statement into QuickBooks Online.

The data uploaded to QuickBooks is dependent on what your financial institution (FI) provides when linking your bank account. Some share up to the recent 90 days' worth of data.

Follow these steps to add older transactions to your account:

Open the Bookkeeping menu, then click on Transactions.
Hit Bank transactions.
Choose the blue tile for the account to which you want to upload the transactions.
Go to the Link account ▼ dropdown and then hit Upload from file.
Click on Drag and drop or select files and choose the file you downloaded from your bank. Then hit Continue.
Go to the QuickBooks account ▼ dropdown, and choose the account you want to upload the transactions into. Then hit Continue.
Perform the onscreen steps to match the columns on the file with the right fields in QuickBooks. Then hit Continue.
Choose the transactions you would like to import. Then click on Continue.
Hit Yes.
Once transactions are accepted, select Done.

Once everything is uploaded, you can match and categorize your transactions to keep them in order.

Feel free also to read this article to resolve any issues you encounter when uploading: Fix bank upload errors in QuickBooks Online.

You can always reply if you need more help with banking or QuickBooks. Have a good one!

K

kathypOCFHAuthor

Hi Mich

Thanks for the instructions on how to upload a file. I would love to do that. But the only data I have is the paper bank statement. The bank cannot provide a .cvs file for data older than 60 days (in my case January and February 2023). Are you suggesting my only option is to enter the transactions into a spreadsheet and upload that? I was hoping for the ability to enter the data directly into QB online. Thank you. Kathy