Hi, I am looking for someone to create a fairly simple excel spreadsheet for my small business.
I run a bi-monthly community magazine where the advertisers sign up for either a 1 issue run, 3 issue run or a 6 issue run, I need to:
1). keep up with who's ad will run in each issue from a list of about 100 advertisers (all who run at different times)
2). have a way of knowing who's paid and who hasn't for each individual issue (and also for those who pay several issues in advance)
3). be able to input my expenses, printing, mailing cost etc...and it total those letting me know how much is left over
4). estimate how much I need to put back for taxes (20% I believe)
5). and be able to see at a glance my total sales per issue
Hope this makes sense.
Also, if it matters - I will use this spreadsheet on both a mac computer and a PC (Mac at home, PC laptop when out but will need to make changes to the file while out and then update the mac file when I return by saving over the previous file.
PLEASE REPLY WITH A BRIEF EXPLAINATION OF HOW YOU'D CREATE THIS SPREADSHEET SO I'LL KNOW WE'RE UNDERSTANDING EACH OTHER AND ALSO PLEASE DO SUGGEST ADDITIONS THAT YOU THINK MIGHT BE USEFUL AS WELL. THANK YOU.