Haruno Knowledge base

QuickBooks sync

Connect a company to QuickBooks, fetch its months into the books with Sync, and close them. Haruno only reads from QuickBooks.

  • Mac appAvailable
  • Windows appAvailable

A company can take its figures from QuickBooks instead of from files you drop in. You connect the company once. After that, Sync on the company's page fetches its months.

Nothing is written back

Haruno only reads from QuickBooks. Sync fetches figures. It never sends anything back, and it never changes anything in QuickBooks.

The QuickBooks connection is kept on Haruno's server, not in the app. The app asks the server for a company's months and files them in the books.

Connecting a company

You can connect a company in two places.

  • On the dashboard's QuickBooks page.
  • In the app, in Add company ▸ From QuickBooks. See Adding a company.

Either way, QuickBooks' own sign-in opens in your browser. The connection belongs to your organization. If you are not in an organization, it belongs to you.

QuickBooks is not in the Connectors window, on either the Mac or Windows. A chat cannot read QuickBooks directly either. A company's figures reach a chat only through its books. See Ask Haruno about the books.

Fetching months

A QuickBooks company's page has a bar that says where it stands, with the buttons for it.

What the page saysWhat it meansWhat you can do
No months have been fetched for this company yet.The company is added, but no month is filedSync
Fetching months — 3 of 12 filed.A sync is running. You can leave the pageWait, or work elsewhere
Months are filed on this computer. Last fetched …Up to dateSync again later
sign in to QuickBooks againQuickBooks needs the sign-in renewedReconnect, or Reconnect on the dashboard
disconnected from QuickBooksThe connection was endedReconnect, or Manage on dashboard
removed in QuickBooksThe company was removed from your QuickBooks. Its books are kept here, exactly as they areIts books stay as they are
archived in QuickBooksThe company is archived in QuickBooks, so no more months are fetchedIts books are kept
sync stoppedYou stopped syncing it hereAdd it again from QuickBooks to sync into the same books

A person who may not sign in from the app is told that an administrator does it on the dashboard.

A sync fetches the months the company needs. If someone changed a past month in QuickBooks, Haruno notices and fetches that month and the ones after it again, so the books do not go stale.

Press Books ▸ Sync QuickBooks Months to fetch for every connected company at once. It appears only when there is something to fetch.

What a month holds

Each month brings the company's information and chart of accounts, and the trial balance, profit and loss and balance sheet. It can also bring things such as who owes the company and whom it owes, profit and loss by class or department, cash flow, vendor transactions, budgets and recurring transactions, where the company's QuickBooks has them.

Headcount is not read from QuickBooks. You enter it in Company details.

What stays on the Mac

A sync keeps a copy of the company's QuickBooks records on this Mac, including customer and vendor names. The Add company sheet says so, and links to the Data Processing Disclosure.

From fetched months to figures

A synced month is filed first. It does not change the figures you see until it is closed.

  1. Sync

    Fetch the months. They are filed in the company's books.

  2. Analyze data

    The first time, the page says Your monthly data is ready. Analyze the files to set up your reports. Haruno reads the QuickBooks data and suggests how to organize it. You review and approve. See Adding a company and Mappings.

  3. Close the month

    Closing puts the months in the ledger that the statements, checks and chat read. See Closing a month.

A month QuickBooks gained after your last sync is not in the books until you sync it and close it. Chat answers say which month the books run through.

Moving a company from Excel to QuickBooks

A company that has been reading Excel files can switch. Link it to its QuickBooks company, then press Use QuickBooks from now on… on its page. The sheet tells you what will happen before you confirm.

  • From now on the company's books come from QuickBooks.
  • QuickBooks is read again for every month back to the first one.
  • Months already closed are reopened and restated, and their figures may change. Each restated month is recorded, with its reason, in the statement package.
  • The Excel files are no longer read, and the figures read from them are removed from the books. QuickBooks reconciliation reports are still read.
  • Months reconciled in Excel show as not reconciled until a QuickBooks reconciliation report covers them.
  • Reports marked reviewed need reviewing again if their figures change.
  • The mapping is drafted again from QuickBooks. You approve it before the next close.

The move waits if QuickBooks has not sent a month yet. While a move is pending, Keep using Excel goes back to the mapping that reads the Excel files. Nothing in the books has changed by then.

Stopping

Stop syncing from QuickBooks is in the company's menu. The company stays in the Portfolio with its books. Every close, finding and report is kept. Adding it again from QuickBooks syncs into the same books. To take it out of the Portfolio, archive it. See Portfolio.

If Haruno is disconnected inside QuickBooks itself, the company shows as removed in QuickBooks, and its books are kept.

Scheduling

Haruno can run the sync by itself on a timetable. See Scheduled QuickBooks sync.

What to tell a customer

QuickBooks is a read-only source. Haruno never changes anything in it. After the first setup, keeping the books current takes two steps: Sync, then Close month.

Last updated · PR #2944 · View this version on GitHub

History (1 version)
  1. Internal knowledge base for staff: site, reader keys, assistant, 197 pages and the PR rule (#2944)
    What changed
    @@ -0,0 +1,111 @@
    +---
    +title: QuickBooks sync
    +summary: Connect a company to QuickBooks, fetch its months into the books with Sync, and close them. Haruno only reads from QuickBooks.
    +feature: quickbooks-sync
    +covers:
    +  - apple/Sources/CFOFeature/Shell/CFOQboCompanyBanner.swift
    +  - apple/Sources/CFOFeature/Shell/CFOQboLabels.swift
    +  - apple/Sources/CFOFeature/Shell/CFOUseQuickBooksSheet.swift
    +  - apple/Sources/CFOFeature/Shell/CFOQboDataDisclosure.swift
    +  - apple/Sources/CFOFeature/Workflow/CFOQboModel.swift
    +  - apple/Sources/CFOFeature/Workflow/CFOQboConnecting.swift
    +  - apple/Sources/CFOFeature/Workflow/CFOQuickBooksMove.swift
    +  - apple/Sources/CFOKit/CFOQboSnapshot.swift
    +  - apple/Sources/BackendServices/QuickBooks/**
    +---
    +
    +A company can take its figures from QuickBooks instead of from files you drop in. You connect the company once. After that, <Ui>Sync</Ui> on the company's page fetches its months.
    +
    +## Nothing is written back
    +
    +Haruno only reads from QuickBooks. Sync fetches figures. It never sends anything back, and it never changes anything in QuickBooks.
    +
    +The QuickBooks connection is kept on Haruno's server, not in the app. The app asks the server for a company's months and files them in the books.
    +
    +## Connecting a company
    +
    +You can connect a company in two places.
    +
    +- On the dashboard's QuickBooks page.
    +- In the app, in <Ui>Add company ▸ From QuickBooks</Ui>. See [Adding a company](/macos/books/add-company/).
    +
    +Either way, QuickBooks' own sign-in opens in your browser. The connection belongs to your organization. If you are not in an organization, it belongs to you.
    +
    +QuickBooks is not in the Connectors window, on either the Mac or Windows. A chat cannot read QuickBooks directly either. A company's figures reach a chat only through its books. See [Ask Haruno about the books](/macos/books/ask-haruno-about-books/).
    +
    +## Fetching months
    +
    +A QuickBooks company's page has a bar that says where it stands, with the buttons for it.
    +
    +| What the page says | What it means | What you can do |
    +|---|---|---|
    +| <Ui>No months have been fetched for this company yet.</Ui> | The company is added, but no month is filed | <Ui>Sync</Ui> |
    +| <Ui>Fetching months — 3 of 12 filed.</Ui> | A sync is running. You can leave the page | Wait, or work elsewhere |
    +| <Ui>Months are filed on this computer. Last fetched …</Ui> | Up to date | <Ui>Sync</Ui> again later |
    +| <Ui>sign in to QuickBooks again</Ui> | QuickBooks needs the sign-in renewed | <Ui>Reconnect</Ui>, or <Ui>Reconnect on the dashboard</Ui> |
    +| <Ui>disconnected from QuickBooks</Ui> | The connection was ended | <Ui>Reconnect</Ui>, or <Ui>Manage on dashboard</Ui> |
    +| <Ui>removed in QuickBooks</Ui> | The company was removed from your QuickBooks. Its books are kept here, exactly as they are | Its books stay as they are |
    +| <Ui>archived in QuickBooks</Ui> | The company is archived in QuickBooks, so no more months are fetched | Its books are kept |
    +| <Ui>sync stopped</Ui> | You stopped syncing it here | Add it again from QuickBooks to sync into the same books |
    +
    +A person who may not sign in from the app is told that an administrator does it on the dashboard.
    +
    +A sync fetches the months the company needs. If someone changed a past month in QuickBooks, Haruno notices and fetches that month and the ones after it again, so the books do not go stale.
    +
    +Press <Ui>Books ▸ Sync QuickBooks Months</Ui> to fetch for every connected company at once. It appears only when there is something to fetch.
    +
    +### What a month holds
    +
    +Each month brings the company's information and chart of accounts, and the trial balance, profit and loss and balance sheet. It can also bring things such as who owes the company and whom it owes, profit and loss by class or department, cash flow, vendor transactions, budgets and recurring transactions, where the company's QuickBooks has them.
    +
    +Headcount is not read from QuickBooks. You enter it in <Ui>Company details</Ui>.
    +
    +<Callout variant="info" title="What stays on the Mac">
    +A sync keeps a copy of the company's QuickBooks records on this Mac, including customer and vendor names. The Add company sheet says so, and links to the Data Processing Disclosure.
    +</Callout>
    +
    +## From fetched months to figures
    +
    +A synced month is filed first. It does not change the figures you see until it is closed.
    +
    +<Steps>
    +<Step title="Sync">
    +Fetch the months. They are filed in the company's books.
    +</Step>
    +<Step title="Analyze data">
    +The first time, the page says <Ui>Your monthly data is ready. Analyze the files to set up your reports.</Ui> Haruno reads the QuickBooks data and suggests how to organize it. You review and approve. See [Adding a company](/macos/books/add-company/) and [Mappings](/macos/books/mappings/).
    +</Step>
    +<Step title="Close the month">
    +Closing puts the months in the ledger that the statements, checks and chat read. See [Closing a month](/macos/books/month-close/).
    +</Step>
    +</Steps>
    +
    +A month QuickBooks gained after your last sync is not in the books until you sync it and close it. Chat answers say which month the books run through.
    +
    +## Moving a company from Excel to QuickBooks
    +
    +A company that has been reading Excel files can switch. Link it to its QuickBooks company, then press <Ui>Use QuickBooks from now on…</Ui> on its page. The sheet tells you what will happen before you confirm.
    +
    +- From now on the company's books come from QuickBooks.
    +- QuickBooks is read again for every month back to the first one.
    +- Months already closed are reopened and restated, and their figures may change. Each restated month is recorded, with its reason, in the statement package.
    +- The Excel files are no longer read, and the figures read from them are removed from the books. QuickBooks reconciliation reports are still read.
    +- Months reconciled in Excel show as not reconciled until a QuickBooks reconciliation report covers them.
    +- Reports marked reviewed need reviewing again if their figures change.
    +- The mapping is drafted again from QuickBooks. You approve it before the next close.
    +
    +The move waits if QuickBooks has not sent a month yet. While a move is pending, <Ui>Keep using Excel</Ui> goes back to the mapping that reads the Excel files. Nothing in the books has changed by then.
    +
    +## Stopping
    +
    +<Ui>Stop syncing from QuickBooks</Ui> is in the company's menu. The company stays in the Portfolio with its books. Every close, finding and report is kept. Adding it again from QuickBooks syncs into the same books. To take it out of the Portfolio, archive it. See [Portfolio](/macos/books/portfolio/).
    +
    +If Haruno is disconnected inside QuickBooks itself, the company shows as removed in QuickBooks, and its books are kept.
    +
    +## Scheduling
    +
    +Haruno can run the sync by itself on a timetable. See [Scheduled QuickBooks sync](/macos/books/scheduled-quickbooks-sync/).
    +
    +## What to tell a customer
    +
    +QuickBooks is a read-only source. Haruno never changes anything in it. After the first setup, keeping the books current takes two steps: Sync, then Close month.