Zoho Sheet

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

NAME

DEBIT

CREDIT

BYB-DATE

BYB-NAME

BYB-DueDate

BYB-Amount

BYB-DrCr

10000001

Ankur Salt Pvt Ltd

260808.00

31-Mar-2007

Inv/06-07/51

23-Apr-2007

100000

10000001

31-Mar-2007

Inv/06-07/52

10-May-2007

160808

10000002

Velji & Co.

47,000.00

10000003

Vibhuti Shipping Pvt Ltd

251640.00

31-Mar-2007

Inv/06-07/53

15-May-2007

62910

10000003

31-Mar-2007

Inv/06-07/54

15-May-2007

88074

10000003

31-Mar-2007

Inv/06-07/55

15-May-2007

70459.2

10000003

31-Mar-2007

Inv/06-07/56

15-May-2007

30196.8

Remarks:-

1) udi-Magic processes the Excel sheet data and creates TRHREE Ledger Masters as given above

2) The Column ID is required in this case, to identify Ledger Master records as a single Ledger record may span to multiple rows.

3) The Ledger Master for "Velji & Co" as given above does not contain BYB details. This has been kept intentionally.

4) Ankur Salt Pvt Ltd is created under group Sundry Creditors as it has Credit balance, whereas the other TWO legders are created under Sundry Debtors

Op_ Balance Details