Switch To
Product Links
Languages
Themes
Feedback
Sign Up Now
VBA Editor
Coriander Green
Metallic Grey
Coriander Green
Metallic Grey
Loading...
Updating...
Please wait to edit...
Ready for editing
X
Local File
URL
Name of the Document:
Note:-
- Supported file formats: xls, xlsx, sxc, ods, csv and tsv
- Only unprotected files will be imported
CSV files have data in a structured format similar to a database table. Choose the desired import option based on the recommendations provided below:
Import as...
Tabular Data
Recommended for...
- Creating PIVOT Tables and Charts
- Faster loading and performance
- Auto Filters and Freeze Columns
Normal Spreadsheet
Useful for...
- Formatting options
- Formulas & Calculations, and
- Other regular spreadsheet operations
NOTE:
There will be no option inside the document to toggle between these two views.
Spreadsheet Name:
Template Name:
Save As New Document...
Save As New Template...
Mark As New Version...
New Template
From Templates List
Show Text Only
Show Icons Only
Show Icons & Text
Vouchers - Sales Transactions ...
by
shwetasoftwares
195 views
Print
Export
Copy to My Account
Embed in Website/Blog
Tags:
Macro recorded successfully
View Macro
Macros List
|
Unsupported actions
|
Macro Recording in progress
Stop Recording
Cancel
|
Unsupported actions
|
Arial
Arial Black
Book Antiqua
Calibri
Comic Sans MS
Courier New
Garamond
Georgia
Lucida Console
MingLiU
MS Gothic
MS P Gothic
MS Mincho
MS P Mincho
MS Sans Serif
SimHei
Tahoma
Times New Roman
Trebuchet MS
Verdana
8
9
10
11
12
14
16
18
20
24
26
$
Macros
Auto Filter
Freeze Columns
This worksheet is a tabular data. Regular spreadsheet operations like cut/copy/paste, undo/redo, range selection, formulas and formatting are restricted in this mode.
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
Edit
|
Publish
|
Revert Publish
|
URL
|
Clone
ID
Territory
Party Code
Party Name
Bill No
Bill Date
Model
Quantity
Amount
BillTotalAmt-Cummulative-Totalling
VAT
BILL-Amount
BillAmountRoundedOff
INC-10549
ANDHERI EAST
4000690029
Akash Electronics
INC-10549
1/Apr/2008
N6030
3
7203.24
7203.24
288.13
7491.37
7491.00
INC-10550
GOREGAON WEST
4000620563
Satellite Electronics
INC-10550
1/Apr/2008
N1208
2
3508.80
7924.50
316.98
8241.48
8241.00
INC-10550
GOREGAON WEST
INC-10550
N6030
1
4415.70
4415.70
0
0.00
0.00
INC-10551
MALAD WEST
504
India Electronics
INC-10551
1/Apr/2008
N1208
1
1754.40
24441.33
977.65
25418.98
25419.00
INC-10551
MALAD WEST
INC-10551
N6030
5
10296.90
22686.93
0
0.00
0.00
INC-10551
MALAD WEST
INC-10551
N1208
1
2334.78
12390.03
0
0.00
0.00
INC-10551
MALAD WEST
INC-10551
N1208
1
10055.25
10055.25
0
0.00
0.00
INC-10552
DAHISAR EAST
197
Fast Track
INC-10552
1/Apr/2008
N1208
2
3508.80
8977.18
359.09
9336.27
9336.00
INC-10552
DAHISAR EAST
INC-10552
N3110c
1
5468.38
5468.38
0
0.00
0.00
Remarks:-
1) XML tags are written in cells A1, G1, H1
2) Column N, O and P ar kept for verification purpose only. These columns are not used by udiMagic
3) As Bill-Amount value is not entered manually in Excel, we have kept Column L which computes the Bill-Amount based on item-values.
4) ID field is required by udi-Magic to uniquely identify transactions. As Bill-number is also unique, we have taken it as the ID.
Bill_Wise
0 Viewing
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Export (.xls)
Export (.pdf)
Processing...
Assign Macro
Change Macro
View Code
Edit Label
More