Tally DayBook and Ledger Exercises

[admin]

1. Extract Negative ledgers in Sundry Debtors

2. Extract Negative ledgers in Sundry Creditors

3. Extract Negative ledgers in Sundry Loans

4. Ledgers created during the year

5. Ledgers where opening and closing Balances were same

6. List of Bank Ledgers

7. GST registered Debtors and Creditors

8. Unregistered Suppliers

9. Address of all Debtors and creditors

10. Sales Register

11. Purchase Register

12. Journal Register

13. 40A(3) Register

14. Sales / Purchase Transactions without GST

15. List of sundry Debtors > 100000

16. List of Sundry Creditors > 100000

17. Sales Transactions Less than 1 Lakhs

18. Group Trial Balance

19. Cash Flow Affecting Transactions summary / List

20. Entry Altered in the last week.

21. Ledgers altered in the last week.

22. Ledgers with no transactions.

23. Ledgers where it is squared off during the year.

24. List of entries affecting revenue in Daybook

25. Top 10 High value transactions.

26. Cash Transactions passed through Journals

27. Sales / Purchases passed through Journals

28. List of additions to Fixed assets

29. Payments Register

30. Receipts Register

31. List of Transactions involving GST Payment

32. List of Transactions involving GST Ledgers

[ramajayam]

Code: Select all

SELECT $Name, $_PRimaryGroup,  $$ascramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Sundry Debtors" AND NOT $$IsDr:$ClosingBalance

[Balabaskumar]

Code: Select all

SELECT $Name, $_PRimaryGroup,  $$ascramt:$ClosingBalance FROM Ledger WHERE $_PrimaryGroup = "Loans (Liability)" AND NOT $$IsDr:$ClosingBalance

[Balabaskumar]

Code: Select all

Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry Debtors' And $Closingbalance > 100000

[Ilayaraja]

SELECT $Name, $_primaryGroup,$GSTRegistrationType FROM Ledger WHERE ($_primaryGroup LIKE 'Sundry Debtors' OR $_primaryGroup LIKE 'Sundry Creditors') AND $GSTRegistrationType = Regular

[Dhana]

Code: Select all

SELECT $Name, $LedgerName, $OpeningBalance, $_closingBalance  FROM Ledger WHERE $OpeningBalance = $_closingBalance

[Balabaskumar]

Code: Select all

Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry Creditors' And $Closingbalance > 100000

[Sahil Davey]

Code: Select all

SELECT $Key, $MasterId, $AlterID, $VoucherNumber, $Date, $VoucherTypeName, $Led_Lineno, $Type, $LedgerName, $Amount, $Led_Parent, $Led_Group, $Party_LedName, $Vch_GSTIN, $Led_GSTIN, $Party_GST_Type, $GST_Classification, $Narration, $EnteredBy, $LastEventinVoucher, $UpdatedDate, $UpdatedTime, $Nature_Led, $Led_MID, $CompanyName, $Year_from, $Year_to, $Company_number, $Path FROM A__DayBook Where $VoucherTypeName is like 'Journal' And ($LedgerName is like 'Purchase' Or  $LedgerName is like 'Sales')

[mahendat kumar]

Select $Name, $Parent, $Closingbalance from Ledger where $_PrimaryGroup = 'Sundry creditors' And $Closingbalance > 100000

[CD Akshaya]

Select $Name, $Parent, $_PrimaryGroup, $CreatedDate from ledger where $CreatedDate >=$$Date: '01-04-2020'