Continue to WhatsApp?

The chat opens in WhatsApp, in the app or in a new tab. You leave our website, and data such as your IP address is sent to WhatsApp (Meta).

BLOG: EXCEL, INVOICES, DATA

Guides for less office work.

Comparing lists by hand, typing up invoices, entering data twice: it costs hours every week and leaves the worry that a mistake slipped through. Our guides show you step by step how to get that work done faster and with more certainty, with worked examples and honest limits.

  • 17 guides with worked examples
  • For Austria and Germany
  • Fact checked, sources listed

ALL GUIDES

Find the guide for your task.

17 guides

Excel and lists

When two lists do not match, the searching starts. These guides show how to compare lists, find gaps and duplicates and spot price changes without checking every line yourself.

Invoices and e-invoicing

Typing, checking, chasing: incoming invoices take more time than they should. Read which steps can be automated and what e-invoicing rules in Germany and Austria require of you.

Data and imports

Entering the same data into two programs is tedious, and every copy is a chance for an error. Here is how to move data reliably from one program to another by import or interface.

Planning automation

Before you spend money, you want to know whether it pays off. These guides help you work out costs and payback with your own figures, including the case where it does not.

FASTER THAN ANY GUIDE

Try it yourself right away, for free.

Tools for the most common questions in our guides. Right in your browser, no sign up.

Files stay on your device
FOR YOUR INVOICES

What does the e-invoice say?

Read an XRechnung or ZUGFeRD invoice like a paper one, with totals recalculated and the IBAN checked.

Open the e-invoice viewer
FOR YOUR CUSTOMERS

How does a PDF become an e-invoice?

Turn your usual PDF invoice into ZUGFeRD or XRechnung, with totals and required details checked.

Create an e-invoice
FOR PURCHASING

What costs more now?

Compare the old and the new price list and see every increase in percent. Even from a PDF.

Compare price lists
FOR YOUR LISTS

What has changed?

Compare two Excel or CSV files and instantly see missing, changed and duplicate entries.

Compare Excel files
FOR YOUR MASTER DATA

Who is in there twice?

Find duplicate customers, suppliers or items, even Müller and Mueller. You decide what stays.

Find duplicates
FOR YOUR REPORTS

How do twenty files become one?

Merge several Excel files or worksheets into one table, even when the columns are in a different order.

Merge Excel files
FOR YOUR POST

How does the list get onto labels?

Print an address list from Excel onto label sheets, no mail merge needed. Even on a partly used sheet.

Print labels
FOR IMPORTS

Why is the CSV broken?

Garbled characters, the wrong delimiter, lost zeros: detect, repair and download a clean file.

Repair a CSV file
FOR YOUR DECISION

What does your routine cost?

Work out the effort and the possible savings with your own numbers. Every assumption stays visible.

Calculate time

RATHER HAVE IT SOLVED THAN READ ABOUT IT?

Recognise your own workflow? We will take it off your hands.

Describe your task in a few sentences. We will tell you honestly whether automation pays off and, if it does, build an office helper that takes over exactly that work.

  • Personal reply within 1–2 working days
  • Small projects built in 3–7 days
  • Fixed price from €1,990 excl. VAT
Team going through documents together at a wooden table

COMING SOON

Guides we are writing right now.

Your question is not on the list? Let us know. We are happy to pick up questions from everyday work as our next topic.

  • Data and importsCSV opens in one column: causes and fixFor: Administration
  • Data and importsKeep leading zeros when importingFor: Purchasing and administration
  • Data and importsStandardise date formats for CSV importsFor: Administration
  • Data and importsConvert decimal comma and decimal point safelyFor: Finance
  • Data and importsMap columns for a CSV importFor: Operations
  • Data and importsWhy a CSV import failsFor: Administration
  • Data and importsPreparing a BMD import: what to clarify firstFor: Finance, Austria
  • Data and importsDATEV data transfer: interface or file?For: Finance, Germany
  • Invoices and e-invoicingProcessing e-invoices in GermanyFor: Finance, Germany
  • Invoices and e-invoicingElectronic invoices in Austria explainedFor: Finance, Austria
  • Invoices and e-invoicingXRechnung, ZUGFeRD and PDF comparedFor: Finance
  • Invoices and e-invoicingExtracting invoice data: structured or OCR?For: Finance
  • Planning automationOffice work in the trades: three tasks to check firstFor: Trades
  • Excel and listsMatching supplier lists in a trade business officeFor: Trades purchasing
  • Planning automationKeep your software and connect your workflowsFor: Management
  • Planning automationLocal AI or cloud for office workflows?For: Management and IT
  • Planning automationWhich running costs remain with local processingFor: Management
  • Invoices and e-invoicingChecking invoices against orders line by lineFor: Purchasing
  • Planning automationPlanning realistic review time for automationsFor: Management and finance
  • Planning automationPreparing an automation: checklist for your workflowFor: Prospective clients

READ ON

More answers around your workflow.

LET'S TALK ABOUT YOUR WORKFLOW

Write to us. We reply personally.

A question, an idea or a task that costs time every week? A few sentences are enough. You get an honest answer from the people who also build your office helper.

Ivan, Lukas & JanReply within 1–2 working days

  • Personal reply
  • No obligation
  • Based in Vienna, GDPR aware
Photo of Ivan
Rather talk directly?Ivan, your contact person+43 676 59 40 027office@pebblebyte.comMon to Fri 08:00–18:00
Have a specific task? Get your free workflow check

Your message

Please do not enter passwords or confidential customer data. We only use your details to handle your request. No newsletter, no sharing for advertising. Details in our privacy notice.