LibreOffice Logo LibreOffice Logo Extensions, Documentation and Templates repository

Automated Multi-Invoice Collection

Choose from multiple variations of your invoice to initialize with the next available invoice number.Saves/prints to pdf with a descriptive filename.

★ ★ ☆ ☆ ☆
Business Spreadsheets Templates
Download latest

latest release: 2024-03-21 18:52:31

Description

Automated Multi-Invoice Collection

 

auto-increment  -  easy-name  -  easy-print-pdf  -  easy-open-dir   -  easy-customize   etc...

Choose an invoice template from the tabbed sheets then...

Push the Green “Initialize this Invoice” button on the invoice sheet...


- supply a customer abbreviation, preview invoice number ( change only if necessary ).
- other invoice tabs go away... now you are editing a new auto-incremented single invoice file.
- Descriptive filename using invoice number and your company and customer company abbreviations : e.g. Invoice5024-Me-Cust1.odf

 

Push the “MakePDF” button:


- generate a PDF such as: ./PDF/Invoice-5024-Me-Cust1.pdf

More handy buttons
... to open the new pdf, open the file directory or add rows.


Easy to customize...


See the Settings sheet tab.
Modify/Delete/Add invoice sheets easily:
Link to the date and invoiceNumber fields on the separate settings sheet, copy over the buttons and that’s it!


All your invoice templates in one file!

 

Release Description Compatibility Operating Systems License Release notes Updated  
1.2 multi-invoice chooser version 3.3 Linux, Windows, macOS LGPL Separate Settings sheet and multiple invoice sheets to choose from ( all but the selected one are removed for saving new invoice )

Separate settings sheet allows for easy addition/duplication/modification of template sheets.  Older versions of this template had the settings on the same sheet.

More buttons - print pdf but also buttons to open pdf and containing directories.

** Not tested on Windows and MacOS, nor am I sure of minimum compatible version. Feedback welcome. **
2020-10-01 11:43:35 Download
1.1 Invoice template with Invoice number auto-increment and a save filename including invoice number, company and client abbreviations. 5.0 Linux, Windows, macOS CC-BY First Release
JustInvoice.ots
By using this template you assume all responsibilities and risks.

Developed on Linux. Not tested elsewhere.

Setup: Modify to reflect your own company. Don't forget to enter a abbreviated company name which will be used in the filename of each invoice - keep it short!

Use:

     1)  Open template and press green button.

You can set a starting invoice number here ( which will be automatically incremented the next time you open the template )
Enter an abbreviation for the customer name - you will see the generated invoice filename which will be saved ( and also used for the pdf generation )

     2)  Change Orange highlighted areas ( they will automatically change to white ) and other areas to make your invoice.

     3) Press the PDF button to generate a pdf

     4) Close the file and say YES to save your changes!

     5) Open the template again - press the green button and you should see the next invoice number generated.

It will create Invoice and PDFs directories under the base directory on first use.

 

Feedback Welcome!

 

Forseen use cases:
Identical settings in multiple templates: Handy for different types of billing with different layouts but incrementing from the same invoice number.

Slightly different company abbreviation: Identify different employees/templates generating invoices.

Different base directory: different company with own (potentially same) invoice numbers.

 

Known Risks:
 A very rare possibility: For multiple users from a shared filesystem; If the template is used simultaneously they will both try to claim the next invoice number. In most cases one will see the number is taken and refuse to use it but there's a very slight chance the first file will get written in between the check and write of the second file.The check and save happens after the dialog is closed and in immediate succession.
2020-03-05 23:37:55 Download

Related Extensions

Stock Trading Investing Log Journal for DayTrading, Swing Trading, Investors

Logo for Stock Trading Investing Log Journal for DayTrading, Swing Trading, Investors

Stock Market Trader: YOU need a spreadsheet! LearnN.ods tracks your trades; Supports multiple brokers, any trading style (day, swing, investing), counts your day-trades, logs your errors, improves your game!&l

04-2024

783

Not rated yet

Automated Multi-Invoice Collection

Screenshot for Automated Multi-Invoice Collection

Choose from multiple variations of your invoice to initialize with the next available invoice number.Saves/prints to pdf with a descriptive filename.

04-2024

4541

★ ★ ☆ ☆ ☆

Vehicle Mileage Template

Screenshot for Vehicle Mileage Template

A Calc template to record vehicle mileage and expenses.

04-2024

840

Not rated yet

Toutes mes factures regroupées dans un document.

Screenshot for Toutes mes factures regroupées dans un document.

Modèle de facturation permettant d'ajouter/modifier/sauvegarder/relire des factures. Base de données clients dans un onglet du même document. Template to add/modify/save/read all your invoices. your customers are grouped in a separate tab.

04-2024

3157

Not rated yet

Time Sheet Template For Two Week Pay Cycle

Screenshot for Time Sheet Template For Two Week Pay Cycle

Calc Template to calculate time for a two week pay cycle. Keep track of time taken for lunch, vacation or sick time, etc.

04-2024

879

Not rated yet

Time Planner

Logo for Time Planner

A Timeplates template for organizing your to-do list.

04-2024

1369

Not rated yet

Feedback

★ ★ ☆ ☆ ☆

Post your review

You cannot post reviews until you have logged in. Se connecter.

Reviews

  • Bug Menot 9 févr. 2024, 13:05 (Il y a 10 mois)

    ★ ★ ★ ★ ☆

    Important detail: on the sheet "Invoice_Easy_To_Add_Other", it is impossible to set F33 (Discount %) to 0 or leave it empty, without causing a totals error. For this to be possible, the value of F35 (TOTAL) must be changed
    from
    =SI(F32-F34=0; "0.00";F32-F34)
    to
    =SI(F33=0;F32;F32-F34)
    I invite the creator to correct this annoying element.
    Apart from that, it's good work, simple and effective.

  • Kurt Etzel 27 mai 2023, 07:08 (Il y a 18 mois)

    ★ ★ ★ ★ ☆

    Great work! Having an error with MakePDF, here is the error below. Will keep looking for a solution, maybe I missed an instruction.

    BASIC runtime error.
    An exception occurred
    Type: com.sun.star.io.IOException
    Message: SfxBaseModel::impl_store <file:///C:/Users/Etzel/Documents/JustInvoice/PDFs/file:///C:/Users/Etzel/Documents/JustInvoice/Invoices/Invoice1-GSM-Test.pdf> failed: 0x507(Error Area:Io Class:Access Code:7).

  • jf f 2 mai 2023, 20:05 (Il y a 19 mois)

    ☆ ☆ ☆ ☆ ☆

    Hello,
    Thanks for the file!
    Just a problem on windows 7 and LibreOffice 7.4.6.2:
    PDF export is not working, error below:
    Erreur d'exécution BASIC.
    Une exception s'est produite :
    Type: com.sun.star.io.IOException
    Message: SfxBaseModel::impl_store <file:///C:/Users/........./Factures clients/JustInvoice/PDFs/file:///C:/Users/...../Factures clients/JustInvoice/Invoices/IC-239-456.pdf> failed: 0x507(Error Area:Io Class:Access Code:7).

    • Kurt Etzel 27 mai 2023, 07:10 (Il y a 18 mois)

      Did you get yours fixed?

  • Robert Pickering 23 avr. 2021, 21:33 (Il y a 4 année)

    ☆ ☆ ☆ ☆ ☆

    how does this download?

  • Robert Pickering 23 avr. 2021, 21:27 (Il y a 4 année)

    ☆ ☆ ☆ ☆ ☆

    looks good . how do i get it? no luck so far

  • Christoph Henkel 13 oct. 2020, 23:39 (Il y a 4 année)

    ★ ★ ★ ★ ★

    Hi,
    very great job - thank You.
    I am trying the template for my new small business.
    It is very easy to make changes for own purposes, fomats, currency...
    It could be nice, if the Invoice# has more digits instead of maximum four - but this doesn't matter.
    so long,
    Chris

RSS feed for reviews on this page | RSS feed for all reviews