How do I manually enter transactions into my QuickBooks from bank statements from past years (2019 in my case)?

Hello there, @usermgallardo.

Welcome to QuickBooks Community. I'm happy to help you!

We can use the bank register to manually enter transactions from bank statements to your QuickBooks Online account. 

First, add a new bank account from the Chart of Accounts.

1. Go to the Accounting menu.
2. Within the Chart of Accounts tab, click New.
3. Enter the name of the bank and other required details.
4. Choose when you want to start tracking your finances make sure to enter the correct one. In the Balance field, enter the amount in the account.
5. Once done, hit Save and close.
   

Once done, manually record your bank transactions from 2019:

1. Pick the bank you’re working on. Then, click the link for View Register under the Action column.
   
2. When the Bank Register page opens, navigate to the Date column.
3. Click the dropdown arrow below to select which transaction to enter.
4. For example, Check, Deposit, etc. It will expand the line where you can enter the information. 
5. Once done, hit Save to record it.
   
6. Follow the same process for all entries you want to input in QBO.

Then, here's how to reconcile them:

1. Go to the Gear icon.
2. Select Reconcile. If you're reconciling for the very first time, select Get started to continue.
3. From the Account dropdown arrow, select the account you want to reconcile. Make sure it's the same one on your statement.
4. Follow the on-screen instruction. You can refer to this article to help you in completing the task: Reconcile an account in QuickBooks Online.

After reconciling your account, you can pull up a reconciliation report. It serves as your guide to avoid issues in doing future reconciliations. For more tips and details about reconciliation in QuickBooks Online, please use these resources:

• Learn the reconcile workflow in QuickBooks.
• Review and edit your opening balance if you recently added older transactions to your account.

Reach out to me if you have additional questions about recording transactions and reconciling accounts in QuickBooks Online. I’m here to help and make sure you’re taken care of. Have a great rest of the day.

@usermgallardo 

Do you have the bank statements in PDF or another file format?

I have income on the Bank statement I need to record, will the QB entry in Bank show under Accounts receivable .

On excel sheet

Hi there, esnyman.

You can import the bank statement from an Excel file to QuickBooks. I'm glad to show you the steps.

1. Go to Bookkeeping, then select Bank transactions.
2. Choose the blue tile for the account you want to upload the transactions into.
3. Click the Link account ▼ drop-down, then Upload from file.
4. Select Drag and drop or select files, and click Continue.
5. In the QuickBooks account ▼ drop-down, select the account you want to upload the transactions into, then click Continue.
6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks, then click Continue.
7. Select the transactions you would like to import, then click Continue.
8. Click Yes.
9. When you accept your transactions, select Done.

Also, you can select either the 3-column or 4-column format when importing an Excel file. These are the only columns QuickBooks can handle and this order. Check out this article as your guide: Learn how to check the format of the CSV file you got from your bank to upload transactions to Quick....

About showing transactions to the Accounts Receivable account, that depends on how you categorize the bank transactions. I'm adding this article to learn more about the process: Categorize and match online bank transactions in QBO.

Stay in touch with me if there's anything else I can help you with entering your bank statement. Just leave a comment below and I'll get back to you.