We need an excel macro or VBA code which automatically puts bank statement page columns into columns automatically based on what is in the detail column. For example if the client is VAT Registered the vat amount is automatically calculated and the net figure goes into the appropriate column.
For example
Date / Detail / Amount VAT Registered - Yes / No If VAT Registered net figure it put into a VAT column (20%) If not VAT Registered Gross figure is put into the appropriate column - ie Telephone column is BT / EE / Vodafone / Three etc
We will need a way to have a library page or another way to do it, that we can enter typical names of companies that will go into each column.
Apartment Conversion for Increased Rental Income Category: AutoCAD, Building Architecture, Building Regulations, Construction, Construction Management, Home Design, Interior Design, Project Management Budget: $750 - $1500 USD
4K Creative Promo Video Edit Category: After Effects, Animation, Color Grading, DaVinci Resolve, Final Cut Pro, Video Editing, Video Services Budget: $30 - $250 USD
