Guide
Connecting QuickBooks Online to ClearDeposits
How the QuickBooks Online connection works: what ClearDeposits reads, what it writes, how to connect, disconnect and reconnect, and where to get help.
Work in progress. Posting straight into QuickBooks Online is awaiting Intuit's approval of the ClearDeposits app. Today a closed month leaves ClearDeposits as a journal-entry file that QuickBooks Online's own import takes in (Settings, Import data, Journal entries). This page describes the connection as it will work the day it is switched on; the file stays available either way.
What the connection is
ClearDeposits keeps its own balanced record of your Stripe activity, and nothing reaches your books without your approval. Connecting QuickBooks Online means that when you approve a month at Post and Close, the journal entries in that month's posting plan are sent to your QuickBooks company, and the month closes once QuickBooks confirms every one of them.
What ClearDeposits reads from QuickBooks
- Your company's name, its home currency and whether multicurrency is on.
- The date your books are closed through.
- Your chart of accounts: each account's name, type and detail type.
- The names of your customers and vendors, to find the one that stands for Stripe. No transactions.
That is all. ClearDeposits does not read your invoices, payments, bills or any other transaction in QuickBooks.
What ClearDeposits writes to QuickBooks
- Journal entries only: the ones in a posting plan you approved at Post and Close.
- Each is numbered CD- and part of its ClearDeposits id, and its memo names the Stripe document behind it.
- If QuickBooks has no customer named for Stripe, ClearDeposits creates one, named "Stripe Customer", once. Likewise a vendor, named "Stripe", for Accounts Payable lines.
ClearDeposits never changes or deletes anything already in your QuickBooks company. Apart from that customer and vendor, it never writes outside Post and Close.
Before you connect
- Sign in to QuickBooks Online as a company admin; connecting an app needs that role.
- The company's home currency must be US dollars with multicurrency off. ClearDeposits says so and stops otherwise.
- Have your chart of accounts in order: ClearDeposits matches each account by QuickBooks' own account ID, then by full name and type, then by name and type. Account numbers are not used.
Connect
- In ClearDeposits, open Accounting and Mappings from the sidebar.
- Press Connect to QuickBooks. Intuit's own sign-in opens; ClearDeposits never sees your Intuit password.
- Choose the QuickBooks company and press Connect. You return to Accounting and Mappings, connected.
- ClearDeposits reads your accounts in the background and shows each role beside the QuickBooks account it matched. Approve the mappings once.
An account with no match, or several, is listed. Add or rename it in QuickBooks, or choose another in ClearDeposits, then press Check accounts again.
Post and Close
Open the month's posting plan and press Post and Close. The first screen lists anything QuickBooks would refuse, so you fix it before anything is sent. Enter the code emailed to you. The month shows as closing while the entries go out, and as closed once QuickBooks has confirmed every one. If QuickBooks refuses an entry, the month stays open, the refusal is shown in QuickBooks' own words, and you send it again once it is fixed.
Disconnect
From ClearDeposits: Accounting and Mappings, then Disconnect, confirmed on screen. From QuickBooks: Apps, My apps, then Disconnect beside ClearDeposits. Either way ClearDeposits asks Intuit to revoke its access and erases the tokens it holds. Entries already in QuickBooks stay there; they are your record.
Reconnect
If the connection lapses, after about a hundred days without use, or after a disconnect inside QuickBooks, every page says QuickBooks needs reconnecting. Press Reconnect, sign in to Intuit, and choose the same company. Entries that waited go out on their own. A different company is refused once anything has been posted; create a new ClearDeposits workspace for it instead.
Your data
The tokens Intuit issues and your company's identifier are stored encrypted, never shown and never logged. What is read and written is set out in the Privacy Policy and the Terms. ClearDeposits is not affiliated with or endorsed by Intuit Inc.; QuickBooks is a trademark of Intuit Inc.
Help
Email hello@cleardeposits.com. If ClearDeposits showed a Reference, include it: it lets us find exactly what happened, including the identifier Intuit assigns to every request.
Questions about the connection?
Email hello@cleardeposits.com and a person answers.