Sync with QuickBooks Desktop: At a glance

This article will give you an overview of how our sync with QuickBooks Desktop works. If you are looking to set up your sync, please check out the sync setup article linked at the bottom of this page.

J.P. Morgan Digital Banking Cashflow360 utilizes the Bill.com Sync Dashboard to transfer information between J.P. Morgan Digital Banking Cashflow360 and QuickBooks Desktop.

Accounts without 2-way bill sync enabled

Accounts with 2-way bill sync enabled

If you've enabled 2-way bill sync:

With each sync, J.P. Morgan Digital Banking Cashflow360 picks up changes made in QuickBooks to:

• Accounts
• Departments (called Classes in QuickBooks)
• Vendors
• Bills (if 2-way bill sync is enabled)
• Jobs (called "Customer: Jobs" in QuickBooks)
• Bank Balance - shown when paying bills
• Customers
• Invoices (new and edited invoices)
• Items

QuickBooks picks up any changes made in J.P. Morgan Digital Banking Cashflow360 to:

• Accounts
• Departments (called Classes in QuickBooks)
• Vendors
• Bills
• Billable expenses
• Bill Payments
• Vendor Credits
• Funds Transfers
• Customers
• New invoices
• Invoice payments

Things to know

Payables without 2-way bill sync enabled

• We recommend creating all bills, vendor credits, approvals, and payments in J.P. Morgan Digital Banking Cashflow360
• Edits made in QuickBooks for bills, vendor credits, approvals and payments won't sync to J.P. Morgan Digital Banking Cashflow360

Payables with 2-way bill sync enabled

Creating and editing bills in QuickBooks Desktop will sync to J.P. Morgan Digital Banking Cashflow360. Creating and editing bills in J.P. Morgan Digital Banking Cashflow360 will sync to QuickBooks Desktop.

• We recommend creating all vendor credits, approvals, and payments in J.P. Morgan Digital Banking Cashflow360
• Edits made in QuickBooks for vendor credits, approvals and payments won't sync to J.P. Morgan Digital Banking Cashflow360

Receivables

• On accounts created before June 5, 2020, invoice status and amount due on invoices in QuickBooks Desktop will sync to J.P. Morgan Digital Banking Cashflow360. Please contact Customer Support if you'd like to disable it.
• Invoices can be created in either QuickBooks or J.P. Morgan Digital Banking Cashflow360
• Invoices created directly in J.P. Morgan Digital Banking Cashflow360 can be edited until the invoice syncs to QuickBooks
  • After the sync, invoices can only be edited in QuickBooks
• If creating invoices in QuickBooks, select To be emailed for each invoice. You can then select these invoices to email within J.P. Morgan Digital Banking Cashflow360.
• Partial payments should be applied to an invoice before applying credit memos
• QuickBooks picks up new invoices entered in J.P. Morgan Digital Banking Cashflow360 and payments received via J.P. Morgan Digital Banking Cashflow360. J.P. Morgan Digital Banking Cashflow360 picks up any changes to invoices and customers from QuickBooks.
• The date the sync is connected is considered the sync start date for AR invoices. If your sync was connected on Apr 1, 2019, only AR invoices with invoice dates of Apr 1, 2019 or later will sync into J.P. Morgan Digital Banking Cashflow360, no matter the creation date.
  • Any invoices dated before Apr 1, 2019 won't sync from QuickBooks to J.P. Morgan Digital Banking Cashflow360, and Customer Support can't force them over
  • If you manually create those invoices in J.P. Morgan Digital Banking Cashflow360, they'll try to sync to QuickBooks, and there will be a duplicate error if the invoice already exists in QuickBooks. Delete the invoice in QuickBooks and let the newly created invoice in J.P. Morgan Digital Banking Cashflow360 sync to QuickBooks.