Connections

Connections

Connections is everything these books work with, in one list: your bank and cards, online invoice payments, payroll, other accounting programs coming in, QuickBooks Desktop going out, a full download, your own software and AI, and your store if the company runs one. Open it from the Connections item of the menu.

All connections and My connections

  • All connections is the catalog, for finding and adding. Each row says what the connection does, and a solid chip on the right says where it stands right now: Connected, On, Off, Not connected or Not available yet. Connect opens the setup right in the row, with no trip to another page. The search box and the category chips (each counted) narrow a long list. The help link on a row opens its article in this guide.
  • My connections is what this company has switched on, each row saying what it is doing right now. Manage on a connected row in All connections takes you there, and so does a link from another screen (Banking's Map accounts, say). Something you just connected moves there by itself.
  • It stays where you left it. All or My connections and the category chip you picked are remembered on your sign-in: a reload, clicking Connections again or another computer opens the same list.

Reading a row in My connections

Each row leads with its name and a chip: Connected or On in green, or amber when it needs you (Sign in again). Under it:

  • What it is doing, as a few small tiles. The bank row shows Banks (the banks that feed these books), Accounts pulling (how many of your bank and card accounts pull, and how many are not matched yet), Last pull (with how many lines wait in For Review) and Next pull (or "When you press Pull now" while automatic pulls are off). Back to QuickBooks Desktop shows its Last batch, whether every batch is In QuickBooks, and how many were Sent so far. The import from QuickBooks Desktop joins My connections once this company has used it, and shows its Last import (the day and how many entries), the History it brought (from its first year to the cutover date), that it Matched to the penny against QuickBooks, and the Web Connector. Until the import is used it is only on All connections, under Import.
  • The one thing that needs you, as an amber or blue band with its button: a bank that wants you to sign in again (Reconnect), accounts not matched yet (Map accounts), the account list not read yet, lines waiting in For Review (Review them), a QuickBooks batch not marked imported, or an import from QuickBooks that was started and not finished.
  • Buttons that do the work. On the bank row: Pull now (the pull window, the same as on Banking), Map accounts (which account at the bank feeds which account here), Schedule (when and how often it pulls by itself), Banks (connect another bank, sign in again, remove one, or pick the connection these books pull through) and Open Banking. Each opens in a window of its own and the row stays where it is.
  • Show details opens a row's full settings right under it, and Hide details closes them; the words beside it say what is inside. When a chip or the search leaves a single row, its details open by themselves; Hide details still closes them.

If you use Portfolio (under Bonus), a section Your own keys, for Portfolio lists your market data and broker keys and where each stands: the key's last four characters and, for brokers, how many are connected. Change key opens the keys window on that key (add, test, replace or remove it) and Open Portfolio goes where the key is used. The keys are yours, not the company's: the same in every company you open, and nobody else sees them. See Portfolio and watchlists.

Switches inside a row (Allow import, Allow export) take effect when you press Save at the top of the screen. If you leave with unsaved changes, you are asked first.

Bank and card feeds

One bank connection serves every company you open. Before anything is connected, Connect on the Bank and card feeds row (All connections) opens the setup in the row. Where TaDa Books offers it, Connect a bank connects in one click: pick your bank in the window that opens and sign in there, with nothing to set up anywhere else, and these books use the connection at once. The setup lists each connected bank with when it was last read, Reconnect for one that asks you to sign in again, and Remove; the chip beside the button says how many of your plan's bank logins are in use, and an extra one past them is billed monthly (the button says so first). Or use your own connection service below it keeps the other way: your own SimpleFIN, paid to them, pasted in once. When TaDa Books offers no one-click connection, Connect a bank opens that way instead. Manage bank connections opens your saved connections, their limits and removal. Rather not connect? Banking takes your bank's statement files too.

Once connected, the row moves to My connections and opens Map accounts for you, since matching the accounts is the step that decides where the money lands. From then on, the row's buttons:

  • Banks: the connected banks (Connect another, Reconnect, Remove) and This company: which of your saved connections these books pull through, or No bank connection (statement files on Banking only).
  • Schedule: turn on Pull automatically and the first opening of the books after each check time pulls quietly in the background; Pulls per day checks two, three or four times a day instead, spread evenly. A check spends a request only when no fresh read exists yet, and one read serves every company on the connection. New banking day starts at is the hour, in the company's own timezone, from which a fresh bank read counts as today. Banks usually finish their overnight posting by 3:00 AM local time; set it later for a bank that posts late. The same hour on your own clock is shown beside it.
  • Map accounts: one row per bank or card account in these books (searchable and paged), the account at the bank that feeds it, whether it pulls at all (Pulls?: Excluded takes bank files only), and the Connection used (normally Same as the company). One account at the bank feeds one account here, so one already linked elsewhere is not offered. + Employee cards (or sub-accounts) joins extra cards to one account's feed. Refresh from the bank brings in banks or accounts you connected since the last read, and re-reads the last 45 days for every company on the connection. The band at the top counts the service's daily requests used; transaction pulls stop short of the limit so the account list can always still be read.
  • Pull now: the pull window, the same one Banking's Pull opens.

Bank connections, in your profile menu, is the page for the connections themselves: they belong to you, not to one company, and every company you open can pull through them. Add connection service walks through the three steps (an account at the service, your banks connected inside it, then the setup token pasted here; the token works once and is stored encrypted). Each connection shows how many pulls it used today, which companies use it (with Map accounts beside each, opening that company's Bank and card feeds), Limits (pulls per day and connected banks, never past what the service allows) and remove, which switches the companies using it back to statement files.

Categorizing, rules and statement files are in Bank feeds and statements.

Online invoice payments

A pay button on your emailed invoices: the customer pays by card or bank transfer straight into your own payment account, and each payment records itself against the invoice. See Invoices and getting paid.

Payroll from any provider

A payroll provider's report becomes one balanced journal entry per pay date, with the mapping remembered per provider. See Payroll import.

Coming in from another program

  • QuickBooks Desktop: every company and every year of history, checked to the penny against its trial balance, straight from QuickBooks through its Web Connector (no files to export) or from exported reports. Allow import turns the import on for this company. See Import from QuickBooks. After an import, the card can also offer Recognise as sales tax: when the imported invoices carry a line on a sales tax account, that amount becomes each document's sales tax (net of what credit memos gave back), so it reaches your sales tax returns.
  • Xero, Wave, QuickBooks Online and spreadsheets: any journal export as CSV or Excel (switch on Moving in from another system under Beta features first). See Import from a spreadsheet.

Sync to QuickBooks Desktop

For a company that keeps QuickBooks Desktop up to date with these books, whether for a while as you get to trust TaDa Books or for good. The switch beside its name says where it stands: green On, grey Off, and the question mark beside it says what each does. Under All connections, press the grey switch (or Turn on in its details) to start; on My connections, press the green one to stop. Either way it asks first, then takes effect at once. Turning it off keeps everything: batches already made stay, nothing already in QuickBooks changes, and turned on again it carries on where it stopped, so nothing is sent twice. It sends what you post here to QuickBooks by the Web Connector each time you click Update Selected, or by batch files (one .iif file each), and nothing ever goes twice.

Opened, the row leads with one line saying what to do now: names to answer first, entries waiting (with Generate batch beside it), a batch ready to import, or that QuickBooks is caught up (with Check now). Guide me sits on the same line. Three tabs keep the rest apart: Connect QuickBooks (the Web Connector, see below), Check against QuickBooks, and Batch files for a computer that cannot run the Web Connector: every file made so far, with What the next batch carries opening on demand (by itself when a name must be answered first). The row opens on the tab that matters now.

On the QuickBooks row itself, the tiles stay on one line. Once the Web Connector is connected, old batch files drop off the row; they come back only while a batch still waits to be imported. Sent to QuickBooks counts every entry that went over, both ways: so many by the Web Connector, so many by batch files. Times on the row and in the Web Connector's band read like "Today, 9:04 AM PST", in the company's own time zone.

With the Web Connector connected, what waits for QuickBooks is sent by the send wizard at the top of Connect QuickBooks: one list, every line ticked, one button. A company with the Web Connector does not need batch files: the wizard also corrects entries brought over from QuickBooks and changed here, and sends customer payments and bill payments recorded as journal entries (the bank against Accounts Receivable or Accounts Payable) as real QuickBooks payments on their invoices and bills. If QuickBooks does not hold the bank account they were paid into or from, the line says so. Before an entry goes, every account, class, customer and vendor it names that QuickBooks does not have yet is added there first, the same way a batch file adds them. A name that came from QuickBooks and was renamed here before names were remembered is never added (QuickBooks has it under its old name): answer it on Names QuickBooks knows first. An entry QuickBooks refused is never offered again as if nothing happened. If the name it lacked now goes first, the line says so and it goes again. Otherwise it waits under Waiting for you, with QuickBooks' reason and what to do: change it here, or fix it in QuickBooks and press Read QuickBooks again (under Details). When QuickBooks refused it over a fault in our own request, nobody needs to do anything: the result line says "a fault on our side, now fixed", and it goes again by itself, once, the next time you click Update Selected. It is never sent to a batch file. What waits is said one way. Under the list, the wizard names what is not in this send: what waits for you (in the Waiting for you table above the list, each line with what to do, refusals and name questions included); what goes right after another line has gone (a payment after the invoice or bill it pays: it shows up in the list then); what only a batch file can send (counted in entries, each once, for the batch file guide that comes before the check); and what stays here because the Web Connector does not send it (an estimate in a foreign currency, for example). Each line's own reason is under Details. The check against QuickBooks is the wizard's last step. While something can still go, the wizard says to send it first: the check runs again after every send. Once nothing is left to send, the last step says QuickBooks matches these books, or how many differences it found, and the next step lists what Fix all does about them (see Fix what differs below). While QuickBooks takes a send, the tab counts it as it goes: so many of so many done, how many went in, how many QuickBooks refused (and why), how many are still to go. Afterwards it says what the last send did in one line, for example "40 went in, 2 refused". An entry that waits for a name question you must answer shows Answer the question, which opens Names QuickBooks knows. A name QuickBooks already has under exactly the same name is never asked about: the Web Connector's read of QuickBooks settles it. Everything that only informs (each list one by one, the setup file and password, what is linked, the log) is folded under one Details. Entries that a batch file sent and that changed here later are corrected by the Web Connector too: it finds QuickBooks' copy, deletes it and adds the entry as it is now, in the same Update Selected. A customer or vendor it adds goes with its phone, email, account number and notes, so nothing follows to fill them in. Identical bills or invoices (same name, date and amount) are matched through the payment that pays each one, so they never show as a difference. What it still cannot carry (rare: an entry QuickBooks no longer holds as it came, or a kind the Web Connector does not send, each line saying why under Details) comes before the check, with how many: "Before the check: 4 entries go only in a batch file". Start the batch file guide opens the guide, which makes the file and walks you through importing it into QuickBooks one step at a time. On the Batch files tab, Guide me does the same. Either way an entry goes once: one in a batch is not offered to the Web Connector, and one the Web Connector sent never goes in a batch.

  • Guide me opens a guide that takes you through a batch one step at a time, so you never have to work out the order yourself. It opens where these books stand: at the import when a batch was made and not ticked Imported (for anyone working on the company, on any computer), at the name questions when QuickBooks would refuse a name, otherwise at Already there?: every waiting entry is compared with QuickBooks' Journal before the backup, so the file never refuses after it. Once everything waiting was compared, the step says so and Next goes on. With the Web Connector connected, Look in QuickBooks has it compare on the next Update Selected, then Look again; without it, "has anyone entered anything in QuickBooks since these books were brought over from it?" (Yes or Not sure) opens the Already in QuickBooks? check, where you upload QuickBooks' Journal. Next and the file step stay closed until everything is compared, and the step shows done only then, never for an answer alone. Then: open the right company and back it up, make the file (Make batch and save it makes the batch and saves its file; Save it again on the import step saves the same file again if it went missing), and import it with the blue Import IIF button. Tell the guide what QuickBooks said. It imported everything ticks the batch Imported and opens Link payments when a payment needs linking in QuickBooks (see below), otherwise the check. Partly imported asks for the file QuickBooks saved with the refused entries (in the same folder as the file you imported, the same name plus an underscore and numbers), explains each of QuickBooks' error notes in plain words with what the fix does about it, and Make the fixed file and save it saves a fixed file to import the same way (if a name still needs an answer, it lists it with the questions, and Try again makes the file once it is answered). A message the guide does not know is shown as QuickBooks wrote it, never guessed. It went into the wrong company shows QuickBooks' steps to restore the backup you made. I have not imported it yet closes the guide; it opens there next time. The last step is the Trial Balance check, done with two files (accrual and cash basis), which lists what usually causes a difference when the two books do not agree. The guide is done only when both match. The step bar shows green for done and blue for where you are; a grey step cannot be opened yet, and pointing at it says why (no new file while a batch is still being imported, for example). Back goes to the step before, and going back undoes nothing. Pressed It imported everything by mistake? The next screen offers Undo. If QuickBooks asks to switch to single-user mode, or the link is worded differently, the import step lists what to do.
  • Waiting to go to QuickBooks counts every entry posted since the last batch, the dates they span and the batch's total, broken down by kind. Entries that came from QuickBooks in the first place never go back. The preview button lists exactly what the next batch will carry, each entry with its lines.
  • Names QuickBooks knows: QuickBooks finds every account, class and name in a batch by its exact text, and refuses an entry whose text it does not have. So each one here remembers the name QuickBooks has, and the batch always writes that name. Rename an account here and QuickBooks still gets the name it knows. Something new is added to QuickBooks at the top of the batch, shortened to QuickBooks' limits if needed (31 characters for each level of an account or class, 41 for a customer or vendor). The Written differently in QuickBooks list shows every name that goes there under another name, and why.
  • What does QuickBooks call these?: an account, class or name that came from QuickBooks and was renamed here before names were remembered, or sits under one. Each one offers only names QuickBooks is known to have: from your QuickBooks lists when you load them, otherwise names earlier batches recorded it having. Pick one and press Save, or press Create as new to have the next batch add it to QuickBooks first, under its name here. When QuickBooks has nothing like it, the row says so and Create as new is the main button; if it might be there under another name, load your QuickBooks lists and its names appear to pick. The batch waits until each one is answered, so nothing goes over that QuickBooks would refuse. The questions cover the entries waiting for the next batch AND those in any batch not yet ticked Imported, because the wrench may still send those. Each account shows its type (and Archived here when it is no longer used), and the suggestions are only QuickBooks accounts of the same kind, each with its QuickBooks type. An answer that is another kind of account (an income account here, an equity one in QuickBooks) is refused, and a name another account already goes to is never offered. A wrong answer can be taken back with Undo in Written differently in QuickBooks. A suggestion must share the name's own words ("LLC" or "Inc" alone never counts), and when the matching QuickBooks name is already given to another account, the question says which one, so a wrong earlier answer can be found and undone.
  • Load my QuickBooks lists checks every name a batch writes against the names your QuickBooks really has, so a name it would not recognise is caught here instead of failing in QuickBooks. It is optional while the panel says Ready, and the quickest way to settle any questions. In QuickBooks Desktop choose File, then Utilities, then Export, then Lists to IIF Files. Tick Chart of Accounts, Customer List, Vendor List, Other Names List and Class List, save the file, and pick it here. Nothing in QuickBooks changes. Every name that matches QuickBooks exactly answers itself, the questions offer the closest QuickBooks names, and every batch is then checked against QuickBooks' own lists before the file is made. Load them again after you add or rename things in QuickBooks.
  • Before you import into QuickBooks: the first QuickBooks file you save (a new batch, a batch again, its names file or a fixed file) opens a small window that names the company the file is for. Tick that you backed it up in QuickBooks and understand an import cannot be undone, then press Save the file; the other files you save in the same visit do not ask again. Each download is noted in the company's activity.
  • Already in QuickBooks? is optional, and folded until you open it. You need it only if someone may have kept entering in QuickBooks after the books moved to TaDa Books. If they also entered the same things here, the next batch would put them in QuickBooks a second time. If nobody did, skip it. To check, export QuickBooks' Journal for the dates the card shows (Reports > Accountant & Taxes > Journal, then the Excel button the same way as for the Trial Balance) and press Upload Journal. The card lists each waiting entry QuickBooks seems to have already: Same means the same date, amount and account, Likely means the same amount up to 5 days apart or on other accounts. Entries a batch from TaDa Books put in QuickBooks never count. The Same ones are ticked; tick or untick, then press Leave out. Those entries stay in these books as they are, and no batch sends them. If you change or void one here later, the next batch corrects QuickBooks as usual. Left out: QuickBooks already has these lists them, with Send after all to put one back in the waiting list.
  • Generate batch downloads the file and keeps it for downloading again. If anything in it would still be refused, the batch is not made, and the panel says what to settle first.
  • On a check or a card charge, the name on each split line is the line's customer in QuickBooks, so a vendor is written only as the payee, never on the split lines. A customer you billed on a line stays on it.
  • When QuickBooks says some entries failed ("File partially imported"), it saves the entries it refused in a file of its own, with a name ending in numbers, in the folder it shows. Press the wrench beside the batch and pick that file: you get it back fixed, with the names QuickBooks knows and the missing names at the top. Import the fixed file the same way. Do not import the whole batch again, and do not delete it: the entries that went in would go in twice. The names button (the list with a plus) still downloads just the names a batch uses.
  • Corrections: an entry you already sent and then changed or deleted here goes in the next batch as a repair (a reversal, plus the new version for an edit), so QuickBooks catches up. You do nothing; the list names each one and which batch first carried it.
  • Batches lists every batch with its dates, entries, total and file. Its In QuickBooks? column shows Waiting until you click Mark imported, which you do once you have imported the file into QuickBooks; then it shows In QuickBooks with the day. The small undo arrow beside it puts a batch back to waiting if the file did not go in after all. A batch not yet imported can be deleted: its entries go back to waiting. Never delete one you did import, or the entries would import twice.
  • Entries paid from an account that is not a bank (a paycheck paid from a payroll clearing account, say) go over as journal entries, with the same lines and amounts: QuickBooks only accepts a check or a deposit from a bank account, and a card charge from a credit card account.
  • Payments and bill payments go to QuickBooks as the real thing when every invoice or bill they pay came from QuickBooks: a payment received as a QuickBooks payment, a bill payment as a check against Accounts Payable for the vendor. When the entry holding a payment also has other lines (a bank fee, a meal paid from the same deposit, a second deposit), the payment goes as a QuickBooks payment (one per deposit) and the other lines as one journal entry beside it, same accounts and amounts. The payments are written in the order that makes QuickBooks' own rule put each on its invoice here. A card, or an invoice made here, still goes as a journal entry. A payment sent as a journal entry before stays as it is: it is not sent again.
  • Link payments in QuickBooks is the guide's step after the import. With the Web Connector connected there is no need to do these by hand: the send wizard on Connect QuickBooks lists the same payments ("Move a payment") and sends them with everything else at the next Update Selected; then tick each one done here. The step says so at its top. QuickBooks applies an imported payment by its own rule (an open invoice of the same amount first, otherwise the oldest open invoices) and the file cannot tell it which invoice; a bill payment arrives as a credit for the vendor that QuickBooks never applies by itself. The list holds every payment QuickBooks put on another invoice than here, and every bill payment, with where it belongs, what QuickBooks has it as, and its steps in QuickBooks (the arrow on a row opens them). Move them in two rounds: first untick every payment on the list where QuickBooks put it, then tick each where it belongs, because two payments can each sit on the invoice the other needs. Two things to watch in QuickBooks: answer No if it asks to Automatically Calculate Payment (and Yes when it says a transaction is more than 90 days in the past), and in Pay Bills use Set Credits with the Method set to Check, or the payment is made twice. Tick Mark once a row is linked there; the tick is kept with the company, for everyone who keeps these books, and clicking it again takes it back. The list sorts, searches, prints and downloads, and the check warns while any payment is still unlinked, since QuickBooks' cash basis differs until then. One difference stays: QuickBooks' cash basis counts a payment received BEFORE its invoice's date on the invoice's date, while these books count it on the day the money came in. A year's total agrees; its months can differ.
  • How to import into QuickBooks: File, then Utilities, then Import, then IIF Files. In the window QuickBooks shows, click the blue Import IIF button: it checks the file, imports what it can, and saves any entry it refuses to a new file with a note saying why, which the guide fixes. It lists each journal entry's debits first, then its credits. The smaller link (Import it for me. I'll fix it later) keeps the written order but saves no file: it shows an Error on Line warning for each entry it skips. Click OK on each (never Cancel), note the line numbers, and type them into the guide's Fix what failed step. Back up the QuickBooks company file first, since an IIF import cannot be undone.
  • Verify against QuickBooks: with the Web Connector connected, press Check through the Web Connector, then Update Selected in the Web Connector: it brings QuickBooks' accrual and cash Trial Balance as of today and the check runs on both, with no exports. Pressing the button only asks: nothing is read until the Web Connector runs, so until then the card says Waiting for Update Selected, when the check was asked and when the Web Connector last ran, with the three steps (open the company in QuickBooks; File, App Management, Update Web Services; tick TaDa Books and press Update Selected). Cancel the check withdraws it if nobody will run it. Once QuickBooks has it, the card says QuickBooks is reading it, and the result shows by itself; coming back to the page after pressing Update Selected picks it up. The check is always the last thing QuickBooks reads in a run, after every entry and correction has gone. If the Web Connector changes QuickBooks again after a check (another send), that result is marked as older than QuickBooks and the card asks you to Check again: an old result is never shown as where QuickBooks stands. An entry a batch file sent and the Web Connector later corrected counts once, as the corrected copy QuickBooks now holds. A batch file QuickBooks already holds but nobody marked imported is counted as imported, and the check says so; it is marked imported by itself only once QuickBooks' Journal shows every entry the file wrote, with that batch's mark. Otherwise press Mark imported on it under Batch files. Accounts are matched under the name QuickBooks knows them by, also in old batch files written before an account was renamed or moved, and a Retained Earnings that QuickBooks calls by another name (Members Equity, for example) is read as the same account. When QuickBooks keeps one account here in two (an old one renamed "Net Pay DELETE" beside a new "Net Pay", or "Cash Advances to Employees" beside "Cash Advance to Employee"), the check counts them together and says so; when only the amounts say they belong together, it says "QuickBooks has 2 accounts for" that account. Curly, straight and Windows apostrophes and quotes are the same name everywhere names are compared. Nothing goes to QuickBooks twice: before the Web Connector adds an entry, and before a batch file carries one, TaDa Books compares it with QuickBooks' Journal. An entry QuickBooks already has (the same amounts on the same sides within three days, on the same bank or card, even coded to another expense there, under the same payee) is linked to that copy and never sent. A journal entry goes by its one line on a bank or card account too. Another payee is another entry, even with every line the same. When QuickBooks' copy names no payee and more than one entry could be it, TaDa Books asks you instead of guessing. A comparison holds for a day, and only until the next batch file is made or the entry is edited here. A batch file cannot be made until what it carries was compared: with the Web Connector connected, TaDa Books looks itself on the next Update Selected; without it, the guide's Already there? step asks for QuickBooks' Journal. Fix what differs: when the check after a send finds differences, the same Update Selected reads QuickBooks' Journal for the months these books keep, and the send wizard's next step lists each entry behind them with what it does: Delete the extra copy (an entry typed into QuickBooks by hand as well as sent from here; the copy from these books stays), Correct QuickBooks (QuickBooks' copy has other accounts), Send (QuickBooks lacks it), Already there (QuickBooks has an entry not sent yet, so it is never sent twice), Bring into TaDa Books (made only in QuickBooks after these books were brought over from it) and Mark imported (a batch file QuickBooks holds). Only what the trial balance calls for is listed. All are ticked: press Fix all, then Update Selected, and the check runs again by itself. It is one wizard with one count: the list is step 1 of 6, the four Update Selected steps follow, and the check again is the last. A line with no tick box needs your hand in QuickBooks and says what to do; when no line can be fixed from here, it says so, and you run the check again after. After Fix all, the steps count changes only: Fix all's reads of QuickBooks' Journal are not counted as changes. When the list is not read yet, Fix all reads QuickBooks' Journal and fixes what differs in that same Update Selected, but only what is certain: an extra copy only when the copy kept is the one these books sent (a batch file's mark, or linked by QuickBooks' own id), every line is the same, and both name the same payee or it is the only candidate. Anything less certain (a copy recoded to another account there, for example) stays on the list as a question, Yes, do it or No, leave it, or Yes to all of them for one answer, and goes on the next Update Selected. Nothing is done by itself while a batch file the check counts is not proven in QuickBooks' Journal. After the check, the step names each extra copy Fix all deleted, with its date and amount. An entry whose accounts differ between the two asks one thing: which accounts are right. Correcting it adds the entry as it is here first, and deletes QuickBooks' copy only once QuickBooks took the add; a refused add leaves QuickBooks' copy as it was. That holds too for an entry recorded as already in QuickBooks on another expense there. An extra copy of an entry sent from here is listed even when the bank account differs for other reasons too. A bill, an invoice or a payment made only in QuickBooks is not brought in as a journal entry: enter it here as that document. The check ends with Checked and the time: QuickBooks matches these books, or how many differences there are. A copy marked cleared in QuickBooks is left for you, said so, and a difference no entry explains is named in one sentence. Or upload the two trial balances from QuickBooks yourself opens the steps below, for a computer without the Web Connector. Without it, export a fresh Trial Balance from QuickBooks and upload it. In QuickBooks: Reports > Accountant & Taxes > Trial Balance, Dates: All, Report Basis: Accrual; then the Excel button, Create New Worksheet, Advanced, uncheck "Space between columns", OK, Export, and save it as an .xlsx. Every account is checked against what QuickBooks should hold right now, with batches not imported yet counted as expected lag rather than as problems. Accounts are matched by the name QuickBooks knows them by, so an account renamed here, or one whose name was shortened to fit QuickBooks, is still one account. A file whose header names another company asks before checking; the header is read whether QuickBooks put it in the cells or in the page setup (Excel's printed header). Then the cash-basis file: the same report with Report Basis: Cash (Customize Report if the report does not show it), uploaded with Upload cash trial balance. Its income and expense accounts are compared with these books' cash-basis figures. The accrual file can agree while this one does not: a payment that reached QuickBooks without being applied to its invoice or bill (for example as a journal entry) is not cash-basis income or expense there. Imported files cannot apply payments, so apply it in QuickBooks' Receive Payments or Pay Bills, save, and check again. A file whose header says the other basis is refused with the right button named. Both checks read the report the way QuickBooks prints it: when income and expenses start at the fiscal year and earlier years sit in one equity account, the result says so and names that account. What each difference is, and what to do. Under the accrual differences the card ties them to the entries behind them. When an entry is in QuickBooks twice, it says so ("QuickBooks has one $3,400.00 entry twice"), shows the entry's accounts and amounts, lists every entry here with that shape (date, name, memo, number, and how each reached QuickBooks: from QuickBooks with the rest of the books, a batch file, the Web Connector, marked as already there, or not sent yet), and gives the steps: open the account's register in QuickBooks, find the date with two rows, keep the copy TaDa Books sent (its memo ends with the batch mark, or it was entered the day the Web Connector sent it) and delete the one typed by hand, then check again. A copy QuickBooks is missing gets the steps to enter it again. A difference no entry here explains says to compare that account in both books. A whole batch file is named as the batch: when every account it touches differs by exactly that batch, the card says QuickBooks has batch N but it is not marked imported (press Mark imported), has it twice (it was imported again: restore the backup from before, or delete one copy of each entry carrying the batch mark), or does not have it though it is marked imported (an older backup was restored, or the import never finished: undo Mark imported, download the batch again, import it, mark it imported). Entries the Web Connector sent count as already in QuickBooks, like batches marked imported. With the Web Connector connected, an entry in QuickBooks twice has Delete the extra copy in QuickBooks: on the next Update Selected it reads QuickBooks' Journal around those dates, deletes the copy nothing in TaDa Books accounts for (never the one TaDa Books sent; a copy marked cleared in QuickBooks is left for you, said so), and checks again. It reads every date of that entry, so a copy months old is found too. After the press, nothing changes in QuickBooks until you press Update Selected: the card says Your turn: press Update Selected in the Web Connector, with the steps and Cancel the delete, and the button is gone, so it cannot be asked twice. While the Web Connector runs it, the card says QuickBooks is deleting the extra copy; after, it names what was deleted (for example General Journal #559 of 2026-07-17, $3,400.00), or that nothing was and why, and the check result shows above. If the difference is still there, Delete the extra copy again asks once more.
  • While the Web Connector runs, the row says QuickBooks is taking them now: leave QuickBooks open until it is done (Show details follows it). If some are still waiting after a run, it says to click Update Selected once more. The count there is the same as the send wizard's: changes only, never the reads or the check.
  • The check runs by itself after every send: when you send through the Web Connector, the trial balance check is the last step of the same Update Selected. When it finishes, Connect QuickBooks says the result: QuickBooks matches, or how many differences it found, and then what Fix all does about them.
  • Never added twice: before adding entries, invoices, bills and payments, the Web Connector looks in QuickBooks' Journal around their dates. An amount and a date alone prove nothing (two real $3,400 deposits on one day are two deposits), so it counts: QuickBooks entries TaDa Books already accounts for are set aside, and an entry whose every line (accounts and amounts) matches one of the rest, within three days, waits under QuickBooks may already have these instead of going. Answer Same one: don't send (QuickBooks keeps its copy, nothing is sent) or Different: send it (it goes on the next Update Selected). Everything else goes in the same run.

For a single file of a date range, with no batches kept, use Download for QuickBooks on Home (see Home, the company overview).

The Web Connector tab: payments on the right invoice or bill

A batch file cannot tell QuickBooks which invoice a payment pays, so QuickBooks picks one by its own rule (an open invoice of the same amount, else the oldest), and some land on the wrong invoice. The Web Connector tab connects TaDa Books to QuickBooks through the QuickBooks Web Connector, which comes with QuickBooks Desktop. Through it, a payment goes on exactly the invoice it pays, by QuickBooks' own id, and payments QuickBooks already put on the wrong invoice are fixed without any work in QuickBooks. Batches keep working as before; the connection adds to them.

One company at a time. A connection belongs to ONE company: connecting one company connects that company only. Each of your companies connects on its own, from its own Connections page, with its own password and its own row in the Web Connector, named after it ("TaDa Books - " and the company's name). The tab names the company in its title, in the guide and in the band. Tick only the row of the company open in QuickBooks: a row whose company is not the one open is refused, and nothing is sent. The very first run asks QuickBooks which company is open before anything goes: it connects only when QuickBooks' company name, or the file's own name, is this company's, and otherwise says which company was open and asks you to open the right file.

Connecting takes eight steps, about two minutes, on the computer that has QuickBooks Desktop. The wizard shows one step at a time:

  1. Open QuickBooks and the company file.
  2. Click Download the connection file and save the file in a folder you will remember: you pick it in step 4.
  3. In QuickBooks: File, App Management, Update Web Services. The Web Connector window opens.
  4. Click Add an Application, pick the file, then OK. QuickBooks asks for permission (its window can open behind the Web Connector): choose Yes, whenever my QuickBooks company file is open, then Continue and Confirm.
  5. Paste the password into the Password box on the company's line, press the Enter key on your keyboard, and click Yes to save it.
  6. Tick the line and click Update Selected, the button at the top of the Web Connector window, above the list of companies. This first run connects and reads QuickBooks; nothing is sent yet. Leave Auto-Run unticked.
  7. Check the list of what QuickBooks does not have yet and press Send.
  8. Click Update Selected again: this time it sends them.

Sending to QuickBooks is one wizard. Once connected, the Web Connector tab leads with everything ready to go to QuickBooks as ONE list: new invoices and bills (with any new customer, vendor, account or item they need), estimates and purchase orders, entries, payments, payments to move onto the invoice they pay here, credits to put on their invoice, corrections, and name details. Every line is ticked: Send all to QuickBooks sends them, and you untick a line only if it should wait. The list is step 1 of the same wizard that then walks you through Update Selected in the Web Connector (steps 2 to 5), one step at a time. When that run makes more things ready (a payment goes after the bill or invoice it pays), the same one list comes back for them. What only a batch file carries comes next, before the check, with one button: Start the batch file guide. The separate lists are still there, folded under Details; lists that bring something INTO TaDa Books (details from QuickBooks, estimates, time and mileage, payments where QuickBooks is the record) stay in view.

"QuickBooks found an error when parsing the provided XML text stream" in the Web Connector means QuickBooks could not read one request, so it changed nothing for it. The usual cause was a character QuickBooks cannot take as sent, such as a long dash in a memo; since 2026-11-20 every request is written in a form QuickBooks reads (a character it can store goes as a character code, one it cannot becomes "?"). The request says so in the log and waits to be sent again: run Update Selected again.

The Web Connector runs when you press Update Selected. TaDa Books cannot reach the computer that runs QuickBooks: the Web Connector there calls TaDa Books, and only when you press Update Selected in it. So after any button that sends something to QuickBooks or reads it (Send, Fix in QuickBooks, Correct in QuickBooks, Read QuickBooks again), the tab leads with Your turn: send it to QuickBooks, a short guide with how many things wait, one step at a time with Back and Next: go to the computer that has QuickBooks and open the company, open the Web Connector (in QuickBooks: File, App Management, Update Web Services; or the Windows Start button, type Web Connector; or its icon on the taskbar if it is already open), tick this company's line, click Update Selected. The last step watches by itself while you are at the page; there is nothing to press here. If nobody was at the page for 20 minutes it stops looking (so the database can rest) and says so with a Look now button; coming back to the page, or moving the mouse over it, looks at once. The Connections row says it too while the row is closed. One press sends everything waiting, however long the list; the band turns into QuickBooks is taking it now while it runs, and the tab says Done when the list is empty, with what went in and what QuickBooks refused (for example "Done: the Web Connector finished. 40 went in, 2 refused", each refusal with why). If you tick Auto-Run anyway, TaDa Books lets it run no more often than every 30 minutes: a connection that called every few minutes would keep TaDa Books's database awake around the clock.

The first run reads QuickBooks' customers, invoices and payments. The band at the top then says Connected and names the QuickBooks file. Under it the send wizard shows what is ready for QuickBooks as one list, or QuickBooks is up to date. Nothing to send. Lists that bring something INTO TaDa Books follow it. The connection file and password, Linked to QuickBooks (with Read QuickBooks again) and the Web Connector's log are under Details: a waiting line may point there for its reason or for Read QuickBooks again. From then on the connection belongs to that file: if another company is open in QuickBooks when the Web Connector runs, nothing is sent and the band says which file was open. Forget the QuickBooks file is only for a file that moved or was renamed; the next run learns the file that is open then, the same careful way. If a run stops halfway (the computer slept, QuickBooks closed), whatever was waiting for QuickBooks' answer goes again on the next Update Selected; an add QuickBooks may already hold is never sent twice.

Linked to QuickBooks counts what TaDa Books knows is which: a customer, invoice or payment is linked to its QuickBooks record only when exactly one match exists (same customer, date, amount and number). Two possible matches are never guessed; they stay unlinked. A vendor is linked by its name as soon as it is known to QuickBooks or paid here, by check or card as much as by bill. Not linked, and why lists every QuickBooks record left unlinked, each with what stood in the way in plain words: no name here by that name (it links once one with exactly that name is added), two names here that read the same, its customer or vendor not linked yet, a $0 record, nothing here that day, or the same money in a different count (one payment here where QuickBooks has two the same day: the totals agree). Each row says Nothing to do or Look at it, and a line above the list says whether anything needs you: a $0 record, the same money split differently, or a name only QuickBooks has change no balance. The list changes nothing on either side. Read QuickBooks again reads it at the next Update Selected (QuickBooks is read only when you ask, or by an import; Last full read in the band says when), and Link again redoes the links from the last read.

A credit to put on its invoice (in the send wizard as "Put a credit on", and in its own list) is an invoice that is paid here but still open in QuickBooks because the payment reached QuickBooks as a journal entry (a batch file can send no more): QuickBooks holds the money as an unused credit for the customer. Apply in QuickBooks puts that credit on the invoice at the next Update Selected, exactly as Receive Payments, Discounts And Credits does by hand: a $0.00 payment that uses the credit. No money moves and no income changes. If QuickBooks has no credit of that amount for that customer that day, or two of them, nothing is applied and the log says what to do; a credit already used is refused by QuickBooks.

Not in this send. Under its list, the send wizard names what waits, in the four kinds above: for you, right after another line, only in a batch file (before the check), or staying here. The Batch files tab says the same split: how many go by the Web Connector and how many need a file.

Correcting an entry brought over from QuickBooks (since 2026-11-20). An entry that came from QuickBooks and was then changed, voided or deleted here shows in the send wizard as Correct, "... brought over from QuickBooks, changed here". QuickBooks never told TaDa Books its own number for those entries, so the Web Connector first reads QuickBooks' Journal for that one day and finds the entry by what QuickBooks holds: the same amounts on the same sides, then the same accounts, number and name. A copy that is another entry here (one the Web Connector added, for example the new version of an entry replaced here) is never taken for this one. It must find exactly one; if it finds none, or two it cannot tell apart, nothing changes in QuickBooks and the line says so (only a batch file can send that one). Found: the Web Connector adds the entry as it is now FIRST, and deletes QuickBooks' old copy only after QuickBooks says the new one went in. If QuickBooks refuses the new copy, its old copy stays and nothing changed there; the entry waits on the send list with QuickBooks' reason. If QuickBooks takes the new copy but will not delete the old one, the delete goes again by itself on the next Update Selected. If QuickBooks had it cleared, the new copy is marked cleared too, so the bank's cleared balance there does not move. An entry voided or deleted here is only deleted there. If QuickBooks had that one cleared, it is deleted only together with marking cleared the entry here that takes its place (the same day, the same amounts, the same bank), so QuickBooks' cleared balance does not move; when nothing here takes its place, it is not deleted, and the line says what to do. Pressing twice, or pressing Send while QuickBooks is still working, never corrects an entry twice. The log shows each step: "Find QuickBooks' copy of an entry to correct", then the add, then "Delete QuickBooks' old copy of an entry".

The lists, one by one. Everything below that goes TO QuickBooks is also in the send wizard, which sends it all at once; the lists sit folded under Details, each with its own button for anyone who wants to send part of it.

Payments on a different invoice in QuickBooks lists every linked payment that pays one invoice here and another in QuickBooks, and The record says which side is right:

  • A payment made in TaDa Books: TaDa Books is the record. Fix in QuickBooks (or Fix all in QuickBooks) moves it there at the next Update Selected in the Web Connector. When payments swap invoices and neither invoice has room, one is taken off its invoice for a moment and moves right after, so QuickBooks accepts every step.
  • A payment that came from QuickBooks: QuickBooks is the record (the import matched it to an invoice by the same rule QuickBooks uses). Match TaDa Books (or Match all to QuickBooks) applies it here as QuickBooks does, together with any payment it swaps invoices with. Nothing goes back to QuickBooks, since QuickBooks already holds it that way. Once a payment that came from QuickBooks has been corrected here and sent back (by a batch file or the Web Connector), QuickBooks holds TaDa Books's version, so TaDa Books is the record and the row offers Fix in QuickBooks instead.
  • A row that cannot be fixed from here says why, for example an invoice that is not linked yet, or an invoice that another payment holds on the other side.

New payments for QuickBooks lists payments made here that QuickBooks does not have yet. One whose customer and invoices are already in QuickBooks goes by the Web Connector, on exactly those invoices; Send by the Web Connector queues them, and the batch leaves them out at once, so nothing is sent twice. The others go with the batch as before, and each says why (an invoice made here goes with the batch first, for example). If QuickBooks refuses one, it is waiting for the batch again. If the answer never arrives, it is never sent blindly a second time: the next read shows whether QuickBooks has it, and if not it is waiting again.

Bills too. Everything above works the same way for bills: the Web Connector reads QuickBooks' vendors, bills and bill payments, links them, and lists a bill payment that pays one bill here and another in QuickBooks with a Vendor chip (a customer payment wears a Customer chip). A bill payment made here moves in QuickBooks with Fix in QuickBooks. One paid by credit card cannot be changed in place in QuickBooks, so it is replaced whole: the new one is added on the right bill and the old one deleted (the new one first, when the bill has room, so a refusal changes nothing). A bill payment that came from QuickBooks is matched here with Match TaDa Books: only which bills it pays changes, never its amount or its entry. One that took an early-payment discount, or is in another currency, says why it cannot be matched. A bill payment a batch file sent arrives in QuickBooks as a check to Accounts Payable, which someone had to apply to its bill in Pay Bills. With the Web Connector, Fix in QuickBooks applies it to the right bill for you.

New accounts and classes go first. Every read also brings QuickBooks' chart of accounts and classes. Before the Web Connector sends anything (an invoice, a bill, an entry, a payment), any account or class it names that QuickBooks does not have yet is added first, parents before their subaccounts, with the same account type a batch file would give it (a subaccount takes its parent's type, as QuickBooks requires). The log lists each one as Add an account or Add a class.

Name details: QuickBooks and here lists customers and vendors whose details differ between the two. Every name on it is in both places and linked; its columns are Details only QuickBooks has, Details only here and Details that differ. QuickBooks starts an address with the name; that line is left out, so an address that is only the name counts as no address. The details compared: email, phone, address, account number, notes, 1099, inactive, and from QuickBooks a vendor's tax ID, a customer's tax exemption (a non-taxable tax code, with its resale number), the terms when they match one of your own payment terms by name, and a custom field's value when you keep a custom field with the same name here. Bring here fills the empty fields here with what QuickBooks has; Send to QuickBooks fills the empty fields in QuickBooks with what is kept here. Nothing already filled in, on either side, is ever replaced: where both hold something different, the row shows both for you to decide. A tax ID and an address are never sent to QuickBooks from here. The details come with every read, so Read QuickBooks now refreshes the list.

New invoices and bills for QuickBooks lists invoices and bills made here that QuickBooks does not have yet. Sent by the Web Connector they arrive as real QuickBooks invoices and bills (a batch file can only carry them as journal entries, which no payment can be applied to in QuickBooks), so their payments then go on them exactly. A customer or vendor QuickBooks does not know yet is added first. QuickBooks posts an invoice line through an item, so each income account an invoice uses gets a service item named after the account that posts to it; an item QuickBooks already has of that name is used when it posts to the same account. If it posts somewhere else, nothing is sent: the log says which account QuickBooks' item uses, and the invoices that need it wait until you rename one of the two.

Sales tax, discounts and jobs. An invoice with sales tax goes with QuickBooks' sales tax item at the same rate and a taxable or not-taxable code on every line. QuickBooks charges its rate once, on the taxable total, so before sending, TaDa Books works the tax out QuickBooks' way; it goes only when that is the tax here to the cent, and otherwise the row shows both figures and it goes with the batch (this happens when the tax here is rounded line by line). QuickBooks' answer is checked too: if a setting in QuickBooks still makes its tax different, the invoice is deleted there again and waits. If QuickBooks has no sales tax item at that rate, the row asks you to add one there. A discount goes as a minus line, taxable when it lowers the tax here. An invoice for one job goes to the job in QuickBooks (Customer:Job), the job added first if QuickBooks does not have it, and a bill's line for a job carries it for job costing. Still with the batch, each saying so: tax included in prices, lodging tax, lines for different jobs on one invoice, retainage, a bill that buys stock, and any foreign-currency document. An invoice or bill the Web Connector sent and you change later is corrected the same way as an entry (below), unless QuickBooks already has payments on it: then the row asks you to change it in QuickBooks too.

Estimates and purchase orders for QuickBooks lists open estimates and purchase orders made here that QuickBooks does not have yet. They never post, so a batch file never carried them. Sent by the Web Connector they arrive as real QuickBooks estimates and purchase orders, each line through the item named after its account (added first if QuickBooks has none, the same way as for invoices). QuickBooks needs estimates and purchase orders turned on in its preferences; if they are off, QuickBooks refuses and the log says so. One with sales tax, a discount, a line for a job or another currency stays here, and says so. Each goes once: a later change here is not sent again yet.

Open in QuickBooks, not here: estimates and purchase orders lists the open estimates and purchase orders QuickBooks holds that are not in TaDa Books (the import from QuickBooks' reports never carries them, because they never post). Bring here makes each one here, every line on the account its QuickBooks item posts to, with QuickBooks' number, dates and memo, and links the two so it is never offered again or sent back. One whose customer or vendor is not linked yet, or whose item's account is not found here by its QuickBooks name, says so. The list appears only when there is something on it, and it refreshes with every read.

In QuickBooks, not here: time and mileage lists the time entries and vehicle mileage QuickBooks holds that are not in TaDa Books (the import from QuickBooks' reports never carries them). Bring here saves each one with the same rules as the Time and Mileage screens: the customer and job, the income account its service item posts to, the class, the worker's name, billable or not. One for a customer not linked yet, or with no hours or miles, says so. A press brings up to 300; press again for the rest.

New entries for QuickBooks lists journal entries, checks, deposits, card charges and card refunds made here that QuickBooks does not have yet. Sent by the Web Connector they are exactly what the batch file would carry, and the batch leaves them out. One that pays invoices or bills goes with the batch, and says so. If QuickBooks' answer to an entry never arrives, the log shows No answer yet: look in QuickBooks, and if it is not there, press Not in QuickBooks: send again beside it. (A read cannot tell for these, and a guess could put it in QuickBooks twice.)

Sent by the Web Connector, changed here since lists the entries the Web Connector added to QuickBooks that you then changed, voided or deleted here. Correct in QuickBooks (one row, or all of them) has the Web Connector delete QuickBooks' copy and then add the entry as it is now; a voided or deleted one is only deleted. QuickBooks then holds one clean entry. The delete goes first, so the entry is never in QuickBooks twice: if QuickBooks refuses the new version, the entry simply waits again. If QuickBooks refuses the delete (a closed period, for example), nothing changes there and the next batch file corrects it the old way: a reversal of the old version and a new copy. If you leave the list alone, the batch does the same. Deleting an entry in QuickBooks also takes it off a QuickBooks reconciliation, if it was reconciled there.

What the Web Connector did lists every request and QuickBooks' answer, newest first, in the company's time zone. If someone changed a payment in QuickBooks after TaDa Books read it, QuickBooks says so and the change is tried again with QuickBooks' latest copy. New password stops the Web Connector until the new one is typed in; Turn the connection off makes the Web Connector stop at the door until it is turned on again.

Download everything

The whole of this company's books as spreadsheet files that open in Excel, plus its documents as a second zip. Every company at once, a password-protected copy, and restoring a copy live on the plan page. See Your data, backups and security.

Your own software and AI

An API key for your own programs, webhooks that tell them when something changes, and the link that lets an AI assistant you already use read your books. See The API and webhooks.

Elsewhere in the books

Connections for your store, when a company runs one, open in their own row.