QuickBooks Online: upload manual bank transactions from csv or excel
Вставка
- Опубліковано 5 вер 2024
- QuickBooks 30-day free trial + 30% off for 12 months:
quickbooks.int...
Subscribe to all my ADVANCED training for $50/m: hectorgarcia.c...
Call our office 954-414-1524 to setup a private training/consultation about QuickBooks, Excel, Accounting/Bookkeeping, Taxes, and/or General Business Consulting (price starts at $550)
E-mail Hector your questions hector@garciacpa.com
After many searches, your video helped me import transactions. Thanks
great
Thank you, Hector! Your videos always save the day!
:)
Thank you for this detail step by step
Sure, my pleasure!
Thank you so much! Such a helpful video! My bank does not have direct downloads, so I was thinking I was going to have to put it all in manually😱… you saved me lots of time!
;)
Thanks Hector . I am looking for transactions import directly from the bank to qbook
This is the only way with built-in tools
This was a very good explanation...thankyou
:)
Thank you so very much.
:)
Great explanation!
I was able upload one .CSV file for 2019 with no problem. I went to upload 2020 .CSV and I was not allowed to. I later found it had to be less than 1000 lines. I edited the file to 950 lines, and went through the process again. I selected the file, then was brought to the header match screen. When I attempt to match by selecting the drop down arrow, nothing appears.
I have tried it with multiple files and I get the same result.
The first file uploaded with no problem.
Any suggestions?
Thank you!
Your comment was very helpful to me because I was trying to load multiple months into QuickBooks online and it would not work but once I did it month by month it worked just fine, so thank you for that.. 😊
@@priscillaclements8503 I'm happy to hear it! It was a frustrating challenge lol
Did you solve it?
Thanks Hector, Video is great, but I cannot upload, there is error message on the dates
Change the formatting
Thank you sir! You are a wonderful person!
:)
Hi Hector, when creating the Excel file, does each month have to be its own file or are we able to create separate tabs for each month and then upload it all at one time? The client's bank account was closed and they was not able to add the account, nor did they ever export the statements. I'm working off of a physical bank statement and manually adding each transaction. I'm looking for the most efficient and quickest way to get the transactions added. Your expert opinion is greatly appreciated.
Doesn’t need to be separate
Hi Hector, have you done any videos on upload split transaction into quickbooks online from excel?
You need to use an app called Transaction Pro or SaasAnt for that.
The sample deposit file provided by QBO has a column for 'Received From'. However, when uploading the deposit spreadsheet, it doesn't capture that column, and I am therefore forced to manually enter the 'Received From' information for each individual transaction once the transactions are already in quickbooks. This is extremely difficult and time consuming. Am I missing something or is this really as bad as it looks?
Not sure; i have not experienced that
Héctor, not sure if you have covered the following question in another video but here goes: what’s the easiest way to link payments made to a vendor from my credit card or bank feed to a purchase order after adding it via batch entry? I have lots of backed up reconciling for both my bank and Amex account and most purchases hav e purchase orders that I need to link to. When entering them as a bill or credit card transaction, I have to select an account which then doesn’t allow me to select the corresponding purchase order in order to receive the po. Do you have a video covering this?
You have to recieve the PO first into a bill, and THEN you can pay the bill with the CC
Hi Hector. Is it possible to upload the whole GL from another Accounting Software (WAVE) and import it to Quickbooks online with an excel or csv file? Thanks for your help!
Quick answer is NO
Long answer is: with a 3rd party app like SaasAnt, some excel finessing, and 20-30 hours of free time; Yes
@@HectorGarciaCPA OH MY! Who has 20 - 30 hours of free time! LOL. Thanks for responding. It was worth asking. Our client has switched from Wave Accounting to Quickbooks online and I was hoping to be able to transfer the history of the transactions of this fiscal year to QB. I guess I'll start in QB with opening balances next year and finish the statement in WAVE this year. Thank you again for taking the time to respond.
You saved the day! Thank you!
You are welcome!
Thank you Hector, Need help in bank transactions with export to excel . I want to include memo too, how can i include it.
Cant
Thank you for another great video. Your tutorials are so easy to follow, thorough, and get right to the point!
Glad you like them!
But you didnt show how to set up the name of the account so it shows in the drop down menu
Hi Sir. Hope you are doing great. How to undo manually uploaded transactions in QBO.
Cant
Hey, do you have a video explaining how the VBA works for the file?
No
Thank you !!😊
You are welcome
is there a way you can also upload in addition to the the core data in the four columns noted, (date, description, spent/received) columns for an expense account and class?
Nope.
Hi Hector, thank you for the great content. What if the CC you're using cant give you access to connect with quickbooks? where am going to upload the .CSV file ? thank you
download the CSV from the bank... then upload to QB using the instructions in the video
How do I assign accounts to what I upload for example office expense, travel expense etc. Can I do that on the spreadsheet and then load?
You cant… thats all done via bank feeds
Hello Héctor, tks for the vídeo. But i Did the same as you exemple but it not work for me.
Try again.. should be working now
Is there option to delete the uploaded file. I added in wrong account
No… you need to start over
Hello! It seems like all the transactions we upload are only categorized as "Expense" although some of them really are check transactions. Is there a way for us to indicate (in the .csv) that a transaction is a check transaction?
No
Then how do we properly classify transactions under the "spent" column as checks?@@HectorGarciaCPA
Halo im lidia, i wanna ask about import bank transactions, when i upload transaction csv, your file does not contain the three required columns: transaction date, memo and amount, why?
My file? What do you mean?
Question, I am trying to import my monthly csv report from amazon sellers. I have connected my account, but only have access to the past 90 days automatically, so I am trying to manually upload the rest of 2022. Can I use the approach you described in your video or is this only for bank accounts?
This is only for bank accounts.
The e-commerce app in QBO only allows importing those 90 days and thats it
How about removing the uploaded bank statement on quickbooks?
You can delete the account
Once I upload the file, I do not have an option to choose an account. What am I doing wrong?!
Start over.. close and open again.. that’s weird
hello please could you kindly share me csv format to upload manually bank transaction
Is 3 columns: Date, Description, and Amount
Hi Hector! Thank you for this video. Question, how do you add in the bank account balance when you manually import? I see it's listed as 0.00.
Why I can't upload using OFX file to QBO?
Needs to be .QBO file or .CSV
How do you convert a PDF file into a CVS file.
You need an app like MoneyThumb or Propersoft
Hi Hector, thank you for this. Can payment remittances be imported into to quickbooks to match banking deposits received? Also is there a particular format that it will need to be for this to happen? Our company is currently using Quickbooks Online+ and would like to be able to import CSV/Excel generated remittances to match payments received. Can you assist? Thanks so much.
Is they payment remittances a Check? Or electronic payment?
@@HectorGarciaCPA Electronic payments
Hello, Can i stall match thr transactions even it is manually uploaded? Thanks.
Yes…. All the functions are the same
@@HectorGarciaCPA thank you
Thanks for the great video Hector! I'm having an issue with the "Date" column. My files are from PNC and I've chosen the correct date format. The "Column" says a series of random numbers for the description, which is the selection I used when helping it identify which column the date is located in. However, I get the red exclamation (!) point warning when it gives me the list to choose which transactions I want to import. Part of my issue is that it's a .csv, and I'm on Mac so if I edit the file in any way it forces me to save as a "Numbers" file type which QB doesn't recognize. Not sure how to get around this. Tried to upload the .xls file instead but QB doesn't recognize that either. Is there a way to copy/paste the .csv into a .txt file and then import, or is there a better way? Thank you in advance!!
Needs to be CSV file
@@HectorGarciaCPA Yes, I understand that. Iwas able to fix it. It was because the Dates were formatted with Slashed /// instead of dashes--- if you can believe that!! Now I got it imported and every transaction shows as a deposit because there are no minus signs in front of any of the amounts!! Thanks PNC for all the hard work you put into making sure those files are usable!! What a joke. I can't even get into all the ways this bank has failed, but I appreciate you answering me so quickly!!
@@jamphotostudio , should the numbers be without dollar signs? Mine show dollar signs and no minus signs. I will change to put the minus signs in but should I also remove the dollar signs or is it okay to leave them?
how do i make my bank statement a "csv file" first of all.
You would download it as CSV directly from bank, that’s the premise.
If you don’t have access to the bank and all you have is a PDF or printed version. You need a special conversion software such as Money Thumb PDF2QBO
I have videos on that
@@HectorGarciaCPA thanks Hector. I'll try. I do have access to my client's bank.