Booking bonus

Calculating bonus

1. Obtain the bonus calculation template from 'Money' channel
2. Use steps from help tab to fill in the sheet
3. Save file as '<year>-Q<quarter>-bonus.xlsx' and export as pdf
4. Post pdf version of file in 'Money' channel

Requirements

Rules based on the following post: https://chat.dsinternal.net/#narrow/stream/25-Money/topic/.E2.9C.94.20Wage.20files.20request.20for.202024-07/near/10522

• Bonus PDF needs to be ready by the 2nd of the new quarter before 11:00, in order for it to be approved and sent to accountants on time.
• All receipts needs to filed and reconciled by the 2nd 11:00 of the new quarter in order for the bonus to be approved.
• The bonus sheet needs to be approved by the 6th, 22:00.
• Bonus needs to filed in Exact by the quarterly meeting, if it is approved.

Create bonus booking on exact

1. Exact -> Financieel -> Boeken en grootboekrekeningen -> Boekingen -> Aanmaken (English: Financial -> Entries & G/L Accounts -> Entries -> Create)
2. Click '91 - Bonus verdeling'
3. First line item
   1. Set 'Datum' to last day of the quarter you're booking the bonus for (e.g. December 31st when booking Q4 bonus)
   2. Set 'Grootboekrekening' to '4010 - Bijzondere beloning'
   3. Set 'Omschrijving' to 'Bonuskosten <year> Q<quarter>'
   4. Set 'Debet' to total bonus to be paid out as calculated in sheet (under 'Bonus costs')
4. Line item for every employee that receives a bonus (as calculated in bonus sheet)
   1. Set 'Datum' to same value as first line
   2. Set 'Grootboekrekening' to '1790 - Te betalen bonussen'
   3. Set 'Omschrijving to 'Bonuskosten <year> Q<quarter> <employee name>'
   4. Set 'Credit' to amount of bonus for that employee (as calculated in bonus sheet)
5. Line item for every owner that receives a bonus (as calculated in bonus sheet)
   1. Set 'Datum' to same value as first line
   2. Set 'Grootboekrekening' to '4010 - Bijzondere beloning'
   3. Set 'Omschrijving to 'Bonuskosten <year> Q<quarter> <owner name>'
   4. Set 'Credit' to amount of bonus for that owner (as calculated in bonus sheet)
6. If at this point there is a small difference between Debet and Credit (and all entered numbers are correct), you can create a line with Grootboekrekening '9200 - Rekenverschillen' to make up for the difference
7. Save the entry

Attach bonus calc sheet to booking in Exact

1. Exact -> Documenten -> Nieuw document (English: Exact -> Documents -> New Document)
2. Subject: 'Bonus <year>-Q<quarter>'
3. Categorie (Category): 'Crediteuren'
4. Date: Today
5. Delen (Share): Huidige administratie
6. Type: Bijlage (Attachement)
7. Boeking (Entry): The bonus booking for that quarter (The 4010 G/L account entry that's not for an owner)
8. Attach the pdf version of the bonus calc sheet