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?
Dryrun pulls bills and bill payments, using Vendor/Payee as Dryrun category
Bills: Item Name
Bills: Due Date
Bills: Category Name
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.
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
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’.
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 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 email@example.com