- 466
- 795 526
Gentle Frog
United States
Приєднався 9 жов 2018
Gentle Frog offers training for QuickBooks as well as bookkeeping services for small business owners in the US and Canada. I help DIY business owners understand how to manage their bookkeeping and provide a “safety net” by making myself available to answer questions and guidance about bookkeeping and QuickBooks software.
How to Export Reports from QuickBooks to Excel: Classic vs. Modern View
In this video, learn how to export reports like the Profit and Loss, Balance Sheet, and more from QuickBooks Online to Excel. Whether you're working with the classic view or the modern view, I'll walk you through instructions to customize your date range, apply filters, and get the data you need.
Discover the key differences between exporting from the classic and modern report views, and see how each format looks in Excel.
Key Topics Covered:
▪️Exporting reports via the Tools menu
▪️Exporting specific date ranges and filters
▪️Comparing Classic and Modern report views in Excel
Streamline your QuickBooks workflow and master exporting reports with ease!
📌 If this tutorial helps you, don't forget to like, comment, and subscribe for more QuickBooks tips and tutorials!
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-your-quickbooks
☕ If you found this video helpful you can say "thanks" by buying me a coffee...
www.buymeacoffee.com/gentlefrog
Connect with Rachel on Facebook:
gentlefrogllc/
Join Gentle Frog's Bookkeeping Lily Pad - Community Group: groups/1620775105117880
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
Check our reviews: www.gentlefrog.com/reviews/
Timestamps
00:00 - Intro
00:26 - Export data shortcut
00:54 - Profit and Loss
01:28 - Export specific date range
02:10 - Export modern view
02:35 - Exported modern view P&L
02:51 - Exported classic view P&L
03:20 - Outro
#quickbooksonline #qbo
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.
Discover the key differences between exporting from the classic and modern report views, and see how each format looks in Excel.
Key Topics Covered:
▪️Exporting reports via the Tools menu
▪️Exporting specific date ranges and filters
▪️Comparing Classic and Modern report views in Excel
Streamline your QuickBooks workflow and master exporting reports with ease!
📌 If this tutorial helps you, don't forget to like, comment, and subscribe for more QuickBooks tips and tutorials!
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-your-quickbooks
☕ If you found this video helpful you can say "thanks" by buying me a coffee...
www.buymeacoffee.com/gentlefrog
Connect with Rachel on Facebook:
gentlefrogllc/
Join Gentle Frog's Bookkeeping Lily Pad - Community Group: groups/1620775105117880
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
Check our reviews: www.gentlefrog.com/reviews/
Timestamps
00:00 - Intro
00:26 - Export data shortcut
00:54 - Profit and Loss
01:28 - Export specific date range
02:10 - Export modern view
02:35 - Exported modern view P&L
02:51 - Exported classic view P&L
03:20 - Outro
#quickbooksonline #qbo
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.
Переглядів: 38
Відео
How to Export Lists and Data from QuickBooks Online to Excel
Переглядів 5612 годин тому
In this video, I’ll show you step-by-step how to export data and lists from QuickBooks Online to Excel. Whether you’re transitioning to different software, need to analyze data in Excel, or simply prefer working in spreadsheets, this guide has you covered. What You’ll Learn: ▪️How to export customer, vendor, and employee lists ▪️Tips for exporting your Chart of Accounts to Excel ▪️How to access...
QuickBooks Update: Tags Discontinued in 2025 - What You Need to Know
Переглядів 9321 годину тому
QuickBooks is retiring its Tags feature on March 8, 2025, as announced in an email from Intuit dated December 18, 2024. In this video, I explain what this means for users and what’s replacing it: Custom Fields. Here’s a breakdown of what’s coming: ▪️Simple Start Plan: 1 custom field ▪️Essentials Plan: 4 custom fields ▪️Plus Plan: 4 custom fields ▪️Advanced Plan: 12 custom fields If you're curre...
How to Record Deposits with Fees in QuickBooks Online (Stripe, Square, etc.)
Переглядів 141День тому
In this video, I walk you through how to record deposits in QuickBooks Online when fees are deducted before the money reaches your bank account. Whether you're using Stripe, Square, or another credit card processor, this step-by-step guide will help you accurately log income, fees, and deposits for clean and consistent bookkeeping. You'll learn: ▪️How to use the "Bank Deposit" screen in QuickBo...
How to Record Stripe Deposits with Fees in QuickBooks Online
Переглядів 19114 днів тому
In this video, I walk you through how to record deposits from Stripe in QuickBooks Online when fees are deducted. If you’re handling transactions where Stripe processes payments and takes a fee off the top, this tutorial will ensure your bookkeeping stays accurate. You’ll learn how to: ▪️Break down the deposit details in Stripe to record income, refunds, and fees. ▪️Manually create a bank depos...
QuickBooks Online Accounts Payable Aging Summary: How to Track and Manage Bills
Переглядів 6714 днів тому
In this video, I’ll walk you through the Accounts Payable Aging Summary report in QuickBooks Online. This report is essential for tracking outstanding bills, identifying overdue payments, and managing vendor balances effectively. Here’s what you’ll learn: ▪️How to find the Accounts Payable Aging Summary report ▪️What the columns mean and how to interpret overdue bills ▪️How to click through for...
How to Merge Reconciled Bank Accounts in QuickBooks Online: Step-by-Step Demo
Переглядів 10921 день тому
Merging two bank accounts in QuickBooks Online-especially reconciled accounts-can lead to unexpected results if you're not prepared. In this video, I’ll walk you through what happens when two reconciled accounts are combined, so you can make an informed decision before proceeding. Using an example with two accounts I’ll show: 1️⃣ How to merge accounts step-by-step 2️⃣ What happens to reconcilia...
How to Enable Blue Account Cards in QuickBooks Online's Bank Transactions Screen
Переглядів 5621 день тому
In this video, I’ll show you how to enable the blue account cards on your Bank Transactions screen in QuickBooks Online. If you’re wondering why your Bank Transactions screen looks different from others you’ve seen online, it might be because the account cards view is turned off. This quick tip is perfect for anyone who wants to make navigating the banking screen easier and more intuitive. If y...
QuickBooks Payroll Alert: Important Update on Payroll Tax Changes
Переглядів 13928 днів тому
If you've seen an alert in QuickBooks prompting you to take action about upcoming changes to payroll but aren’t sure what to do next, this guide will help you locate and address the issue. I'll show you how to find the correct email from Intuit with details about affected clients. Payroll users: Don’t let this urgent update slip through the cracks. This video highlights exactly what to look for...
QuickBooks Help: How to Delete an Incorrectly Uploaded Bank Statement
Переглядів 111Місяць тому
In this QuickBooks tutorial, learn how to delete a PDF that you accidentally uploaded instead of a bank statement. Mistakes happen, and if you've uploaded the wrong file, this video will guide you through the steps to remove it from your reconciliation screen. We'll cover: - Accessing the reconciliation history - Locating attachments in QuickBooks Online - Removing an unwanted PDF with just a f...
Understanding Open Balance vs. Overdue Payment in QuickBooks: Quick Guide
Переглядів 123Місяць тому
Ever noticed a customer profile in QuickBooks Online showing different amounts for an open balance and an overdue payment? In this video, I explain what these terms mean and how to interpret these numbers accurately. Using a simple example, I break down why you might see an open balance that doesn’t match the overdue amount and how QuickBooks tracks these figures based on invoice due dates. You...
How to Record an NSF Payment in QuickBooks Online | Correcting Returned Checks
Переглядів 205Місяць тому
In this QuickBooks tutorial, I walk you through the steps to accurately record a returned or NSF (non-sufficient funds) payment, including how to remove a previously recorded refund receipt. Whether your client’s check bounced or they used an incorrect payment method, I’ll show you how to adjust your records properly so that the invoice remains outstanding in QuickBooks. You'll learn how to: 1....
Why NOT to Use a Refund Receipt for NSF Checks in QuickBooks Online
Переглядів 71Місяць тому
In this video, I explain why using a refund receipt for an NSF (non-sufficient funds) check or incorrect payment method in QuickBooks is not the best approach. When a customer payment bounces or an incorrect card is used, issuing a refund receipt can lead to accounting inaccuracies in your profit and loss statement. Instead of reflecting the actual situation - where the client still owes you mo...
How to Fix Duplicate Bill and Expense Entries in QuickBooks Online
Переглядів 207Місяць тому
In this video, I'll walk you through the steps to resolve a common QuickBooks issue: duplicate entries for a bill and expense of the same amount. If you notice that a bill and an expense show up separately in your records, it may be due to a payment miss entry. This results in an inaccurate view of your accounts payable and a confusing vendor balance. I’ll start by showing you a quick fix: link...
How to Add and Edit a Receipt in QuickBooks Online Uploaded With the Mobile App
Переглядів 107Місяць тому
How to Add and Edit a Receipt in QuickBooks Online Uploaded With the Mobile App
How to Edit Report Section Titles in QuickBooks Online
Переглядів 69Місяць тому
How to Edit Report Section Titles in QuickBooks Online
How to Add Notes to Financial Reports in QuickBooks Online
Переглядів 114Місяць тому
How to Add Notes to Financial Reports in QuickBooks Online
QuickBooks Help: How to Clean Up Unreconciled Transactions from Previous Years (Part 2)
Переглядів 3752 місяці тому
QuickBooks Help: How to Clean Up Unreconciled Transactions from Previous Years (Part 2)
QuickBooks Help: How to Clean Up Unreconciled Transactions from Previous Years (Part 1)
Переглядів 3742 місяці тому
QuickBooks Help: How to Clean Up Unreconciled Transactions from Previous Years (Part 1)
How to Remove an Incomplete Bank Reconciliation in QuickBooks Online Accountant
Переглядів 1592 місяці тому
How to Remove an Incomplete Bank Reconciliation in QuickBooks Online Accountant
Why Does My Account Have a Balance When the Bank Register is Empty - QuickBooks Online
Переглядів 752 місяці тому
Why Does My Account Have a Balance When the Bank Register is Empty - QuickBooks Online
How to Transfer the Primary Admin Role in QuickBooks Online When the Usual Method Fails
Переглядів 2172 місяці тому
How to Transfer the Primary Admin Role in QuickBooks Online When the Usual Method Fails
Why Undeposited Funds Appear in Your Bank Register in QuickBooks Online
Переглядів 1262 місяці тому
Why Undeposited Funds Appear in Your Bank Register in QuickBooks Online
How To Remove Transactions From Undeposited Funds in QuickBooks Online
Переглядів 1052 місяці тому
How To Remove Transactions From Undeposited Funds in QuickBooks Online
QuickBooks Update: New Payment Option for Invoices Without Payments Enabled (October 2024)
Переглядів 1782 місяці тому
QuickBooks Update: New Payment Option for Invoices Without Payments Enabled (October 2024)
How Transactions End Up in QuickBooks Online's Undeposited Funds
Переглядів 1512 місяці тому
How Transactions End Up in QuickBooks Online's Undeposited Funds
How to Find Undeposited Funds in QuickBooks Online
Переглядів 1603 місяці тому
How to Find Undeposited Funds in QuickBooks Online
What Are Undeposited Funds in QuickBooks Online
Переглядів 1493 місяці тому
What Are Undeposited Funds in QuickBooks Online
How to Manage Incorrect Vendor Name Suggestions in QuickBooks Online with Bank Rules
Переглядів 1263 місяці тому
How to Manage Incorrect Vendor Name Suggestions in QuickBooks Online with Bank Rules
Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import
Переглядів 783 місяці тому
Testing SupaClerk Bank Statement Conversion to CSV for QuickBooks Online Import
Hi Rachel, I'm familiar with your training through the 60 day program. I would like to know if you offer mentorship. I feel your way of doing quickbooks is more my style. What is the best way to talk with you?
I don't have a structured mentorship program but I'm always up to create something custom. You can send me an email, rachel@gentlefrog.com, or book a free discovery call, www.gentlefrog.com/discovery-call/, (my calendar is pretty sparse right now) to discuss your needs.
I have QB desktop! Do you have this video for desktop users?? I really need it 😢
In the video I use a Journal Entry to record the Payroll data. I would do it the same way in Desktop.
Will this still work now that Intuit is not supporting QB Desktop Pro?
If you have a valid subscription, yes. If you don't have a valid subscription I'm not sure but you can test it.
Very nice video. I’m actually trying to find a way to delete my account on tax 99. Is this possible? Thanks in advance.
That would be a question for Tax1099 support: zenwork.my.site.com/SupportTax1099/s/
Very useful vid. Thank you
You're welcome! I'm so glad you found it useful.
when or why would i give someone primary admin role? right now I am as primary and I added my acct as company admin, in what case would it be helpful or why would i switch it. Was trying to figure out the difference and found your video
If you, the business owner, are the primary admin there's really no reason for you to ever have to do this. This for Accountant Users who will often create the QuickBooks account/file for a client making them the primary admin, and then at some point need to transfer the account to the client.
Rachel, Will track1099 site do a 1098 , and on here is the "payer" that would be the one re- paying interest( hard money loan) and the receiver would be the one getting the interest from the loan I gave them from a mortgage.
Track1099 has a list of forms they do and various 1098's are on the list. I'm not a CPA and do not give any advice related to filling out tax forms.
how do I request this invoice if i don't want it to be in accounts receivable?
I don't understand the question. Can you give me some information on what you're trying to accomplish?
In my QuickBooks setup, the screen for entering transactions manually comes up at the bottom of the screen instead of at the top. What should I do so that it comes up on the top?
Intuit is constantly testing new things in QuickBooks. For some accounts that screen is at the bottom 🤷♀Unfortunately, there's nothing you can do to change it. If you really don't like it you can try contacting QB support to see if they can change it.
how do you enter a new loan that had processing fees, when you receive the amount different from the amount financed?
Credit loan including fees Debit cash in bank or awesome thing purchased Debit fees expense
@@GentleFrog Thank you
Good info!
How do you restore a debited transaction? I can't figure that one out
There is no restore, you have to enter it again.
@@GentleFrog Thank you so much!!
Yeah I found that as well. Why they dropped the reactions selection on the participants screen is beyond me. Another example of changing a working product to give it less utility. Thanks for nothing , zoom.
It definitely seems like a step backward!
Thank you for showing us how to deal with old unreconciled transactions. I was able to correct this for my books.
You're welcome! I'm so happy to hear that you were able to get your books corrected
Thank you Rachel perfect
Thank you so much! Extremely helpful!
You're welcome! I'm so glad it helped you out.
Hi Rachel! I hope you are doing well. But I need your help just for 2 minutes. Can you please talk to me? My hubDoc is not showing the third option to create CSV report. Can you please help me?
That sounds like a software issue which I'm not qualified to answer. But here's the hubdoc support page: www.hubdoc.com/support
Would you suggest using this if you have a customer with two differnt locations and both locations pay different sales tax rates?
Tax is based on the location of the goods or services. I'd make two sub customers, one for each location. They can be set up to bill to the parent customer if needed.
Thank you for this recommendation. I understand the tax part, but I am not sure I fully understand setting up two sub customers under the parent account. Let’s see if I understand correctly. Let’s say as example the two customers are Bob’s Tree Service North tax rate 8.9% and Bob’s Tree Service South rate 8.0%. I would name my parent account Bob’s Tree Service and leave out the address? Now I can add my two sub customers below my parent account. Do you possibly have any examples I could watch?
@@JamieRaemaeker-w2u You can create a test invoice dated 12/31/2025 for each location and make sure the taxes appear like they should. If you feel uncomfortable doing this in your QB you can use the test drive account: quickbooks.intuit.com/learn-support/en-us/help-article/small-business-processes/test-drive-quickbooks-online/L9C12ODlA_US_en_US
I like your tutorials - do you work directly with clients.
Yes, I do work directly with training and bookkeeping clients.
@@GentleFrog What is the process - I have used QuickBooks for year and still get frustrated!!! I thought I was successful importing customers from my original company file and I have problems!!
@@KittyMRuhstaller All training is done over Zoom so we can screen share and I can see what's going on. You can schedule training here: www.gentlefrog.com/meeting I'm currently working on a big project and won't be doing any training throughout the month of January. If you need help ASAP I'd suggest reaching out to one of these other wonderful QuickBooks experts who also offer one-on-one training: littledetailsbookkeeping.com/ trueresourcebookkeeping.com/ www.quickbooksjeannie.com/
Do you know how to add a Class to a single line item transaction? Class is an option when selecting Split, but I typically only have one line item.
Unfortunately you can't do this from the mobile app, you must log into QB from you browser to make these adjustments. I don't use QB mobile receipts but this comes up on training calls, I've tested it recently and haven't come up with a more efficient solution.
@@GentleFrog Thank you! I found a workaround within the Mobile App for Credit Card receipts (haven't tested for Bills, but should work similarly). Upload receipt, save and create expense (as you normally would for a single line item). Receipt should move over to the Reviewed section where you can edit and you should now see Class as an option. I'm a company admin, but hopefully this is the same workflow for standard users.
@@betho269 Yes, that is a way to do it. It will work for standard users.
Can you tell me why the total increases by the invoiced amount when converted?
I've never heard of that happening before. I'd suggest scheduling a meeting but my schedule is booked through January. Here are some other bookkeepers who can take a look and give you advice: littledetailsbookkeeping.com/ trueresourcebookkeeping.com/ www.quickbooksjeannie.com/
Thank you!
I still need to find the gear icon
It should be in the upper right corner of your screen. If it's not try logging out and logging back in and if that doesn't work you'll need to contact QBO support.
Do you have any questions about switching from tags to custom fields? Let me know in the comments!
Hi Rachel. Having no experience with Stripe or Square, would you know the exact amount, via a predetermined fee, for how much to subtract from your bank deposit, on any given sales amount? Is this something that is known in advance? Thank you for the great videos.
Yes and no. Payment processors like Stripe and Square do often list their standard rates on their website but it can vary. There's often volume discounts depending on how many transactions you process per month. You'll have to check with each processor to find out.
Good Discussion
Does anybody know why QBO will not let me email invoices to customers? It tells me to double check customer information but their email address is correct.
I'm not sure why that would happen, it could be a bug. Technical glitches is one of the few times I'd suggest contacting QBO support: quickbooks.intuit.com/learn-support/en-us/help-article/account-management/contact-quickbooks-products-services-support/L7lDnkKLB_US_en_US
I entered a transaction in QB online to our credit card as an expense. It was reconciled before I realized it should not have been treated as such and the expense amounts were kind of double entered. Instead I realize I should have used the pay down credit card transfer option. So I deleted the reconciled error transaction and then entered the pay down credit card option as it should have been. I suspect I did this wrong because now I have caused an error in our reconciliation. HELP!!!!! Thank you.
Thank You!!! ☺
You're welcome!
Thank you. Thank you. Thank you. PayPal should be ashamed of themselves.
They definitely don't make it easy!
Hi Rachel, thank you for your clear explanation. I have a situation with a liability that has to be switched from one "client" to "another client" (same owner different enterprises) how do you set up the first journal entry? The liability account is clear, but I can not figure out the other account in the JE. Would very much appreciate your help. Thank you
I'm having a hard time wrapping my head around this and will need some more context. Does this QBO which has a liability still have a liability? If not, why not?
I like how you keep the different fees separate. I work with a client who has revenue from Airbnb sites. I want to bring in certain fees n such. Thank you!
Thanks! Some people will lump all fees together, I like to keep things separate, it's a personal preference.
Thank you!
You're welcome!
Hi, how would I record the stripe fee and amt for quickbooks desktop?
1. Go to banking 2. Make deposit 3. Enter the sales or select from the customer payments that are already there 4. Enter the merchant account and the negative amount for the fees Follow the same logic as I show in the QBO video.
@@GentleFrog Thank you. I went to the undeposited and did basically what you said. Thank you for the quick response
How do I get the second column to show?
What column are you referring to?
Thank you!!
You're welcome!
Thanks for keeping us updated on these important payroll tax changes!
You're welcome! I wish Intuit would make it easier for people.
can you email receipts directly to quick books
Yes, go to the Receipts section (Transactions ->Receipts in the left side menu). Then click Manage settings on the right and it will give you a separate email address for expenses and sales.
How do I move my Quickbooks from QBox to Online Quickbooks? That would be a great video topic - thanks
Great idea! I've added it to my video queue.
Your content is so intuitive; I have a query, you have correlating video. A symbiotic relationship. Thanks so much ;-)
That's great! If you ever have a query and I don't have a correlating video, let me know! I'm always looking for new topics to cover.
Thank you so much for this! I'm working out of both Online and Desktop for different companies and the same methods I use for corporate cards on DT apparently didn't translate onto QBO. You're a lifesaver!
Yay! That's so great to hear.
Excellent video; cleared up some questions I had.🙂
Yay! I love to hear that. If you have any questions I haven't addressed in my videos let me know!
Same here it's not working... It's creating new company
Are you using the app?
Very helpful. Thank you.
You're welcome! I'm so glad you found it helpful.
This is a great channel
Thank you ! I'm glad you like it. If you have any topics you'd like me to cover let me know in the comments!
Thanks Rachel! Of course I just got this message yesterday with a client of my client ..I will make her aware today since I thought this was 1 of QBO payrolls many glitches.
Hi Rachel, my company was sold as an Asset tot eh new owner and he did a a line of credit to pay off the old owner, how could I set this in QBO.
If I understand this correctly, the buyer asked the seller to give them a loan to buy the asset... Debit: (a new asset) Loan to ABC Company Credit: The asset that was sold Debit/Credit: A newly created other income or an other expense account called "Gain (or loss) on sale of Super Cool asset". When done, the original equipment asset account will be zero dollars. And there will be a new asset for the loan issued to the company that borrowed money to buy a thing.
@@GentleFrog No, the seller sold the company to new buyer as a asset and the buyer took a line of credit to pay him off in which we have to record in our books, so we didn't get the money the seller got the full amount deposit to his account.
Thank you so much for this video!❤️ I saw that message when I tried to reclassify a reconciled transaction. I was so scared to change it because the process of unreconcile/reconcilng it again was very overwhelming especially that I’m almost completing my year-end bookkeeping.❤️❤️❤️
Yay! I'm so glad my video helped you out in getting your year-end bookkeeping done.
Can you do something about Due To/From Accounts (Intercompany, etc)
Thanks for the suggestion, I've added it to my list of ideas for upcoming videos.
Big thanks! Subscribed
Thank you!