Germany uses the Euro as currency, and typically you will find that prices in Berlin are similar to those in major cities in the UK. You should be aware that many restaurants and shops in Germany do not accept credit cards, and always check that you have the means to pay before sitting down. Tipping is not compulsory, although for good service it is expected and 10-15% will suffice. Many restaurants already include a service charge on meals, meaning that you do not need to leave any additional money.
Goods on display in shops already include sales taxes such as VAT, so the price that you see on the ticket is the price that you will pay at the checkout. Typically prices in Germany are slightly lower than in the UK, although in Berlin they are higher than the country as a whole. You should expect to pay about the same for a night out as you would in Manchester or London.