Budget book in Calc - LibreOffice 6-4

From The Document Foundation Wiki
Jump to: navigation, search

Template:TopMenu/en Template:Menu/en

Other languages:
dansk • ‎Deutsch • ‎English

In work!

Foreword

"Housekeeping book EN"
"Regular costs EN"

This description refers to version LibreOffice 6.4. The video "Calc Housekeeping Book" links to this page here, which contains further information and details. This video shows how a simple Housekeeping book can be designed in Calc.

Link to the video

Link to the Video in DE-German: Housekeeping book Video in work!

Calc create Housekeeping book

Open work file

Open Calc and the existing work file "Housekeeping book - Haushaltsbuch - in Calc".
The Housekeeping book is initially created for one year and contains monthly, half-yearly and yearly expenditure.

Labelling the months

lower right corner

Complete the labels for the months. To do this, click on the cell "C1"="January" and drag the lower right corner to the right until column "N".

Create total earnings January

Now click in cell "C6", here the sum of the earning for January is to be calculated. Click on the small arrow down next to the totals symbol in the formula bar and click on the "Sum" symbol and press Return.

Create total earnings February to December

Click again in cell "C6" and you will see the calculation at the top of the input line. We drag right at the bottom right corner of the cell to column "N". You have now made the calculations, the totals January to December for the revenue [1].

Create total expenditures January

Now click in the cell "C17", here the sum of the expenditures for January should be calculated. In the formula bar, click on the small down arrow next to the sum icon and click on the "Sum" icon and press Return.

Create total expenditures February to December

Again, click in the cell "C17" and you will see the formula at the top of the formula bar. Drag the bottom right corner of the cell to the right until column "N". You have now created the calculations of the totals, January to December, for the expenditures [2].

Create totals for half-yearly and yearly

Click on the table tab "Regular costs EN". Listed here are the expenditures that do not occur on a monthly basis. Here you calculate the sums for half-yearly [3] and yearly [4].

Insert share half-yearly and yearly in the table ″Housekeeping book EN″

Click on the table tab "Housekeeping book EN".

In cell "C15" take the sum "half-yearly" [5] from the tab "Regular costs EN" and divide it by six.
In cell "C16" you take the sum " yearly" [6], from the tab "Regular costs EN" and divide it by twelve.

Note: The monthly split amounts, for half-yearly and yearly, should be set aside accordingly by the payment date.

Copy monthly earnings and expenditures from January to the remaining months

Copy earnings item

Select cells ″C3″ through ″C5″. Press Ctrl+C and paste the copied into rows ″C3″ to ″C5″ of the columns "D" to "N".

Copy expenditure item ″C9″ to ″C14″

Select the cells ″C9″ to ″C14″. Press Ctrl+C and paste the copy into the lines ″C9″ to ″C14″ of the columns ″D″ to ″N″.

Copy expenditure items ″C15″ and ″C16″

Copy the formula contents of the cell ″C15″ from the formula bar. Insert ″D15″ to ″N15″ in each cell.
Copy the formula contents of the cell ″C16″ from the formula bar. Insert ″D16″ to ″N16″ in each cell.

Note: The earnings and expenditure can of course be adjusted according to your own needs.

Working files

Working file: Housekeeping book - Haushaltsbuch - in Calc

Working file: Housekeeping book - Haushaltsbuch - in Calc final

References

[1] Table: "Housekeeping book EN"; Entry in "C6"="=SUM(C3:C5)"; in the columns February to December corresponding to "D" to "N".

[2] Table: "Housekeeping book EN"; Entry in "C17"="=SUM(C9:C16)"; in the columns February to December corresponding to '"D" to "N".

[3] Table: "Regular costs EN"; Entry in "E5"="=SUM(E3: E4)".

[4] Table: "Regular costs EN"; Entry in "E13"="=SUM E7: E12)".

[5] Table: "Housekeeping book EN"; Entry in "C15"="=regularly.E5/6". The entry is repeated in the columns "D" to "N".

[6] Table: "Housekeeping book EN"; Entry in "C16"="=regularly.E13/12". The entry is repeated in the columns "D" to "N".