Excel Invoice Maker

Description
Excel file template to create and save invoices, make PDF invoices, and track total sales, collected sales, and accounts receivable.
It is perfect for small businesses who need simple and easy invoice maker template.


This Excel invoicing file includes:


Invoice Template
Excel template to prepare and save sales invoices:

• Sales invoice template with VAT
• Automatic invoice number from last saved invoice
• Drop down list selection for customer details, products or services description, and payment terms
• Automatic subtotal, VAT, total amount, and due date
• Invoice saved as PDF file, invoice data saved for analytics purposes

Accounts Receivable KPIs
Financial cash collection KPIs:

• Total sales, and collected sales
• Total amount of accounts receivable

This invoicing template is quite easy to use, you just need to:

• Create and save sales invoices
• Enter payments received for each invoice

Template Requirements:

• Works on PC with Windows.
• Does not work on a MAC.
• Requires Microsoft Excel 2016 or higher with Power Pivot add-in. 👉 Watch this video to find out if your Excel version includes the Power Pivot add-in https://youtu.be/-3U0Om5d_JU
• Allow Macros to run (enable content when opening file).
• Ready-to-use template, just enter or import your data.
• Dashboard ready to be printed.
• Instructions on Excel file “User Guide”.

Template Customization:
Colors, fonts, and all style attributes can be changed to suit your needs. If you want to make changes on your own, just enter the password included with the file to unlock the template.