Connect QuickBooks Online or Xero
Part of the Accounting package. Connect QuickBooks Online or Xero so deals, payments and commissions flow into your accountant's books.
Connecting QuickBooks Online (also called QBO) or Xero is part of the Accounting package. Once it is connected, LeaseDash sends the money from your deals into the books your accountant already uses, so nobody types it in twice. It works one way: LeaseDash sends records to QuickBooks or Xero. It only reads your list of accounts, items and customers, and it never deletes anything you already have there.
Before you start
- The Accounting package must be on for your agency. It is included on the Agency plan, it is a monthly add-on on Team, and it is not available on Solo. See What the Accounting package is and what it includes.
- You need permission. Admins have it by default. Anyone else needs the permission called Connect accounting software (QuickBooks, Xero), which an Admin can give them. If you cannot see the Accounting software panel in Settings, ask an Admin.
- You need to be signed in with two-step sign-in. See Turn on two-step sign-in.
- You need a QuickBooks Online or Xero login that is allowed to add apps to your company. That is usually the owner or an administrator of the company on their side.
Connect your accounting software
- Open Settings and find the Accounting software panel. Press Open accounting software. (If your agency has not added the Accounting package yet, the same button says See the add-on.)
- On the Accounting software page, press Connect QuickBooks Online or Connect Xero. The button says "Opening..." for a moment.
- Your browser goes to Intuit's page (for QuickBooks) or Xero's page. Sign in there with your QuickBooks or Xero login. You sign in on their page, so LeaseDash never sees your password.
- Choose the company (QuickBooks) or the organization (Xero) you want to send to, then approve the connection. Pick one. If you have several, choose the one your accountant uses for this agency.
- You land back in LeaseDash with the message "Connected. Next, choose what to send and which accounts to use." The company's name shows on a new card with a Connected tag. If it is the wrong company, disconnect (see below) and connect again.
The sign-in link is good for 10 minutes. If you take longer, start again with the Connect button.
Each agency can have one QuickBooks Online company and one Xero organization connected at a time. Sync with FreshBooks, Zoho Books and Wave is coming soon (their cards are marked Coming soon).
If the Connect buttons are greyed out and say "Not set up on the server yet.", or the page says "Accounting sync isn't set up yet. Ask LeaseDash support.", the connection to QuickBooks or Xero is not available yet. That is not something you did wrong and you cannot fix it from your side. Contact LeaseDash support, say which program you want (QuickBooks Online or Xero), and we will turn it on.
Choose what is sent
Nothing is sent until you choose it. Everything starts off. On the connection's card, under What to send:
- Send records from: pick the first date to send. It starts at 30 days before you connected. Older deals are not sent.
- Closed deals: choose Don't send, Send as invoices, or Send as sales receipts (paid in full). Only closed deals from that date with at least one customer line are sent. In Xero, a sales receipt becomes an invoice plus a payment for the full amount.
- Tick any of these you want: - Customer payments (card, cash, check, Zelle). This needs closed deals sent as invoices, because a payment is applied to its invoice. LeaseDash tells you if the two do not match. - Amounts you owe dealers, as bills - Rep commissions, as bills
Choose the accounts (account mapping)
Next to it, Which accounts to use lists one choice for each thing you turned on. Pick the matching account from your own QuickBooks or Xero list:
- Car deal income and Fees and charges income. In QuickBooks you pick an item. In Xero you pick an account. Deal lines that read like fees (registration, documentation, taxes, delivery and similar) go to the fees choice. Everything else goes to car deal income.
- Money goes into, for sales receipts.
- Card payments go into, and Cash, check and Zelle go into, for payments.
- Amounts owed to dealers and Rep commissions, which are expense accounts.
If the lists are empty, or you just added a new account in QuickBooks or Xero, press Refresh accounts. A line reading "Still to choose" tells you what is missing. Press Save choices when you are done. Sync now saves for you first.
How often it syncs, and Sync now
- Automatic: LeaseDash checks every connection about every 6 hours and sends anything new or changed. It only does this for connections that have something chosen to send.
- Sync now: press Sync now on the card to send straight away. A message tells you how many were sent and how many failed. The button is turned off while a choice needs fixing or the sign-in has ended (press Sign in again, see below). If a sync is already running, wait a minute.
- Big backlogs: one sync sends up to 300 of each kind of record and stops after about a minute and a half. The message says how many are left, and the next sync carries on.
- Nothing goes twice. Each record is sent once. If you change a deal or bill in LeaseDash afterwards, the change is sent as an update. A payment cannot be changed after it is sent, so LeaseDash skips it and says so in the log. Change or remove it in QuickBooks or Xero.
The card also shows Last sync and the last 24 hours as "sent, failed, skipped".
The activity log
The Sync log at the bottom of the card has one line for each record that was sent, failed or skipped. It shows When, What (the kind of record, the amount and the car), Result (Sent, Failed or Skipped) and Details in plain words. Use Show to see only one result and Type to see only one kind of record. Lines are kept for about 13 months. They do not show customer names.
What goes across, and what does not
Goes across:
- Closed deals, as invoices or sales receipts, with each line, the date, the car and a reference number starting LD-.
- Customer payments, applied to their invoice.
- Amounts you owe dealers, and rep commissions, as bills.
- Customer, dealer and rep names (and customer emails), only so the invoice or bill is filed under the right contact. LeaseDash looks for an existing contact by email, then by name, and adds one only when it finds none.
Does not go across:
- Anything you did not turn on, and anything before Send records from.
- Card numbers, bank details, notes, documents and photos.
- Your bank connections and the rest of your LeaseDash books.
- Anything coming back. LeaseDash does not copy changes from QuickBooks or Xero into LeaseDash.
When something goes wrong
- One record fails. It is logged as Failed with a plain reason, such as "The accounting software refused this record. Check the account choices in the mapping." The rest still go, and the failed one is tried again at the next sync. The card shows how many could not be sent.
- Skipped. A payment is skipped until the deal it belongs to has been sent. Send closed deals as invoices first.
- Slow down. If QuickBooks or Xero asks LeaseDash to slow down, the rest goes in the next sync.
- The sign-in ended. The card turns yellow, says what happened and shows a Sign in again button, and syncing stops until you press it. This happens if you remove LeaseDash inside QuickBooks or Xero, or the sign-in goes unused for a long time. See Sign in again below.
- Needs attention. Open the card and read the message at the top. It names what to fix, for example an account that still needs choosing.
Sign in again
If the card says the sign-in ended, or Needs attention, press Sign in again. You can also press it any time on a healthy card (it is the quiet button next to Refresh accounts), for example before your accountant's year-end.
- Press Sign in again on the card.
- Sign in on the QuickBooks or Xero page and approve, the same way as when you first connected.
- You land back in LeaseDash with "Signed in again. Your sync history and choices were kept."
It is the same connection, so nothing starts over: the sync log, your What to send choices, your account choices and the list of what was already sent are all kept, and nothing is sent twice. Only the sign-in itself is replaced. Syncing carries on at the next sync, or press Sync now. You need the same permission as for Connect.
Sign in to the same QuickBooks company or Xero organization as before. If you sign in to a different one, LeaseDash refuses and leaves your connection as it was. The message reads "That's a different QuickBooks company. Sign in to Summit Lease Partners, or disconnect first to switch companies." It shows your own company's name. To really switch to another company, disconnect first (see below), then connect the new one.
Disconnect
- On the connection's card, press and hold the "Hold to disconnect" button until it fills. On a keyboard, hold Enter or Space. If you cannot hold, focus the button and use the Confirm button that appears.
- LeaseDash tells QuickBooks or Xero to end the sign-in, then forgets the sign-in, your account choices and its list of what was already sent.
What was already sent stays in QuickBooks or Xero. The activity log stays too. You can also remove LeaseDash from inside QuickBooks or Xero.
LeaseDash forgets what it sent when you disconnect. If you connect again, it treats every deal as new. Before you sync, set Send records from to a date after your last send, or you may get duplicates.
Troubleshooting
- I do not see Accounting software in Settings. You may not have the permission (ask an Admin), or the Accounting package is not on for your agency. See What the Accounting package is and what it includes.
- The Connect buttons do not work. See the note under the connect steps and contact LeaseDash support.
- "That sign-in took too long." Press the Connect button again and finish within 10 minutes.
- "The accounting software was not allowed to connect." You chose not to allow it, or your login cannot add apps. Try again and approve it, or ask the company's owner.
- "This agency is already connected to a different company." Disconnect the current company first, then connect the other one.
- "That's a different QuickBooks company." (or Xero organization) You pressed Sign in again but signed in to another company than the one on the card. Press Sign in again once more and choose the company named in the message. Nothing was changed. If you want the other company instead, disconnect first.
- The company or organization is wrong. Disconnect, then connect again and choose the right one on QuickBooks' or Xero's page.
- Sync now is greyed out. Fix the message on the card (for example, payments need invoices). If the sign-in ended, press Sign in again.
- Nothing was sent. Check that Closed deals or another box is turned on, that the deal closed on or after Send records from, and that every account is chosen.
- I need to sign in again. Press Sign in again on the connection's card. You do not need to disconnect, and you keep your history, choices and the list of what was already sent.