Smart Invoice Settings

Excel Template Mapping

Template File

Sheet Name

Invoice No Cell

Invoice Date Cell

Company Cell

Contact Name Cell

Phone Cell

Address Cell

Note Cell

Total Cell

IFSC Cell

Account Cell

Account Name Cell

Invoice Defaults

These values are controlled from settings and auto-filled on the invoice form.

Default Invoice No

Default Address

Default Note

Default IFSC

Default Account No

Default Account Name

Item Rows

Start Row

End Row

Description Col

Amount Col

Static Sheet Values

Use one line per cell like A1=My Company.

Mail Settings

SMTP Host

Port

Security

From Name

SMTP Username

SMTP Password

From Email

Email Subject

Email Body || {invoice_no} * for actual invoice number

CC Email

Saved Uploads

Back to Invoice