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.
