0% found this document useful (0 votes)
8 views9 pages

Automated Invoice Creation in Excel

Uploaded by

Koné Sékou
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views9 pages

Automated Invoice Creation in Excel

Uploaded by

Koné Sékou
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

Invoice Number Invoice Date Customer Name Address City

INV1000 6-Aug-23 Customer 9 Address 77 City 28


INV1000 6-Aug-23 Customer 9 Address 77 City 28
INV1000 6-Aug-23 Customer 9 Address 77 City 28
INV1000 6-Aug-23 Customer 9 Address 77 City 28
INV1000 6-Aug-23 Customer 9 Address 77 City 28
INV1000 6-Aug-23 Customer 9 Address 77 City 28
INV1001 11-Jul-23 Customer 35 Address 92 City 28
INV1001 11-Jul-23 Customer 35 Address 92 City 28
INV1001 11-Jul-23 Customer 35 Address 92 City 28
INV1001 11-Jul-23 Customer 35 Address 92 City 28
INV1001 11-Jul-23 Customer 35 Address 92 City 28
INV1001 11-Jul-23 Customer 35 Address 92 City 28
INV1002 23-Feb-23 Customer 57 Address 90 City 11
INV1002 23-Feb-23 Customer 57 Address 90 City 11
INV1002 23-Feb-23 Customer 57 Address 90 City 11
INV1002 23-Feb-23 Customer 57 Address 90 City 11
INV1002 23-Feb-23 Customer 57 Address 90 City 11
INV1002 23-Feb-23 Customer 57 Address 90 City 11
INV1003 14-Sep-23 Customer 89 Address 20 City 10
INV1003 14-Sep-23 Customer 89 Address 20 City 10
INV1003 14-Sep-23 Customer 89 Address 20 City 10
INV1003 14-Sep-23 Customer 89 Address 20 City 10
INV1004 29-Jul-23 Customer 42 Address 67 City 32
INV1004 29-Jul-23 Customer 42 Address 67 City 32
INV1004 29-Jul-23 Customer 42 Address 67 City 32
INV1004 29-Jul-23 Customer 42 Address 67 City 32
INV1005 30-Aug-23 Customer 16 Address 74 City 23
INV1005 30-Aug-23 Customer 16 Address 74 City 23
INV1005 30-Aug-23 Customer 16 Address 74 City 23
INV1005 30-Aug-23 Customer 16 Address 74 City 23
INV1006 14-Aug-23 Customer 5 Address 20 City 10
INV1006 14-Aug-23 Customer 5 Address 20 City 10
INV1006 14-Aug-23 Customer 5 Address 20 City 10
INV1006 14-Aug-23 Customer 5 Address 20 City 10
INV1007 14-Oct-23 Customer 4 Address 18 City 45
INV1007 14-Oct-23 Customer 4 Address 18 City 45
INV1007 14-Oct-23 Customer 4 Address 18 City 45
INV1007 14-Oct-23 Customer 4 Address 18 City 45
INV1008 8-Jan-23 Customer 39 Address 13 City 8
INV1008 8-Jan-23 Customer 39 Address 13 City 8
INV1008 8-Jan-23 Customer 39 Address 13 City 8
INV1008 8-Jan-23 Customer 39 Address 13 City 8
INV1009 1-May-23 Customer 23 Address 91 City 16
INV1009 1-May-23 Customer 23 Address 91 City 16
INV1009 1-May-23 Customer 23 Address 91 City 16
INV1009 1-May-23 Customer 23 Address 91 City 16
INV1010 3-Oct-23 Customer 95 Address 58 City 12
INV1010 3-Oct-23 Customer 95 Address 58 City 12
INV1010 3-Oct-23 Customer 95 Address 58 City 12
INV1010 3-Oct-23 Customer 95 Address 58 City 12
PIN GSTIN Item Name Unit Price Qty
773744 27AAHP101252ZM Item 8 $342.32 3
773744 27AAHP101252ZM Item 4 $321.36 4
773744 27AAHP101252ZM Item 10 $266.07 7
773744 27AAHP101252ZM Item 5 $711.19 3
773744 27AAHP101252ZM Item 5 $656.43 3
773744 27AAHP101252ZM Item 5 $628.16 1
773744 27AAHP101252ZM Item 1 $560.51 4
773744 27AAHP101252ZM Item 2 $355.40 3
773744 27AAHP101252ZM Item 4 $773.43 8
773744 27AAHP101252ZM Item 11 $579.36 8
773744 27AAHP101252ZM Item 10 $548.60 1
773744 27AAHP101252ZM Item 14 $214.82 4
385977 27AAHP412066ZM Item 17 $536.07 3
385977 27AAHP412066ZM Item 13 $613.70 2
385977 27AAHP412066ZM Item 2 $432.02 8
385977 27AAHP412066ZM Item 17 $426.77 1
385977 27AAHP412066ZM Item 3 $290.30 3
385977 27AAHP412066ZM Item 12 $488.49 5
399888 27AAHP350875ZM Item 15 $987.86 5
399888 27AAHP350875ZM Item 1 $244.61 1
399888 27AAHP350875ZM Item 2 $772.72 4
399888 27AAHP350875ZM Item 19 $901.47 6
906741 27AAHP661419ZM Item 6 $516.28 5
906741 27AAHP661419ZM Item 15 $645.20 7
906741 27AAHP661419ZM Item 11 $327.19 6
906741 27AAHP661419ZM Item 18 $207.79 6
686580 27AAHP536341ZM Item 10 $433.42 7
686580 27AAHP536341ZM Item 16 $502.67 1
686580 27AAHP536341ZM Item 4 $389.87 8
686580 27AAHP536341ZM Item 1 $583.40 1
399888 27AAHP350875ZM Item 16 $905.69 4
399888 27AAHP350875ZM Item 9 $770.90 6
399888 27AAHP350875ZM Item 16 $318.22 6
399888 27AAHP350875ZM Item 9 $420.49 8
994751 27AAHP170390ZM Item 11 $313.50 2
994751 27AAHP170390ZM Item 16 $191.60 8
994751 27AAHP170390ZM Item 6 $178.23 4
994751 27AAHP170390ZM Item 14 $681.33 6
434618 27AAHP960395ZM Item 13 $133.01 8
434618 27AAHP960395ZM Item 17 $237.57 2
434618 27AAHP960395ZM Item 19 $578.90 6
434618 27AAHP960395ZM Item 15 $196.45 6
228778 27AAHP686165ZM Item 17 $288.41 9
228778 27AAHP686165ZM Item 8 $118.06 2
228778 27AAHP686165ZM Item 3 $394.75 5
228778 27AAHP686165ZM Item 8 $267.91 5
251456 27AAHP225917ZM Item 11 $742.01 2
251456 27AAHP225917ZM Item 19 $634.23 4
251456 27AAHP225917ZM Item 4 $439.56 9
251456 27AAHP225917ZM Item 18 $810.25 4
Sub Total Discount% Discount Tax% Tax Amount
$1,026.96 12 $123.24 12 $108.45
$1,285.44 8 $102.84 5 $59.13
$1,862.49 5 $93.12 13 $230.02
$2,133.57 10 $213.36 12 $230.43
$1,969.29 12 $236.31 11 $190.63
$628.16 13 $81.66 11 $60.11
$2,242.04 18 $403.57 5 $91.92
$1,066.20 18 $191.92 5 $43.71
$6,187.44 13 $804.37 14 $753.63
$4,634.88 18 $834.28 9 $342.05
$548.60 17 $93.26 8 $36.43
$859.28 16 $137.48 13 $93.83
$1,608.21 19 $305.56 12 $156.32
$1,227.40 9 $110.47 5 $55.85
$3,456.16 10 $345.62 12 $373.27
$426.77 7 $29.87 9 $35.72
$870.90 16 $139.34 10 $73.16
$2,442.45 18 $439.64 10 $200.28
$4,939.30 7 $345.75 10 $459.35
$244.61 13 $31.80 10 $21.28
$3,090.88 7 $216.36 10 $287.45
$5,408.82 5 $270.44 11 $565.22
$2,581.40 11 $283.95 7 $160.82
$4,516.40 15 $677.46 6 $230.34
$1,963.14 19 $373.00 11 $174.92
$1,246.74 7 $87.27 7 $81.16
$3,033.94 15 $455.09 12 $309.46
$502.67 6 $30.16 6 $28.35
$3,118.96 6 $187.14 7 $205.23
$583.40 15 $87.51 8 $39.67
$3,622.76 9 $326.05 13 $428.57
$4,625.40 9 $416.29 8 $336.73
$1,909.32 9 $171.84 12 $208.50
$3,363.92 9 $302.75 8 $244.89
$627.00 18 $112.86 14 $71.98
$1,532.80 14 $214.59 9 $118.64
$712.92 12 $85.55 5 $31.37
$4,087.98 9 $367.92 11 $409.21
$1,064.08 18 $191.53 5 $43.63
$475.14 18 $85.53 14 $54.55
$3,473.40 16 $555.74 5 $145.88
$1,178.70 16 $188.59 11 $108.91
$2,595.69 13 $337.44 6 $135.50
$236.12 13 $30.70 11 $22.60
$1,973.75 7 $138.16 10 $183.56
$1,339.55 17 $227.72 10 $111.18
$1,484.02 5 $74.20 5 $70.49
$2,536.92 12 $304.43 7 $156.27
$3,956.04 15 $593.41 7 $235.38
$3,241.00 16 $518.56 14 $381.14
Total Amount
$1,012.17
$1,241.74
$1,999.38
$2,150.64
$1,923.60
$606.61
$1,930.40
$918.00
$6,136.70
$4,142.66
$491.77
$815.63
$1,458.97
$1,172.78
$3,483.81
$432.62
$804.71
$2,203.09
$5,052.90
$234.09
$3,161.97
$5,703.60
$2,458.27
$4,069.28
$1,765.06
$1,240.63
$2,888.31
$500.86
$3,137.05
$535.56
$3,725.28
$4,545.84
$1,945.98
$3,306.06
$586.12
$1,436.85
$658.74
$4,129.27
$916.17
$444.16
$3,063.54
$1,099.02
$2,393.75
$228.02
$2,019.15
$1,223.01
$1,480.31
$2,388.76
$3,598.02
$3,103.58
TAX Invoice
PK: An Excel Expert Bill To:
321 Avenue A Customer 35

Portland, OR 12345 Address 92

Phone: (206) 555-1163 City 28

Fax: (206) 555-1164 773744

[Link] GSTIN: 27AAHP101252ZM

Invoice Number: INV1001 Invoice Date: 11-Jul-23

Item Name Unit Price Qty Total Amount


#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?
#NAME? #NAME? #NAME? #NAME?

Sub Total $15,538.44


Discount $2,464.88
Tax $1,361.58
Total $14,435.15

Thank You!

You might also like