Financial Accounting

1 Automation & reducing the paper work 2 Monitoring on accounts , sales , purchases & deposits, Banks 3 Job card for projects & Services 4 Detail of quotations & tenders submitted as estimated Vs Actual cost 5 Details of Company 6 Inventory control 1 Automation: Various routine papers required to be submitted as refund of EMD , Application of Tender, Reminders etc. tender cover page, Envelope , introduction letters etc. Where the variable is Company , Party to which letters are addressed , Subject & reference nos. of Documents & several documents as asked in tender. 2 Monitoring of accounts: A. Sales Bill: Preparation of sales Bill & monitoring of Payment received any deductions in the bill, reminder for non-payment etc. Entry of payment in Bank book & Cash Book and or/job card etc. Sales register shall be able to give the Reports as per Party wise, Bill no Wise , date wise, Subject wise, Work order wise, Payment received-not received statement, Date of bill wise & date of payment wise, TDS wise, WCT wise, Penalty wise, Bill amount wise, Deposit wise etc. Also the report to be generated in MS Excel sheets B. Purchase register : Preparation of Purchase register & monitoring of Payment made, advances if any deductions in the bill, Entry of payment in Bankbook & Cash-Book &/or job card etc The software shall be able to give the report in MS excel sheet & Reports as per Party wise, Bill no Wise , date wise, Subject wise, Work order wise, Payment made -not not made statement, Date of bill wise & date of payment wise, TDS wise, WCT wise, Bill amount wise, Deposit wise etc. C. Bank Book: Bank book shall be maintained with description in three stages with cross reference of each entry in sale, purchase , expense, job card, cash book, expense , etc. The reports to be generated are , party wise , Bank wise , bank account wise, Bank heading & description wise, Date wise, cheque no wise , Also the report to be generated in MS Excel sheets Also Needs the break up & total for amount paid or received for cumulative vouchers, sale bills , EMDs, The entry in the bank book will also be reflected in sale or purchase or emd or legal charges or expense and /or job card D. Cash Book: Cash book shall be maintained with description in three stages with cross reference of each entry in sale, purchase , expense, job card, bank book, expense job card etc. The reports to be generated are , party wise , Date wise. Also the report to be generated in MS Excel sheets Also the break up with description & comments shall be displayed in the cash book. E. Expense register: Expense registered to be maintained at for tracking the office expenses with Details of Expenses amount , purpose & description in three stages & Persons etc. also the cross reference entry of the expense in cash book & bank book & / or Job card etc. Reports to be generated are Person wise, Description wise, date wise, Voucher no wise. Also the report to be generated in MS Excel sheets There are some indirect office expenses & few direct expenses. The Direct expenses are reflected in Job card. F. There shall be provision by which the bills & accounts may be settled with sister concern company for which purchase & sales accounts, bank, emd, security deposits job card cash book needs to be settled G. Job Card: Job card needs to be prepared specially for the job of project & hire services as the work is of long duration where the Job card are prepared work order wise & entry in the job card will be in cross reference with bank book, cash book expense voucher sale & purchase etc the description is made in two stages. Report to be generated are expense wise , work order wise, Person wise (expense) date wise. Also the report to be generated in MS Excel sheets H. EMD : One of the major concern is Earnest money deposits where the entry is made for various sister concern company & clients for various subjects. The entry to be made are tender no: subject, date of EMD, amount of EMD, Form of EMD as Cash, Cheque, DD, PO, Bank Guarantee, Report to be generated are Party wise, company wise , Date wise, EMD no wise , accounts unit wise, EMD received / not received, Due for payment / not due , inter company accounts settlement for amount received in parent company. Also the report to be generated in MS Excel sheets I. Security Deposits & other deposits : Amount is kept as deposits for various reasons as contract deposits, security deposits , deposit for registration etc. The entry to be made are tender no: subject, date of Deposit, amount of Deposit Form of Deposit as Cash, Cheque, DD, PO, Bank Guarantee, Report to be generated are Party wise, company wise , Date wise, Receipt no wise , accounts unit wise, amount received / not received, Due for payment / not due , inter company accounts settlement for amount received in parent company. Also the report to be generated in MS Excel sheets J. Tender : We participate in various tenders & as such the list of tender & Company participating the tender & other details like , Tender No, Tender subject, Tender Cost , tender EMD amount , Party, Company, Type of Tender ( Two part , Single part ) Tender Due date for Part 1 & due date for part 2. Estimated cost by Department , location of tender estimated excell sheet. EMD Paid or exempted. Participated ( yes / no) The comparative results of various participants. Validity of tender, etc. The reports to be generated are List of Tender, Tender participated by particular company tender for a particular party, Date wise, EMD amount wise, subject wise. Due date wise. K. List Of Party: Party is the client where various works are going on where various tenders are invited & various work orders are placed. Party contains Name of Party, Address, Ph no , Concern person , Fax no etc. Report to be generated is list of party. L. Purchase / Work order received: Work is started after getting the work order. The details to be stored is as follows. Work order no, Subject, Work order Amount , Contract period, Company , Party, Date of work order, tender ref no, Bill no: M. Purchase / Work order issued : The details to be stored is as follows. Work order no, Subject, Work order Amount , Contract period, Company , Party, Date of work order, offer ref no, Bill no: Advance paid if any. Contact no & contact person. Terms of payment. N. Legal & stationary chargers: For several jobs where contract to be executed, legal & stationery charges are required to be paid. The details of which are party company, amount. Tender no , work order no , work description , Receipt no , Form of payment as Cash/DD/ PO. O. List of Company: There is a group of sister concern company where several work are undertaken independently & several works are done jointly. The details of Each company required are , Name of company, Proprietary /partner ship/ Public ltd , Adress, Phone no., Fax No, Concern person, Bank Account no, Branch, ECS & MICR nos. Mob No etc. P. List of Files: several files are made in the office to keep various papers the list contains file no description name of company , type of files Q. Phone Book: Address book will store the details of name , Phone no ( Residential & Office) ,Mob No , Address of contact etc. R. Standard Items: The file shall contain Some of the Standard items generally required for Estimate with Technical details like , Capacity, Weight per Meter, Density, size etc. The details shall be able to be category . Viz. Electrical, Mechanical, General etc. With sub category. Date of rate also shall be able to be put in the same. R. Inventory control Check In/Out manages material and equipment check-in and checkout transactions, as well as consumable and non-consumable stock. Applications include, check in and check out materials and equipment, manage consumable stock, take physical inventories. Applications: tracking of documents, property and equipment; management of maintenance parts, stockrooms, and central stores. All the results of Reports shall be available on printer as well as on screen with proper heading of date of reports & Report for criteria also it shall indicated from Date---- to Date with all sub total & grand total. Also it shall indicate the page x of  at bootm. Also there shall be facility to take the back up & restore of data at Any hard drive or any network machine or floppy or CD The program shall have security in following level. 1 First entry level is accessible to the entire authorized person doing routine entry. 2 Few of reports can viewed by only important persons. Also some important estimates, offers & others shall be accessible to only important persons 3 few of entry shall be only accessible to be viewed by important persons. all the source code should be provide in VB6 and SQL. Trial to be given for a week after completion of software. With one year free service. We will also like to see the demo of any similr work done by you