Skip to main content

TheAccountSolutions

PROVIDING ACCOUNTING SOLUTIONS FOR ACCOUNTANTS AND BUSINESS OWNERS

Search This Blog

Home
ABOUT
CONTACT US
FREE TEMPLATES
CUSTOMIZED TEMPLATES
SUPPORT
ATAs

Showing posts from December, 2020

Posts

How to Track Expiry Date of items on Excel (Automated with VBA)

December 01, 2020

EXCEL TEMPLATES

+

Get link
Facebook
Twitter
Pinterest
Email
Other Apps

Translate

TheAccountSolutions Video Tutorials

SOLUTIONS TO ACCOUNTING CHALLENGES

SERVICES

Accounting2 BOOK KEEPING10 BUDGETING1 Business Diary2 BUSINESS MANAGEMENT1 Do You Know6 EXCEL TEMPLATES13 External Audit1 Forensic1 TAXATION4

RESOURCES

2024 1
- January 2024 1

2023 8
2022 4
- December 2022 2
- November 2022 2
2021 18
2020 5
2018 2
- May 2018 1
- April 2018 1
2017 15
2016 8
- December 2016 7
- November 2016 1

Show more Show less

Reach Us

Name

Email *

Message *

Report Abuse

MOST READ

HOW TO TRACK EXPIRY DATES WITH EXCEL

I remembered an occasion when we were supposed to see a program on TV on a particular day but lo and behold our Cable subscription expired without our knowledge. We simply did not keep track of when we renewed the last subscription. And so we had to miss out on that program. Now, the above experience could happen to anyone on any occasion. It could be any of the following situations; 1. Renewal of a Membership Subscription 2. Renewal of Motor Vehicle Papers 3. Renewal of Business & Operational Licenses 4. Renewal of Cable Subscription 5. Renewal of Rates, Rents & Utilities 6. And any other stuff that expires within a given period of time In all these, it means that you have a DATE that the item was RENEWED and a DATE in which the last RENEWAL will EXPIRE. There are many ways to keep track of items that WILL SOON EXPIRE and the most common ones are CALENDARS and ALARMS REMINDERS. If you are a regular EXCEL USER, t

HOW TO MANAGE PURCHASES, SALES & STOCK/INVENTORY WITH EXCEL

How do you keep records of your daily sales? In a notebook? Notepad? Excel? How long does it take you to prepare a sales and purchases report? are they done daily, weekly or monthly? Do you run a one man retail or wholesale business and you want to track your daily Purchases, Sales and Stock balance? Are you a Sales Person and you receive Sales report on Excel from various sales point? With the use of Specially Designed Excel Template you can quickly put a whole lot of reports together. We have put together a little Template on Excel with a whole lot of features to enable you record your daily transactions (Purchases & Sales) and view your daily current Stock level. This Template was designed to meet up with the recent demands from our subscribers who have used our STOCK-INVENTORY MANAGEMENT TEMPLATE 1 . The Stock-Inventory Template was designed to manage your stock balances on a daily basis. So, we thank our Subscribers for the encouragement and feedback. Here is an Excel Temp

Powered by Blogger