Small business in excel 2007
angi13
Registered Posts: 24 New contributor 🐸
Hi,
I really need some help to start up a small busines in excel 2007. I am trying to set up a Cash Book designed to handle all the bookkeeping needs for small business in Excel 2007.The Cash Book to include if possible the items below:
Income and expense items
Sales and purchase ledgers
Unlimited accounts added or inserted with a click of the button
Bank reconciliations
Balance sheet
Profit & Loss and Cash Flow
Aged Customer and Supplier Summary Reports if posible
Trial Balance with Monthly Movement and YTD Balance
Accrual prepayments
VAT Return summary
Can anyone please help?
Thank you very much:)
angi13
I really need some help to start up a small busines in excel 2007. I am trying to set up a Cash Book designed to handle all the bookkeeping needs for small business in Excel 2007.The Cash Book to include if possible the items below:
Income and expense items
Sales and purchase ledgers
Unlimited accounts added or inserted with a click of the button
Bank reconciliations
Balance sheet
Profit & Loss and Cash Flow
Aged Customer and Supplier Summary Reports if posible
Trial Balance with Monthly Movement and YTD Balance
Accrual prepayments
VAT Return summary
Can anyone please help?
Thank you very much:)
angi13
0
Comments
-
in Excel!!!
You would need to write it in Access and use an awful lot of Macros.
Why don't you just use some of the free accounting online software and save yourself an awful lot of grief and also have the peace of mind of knowing you haven't missed anything and it will automatically run all your Year End processes for you too.
Check out the posts by Stefanboro .. he has listed quite a few. Wave being amongst them.0 -
Thank you very much for your advise0
Categories
- All Categories
- 1.2K Books to buy and sell
- 2.3K General discussion
- 12.5K For AAT students
- 319 NEW! Qualifications 2022
- 157 General Qualifications 2022 discussion
- 11 AAT Level 2 Certificate in Accounting
- 56 AAT Level 3 Diploma in Accounting
- 92 AAT Level 4 Diploma in Professional Accounting
- 8.8K For accounting professionals
- 23 coronavirus (Covid-19)
- 272 VAT
- 92 Software
- 274 Tax
- 136 Bookkeeping
- 7.2K General accounting discussion
- 201 AAT member discussion
- 3.8K For everyone
- 38 AAT news and announcements
- 345 Feedback for AAT
- 2.8K Chat and off-topic discussion
- 582 Job postings
- 16 Who can benefit from AAT?
- 36 Where can AAT take me?
- 42 Getting started with AAT
- 26 Finding an AAT training provider
- 48 Distance learning and other ways to study AAT
- 25 Apprenticeships
- 66 AAT membership