Katana lets you edit the currency rate and fixed date on sales orders (SOs) and purchase orders (POs) to ensure your financial records stay accurate. This is especially useful when aligning with accounting systems or matching the actual exchange rate used during payment.
Why you might need to edit rates
To match exchange rates between Katana and your accounting system (e.g. Xero, QuickBooks).
To reflect the actual payment rate used by your bank or payment provider.
To recalculate totals in your base currency after adjustments.
How to edit the currency rate or date
Open a sales order or purchase order in a non-base currency.
If the currency rate is fixed, you’ll see an Edit rate link under the Totals section.
Example:
Click Edit rate.
Update the Currency rate or Fixed at date in the pop-up.
Important note:
Changing the Fixed at date will not automatically retrieve historical exchange rates or update the rate to match the chosen date. You must manually adjust the rate if needed.
Once saved, Katana will recalculate the converted total in your base currency.
When you cannot edit rates
If the order has already been submitted to your accounting platform (as an invoice or bill), the rate is locked in Katana.
To make changes, update the rate directly in your accounting system.
If the invoice or bill is deleted in Xero or QuickBooks, Katana will allow you to edit the conversion rate again.
Your feedback is invaluable. Let us know your thoughts on this article or anything in Katana you'd like to see improved: [email protected]