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

Bills: Amount

Bills: Due Date 

Bills: Category Name

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.

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.

Invoices

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

Invoices: Item Name

Invoices: Item Amount

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

Invoices: Category Name

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'.

Bank Balance

Month Start Bank Balance: Amount

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

Month Start Bank Balance: Accounts 

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

 

Day Start Bank Balance: Amount

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

Day Start Bank Balance: Accounts

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)

Partial Payment: Outstanding Balance Still Due

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

Partial Payment: Payment Made

Partial Payment: Balance Due Date

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

Multi Currency: The Exchange Rate Provided by QuickBooks Online

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

Did this answer your question?