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 |
|
|
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.
What is not available to extract from QuickBooks Online?
- Bank details & Reconciliation data
- No endpoint available to retrieve from:
- Employee as a contact used in Expense transactions
- Time entries
- Payroll
- Inventory
- Sales orders
Content availability and comparison
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 |
|
|
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 |
| 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 |
| Report |
Transaction availability and comparison
QuickBooks Online | RECKON INSIGHTS | CATEGORY |
Invoices | Invoice | Accounts Receivable |
Receive payments |
| Accounts Receivable |
Quotes | Estimate | Accounts Receivable |
| Credit note | Accounts Receivable |
Cheque | Cheque |
|
Bills | Bill | Accounts Payable |
Pay Bills |
| Accounts Payable |
Purchase order | Purchase order | Accounts Payable |
Supplier 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.
- In Reckon Insights, click on the three-line menu in the upper-left hand
- Select Explore then click on Transactions
- Expand the Transaction field and see Location
The Transaction Explore can be found on the following contents:
ACCOUNTS RECEIVABLES
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
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
Employee Expense Claims
