Syncing Katana Purchase Orders to Xero as bills
Katana x Xero integration allows creating bills in Xero based on Katana 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:
|Purchase order #||-||Will not be synced to 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".
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.