Skip to main content

Working with Line Items in Datamolino

How to view and work with line items Datamolino. Checksum, fullscreen, automation, keyword rules and bill split explained.

Tina avatar
Written by Tina
Updated today

With line items, you can break your invoice down into individual entries and apply coding at a granular level. This is especially useful if you need to split costs across different ledger accounts or tracking categories.

Sections covered in this video:

  1. Switch to Line Item view

  2. What information is captured?

  3. Checksum - what does validation mean?

  4. When to use Fullscreen view

  5. Automate line item coding

  6. What is Bill Split

  7. Export to your accounting software

How to switch to line items view

πŸ‘‰ To view line items, change the Export as view to Line items.

πŸ‘‰ If you work with line items regularly, you can set this as your default view for the folder, so you don’t have to switch manually each time.

What information is captured?

πŸ‘‰ Datamolino automatically captures the description, quantity, amounts, and tax for each line item (where available on the invoice).

  • Your ledger accounts, tax codes, and tracking categories are synced from your accounting software.

  • You can also add or delete line items manually


Checksum - why should I have validation on?

πŸ‘‰ Keeping validation enabled helps prevent errors, missed line items, or other inaccuracies from being exported to your accounting software.

  • Datamolino automatically adds up all the individual line items and compares the total with the invoice total.

  • When validation is enabled, both totals must match before the invoice can be exported to your accounting software. If they don’t, Datamolino stops the export and shows an error, so you can fix the difference first.


When to use fullscreen view

πŸ‘‰ Fullscreen View gives you a compact layout that makes it easier to review and code multiple items quickly.

  • You can select several or all line items at once and code in bulk

  • It’s the most efficient way to handle detailed invoices.

How to automate line item coding

πŸ‘‰ Datamolino remembers your last coding choice for the same line item description in future invoices. If descriptions vary slightly between invoices but generally uses the same words, you can create keyword rules.

  • A keyword rule tells Datamolino to automatically apply specific coding whenever a description contains certain words.

  • This reduces manual work when processing repetitive supplier invoices.

πŸ’‘ More on keyword rules HERE


What is Bill Split and when to use it

πŸ‘‰ Bill Split lets you divide an invoice total into a few line items by percentage or amount - without coding each line manually.

  • Use it when you need to allocate costs between multiple ledger accounts or tracking categories, or when you want to apply different tax codes but don’t need a detailed line-by-line breakdown.

  • You can save Bill Split rule for future use or set it to be applied automatically for a specific supplier.

πŸ’‘ More on bill split HERE

Export to your accounting software

πŸ‘‰ Click Export to send the invoice to your accounting software.

  • Datamolino exports all line items along with the original invoice PDF.

  • To quickly open the invoice directly in your accounting software, click the grey forwarding icon
    ​

Did this answer your question?