How To Import Transactions From Excel Into QuickBooks Online
ฝัง
- เผยแพร่เมื่อ 7 ส.ค. 2024
- In this QuickBooks Tutorial you will learn how to import bank transactions from Excel into Quickbooks Online
Contact Rachel for one-on-one assistance:
www.gentlefrog.com/meeting/
Are you a small business owner struggling to make sense of your QuickBooks data? Sign up for my FREE Review Your QuickBooks Mini-course and learn how to keep your QuickBooks accurate, up-to-date, and free from costly errors: courses.gentlefrog.com/review...
Try QuickBooks Online for free for 30 days:
bit.ly/3gXpv3b
Already know you want QuickBooks Online? Buy now and save 30% on your first 12 months:
intuit.me/3gZ0q85
Connect with Rachel on Facebook:
/ gentlefrogllc
Check our reviews:
proadvisor.intuit.com/app/acc...
www.yelp.com/biz/gentle-frog-...
www.gentlefrog.com/reviews/
Timestamps:
0:00 - Intro
00:20 - What you'll learn
00:45 - Example using sample company file
00:58 - Excel file example
01:20 - Save Excel file as CSV
01:33 - Bank accounts
01:53 - Upload CSV into QuickBooks Online
02:44 - Mapping imported CSV file to QuickBooks Account
04:25 - Double-checking transactions for import
04:53 - Accepting transactions
#quickbooksonline #bookkeeping #quickbookstutorial
This content is for information purposes only and should not be considered legal, accounting, or tax advice, or a substitute for obtaining such advice specific to your business. Additional information and exceptions may apply. Applicable laws may vary by state or locality. No assurance is given that the information is comprehensive in its coverage or that it is suitable in dealing with a customer’s particular situation. Gentle Frog, LLC does not have any responsibility for updating or revising any information presented herein. Accordingly, the information provided should not be relied upon as a substitute for independent research. Gentle Frog, LLC does not warrant that the material contained herein will continue to be accurate, nor that it is completely free of errors when published. Readers and viewers should verify statements before relying on them.
Please let me know if you have any questions about QuickBooks and Excel integration
Hi Rachel, do you have a recommendation for importing sales transactions into QB from Square? QB provides a free connector but the reviews are really bad and I'm afraid to use it. Thx!
@@sapoland If you're testing ideas, I recommend taking a backup first (www.rewind.io). The Square connector sometimes works and sometimes it's goofy, in my experience, it's very case by case.
Good detail-all I need to import excel into QBO. Thank you!
Thanks!
Wow wow wow I finally got this thanks u so much mam you saved my new year holidays. Advance happy new year 2022🎄🎂🎊🎉💐
I'm so glad to hear this video helped you ou. Happy New Year to you too Surya!
Thank you!
You're welcome! ~Rachel
This is awesome info. Can I use this to import payroll from an outside company? I use Southland processing.
Technically, yes, but it's NOT the way I'd do it. This will upload the amount into bank feeds then someone will have to to allocate it. That someone will need to split the expense among many categories (accounts). Personally, I'd pull my hair out doing it this way. I prefer using journal entries.
I have a training demo video showing how to do a journal entry for payroll: th-cam.com/video/sA2MO-VAQvg/w-d-xo.html
Hi Rachel, Thank you so much for this information. Could you also assign those transactions you downloaded to the checking account, even though the transactions were done using a personal cc? Thank you!
Yes! When you upload an excel doc, QuickBooks doesn't know what the account type was to begin with. You get to pick the account you want to link the data to, be it checking/credit card. Easy peasy.
@@GentleFrog So, let's say that the person had a personal account ( that she was using for both personal and business transactions) before setting up QuickBooks, and now she just set up QB and has a business checking account that is connected to QB. But she wants to include the transactions done before (with her personal account). So All she has to do is create a new bank account (should I name personal checking?) and import the way you explain in the video to this account? And shouldn't I remove this bank account at some point cause she no longer uses it? when and how should I do that?
Thank you so much!
@@naganha3873 If you'd like to go over this with me you can schedule a 30-minute meeting and we can figure out what will work best in this situation: www.gentlefrog.com/meeting/
Hi Rachel, I want to update my chart of accounts numbers for my next financial year. is there a way to mass-update all the journal entries of my current financial year with the new account numbers ? Thanks for your video !
When the account numbers are updated, they're updated. You don't get to change them for a specific year. Imagine an excel doc with a column for numbers. It's like that.
@@GentleFrog I'm considering reducing the number of accounts used. For example, I have 5 financial fees GL at the moment and my future COA will only have one. Therefore, I can't simply update the GL number, I would need to map all 5 Financial fees GL to the new one. Since the volume of transactions is important, I don't want to update each line of transactions one by one - that's why I was wondering if I could :
1- Extract all the journal entries of FY 2022-23
2- in an excel, update the old GL # with the new ones.
3- mass upload the updated JEs in Quickbooks
@@etiennefournier7402 You can book a 15-minute meeting and we can strategize about the pros/cons/options for doing this: www.gentlefrog.com/meeting/
when i download a CSV file from the bank, can we delete rows and columns within excel before importing? Also, when I do import the file does it overwrite whats already in the review folder within QBO, or simply add these ADDITIONAL transactions to the review folder? I need to import about 3 months worth of bank info that did not automatically download into QBO, while not messing up whats currently in the review folder. Please help....LOL..I dont want to mess up my bank transactions currently in the review folder.
You can and should delete stuff before the import, often there are merged rows in the header/footer and that prevents the import which is nice and frustrating (for me at least).
I shouldn't overwrite what is pending in the for review folder, I've never seen that happen. It should ignore those and not double enter them. BUT you can sort by date or amount order and quickly see if they're doubled up. If they are, you can carefully batch delete.
You could also add your pending stuff in for-review and then add the missing 3 months.
One more thought -- if you are worried you might really screw things up, get Rewind.io, it's a backup software for QuickBooks Online. I use it for a couple of clients where we are either experimenting or there is a ton of work that goes into the file and I just want a back up for peace of mind. It's super easy to use.
CAN YOU PLEASE MAKE A VIDEO ON HOW TO IMPORT PAYCHEX BI-WEEKLY REPORT TO QB ONLINE. I need to import the report to the GL
Hi Rosa, that's not a video I'd make as it would require confidential information. You can reach out to Paychex support: www.paychex.com/support
Hello, please let me know how to import the Gl transactions report from Paychex to QB online bi-weekly
Hi Rosa, I don't work with Paychex so this is something that I can't explain. Please reach out to Paychex directly for help with this www.paychex.com/support
Does this work the same if you are importing CC transactions?
Yes, this works if you are importing CC transactions.
Do I need to be in Admin to upload?
Hi Leticia, you don't necessarily have to be an admin. There are various permission levels in QuickBooks. Try uploading and see if it works. If it doesn't then you will need different permissions on your account.
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?
Hi Lidia, do you have those three required columns in your CSV file? Without seeing the file I can't say what might be going on here. If you'd like you can schedule a 15 minute meeting and I can take a look and see: www.gentlefrog.com/meeting/
Hi Rachel, how do the imported Excel data leave the to do list to become part of the account?
The same way you transactions that are imported directly from your bank leave your to-do list. You review them and either add them, match them with an existing transaction or mark them as a transfer. Here's a video that shows you that process: th-cam.com/video/AoN1NpzT5yw/w-d-xo.html
@@GentleFrog Thank you