Entering Bank Transactions manually

You can use MT Online or one of the converter tools (e.g csv2qbo @ $60 one time license)as a workaround.

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

Hello, kcbooks13. 

I checked with my tools and found the same scenario as yours. Before proceeding, may I know the bank to which you're trying to upload the transaction? This will help me check if it's related to the same issue you encountered. 

To successfully import your CSV file, we must follow QuickBooks's file format. I recommend you reimport your CSV file using the correct format. Let me guide you through the process: 
 

1. Go to Transactions, then Bank Transactions.
2. Choose the blue tile for the account you want to upload the transactions into.
3. Tap the Link account ▼ dropdown and then Upload from file.
4. Click Drag and drop or select files and select the file you downloaded from your bank. Then tap Continue.
5. In the QuickBooks account dropdown, hit the account you want to upload the transactions into. Then press Continue.
6. Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Continue.
7. Pick the transactions you would like to import. Then hit Continue.
8. Click Yes.
9. When you accept your transactions, select Done.

I have included several detailed resources about working with transactions that may be useful in the future.
 

• Manually upload transactions into QuickBooks Online
• Categorize and match bank transactions in QuickBooks Online

Once you have categorized your entries, you can reconcile them to ensure that your books are accurate. This simple process can help you identify any discrepancies or errors in your records, allowing you to correct them before they become a more significant issue.

I'm just around the corner to help if you have any other questions besides handling transactions. Don't hesitate to post a reply below. Have a wonderful day!

I have about a year gap in uploaded data. The bank would only go back to Feb 2022. I have previous three years - 2019, 2020 and part of 2021 uploaded. I have all the data in a binder in a month to month recording. We are a small 501C3 group and entering by hand will not be too bad. I just want to know the most efficient way to do this. Any suggestions of the best flow? The chart of accounts are already set up and I shouldn’t have to add anything but I know how to do that.

Thanks for any comments!

kk

Welcome to the QuickBooks Community, KimKeith.

Please know that once your bank only allows you to download the latest 90 days or as far as 24 months of transactions, manually importing them to QuickBooks is the quickest way to display data in the application. Another most efficient way to directly do this in QBO is currently unavailable. However, let me route you to a center where you can achieve your goal in an different way.

I recommend going to the Apps menu to see hundreds of apps you can integrate with QuickBooks. It will help you choose another option for performing the most efficient way to enter or import entries quickly.

Here's how:

1. From the left menu, select Apps.
2. Go to the Find apps tab.
3. Enter the app name in the search bar or select the Browse category dropdown arrow to check out different apps.
4. Once you find the app, choose its tile to see the reviews and pricing.
5. To start the signup process, select Get App Now.
6. Choose your firm or select a client from the Install for Your Client list dropdown menu.
7. Select Install and authorize QuickBooks to share your data with the selected app.
8. Configure any sync preferences and choose Save & Sync.

In case you need steps on how you can review your imported data by matching or adding them to avoid duplicate ones, you can read this article: Categorize online bank transactions in QuickBooks Online.

You can always add a comment below if you have any other concerns about managing bank or credit card entries in QBO. I'm always here to help you further, KimKeith. Take care.

@KimKeith 

I have all the data in a binder in a month to month recording

Do you still have the file in PDF format? Another option, try scanning 1 file to PDF. Then use the trial version of 2qbo Convert Pro as a workaround. If you decide to purchase it, you can get it from a partner + $100 cashback.

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