Xero to Dryrun Import – Data Mapping

When importing client data from Xero to Dryrun, two common questions are:

  • Where does Xero data come from exactly?
  • Where does Xero data map to in Dryrun?

Here’s your answer:

Bills

Bills: Amount Due

Xero Bill Item Amount in Dryrun

Bills: Due Date

Xero Bill Due in Dryrun

Bills: Planned Date (Overrides Due Date when it is used on an item in Xero)

Xero Bill Planned Date in Dryrun

Bills: Item Name

Xero Bill Item Name in Dryrun

Bills: Category Name

Xero Bill Category in Dryrun

Invoices

Dryrun pulls from Xero’s income invoices, using Expected Payment Date (if available), or Due Date (if EPD unavailable)

Invoices: Amount Due

Xero Invoice Amount in Dryrun

Invoices: Due Date

Xero Invoice Due Date in Dryrun

Invoices: Expected Date (Overrides Due Date when it is used on an item in Xero)

Xero Invoice Expected Date in Dryrun

Invoices: Item Name

Xero Invoice Item Name in Dryrun

Invoices: Category Name

Xero Invoice Category Name in Dryrun

Bank Balance

Bank Balance to Month Start: Dryrun pulls from Xero’s Bank Summary report, query on every month, taking the Opening Balance figure

Bank Balance to Today: Dryrun pulls from Xero’s Bank Summary report, query on today’s date, taking the Opening Balance figure

Bank Balance: Amount

Xero Bank Balance Amount in Dryrun

Bank Balance: Bank Accounts (If more than one account is selected for sync, the amounts will be compiled)

Xero Bank Balance Account to Dryrun

Bank Balance: Date (Taken from Opening Balance)

Xero Bank Balance Date in Dryrun

Partial Payments

Dryrun will split items up into individual payments when partial payments are accepted in Xero.

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 (or ‘expected date’ if that function is used.)

Partial Payment: Amount and Date of a Payment (Dryrun will track as many payments as required)

Xero Partial Payment in Dryrun

Partial Payment: Balance Due (The balance due will refresh to the due date/expected date)

XeroXero Partial Payment Balance in Dryrun

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: Original Amount (The amount paid in a non-native currency)

Xero Currency Original Amount in Dryrun

Multi Currency: Converted Amount (Converted in Xero to your native currency)

Xero Currency Converted in Dryrun

Multi Currency: Exchange Rate (Exchange provided by Xero)

Xero Currency Exchange Rate in Dryrun

Seeing something unusual in your 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