What is the rule set up for the third journal entry to DR Payroll Liabilities CR Cash?

How do you treat employee loans and repayments? Journal entry? How to map it?

We use ADP and the individual employee checks hit our payroll account. Does the GLI in ADP record the individual checks and post them in our Payroll Account in Quickbooks?

QCoach, thank you so much for these videos. They are really helpful. I have used Quickbooks Desktop for 30 years and now I am switching to Quicken Classic Business & Personal. The format is quite different. How do I record a Deposit? Do I enter the deposit under transactions? I don't see an option for making Deposits. Are all debits and credits recorded though transactions? Thank you.

Have you made a video showing how to record the sale of RSUs? I would so appreciate it!

This was so helpful! Thank you

Having a problem with syncing, as all payments have synced from Jobber and now creating duplicate payments/deposits in our system putting our Balance Sheet into a complete mess. Any help with this would be greatly appreciated, as neither Jobber or QBO have been able to help and QBO claims its a bug on QBO side which they are working on, but if anyone is using this successfully, I would appreciate this, otherwise I am ready to delete all Jobber transactions from QBO.. TIA

So my client uses Jobber (but not the Payments option) and Square. He also gets paid by e-transfers and cheques. Somehow all of it ends up in the Undeposited Funds account and I can't figure out why or how to turn it off. I tried creating "bank deposits" to move these to the actual chequing account but I only made things worse and now the deposits in the bank register are showing as doubled. Please help!

When I receive a distribution to my bank account how can I link that to reflect on the partnership account

Can you assign locations in the payroll mapping?

Can you export QuickBooks data into Quicken for example chart of accounts, vendor list, customer names, etc.

Iris

Thanks for this in-depth video! I have a couple of questions. Would there ever be a need or benefit to create more than one journal entry for payroll where there are journal entries by department? I think that would just make it harder to match bank transactions, even if it were possible. Is it a common practice to use sub-accounts when splitting things like payroll wages into different departmental accounts?

Super helpful, thank you! The only video on youtube that walks through entering private equity transactions. One question: when entering "Set Value" for the partnership, can I get that value from my annual K-1? If so, where on the K-1 is it shown?

I also would like to know if it's possible to convert/export my personal quickbooks data to quicken.

Can I covert from Quickbooks Desktop to Quicken?

How do you resize the tiles in the main view. Thank you.

Excellent video. Thank you

Do you have the la cart video? I am looking to only take a portion from Quicken and convert it into an existing Quickbooks client.

Update: Release R52.28 in September 2023 does the following: "Improved the Investment Partnership Summary Report by including a column for the last valuation date with a clickable link for updating the value. Default column widths were also adjusted for this report". You would see this after the IRR column on the report reviewed starting at 13.50. My Opinion: Nice, but still looking for several more features in this area to truly utilize Quicken functionality for Partnership investments.

Thanks for this very helpful video. You seem the perfect person to ask: I'm assuming there's a high broad demand for a more automatic way to integrate Amazon itemization and categorizations into Quicken. I wonder if you've found one since producing this video, and if not, why they don't exist? It would seem an obvious add-on for Amazon or some third party to produce.

Any tips on syncing when I have two jobber profiles ( different locations) that need to sync to one single quickbooks company profile. Right now the second jobber profile throws error due to duplicate invoice numbers. Suggestion from jobber was to start invoice numbers higher on the second profile to deconflict. This does not seem like it would work if many more locations are added. Any advice would be greatly appreciated.

Can you address how to deal with jobber credit card payments matching bank records. The invoice paid has the full amount and the bank receives the fee reduced amount. Quickbooks wants to see the full invoice amount. Do I reduce the invoice in quickbooks before reconciling?

What reports do you pull to compare to QB's on a monthly basis to ensure that all the information is coming over accurately?

Very good video. I haven't seen this anywhere else.

Will done. May I ask are using Windows or I would like to try quicken but I use macOS Catalina have be told Mac is like the res headed step child.

How did you name the journals that ADP brought into QBO? i.e. at 5:40 I can see the Journal Entry names listed as the last day of the pay period + the total amount.

Thanks for all the information.

I have a cleaning business and having trouble with this issue and I think I just need to hire someone that can help me out with running my quick book and knows how to using both jobber and quick book 😢

So how does the "map chart of accounts function" work and how do the transactions happen when they his the "banking" tab within qbo?

Thank you for this video! I'm wondering if the following be more accurate? Let's say you get 10 shares at $100 for $1,000. Let's say 3 shares are sold for $309 to cover taxes. That implies a cap gains of $9 ($3 / share sold). Would it be more accurate to record income of $1,000 - $300 in taxes (paycheck as you have it). Then purchase transaction of 10 shares at $100 for $1,000 expense (this is the RSU grant). Then sell transaction for 3 shares for $103 each. That way you don't have realized gains attached to "phantom" shares. Not really sure that it matters. Just a thought.

Amazon discontinued the download to excel option on 3/20/23. Does anyone know of a way to still get this information?

I'm a bit confused by the discussion beginning at 10:00. Are we really limited to one account for sales?

Awesome video. Thanks so much.

Is this Quicken for the MAC or Quicken for Windows?

Great video thanks for making it

Thank you. Quickly becoming a fan.

How to do 2022 taxes for a beginner.

Hi.... Please ,you can say How i navigate into colum bars whit enter. Actualy i nerd click on name for inserto information. Sorry about my inglish.

We are currently using Sage 50 Accounting. All of our products/services are managed under categories. For example when we sell something, that product goes under category 4090 (Installations). If we invoice using Jobber and we plan to switch to Quickbooks. One, does QBO do categorizing for sales and expenses? As, well if you make an invoice in Jobber does it keep the category or does it generalize it all under "sales"?

Thank you! what if I don't have a subscription and I want to open a QDF file that is made by versions later than 2013(I couldn't open it with 2013 )Is there any way to change it to a format that it's openable by 2013 version which doesn't require subscription??

In this video, you mention another video on converting CSV to QFX. However, I don't see such a video in the list of QCoach videos. Is the video under name?

Nice presentation. Thanks for showing this. I usually just manually split my transactions if they're significant, but nice to see a practical way to import the Amazon data. If I could just get this automated for Costco and Home Depot too, that would be amazing, but in the big picture I guess I really don't need all the detail that I want. 🙂Great to see your workflow.

You can always simply just edit the security name: click on Holdings, click the security, click Edit Details, then edit the Name to be just the ticker symbol or ticker symbol plus description. Whatever you want it to be. Not that difficult for most cases since it only needs to be done once for each security and then you get your reports to look the way you want them to. I like to categorize my securities, so for example, I rename them as TECH-AAPL, TECH-GOOG, BOND-LQD, BOND-BND, TOT-VTI, TOT-FMAGX, etc. Then they come out alphabetized in groups in the Holdings view.

Great video, i started a new construction company and we use Jobber and QBO. Thank you

Why is the Tools bar menu missing from my tool bar ribbon and how do I get it?

We are extremely heavy Jobber users with QBO online sync. I have been frightened to turn on syncing of "Jobber Payments payouts & fees" because we have 5 years of data that I am afraid the sync will somehow mangle. Do you know if old transactions are impacted? Or is it only new payouts and fees that have never been synced before that sync under the new system?

Thank you both for this video series. My business is 100% simple lawn mowing service. Unfortunately, I cannot use Jobber-Quickbooks Sync for invoices because Quickbooks insists on using Automated Sales Tax, which is incorrect for 90% of my customers (in Texas). I must collect state and county sales tax based on my office location (which has no other local tax), plus City/SPD/MTA sales/use tax based on customer location - and Quickbooks AST does not calculate this correctly unless the customer location does not have any City/SPD/MTA local taxes (which I don't know unless I manually check their address on the Texas Comptroller website). I've tried manually setting the correct custom and default taxes for each client and invoice in Jobber and each client in Quickbooks, but the Invoice sync always results in Jobber deferring to the Quickbooks AST calculations for sales tax, with no option to override. Editing the tax in QB then re-syncing results in the same sync error for each invoice. Now that we've learned the benefits and basic process for using Sync for businesses that don't have my particular tax issue, I would love to learn from you: 1) Would my business benefit from syncing everything other than invoices (i.e. Customers, Services, etc)? 2) If not, could you walk us through some best practices for manually updating Quickbooks based on Jobber reports? Thank you!

Very nice, thank you.

Wow! Just stumbled across your site. GREAT STUFF! This is what I've been looking for to get me off the dime! I've been sidetracked with difficulties getting my Checking account to accurately reconcile, and each year, I "recommit" and try again. Hoping this time I can get it all flowing! Thanks for great instructional videos on Quicken!