Skip to main content

1-05 Export data as Bank Transactions (great for Xero Cashbook)

Jan Korecky avatar
Written by Jan Korecky
Updated over 2 weeks ago

In Datamolino, you can export bills into Xero's Bank Accounts. This allows you to bypass the Accounts Payables and instead immediately create a spend money transaction in Bank Accounts.

This workaround works great for receipts that have been already paid by cash or credit card. This way you can post them directly as a spend money transaction and choose the correct โ€˜Bank Accountโ€™.

How to set the all invoices from a supplier to export into Bank Transactions?

When inside the document, go to supplier automation:
โ€‹

In the automation settings, make the change to export all invoices as Bank Transactions, select the bank account and the bank transaction type and click 'save'. From now on, all invoices from this supplier will be pre-selected as bank transactions.
โ€‹

Export individual item into Bank Transactions

In the document detail - Supplier Section, you can choose the Export destination individually.

How to set the whole Folder to export into Bank Transactions?

You can set the whole folder to export into Bank Transactions by doing two things:

๐Ÿ‘‰ Change the default folder settings for new suppliers:
Go to Folder menu > Integration, make the desired change to export as Bank Transactions, and click Save. This will apply to all new suppliers added to the folder via Datamolino.

๐Ÿ‘‰ Update existing suppliers in the folder:
Go to Folder menu > Automation contacts > Mass edit supplier automation settings, make the same change, and click Save. This updates all existing suppliers in the folder.

...if you want to learn more about these automation settings, click here.

Bank Transactions exports behave the same as Bill exports, you can read more about exports here: Export data as Purchase Bills (or Sales invoices).


โ€‹


โ€‹
โ€‹

Did this answer your question?