Ideally would process in normal work-flow in each of system, that is parallel.
Instead of Parallel Run after Conversion from QuickBooks Desktop to QBO - QuickBooks Online -
is there any short-cut possible, like ONLY input in Desktop but then export from Desktop the Customer Invoice, Receipt, Bill, and Vendor Payment. And import into QuickBooks Online.
Anyone familiar with such tools, and process, so that both are in sync.
I'm happy to see that you're interested in transitioning from QuickBooks Desktop to QuickBooks Online. Having the flexibility to work from anywhere using cloud technology will certainly benefit your business. I can shed some light on your options for converting from Desktop to Online.
If you've already converted your QuickBooks Desktop data to QuickBooks Online, that's great. If you need guidance on how to complete that process, see our Community article Migrating from QuickBooks Desktop to QuickBooks Online. You'll want to do this before importing any other items into QuickBooks Online, as the migration can only be performed while the company is still empty or it can cause issues to occur. Then the historical data will be moved and it'll only be the data entered into QuickBooks Desktop during the test period that you'll need to manually import to QuickBooks Online.
It sounds like you're looking to export customer and vendor transaction data into your QuickBooks Online after inputting it into QuickBooks Desktop. This can be done by exporting data from QuickBooks Desktop into an Excel or CSV file format, and then importing those files into QuickBooks Online. To export data from QuickBooks Desktop to CSV format:
- Open the Customer/Supplier Centre.
- Select the Excel drop-down, then choose:
- Export Customer/Supplier list if you want to export customer/supplier data such as name, balances and contact information.
- Export Transactions if you want to export transactions (either by name or transaction type).
- In the Export window, choose Create a comma separated values (.csv) file.
- Select Export.
- Assign a file name, then choose the location where you want to save the file.
- Locate, open, and edit the file as needed.
For more information on exporting data from Desktop to CSV or Excel, see our Community articles Import/export CSV files and Import or export MS Excel files. Once you've completed those steps, you can then import the data into QuickBooks Online. The steps are:
- Sign into your QuickBooks Online company file.
- Click the Gear icon, then under Tools select Import data.
- In the Import data screen, select which type of data you are trying to import (based on your description, it sounds like you will be importing Customers, Invoices, Suppliers, and Bills. Please note that you have to import each of these separately).
- The next screen prompts you to browse for the applicable excel or CSV file. There is also a link to download a sample file. I recommend taking a look at that file so that you can see what information is required by QuickBooks Online.
- After selecting the file, follow the prompts to map the fields in the file to the corresponding fields in QuickBooks Online.
- Once that's completed, confirm that the data looks correct in the preview screen and complete the import.
Your invoices and other data from QuickBooks Desktop and QuickBooks Online will now be in sync. If this doesn't quite hit the mark, or if you need any further clarification please reply to this thread!
Thank you for your detail message.
I was able to import Bill, into QuickBooks Online. I don't find Vendor Payment option in import.
Also I can import Invoice, but no customer payment.
Another piece I'd like to import is Pay Cheque from Desktop to Online - HOW ? Please note I do not have Payroll subscription on my QuickBooks Online. We do payroll on Desktop.
I'm glad that the previous message was helpful for you. Let's ensure that we get all the necessary data imported into your QuickBooks Online company file.
Importing the vendor and customer payments will be a bit different than the process to import invoices and bills. After importing your invoices and bills, you'll need to import an Excel/CSV file containing bank transactions for the previous business activities. Once all the bank transactions are imported, you can then match them to the appropriate bills and invoices. The system then records the bill payments and invoice payments upon matching.
The steps to retrieve the business's bank transactions are:
- Sign in to your bank or credit card’s website.
- Look for and follow your bank’s steps to download transactions. Every financial institution has different steps.
- Check the date range for the download. You'll want to include the dates for all the invoices and bills that were imported to QuickBooks Online from QuickBooks Desktop.
- Download your transactions. Save the file somewhere you can easily find it, like your computer's desktop.
Once you have your bank transactions, you'll need to import them into QuickBooks Online's bank feed. Here's how:
- In QuickBooks Online, go to the Banking/Transactions menu. Then select the Banking tab.
- Select the Link account dropdown menu and then Upload from file.
- Select Browse and then select the file you downloaded from your bank. Then select Next.
- In the QuickBooks account dropdown, select the account you want to upload the transactions into. Then select Next.
- Follow the onscreen steps to match the columns on the file with the correct fields in QuickBooks. Then select Next.
- When you’re ready, select Let's go.
You'll then have bank transactions in your bank feed. Once this is complete, you should notice some of the transactions showing "matching records" as the bill and invoices were imported before. You'll then need to match the transactions to those forms by:
- Find a downloaded transaction with the Match option in the Action column.
- Note the Date, Description, Payee, and amount spent or received.
- Select the downloaded transaction to expand the view.
- Review the Matching records found. This is the possible matching transactions (invoices or bills) you already entered in QuickBooks.
- Select the link next to each match to get more details.
- Make sure this is the correct match. In particular, review the Deposit to, Payment method, and Bank account fields on forms for the existing transaction in QuickBooks.
- If this is the correct match, close the open transaction.
- Select Match.
Once you click Match, the system will generate an invoice or bill payment based on the transaction. I've linked the following Community articles for further reference if needed:
- Manually upload transactions into QuickBooks Online
- Categorize and match online bank transactions in QuickBooks Online
QuickBooks Online doesn't have the ability to import pay cheques from QuickBooks Desktop. Normally when switching from Desktop to Online, year-to-date amounts for employees are entered within the payroll module. I know you're not using payroll in QuickBooks Online so for these transactions, you may need to consult an accountant to determine how to record the past pay cheques via journal entries. This is because you may need to set up different payroll expense and liability accounts in QuickBooks Online to properly record the pay cheques. If you're not already connected to your accountant in QuickBooks Online, you can invite them to view your books by going to the My Accountant tab and entering their email address to send an invite. If you don't have an accountant, you can click Find a pro to help to search for a QuickBooks Certified Pro Advisor who can assist you.
I hope this helps, please let me know if I can clarify anything or assist you further.
You need an importer tool to import some transaction types (e.g Bill Payment, Receive Payments)
The template should be like these
|RefNumber||APAccount||Vendor||TxnDate||Bank or CC Account||PrivateNote||Currency||ExchangeRate||ToBePrinted||BillApplyTo||LineAmount|
|3454||Green's Taxi Service||01/11/2020||Checking||Bill Payment||N||185||125,13|
|321901||Federal Express||01/11/2020||Checking||Bill Payment||N||201||264,07|
|2||28/11/2020||4908||Leonard Walker Inc||Check||Checking||102||138,78|