Tally – ALL in One (Part-3)
Purchase Order
o Receipt note
o Purchase bill pending
o order outstanding / pre close
E-way Bill
Import Data
Adjustment Entry
o Depreciation on Assets
o Outstanding and Advance Entries
Report Analysis
o Month – Quarter – Year wise
Export Report
o Excel format
o PDF Format
Duplicate voucher Create
Inclusive Tax Invoice (Sales / Purchase)
Group Company – Multiple firm
Close financial Year and check next financial year report opening Balance.
June-1
Purchase order to Ankur Electronics 10 PCS Exide Tubular Invertors Battery (150
AH) – Order no Ank-1 @ Rs. 10500 Each
June-1
Payment for following (Using duplicate / or as new pass entry)
Stationary Exp Tea/Coffee Expenses
Noida-Head Office 1600 3800
Payment mode for above transaction (Petty cash) and below transaction by HDFC
Bank
Prepared by – Manoj Sir
Cost Center-Class Office Rent Salary Electric Bill
Noida-Head Office 20,000 50,000 12,000
Faridabad-Branch
Office
25,000 56,000 18,000
June-2
Received order from Ankur Electronics 8 PCS Exide Tubular Invertors Battery (150
AH) – against Order no Ank-1 and Create purchase invoice 5 PCS against order
received and pre-close remaining order.
Note – Amount of Product Inclusive Tax (Round invoice, if show Decimal Amount)
June-2
Sold 5 PCS Exide Tubular Invertors Battery (150 AH) to Suresh (Customer) – E-way
Bill @ 11000 (123401234012) Inclusive tax Invoice
Uttar Pradesh by Mehta Transporter (Delhi – Register Dealer)- Vehicle No
DL1R -JP 7892
July-1
1 PCS reject of Exide Tubular Invertors Battery (150 AH) – against Receipt no Ank-
1 (Reason – out of order)
July to December – Same Amount
Payment for following (Using duplicate / or as new pass entry)
Stationary Expenses Tea/Coffee Expenses
Noida-Head Office 1500 3500
Payment mode for above transaction (Petty cash) and below transaction by HDFC Bank
Cost Center-Class Office Rent Salary Electric Bill
Noida-Head Office 20,000 50,000 10,000
Faridabad-Branch
Office
25,000 56,000 16,000
Prepared by – Manoj Sir
Work between Jan to March Pass in Project2 Firm
(Import Ledger or inventory into 2nd firm from Project1 firm)
1-January
Create new Company – Project2 and create new Bank ICICI in this firm, Transfer 1
Lacs into ICICI bank from HDFC Bank Account – Using Group Company join Project
and Project2 firm as Group Company (MY Project)
1-January
Purchase 2 PCS Exide Tubular Invertors Battery (150 AH) – From Ankur Electronics
@ Rs 11000 (inclusive Tax – Round Invoice)
1st Feb
Paid to Ankur Electronics 20000 Amount by ICICI Bank
1st March
Received Commission in ICICI Bank Account Rs 50000 (Cost Center- Noida Office)
1st March
Transferred 8000 Rs in Petty cash from ICICI Bank
31-March (Group Company Report)
Export Balance sheet in XLS or PDF format into d Drive – MYDATA folder
Export Month wise – Creditor , Debtor and Expenses Report in MYDATA
folder (Using Group-Summary with Auto column )
31-March
Adjustment at the end
Depreciation on office furniture (chair and table) 10%
Prepared by – Manoj Sir
Salary outstanding Rs 25,000
Electric bill paid in Advance Rs 12000