In the last couple of weeks, we have worked hard to optimise our system to keep up with the increased demand for Datamolino. We are also thinking hard about our users, so even when we are working on the "invisible parts" of Datamolino, we try to squeeze in features that will help you to be more effective.
You can now forward your HTML receipts to Datamolino, we will create a PDF from your email receipt. Because we create a PDF, this allows us to upload the resulting file to your accounting system if file attachments are supported (Xero).
How do we process your emails now? If an email contains a PDF file, only the PDF will be processed. If an email does not contain a file attachment, Datamolino will create a PDF from the content that is marked as <html>. This will strip the email of unnecessary information that accumulates if the email was forwarded. In most cases this allows us to create a PDF that will appear consistent every time.
Improved file exports
You will find some new formats for you file exports. How to export to file can be found in this help file [click]. This is the list of changes:
Excel / CSV invoices / CSV line items
The excel and CSV files now contain the essential invoice data and some additional columns to make your life easier:
- INVOICE DATA: invoice_number, company_name, company_tax_id, issue_date, due_date, description, sub_total, vat_total, total, currency
- DOCUMENT TYPE: invoice or credit note
- IMPORT DATE: this is date that the original file has been uploaded to Datamolino
- ORIGINAL FILE NAME: name of the original file that was uploaded to Datamolino
- DTMLN FILE NAME: the file name as the file is saved in your folder. Datamolino renames the files if we split the original file into multiple transactions.
- DTMLN LINK: this is the web address of the invoice in your Datamolino folder. You can access it if you are logged in to Datamolino and have the access rights to the folder where the invoice is located
Please note: The CSV export has now two variants: The "CSV invoices" exports only the invoice summary data, the "CSV line items" exports the invoice data as individual line items (you must be on the DETAILED user plan)
We have implemented the Sage "Audit Trail Transactions" template as found in the Sage documentation here. You still need to amend some data into the columns manually in a spreadsheet program.
Technical note to the Excel and CSV files
The decimal separator is " ." and in the CSV files the column separator is ";". When you open the files in Excel it depends on your regional settings. For some users, numbers with decimal separator "." show as "text". In this case, it is easiest to select the column and do a find and replace from dot "." to a comma ",". When importing a CSV to Excel it is also possible to define the decimal separator. (see screenshots).