A dashboard I created on Google Sheets to ensure you reach your financial goal through centralising and automating invoice management. I used Google App Script to automate PDF creation and invoice emailing.

gsheetscriptsinvoiceautomation

01 * The dashboard

It helps you understand where your finances go. From scheduled, incoming or paid invoices, you can forecast and ensure you meet your financial goals.

02 * Sheets

The magic lies with the sheets with each invoice linked to projects & companies. I use googlefinance on the closest date to convert the amount to euros.

03 * Emailing

Once your data is good to go, you can generate an invoice following a template. Then an email will be ready to be sent in your drafts.