Budget book revenue surplus with success groups in Excel VBA

This program is an Excel file programmed in Excel VBA. The Excel file has 2 worksheets: "Mask", "Table View".

The program has space for 2730 revenue offices and 2730 cost centers. You can combine them in different success groups. Program has space for 300 groups.

The headline "Budget book revenue surplus with success groups in Excel VBA" and picture are link to YouTube movie where example business cases will show how the program works.

Below is the description of the example business cases.

For success group Article1 two cost accounts Purchase Price A1, Reference Costs A1 and one income account Sales Price A1 are created

For success group Article 2 is created: cost accounts Purchase Price A2, Reference Costs A2 and revenue account Selling Price A2.

For success group Sales Tax is created two cost accounts Pre-Tax, Tax office and revenue account VAT.

For success group Private Money is created: cost account Private Withdrawal and revenue account Private Investment.

Financial year starts with Private Placement - 1000 €

Further in the example, accounting records are created for these accounts and groups.

Booking rates for January: Purchase Price A1 - 100 €, Pre-Tax- 19 €, Purchase Costs A1 - 50 €, Pre-Tax- 9,50 €, Purchase Price A2 - 200 €, Pre-Tax- 38 €, Purchase Costs A2 - 100 €, Pre-Tax- 19 €, Sales Price A1 - 300 €, VAT - 57 €, Sales Price A2 - 600 €, VAT - 114 €. Finally comes Tax Office - 85,50 €.

Private Withdrawal - 200 €

Booking rates for December: Purchase Price A1 - 200 €, Pre-Tax- 38 €, Purchase Costs A1 - 100 €, Pre-Tax- 19 €, Purchase Price A2 - 300 €, Pre-Tax- 57 €, Purchase Costs A2 - 150 €, Pre-Tax- 28.50 €, Sales Price A1 - 600 €, VAT - 114 €, Selling Price A2 - 900 €, VAT - 171 €. Finally, Tax Office - 142.5.

Private Withdrawal - 1300 €.

The program creates table views from all accounts, groups, from the Journal, which can be printed easily.

Are two more accounts created: cost account Opening Balance and revenue account Opening Balance.

When the calendar year is over, with the button "Change year" all posting records are deleted, the password is the number 3, and with the first posting record the closing balance from the previous year is recorded as the Opening Balance. In this example initial inventory was Opening Balance - 700 €.

The width of all columns in the list box is automatically adjusted and all values are displayed in full.