Xero expenses synced with Core

Core expenses sync with Xero expenses. Here we are explaining the expense data flow between Core and Xero with an example.

Let us take an expense item in Xero, Mileage Travel, with the following field values:

Xero.jpg

As you can see, the Purchase Unit Price = 10

Sales Unit Price = 21

On syncing this item from Xero to Core, the data is mapped in the following way in Core:

Xero_2.jpg

Xero

 Data Flow

Core 

Item Code

<->

Expense Item Code

Sales Description

<->

Expense Item Description and Activity Item Memo

Sales Unit Price

<->

Markup

Purchases Unit Price

<->

Cost Rate

Sales Account

<->

Income Account

Purchase Account

<->

Expense Account

Purchase Tax Code Default Rate

<->

Purchase Tax Rate

From the above mapping, it is clear that:

  • In this case, GST on Expenses tax code default rate is 10% in Xero and the Purchase Tax Rate for the synced expense in Core is 10.
  • Xero Sales Unit Price maps to the Markup in Core by a calculation. To calculate the markup for the synced expense item in Core, the formula is specified as below:

Markup = ((Sales Unit Price – Purchase Unit Price) / Purchase Unit Price) x 100

So, in the above case,

[(21 -10) / 10)] x 100 = 110

Accordingly, the markup in Core is calculated as 110. So on syncing the specified expense item, Cost Rate will be 10, Purchase Tax Rate will be 10 (or any other value from the tax code in Xero) and markup will be 110.

Was this article helpful?
0 out of 0 found this helpful