Skip to main content

Export expenses and payments to Microsoft Business Central

Updated this week

You are now ready to prepare your payables on Spendesk and export them to Microsoft Business Central.

Bookkeep your payables​

You can bookkeep your expenses using all of your familiar Microsoft Business Central accounts and values. Once you are ready to export your expenses to Microsoft Business Central, navigate to Bookkeep > Export and select the desired period to export.

Important notes:

  • Spendesk exports recognized expenses - expenses that passed all configured approval flows and were prepared by finance. We do not create any accounting entries for expenses that are still under review.

  • The documentary evidence for one payable (receipts, invoices, screenshots) are merged into a single PDF and this PDF is then exported.

  • Payables (purchase invoices) can be exported in their original currency. Please ask your Spendesk representative to enable this for you. Make sure you have a Currency Exchange rate service configured by following these steps, so that Unrealised Gains or Losses can be calculated until the invoice is paid.

    Payments are exported to Microsoft Business Central bank journal in wallet currency. Once invoices are posted, Microsoft Business Central will calculate Realized Gains or Losses automatically.

Push your payables to Microsoft Business Central

You will see a preview of the payables ready to be exported. Click Push to Microsoft Business Central to export them in bulk. You can also export a single payable. Payables will be exported as Draft purchase invoices or credit memos to the purchase journals you previously configured. Payments will be exported as payment journal entries in the payment journal you also configured.

  • Expense claims are exported as Draft purchase invoices (where vendor is the employee) in the journal selected for expense claims. Reimbursements of expense claims are exported as entries in the Payment journal.

  • Invoices and Card purchases are exported as Draft purchase invoices in the journal selected for invoices. Invoice payments made from Spendesk are exported as entries in the Payment journal.

  • Credit notes and Card refunds are exported as Draft purchase credit memos in the journal selected. Corresponding card payments are exported as entries in the payment journal.

  • FX, ATM and other bank fees are exported as entries in the selected Payment journal using the bank charges account you configured previously.

  • Wallet loads (wire transfers to top-up your Spendesk wallet) are exported as entries in the selected Payment journal.

You should now be all set up to use this integration with Microsoft Business Central and export your payables every month or when you need to.

Did this answer your question?