Our direct integration with Business Central allows us to have full control over the data exchanged between Payhawk and MS Dynamics 365. If you haven't connected your Xero organization to Payhawk, you can follow this guide.
Here's a diagram of all the data that MS Dynamics Business Central and Payhawk are sharing.
Transactions automatically exported to Business Central's bank accounts
For accounting reasons, we export only settled transactions. Hence, if the payment has been authorized but not settled, we will not export it. Once a transaction is settled, its settlement date and the amount will be automatically exported to the Payhawk bank account in Business Central as a bank transaction. This includes:
You can read more details about our integration with the Business Central bank feed here.
Types of expenses exported to MS Business Central
When you Mark as reviewed an expense this will push the expense to Business Central as bills.
When unpaid Bills are marked as paid or paid directly through Payhawk, they will automatically be updated as paid Bills if we manage to match it to a payment on Xero.
Payhawk data fields that are exported to Business Central
Supplier - if the supplier is not in Business Central, we create a new contact automatically
Category - mapped to the Business Central chart of accounts.
Due date - for all bank expenses Payhawk exports the due date. If there is no due date entered, the date of the expense is used as due date.
Note - the cardholder's explanatory note for the expense is shown in the Description field of the expense in Business Central.
Amount - this is the total minus the tax rate for the expense.
VAT Rate - the tax rate provided by Business Central.
Tracking Categories - Payhawk imports Business Central tracking categories and let's use them as expense fields
Fees - when there is a fee to the transaction, the fee is applied as a line item to the bank transaction in the account Fees that Payhawk created.
More questions? Feel free to write to us in the chat 💳