Create Access Database for a Book Publisher
$250-750 USD
Pagado a la entrega
I run a small book publishing company, but managing everything off a spreadsheet has become unwieldy. I tried learning Access 2010, but I quickly got bogged down and confused. So now I'm stuck running things off a spreadsheet and a database. It takes a week every time I have to figure quarterly taxes or royalties. I need help.
The database you create must:
• Split out payments for orders and purchase orders to apply the correct amount of profit to each book ordered
• Track sales of each title by number of units sold
• Track sales of each title by profit
• Track expenses for each order
• Track progress of a title toward breakeven vis-à-vis development costs
• Track each title’s development costs
• Track each title’s publishing information
• Track royalties already paid
• Track and figure royalties owed (by title, by author, by quarter, and by year)
• Track purchase orders coming in
• Track purchase orders fulfillment costs
• Track purchase orders payments received
• Track purchase orders profits (total and by book and author)
• Track expenses across all categories
• Track payments and income from all channels
• Give me taxes owed at the click of a button (for quarter and year and sales tax)
• Track customers, including total purchase history
• Generate custom e-mail lists/reports from customers
• Separate when sales happened from when those sales were paid for
• List and track authors
• Track author sales expenses
• Track author sales income (and be sure those profits don’t figure into royalties)
• Track PayPal fees
• Generate invoices that can be sent to bookstore and library customers
• Import reports from Paypal
• Import reports from Snowfall Press (printer)
• Import reports from LightningSource (printer)
• Import reports from Kindle/Amazon
• Import reports from Sony/Nook
• Import reports from Kobo
• Connect payments for Amazon/LSI with breakdown of Amazon/LSI sales from months earlier
• Generate taxes owed at the press of a button
• Generate royalties owed at the press of a button
Nº del proyecto: #2382451
Sobre el proyecto
20 freelancers están ofertando un promedio de $590 por este trabajo
Dear SIR, We Are An Expert Team Of Developers, In This Type Of Program In Real life, We Can Do This Job Perfect For You.
Hi, I have experience with this project I am very happy to work with you in this project Best regards winnet21
Hello. We are a German Company with a team of 3 dedicated VBA developers and we've done the similar projects. Please check your PMB.
Hi, .NET developer with 7+ years of experience is ready to help you. Please, check PMB for more details. Thanks.
What you need is a database plus user interface in Access. I have database design, administaration experience, and Access development experience.I had built a complete system for a foreign currecy trading company from Más
Sir, I have expertise in Database application development and implementation,for more detail,plz check pmb. Thanks
I totally understand your projects and I have recently made similar software (vb + access) which was capable of stick handling, producing reports, recording transactiins, cash balances, keeping record of debtors and cr Más
We are new software development group. Our priority of development is database oriented. We have an interesting offer for you. Check your PM for more details
I am exprienced in Ms Access for 10 years. I will do the job as soon as possible. Please give me a chance.