Vintage Invoice

Just because the invoice is a business document, doesn't mean it has to be boring

Under construction ...

This example shows how you can generate nice vintage invoices from data in a spreadsheet. It will generate a PDF document that displays the data in a table and sends it as an attachment to your customer.

The generated invoice will be uploaded to Google Drive and all generated invoices will also be tracked in the Google Sheet.

This makes invoicing very simple and all relevant data is securely stored in your beloved Google Apps.

The invoice is generated from a LibreOffice document that is used as a template. To customize the layout of the invoice, open the LibreOffice document from your local Google Drive folder.

You can modify the template to contain your company logo, address and your signature if desired.

The Google Sheet contains the timesheet and the project data like your customer's name, the currency and other settings.

Get your free copy of the Vintage Invoice Application.

Getting started

You will have to perform a few simple steps. After you have logged in to Ultradox and copied the example to Google Drive, you will find a number of files in the project folder:

Open the project folder on google drive

In the project folder you will find one LibreOffice document Vintage Invoice.

The Timesheet Spreadsheet is used to collect all the orders like the project settings, hours per date and category and the folder Invoices will contain all the generated invoices so that you can easily find and resend invoices on demand.

The red Vintage Invoice file is the Ultradoc that contains all the actions to be performed.

Make it yours

Enter project data

Open the document Timesheet directly from Google Drive or via the automation Vintage Invoice by clicking on the editing icon in the building block with referencing these document. Overwrite the sample entries and enter all relevant data into the Project and Timesheet worksheets.

Invoice number

Open the automation Vintage Invoice to format the invoice number which is predefined as follows: ${now;date(yyMMdd}-${invoices;number(0000)}

If you want to set a different format, adjust the format in the Assign values building block.

Formatting E-Mail

Open the automation Vintage Invoice to setup email formatting.

Enter the email address of the recipient of your invoices by clicking on the editing icon in the Plain text email building block. If necessary, you can also change the attachment and the subject here.

Edit LibreOffice template

To create a preview of the LibreOffice template, click on the corresponding button in the Create PDF building block menu bar. If you want to edit the invoice template, open the LibreOffice template from your local Google Drive folder.

Run

 When you are finished with your entries, you can start the automation by clicking the Run button in the automation toolbar.

Questions and Feedback

If you have any comments on this page, feel free to add suggestions right to the Google document that we are using to create this site.

If you are not yet member of the Ultradox community on Google+, please join now to get updates from our end or to provide feedback, bug reports or discuss with other users.

Last Updated: 04.03.19