Payslip Transaction question

IImayneII

unread,

Dec 31, 2019, 8:18:24 AM12/31/19

to Beancount

Hello. I'm just started using fava/beancount but have a question regarding how to set up a payroll.

I want to track all lines on the payslip since some will be shown on a tax filing, that way I can easily check if they are correct. The issue I currently have, is with the way the payslip is set up. The net income result is not just [gross income - taxes]. It's actually [gross income - taxes + bonusses]. So the bonusses are technically part of the net income, but I would like to track them separately, but I do not see an easy way of doing this.

This is what I was doing for the transaction

2020-01-01 * "Advance Payment Salary"
Asset:Account:Checking 1500 EUR
date: 2020-01-01
source_desc: " "
Income:Employer:Salary:Performance -1500 EUR

2020-01-20 * "Salary Deposit"
Asset:Account:Checking 380 EUR
date: 2020-01-20
source_desc: " "
Expenses:Taxes:BY2020:RSZ 300.00 EUR
Income:Employer:Salary:Bonus -40.00 EUR
Expenses:Taxes:BY2020:Pretax 400.00 EUR
Income:Employer:Salary:Deduct -10.00 EUR
Income:Employer:Salary:Car -120.00 EUR
Income:Employer:Salary:CostsForfait -180.00 EUR
Expenses:Taxes:BY2020:RSZ:Extra 20.00 EUR
Equity:Employer:DinnerCheque:Contribution 30.00 EUR
Income:Employer:Salary:Car 120.00 EUR
Income:Employer:Salary:Performance -900.00 EUR

Actual Payslip:

Performance                                    2400.00 EUR
------------------------------------------------------------  
Total Gross salary                             2400.00 EUR
Taxes RSZ                 	               -300.00 EUR
Bonus	                                         40.00 EUR
------------------------------------------------------------
Taxable                                           2140 EUR
Pretax                            	       -400.00 EUR
Deduct                           		 10.00 EUR
Car		                                120.00 EUR
Costs Forfait                                   180.00 EUR
Taxes Extra                                     -20.00 EUR
DinnerCheque                                    -30.00 EUR
Car			                       -120.00 EUR
------------------------------------------------------------
Net salary                                        1880 EUR

Basically the calculation is more like this

2400 (gross income)
-870 (all taxes)
--------------------------------------
total 1530
+350 (all "bonus/forfait/etc")
--------------------------------------
total 1880 (net income)

The problem is how I can put this in a zero-sum transaction without affecting the gross income since I can't just do this (since it's not a zero sum transaction):

2020-01-20 * "Salary Deposit"
Asset:Account:Checking 1880 EUR
Expenses:Taxes 870.00 EUR
Income:Employer:Salary -2400.00 EUR

And since the combination of net income and taxes is higher than the gross total (net income + taxes). That's where the bonus parts come in. But when I account for the bonus parts, my gross income is also more than the actual 2400

2020-01-20 * "Salary Deposit"
Asset:Account:Checking 1880 EUR
Expenses:Taxes 870.00 EUR
Income:Employer:Salary -2400.00 EUR
Income:Employer:Salary:BonusSpecific -350.00 EUR

Is there a way to avoid this? Or a preferred way to handle something like this?

Oon-Ee Ng

unread,

Dec 31, 2019, 10:10:59 AM12/31/19

to bean...@googlegroups.com

Why not just:-

2020-01-20 * "Salary Deposit"
Asset:Account:Checking 1880 EUR
Expenses:Taxes 870.00 EUR

Income:Employer:Salary:Gross -2400.00 EUR

Income:Employer:Salary:BonusSpecific -350.00 EUR

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/3654e2f3-4d56-4d86-bf4e-70dcf5c09487%40googlegroups.com.

Message has been deleted

IImayneII

unread,

Dec 31, 2019, 1:39:39 PM12/31/19

to Beancount

You are probably right I should do something like this. The only issue I had with this approach is that with this, in the income statement tab of fava and in general, the "Income" account and "Income:Employer:Salary" would reflect a bigger income since I would count the Gross and Bonusspecific, when bonusspecific is actually part of gross salary.

But I guess I could just leave out the "Income:Employer:Salary:Bonusspecific" account when creating a report. And for calculating net profit it wouldn't matter I guess.

Op dinsdag 31 december 2019 16:10:59 UTC+1 schreef Oon-Ee Ng:

Reply all

Reply to author

Forward