Wednesday, June 3, 2020

Develop Advance Excel Applications











About:

All the three categories are developed in Microsoft Excel

VBA is used for reports

Its only for CASH BASED BUSINESSES not for double entry system

Can be used by small shops, home base cash record of income and expenses and other very small business operating only in cash

Simple procedure one has to make entry in the transaction table like date, details of the entry finally cash received or cash paid. Rest will be calculated by the excel and for profit and loss report only enter the designed period dates the profit and loss report will be displayed with head-wise balance summary.

Further a tab has also been included for cash count i.e. cash counted for start of the day and cash at closing of the day, Form this the client will be in a position of reconciling the cash and the balance shown in transaction table, if any difference arises, that may be tracked.    



Reviews


: : : : :


No comments:

Post a Comment