QuickBooks Online to Dryrun Import – Data Mapping

Importing data from QuickBooks Online to Dryrun is a convenient way to quickly start building forecasts from a known data set, however two common questions are:

  • Where exactly does QuickBooks Online data come from within Intuit’s software?
  • Where does QBO client data map to in Dryrun?

Voila!
 

 

Bills

Dryrun pulls bills and bill payments, using Vendor/Payee as Dryrun category

Bills: Item Name

QBO Bill Name in Dryrun

Bills: Amount

QBO Bill Amount in Dryrun

Bills: Due Date

QBO Bill Due Date in Dryrun

Bills: Category Name

QBO Bill Category in Dryrun

Expense

Dryrun pulls expenses into the Recurring Section, using the Bank Account as the Dryrun category

Expense: Records in Recurring

Expenses are generally prepaid, smaller and often repeat so they can serve as a great baseline for a recurring budget.

QBO Expense to Dryrun

Expense: Name & Category

Expenses are related to the bank account from which they are paid in QuickBooks Online. The bank account is used as the category in Dryrun.

QBO Expense to Dryrun Category

Invoices

Dryrun pulls invoices and invoice payments, using Customer as Dryrun category

Invoices: Item Name

QBO Invoice Name in Dryrun

Invoices: Item Amount

QBO Invoice Amount in Dryrun

Invoices: Due Date (Date plus terms outlined, such as ‘net 30’)

QBO Invoice Due Date in Dryrun

Invoices: Category Name

QBO Invoice Category in Dryrun

Estimates

Dryrun pulls estimates, using Customer as the Dryrun category. Users often import the more speculative Estimates into a ‘Sales’ scenario in Dryrun to keep them separate from their ‘Actuals’.

QBO Estimate into Dryrun

Bank Balance

Month Start Bank Balance: Amount

Dryrun pulls from Bank Balance line(s) on the Balance Sheet Report for the month start balance.

QBO Bank Balance Month Start

Month Start Bank Balance: Accounts

If more than one bank account is imported, the amounts will be compiled into a total balance.

QBO Bank Account Month Start

 

Day Start Bank Balance: Amount

Dryrun pulls in today’s bank balance and from the dashboard Bank Accounts panel.

QBO Bank Balance Day Start

Day Start Bank Balance: Accounts

QBO Bank Account Day Start

Partial Payments

Partial Payments Handling: Dryrun will split items up into individual payments when partial payments are accepted in QuickBooks Online. The payments are treated as individual items in Dryrun recorded on the payment date. The number of payments is detailed, such as “1 of 4”. The unpaid balance is placed on the due date.

Partial Payment: Payments Made (Dryrun will track the number of payments and amounts)

QBO Partial Name in Dryrun

Partial Payment: Outstanding Balance Still Due

QBO Partial Balance in Dryrun

Partial Payment: Calculated based on the total of the original invoice

QBO Partial Total in Dryrun

Partial Payment: Payment Made

QBO Partial Single Payment

Partial Payment: Balance Due Date

QBO Partial Due in Dryrun

Multi Currency Support

Multi Currency Support: Dryrun pulls the item amount converted to the base currency in Dryrun. The original transaction currency is noted in the category heading and the conversion rate is detailed in the item notes.

Multi Currency: Amount in the Original Currency

Multi Currency: Converted to Your Native Currency

QBO Currency Amount in Dryrun

Multi Currency: The Exchange Rate Provided by QuickBooks Online

QBO Currency Exchange Rate in Dryrun

Finding something unusual in your QBO feed? Chat us up or send us an email at hello@dryrun.com

Like the article? Please share...Share on LinkedIn
Linkedin
Share on Facebook
Facebook
Tweet about this on Twitter
Twitter
Share on Google+
Google+
Email this to someone
email