Skip to main content
K
kcbooks13
January 15, 2024
Question

Entering Bank Transactions manually

  • January 15, 2024
  • 2 replies
  • 0 views

My bank feed was not synced to my Quickbooks Online account from May-Sept of 2023 so I had to manually enter all my bank transactions for this period (I was unable to get CSV files for import from my bank and was unable to convert bank statements to files for import - tried multiple ways with no luck). The only way to manually enter transactions that I could find was to add them to my bank register in my Chart of Accounts (https://quickbooks.intuit.com/learn-support/en-us/banking/how-to-enter-manual-bank-transactions/01/1344518#M105191). I did this and now need the transactions to be synced/added to my Quickbooks bank feed/transaction history. Any advice on how to go about this or a work-around for manual transaction entry?

2 replies

4
4Gal
January 15, 2024

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

 

 

A
AileneA
January 15, 2024

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.
 

 

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!

K
KimKeith
February 29, 2024

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

C
ChristieAnn 11
February 29, 2024

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.

Terms & ConditionsAccessibility statement