I require simple voucher based accounting software in Excel with trading, P&L, balance sheet, with reports on both the screen and printer. Is there any?
There is a pack with the scripts for Excel called Mango's Accounting. There are documents, tutorials, instructions, and download available for you to get started. The scripts do what you've just asked. You can download it from the official website: http://www.mango.org.uk/guide/mangoaccountingpack
Before starting, I would pick the PDF guide to see exactly what the software has to offer and how should you start with it.