Revenue-surplus Bill or budget book based on an Excel 2010 file

This program is an Excel 2010 file programmed in VBA.

 

The program features 2339 ingestion places and 2339 cost centers. The user can each time the labels newly awarded places or change.

 

This program creates detailed analysis about stocks on all places in time intervals of a month or a year.

 

If calendar year end, the calendar for the new year just with a simple touch of a button is created.

 

To use the program, you need no prior knowledge. Simply enter the expenses to cost centers and enter the revenue to revenue authorities.

 

This program can you use in various areas of the private household, for example, create a detailed overview of the current account.

Some examples in pictures

 

 

 

 

1 In the sheet "Input mask" the job titles are available (2 X 2339) and button, which activates the input mask.

 

 

2 Entry in the revenue office.

 

 

3 Entry in the cost center.

 

 

 

4 Evaluating success.