The Katana to Xero integration allows bill creating in Xero based on Katana Purchase orders and Outsourced Purchase orders with a single click of a button.

Note: This integration does not support recording Katana Purchase Orders just as expenses in Xero (without creating bills) or creating Purchase Orders in Xero. It only supports creating bills in Xero.

When you have connected your Xero account to Katana, you can see a new "Bill" column in the "Buy" screen in Katana.

Selecting "Create bill" for a Purchase Order will create a matching bill in Xero. The "Bill" status will change to "Bill created Xero".

The value of the transaction will be recorded on the Xero account you selected during the initial connection of Xero to Katana.

Note: Billing status cannot be reverted back to "Not billed" in Katana. You need to delete the bill in Xero, which will also revert the status in Katana. Reflecting the status back to Katana might take a few minutes.

Clicking on the status will direct you to the relevant bill in Xero.

Data between Xero and Katana is matched as follows:

Katana

Xero

Comments

Purchase order #

Reference

Katana Purchase Order number is sent to Reference field on the bill created in Xero.

Supplier

Supplier

Suppliers are matched based on email. Suppliers that do not exist in Xero are created automatically.

Created date

Bill date

Bill date in Xero equals the Created date for the Purchase Order in Katana.

Expected arrival

-

Not synced to Xero.

-

Due date

Assigned automatically to the bill based on your Xero settings.

Line item

Line item

Purchase Order line items in Katana will be added as bill lines in Xero. SKU of the item is added to the Item Code and the Item name will be added to the Description field of the bill. Account on the bill is based on the ledger accounts mapping defined for purchasing during the initial Katana x Xero connection.

Quantity

Quantity

If you are using unit conversions in Katana for purchased items, then the bill in Xero displays the quantity in your Katana Stock Unit of Measure, not Purchase Unit of Measure.

Price per unit

Unit price

Price per unit from Katana Purchase Order is synced to Unit Price on Xero bill.

Tax %

Tax rate

Assigned to the line item in Xero based on the tax rate mapping defined during the initial connection of Xero to Katana.

All bills in Xero are created as "Tax Exclusive".

Deleting bills

You can only delete bills in Xero

Click on the "Bill created Xero" status for a specific Purchase Order in Katana to open the respective bill in Xero.

When you delete a bill in Xero that is created via Katana integration, the "Bill" status for the related Purchase Order is reverted back to "Not billed".

Note: It might take up to 15 minutes for the "Bill" status to update in Katana after deleting the bill in Xero.

Did this answer your question?