We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Business Database
natc
Posts: 593 Forumite
in Techie Stuff
I dont know if ive put this in the right place, apologies first if I havent....
I think ive made a thread somewhere before about this but was a long time ago and the needs have changed!
We just need a simple system. We have been using excel for everything, to record the staffs hours and the places they have worked etc which shows them a monthly breakdown. Then we have to invoice each customer, then we make a wage sheet on excel for each staff member so that we can pay them through the bank.
I just find that doing it all this way is time consuming and sometimes, user error may occur and the information is not accurate. I feel a system that you can make records for each staff member, and then records for the customers would make this easier. Im not sure what Sage would be like for this, but heard its expensive and prob not the best system for us to use. We dont need an accounting system, just a system where you can input the details once, instead of 3 times! Then to be able to print some kind of report showing the staff wage totals for the month/week, and then to generate an invoice......hope this makes sense....
I think ive made a thread somewhere before about this but was a long time ago and the needs have changed!
We just need a simple system. We have been using excel for everything, to record the staffs hours and the places they have worked etc which shows them a monthly breakdown. Then we have to invoice each customer, then we make a wage sheet on excel for each staff member so that we can pay them through the bank.
I just find that doing it all this way is time consuming and sometimes, user error may occur and the information is not accurate. I feel a system that you can make records for each staff member, and then records for the customers would make this easier. Im not sure what Sage would be like for this, but heard its expensive and prob not the best system for us to use. We dont need an accounting system, just a system where you can input the details once, instead of 3 times! Then to be able to print some kind of report showing the staff wage totals for the month/week, and then to generate an invoice......hope this makes sense....
0
Comments
-
Excel is one choice; what about Microsoft Access?
0 -
Use an Access database?0
-
We have been using excel, but is very tedious and and we have to make about 3 or 4 spreadsheets, if one mistake made or deleted by accident, can mess everything up....Never used Access, but opened it, looks ajust like excel? That right?0
-
Can reports be generated from the info you put in and invoices generated?0
-
:huh: Excel is a spreadsheet with database capabilities; Access is a fully-fledged database giving you control of textual and numerical data. You really need to decide what your information is more suited to, application wise I meanWe have been using excel, but is very tedious and and we have to make about 3 or 4 spreadsheets, if one mistake made or deleted by accident, can mess everything up....Never used Access, but opened it, looks ajust like excel? That right? And yes, Forms and Reports can be generated as a means to an Invoice.
HTH.0 -
Mmmm intriguing! Thanks. Never used Access, is it easy enough to plod through?0
-
Er, I certainly would not call it easy. Implementations in each upgrade version certainly have made it more intuitive to use (vis-a-vis Excel) and there are some very useful in-built Wizards that might aid you. I'm sure if you do a Google search, there should be plenty enough info guides to steer you in the correct directionMmmm intriguing! Thanks. Never used Access, is it easy enough to plod through? 0 -
Mmmm think ill just buy some kind of software, dont want more stress of having to create a database, wouldnt know where to start! lol0
-
Thanks very much for your help though. I shall have a browse on the net and see whats what, someone has suggested that SAGE is actually the way to go....0
This discussion has been closed.
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.5K Work, Benefits & Business
- 602.8K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards