Hello My Friends!! This video will help everyone everywhere do all their QuickBooks online work faster and easier. It explains everything you could possibly need about connecting, importing and downloading bank transactions to manage your bank transactions and credit card transactions fast and easy. It’s the clearest, smoothest explanation anywhere about this feature. There’s even practice exercises that yo8u can download and try!! Nobody else on RUclips has this!! It’s free for you to enjoy!! I hope you will click “like” and subscribe. -Mark
I’m Vietnamese, and I am learning American Accountant to find a remote job from US. And so thank you to see this video, you speak very clearly and understandably. Your pronunciation is easy to hear to catch up what you say. Again, thank you very much.
Thank you so much for the nice compliment A very glad that the videos are helping you If you click in the top right corner of this video, you will get the link to the full playlist and you should watch all the videos in the playlist in proper order. And then you will be an expert with everything Mark
Thank you so much I hope you will click like after watching each video to help support the free channel for everyone and am here if you have If you have any questions and please subscribe Mark
Thank you Mark for all the great information. Could you explain how to add a transfer to an equity account being used as a draw acct and reimbursed as capital . I need to put the owners name in but only get vendor and customer options.
Your information has been very helpful, we just moved to the online version. I’m interested in cleaning up the supplier and customer lists, we have many duplicates, but so far I haven’t found this topic addressed, do you have anything on this subject?
Thank you for the kind words I do have videos on importing and exporting the customer and vendor list but not about cleaning it up It's easy to delete vendors and customers one by one and batch add them
Oh thank you so much It's worth it when you hear the great appreciation and I want everyone to use these videos and if the quick books. Company. Knew what this channel Does,. Then they would send everybody here because it's solves every problem that they could ever have. I hope you remember to click like after watching each one and encourage others to subscribe and please stay in touch! Mark.
@@worldwidequickbooks OK...you got me going. Do you have any resources that discuss improved financial reporting options? For example if you want to create more customized non-vanilla financial statements, what are some best options for doing this? Many thanks and if you have a video please point me to it.
Mark, do you have a full tutorial video about how to pass Proadviser certificate in QuickBooks? No matter how many hours it is, I'm very willing to watch your video than to go to self paced training in QuickBooks
Thank you that is such a nice compliment Unfortunately I do not have a video series specifically to pass the pro adviser test I do have a lot of the same topics But no matter what you still have to do. The self pace training because they are the ones who are going to give you the test questions They are going to use the same words in the self paced video as they have in the test questions. I suggest that you Watch the complete tutorials that I have Then take the Self paced training they provide My videos will give you the good foundation. And if there is any topic that they have, that is confusing, you, you can search for the equivalent topic on my channel, and it might help elaborate. You can stay in touch and ask me questions in the comments section as your studying for pro adviser. But ultimately, you have to use their worms and their methods to answer the question in the test. Thank you so much again and I hope you will click like after watching each video you've saved to help support the free channel for accountants and everyone, and please subscribe Mark
Hello Mark! Thanks for excellent lesson. If I am setting up a NEW company in QBO starting Jan 1, 2024 and getting bank feeds for all the bank and credit card transactions. Say the accounts statement also included some transactions from Dec 2023 (eg Dec 15/2023-Jan14/2024 statement range), now appearing in the book. When I reconcile those accounts, If I just accept them, the company P&L will start with negative from Jan 1/2024. How would I deal with those last year transactions to start fresh in 2024? Thank you!
Thank you for asking This playlist will show you exactly what to do when you're starting up fresh so that you can have. All the right numbers at the beginning ruclips.net/p/PLqRhgBZfJuE4_HFc8mGCR7_BbDYrfF0Vq It's important to watch the videos in proper order to make sure you understand the ideas better and do everything the right way After you watch the playlist, I'm here. If you need follow up questions and you can always leave the question in the comments section of any video you're asking the question about I hope you will click like after watching each 12 help support the free channel for everyone and please subscribe Mark
Thank you so much for all the tutorial videos. Your videos really helped me understand how QBO works. I would like to know how to apply bank feeds data to open invoices and bills. Do you have any other videos that explain those?
Thank you yes absolutely If you click in the top right corner of this video you will get the link to the full bank feeds playlist. Make sure that you watch it and proper order and the video towards the end of the playlist. Has the information that you need Please confirm you have it I hope you will remember to click like after watching each one to help support the free channel for everyone and please subscribe. Mark
Thanks for the reply. I clicked the top right corner and found the links to a playlist titled "QB Online Bank Reconciliation". I don't have time to watch everything today, but I'll definitely watch them later soon. Thank you so much. In this video you mentioned that (23:32) "You can match it to a different transaction. but matching a transaction to a different transaction would be the topic of another video" I wanted to know how to match bank data to a different transaction already recorded as Bill or Invoice but not recorded on book as cash payment/receipt part. Was the procedure explained in one of the videos in the playlist " QB Online Bank Reconciliation" ? The process I'm interested to know is for the examples, 1:24:42 If the invoice has been recorded, is it possible to click "Find Match" or "FInd Other Match" , ( instead of categorizing it to AR once), and apply to the customer's invoice? 1:33:45 Same thing for vender. If a bill is already entered, click "Find Other Match" and apply directly to the vender's bill rather than recording it as A/P. I guess QBO should be able to find an invoice or a bill by most key word such as a customer, or a vender name you enter in the search box. I've just started using QBO two weeks ago, and I'm not familiar with those parts.
THANKYOU much for this information. How do one locate a specific topic like ,removing old Entries in reconciliation windows without effecting any reports / reconciliations that taxes have been filed on.
Thank you for asking Everything you could need to know about bank. Reconciliation is in this playlist, but you must watch it in proper order and it will not take that long ruclips.net/p/PLqRhgBZfJuE7Kmc1AOq3fw3aYuZItztuV Please let me know if the playlist answered your question. Each video is only a few minutes but it's worth watching Mark
I thought you were going to change the name to office max at 26:09 but you re-typed staples. Was that a mistake on your part? That's the only way I think I can make sense of the point you were trying to make. Your videos have been a godsend in helping me learn quickbooks after years of running Sage. Thank you for your wonderful content!
Oh thank you so much for the kind words. I'm very glad the videos are helping you and don't forget to click like after watching each one to help support the free channel for everyone and please. Subscribe and stay in touch Mark.
You could either delete every transaction one by one because there is no batch delete,or,. You could contact quick books online sport and either ask them to reset your account or to cancel your account and sign up again fresh. You could also use a different email address and sign up using a different phone number for a separate account for the Free.30 day plus version trial just to be. Able to do this video. This way you won't screw up your actual companies numbers. Thank you for the compliment and thank you for watching and appear if you need anything else regarding quick books. I hope you will always click like after watching each video and subscribe. Mark.
It's me again! Haha. At 1:24:53, why did you use the Accounts Receivable account, instead of the income account? I thought if you have earned and received the money then it should be categorized as the income account.
Thank you.I do not have the transactions memorized, but I would assume you would choose accounts.Receivable instead of income if it is in fact an advanced payment So you need two things You need to click on the top right corner of this video to watch the full playlist.I'm importing and bank feeds so that you understand the contacts about everything works You should watch the playlist and proper order You also need the video about advanced payments to customers in order to explain why you would choose account receivable Please let me know if you want that video.I can send you the link Mark
@@worldwidequickbooks so it is safe to say that I will only categorize a deposit or a money received as an A/R if it is a prepayment or an advance payment? But if it's not an advance payment, then it should be an income account? I'm so sorry for flooding you with questions.
Sir, thank you so much for teaching us the Quickbooks. I have been following your videos and learning the basics. You have helped me a lot. But I need your help a bit. In this video you provided a project and necessary files. I did as per your instructions. But the QBO file for bank transaction contains more than 500 transactions and the rules list you have given is not sufficient to cover all the transactions to be categorized from the review panel. Please suggest me what should I do?
Thank you for the compliment and I'm very glad. You're learning well and thank you for being a loyal and devoted student The excess files that has the rules has other sheets and in the other sheets. There are explanations of what To Do for the transactions that are not covered under the rules. I'm assuming you have access to the excel sheet so please confirm. Mark
Sir, I'm very sorry to disturb you. But the excel file which I have contains only 7 rules and only 4 check type transactions and some instructions. And I do not know what to do to the transactions which are not covered under the rules. Please help me a bit Sir.
Hello Mark and good day! Thanks for all your support. I have a question regarding a account. I setup QuickBooks and I believe I selected a date in Q4 of 2023 (October), I'm not totally sure, and I successfully reconciled the account after some trial and error. Retrospectively, I should have selected Q1 of 2023 (January) for my starting import date. I've since changed my opening balance based on the January statement and now, I'm off 24k because it's not downloading the first 10 months of records. I tried the manual route of importing documents manually however my bank only allows a pdf download and when I converted to a cvs file, the rows were not aligned singularly, and the date format was off. My question is if there's a way to pull the data from my bank for the first 10 months that I'm overlooking? I have other accounts and successfully imported back to January 2023 for one of those.
Thank you but I really can't read all that Please limit your question to 2 to 5 sentences and be conscious and limit to them to one at a time. And I promise I'll answer each one in proper order. Because I do want to help you Mark
@@worldwidequickbooks - Got it! I originally setup my import date for 1/1/23 and successfully reconciled my account closing out the year. I need to get all transactions starting 1/1/2023 so I disconnected/reconnected the account, changed my opening balance date to 1/1/23 and updated starting balance dollar amount. No additional transactions however are imported into Quickbooks. Am I missing something?
I cannot be sure without a full session because there are more things I would needto ask about. However, this playlist, watched in proepr order, will explain the ideas of setting up fresh as of a specific start date. This should cover any remaining questions you have about the set up. ruclips.net/video/RNStJ9YQpus/видео.html -Mark
Question: I am new to QBO. I am however using QBO Accountant version. I thought I was working within a client file (my personal/non business) when I linked bank accounts and brought in transactions for review. Fortunately, I used the Journal Report with only a couple transactions to realize it was incorrect. How can I remove these bank accounts from my business file (accountant) and then link to my client file? Does my client file require their own QBO account?
The client has to have a separately paid account and cannot have a free account The account introduction is free but the clients must pay for their accounts monthly Then they must invite you as an accountant. User for you to be able to log into their account You will then be able to see from the interface that you are the accountant user. But you are inside their account and you are not in your own personal company books and files The my company section in the left is for your accounting firm to keep its own books and the client section is for you to log in to their accounts and see a different interface before you perform services or record transactions I could send you a video that shows this Please let me know if you'd like me to send you the link. Or you want to stand what to do Mark
@@worldwidequickbooks Yes, please send the link. Will the video you are sending over also explain how to remove the bank accounts and the transactions that are currently sitting in review?
Sir can you please make a video regarding internal transfer between bank accounts, especially those transactions the quickbook AI cannot pair by themselves? Thanks a lot sir, your videos are very helpful and easy to follow.
Thank you for asking If you're a asking about multi currency transactions you could watch this playlist and proper order and it will give you everything you need. ruclips.net/p/PLqRhgBZfJuE57wUDCbnNefXgX8TvS2R-B If you're not asking about multi currency transactions. Then please clarify and I'll be happy to help you. Mark
@@worldwidequickbooks Sir I was asking about the internal transfer between one bank account to another. I am facing problems when the quickbook by itself cannot categorize and pair the transaction by itself. The 'find match' option is also confusing me. Sir please help me to get clarified. Thank you
I really appreciate your work Mark! But I am struggling with importing pdf bank statement to QBO. I need to import old bank statements that are 3 years old and can't access from the bank to import them in a certain format, eg. csv. So, how do I change pdf file into a format that is accepted by QBO?
If you can find a converter or a website that will convert pdf to excel or even convert to word and then copy and past to excel, then you can use the videos in this playlist to see how to import. You may be able to download those other file formats that you mentioned if you call your banks; give it a try and let me know. -Mark
when I pull my bank information how far back do you recommend? this year last month or start from where I stopped in desk top I think it expired 5-31-23
Thank you but only you what no what you need in a situation like that. Just go as far back as you need. If the bank does not make the files available as far back as you need. Then you have no choice but to ask them for the statements and put everything into the quick books online one by one. Not a pleasant thought Mark
Yes. ruclips.net/p/PLqRhgBZfJuE7Kmc1AOq3fw3aYuZItztuV You must watch this playlist in proper order and you will then be an expert and have everything you need.. I hope you will quick like after watching each one to help support the free channel for everyone and I'm here if you have any questions. Mark
Thank you so much and I have already done that Click on the Kitty to go to the main channel page. Go to rose down to see the most popular video with overhaffer million views called "quick books online complete tutorial". You should watch that 1 1st and then watch this one and then believe me. You will have everything you need and i'm here if you have any other questions I hope you will remember to click like and subscribe Mark
When using classes for invoicing customers, is it also required to select a class when coding transactions from the bank feeds? That would get a little tedious if that’s true? Or can you just clear the bank feeds without having to class every transaction that comes in?
You can have classes and recorded from the bank feeds review list I can show you If you click in the top right corner of this video you will get the link to the full playlist for bank feeds and downloading transactions One of the last videos in that playlist shows you how you can use classes in the bank feeds. Confirm that you found the video and if not then I'll help you I'll find You the link. Mark
@@worldwidequickbooks Hey thanks I was able to figure that out. I do have another question related to a friend of mine accounting for a vehicle loan for their transportation service business. Their accountant is having them code their vehicle loan payment (either the interest or principle portion) to COGS (Costs of Goods Sold), that didn't make sense to me as this business does not sell or manufacture goods. They only provide transportation services and this was for a loan payment to one of their vans that they use. Using COGS seems incorrect, what do you think?
@@RJArrayCPA, I strongly feel this is a mis-categorization issue and a QuickBooks. Let me tell you what I think from a accounting perspective. The loan should be categorized as loan payable depending on the used in their chart of accounts. The monthly interest is charged to an interest expense account until the payment of the loan account is brought to zero.
@thequickbooksdude Vendors are not able to be associated with accounts receivable.... I know you released a series related to property management companies, however, from the perspective of the *landowner*, would it be necessary for a landowner to have both a vendor and a customer for the property management company so that it can recognize RI from the tenant but also 1) assign the property management expense to the management company and 2) assign the accounts receivable to the property management company? Any help would be much appreciated; thank you for being so responsive to your comments section.
Thank you for watching the video series I can tell you that my message that's shown in the desktop landlord service companies that give service to landlords for management. , are the best methods and very much better than the one you mentioned here. You must watch that series and proper order by clicking in the top right corner of any of the videos to get the link to the full playlist and if. You did not watch It in proper order. You did not really see how it works. It works beautifully if you watch the series and proper order from beginning to end and create a file and follow step-by-step and you will see that it. Gives you everything you need with very easy procedures. Mark
@@worldwidequickbooks I am trying to solve a specific issue from a LAND-OWNER perspective that I feel would not be addressed in a timely manner by rewatching that series. Might you have any advice as to how a LANDOWNER would record receipt of AR from a Prop. Mgt. Co.? Either way, thank you for your time.
Thank you but I actually don't uderstnd what you are asking. It's difficult to read a whole text about some concept here in the comment section. I usually savew a detalied consultation for a paid session if it's that important to the client. -Mark
Hi mark hope you are doing great. so i have a little different question regarding QBO signup. so i am from pakistan and i have just started bookkeeping and i want to practice it on QBO while watching your videos but i cant afford to buy the plus version of quickbooks online so i went for the 30 day trial BUTT its not working. I entered all the required information regarding payment and billing but its not working. Is there any way that you can help me with this? I"ll be grateful if you could please help me with this. Thanks
I can't really do texts for it but I do appreciate you watching the video at once you can get things to work properly you can come back to. The channel and get a video for everything you need Mark
@@worldwidequickbooks thanks. I have another small request. Can you please make a video about Quickbooks Test drive? How to Practice Bookeeping overthere?? please
If the Banks use an account number for where the money is coming and going from for accountability...two things should happen debit and credit....everywhere
If Quickbooks and Banks are "The General Keepers of accounts....shouldn't the road to a transaction's record be mapped out at the register or in the app? If I have bill pay with my bank Already, and my bank has Quickbooks already 🙃...see where I'm heading 😒
Are you using QuickBooks for home finance or for business? I would need to know that before I could tell you how to classify your husband's salary Mark
You have to watch the chapter of important cubio files in order to understand how To Do it. You could watch the entire video and proper order but there's a table of contents if you want to see how to import the specific file type that. You're having an issue with. Mark
Hello My Friends!!
This video will help everyone everywhere do all their QuickBooks online work faster and easier. It explains everything you could possibly need about connecting, importing and downloading bank transactions to manage your bank transactions and credit card transactions fast and easy. It’s the clearest, smoothest explanation anywhere about this feature.
There’s even practice exercises that yo8u can download and try!! Nobody else on RUclips has this!!
It’s free for you to enjoy!!
I hope you will click “like” and subscribe.
-Mark
I’m Vietnamese, and I am learning American Accountant to find a remote job from US. And so thank you to see this video, you speak very clearly and understandably. Your pronunciation is easy to hear to catch up what you say. Again, thank you very much.
Thank you so much for the nice compliment
A very glad that the videos are helping you
If you click in the top right corner of this video, you will get the link to the full playlist and you should watch all the videos in the playlist in proper order. And then you will be an expert with everything
Mark
Best QBO teacher on the internet.
Thank you so much
I hope you will click like after watching each video to help support the free channel for everyone and am here if you have If you have any questions and please subscribe
Mark
Thank you Mark for all the great information. Could you explain how to add a transfer to an equity account being used as a draw acct and reimbursed as capital . I need to put the owners name in but only get vendor and customer options.
Thank you for asking
You can just put the owner's name on the vendor and customer list and use that name as part of the Transaction
Mark
Your information has been very helpful, we just moved to the online version. I’m interested in cleaning up the supplier and customer lists, we have many duplicates, but so far I haven’t found this topic addressed, do you have anything on this subject?
Thank you for the kind words
I do have videos on importing and exporting the customer and vendor list but not about cleaning it up
It's easy to delete vendors and customers one by one and batch add them
Excellent video, Mark, and thank you. We don't say it enough. You've done a remarkable job with these videos! Simply amazing what you've created here.
Oh thank you so much
It's worth it when you hear the great appreciation and I want everyone to use these videos and if the quick books. Company. Knew what this channel Does,. Then they would send everybody here because it's solves every problem that they could ever have.
I hope you remember to click like after watching each one and encourage others to subscribe and please stay in touch!
Mark.
@@worldwidequickbooks OK...you got me going. Do you have any resources that discuss improved financial reporting options? For example if you want to create more customized non-vanilla financial statements, what are some best options for doing this? Many thanks and if you have a video please point me to it.
Mark, do you have a full tutorial video about how to pass Proadviser certificate in QuickBooks? No matter how many hours it is, I'm very willing to watch your video than to go to self paced training in QuickBooks
Thank you that is such a nice compliment
Unfortunately I do not have a video series specifically to pass the pro adviser test
I do have a lot of the same topics But no matter what you still have to do. The self pace training because they are the ones who are going to give you the test questions
They are going to use the same words in the self paced video as they have in the test questions.
I suggest that you Watch the complete tutorials that I have
Then take the Self paced training they provide
My videos will give you the good foundation. And if there is any topic that they have, that is confusing, you, you can search for the equivalent topic on my channel, and it might help elaborate.
You can stay in touch and ask me questions in the comments section as your studying for pro adviser. But ultimately, you have to use their worms and their methods to answer the question in the test.
Thank you so much again and I hope you will click like after watching each video you've saved to help support the free channel for accountants and everyone, and please subscribe
Mark
I appreciate your response Mark... All your videos really help me a lot and thank you for the advice I'll take note of it! Thank you again ☺️
Hello Mark! Thanks for excellent lesson. If I am setting up a NEW company in QBO starting Jan 1, 2024 and getting bank feeds for all the bank and credit card transactions. Say the accounts statement also included some transactions from Dec 2023 (eg Dec 15/2023-Jan14/2024 statement range), now appearing in the book. When I reconcile those accounts, If I just accept them, the company P&L will start with negative from Jan 1/2024. How would I deal with those last year transactions to start fresh in 2024? Thank you!
Thank you for asking
This playlist will show you exactly what to do when you're starting up fresh so that you can have. All the right numbers at the beginning
ruclips.net/p/PLqRhgBZfJuE4_HFc8mGCR7_BbDYrfF0Vq
It's important to watch the videos in proper order to make sure you understand the ideas better and do everything the right way
After you watch the playlist, I'm here. If you need follow up questions and you can always leave the question in the comments section of any video you're asking the question about
I hope you will click like after watching each 12 help support the free channel for everyone and please subscribe
Mark
@@worldwidequickbooks Thank you Mark for the prompt reply! You are the best :) I subscribed and liked what I watched. I will check out these lessons.
Thank you so much for all the tutorial videos. Your videos really helped me understand how QBO works.
I would like to know how to apply bank feeds data to open invoices and bills.
Do you have any other videos that explain those?
Thank you yes absolutely
If you click in the top right corner of this video you will get the link to the full bank feeds playlist.
Make sure that you watch it and proper order and the video towards the end of the playlist. Has the information that you need
Please confirm you have it
I hope you will remember to click like after watching each one to help support the free channel for everyone and please subscribe.
Mark
Thanks for the reply. I clicked the top right corner and found the links to a playlist titled "QB Online Bank Reconciliation". I don't have time to watch everything today, but I'll definitely watch them later soon. Thank you so much.
In this video you mentioned that (23:32) "You can match it to a different transaction. but matching a transaction to a different transaction would be the topic of another video" I wanted to know how to match bank data to a different transaction already recorded as Bill or Invoice but not recorded on book as cash payment/receipt part. Was the procedure explained in one of the videos in the playlist " QB Online Bank Reconciliation" ?
The process I'm interested to know is for the examples, 1:24:42 If the invoice has been recorded, is it possible to click "Find Match" or "FInd Other Match" , ( instead of categorizing it to AR once), and apply to the customer's invoice? 1:33:45 Same thing for vender. If a bill is already entered, click "Find Other Match" and apply directly to the vender's bill rather than recording it as A/P. I guess QBO should be able to find an invoice or a bill by most key word such as a customer, or a vender name you enter in the search box. I've just started using QBO two weeks ago, and I'm not familiar with those parts.
THANKYOU much for this information.
How do one locate a specific topic like ,removing old
Entries in reconciliation windows without effecting any reports / reconciliations that taxes have been filed on.
Thank you for asking
Everything you could need to know about bank. Reconciliation is in this playlist, but you must watch it in proper order and it will not take that long
ruclips.net/p/PLqRhgBZfJuE7Kmc1AOq3fw3aYuZItztuV
Please let me know if the playlist answered your question. Each video is only a few minutes but it's worth watching
Mark
I thought you were going to change the name to office max at 26:09 but you re-typed staples. Was that a mistake on your part? That's the only way I think I can make sense of the point you were trying to make. Your videos have been a godsend in helping me learn quickbooks after years of running Sage. Thank you for your wonderful content!
Oh thank you so much for the kind words.
I'm very glad the videos are helping you and don't forget to click like after watching each one to help support the free channel for everyone and please. Subscribe and stay in touch
Mark.
Could you please look at what I’m saying at 26:09 and let me know if you intended to type in Office max or re-type staples there?
Thank you for your excellent teaching, Mark! I got 1 question, how can I erase all existing info in my QBO before this practice test?
You could either delete every transaction one by one because there is no batch delete,or,. You could contact quick books online sport and either ask them to reset your account or to cancel your account and sign up again fresh.
You could also use a different email address and sign up using a different phone number for a separate account for the Free.30 day plus version trial just to be. Able to do this video.
This way you won't screw up your actual companies numbers.
Thank you for the compliment and thank you for watching and appear if you need anything else regarding quick books.
I hope you will always click like after watching each video and subscribe.
Mark.
It's me again! Haha. At 1:24:53, why did you use the Accounts Receivable account, instead of the income account? I thought if you have earned and received the money then it should be categorized as the income account.
Thank you.I do not have the transactions memorized, but I would assume you would choose accounts.Receivable instead of income if it is in fact an advanced payment
So you need two things
You need to click on the top right corner of this video to watch the full playlist.I'm importing and bank feeds so that you understand the contacts about everything works
You should watch the playlist and proper order
You also need the video about advanced payments to customers in order to explain why you would choose account receivable
Please let me know if you want that video.I can send you the link
Mark
@@worldwidequickbooks so it is safe to say that I will only categorize a deposit or a money received as an A/R if it is a prepayment or an advance payment? But if it's not an advance payment, then it should be an income account? I'm so sorry for flooding you with questions.
Sir, thank you so much for teaching us the Quickbooks.
I have been following your videos and learning the basics. You have helped me a lot.
But I need your help a bit.
In this video you provided a project and necessary files. I did as per your instructions.
But the QBO file for bank transaction contains more than 500 transactions and the rules list you have given is not sufficient to cover all the transactions to be categorized from the review panel.
Please suggest me what should I do?
Thank you for the compliment and I'm very glad. You're learning well and thank you for being a loyal and devoted student
The excess files that has the rules has other sheets and in the other sheets. There are explanations of what To Do for the transactions that are not covered under the rules.
I'm assuming you have access to the excel sheet so please confirm.
Mark
Sir, I'm very sorry to disturb you.
But the excel file which I have contains only 7 rules and only 4 check type transactions and some instructions.
And I do not know what to do to the transactions which are not covered under the rules.
Please help me a bit Sir.
Hello Mark and good day! Thanks for all your support. I have a question regarding a account.
I setup QuickBooks and I believe I selected a date in Q4 of 2023 (October), I'm not totally sure, and I successfully reconciled the account after some trial and error. Retrospectively, I should have selected Q1 of 2023 (January) for my starting import date. I've since changed my opening balance based on the January statement and now, I'm off 24k because it's not downloading the first 10 months of records. I tried the manual route of importing documents manually however my bank only allows a pdf download and when I converted to a cvs file, the rows were not aligned singularly, and the date format was off. My question is if there's a way to pull the data from my bank for the first 10 months that I'm overlooking? I have other accounts and successfully imported back to January 2023 for one of those.
Thank you but I really can't read all that
Please limit your question to 2 to 5 sentences and be conscious and limit to them to one at a time. And I promise I'll answer each one in proper order. Because I do want to help you
Mark
@@worldwidequickbooks - Got it! I originally setup my import date for 1/1/23 and successfully reconciled my account closing out the year. I need to get all transactions starting 1/1/2023 so I disconnected/reconnected the account, changed my opening balance date to 1/1/23 and updated starting balance dollar amount. No additional transactions however are imported into Quickbooks. Am I missing something?
I cannot be sure without a full session because there are more things I would needto ask about. However, this playlist, watched in proepr order, will explain the ideas of setting up fresh as of a specific start date. This should cover any remaining questions you have about the set up.
ruclips.net/video/RNStJ9YQpus/видео.html
-Mark
Question: I am new to QBO. I am however using QBO Accountant version. I thought I was working within a client file (my personal/non business) when I linked bank accounts and brought in transactions for review. Fortunately, I used the Journal Report with only a couple transactions to realize it was incorrect.
How can I remove these bank accounts from my business file (accountant) and then link to my client file? Does my client file require their own QBO account?
The client has to have a separately paid account and cannot have a free account
The account introduction is free but the clients must pay for their accounts monthly
Then they must invite you as an accountant. User for you to be able to log into their account
You will then be able to see from the interface that you are the accountant user. But you are inside their account and you are not in your own personal company books and files
The my company section in the left is for your accounting firm to keep its own books and the client section is for you to log in to their accounts and see a different interface before you perform services or record transactions
I could send you a video that shows this
Please let me know if you'd like me to send you the link. Or you want to stand what to do
Mark
@@worldwidequickbooks Yes, please send the link. Will the video you are sending over also explain how to remove the bank accounts and the transactions that are currently sitting in review?
Sir can you please make a video regarding internal transfer between bank accounts, especially those transactions the quickbook AI cannot pair by themselves?
Thanks a lot sir, your videos are very helpful and easy to follow.
Thank you for asking
If you're a asking about multi currency transactions you could watch this playlist and proper order and it will give you everything you need.
ruclips.net/p/PLqRhgBZfJuE57wUDCbnNefXgX8TvS2R-B
If you're not asking about multi currency transactions. Then please clarify and I'll be happy to help you.
Mark
@@worldwidequickbooks Sir I was asking about the internal transfer between one bank account to another. I am facing problems when the quickbook by itself cannot categorize and pair the transaction by itself. The 'find match' option is also confusing me. Sir please help me to get clarified. Thank you
I really appreciate your work Mark!
But I am struggling with importing pdf bank statement to QBO. I need to import old bank statements that are 3 years old and can't access from the bank to import them in a certain format, eg. csv. So, how do I change pdf file into a format that is accepted by QBO?
If you can find a converter or a website that will convert pdf to excel or even convert to word and then copy and past to excel, then you can use the videos in this playlist to see how to import.
You may be able to download those other file formats that you mentioned if you call your banks; give it a try and let me know.
-Mark
when I pull my bank information how far back do you recommend? this year last month or start from where I stopped in desk top I think it expired 5-31-23
Thank you but only you what no what you need in a situation like that.
Just go as far back as you need.
If the bank does not make the files available as far back as you need. Then you have no choice but to ask them for the statements and put everything into the quick books online one by one.
Not a pleasant thought
Mark
Do you have a video on how to reconcile accounts?
Yes.
ruclips.net/p/PLqRhgBZfJuE7Kmc1AOq3fw3aYuZItztuV
You must watch this playlist in proper order and you will then be an expert and have everything you need..
I hope you will quick like after watching each one to help support the free channel for everyone and I'm here if you have any questions.
Mark
Great sir
congratulations plz Quick book accounting software course basic level to professional level with practical Plz?
Thank you so much and I have already done that
Click on the Kitty to go to the main channel page.
Go to rose down to see the most popular video with overhaffer million views called "quick books online complete tutorial".
You should watch that 1 1st and then watch this one and then believe me. You will have everything you need and i'm here if you have any other questions
I hope you will remember to click like and subscribe
Mark
When using classes for invoicing customers, is it also required to select a class when coding transactions from the bank feeds? That would get a little tedious if that’s true? Or can you just clear the bank feeds without having to class every transaction that comes in?
You can have classes and recorded from the bank feeds review list
I can show you
If you click in the top right corner of this video you will get the link to the full playlist for bank feeds and downloading transactions
One of the last videos in that playlist shows you how you can use classes in the bank feeds.
Confirm that you found the video and if not then I'll help you I'll find You the link.
Mark
@@worldwidequickbooks Hey thanks I was able to figure that out. I do have another question related to a friend of mine accounting for a vehicle loan for their transportation service business. Their accountant is having them code their vehicle loan payment (either the interest or principle portion) to COGS (Costs of Goods Sold), that didn't make sense to me as this business does not sell or manufacture goods. They only provide transportation services and this was for a loan payment to one of their vans that they use. Using COGS seems incorrect, what do you think?
@@RJArrayCPA, I strongly feel this is a mis-categorization issue and a QuickBooks. Let me tell you what I think from a accounting perspective. The loan should be categorized as loan payable depending on the used in their chart of accounts. The monthly interest is charged to an interest expense account until the payment of the loan account is brought to zero.
@thequickbooksdude
Vendors are not able to be associated with accounts receivable....
I know you released a series related to property management companies, however, from the perspective of the *landowner*, would it be necessary for a landowner to have both a vendor and a customer for the property management company so that it can recognize RI from the tenant but also 1) assign the property management expense to the management company and 2) assign the accounts receivable to the property management company?
Any help would be much appreciated; thank you for being so responsive to your comments section.
Thank you for watching the video series
I can tell you that my message that's shown in the desktop landlord service companies that give service to landlords for management. , are the best methods and very much better than the one you mentioned here.
You must watch that series and proper order by clicking in the top right corner of any of the videos to get the link to the full playlist and if. You did not watch It in proper order. You did not really see how it works.
It works beautifully if you watch the series and proper order from beginning to end and create a file and follow step-by-step and you will see that it. Gives you everything you need with very easy procedures.
Mark
@@worldwidequickbooks I am trying to solve a specific issue from a LAND-OWNER perspective that I feel would not be addressed in a timely manner by rewatching that series. Might you have any advice as to how a LANDOWNER would record receipt of AR from a Prop. Mgt. Co.? Either way, thank you for your time.
Thank you but I actually don't uderstnd what you are asking.
It's difficult to read a whole text about some concept here in the comment section.
I usually savew a detalied consultation for a paid session if it's that important to the client.
-Mark
Hi mark hope you are doing great. so i have a little different question regarding QBO signup. so i am from pakistan and i have just started bookkeeping and i want to practice it on QBO while watching your videos but i cant afford to buy the plus version of quickbooks online so i went for the 30 day trial BUTT its not working. I entered all the required information regarding payment and billing but its not working. Is there any way that you can help me with this? I"ll be grateful if you could please help me with this. Thanks
I can't really do texts for it but I do appreciate you watching the video at once you can get things to work properly you can come back to. The channel and get a video for everything you need
Mark
@@worldwidequickbooks thanks. I have another small request. Can you please make a video about Quickbooks Test drive? How to Practice Bookeeping overthere?? please
Hi, do you offer tutorials?
Yes this is another tutorial for you to learn and enjoy and if did any specific topic don't be shy to ask.
Mark
How do i import a trial balance into quickbooks desktop
Thank you. Here's the link to the playlist and you need to watch it in proper order
ruclips.net/p/PLqRhgBZfJuE77I0nQ5P_nKoTWYl1xYk5J
Still my point is not enough accountability. If QuickBooks and banks could see this in first rules...
Watch the full tutorial and then you will see
If the Banks use an account number for where the money is coming and going from for accountability...two things should happen debit and credit....everywhere
Maybe China can explain the separate business chip and maybe the best maps win 🏆 🤔
@worldwidequickbooks You watch the video again kindly, how many clicks did you see? Critically ?
If Quickbooks and Banks are "The General Keepers of accounts....shouldn't the road to a transaction's record be mapped out at the register or in the app? If I have bill pay with my bank Already, and my bank has Quickbooks already 🙃...see where I'm heading 😒
How to categorize my husband salary he received in my bank?
Are you using QuickBooks for home finance or for business?
I would need to know that before I could tell you how to classify your husband's salary
Mark
TRANSACTION FILE ARE NOT IN EXCEL AND CANNOT BE OPEN TO IMPORT
You have to watch the chapter of important cubio files in order to understand how To Do it. You could watch the entire video and proper order but there's a table of contents if you want to see how to import the specific file type that. You're having an issue with.
Mark
Ok thanks