Connect QuickBooks Online
Finconsol connects to QuickBooks Online directly and only reads your figures. A QuickBooks sign-in covers one company, so you connect once for each company in the group, signed in as an administrator of that company. Finconsol then syncs each company daily, and again whenever you refresh.
Who signs in
A QuickBooks sign-in covers one company. Sign in as an administrator of that company, and repeat for each QuickBooks Online company in the group.
Connect each company
- On the Companies screen, choose Connect an accounting system, then Connect to QuickBooks.
- Sign in as an administrator of the company and allow the access QuickBooks asks for.
- Back in Finconsol, choose Add as company. The price for the extra company is shown before you confirm.
- Repeat for each of the other QuickBooks Online companies.
- Map each company's accounts to the group chart. Mapping accounts explains how.
Finconsol takes each company's name, currency and financial year from QuickBooks, and you can correct them later.
What Finconsol reads
Finconsol reads each company's details, its chart of accounts and its figures for each month, and checks them against the balance sheet and profit and loss. Every report is read on the accrual basis, so compare Finconsol with QuickBooks reports set to accrual. Finconsol only reads your figures and never changes them.
For QuickBooks companies, intercompany is eliminated at account level, and receivables and payables aging is not available.
How often it refreshes
Every company syncs daily, and again whenever an administrator chooses Refresh now on the Data Health screen. When figures refresh has the details.
Reconnect the right company
When you reconnect, sign in to the same QuickBooks company. If you sign in to a different one, Finconsol keeps the connection as it was and asks you to press Reconnect and choose the right company.
QuickBooks Desktop
A QuickBooks Desktop company comes in by trial balance upload. Run the Trial Balance report for the month, export it to Excel, put the figures in the Finconsol template and upload it. What a trial balance upload needs lists the columns.
Disconnect QuickBooks
Disconnect from QuickBooks on the Companies screen ends the connection. Nothing changes in your QuickBooks books, and the change log records it. A connection still used by a company in the group cannot be removed until the company uses another connection or leaves the group.