Skip to content
Languages
A hand plugs a USB drive into a laptop

Spreadsheet or invoicing software? Test correction and export

Spreadsheet or invoicing software? Test correction, storage and export

A spreadsheet can produce a single invoice quickly. Use fictional data to see whether you can also retrieve a sent invoice, its correction and the original files later.

·

Photo: Aleksander Dumała on Pexels

You create your first invoices from a template. A customer reports an incorrect quantity, so you edit the file. Only afterwards do you realise you no longer know exactly which version they received. To choose a tool, test the process beyond the first PDF. Run the same exercise in your current setup and in an alternative you are considering.

1. Set up a complete sample case

Use fictional customers and a clearly separated test area so nothing is sent or posted. Create a sample invoice with a unique reference, a description, quantity and amount. File it as you would after sending a real invoice. Note where the invoice number, original file and dispatch record can be found. Check whether someone else can retrieve the right file without knowing your folder structure.

2. Simulate a correction

Pretend the customer queries the quantity. Create a correction using the procedure you would follow and link it to the original invoice. See whether the two documents can be retrieved separately and clearly matched. For tax-relevant records under German law, § 146(4) of the Fiscal Code (AO) requires the original content to remain identifiable. The GoBD also explain why ordinary file storage generally needs additional measures to prevent untraceable changes.

Spreadsheets can be useful for estimates and working lists. If you use one for invoicing, review the whole process, including storage, changes and access. With invoicing software, the way you configure and use it also matters.

3. Check structured invoices and data handover

If it is relevant to your business, test a structured e-invoice. Determine separately what you must be able to receive and what you must issue. Some transactions are covered by exceptions or transitional rules for issuing. Check that you can retrieve and transfer the original file, including the structured data. A PDF view alone does not answer that question.

Export the sample case. Confirm that the original, the correction and their data are clearly linked. If you work with an adviser, ask which records and data formats they can use. Also test how you could access earlier data if you changed tools later.

4. Decide based on the gaps you find

Write down what each option handles automatically and what needs a technical or organisational control. If two people assign numbers manually, an old invoice can easily be overwritten or the export omits the original file, fix the gap before using the process. Switch after a successful correction and handover test. Record when the new process starts and where earlier records will be kept.

Before the first real invoice

  • Find the original and correction separately.
  • Trace the changes and their links.
  • Check the e-invoice scenarios and original files that matter.
  • Confirm export, access and responsibilities.

Correct an invoice · Check an e-invoice against its PDF

Sources

Photo credit: Aleksander Dumała / Pexels · Pexels license

Organise your office digitally

With Motorica you create invoices, quotes and receipts – and keep deadlines in view.

Discover Motorica   Knowledge