Table of Contents

What's New - QuickBooks Online data source for Reckon Insights

About

Reckon Insights is now able to add QuickBooks Online as a new data source.

A single and a combination of multiple data sources including from Reckon Accounts Hosted and Reckon One can be combined and supported.

The steps to managing users, permission, and feeds is standard regardless of the data source.

To add QuickBooks Online as a new data source, add a new order or update your product from Reckon Portal.

NEW USERS

EXISTING USERS

  1. Select Reckon Insights under the Available Products
  2. Click on Start free 14 days trial
  3. Select the number of QuickBooks Online feed
  4. Enter your Payment details
  5. Then, click on Place secure order

  1. Select Reckon Insights under the Available Products
  2. Click on LICENSES then MANAGE LICENSES
  3. Select the number of QuickBooks Online feed
  4. Then, click on Continue


See the related article for Adding a QuickBooks Online Data Feed guideline to set up and configure.



Synchronisation

The initial synchronisation will begin as soon as the QuickBooks Online Data Feed is added for Reckon Insights. This is the longest ETL process, depending on the amount of data a company contains.

After which, Reckon Insights will perform a daily synchronisation of updated data.

The time is dependant when the feed was added. For example, the QuickBooks Online Data Feed was added at 10 PM. The subsequent synchronisation will then occur at 10 PM, the following day.

Similar to existing Data Sources, email notifications will be sent to the owner for any failures in synchronisation or the disabling of the QuickBooks Online feed resultant from multiple sync failures.



What is not available to extract from QuickBooks Online?

  1. Bank details & Reconciliation data
  2. No endpoint available to retrieve from:
    1. Employee as a contact used in Expense transactions
    2. Time entries
    3. Payroll
    4. Inventory
  3. Sales orders



Content availability and comparison

Enhancements can be requested by entering the details at Reckon Product Ideas.

Customers

QuickBooks Online

RECKON INSIGHTS

CONTENT TYPE

Deposit Detail

Sales Receipt List

Report

Income by Customer Summary

Income by Customer Summary

Report

Quotes by Customer

Estimates List

Report

Sales by Customer Detail

Sales by Customer

Report

Accounts receivable ageing detail

Aged Debtor Detail

Report

Accounts receivable ageing summary

  1. Aged Debtor Detail Summary
  2. Debtors Ageing
  1. Report
  2. Chart

Customer Balance Summary

Customer Balances

Report

Invoice List

Invoice List

Report

Open Invoices

Unpaid Invoices

Report

Suppliers

QuickBooks Online

RECKON INSIGHTS

CONTENT TYPE

Expenses by Supplier Summary

Expenses by Supplier Summary

Report

Transaction List by Supplier

Supplier Transaction Detail

Report

Accounts payable ageing detail

Aged Payables Details

Report

Accounts payable ageing summary

Aged Payables Summary

Report

Bill Payment List

Payment List

Report

Supplier Balance Summary

Supplier Balance

Report

Unpaid Bills

Unpaid Bills

Report

Financial

QuickBooks Online

RECKON INSIGHTS

CONTENT TYPE

Profit & Loss year-to-date comparison

Profit & Loss - Year on Year

Report

Profit & Loss

  1. Profit and Loss Summary
  2. Profit and Loss Summary (small -dashboard)
  3. Profit and Loss Summary (small - multi year)

Report

Profit & Loss by Class

Profit & Loss by Class

Report

Quarterly Profit & Loss Summary

Profit & Loss by quarter

Chart

General Ledger

Ledger Transactions (Accrual)

Report

Transaction Detail by Account

Account Enquiry (accrual)

Report

Trial Balance

  1. Trial Balance Summary
  2. Trial Balance Summary (small - dashboard)

Report



Transaction availability and comparison

QuickBooks Online

RECKON INSIGHTS

CATEGORY

Invoices

Invoice

Accounts Receivable

Receive payments

  1. Receive payment
  2. Receipt

Accounts Receivable

Quotes

Estimate

Accounts Receivable

  1. Adjustment Notes
  2. Refund Receipt

Credit note

Accounts Receivable

Cheque

Cheque

  1. Accounts Payable
  2. Banking

Bills

Bill

Accounts Payable

Pay Bills

  1. Payment
  2. Bill payment cheque

Accounts Payable

Purchase order

Purchase order

Accounts Payable

Supplier credit

  1. Bill credit
  2. Bill payment credit

Accounts Payable

Bank deposit

Deposit

Banking

Transfer

Transfer

Banking

Pay down credit card

Credit card charge

Banking

Journal

Journal

Financial


New Explore Field: Location

According to Intuit, Locations are used in QuickBooks Online transactions to designate different business units within the business — especially if doing business across multiple “locations” — for reporting purposes.

To accommodate the new QuickBooks Online, a new Dimension field is added to the Explore for Location.

  1. In Reckon Insights, click on the three-line menu in the upper-left hand
  2. Select Explore then click on Transactions
  3. Expand the Transaction field and see Location


The Transaction Explore can be found on the following contents:

ACCOUNTS RECEIVABLES
REPORTS
Customer Transaction Detail
Customer Transaction Summary
Estimates List
Invoice List
Sales Receipt List
Unpaid Invoices

KPIs
Balance Unpaid Invoices
MTD Total Invoices
YTD Total Invoices
ACCOUNTS PAYABLES
REPORTS
Bill
Expenses by Supplier Summary
Supplier Payments
Supplier Transaction Detail
Supplier Transaction Summary
Unpaid Bills

KPIs
Balance Unpaid Bills
MTD Employee Expenses
MTD Total Purchases
YTD Employee Expenses
YTD Total Purchases
PAYROLL
REPORTS
Employee Expense Claims





How did we do?

Related Articles

Powered by HelpDocs (opens in a new tab)

Powered by HelpDocs (opens in a new tab)