did transfer from QBO to QBDT

I’ve got your back, lrh.

Let me share information about your concern with running cash basis reports in QuickBooks Desktop (QBDT).

When migrating from QuickBooks Online (QBO) to QuickBooks Desktop (QBDT) there may be some discrepancies we might expect. One of these is running reports. We can utilize the reports to compare if all data are copied successfully. In this, I want to show what report discrepancies we can expect:

• Cash basis — QuickBooks Desktop and QuickBooks Online don't track transactions as paid the same way. Reports may not match using a cash basis.
• Inventory — Reports might not match because QuickBooks Online and QuickBooks Desktop calculate inventory differently.
• Multi-currency — Transactions with 3 different types of currencies don't convert to QuickBooks Online.

Since you’re missing two vendors when running a Profit and Loss report on Cash Basis this is because the two programs track differently with paid transactions. This means that in QBDT when you paid the bills, the transactions will then be shown on the P&L report on Cash Basis.

Moreover, to ensure that everything was migrated successfully, you’ll want to run and compare your financial reports. In case you think that there is missing information, you can manually import them using a supported file to QBDT.

I also added this article to know what to expect when converting to QBDT: Learn how features and data move from QuickBooks Online to QuickBooks Desktop.

Feel free to leave a comment if you have more questions about moving your QBDT file to QBO. The Community always has your back. Have a good one!

thanks for helping but the wrong way

i left QBO to go to QBDT   

need to know whats missing when i import bills in QBDT   so that my bill show up when i choose cash report basis for profit and loss reports

BY THE WAY WE ARE A CASH BASIS COMPANY

so my reports have to be in cash basis

Let me help you with your concern about Profit and Loss report not showing all the transactions for cash basis, @lrhmail451.

There are a few things you can try to fix this problem if you discover that your income and expense transactions are missing from your profit and loss report.

How the accounting basis is set for the Profit and Loss report should be examined first. Invoicing on a cash basis versus an accrual basis differs in how you choose the date for reporting income or expenses.

With bills and bills payment, the expense is tracked by the bill.

You can check this article to know what to consider in troubleshooting missing transactions: Why are my income and expense transactions missing from my Profit and Loss report?

I'm also adding this article for future reference in customizing reports in QuickBooks Desktop: Customize reports in QuickBooks Desktop. You can add some details you need to show in your report.

Let me know if you need additional assistance in running Profit and Loss report. I'm always here to help. Have a great day.

some how everyone is missing the boat

i get how income and expenses work for accounting

but there is something that the system is tracking to get it in the right spot

last night i did a test     i took two bills and posted them manually in the system with the same dates and then i paid them manually and they showed up in the cash report basis

there are too many for me to manually key all what i need in the system 

why the manually input of bills and payments shows up but when i do the import of bills and payments they do not show up

there has got to be something on the templete that i am not getting right or not toggling

it has to do with how the templete is recording the transaction   (i am missing something)

if i could only export a bill out of QBDT then i could see what that templete has compared to what i am doing on my templetes that i am importing

did some more testing

it seems that because these were put in with trnstype BILL

it has to be paid by trnstype Bill Pmt-Check and all is good

my templete says     Bill Payment (Write Check Against AP)

but it goes in as trnstype Check 

its there another templete that the trnstype for payment is Bill Pmt-Check

i could have this one company fix and get to 3 others if i can just get the right templetes to post my transactions

this is what i get

Thanks for sharing detailed information about your concern, @lrhmail451.

Let me help share some steps on how your bills and payment will show up in your Profit and Loss report.

The difference between cash basis and accrual basis reporting is how the date is determined for reporting the income or expense. Please note that the cash basis report will use the bill date.

In your case, since it shows Bill Payment (Write Check Against AP), you'll need to edit your IIF file. Then enter the correct information in the file.

Here's how:

1. In Microsoft Excel, go to File and select Open.
2. In the File type dropdown, select All Files.
3. Select the IIF file you want to edit, then select Open.
4. In the Text Import Wizard, select Next, then Next, and Finish.
5. Make the changes to your IIF file.
6. Go to the File menu, select Save, then Yes.
7. Exit Excel. You'll get a prompt to save the IIF again. Select Don't Save.

Once done, you can import the file again. Before doing so, make sure to create a backup to restore your data in case you run into problems. For complete details see this article: Export, import, and edit IIF files.

Also, to fix the template you use, we can run the Verify and Rebuild Data utility. The tool scans data issues within the file and self-resolves them.

I've also included an article that'll help you check the complete list of workflows and other vendor-related transactions:  Accounts Payable workflows in QuickBooks Desktop.

Keep me posted if you have any other concerns or follow-up questions. The Community always has your back.

ok after being on the phone for 5 hours it has come done to this

QB will not let you import payments that toggles the bill it goes with so that the payment and bill show to the system they are completed

this is the reason my payments does not show up on cash basis and show up when you use accrual basis

all the payments i put in by import will have to clear with a bill in order to show so now since QB does not allow importing payments with (bill pmt -Check) any more i have to manually go in and use the credit that was created by each check that i imported to the system

we are talking about thousands of entries           thanks so much QB    way to make our jobs easier

because you do not have a way to get a file to turbo tax for QBO users to do taxes and when we transfer over to use QBDT and all transactions are not complete or migrate over like they need to we are stuck with your  software QBO or QBDT that does not work!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!